Inventory file templates, category listing guidelines, and browse tree guides
You can also get the information from Seller University:
- How to add products by uploading a feed file (new ASIN)
- How to add products by uploading a feed file (ASIN exists)
Overview
An Inventory File Template is a Microsoft Excel spreadsheet that contains multiple columns for describing and listing your products. Sellers can use inventory file templates to create and update listings on Amazon
- Inventory File templates can be downloaded from the Inventory File Templates section in the second half of this help page.
- You can generate customized inventory templates specific to the types of products you sell, which allows you to list products across multiple categories in one template. For more information, see Create your inventory file template.
- You can update number of days from order to shipping in bulk. See How to Change the Number of Days from Order to Shipment for details.
- You can create variation in bulk as well. See How do I create or modify a product that includes variations? for details.
Identify classification for your listings
The Amazon classification system uses values supplied by sellers to determine where listings are visible in the browse structure on Amazon. The Product Classifier tool helps you to identify the appropriate classification for your listings.
You can also use Browse Tree Guide, which can be downloaded from this page, to identify appropriate classification.
Select an inventory file template
Refer to the following table, select an appropriate inventory file template for your usage from the Inventory File Template section in the second half of this help page, and download it. Fill out the downloaded file and upload it to Seller Central. See here for creating and uploading an inventory file template.
| File type | Use Case | File name | More Info |
|---|---|---|---|
| Product creation and matching |
Page does not exist in Amazon catalog. You have full product information. You will provide a range of product attributes in your file. |
Category Specific Inventory Files | Templates for each category are in the table below.
Note: The name of file template may differ from the name of category or the name of store in Amazon.
|
| Product matching only |
Page exists in Amazon catalog. You do not have full product information. You can update only listing information (such as price, points and quantity), but not product information (such as title and description). Match the product using only the product identifier, such as a UPC, JAN, or ISBN, and then provide listing details such as condition, item notes, price and quantity. |
Inventory Loader
For BMVD(Books, Music, DVDs and Videos) |
"will-ship- internationally" field is contained. Shipping settings are available for BMVD products. |
| Listing Loader
For Non-BMVD |
"sale- start-date" and "is-gift-wrap-available" fields which can be used for Non-BMVD are contained in the file. | ||
| Inventory or Price updates | Quick updates to price, Amazon Points or quantity only | Price & Quantity File | Select "Price & Quantity File" to upload. |
| Shipping options | Update BMVD shipping service areas | Inventory Loader | |
| Change shipping service areas or fees for specific products | Shipping Override File |
Note: Shipping overrides are not available for BMVD products
|
|
| Product data changes | Update data contributions to product pages | Category Specific Inventory Files | For single products, use Add a Product instead |
| Delete product and catalog contributions | Category Specific Inventory Files For Non-BMVD |
Enter "Delete" to the "Update-Delete" field | |
| Inventory Loader
For BMVD |
Enter "x" to the "Add-Delete" field |
Download, save, and open the inventory file template
We recommend you do not open these files directly in your browser. Instead, save the file to your local computer and then open it using a spreadsheet program.
- In your browser, click the link for the inventory file template you want from Inventory File Template section in the second half of this help page.
- From the pop-up menu, select "Save the file."
- Choose a location on your local computer, and click the downloaded file to open it in Excel.
Inventory File Templates
- The Inventory Loader allows you to enter BMVD shipping settings, with optional fields for expedited-shipping and will-ship-internationally.
- The Listing Loader allows you to enter information for non-BMVD features, with optional fields such as sale-start-date and is-gift-wrap-available.
For basic matching, either the Inventory Loader or Listing Loader can be used.
| Inventory Loader For BMVD (Books, Music, DVD/Video) |
|
|---|---|
| Before Microsoft 2003
The macro program is NOT contained. |
Microsoft 2003 and later
The macro program is contained. |
Listing Loader
Price & Quantity
Select "Price & Quantity" to upload
- Please choose ‘Price & Quantity file’ as file type from drop down when uploading Price & Quantity file.
- Price and Quantity file is always treated as Partial Update.
- Please set ‘standard-price-points’ as well when changing ‘price’, otherwise, point will be initialized and set to 0 automatically.
- Please set ‘handling-time’ as well when changing ‘quantity’, otherwise, handling-time will be initialized and set to default automatically.
Category-Specific Inventory File Templates
Inventory file templates, category listing guidelines, and browse tree guides
- Inventory file templates, category listing guidelines, and browse tree guides
- Add product data to your inventory file
- Improve your listing quality using bulk edits
