Search Help:

Inventory Files for Non-Media Categories

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 the columns needed for describing and listing your products. It also contains definitions for each column.
The templates you need in order to create product pages and listings can be downloaded from this page. For category-specific product files, you also have to download the applicable Browse Tree Guide (BTG).

Choosing a Text-file Template
There are a number of text 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.com.
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.co.uk catalogue
  • You have full product information

Category Specific Inventory Files

Templates for each category are in the table below.

Product matching only

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

Inventory Loader

The Listing Loader* can also be used.

Inventory updates

Quick updates to price or quantity only

Price & Quantity File

3-column format

Category Specific Inventory 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

Inventory Loader

Use "d"

* The Inventory Loader and Listing Loader are similar templates with slightly different applications. The Listing Loader will allow sellers to enter information 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, although we recommend the Inventory Loader for most cases. In cases where several matches are found for a product, the Listing Loader may help you to resolve the issue more easily.

Please note:

  • The template names in the chart (below) do not necessarily correspond to categories or product tabs on Amazon.co.uk.

To create an inventory file, you need a copy of the Inventory Loader you plan to use.

Templates Table

Template

Select in the 'Feed type to upload' menu

Inventory Loader:
Upload your inventory to match existing product pages using the Amazon tab-delimited format for all categories. Inventory Loader cannot be used to create new product pages. Read more about uploading your listings using the Inventory Loader.

Inventory Loader File

Price & Quantity: Modify or delete your existing inventory on Amazon by only submitting SKU, Price and Quantity in your upload. Learn More

Price & Quantity File

Book Loader: (Standard): Upload your book inventory or add new books detail pages to the Amazon catalogue using the Standard Book Loader tab-delimited format by Amazon. Use the Bookloader if you do not have the ISBN, UPC or EAN for a book or the book is pre-ISBN, and we will match your book to our catalogue based on the data you provide. Learn more

Standard Book Loader File

Music Loader:
The Music Loader is a bulk page-creation and page-matching tool for sellers who list products in our Music category. The Music category has a separate inventory template that has tabs with Instructions, Image Information, Data Definitions, Examples, and Valid Values. Learn More

Music Loader File

Video Loader:
Upload your Video, DVD, and Blu-ray inventory and add new product pages to the Amazon.co.uk catalogue using the Amazon tab-delimited format. Learn more

Video Loader File

For all other product templates (with the exception of UIEE), choose the Inventory Files for non-media categories menu option.

Macros
Please note: Some of the templates provide macros to assist you in creating 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: Enabling Macros in Excel

Download Instructions


We do not recommend that you open these files directly in your browser. Instead, save the file to your local computer and then open it using your spreadsheet program.
  • In your browser, right-click the link for the file you want.
  • From the pop-up menu, select "Save Target As."
  • When the Save As dialog box appears, choose a location on your local computer, and then click "Save."

Category-specific inventory files
To create an inventory file, you need a copy of the appropriate Inventory File Template.

Template

Browse Tree Guide (BTG)

Apparel *

Apparel

Automotive 

Automotive

Baby

Baby

Beauty *

Beauty

Computers & Accessories

Computers & Accessories

Consumer Electronics

Consumer Electronics

Grocery & Beverages *

Grocery & Beverages

Health & Personal Care *

Health & Personal Care

Personal Care Appliances *

Health & Personal Care

Home

Please use this template correctly and ensure that you only upload the appropriate product types. Click here for Home product types.

   

Home and Garden

Small Domestic Appliances (Kitchen)

Please use this template correctly and ensure that you only upload the appropriate product types. Click here for Small Domestic Appliances (Kitchen) product types.


Home and Garden

Lawn & Garden

   

Home and Garden

Home Improvement

Home Improvement

   

Jewellery *

Jewellery

Kindle Accessories

Consumer Electronics

Large Appliances 

Large Appliances

Lighting

Lighting

Luggage

Luggage

Musical Instruments

Musical Instruments

Office

Office

Pet Supplies
(Do not use for Pet Food! For Pet Food please continue to use the Grocery flat file.)

Pet Supplies
Until further notice, please use this browse tree guide together with
flat files Home and Garden, or Grocery (for pet food).

Shoes & Accessories

Shoes & Accessories

Software & Video Games 

Software
Video Games

Sports

Please use this template correctly and ensure that you only upload the appropriate product types.Click here for Sports Product Types.

Sports

Toys

Toys

Watches *

Watches

* can only be used by pre-approved sellers.

Related Topics:

Seller Support

Please use the e-mail address associated with your Amazon.co.uk Seller account.