Want to check supplier sheets quickly to be able to see what's profitable and what's not? The Product Scanner can help. Here's how to use it:
Uploading Your File
Find the place where it says to "Upload File"
Drag your supplier spreadsheet there, or click to find the file on your computer.
Image or attachment is not accessible.
Setting Up Your Scan
Next, set up your scan:
The scanner will use your file name as the scan name. If you want to change it, just type a new name.
If your spreadsheet doesn't have a header row at the top, turn off the 'Has Header Row' switch.
If the header is not in the first row, you can pick which row it's in.
π Tip: ALQEN automatically selects the header row in the first row
Image or attachment is not accessible.
Telling ALQEN What's in Your Spreadsheet
Choose what kind of product code you're using: UPC, ASIN, or WPID.
Make sure the 'Product ID Type' is matched to the right column in your spreadsheet.
Match the 'Product Cost' to the column that shows how much each item costs you.
If you have selling prices in your spreadsheet, match the 'Selling Price' to that column. If you skip this, the scanner will use Amazon's or Walmart's current price.
Image or attachment is not accessible.
Starting the Scan
Click the 'Scan File' button to start.
Watch the progress bar to see how it's going.
Keep an eye out for any error messages.
Image or attachment is not accessible.