Skip to main content
All CollectionsLearn about our FeaturesUPC Scanner Tool Explained
How to upload a supplier spreadsheet to the UPC Scanner?
How to upload a supplier spreadsheet to the UPC Scanner?

Follow this guide to quickly learn how to upload and configure a bulk scan.

Updated over a week ago

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

  1. Find the place where it says to "Upload File"

  2. 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:

  1. The scanner will use your file name as the scan name. If you want to change it, just type a new name.

  2. If your spreadsheet doesn't have a header row at the top, turn off the 'Has Header Row' switch.

  3. 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

  1. Choose what kind of product code you're using: UPC, ASIN, or WPID.

  2. Make sure the 'Product ID Type' is matched to the right column in your spreadsheet.

  3. Match the 'Product Cost' to the column that shows how much each item costs you.

  4. 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

  1. Click the 'Scan File' button to start.

  2. Watch the progress bar to see how it's going.

  3. Keep an eye out for any error messages.

Image or attachment is not accessible.

Did this answer your question?