Other Help Areas
Inventory Loader Instructions
The Inventory Loader allows sellers to upload thousands of listings in a single file for matching against existing product pages at Amazon.com. (It is not for creating new product pages.) You can use the Inventory Loader to keep your listings up-to-date by modifying existing items, adding new stock, and deleting or "zeroing" stock quantities for unavailable items. You can even purge and replace all listings with a single upload.
To use the page-matching features of the Inventory Loader, sellers must provide a product identifier and specific information about their offering. Sellers can use a SKU and selected listing data when modifying existing listings.
Because Inventory Loader files are not used for creating new product pages, sellers do not have to provide detailed product data as they would when using a category-specific inventory file. Also, a single Inventory Loader file can be used to upload or modify listings in multiple product categories at the same time.
The Inventory Loader File Template
To create an Inventory Loader file, you must first download the Inventory Loader File template to your hard drive. The template will open as a Microsoft Excel file and contains a pre-formatted worksheet where you will provide your product data. The file includes additional worksheets to help you complete the template. You can also enable optional file macros to automate some of the steps for creating and uploading your file.
There are four basic steps to using the Inventory Loader File template:
Note: If you don't have macros enabled, save the file in text (.txt) format and upload it through the Upload Products & Inventory tool.
Inventory Loader File Tabs
When you open the template, you will see several tabs across the bottom of the workbook:
Inventory Loader File Macros
On the Add-Ins menu in the toolbar at the top of the template, you will find four macros: Validate, Upload File, Import File, and Update Template. With these macros, you can validate your data and learn how to correct any errors, as well as automate some of the tasks in populating and uploading your file. These macros are designed to simplify your experience and are highly recommended.
Note: All column headings must appear exactly as shown, in lower-case letters and with no spaces or quotation marks. Make sure that dashes appear in any multi-word column heading names. We recommend that you use the pre-built template, but you may construct your own file and insert the correct column headings.
Required Inventory Loader Fields
If a value is not included in the field below, your listing will not be visible on Amazon.com. Under certain circumstances, values are also required in other fields. (See Desired Inventory Loader Fields below.)
A SKU (stock-keeping unit) is used to track inventory. Each SKU you create must be unique to an individual item in your current template and existing listings. A SKU can be any alpha-numeric string. Avoid using symbols or spaces in your SKU.
Desired Inventory Loader Fields
The data you enter for these desired fields gives customers the basic information they need to make an informed purchasing decision. We highly recommend that you fill in all desired fields. Not providing data in desired fields can result in poor product descriptions and make your product hard to find. If a product exists on Amazon.com but does not have a price or quantity, customers cannot buy it.
Each product sold on Amazon.com also includes an industry standard product identifier. This field is required for product matching when creating new listings.
The following are recognized by Amazon as product IDs:
The product-id-type is a numerical entry that indicates if the product-id is an ASIN, ISBN, UPC, or EAN. This is a required field if product-id is provided. The options include:
This is a numeric entry that indicates the condition of the item. This field is required for creating a new listing.
Note: Not all conditions are available for all categories. For more information about what conditions you may use in your product category, see Condition Guidelines.
The price per item, in U.S. dollars. Do not include the "$" symbol. The price has to be greater than zero (0.00). This is a required field if product-id is provided and you are creating new listings. You must provide a price to make the item available for purchase on Amazon.com.
You must enter a quantity when adding a new SKU. You can set the quantity anywhere between 1 and 1,000. This is a required field for seller-fulfilled items if product-id is provided, and to make the item available for purchase on the website. Items must be in-stock and on-hand at the time a purchase is made.
Note: For Fulfillment by Amazon items (FBA), do not enter a quantity. Instead, provide a fulfillment-center-id in the last column of the template. See Optional Inventory Loader Fields below.
Use this field to describe any differences your item has from the new item sold by Amazon.com (for example, if your hardcover book is missing the dust-jacket). This field is limited to 1,000 characters for all Used, New, Collectible, and Refurbished items.
A code that indicates the countries to which you are willing to ship:
If you do not enter an option, the general setting you chose when you signed up to sell will be used as the default.
If you do not enter the value "international" in the expedited-shipping column, only International Standard shipping will be available. You can offer International Standard, International Expedited, both, or neither.
Note: Domestic Two Day, Domestic One Day, and International Expedited are for Books, Music, Videos, and DVDs (BMVD) only. For BMVD you can offer multiple expedited shipping options.
By selecting to ship internationally, your item will appear on other Amazon sites when there are no offers from a marketplace seller. You are solely liable to comply with the laws and regulations of the country from which you are shipping your products and also for the country to which you are shipping, as applicable. The international buyer may have to pay customs duties, taxes and processing fees for your product.
Note: Some products, including consumer electronics, software and video games, may not be shipped internationally or may only be shipped to eligible countries.
Enter "n" if you will not offer expedited shipping at all for the item. Enter "y" if you will only offer Domestic Expedited, but not Domestic Two Day, Domestic One Day, or International Expedited.
These are the valid expedited-shipping values for BMVD Items:
If you offer more than one expedited shipping option for a BMVD item, don't use the "y" value; use only the words domestic, second, next, and international, in any combination. Use the words exactly as listed and separate them with commas. Here are some examples of valid entries for the expedited-shipping column:
Optional Inventory Loader Fields
See Inventory Loader SKU Deletion for more information about deleting SKUs.
To remove offers from Amazon.com without deleting the SKU, use 'd' or set your inventory quantity to '0' (zero).
If you do not populate the add-delete field, our system will use these defaults:
This optional field helps Amazon identify potential pricing errors with your listings. To use this service, enter your minimum allowable price for this product. If you attempt to set your price for the product below your minimum allowable price, your offer will become inactive and you will be notified via email. You can always change your minimum allowable price by modifying the value in this field and uploading the updated file to Amazon.
Note: To remove the minimum price value for an item, enter the value "delete" in this field. Do not enter '0' or other numeric values. If you include this field but do not provide a value for an item, no change will be made to your existing minimum price value.
This optional field helps Amazon identify potential pricing errors with your listings. To use this service, enter your maximum allowable price for this product. If you attempt to set your price for the product above your maximum allowable price, your offer will become inactive and you will be notified via email. You can always change your maximum allowable price by modifying the value in this field and uploading the updated file to Amazon.
Note: To remove the maximum price value for an item, enter the value "delete" in this field. Do not enter '0' or other numeric values. If you include this field but do not provide a value for an item, no change will be made to your existing maximum price value.
This field is only required if you use Fulfillment by Amazon (FBA). If you don't use FBA, leave this column blank.
Use the Product Tax Code only if you are sure that your account is tax-enabled in Seller Central and you have Amazon tax codes for all your products. If no entry is provided, the default is "A_GEN_NOTAX."
Please use the e-mail address associated with your Amazon.com Seller account.
Other Help Sites