How to use the Inventory Loader 如何使用库存加载工具

The Inventory Loader can be used to create or update listings for products that are already in the Amazon catalog. If
you wish to list a product that is not yet listed in Amazon catalog, use a category-specific inventory file, which you 库存加载工具可用于为亚马逊目录中已有的商品创建或更新商品信息。如果您想要发布尚未在亚马逊目录中发布的商品，请使用特定于分类的库存文件，您可以从以下页面下载该文件：
can download from the below page:
[Link] [Link]

How to use this file 如何使用此文件

1. Review the tabs in this file to learn what the attributes are used for, which attributes are required, and what are 1. 查看此文件中的选项卡，了解属性的用途、哪些属性是必填的以及每个属性的可接受值。
the acceptable values for each attribute.
2. Add your listing data to the ‘template’ tab. 2. 将您的商品信息数据添加到“模板”选项卡。
3. Column headers in yellow are required. You must provide a value in these columns for your listing data to be 3. 带有黄色标题的列为必填字段。您必须在这些列中提供一个值，以便亚马逊能够成功处理您的商品信息数据。
successfully processed by Amazon.
4. Column headers in orange are recommended. Listings that are missing a recommended attribute may result in 4. 带有橙色标题的列为建议字段。缺少建议属性的商品信息可能会导致商品信息质量较差，且/或使买家难以找到您的商品。例如，如果未为商品价格提供值，依然可以在亚马逊目录中创建您的商品信息，但买家无法在
poor listing quality, and/or make your product hard for customers to find. For example, if a value is not provided for 亚马逊网站上搜索到您的商品信息。
price, your listing can be created in the Amazon catalog, however will not be searchable by buyers on the Amazon
website.
5. Column headers in white are optional. Optional columns may or may not apply to your listing, or may reference 5. 带有白色标题的列为可选字段。在发布商品信息以供销售时，可选列可能会（也可能不会）适用于您的商品信息，或者可能引用有用但并非关键的信息。我们建议您填写适用于您的商品的所有可选单元格。 在某些情
information that is useful, but not critical, when offering a product for sale. We encourage you to fill all optional cells 况下，标有“可选”的字段可能对您的业务至关重要。
that apply to your products. In some cases, fields that are labeled ‘optional’ may be crucial to your business.

6. Save your file as a tab-delimited text file (.txt). 6. 将您的文件另存为制表符分隔的文本文件 (. txt)。

7. Visit [Link] where you can upload your tab-delimited text file. By
7. 访问 [Link]
uploading your file, you confirm submission of your listing data to the Amazon catalog.

Important information 重要信息

Inventory Quantity: Do not provide a value in the ‘quantity’ column for items that are fulfilled by Amazon. The 库存数量： 对于亚马逊配送的商品，请勿在“数量”列中提供值。“数量”列应仅适用于卖家自配送的 SKU。亚马逊配送的 SKU 的库存数量将取决于亚马逊运营中心接收的商品数量。如果您在“数量”列中为亚马
quantity column should be used only for seller-fulfilled SKU’s. The inventory quantity for Amazon-fulfilled SKU’s will 逊配送的 SKU 提供了值，它们将转换为卖家自配送。
be determined by the number of items received at the Amazon fulfillment center. If you provide a value in the
‘quantity’ column for SKU’s that are fulfilled by Amazon, they will convert to seller-fulfilled.
Learn more 了解更多信息
How to complete your InventoryLoader template
Label Name Definition and Use Accepted Values Example Required
sku A unique identifier for the product, assigned by the An alphanumeric string; 1 character minimum in length 15700
merchant. The SKU must be unique for each product and 40 characters maximum in length. Required
listed.
product-id A standard, alphanumeric string that uniquely identifies The product-id must have a specific number of characters 012345678912
the product. This could be a UPC, EAN or ISBN. This is a according to type: UPC (12 digit number), EAN (13 digit
required field if product-id-type is provided. number) or GTIN(14 digit number). Please ensure that
leading zeros do not get lost when the file is exported from
excel to text. This can be accomplished by formatting the
numbers in these cells as text, and double checking Desired
your .txt file to ensure that no errors have occurred while
exporting your file.

product-id-type The type of standard, unique identifier entered in the Please select one of the following: 3
product-id field. This is a required field if product-id is 1 = ASIN
provided. 2 = ISBN Desired
3 = UPC
4 = EAN

price The price at which the merchant offers the product for A price greater than 0. Do not include thousands 249.99
sale, expressed in U.S. dollars. The price should be separators or currency symbols.
greater than 0. Do not include thousands separators or
currency symbols. This is a required field if product-id is Desired
provided.

minimum-seller-allowed-price This optional field helps Amazon identify potential pricing To remove the minimum-price value for an item, enter the 150.00
errors with your listings. To use this service, enter your value "delete" in this field. Do not enter 0 or other numeric
minimum allowable price for this product. If you attempt values.
to set your price for the product below your minimum
allowable price, your offer will become inactive and you
Desired
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.

maximum-seller-allowed-price This optional field helps Amazon identify potential pricing To remove the maximum-price value for an item, enter the 299.99
errors with your listings. To use this service, enter your value "delete" in this field. Do not enter 0 or other numeric
maximum allowable price for this product. If you attempt values.
to set your price for the product above your maximum
allowable price, your offer will become inactive and you
Desired
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.

item-condition A numerical entry that indicates the condition of the 1 - Used, Like New 1
item. Please select a value from the list. 2 - Used, Very Good
This is a required field for new listing. 3 - Used, Good
4 - Used Acceptable
5 - Collectible, Like New
6 - Collectible, Very Good
7 - Collectible, Good Desired
8 - Collectible, Acceptable
9 - Not used
11 - New

quantity Merchant-fulfilled products: Enter the quantity of the A whole number. 0, 100, or 12142
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, Desired
submit fulfillment-center-id in a separate column (see
data definition for details).

This is a required field if product-id is provided.

add-delete Indicate with an 'a' those listings you wish to update/add a = (update/add) a
to your current inventory. A value of 'd' will reduce the d = (delete)
listings inventory to 0 but the listing details will remain in x = (completely from system)
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 Desired
record will be applied as an update/add.

will-ship-internationally Select the code corresponding to your choice: "1" or "n": "1" or "n" = Will ship in US only 1
Will ship within US only; "2" or "y": Will ship to "2" or "y" = Will ship to international locations Desired
international locations.

expedited-shipping Please provide a comma-delimited list of all expedited A comma-delimited list including any combination of the "Next, Second"
shipping options that you offer for this item. following: "Domestic, Next"
"Next, Second,
If you do not offer any expedited shipping options for this "Next" (One day) Domestic,
item, leave this cell blank. "Second" (Two day) International"
"Domestic" (Domestic Expedited) "Next, Second,
"International" (International Expedited) Domestic, Plus"
"Plus" (Faster Expedited Domestic: 1 to 3 days. Eligibility Desired
based on performance. See "Learn More" link below.)

N = None, no expedited shipping offered

Learn More
standard-plus Indicate with a "Y" those listings that you wish to offer "Y" = 3 to 5 business days transit time Y
faster Standard shipping (3 to 5 business days). Eligibility "N" = 4 to 14 days transit time
to offer faster transit times is based on performance.
Buyers will see the reduced transit time during checkout Desired
and in the order details of their account.

Learn More
item-note You can use this field to describe any differences your Any string up to 2000 characters. Slightly worn on the
item might have from the New item sold at [Link]. edges.
This field is limited to 2000 characters for all Used, New,
Collectible, and Refurbished items appearing as Amazon Desired
Marketplace listings.

fulfillment-center-id Amazon-fulfilled products: For those merchants using AMAZON_NA, DEFAULT AMAZON_NA
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 Required for Amazon-
quantity, will switch the item back to Merchant-fulfilled. fulfilled products.
Merchant-fulfilled products: Do not enter fulfillment-
center-id, as it is not applicable.

product-tax-code [Link]'s standard code to identify the tax Enter the product tax code supplied to you by A_GEN_TAX
properties of a product. [Link]. If no entry is provided, the item will default
to your seller-defined default product tax code if
configured, otherwise "A_GEN_NOTAX" will be used. If you Optional
want to delete a previous value enter "Default".

handling-time Indicates the time, in days, between when you receive A positive integer 3, 5, or 10
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 Optional
business days. Should not have more than one value.
Should not have range of days or word "days" at the end.

merchant_shipping_group_name For SKUs fulfilled by the Seller, use this field to assign One of the Shipping Template names (string) configured in the Free Shipping
SKUs to a Shipping Template that has been configured in Ship Settings UI Template, Default
the Ship Settings UI. If left blank, new SKUs will be Template
assigned to the Default Template and existing SKUs will
remain assigned to the existing Shipping Template. Optional
Shipping Templates can be used to configure
regionalized ship settings and differentiate ship settings
for different sets of SKUs

batteries_required Please indicate whether batteries are required to use Select one of the following options: true or false. FALSE
the product. MANDATORY IF “FulfillmentCenterID”
= ‘AMAZON_NA’
are_batteries_included Please indicate whether batteries are included with Select one of the following options: true or false. TRUE
the product. MANDATORY IF "BatteriesRequired" 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
"AreBatteriesIncluded" is TRUE
battery_type Please refer to the Valid Values worksheet. Only use this Specify the type of battery in the product. battery_type_lithium MANDATORY IF
when PowerSource is 'battery' _ion "BatteryCellComposition" 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
"BatteryCellComposition" 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
"BatteryCellComposition" IN (Lithium
Variants)

number_of_lithium_ion_cells Total number of Lithium cells (of type \"Ion\") in the A positive whole number. 4 MANDATORY IF
product, where the cell isn't contained in an encased "BatteryCellComposition" IN (Lithium
battery. Variants)

number_of_lithium_metal_cells Total number of Lithium cells (of type \"Metal\") in the A positive whole number. 4 MANDATORY IF
product, where the cell isn't contained in an encased "BatteryCellComposition" IN (Lithium
battery. Variants)

lithium_battery_packaging Describe how the lithium batteries are packaged. Select from one of the following: batteries_only\ batteries_contained_ MANDATORY IF
nbatteries_contained_in_equipment\ in_equipment "BatteryCellComposition" IN (Lithium
nbatteries_packed_with_equipment Variants)
MANDATORY IF
"BatteryCellComposition" IN (Lithium
lithium_battery_energy_content Watt hours of each battery (or cell) in unit number 2 Ion Variants) OR OPTIONAL IF
"BatteryCellComposition" (Lithium
lithium_battery_weight This is the weight in gms of lithium contained in A positive whole number. 2
MANDATORY IF
each \"metal\" cell or battery or in the case of "BatteryCellComposition" IN (Lithium
rechargeable batteries it is the \"equivilent lithium Metal Variants) OR OPTIONAL IF
content\" expressed in grams, in each ion cell or battery. "BatteryCellComposition" IN (Lithium
Ion Variants)

supplier_declared_dg_hz_regulation1- Common products can be regulated as dangerous goods Common products can be regulated as dangerous goods
MANDATORY IF “FulfillmentCenterID”
supplier_declared_dg_hz_regulation5 (e.g. nail polish, aerosols, cleaning products). For more (e.g. nail polish, aerosols, cleaning products). For more = ‘AMAZON_NA’ AND
information, refer to the help pages. information, refer to the help pages. “SwitchFulfillmentTo” = ‘AFN’

hazmat_united_nations_regulatory_id Specify the four digit United Nations Transportation Specify the four digit United Nations Transportation UN3218
Number that identifies hazardous substances in the Number that identifies hazardous substances in the MANDATORY
framework of international transportation. String with the framework of international transportation "SupplierDeclaredDGHZRegulation" =
first two characters 'UN' and the last four characters ‘transportation'
numbers between 0001- 3518

safety_data_sheet_url Holds link to the externally hosted SDS (Safety Data Holds link to the externally hosted SDS (Safety Data http://
Sheet), also known as MSDS (Material Safety Data Sheet) for an item [Link]
Sheet), for an item. This is hosted by the manufacturer m/MSDS/MSDS/
or distributor, so that it will always be up-to-date and [Link]
correct. ?
country=US&langua MANDATORY IF
"SupplierDeclaredDGHZRegulation" =
ge=en&productNum 'ghs' OR OPTIONAL IF
ber=84985&brand= "SupplierDeclaredDGHZRegulation" IN
ALDRICH&PageToGo ('transportation','storage','waste','not_
ToURL=http%3A%2F applicable','other','unknown')
%[Link]
[Link]%2Fcatalog
%2Fproduct
%2Faldrich
%2F84985%3Flang
item_weight The unit of measure used to describe the weight of the A number with up to 10 digits to the left of the decimal 2.33, 20.75,
product, expressed in grams or kilograms. *** Required point and up to 2 digits to the right of the decimal point. 10000.00 MANDATORY IF
"SupplierDeclaredDGHZRegulation" IN
when ItemWeight is provided. Please do not use commas. ('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 A number with up to 10 digits allowed to the left of the 180
modifier; unit is based on your response in the decimal point and 2 digits to the right of the decimal point. Optional
Temperature Units column of the template. Please do not use commas.
ghs_classification_class1-ghs_classification_class3 The class and category assigned by the Global Global Harmonized System (GHS) CLP classification [{class:Explosive,su
Harmonized System (GHS) CLP classification system of system. bcategory:Liquid}] MANDATORY IF
chemicals. "SupplierDeclaredDGHZRegulation" =
'ghs' OR OPTIONAL IF
"SupplierDeclaredDGHZRegulation" IN
('transportation','storage','waste','not_
applicable','other','unknown')

item_weight_unit_of_measure The unit of measure used to describe the weight of the The unit of measure used to describe the weight of the KG MANDATORY IF
product without shipping material. product without shipping material. "item_weight" is used
item_volume_unit_of_measure overall volum of an item overall volum of an item mililiters MANDATORY IF
"item_volume" is used
lithium_battery_energy_content_unit_of_measure Indicate unit of measure if Lithium Battery Energy Indicate unit of measure if Lithium Battery Energy Content watt hours MANDATORY IF
Content is populated is populated "lithium_battery_energy_co
ntent" is used
lithium_battery_weight_unit_of_measure Select the unit of measure for Lithium Battery Weight . If Select the unit of measure for Lithium Battery Weight . If grams MANDATORY IF
Lithium Battery Weight is used, you must also enter Lithium Battery Weight is used, you must also enter "lithium_battery_weight" is
theLithium Battery Weight Unit Of Measure. theLithium Battery Weight Unit Of Measure. 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
california_proposition_65_compliance_type
required if food, furniture or
Optional
This attribute captures information needed from suppliers which iSelect the warning type applicable to your product, if any. You certi Furniture chemical is selected in the
california_proposition_65_chemical_names1 compliance type field. Notor
required if food, furniture
This attribute captures information needed from suppliers which iIf you selected the Food, Furniture, or Chemical warning you must ind
Lead, Acetamide exposed
chemicalifisthey selectinany
selected the of
california_proposition_65_chemical_names2 compliance type furniture
required if food, field. Notor
This attribute captures information needed from suppliers which iIf you selected the Food, Furniture, or Chemical warning you must ind
Lead, Acetamide exposed ifisthey
chemical selectinany
selected the of
california_proposition_65_chemical_names3 compliance
required type furniture
if food, field. Notor
This attribute captures information needed from suppliers which iIf you selected the Food, Furniture, or Chemical warning you must ind
Lead, Acetamide exposed
chemicalifisthey selectinany
selected the of
california_proposition_65_chemical_names4 compliance type field. Notor
required if food, furniture
This attribute captures information needed from suppliers which iIf you selected the Food, Furniture, or Chemical warning you must ind
Lead, Acetamide exposed
chemical is selected in the of
if they select any
california_proposition_65_chemical_names5 compliance type field. Not
This attribute captures information needed from suppliers which iIf you selected the Food, Furniture, or Chemical warning you must ind
Lead, Acetamide exposed if they select any of
List Price Manufacturer's suggested retail price or list price for the Provide the list price for the product not including tax. List 259.99
product. This is not the same as the offering price, which Price is the suggested retail price of a product as provided
is specified in the item-price field by a manufacturer, supplier, or seller. This is not the Optional
offering or cost price. If you are unable to provide a list
price, enter a value of 0
 minimum-seller-allowed-price
sku product-id product-id-type price
maximum-seller-allowed-price
item-condition quantity add-delete
will-ship-internationally expedited-shipping standard-plus item-note
fulfillment-center-id product-tax-code handling-time
merchant_shipping_group_name batteries_required are_batteries_included
battery_cell_composition battery_type number_of_batteries battery_weight
battery_weight_unit_of_measure number_of_lithium_ion_cells
number_of_lithium_metal_cells lithium_battery_packaging
lithium_battery_energy_content
lithium_battery_energy_content_unit_of_measure lithium_battery_weight
lithium_battery_weight_unit_of_measure supplier_declared_dg_hz_regulation1
supplier_declared_dg_hz_regulation2 supplier_declared_dg_hz_regulation3
supplier_declared_dg_hz_regulation4 supplier_declared_dg_hz_regulation5
hazmat_united_nations_regulatory_id safety_data_sheet_url item_weight
item_weight_unit_of_measure item_volume item_volume_unit_of_measure
flash_point ghs_classification_class1 ghs_classification_class2
ghs_classification_class3 california_proposition_65_compliance_type
california_proposition_65_chemical_names1
california_proposition_65_chemical_names2
california_proposition_65_chemical_names3
california_proposition_65_chemical_names4
california_proposition_65_chemical_names5 List Price