Sell on Amazon Sign in
This article applies to selling in: Netherlands

Inventory file templates

Individual sellers: This feature is only available to sellers with a Professional selling plan. Learn more by visiting Selling plan comparison.
Note: Macros in inventory file templates are no longer supported.

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 known in the Amazon catalog.

To create an inventory file, follow these steps:

  1. Identify the classifications for the listings in your catalogue using the Product Classifier tool. This produces a Product Classifier file.
  2. Use the Product Classifier file to identify the inventory file template you will use to upload your listings and classifications.
  3. Fill in the inventory file template with the optional, desired, and required data and 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: If you are selling in more than one European stores, use the EU Browse Node Mapping table to easily find the corresponding Browse Nodes across all EU Stores.

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, Video, DVD) 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 already listed in your seller account. Use for price and quantity updates of items already listed in your seller account.
Shipping Overrides Modify shipping settings for individual products in your seller account. Use only for non-media products as exceptions where the regular shipping settings in Seller Central are not sufficient.

Inventory Loader and Listing Loader

If you intend to sell items which exist already in Amazon's catalog, you can use either the Inventory Loader or 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, Video, DVD, 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. Learn more about Listing Loader

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 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 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 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 catalogue using the Product Classifier tool. This produces a Product Classifier file.
  2. Use the Product Classifier file to identify the inventory file template you will use to upload your listings and classifications.
  3. Next you 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 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 contain instructions for completing the spreadsheet, image requirements and the data definitions. The tab labelled 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 (particularly 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 are done, save a copy of your file as a text file (save as: tab delimited text).
  7. Go under Inventory in Seller Central to Add Products via Upload. From the drop-down menu on the Upload your Inventory File tab, select the type of file to upload (e.g., Inventory Files for non-Media Categories).
  8. In the Locate File to Upload section, click Browse and select the tab-delimited text file (*.txt) you created earlier. Click 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 catalogue. 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

(Create new products with all available attributes)

Browse Tree Guide Style Guide Use For Approval Required
Automotive:

Car & Motorbike Parts and Accessories

Tyres and Wheels

BTG Style Guide e.g. Car and Motorcycle parts and accessories, tyres and rims, lubricants No
Baby BTG Style Guide e.g. Beds, Pushchairs, Babyphones, Pacifiers, Diapers. Use the Clothing template for baby clothes.

To ensure that you only upload the appropriate product types, click here.

No
Beauty ** BTG Style Guide e.g. Fragrances, Make Up, Hair Care.

To ensure that you only upload the appropriate product types, click here.

-
Business, Industrial & Scientific Supplies

Educational Supplies

BTG Style Guide Business, Industrial and Scientific Supplies designed to be used for professional purposes in a business or commercial environment. No
Books BTG Style Guide Match to existing books or create new entries in the catalogue. No
Clothing ** BTG Style Guide Women, Men, Kids & Baby clothing. Use the Shoes & Accessories Template for Clothing Accessories like Belts or Scarfs. Use the new Eyewear template for Glasses. -
Computers & Accessories BTG Style Guide e.g. Computers, Laptops, Computer Parts, Tablets and Tablet Accessories. No
Consumer Electronics BTG Style Guide e.g. TV, HiFi Equipment, Headphones, Cameras. No
Sunglasses and Fashion Eyewear** (Eyewear is now separated from the Clothing category) BTG Style Guide e.g. Sunglasses -
Food & Beverages ** BTG Style Guide (Food) To ensure that you only upload the appropriate product types, click here. -
Health and Personal Care** BTG Health & Personal Care

Personal Care Appliances

OTC Medication

Dietary Supplements

Style Guide Sexual Wellness

Health & Personal Care, Personal Care Appliances, Dietary Supplements.

To ensure that you only upload the appropriate product types, click here.

-
Home BTG Style Guide No
Home Improvement BTG Style Guide e.g. DIY Tools, Building Supplies, Plumbing, Work Safety Equipment No
Jewellery** BTG Style Guide - -
Small Domestic Appliances (Kitchen) BTG - - No
Lawn & Garden BTG Style Guide - No
Lighting BTG Style Guide e.g. Indoor and Outdoor lamps, Lightbulbs No
Luggage BTG Style Guide - No
Music BTG Style Guide - No
Musical Instruments BTG - e.g. Instruments, DJ Equipment, PA No
Office BTG Style Guide - No
Pet Supplies BTG Style Guide - No
Shoes & Accessories BTG Style Guide

No
Software & Video Games BTG (Software)

BTG (Video Games)

Style Guide - No
Sports BTG Style Guide - No
Toys BTG Style Guide - -
Watches BTG Style Guide

-
Video BTG Style Guide - No

**can only be used by pre-authorised merchants. See this page for more information.

Sign in to use the tool and get personalised help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling on Amazon


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