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?|
|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.
|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
|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:
|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
|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:
|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.||15000||Optional|
|item width||Item Width||The width of the product.||10.33||Optional|
|item height||Item Height||The height of the product.||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.
|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:
|package weight||Package Weight||The weight of the package.||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:
|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
Collectible; Like New
Collectible; Very Good
|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.
|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|
Copyright naeemrajani.com, Contact +923002556165 - Digital Marketing Agency