Inventory Loader File UK Template

and the definitions

1 = ASIN
2 = ISBN
3 = UPC
4 = EAN|3|Desired|
|price|The price at which the merchant offers the product for sale, expressed in the local currency. The price should be greater than 0. Do not include thousands separators or currency symbols. This is a required field if product-id is provided.|A price greater than 0. Do not include thousands separators or currency symbols.|249.99|Desired|
|minimum-seller-allowed-price|This optional field helps Amazon to identify potential pricing errors with your listings. To use this service, enter your minimum allowable price for this product. If you attempt to set your price for the product below your minimum allowable price, your offer will become inactive and you will be notified via email. You can always change your minimum allowable price by modifying the value in this field and uploading the updated file to Amazon.|To remove the minimum-price value for an item, enter the value "delete" in this field. Do not enter 0 or other numeric values.|150.00|Desired|
|maximum-seller-allowed-price|This optional field helps Amazon to identify potential pricing errors with your listings. To use this service, enter your maximum allowable price for this product. If you attempt to set your price for the product above your maximum allowable price, your offer will become inactive and you will be notified via email. You can always change your maximum allowable price by modifying the value in this field and uploading the updated file to Amazon.|To remove the maximum-price value for an item, enter the value "delete" in this field. Do not enter 0 or other numeric values.|299.99|Desired|
|item-condition|A numerical entry that indicates the condition of the item. Please select a value from the list.
This is a required field for new listing.|1 - Used, Like New
2 - Used, Very Good
3 - Used, Good
4 - Used Acceptable
5 - Collectible, Like New
6 - Collectible, Very Good
7 - Collectible, Good
8 - Collectible, Acceptable
9 - Not used
11 - New|1|Desired|
|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 merchant-fulfilled items. If left blank when first submitting the product information, the item will be displayed as "Out of stock."
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).

This is a required field if product-id is provided.|A whole number.|0, 100, or 12142|Desired|
|add-delete|Indicate with an ‘a’ those listings you wish to update/add to your current inventory. A value of ‘d’ will reduce the listings inventory to 0 but the listing details will remain in the system. Indicate with a value of ‘x’ the listings which you wish to completely delete from your current inventory and all product information for these listings will be completely removed and cannot be recovered once removed. If no value is provided for this field, the record will be applied as an update/add.|a = (update/add)
d = (delete)
x = (completely from system)|a|Desired|
|will-ship-internationally|Select the code corresponding to your choice.|3 = UK Only
4 = UK and Europe
5 = UK, Europe, and North America
6 = Worldwide|3|Desired|
|expedited-shipping|Please provide the expedited shipping option that you offer for this item.

If you do not offer any expedited shipping options for this item, leave this cell blank.|3 = UK Only
N = None, no express delivery offered|3|Desired.|
|item-note|You can use this field to describe any differences your item might have from the New item sold at Amazon. This field is limited to 2000 characters for all Used, New, Collectible, and Refurbished items appearing as Amazon Marketplace listings.|Any string up to 2000 characters.|Slightly worn on the edges.|Desired|
|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_EU, DEFAULT|AMAZON_EU|Required for Amazon-fulfilled products.|
|merchant-shipping-group-name|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.|Heavy Bulky Products, “CN ShunFeng Delivery”|Desired|
|product_tax_code|Amazon standard code to identify the tax properties of a product|Enter a product tax code from the list supplied to you by Amazon. If no entry is provided, the item will default to your seller-defined default product tax code. If you want to delete a previous value leave it blank.|A_FOOD_GEN|Desired|
|handling-time|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. Should not have more than one value. Should not have range of days or word “days” at the end.|A positive integer|3, 5, or 10|Optional|
|batteries_required|Please indicate whether batteries are required to use the product.|Select one of the following options: true or false.|Yes|MANDATORY IF “Fulfillment_Center_ID” = ‘AMAZON_NA’|
|are_batteries_included|Please indicate whether batteries are included with the product.|Select one of the following options: true or false.|Yes|MANDATORY IF “Batteries_Required” is TRUE|
|battery_cell_composition|Specify the cell composition of battery in the product.|What type or composition is the battery?|lithium_ion|MANDATORY IF “Are_Batteries_Included” is TRUE|
|battery_type|Please refer to the Valid Values worksheet. Only use this when PowerSource is ‘battery’|Specify the type of battery in the product.|battery_type_lithium_ion|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Variants)|
|number_of_batteries|Any integer greater than or equal to zero|Any integer greater than or equal to zero|3|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Variants)|
|battery_weight|Number up to 10 digits and 2 decimal points long.|Number up to 10 digits and 2 decimal points long.|150|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Variants)|
|number_of_lithium_ion_cells|Total number of Lithium cells (of type "Ion") in the product, where the cell isn’t contained in an encased battery.|A positive whole number.|4|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Variants)|
|number_of_lithium_metal_cells|Total number of Lithium cells (of type "Metal") in the product, where the cell isn’t contained in an encased battery.|A positive whole number.|4|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Variants)|
|lithium_battery_packaging|Describe how the lithium batteries are packaged.|Select from one of the following: batteries_only\nbatteries_contained_in_equipment\nbatteries_packed_with_equipment|batteries_contained_in_equipment|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Variants)|
|lithium_battery_energy_content|Watt hours of each battery (or cell) in unit|number|2|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Ion Variants) OR OPTIONAL IF “Battery_Cell_Composition” (Lithium Metal Variants)|
|lithium_battery_weight|This is the weight in gms of lithium contained in each "metal" cell or battery or in the case of rechargeable batteries it is the "equivilent lithium content" expressed in grams, in each ion cell or battery.|A positive whole number.|2|MANDATORY IF “Battery_Cell_Composition” IN (Lithium Metal Variants) OR OPTIONAL IF “Battery_Cell_Composition” IN (Lithium Ion Variants)|
|supplier_declared_dg_hz_regulation1-supplier_declared_dg_hz_regulation5|Common products can be regulated as dangerous goods (e.g. nail polish, aerosols, cleaning products). For more information, refer to the help pages.|Common products can be regulated as dangerous goods (e.g. nail polish, aerosols, cleaning products). For more information, refer to the help pages.||MANDATORY IF “Fulfillment_Center_ID” = ‘AMAZON_NA’|
|hazmat_united_nations_regulatory_id|Specify the four digit United Nations Transportation Number that identifies hazardous substances in the framework of international transportation. String with the first two characters ‘UN’ and the last four characters numbers between 0001- 3518|Specify the four digit United Nations Transportation Number that identifies hazardous substances in the framework of international transportation|UN3218|MANDATORY “Supplier_Declared_DG_HZ_Regulation” = ‘transportation’|
|safety_data_sheet_url|Holds link to the externally hosted SDS (Safety Data Sheet), also known as MSDS (Material Safety Data Sheet), for an item. This is hosted by the manufacturer or distributor, so that it will always be up-to-date and correct.|Holds link to the externally hosted SDS (Safety Data Sheet) for an item|http://www.sigmaaldrich.com/MSDS/MSDS/DisplayMSDSPage.do?country=US&language=en&productNumber=84985&brand=ALDRICH&PageToGoToURL=http%3A%2F%2Fwww.sigmaaldrich.com%2Fcatalog%2Fproduct%2Faldrich%2F84985%3Flang%3Den|MANDATORY IF “Supplier_Declared_DG_HZ_Regulation” = ‘ghs’ OR OPTIONAL IF “Supplier_Declared_DG_HZ_Regulation” IN (‘transportation’,‘storage’,‘waste’,‘not_applicable’,‘other’,‘unknown’)|
|item_weight|The unit of measure used to describe the weight of the product, expressed in grams or kilograms. *** Required when ItemWeight is provided.|A number with up to 10 digits to the left of the decimal point and up to 2 digits to the right of the decimal point. Please do not use commas.|2.33, 20.75, 10000.00|MANDATORY IF “Supplier_Declared_DG_HZ_Regulation” IN (‘transportation’,‘storage’,‘waste’,‘ghs’,‘other’,‘unknown’)|
|item_volume|Indicates the volume capacity of a product.|Describe the volume of the item|12|Optional|
|flash_point|Enter the flashpoint temperature. Do not include modifier; unit is based on your response in the Temperature Units column of the template.|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.|180|Optional|
|ghs_classification_class1-ghs_classification_class3|The class and category assigned by the Global Harmonized System (GHS) CLP classification system of chemicals.|Global Harmonized System (GHS) CLP classification system.|[{class:Explosive,subcategory:Liquid}]|MANDATORY IF “Supplier_Declared_DG_HZ_Regulation” = ‘ghs’ OR OPTIONAL IF “Supplier_Declared_DG_HZ_Regulation” IN (‘transportation’,‘storage’,‘waste’,‘not_applicable’,‘other’,‘unknown’)|
|item_weight_unit_of_measure|The unit of measure used to describe the weight of the product without shipping material.|The unit of measure used to describe the weight of the product without shipping material.|KG|MANDATORY IF “item_weight” is used|
|item_volume_unit_of_measure|overall volum of an item|overall volum of an item|milliliters per second|MANDATORY IF “item_volume” is used|
|lithium_battery_energy_content_unit_of_measure|Indicate unit of measure if Lithium Battery Energy Content is populated|Indicate unit of measure if Lithium Battery Energy Content is populated|watt hours|MANDATORY IF “lithium_battery_energy_content” is used|
|lithium_battery_weight_unit_of_measure|Select the unit of measure for Lithium Battery Weight . If Lithium Battery Weight is used, you must also enter theLithium Battery Weight Unit Of Measure.|Select the unit of measure for Lithium Battery Weight . If Lithium Battery Weight is used, you must also enter theLithium Battery Weight Unit Of Measure.|grams|MANDATORY IF “lithium_battery_weight” is used|
|battery_weight_unit_of_measure|Unit of measure used to describe the battery weigh|Unit of measure used to describe the battery weigh|gr or kg|MANDATORY IF “battery_weight” is used|
|list_price|Die unverbindliche Preisempfehlung vom Hersteller oder einem autorisierten Wiederverkäufer für die jeweilige Markplatz Webseiten.|Ein Preis größer als 0 mit bis zu zwei Dezimalstellen nach dem Komma. Verwenden Sie keine Währungssymbole oder Tausendertrennzeichen.|59.99|Optional|
|uvp_list_price|Die unverbindliche Preisempfehlung vom Hersteller oder einem autorisierten Wiederverkäufer für die jeweilige Markplatz Webseiten.|Ein Preis größer als 0 mit bis zu zwei Dezimalstellen nach dem Komma. Verwenden Sie keine Währungssymbole oder Tausendertrennzeichen.|59.99|Optional|