This article applies to selling in: United Arab Emirates

Inventory file templates

Individual sellers: This feature is only available to sellers with a Professional selling plan. Learn more by visiting Selling plan comparison.

An Inventory File Template is a Microsoft Excel spreadsheet that contains multiple data columns for describing your products. Sellers use Inventory File Templates to upload listings to Amazon.

Most Inventory File Templates are designed for a specific product category. Additional templates are available to create or update listings in all categories, when the target products are already available in the Amazon catalog.

To create an inventory file, follow these steps:

  1. Identify the classifications for the listings in your catalog using the Product Classifier tool. This produces a Product Classifier file.
  2. Use the Product Classifier file to identify the inventory file template that you will be using to upload your listings and classifications.
  3. Fill in the Inventory File Templates with the optional, desired and required data in accordance with the appropriate category Style Guide and your seller agreement.
Note: Information on search refinements and valid values can be found on the Refinements tab (worksheet) in the Browse Tree Guide for each category.

For detailed instructions on how to create an inventory file using the Inventory File Template, see Building Your Inventory File.

Browse Tree Guides

Browse Tree Guides (BTGs) contain the same information as is exposed in the Product Classifier tool. BTGs also contain required refinements for each listing and valid values. We use the refinements to improve the customer discovery experience. For example, the refinement “Cuff Type” is displayed to customers in the Men’s Dress Shirt browse node, but not to customers in the Electronics node.

Note: On February 28, 2020, Amazon made new versions of the Inventory Loader, Listing Loader, and Price & Quantity File available for download on Seller Central. Please download the new versions of the Inventory Loader, Listing Loader, and Price and Quantity File using the links below.

While the files below can be used by all sellers with a Professional selling plan, some files contain macros that can be used only by sellers with MWS credentials. The macros provide optional features that are not required to use the files. To obtain MWS credentials, you must be compliant with the requirements set forth in the Acceptable Use Policy and Data Protection Policy, described here. Note that the Upload File macro that was available in the legacy versions of the Listing Loader, Inventory Loader, and Price & Quantity File, is no longer available in the new versions of these files.

General Templates (Not Category Specific)

Template Name Use case Use for
Inventory Loader To upload your inventory by assigning your offers to existing products in the Amazon catalog. Use for media products (Books, Music, Videos and DVDs), including their shipping settings
Listing Loader To upload your inventory by assigning your offers to existing products in the Amazon catalog. Use for non-media products, including the option to set sales prices or gift options.
Price & Quantity Update Update Prices and Quantities of items that are already listed in your seller account. Use for price and quantity updates of items that are already listed in your seller account

Inventory Loader and Listing Loader

If you intend to sell items that already exist in Amazon’s catalog, you can either use the Inventory Loader or the Listing Loader to assign your offers to these products. The Inventory Loader and Listing Loader are similar templates with slightly different uses:

  • The Inventory Loader allows you to enter shipping settings for media products (Books, Music, Videos and DVDs, usually referred to as “BMVD”) 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”.

Category Style Guides

There are general requirements that are applicable to all categories. In addition, each category has slightly different listing requirements that sellers should follow. These requirements ensure that your listings are displayed optimally on the website. For more information, consult the style guide for your category in the table below. (Style guides are not available for all categories. Where no style guide exists, refer to the general listing guidelines.)

Downloadable Files

The tables below contain the downloadable Microsoft Excel and PDF files that you will need to create an inventory file. Do not open these files directly in your browser. Instead, save the files to your local computer, and then open them from your local disk drive. We recommend that you keep a back-up copy of your completed inventory file on your computer for future reference.

  1. Identify the classifications for the listings in your catalog using the Product Classifier tool. This produces a Product Classifier file.
  2. Use the Product Classifier file to identify the inventory file template that you will be using to upload your listings and classifications.
  3. Next, save the file to your computer and then open it using a spreadsheet program.
  4. In your browser, right-click the link for the file that you want from the list below.
  5. When the pop-up menu appears, click Save Target As.
  6. When the Save As dialogue box appears, choose a location on your computer, and then click Save.

Instructions for using the file


  1. Open the template in your spreadsheet application.
  2. The first sheet in the workbook contains instructions for filling in the spreadsheet, image requirements and the data definitions. The tab labeled Template is the one in which you will enter your data.
  3. Fill in the spreadsheet. See the corresponding column in the data definitions to understand which values are required or optional. Refer to the Valid Values tab to understand if attributes accept only certain, predefined values.
  4. If the numbers in the columns (in particular the product-id) do not retain all of their digits, you may need to select the column and change the data format to “Text”.
  5. Do not delete or modify the information in the first three rows of the file (the file header and the column headings).
  6. When you have finished, save a copy of your file as a text file (save as a tab-delimited text).
  7. Go to Inventory in Seller Central to Add Products via Upload. From the drop-down menu in the Check your File section, choose the type of file that you want to upload, select the file via Browse and then click the Check My File button.
  8. If the ticked file produces errors, you can edit them directly in the ticked file, and then upload the same file after correction.
  9. Press Upload Now to submit your file to Amazon.

For detailed instructions on how to create an inventory file using the Inventory File Template, see Building Your Inventory File.

Category-specific Templates

You can use these templates to list your products on Amazon. They help you to either create new product detail pages or match to existing items in our catalog. The templates contain detailed instructions and data definitions.

For detailed instructions on how to create an inventory file using the Inventory File Template, see Building Your Inventory File.

Note:
  • The Template Name values do not necessarily correspond to categories or product tabs on Amazon.
  • The Required column in the inventory file’s data definition tab specifies which elements are mandatory and which are optional.
  • We recommend that you keep a back-up copy of your completed inventory file on your computer for future reference.
Standard Template Browse Tree Guide Style Guide Use For Approval Required
Clothing BTG for AE Style Guide Women, Men, Kids & Baby clothing. Use the Shoes & Accessories Template for Clothing Accessories like Belts or Scarves. Use the new Eyewear template for Glasses. No
Baby BTG for AE Style Guide e.g. Beds, Pushchairs, Babyphones, Dummies, Nappies. Use the Clothing template for baby clothes. Yes
Auto Accessories BTG for AE Coming Soon e.g. Car and Motorcycle parts and accessories, tyres and rims, and lubricants Yes
Camera BTG for AE Coming Soon e.g. TV, Hi-Fi Equipment, Headphones and Cameras. No
Beauty BTG for AE Style Guide e.g. Fragrances, Make-up, Hair Care. Yes
Computers BTG for AE Coming soon e.g. Computers, Laptops, Computer Parts, Tablets and Tablet Accessories. No
Consumer Electronics BTG for AE Style Guide e.g. TV, Hi-Fi Equipment, Headphones and Cameras. No
Educational Supplies BTG for AE Coming Soon

No
Eyewear BTG for AE Coming Soon e.g. Sunglasses No
Food and Beverages BTG for AE Coming Soon

Yes
Grocery & Gourmet BTG for AE Style Guide

Yes
Furniture BTG for AE Coming Soon

No
Health BTG for AE Style Guide e.g. Health & Personal Care, Personal Care Appliances, Dietary Supplements Yes
Home BTG for AE Coming Soon

Yes
Lawn and Garden BTG for AE Coming Soon

No
Luggage BTG for AE Style Guide

No
Jewelry BTG for AE Style Guide

No
Home Improvement BTG for AE Coming Soon e.g. DIY Tools, Building Supplies, Plumbing and Work Safety Equipment No
Musical Instruments BTG for AE Coming Soon e.g. Instruments, DJ Equipment, PA Systems No
Pet Supplies BTG for AE Style Guide

Yes
Tires and Wheels BTG for AE Coming Soon

No
Shoes BTG for AE Style Guide

No
Sports BTG for AE Style Guide

No
Toys BTG for AE Coming Soon

Yes
Watches BTG for AE Style Guide

No
Books BTG for AE Coming Soon Match to existing books or create new entries in the catalogue. No
Kitchen BTG for AE Coming Soon

Yes
Large Appliances BTG for AE Coming Soon e.g. Washing machines, Dishwashers and Refrigerators No
Lighting BTG for AE Style Guide e.g. Indoor and Outdoor Lamps, Light bulbs No
Office Products BTG for AE Coming Soon

Yes
Outdoors

Style Guide

No
Video Games BTG for AE Coming Soon

No
Wireless Product Compliance BTG for AE Coming Soon Use to add information required as part of the UAE laws and regulations Yes
Sign in to use the tool and get personalized help (desktop browser required). Sign In


Reach hundreds of millions of customers

Start selling on Amazon


© 1999-2020, Amazon.com, Inc. or its affiliates