You can use inventory file templates to create or edit your listings in the Amazon catalogue in bulk.
If the items you want to list are already in Amazon’s catalogue in the marketplace where you want to list and you do not wish to provide information that describes the item, such as bullet points or product description, we recommend that you use one of the following three templates, which can be downloaded here:
If the items you want to list do not yet exist in Amazon’s catalogue in the marketplace in which you want to list or you wish to provide information that describes the item, such as bullet points or product description, we recommend that you use a category-specific template. You can generate a template for the categories in which you wish to list by visiting the Add Products via Upload page.
If you want to list your items in multiple marketplaces, we recommend that you use the Multi-Marketplace Listing Template. You can generate this template on the Add Products via Upload page by selecting the marketplaces in which you want to list before you generate your template. For details on using the multi-marketplace features in this template, see the bottom of this page.
If the items you are listing are books and are not in the catalogue, or you do not know the ISBN, UPC or EAN, you can use the Standard Bookloader file. You supply information about the book (such as title and author) and we will check whether it already matches a catalogue item. If it does not match, we will create a new catalogue entry based on the information you supplied. Booksellers may also want to load inventory using the UIEE format. With this option, if you don’t have ISBNs, you can still load your items to Marketplace by taking advantage of Amazon’s ISBN matching. Books that don’t have ISBNs will have new detail pages created.
If the items you are listing belong in the Music category, you can use the Music Loader File. If your product is already in Amazon’s catalogue, Amazon will add your listing to the existing page. If your product is not already in the catalogue, Amazon will create a new catalogue page based on the information you supplied.
We recommend that you keep a backup copy of your completed template on your computer hard drive so that you can use it later to make updates to your listings.
The SKU is the key field in every inventory file and should not be altered or reused The SKU is the key field in every inventory file and should not be altered or reused within a single marketplace. Amazon uses the SKUs in your inventory file to associate your product listings (the product page ASIN and your offering) with your individual inventory level records in the Amazon catalogue. This means the following:
We recommend that you always provide the UPC, EAN, JAN or ISBN when creating a new product page on Amazon. For more information, see Product identifiers. For the requirements for each category, including exceptions and exemptions where available, see Category and product code requirements.
Customers primarily use search terms (keywords) to find products on Amazon. Good search terms go a long way toward increasing product visibility. Most products can support five keywords. Think like customers do and use search terms that are popular on your own website or for your product line. For more information about using search terms, see Use search & browse.
Some categories support variation relationships that include a single parent product and multiple child products.
Parent products are non-sellable products that you list in your inventory file so you can create relationships between products.
Child products are unique, sellable products linked to a parent product. The child product is similar to other child products (or siblings) linked to the same parent product. However, the child varies from its siblings according to specific criteria. These criteria are described in the variation-theme section of the Data Definitions tab on the inventory file template. Acceptable variation themes differ by category, but might include attributes such as size, colour and flavour.
Set up parent-child relationships in your inventory file whenever possible. This makes search and browse results much more manageable for customers because related child products are grouped together. When you set up parent-child relationships, distinguish each child product in the title. For example, if you sell shirts and some are red and some are blue, use ‘Shirt, Red’ and ‘Shirt, Blue’.
You can view the child ASINs for each parent ASIN in the Amazon catalogue on the Manage Inventory page page in your seller account.
For more information, see Variation relationships.
When you open the product template in Microsoft Excel, you see several tabs along the bottom of the product template workbook. These tabs include the following:
|Instructions||An overview of how to use the product template.|
|Data Definitions||A detailed review of each field in the inventory file. This tab provides a label name, definition, use case, accepted values and example for each field.|
|Template||The sheet where you provide your listing information. You can modify the order of the columns, but do not modify the order of the top three rows. The first row of this sheet contains information about the version of the template you are using. The second row of this sheet contains attribute labels that describe the information being requested in each column. The third row contains the attribute identifier that Amazon’s systems use to associate your listing data with the correct attribute.|
|Examples||Examples of how to accurately format the data for different products.|
As you enter your listing information on the Template tab, follow the instructions provided on the Data Definitions tab. Some fields require you to choose from a set of values. Refer to the Data Definitions tab for these sets of valid values.
Before you start
Use this information to help you build your inventory file:
The Text File template includes a Data Definitions tab containing a detailed review of each field in the inventory file. This tab provides a label name, definition, use case, accepted values and example for each field. You will need to refer to this tab to successfully upload your products. The Data Definitions tab is located at the bottom of the Text File template.
Amazon offers suggestions for listing your product information that is proven to increase both visibility and sales. For more information, please see using product details.
Images greatly increase sales and therefore are extremely important. Amazon offers advice on how to list the best images for your products. See Amazon’s product image requirements here.
Search terms are the primary method customers use to find products. Amazon offers tips on optimising these terms. For more information, please see Using search and browse.
When using a category-specific inventory file, you should specify the operation you wish to perform on your SKU in the column labelled Update delete. There are three options:
Before you upload your inventory file, check that it meets the following conditions:
After you finish populating your inventory file, you can upload the file on the Add Products via Upload page. When uploading your file, ensure that you select the option that corresponds to the type of inventory file you are using.
If you selected multiple marketplaces when generating your category-specific inventory file on the Add Products via Uploads page, this section applies. Including additional marketplaces in your template will add columns for you to provide marketplace-specific offer data, including price. For each SKU, provide a price and currency for each marketplace in which you would like to list the item. The product data you provide in your template will apply to the SKU in the marketplace in which you submit your template. If you provide offer data in your template for a marketplace in which the detail page for your listing does not yet exist, Amazon will attempt to create the detail page by translating your product data into the primary language of the requested marketplace.