Vous voulez voir cette page en français ? Cliquez ici.
Search Help:

Inventory File Templates

Individual sellers:  These templates are for Professional sellers only.

Overview

To create an inventory file, you need a copy of the template you plan to use. An Inventory File Template is a Microsoft Excel spreadsheet that contains multiple columns for describing and listing your products. It also contains definitions for each column.

The templates you need to create product pages and listings can be downloaded from this page. For most category-specific product files, also download the applicable Browse Tree Guide (BTG).

Go directly to templates tables!

Choosing a Template

There are a number of files available for uploading your inventory to Amazon. Which file you choose will depend on your specific needs, and you may find it helpful to use different file types for different purposes.

The main distinction to make when selecting a file is whether you need to create product pages or whether you will only be matching to existing pages to create product offerings. Creating new pages requires you to provide a range of product attributes in your file. Matching can be done using only the product identifier, such as a UPC, EAN, or ISBN, and then providing listing details such as condition, item notes, price and quantity

If you want to upload only listing information (such as price and quantity), and not product information (such as title and description), you can use the Inventory Loader (or the Listing Loader). For quick updates, use the Price & Quantity File. These files offer a simple way to upload or edit your listing information for products that already exist on Amazon.ca.

The following table may help you decide when to use each of the files available to you.

File type

Use Case

File name

More Info

Product creation and matching

  • Page does not exist in Amazon.ca catalogue
  • You have full product information

Category Specific Inventory Files

Templates for each category are in the table below; UIEE files can also be used for Books

Product matching only

  • Page exists in Amazon.ca catalogue
  • You do not have full product information

Inventory Loader

For single products, use Sell Yours Here instead

Inventory updates

Quick updates to price or quantity only

Price & Quantity File 3-column format

Category Specific Inventory Files

For non-BMVD files, use the PartialUpdate feature

Update listing data only

Inventory Loader, Category Specific Inventory Files

The Listing Loader* can also be used

Product data changes

Update data contributions to product pages

Category Specific Inventory Files

For single products, use Add a Product instead

Delete product and catalogue contributions

Non-BMVD Inventory Files

Use "Delete"

Inventory Loader

Use "x"

Note: The template names in the tables (below) do not necessarily correspond to categories or product tabs on Amazon.ca.

Download Instructions

We do not recommend you open these files directly in your browser. Instead, save the file to your local computer and then open it using your spreadsheet program.

  1. In your browser, right-click the link for the file you want.
  2. From the pop-up menu, select "Save Target As."
  3. When the Save As dialog box appears, choose a location on your local computer, and then click "Save."

We recommend that you keep a back-up copy of your completed template on your computer hard drive for future reference.

Template Macros

Most template files include macros that can assist you in creating your data files and uploading your inventory. The macros will allow you to:

  • Validate the data you've provided in the file
  • Upload your file directly from Excel
  • Import files in .txt, .csv, or .xls format and map data to template fields
  • Update your template with the most current version

For more information, see the following Help pages:

Templates Tables

Files for Matching or Updating Inventory

Inventory File Template

Help Documents

Inventory Loader Learn more
Price and Quantity Learn more

Files for Media Categories (BMVD)

Inventory File Template

Help Documents

Book Loader Learn more
Music Loader Learn more
Video Loader Learn more

Files for non-Media Categories

Inventory File Template

Browse Tree Guide

Automotive Parts & Accessories* (See also: Tires) BTG
Baby BTG
Beauty BTG
Camera & Photo Use the BTG for Consumer Electronics
Cell Phones (Wireless) Use the BTG for Consumer Electronics
Consumer Electronics BTG
Grocery & Gourmet Food BTG
Health & Personal Care BTG
Home & Garden BTG
Jewellery* BTG
Large Appliances BTG
Lawn & Garden - Use the Home & Garden template** BTG
Luggage & Bags BTG
Musical Instruments BTG
Office Products Use the BTG for Consumer Electronics
Personal Computers Use the BTG for Consumer Electronics
Pet Supplies BTG
Software & Video Games BTG (Software)
BTG (Video Games)
Sports & Outdoors BTG
Sports Collectibles* BTG
Tires* (See also: Automotive Parts & Accessories) BTG
Tools & Building Supplies BTG
Toys & Games BTG
Watches* BTG

* Sellers listing in this category must be approved by Amazon. Please see our Categories Requiring Approval page for more information.
** Select ProductType = OutdoorLiving or ProductType = SeedsAndPlants.

Related Topics:

Seller Support

Please use the e-mail address associated with your Amazon.ca Seller account.
ARRAY(0xb35c8048)