Upload inventory using the Inventory Loader

To download the Inventory Loader, click here.

The Inventory Loader lets you do the following:

• Upload thousands of listings in a single file for matching against existing product pages on Amazon
• Keep your listings up-to-date by modifying existing products
• Add new inventory
• Delete or "zero" inventory quantities for unavailable products
• Purge and replace all listings

To use the page matching features of Inventory Loader, you must provide a product identifier and specific information about your offer. You can use a SKU and selected listing data when modifying existing listings.

Because Inventory Loader cannot be used to create new product detail pages, you do not need to provide detailed product data. A single Inventory Loader file can be used to upload or modify listings in multiple product categories at the same time.

Inventory Loader or Listing Loader

Prepare your Inventory Loader file

There are four basic steps to use the Inventory Loader file template:

1. Download the Inventory Loader file template.
2. On the InventoryLoaderTemplate tab, enter a SKU, product identifier, and listing data for the products you want to offer for sale. You can manually enter listing details one by one, or if you have macros enabled, you can import an existing file that includes your listing information by using the Import File macro.
3. Verify the information you entered. If you have macros enabled, you can automate this process by clicking Validate from the file menu. The macro checks for data completeness and greatly reduces upload failures due to input errors.
4. Use the Upload File macro from the file menu and enter your seller account email and password.

Required Inventory Loader Fields

If a value is not included in the field below, your listing will not go live on the Amazon website. Under certain circumstances, values are also required in other fields. (See details in the Desired Inventory Loader Fields section below.)

sku: A SKU is a "stock-keeping unit" 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 columns with orange headers are desired: the data you enter for these 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.

product-id

The ISBN, ASIN, EAN or UPC number of the product (refer to the item barcode). It must be entered without spaces or dashes. If you are using a spreadsheet application, enter this information in text format in order to preserve the zeros at the beginning of the field.

This field is required if values have been entered in the "product-id-type" field.

product-id-type

This is the numerical entry that indicates if the product-id is an ASIN, ISBN, UPC, or EAN.

• 1 = ASIN (Amazon ID code)
• 2 = ISBN (10 characters)
• 3 = UPC (12 numerals or less)
• 4 = EAN (13 numerals - barcode)

This field is required if values have been entered in the "product-id" field.

price

The is the price of the item in Euros. Do not use the "€" symbol or the word "Euros". The price must be greater than zero.

This field is required if a value has been entered in the "product-id" field. You must enter a price in order for the item to be listed on Amazon.

item-condition

This is a numeric entry indicating the condition of the item. This field is required for creating a new listing and desired if you are updating an existing listing.

• 1 = Used - Like New
• 2 = Used - Very Good
• 3 = Used - Good
• 4 = Used - Acceptable
• 5 = Collectible - Like New
• 6 = Collectible - Very Good
• 7 = Collectible - Good
• 8 = Collectible - Acceptable
• 9 = Not used
• 10 = Refurbished
• 11 = New

quantity

Items shipped by the vendor: Enter the quantity of the item available for sale. These are the items available and in stock. The amount is mandatory for all items shipped by the seller. If the field is left blank, the item will be considered "out of stock".

Items shipped by Amazon: Please do not enter an amount. This field does not apply to products shipped by Amazon. Please enter instead a valid value in the "fulfillment-center-id" field. Please see the "Data Definitions" tab for the Inventory Loader file for details.

This field is required if values have been entered in the "product-id" field.

add-delete

Indicate with an "a" those listings you wish to update/add to your current inventory. Indicate with a "d" those listings you wish to close in your current inventory. The listings will remain in the system, retaining listing details.

Indicate with an "x" only those listings which you wish to completely delete from your current inventory. All product information for these listings will be completely removed, and cannot be recovered once removed. It is recommended that you not delete your listings, but close them instead, so that the data will be retained. If no value is provided for this field, the record will be applied as an update/add.

Please see our page describing the Inventory Loader SKU Deletion for more detail.

will-ship-internationally

A code that indicates the countries to which you are willing to ship:

• 15 = Metropolitan France
• 16 = Europe
• 17 = Europe, Overseas Territories, and New Caledonia
• 18 = Europe, Overseas Territories, New Caledonia, and North America
• 19 = The whole world

expedited-shipping

if you offer expedited delivery service in France and Monaco, enter the numerical value 15; otherwise, enter the letter "N".

item-note

Text explaining the actual condition of the item. You can also add comments (up to a limit of 2000 characters), for example, for listings for collectable books.

main-offer-image

The URL for the location of the main image of the product. The main image will be displayed on the product detail page. Images for listings should represent the particular characteristics of the item you are selling and illustrate the unique attributes that will help buyers to determine its condition and value.

Images for listings should be at least 200 pixels (on the longest side). A ratio of 1:1 or 2:1 is preferred. Accepted formats are JPEG (.jpg), GIF (.gif) and PNG (.png). For image standards as well as additional conditions, please visit our Help pages for images.

offer-image-1, -2, -3, -4, -5

Fields used to submit the URLs for other pictures of new and collectible items.

Optional Inventory Loader Fields

minimum-seller-allowed-price

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.

maximum-seller-allowed-price

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.

fulfillment-center-id

• Items fulfilled by Amazon: for sellers who use the Fulfilled by Amazon service, this field is used to indicate whether the item is entered in "Inventory fulfilled by Amazon (AFN)" or in "Inventory fulfilled by seller (MFN)." Enter the value "AMAZON_EU" if you want the product to be fulfilled by Amazon. Leave the field blank or enter "DEFAULT" if you want the item fulfilled by the seller.
• Items fulfilled by seller: leave the field blank