Batch upload product explanation + practice

If the seller has many products and finds it troublesome to list them individually, they can consider uploading them in batches. Taking the US site as an example, we will explain in detail how to upload listings in batches in the form of pictures and text.

1. Log in to the backend

Enter the seller backend, move the mouse to INVENTORY, and click "Add Products via Upload".

2. Download the inventory file

The download path is relatively simple. The overall path is: "Add Products via Upload" → "Download an Inventory File" → "Inventory Files". In "Inventory Files", the seller finds the template corresponding to the category to be uploaded (as shown in Figure 2 below). Then download the template to the computer. The downloaded template is generally in EXCEL format and contains a total of 6 documents.

3. Get a general understanding of the role of the 6 documents

The six EXCEL tables in the batch upload template are: Instructions, Images, Data Definitions, Template, Example and Valid Values.

• Instructions: Operation guide, which provides a basic introduction to the entire batch table.

• Images: Image requirements, that is, the requirements for uploading all images.

• Data Definitions: Data definition, which explains each field of the entire bulk upload template.

• Template: Template. That is, the batch upload template. Sellers need to use this template and fill in the required content such as product title, price, UPC, image link, etc. into the template. At the same time, the format of this batch upload template is fixed and sellers cannot modify it at will.

• Example: Amazon provides a case demonstration of uploading a template, which sellers can refer to if needed.

• Valid Values: Valid values.

4. Interpretation of the Data Definitions table

The Data Definitions table is worth a look for sellers. It explains each field of the Template document in detail. By reading this table, sellers can know the requirements and points to pay attention to when uploading products in bulk.

The Data Definitions table is divided into seven columns: A, B, C, D, F, E, and G. Below, we will explain each column.

• Column A is Group Name: group name.

• Column B is Field Name: Field Name. Refers to the field name of the batch upload template, such as item_sku, Product ID, etc. in the figure above.

• Column C is Local Label Name: Local label name, which is actually the same as column B, and refers to another field name of the Template document, such as the Seller SKU, Product ID, etc. field names in the figure above.

• Column D is Definition and Use, which explains the definition of each field name of Template (bulk upload template) in detail. As shown in the figure above, there are also definitions and explanations for field names such as item_sku and Product ID.

• Column E is Accepted Values: valid values, that is, the acceptable range of values ​​filled in the field name of the Template (bulk upload template), that is, the acceptable content. For example, the field "external_product_id" can be filled in with "Any valid GCID, UPC, or EAN", that is, any valid GCID, UPC or EAN code can be filled in "external_product_id".

• Column F is Example: Amazon provides examples of what can be filled in each field name.

• Column G is Required. It refers to whether there is a requirement to fill in this field. There are three items here: Required is a mandatory item, Preferred is a priority item, and it is recommended that the seller fill it in, and Optional is optional.

5. Template batch upload template upload steps

After understanding the "Data Definitions" table, the next step is for sellers to use Template (bulk upload template) to upload products.

As mentioned above, sellers download templates based on the product categories they sell. Therefore, the format and content of the Template (bulk upload template) are different for different categories. This article takes the Template (bulk upload template) of mobile phone cases as an example.

Enter the required information as required by the Data Definitions.

In this form, the two fields Field Name and Local Label Name, if they are bold fields, are required. As shown below:

In addition, in the mandatory field, the "main_image_url" column is where you need to fill in the main image address. Sellers can process the image first, and then upload it to a space on the Internet. After the image is successfully uploaded, the seller finds the image, right-clicks the mouse and clicks "Properties" to obtain the image address, and then copies the image address to the "main_image_url" column of the corresponding product. See the figure below.

In addition, if the seller needs to upload other pictures, he can also use the same method to put the picture address in other_image_url1 - other_image_url3. As shown below.

6. Check the form

After filling all product information into the Template (bulk upload template), sellers can use the "Check Inventory File" function on the "Upload Your Inventory File" page to check the entire template. The system will initially determine whether there are any errors in your form. See the figure below.

After the seller selects the file type and the file to be checked and fills in the email reminder, click "Check Inventory File" to check. If there is an error, the system will prompt a processing report. The seller can download the report and make changes according to the report mark prompts.

7. Upload the form

After the initial check, the seller continues to upload the form on the "Upload your inventory file" page. As shown in the figure below, select the corresponding file type, file upload, and email reminder.

8. Download Error Handling

After uploading the form, sellers can switch to the "Monitor Upload Status" page to view the latest batch upload results and download error handling reports.

Sellers can find the error report document in the backend search bar. Each error code corresponds to a different error message. By comparing, sellers can modify the information filled in a certain field.