To upload Excel file, set your PC to the Japanese environment (Shift-JIS).
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 to 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, see Create your inventory file template.
Use the following checklist to help build your product 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 (only in Japanese). 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. You can find a copy of the text file templates in the Inventory file templates Help topic.
Data Definition in English:http://s3.amazonaws.com/JP_AM/Listing/FF_DataDefinition-EN.xlsx
Data Definition in Chinese:http://s3.amazonaws.com/JP_AM/Listing/FF_DataDefinition-CN.xlsx
Amazon offers suggestions for providing product information to maximize visibility of your products. For more information, please see Improve product details.
Quality product images can increase the appeal of your listings and therefore are extremely important. For tips on effective images for your products, please see Improve product details.
Use the following checklist before you upload your product file:
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 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 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.
For more information, see Variation relationships.
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.
You are now ready to upload your inventory file. For more information, refer to the Upload your inventory file.
If you don't want to include the payment methods of Cash on Delivery (COD) or Convenience Store Payment (CVS), enter the following values. The payment will be unable to set if you leave blank, and the exclusion will not be applied.
|exclude cod||Exclude Cash On Delivery|
|exclude cvs||Exclude Convenience Store Payment|
|exclude code, cvs||Exclude both Convenience Store Payment and Cash On Delivery|
|exclude_none||No excluded payment method|
The lead time to ship is the time it takes you to get a product to your shipment carrier. The total shipping time is then lead time + carrier time.
The following table identifies the fulfillment 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 0 and 30.
|Input||Availability Message||Number of Days|
|1-2||In stock||1-2 days|
|3||Usually ships in 2-3 business days||2-3 days|
|4||Usually ships in 3-4 business days||3-4 days|
|5||Usually ships in 4-5 business days||4-5 days|
|6-10||Usually ships in 6-10 business days||6-10 days|
|11-15||Usually ships in 1 to 3 weeks||11-15 days|
|16-20||Usually ships in 2 to 3 weeks||16-20 days|
|21-30||Usually ships in 3 to 5 weeks||21-30 days|