Build your inventory file

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

You can use inventory file templates to list your products in the Amazon catalogue and to offer them for sale on Amazon. Inventory file templates let you add or edit product listings in bulk. You can create a template to suit your specific requirements and list different types of products across multiple categories using one template. First, create your template using the Add a Product via Upload tool. For more information, go to Add your products using inventory files.

Tips for building an inventory file

Backups

We recommend that you keep a backup copy of your completed template on your computer hard drive.

SKU

The SKU is the key field in every inventory file and should not be altered or reused . Amazon uses the SKUs in your inventory file to associate your product listings (the product detail page) with your individual inventory level records in the Amazon catalogue. This means:

Every product in your inventory file must have a unique SKU.
Every new SKU you upload to Amazon results in the creation of a new record in the Amazon catalogue.
Because each record is unique, an existing SKU cannot be changed. It remains in the catalogue until you delete it.
If you upload an inventory file with data for a SKU that already exists, the most recent data replaces data from previous feeds.

Standard product identifier

We recommend that you always provide the UPC, EAN, JAN, or ISBN when creating a new listing on Amazon. For more information, go to Product UPCs and GTINs. For the requirements for each category, including exceptions and exemptions where available, go to Overview of category UPC requirements.

Search terms

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, go to Optimise listings for search.

Note: Standard Book Loader files do not support search terms (keywords). Amazon assigns search and browse information for products listed in the Books category. However, you can use the Add a Product tool to increase the number of search keywords for your Books products.

Variation relationships

Some categories support variation relationships that include 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 flavor.

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."

Note: You must set up a parent-child relationship if an appropriate variation theme exists for your products and category.

You can view the child ASINs for each parent ASIN in the Amazon catalogue on the Add a Product page in your seller account.

For more information, go to Variation relationships.

Save your inventory file

Before you upload your inventory file to Amazon, you need to save it as a text (tab-delimited) file. Perform this step after you add products to your product inventory file.

Here is how to save your updated inventory file:

Save your work as an Excel workbook one final time. We recommend that you create a backup copy and add a date to the file name. This will help to keep a history of your work if you want to refer to prior versions or if there is an error in processing.

Make sure the worksheet tab that contains your data is active.

On the File menu, click Save As. The Save As dialog box appears.

In the Save As Type select Text (Tab-delimited) (*.txt). Browse to where you would like to save the file, rename the file, and click Save.
- Click Yes if you see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets.
- Click Yes if you see a warning that your file contains features incompatible with the selected Text (Tab delimited) file format.

You are now ready to upload your inventory file. For more information, refer to Upload your inventory file.

Set the handling time in an inventory file

The handling time is the time it takes you to get a product to your shipment carrier. The total delivery time is then handling time + transit time.

The following table identifies the fulfilment messaging that Amazon provides to customers based on the product-level availability you provide in your inventory data feed. Your product-level availability must be a number between 1 and 30.

Input (In days)	Availability Message
1-2	In stock
3	Usually ships within 2-3 days
4	Usually ships within 3-4 days
5	Usually ships within 4-5 days
6	Usually ships within 5-6 days
7	Usually ships within 6-7 days
8	Usually ships within 7-8 days
9	Usually ships within 8-9 days
10	Usually ships within 9-10 days
11	Usually ships within 10-11days
12	Usually ships within 11-12 days
13	Usually ships within 12-13 days
14	Usually ships within 13-14 days
15-21	Usually ships within 2-3 weeks
22-28	Usually ships within 3-4 weeks
28-30	Usually ships within 4-5 weeks

Note: If you do not specify a handling time, the value is set to the default handling time specified on Seller Central. If you use an inventory file template to update your inventory amounts, be sure to specify your handling time in the fulfillment_latency field.