You can use inventory file templates to list your products in the Amazon catalog 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 Create your inventory file template.
If the items you are listing are already in Amazon’s catalog, you can use the Inventory Loader file to add your prices and quantities for sale. This is the easiest file to use. You just need to know the ISBN, UPC or EAN.
If your product is already in Amazon’s catalog, Amazon will add your listing to the existing page. If your product is not already in the catalog, Amazon will create a new catalog page based on the information you supplied.
The Price & Quantity template is great for easy inventory modifications. With it you can modify or delete your existing inventory on Amazon by only submitting SKU, Price and Quantity in your upload.
We recommend that you keep a backup copy of your completed template on your computer hard drive.
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 page ASIN and your offering) with your individual inventory level records in the Amazon catalog. This means:
We recommend that you always provide the UPC, EAN, JAN, or ISBN when creating a new product page on Amazon. For more information, go to Product identifiers. For the requirements for each category, including exceptions and exemptions where available, go to 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, go to Use search & browse.
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, color, 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."
You can view the child ASINs for each parent ASIN in the Amazon catalog on the Add a Product page in your seller account.
To create inventory files, you download the appropriate text file template. The text file template is a Microsoft Excel file that contains a preformatted worksheet where you list your product data. It also contains a number of other worksheets to help understand how to use the template.
Because each category on Amazon requires a different set of product data for its detail pages, a separate product template also exists for each category. In fact, some categories might have more than one template. It is important to use only the appropriate product template that is intended for your category.
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 actual worksheet on where you enter your product data using to the specifications found in the Data Definitions tab. This worksheet contains a row to help Amazon know which template you are using and a second row with column headings (label names) representing each of the fields in your inventory file.|
|Examples||Examples of how to accurately format the data for different products.|
As you enter your product data on the Template tab, be sure you follow the instructions provided on the Data Definitions tab. Many fields require you to use very specific terms. Sometimes those terms are listed in the Accepted Values column of the Data Definitions tab.
After you finish populating the Template tab in the Product Template with your product data, you are ready to create the inventory file you will upload to Amazon using Seller Central.
You are now ready to upload your inventory file. For more information, refer to the Upload your inventory file.
The lead time to ship or Handling time is the time it takes you to get a product to your shipment carrier. The total shipping time is then handling time (lead time to ship) + transit time (carrier time).
The following table identifies the fulfillment messaging that Amazon provides to customers based on the handling time you provide in your inventory data feed. Your handling time must be a number between 0 and 30 (N days).
|Input (N days)||Availability Message||Max Days to Ship|
|3||Usually ships within 2-3 days||3|
|4||Usually ships within 3-4 days||4|
|5||Usually ships within 4-5 days||5|
|6||Usually ships within 5-6 days||6|
|7||Usually ships within 6-7 days||7|
|8||Usually ships within 7-8 days||8|
|9||Usually ships within 8-9 days||9|
|10||Usually ships within 9-10 days||10|
|11||Usually ships within 10-11days||11|
|12||Usually ships within 11-12 days||12|
|13||Usually ships within 12-13 days||13|
|14||Usually ships within 13-14 days||14|
|15-21||Usually ships within 2-3 weeks||N|
|22-28||Usually ships within 3-4 weeks||N|
|28-30||Usually ships within 4-5 weeks||N|
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, see Improve 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, see Using search and browse.
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 offer values 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, which can take up to 48 hours to complete.
MMT is an extension of the category-specific inventory file templates that you can generate on the Add Products via Upload page in Seller Central. You can generate MMT by visiting Add Products via Upload page under the Inventory menu in Seller Central. To generate MMT, select multiple marketplaces before you generate your template. The list of selectable marketplaces displayed includes all marketplaces in which you are authorized to sell and have your accounts linked.
Use a consistent decimal separator throughout the template, including for prices in each marketplace. This should be the decimal separator that you normally use when using Amazon’s listing templates.
Prices must be provided in the primary currency of each marketplace. The currency for each marketplace is shown in the column header.
Unlike the single-marketplace template, MMT contains columns for each secondary marketplace that you can use to provide information about your offer (e.g. price). These columns of the template are marked with headers indicating the marketplace to which the columns apply (e.g. UK, DE). At a minimum, you must provide a price to create a listing in a secondary marketplace. If the ASIN does not already exist in the secondary marketplace, Amazon will attempt to create the listing in that marketplace for you.
Yes. As you update your product data over time in the home marketplace, your updated product data is translated into the languages of the secondary marketplaces and updated on the product detail pages in those marketplaces. Note that if you provide your own translated content directly into a secondary marketplace using another listing tool, that content will take precedence over any current or future translations performed by Amazon.
No. For each SKU, you can provide offer data for any marketplaces in which you want to list your item. Each SKU can be listed in one or multiple marketplaces in the template. The red highlighted cells are only required if you wish to list in that marketplace.
No. If the detail page exists in a secondary marketplace and you provide values for the secondary marketplace for price and currency in MMT, Amazon will create the offer for the ASIN in the secondary marketplace. If the detail page does not exist in the secondary marketplace, Amazon will attempt to create the detail page on your behalf.
The process of creating a detail page with your offer can take up to 48 hours, but usually completes within 24 hours. When you provide values for price and currency for a secondary marketplace, you are expressing an intent to list in that marketplace and Amazon will attempt to create the listing in that marketplace for you. It is possible that due to legal and compliance reasons, Amazon may not be able to create a detail page on your behalf. We recommend that you check your secondary marketplace’s Manage Inventory directly after 48 hours to ensure your listings have been created successfully.
For information, go to Amazon’s Category, Product, and Content Restrictions page.
Yes. For each SKU in your MMT for which the detail page does not exist in a secondary marketplace and for which you provided a price, the processing report will contain a message to indicate that Amazon is attempting to create the detail page on your behalf. Because the processing report is generated before the detail page creation process in secondary marketplaces is completed, the processing report does not provide information about the status of listing creation in secondary marketplaces.
Go to the Inventory menu on the top navigation bar, and select Manage Inventory. Find the SKU you wish to check and click Edit in the right column. On the Offer tab, scroll to the bottom of the page to find the status of the ASIN in each marketplace. If Amazon is still translating your listing, it will show as ''in progress''. If translation cannot be completed, this will also be shown.
In addition to providing values for all required attributes, Amazon recommends that you provide values for compliance attributes such as power_plug_type. Note that these attributes are not applicable to all product types and marketplaces and therefore may not exist in the template for all product types.
You must comply with all applicable laws when listing and selling products on Amazon, including applicable laws in each jurisdiction in which your products are sold. If you determine that you are allowed to sell a product in a marketplace for which MMT did not result in successful detail page creation, you can create the detail page by using another listing tool, such as a single-marketplace listing template or the Interactive Listing Workflow.
If the detail page for your product does not exist in any Amazon marketplace worldwide prior to your submission of MMT, Amazon will use the content you provide in MMT for the home marketplace as the source for translations when attempting to create the Detail Page in the secondary marketplace. If you have already created the ASIN in multiple marketplaces and have linked your accounts across those marketplaces, Amazon will use listing contributions from one of the marketplaces in which you have a listing for ASIN as the source content for the translations.
No. Product data provided in MMT is not translated and contributed to the ASIN in a secondary marketplace if the detail page already exists in the secondary marketplace at the time that you submit MMT. Translation and contribution of product data to a secondary marketplace occurs only in the scenario that the ASIN does not exist in the secondary marketplace at the time of MMT submission.
The list includes all marketplaces in which you are registered and are able to create listings in. You must have linked your accounts to access marketplaces outside of a region such as Europe or North America.
Yes, you can download and submit MMT in any marketplace in which you are authorized to list products in bulk. The home marketplace is not determined by an account setting, but rather determined by the marketplace in which you download and submit your MMT.
No, MMT does not provide this capability. The product images that you provide in MMT will be used for all marketplaces.
No, MMT does not provide this capability. To provide your own translated product content for secondary marketplaces, use a single-marketplace template for each marketplace or the Interactive Listing Workflow for each marketplace.
Select the marketplace for which you want to view the translated content using the marketplace switcher at the top of the Seller Central page. You can then view and edit the translated content by visiting the Manage Inventory page under the Inventory menu, and clicking Edit for the SKU you want to change. If you would like to overwrite the translation with your own content, you can submit content in the text box for the attribute.
You can use both BIL and MMT. However, if you have an SKU whose price for a particular marketplace is defined using a BIL price rule, the BIL price rule will be turned off for that SKU in the target marketplace if you provide a price in MMT or other listing tool for that marketplace and SKU. If you wish to revert to using the BIL price rule, you should remove this ASIN from the BIL exclusion list for that marketplace using the Build International Listings page in Seller Central. Conversely, if you previously provided the price for an ASIN in a marketplace using MMT, and you subsequently create a BIL connection with that marketplace as the target marketplace, the BIL price rule that was defined when setting up the BIL connection will take precedence over the price previously provided in MMT.
You must request approval separately in each marketplace for most approvals.
Marketplace-specific errors for offer data that you provide in MMT will appear in the processing report that Amazon provides after you submit your template. If the errors do not prevent SKU creation, you can also view the errors by signing in to Seller Central for the marketplace you want to check and then viewing your SKU in Manage Inventory.
No. The product data for your listing in the secondary marketplaces is not deleted. The submission of MMT affects only the offer data (e.g. price) for your listing in the secondary marketplace.