How to complete your Amazon inventory template

Below are the official information provided by Amazon that will help you to create your “Amazon template” very nicely and filling all attribute in that. If still facing any issue please email or call me me.

Group Name Field Name Local Label Name Definition and Use Accepted Values Example Required?
Required            
  item type Item Type Keyword The keyword from the Browse Tree Guide that best describes the type of item. Refer to the Browse Tree Guide (BTG) for valid values. tank top and cami shirts Required
  item sku Seller SKU A unique identifier for the product, assigned by the merchant. The SKU must be unique for each product listed. After you have established a SKU for a product, please do not change it without first deleting the original SKU from our systems through a delete feed. Unique Identifier. If you don’t enter a SKU we’ll create one for you. 101 My Collectible1 Required
  external product id Product ID A standard, alphanumeric string that uniquely identifies the product. This could be a GCID (16 alphanumeric characters), UPC or EAN. This is a required field if product id type is provided. Any valid GCID, UPC, or EAN. 808791035096 Required
  external product id type Product ID Type The type of standard, unique identifier entered in the Product ID field. This is a required field if Product ID is provided. The type of standard, unique identifier entered in the Product ID field. This is a required field if Product ID is provided. UPC Required
  brand name Brand Name The brand of the product. An alphanumeric string; 1 character minimum in length and 50 characters maximum in length. Ralph Lauren Required
  item name Product Name A short title for the product. This will be displayed in bold on the product page and in the title bar of the browser window. An alphanumeric string; 1 character minimum in length and 80 characters maximum in length. Arrow Men’s Wrinkle Free Pinpoint Solid Long Sleeve, Light Blue, 16″ Neck X 34″ Sleeve Required
  color name Color The colour of the product. An alphanumeric text string; 1 character minimum and 50 characters maximum. If multiple colours are available, a unique record should be submitted for each product. Sage, Navy, Emerald, Cherry, Red, Black Required
  department name Department The department of clothing (mens, womens, etc.) in which the product is found. Please select a value from the Valid Values tab. unisex-adult Required
  size name Size The size of your product. An alphanumeric string. If multiple sizes are available, a unique child record should be submitted for each size. Large Required
  standard price Standard Price A price greater than 0.  Do not include thousands separators or currency symbols. The price at which the product is offered for sale, in the local currency. 249.99 Required
  quantity Quantity Merchant-fulfilled products: Enter the quantity of the item you are making available for sale.  This is your current INVENTORY commitment.  Quantity is required for all “child” or stand-alone items. If left blank when first submitting the product information, the item will be displayed as “Out of stock.”  Do not enter quantity for parent items. Amazon-fulfilled products: Do not enter quantity, as it is not applicable for products fulfilled by Amazon.  Instead, submit fulfillment center id in a separate column (see data definition for details). A whole number. 152 Required
  merchant shipping group name Shipping-Template Sellers can create a set of ship configurations based on business needs and use cases. The ship configurations can be region based and have rules to set SLA and rate for the region. When listing product to create offer, seller needs to select one ship configuration for the product. The ship configuration will be used to retrieve the valid ship options on the website. The ship configuration group for an offer. The ship configuration group is created and managed by the seller through the ship setting UI. “Free Shipping Template”, “Default Template” Required
  main image url Main Image URL The URL where a main image of the product is located.  It’s important that this is supplied for all products. Images should have 72-pixels-per-inch resolution and be 500 pixels minimum in length (on the longest side). The preferred file format is JPEG (.jpg), and the URL must be fully-formed and valid (i.e., include http://). When naming your image, you may use the following convention (though not required): Product SKU + View Indicator (.main) + File Extension (.jpg). An example would be: “15774.main.jpg”.  There cannot be any spaces or high ASCII characters in the image url.  Save the image to your Web server and supply the URL to the image in this field.  Accepted formats are .jpeg, .jpg, and .gif companyname Required
Images – These attributes provide links to images for a product            
  other image url Other Image URL1 – Other Image URL3 The URL for additional images of your product.

These images will be shown on the detail page when the customer clicks through to see other views associated with the product.  For example, you can use this field to show the label information or packaging of your product. Upload additional images with different views to the item, or with some emotional surrounding as additional image.

A valid URL, including leading “http://”

The url is case sensitive, so make sure to use matching capitalization and no redirections (e.g. .jpeg instead of .jpg). While a web browser might be smart enough to locate your image despite of these little inaccuracies, our image collection process isn’t.

companyname Optional
  swatch image url Swatch Image URL The URL where an image of a color swatch from the product is located. Images should have 72-pixels-per-inch resolution and be 30 pixels maximum length (on the longest side). The preferred file format is JPEG (.jpg). When naming your image, please use the following convention: Product SKU + View Indicator (i.e., .swatch) + File Extension (i.e., .jpg). An example would be: “15774.swatch.jpg”. Save the image to your Web server and supply the URL to the image in this field. companyname Optional
Variation – Populate these attributes if your product is available in different variations (for example color or wattage)            
  parent child Parentage Defines the product within a relationship with another, similar product. 

The “parent” defines the basic data about the product. Parent products are not purchasable; the “parent” product simply specifies the attributes of the product that are common among all of its children and only acts as a place holder.  The “child” products define the possible variations (i.e., size, color) of the parent product and represent the items that are actually for sale.

This field is required if any of the following columns are populated: variation theme, color, paper size, maximum expandable size, line size.  If the product does not participate in a variation relationship, use the value “child.”

For further information about how to construct a product variation, please refer to this template’s “Example” tab.

Please select one of the following values: parent
child
parent Preferred
  parent sku Parent SKU If the product is a child product, list the SKU of the parent product which is related.  DO NOT FILL IN THIS FIELD FOR PARENT PRODUCTS. An alphanumeric string; 1 character minimum in length and 40 characters maximum in length. 10162513 Preferred
  relationship type Relationship Type Describes the relationship between products that are related. Accessories can be seen on the www.amazon.com site as “Also Recommended” selections on certain detail product pages.  Use this field to create an accessory relationship. Select one of the following options:
Accessory
Variation
Accessory Preferred
  variation theme Variation Theme Describes the parameter(s) by which the parent product may vary.  The value input for this field should be the same for both the parent and child SKUs. Example: If the product varies by size, input the value Size. If the product varies by color, input the value Color.   Terms used for variation themes are created by you the merchant. (e.g. ‘count’ can be any number that you choose). Select and applicable variation theme. Size/Color Preferred
Basic – These are attributes that are important to buyers and should be populated for all your items. Some are required to create an offer.            
  product description Product Description A text description of the product.  If you see #### signs where you should see the text, clear the format of the cell. This can be done by clicking Edit in main menu, select Clear & then Formats. A text string; 2000 characters maximum in length. Note: Type 1 High ASCII characters (®, ©, ™, etc.) or other special characters are not supported. Long sleeve v-neck cardigan with a ribbed waistline and pockets with bow detailing Preferred
  model Style Number If applicable, please submit the style number for the product. For most products, this will be the manufacturer’s unique number that identifies the product; may also be referred to as model number. Style number will be required if you are using Global Catalog ID (GCID) as your source for product-id An alphanumeric string up to a maximum of 40 characters in length. SB-122 Optional
  update delete Update Delete Specifies the type of operation (Update, PartialUpdate or Delete) to be done on the data provided. If left blank, the default behavior is “Update.”  Use “Update” whenever you are changing any field in the existing product’s information, including reducing the inventory to 0.  Only use “Delete” when you wish to remove a product completely and permanently from the catalog.

After you have established a SKU for a product, please do not try changing it without first deleting the associated product from our systems through a delete feed.

Select one of the following options: Update, PartialUpdate, or Delete. Update Optional
Discovery – These attributes have an effect on how customers can find your product on the site using browse or search            
  bullet point Key Product Features1 – Key Product Features5 Brief descriptive text, called out via a bullet point, regarding a specific aspect of the product. These display directly under or next to your product photo, it is useful to put interesting information in these fields. Bullet points will be inserted automatically. An alphanumeric string; 500 characters maximum length per bullet point. Please do not include an actual bullet point object, just the text used to describe your product. Note: Type 1 High ASCII characters (®, ©, ™, etc.) or other special characters are not supported. Dry clean only

Imported

Moisture-wicking

Preferred
  generic keywords Search Terms A word or phrase that best describes the product. While Amazon will automatically have the item’s title and brand in the search index, these additional search terms help locating the product when customers perform keyword searches on our site. It is in your best interest to make use of these additional search terms. An alphanumeric string; 1 character minimum in length and 1000 characters maximum in length. Electric Preferred
Ungrouped – These attributes create rich product listings for your buyers.            
  closure type Closure Type The closure type of the product. An alphanumeric string; 1 character minimum in length and 50 characters maximum in length. Zip Preferred
  collar style Collar Type Describes style of men’s dress shirt. Please refer to the valid values tab for a list of standard fit values. Please fill this field out with one of those values. Not using the appropriate valid values can possibly result in your items not appearing in browse and search. Use the column CollarType in the Valid Values list. An alphanumeric string; 50 characters maximum. Button-down Preferred
  color map Color Map If the colour used to describe the product is nonstandard (e.g., sage), include the standard colour you wish to map to (e.g., green).  If no values are provided, customers will be unable to browse by colour. Please see the Valid Values worksheet for the list of accepted values. Green Preferred
  fit type Fit Type For denim pants, indicates the fit style. Select a value from the Valid Values worksheet. Relaxed Optional
  neck size Neck Size The neck size. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 11.5 Optional
  neck size unit of measure Neck Size Unit Of Measure Specifies what unit of measure you are using for the pet’s neck size measure Select one of the following options: MM, CM, M, IN, FT CM Optional
  neck style NeckStyle Describes the cut or shape of the neckline or collar on all items except men’s dress shirts. Use the column NeckStyle in the Valid Values list. An alphanumeric string; 50 characters maximum. v-neck Optional
  pattern type Pattern Style Describes the pattern on shirts and other clothing types. Select a value from the Valid Values worksheet. Stripes Preferred
  size map Size Map A size value that we may choose to use as a refinement for our customers. Please see the Valid Values worksheet for the list of accepted values. Large Optional
  special size type Special Size Type Any size modifier appropriate to the product. Select a value from the Valid Values worksheet. tall Optional
  sleeve length Sleeve Length What is the sleeve length of this product? A number with up to 10 digits allowed to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 29 Optional
  sleeve length unit of measure Sleeve Length Unit Of Measure The units of measurement for the sleeve length. Select one of the following options: CM or IN. CM Optional
  sleeve type Sleeve Type Describes details of sleeve. Select a value from the Valid Values worksheet. Short Sleeve Preferred
  special features Additional Features Used to store features that are highly product specific. Select a value from the Valid Values worksheet. Wrinkle-Free Preferred
  style name Style The industry name for the style for this item.  Use this to describe the Drive style of a tool or accessory. Select from the list of valid values. Modern Preferred
Dimensions – These attributes specify the size and weight of a product            
  website shipping weight Shipping Weight The weight of the product when packaged to ship. This is displayed on the product page and used to calculate shipping costs for weight-based shipping, if available. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 2.33, 20.75, or 10000.00 Optional
  website shipping weight unit of measure Website Shipping Weight Unit Of Measure The unit of measure used to describe the weight of the product when packaged to ship, expressed in grams or kilograms.

*** Required when ShippingWeight is provided.

Select one of the following options:
GR
KG
OZ
LB
LB Optional
  item weight unit of measure Item Weight Unit Of Measure The unit of measure used to describe the weight of the product, expressed in grams, kilograms, ounces, or pounds.  Required if item-weight is provided. Select one of the following options: GR, KG, OZ, or LB. Do not include the actual weight, which will be collected in the item-weight field. OZ Optional
  item weight Item Weight The weight of the product. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 2.33 Optional
  item length unit of measure Item Length Unit Of Measure The unit of measure used to describe the dimensions (width, length, height) of the product, expressed in centimeters, meters, inches, or feet. Required if item dimensions are provided. Select one of the following options: MM, CM, M, IN, or FT. FT Optional
  item length Item Length The length of the product. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 15000 Optional
  item width Item Width The width of the product. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 10.33 Optional
  item height Item Height The height of the product. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. Please do not use commas. 5.5 Optional
Compliance – Attributes used to comply with consumer laws in the country or region where the item is sold            
  cpsia cautionary statement Cpsia Warning Select from the following Valid Values:
choking hazard balloon
choking hazard contains a marble
choking hazard contains small ball
choking hazard is a marble
choking hazard is a small ball
choking hazard small parts
no warning applicable
Use this field to indicate if a cautionary statement relating to the choking hazards of children’s toys and games applies to your product.  These cautionary statements are defined in Section 24 of the Federal Hazardous Substances Act and Section 105 of the Consumer Product Safety Improvement Act of 2008.  They must be displayed on the product packaging and in certain online and catalog advertisements.  You are responsible for determining if a cautionary statement applies to the product.  This can be verified by contacting the product manufacturer or checking the product packaging.   Cautionary statements that you select will be displayed on the product detail page.  If no cautionary statement applies to the product, select “no warning applicable”. choking hazard balloon Optional
  cpsia cautionary description CPSIA Warning Description Do not use this field, unless instructed to do so by Amazon. An alphanumeric string; 1 character minimum in length and 250 characters maximum in length. no warning applicable Optional
  fabric type Fabric Type List all fabrics, separated by /, and % of each from most to least. Always add “viscose” or “rayon” if listing bamboo, and “azlon” if listing soy. Correct: “100% soy from azlon” or “90% cotton/10% rayon.” Incorrect: “50% bamboo and 50% soy” or “cotton/poly.” An alphanumeric text string; 1 character minimum and 50 characters maximum. 90% cotton/10% rayon Preferred
  import designation Import Designation If made in US from imported materials select “Made in USA and Imported.” If some units are from US and some imported select “Made in USA or Imported.” If made in US from US materials select “Made in USA.” If made outside the USA, select “Imported.” Imported;
Made in USA or Imported;
Made in USA and Imported;
Made in USA
Made in USA or Imported Optional
  prop 65 Consumer Notice Use this field to tell customers if your product is subject to Prop. 65 rules and regulations. Prop. 65 requires merchants to provide California consumers with special warnings for products that contain chemicals known to cause cancer, birth defects, or other reproductive harm if those products expose consumers to such materials above certain threshold levels. For more information, please visit this web site: http://www.oehha.ca.gov/.

You are responsible for (a) determining whether a product requires a Prop. 65 warning and (b) ensuring that the proper warning is provided. If you want to auto-populate the product detail page of a product with a link to the Prop. 65 warning page found in the Help pages on the Amazon.com web site (Help > Ordering > Search Tips & Product FAQ’s > California Proposition 65), you can do so by setting the value in this field to “true.” Note that the default value for this is “false,” so if you do not populate this field, this auto-population will not occur.
IF YOU CHOOSE TO USE THIS FUNCTIONALITY BY SETTING THE VALUE OF THIS FIELD TO “TRUE,” YOU ARE AGREEING (A) TO USE THE CONTENT OF THE RESULTING PROP. 65 WARNING MESSAGE “AS IS” AND (B) THAT AMAZON IS NOT LIABLE TO YOU IN ANY WAY IN THE EVENT THAT THIS WARNING MESSAGE DOES NOT PROVIDE THE PARTICULAR WARNING REQUIRED BY LAW FOR YOUR PRODUCT.

Select ‘true’ if your product is subject to this rule TRUE Optional
Fulfillment – Use these columns to provide fulfillment-related information for either Amazon-fulfilled (FBA) or seller-fulfilled orders.            
  fulfillment center id Fulfillment Center ID Amazon-fulfilled products: For those merchants using Amazon fulfillment services, this designates which fulfillment network will be used. Specifying a value other than ‘DEFAULT’ for fulfillment center id will cancel the Merchant-fulfilled offering.  Resubmitting with a blank or ‘DEFAULT’ value for the fulfillment center id, along with quantity, will switch the item back to Merchant-fulfilled. 
Merchant-fulfilled products: Do not enter fulfillment center id, as it is not applicable.
AMAZON NA, DEFAULT AMAZON NA Optional
  package height Package Height The height measurement of the package. If you are an FBA seller and are using a non-default value for fulfillment center id, package height is required and must be populated. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. 10 Optional
  package width Package Width The width measurement of the package. If you are an FBA seller and are using a non-default value for fulfillment center id, package width is required and must be populated. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. 10 Optional
  package length Package Length The length measurement of the package. If you are an FBA seller and are using a non-default value for fulfillment center id, package length is required and must be populated. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. 10 Optional
  package length unit of measure Package Length Unit Of Measure The unit of measure used to describe the dimensions (width, length, height) of the package expressed in inches, centimeters, or feet. Required if package dimensions are provided. Select from the following valid values:
IN
FT
MM
CM
M
IN Optional
  package weight Package Weight The weight of the package. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. 10 Optional
  package weight unit of measure Package Weight Unit Of Measure The unit of measure used to describe the weight of the package, expressed in kilograms, ounces, or pounds. Required if package weight is provided. Select from the following valid values:
OZ
LB
GR
KG
OZ Optional
Offer – These attributes are required to make your item buyable for customers on the site            
  list price Manufacturer’s Suggested Retail Price Manufacturer’s suggested retail price or list price for the product. This is not the same as the offering price, which is specified in the item-price field. Manufacturer’s suggested retail price. This is not the price that Amazon customers will pay for your product. 259.99 Optional
  condition type Item Condition A numerical entry that indicates the condition of the item. Review the condition guidelines definitions. Used; Like New
Used; Very Good
Used; Good
Used; Acceptable
Collectible; Like New
Collectible; Very Good
Collectible; Good
Collectible; Acceptable
New
New Optional
  condition note Condition Note Descriptive text explaining the actual condition of the item. A text string; 1,000 characters maximum in length. In original package Optional
  product tax code Product Tax Code Amazon.com’s standard code to identify the tax properties of a product. Enter the product tax code supplied to you by Amazon.com. A GEN NOTAX Optional
  fulfillment latency Fulfillment Latency Indicates the time, in days, between when you receive an order for an item and when you can ship the item.  The default leadtime-to-ship is one to two business days. Use this field if your leadtime-to-ship is greater than two business days. Indicates the time, in days, between when you receive an order for an item and when you can ship the item.  The default is one to two business days. Use this field if you expect to take longer than two business days.  5 Optional
  product site launch date Launch Date Specify the Date for when this item can launch on the site (this applies only to you product uploads after you have launched).  For upload and testing purposes, set this date to a date at one year into the future.  When you perform the final upload, use previous day’s date. A date in this format: yyyy/mm/dd. 8/18/2013 Optional
  merchant release date Release Date The first date on which you can deliver a pre-orderable product (one that has never been available prior to this date) to a customer. Date in this format: yyyy-mm-dd 38108 Optional
  restock date Restock Date This is the date that a merchant will be able to ship any back-ordered items to a customer. A date in this format: yyyy-mm-dd. 2004-05-01 Optional
  sale price Sale Price The sale price at which the merchant offers the product for sale, expressed in local currency.  The site will strikethrough the product’s standard price and indicate that the item is on sale at the sale price. You can place your listings on sale by entering a sale price (expressed in local currency) along with start and end dates. 219.99 Optional
  sale from date Sale Start Date The date that the sale price will begin to override the product’s standard price. A date in this format: yyyy-mm-dd. 12/2/2011 Optional
  sale end date Sale End Date The last date that the sale price will override the item’s normal price; the product’s standard price will be displayed afterwards. A date in this format: yyyy-mm-dd. 12/2/2014 Optional
  max aggregate ship quantity Max Aggregate Ship Quantity Indicates the maximum number of these same items that can be shipped together in the same package. A positive integer. 10 Optional
  item package quantity Package Quantity Number of products included in an ASIN. This specifically refers to what typically is referred to as an “each” or unit of sale.

Examples:
1 bag of 8pk socks:  item-package-quantity = 1
5 Bags of 8pk Socks:  item-package-quantity = 5

A positive whole number. 1 Optional
  number of items Number of Items A whole number The number of items that are included in the product 6 Preferred
  offering can be gift messaged Offering Can Be Gift Messaged If you can print a gift message with the item indicate that here.  If left blank, defaults to ‘false’. Select: true or false TRUE Optional
  offering can be giftwrapped Is Gift Wrap Available If you can gift wrap an item indicate that here.  If left blank, defaults to ‘false’. Select: True or False False, True Optional
  is discontinued by manufacturer Is Discontinued by Manufacturer Indicates whether the manufacturer has stopped making the item. Select: true or false TRUE Optional
  missing keyset reason Registered Parameter A value provided during the Merchant registration process. Do not input a value when not known. A value provided during the registration process. Do not input a value when not known. PrivateLabel Optional
  max order quantity Max Order Quantity Maximum number of items that can be ordered The maximum quantity of the product that a customer may purchase in one order 10 Optional