There are two ways to use Listing Loader.
This option requires a Windows operating system with Microsoft Excel 2002, 2003, or 2007.
Step 1 | Enter listing information
Enter listing details for your products, using one of these options:
When macros are enabled, the Listing Loader menu is available in Excel. See Use Template Macros. |
Step 2 | Perform product lookup (optional)
Product Lookup and Bulk Lookup features require authorization through Amazon Marketplace Web Service (Amazon MWS). Learn more. If you are using a version of the Listing Loader template that is older than 2.0, and Bulk Lookup and Product Lookup do not pull any product information into the template, download the latest version of Listing Loader. If you aren't sure which version you have, check the top of column B on the Template tab. Product Lookup and Bulk Lookup check the Amazon catalog for the products you are trying to list, and then fill in the Title and ASIN-hint fields for existing products. You can use the Title field to verify that your product matches with the correct Amazon product. Look up products using one of these options:
|
Step 3 | Review product lookup results (optional)
If a product does not exist in the Amazon catalog, or has multiple matches, your listing information for that product will be put in one of these two tabs:
Follow the instructions in the tabs if any of your listings appear there. |
Step 4 | Validate listings (optional)
Click Validate on the Listing Loader menu to validate your data. This checks your listing data for completeness and can reduce upload failures caused by input errors. |
Step 5 | Upload Listings to Amazon
Upload your listings to Amazon using one of these options:
|
After you finish populating the Listings-Template sheet in the Listing Loader template with your listings data, you are ready to create the inventory file that you will upload to Amazon using Seller Central.
Step 1 | Save your work as an Excel workbook. 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. |
Step 2 | 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. |
Step 3 | In the Save As Type list, select Text (Tab-delimited) (*.txt). Browse to where you would like to save the file, rename the file, and click Save. |
Step 4 | You might see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets. Click Yes. |
Step 5 | You might see a warning that your file contains features incompatible with the selected text (tab delimited) file format. Click Yes. |
You are now ready to upload your inventory file. For more information, see Upload My Inventory File.