Creating a new lookup batch on eComSpy is easy. Check out the short overview below, with
detailed instructions to follow.
First, create your batch in Excel:
- Download an Excel template of the file format here.
- Enter the list of ASINs, UPC numbers, and/or EANs in the first column, "ASIN/UPC/EAN".
- Enter the Item Costs in the second column, "Item Cost", if you want to see projected margins calculated.
Next, save your data in a comma-delimited (CSV) file:
- Save your work as an Excel workbook one final time. We suggest creating a back-up copy and adding a date to the file name to keep a history of your work if you want to refer to prior versions or in case there is an error in processing.
- Make sure you are on the worksheet tab that contains your data.
- On the File menu, click Save As. The Save As dialog box appears.
- In the Save As Type list, choose CSV (Comma delimited) (*.csv). Browse to where you would like to save the file, rename the file, and click Save.
- You might see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets. Click Yes.
- You might see a warning that your file contains features incompatible with the selected CSV (Comma delimited) file format. Click Yes.
Then, upload your batch:
- Click “Upload New Batch” in the left navigation bar. The Upload Batch screen will appear.
- Enter a name for the batch.
- Check “First ASIN Only” if you only want one ASIN returned for each item in the batch. Leaving this box unchecked will return multiple ASINs for each UPC or EAN if they are present and increases the overall processing time.
- Choose New or Used Items using the radio buttons under the Batch Name. The default is New Items. If you want to see matches for both new and used items, upload your batch twice. Choose “New Items” once and choose “Used Items” the next time.
- Click “Browse” to select your batch file from your computer. Select your file and click “Open”.
- Click “Upload” to create a new batch. Your lookups will begin automatically, and you will be notified by email when the batch report is complete. You can also view the progress of your reports on the eComSpy Dashboard.
The import file must be saved as a comma-delimited file with a ".csv" extension.
The first row of the file must contain the column headings, with the actual import data beginning on the second row.
- The column headings must be "ASIN/UPC/EAN" and "Item Cost"
Please note that you must supply ASIN, UPC, or EAN. ASINs must contain 10 characters, UPC numbers must contain 12 characters, and EAN must contain 13 characters. Leading zeroes must be included for accurate results. Instructions for keeping leading zeros can be found here.
Item Cost is not a required field, but allows us to calculate margins for your report. If Item Cost is not included, the value will default to zero for the margin calculations.
A template of the Excel document can be downloaded here.