Teach you how to upload products in bulk and merge variations quickly

Teach you how to upload products in bulk and merge variations quickly

The latest tutorials on bulk uploading products


1. How to download the bulk upload form


1. Log in to the backend and click Inventory - Upload products in batches.



2. After entering this page, you can see the three major sections for batch uploading products. Then you will select the product category and download the inventory file.



3. After selecting the advanced mode, click "Generate Template" to download the latest batch upload template.



2. How to upload products using templates


The editor here only explains all the required attributes and important optional attributes in the table . Please read the text in the picture carefully~


Sellers need to use the XX template to list products and fill in the required content such as product title, price, UPC, image link, etc. into the template.



The format of this bulk upload template is fixed and sellers cannot modify it at will.


Note: The content to be filled in can refer to the values ​​in the values ​​form


Figure 1:



Please be careful when filling in the product title, because if the Amazon listing is old, the title will be locked by the system, which makes it difficult to modify. It is recommended that you think it through before writing it down.


Example 1:



Figure 2:



Example 2:



Figure 3:



Example 3:



Figure 4:



Images can be batch-linked for easier uploading, or they can be manually uploaded in the background.


Figure 5:



Example 5:



Figure 6:



Example 6:



Figure 7:



Example 7:



Figure 8:



Figure 9: If you are not sure about the filling indicators for uploading the variation template form, you can first add the sub-products individually in the background, and then fill them in the variation.

  


Example 9:



Friends who don’t understand can fill in the forms one by one according to the pictures, so it’s less likely to make mistakes.


3. How to upload a template


1. Save the filled form as tab-delimited text



2. Return to the bulk upload product page in the seller backend



3. The system has a special checking function, which will prompt you if there are errors in the form.

  


4. After the initial check, continue to upload on the "Upload your inventory file" page. As shown in the figure below, select the corresponding file and click " Upload ".



5. After the upload is successful, you can download the report in this interface. If there is an error in the form, it will be clearly marked in the report and you can modify it according to the error report.





How to quickly merge variants



Above we talked about how to upload products in batches using a table. Now let’s talk about how to add or merge variants when there are already variants or no variants.


Next, I will show you the specific operation process.


1: Table Merge Variant


1. See the inventory - upload products in batches.



2. Select a category and download the form


In the list of all product categories, select the detailed category of the listing products you want to merge. You can also enter keywords in the search box to search for categories. After finding them, click Select and go to Step 2: Select the template type.


Note: If you are not sure about your product category, you can refer to one of the corresponding listings in your background, click Edit, and look at the first item VitalInfo-Recommended Browse Nodes (here is your product category node), and make your selection accordingly.


3. After selecting the advanced mode, click "Generate Template" to download the latest batch upload template.



4. How to fill in the downloaded template


Fill in all required fields for the parent product , such as SKU, brand name, Product Name, Manufacturer, etc.



5. How to fill in Variation



Parent_child: write Parent for the parent body and child for the child body;

Parent Sku: The parent is not filled in, the child fills in the parent's SKU;

Relationship Type: parent is not filled in, child is filled in variation;

Variation Theme: color/size: Fill in according to your product requirements;

Update Delete: If the parent product is uploaded for the first time, fill in Update, and the child product fill in PartialUpdate.


6. Other matters needing attention


Please fill in other information in the form carefully to avoid errors when uploading.


Also, when uploading a product, if there is a " Variation " in the product category, it means that the category supports variations. If there is no variation, you can choose a similar category with variation to upload. After the upload is successful, change it to the category you need in the Amazon backend.


2. Manually merge variants


First, we also need to go to the backend page and click: Inventory Add new product .



Then, click Create new variation in the bottom right corner .



Once you have successfully entered the variation creation page, select the first option to add or update an existing variation relationship, then enter the parent ASIN of the existing variation.   or one of its descendant ASINs .



Fill in basic attribute informationselect variant category   Click Save to download the fully automatically generated variation table.



Then click Download to get the form.


Note: After the sub-body is successfully put on the shelf, you can generate a template with one click, which contains the information of all products. If there is a need to update later, you can directly use the table for batch processing~



The last step of uploading templates is the same as batch uploading.


There is no variant relationship yet. If you need to merge them into variants, you can use a table.
If there is an existing variant relationship and you need to add a new one, you can use a table or manually.


Choosing a solution that suits you can not only reduce the error rate of data filling, but also improve work efficiency.


Two tips for creating variants



1. All sub-products can have different prices. For example, for products of different colors, even if the purchase cost is the same, the best-selling color should be set to a medium price to create a price ladder . When customers search for the variant product, they will see a certain price range. This can also boost the sales of products with some colors that are not easy to sell.


2. If Amazon sellers want a certain color of product to be the picture on the main interface, they should set that color to the one with the lowest price, because the picture of the product with the lowest price will be automatically displayed on the main interface. If the prices of all colors are the same, the picture on the main interface will be randomly captured.


The role of creating variants




1. Bring traffic and conversion



Variants can give consumers more choices and attract their attention to a certain extent. At the same time, variants can also extend the time consumers spend browsing the product page. For every extra second of stay time, the probability of purchase may increase, thereby improving the conversion rate of traffic.



2. Optimize the ranking of your listing



Amazon will give a higher ranking to listings with variations. If you have a product without variations, but other sellers have variations, Amazon will push the product with variations to the front, because products with variations have more attributes than those without variations, which will increase the product's exposure to a certain extent, and the ranking advantage will also increase the product's click-through rate.



3. Rapidly accumulate reviews



For example: If you have some abandoned links and the product is no longer produced, but there are still some reviews, you can combine the abandoned listing with the product listing you are promoting. Then, the inventory of the abandoned listing is adjusted to zero, and it will not be displayed on the front end, but the reviews and Q&A will be combined, and the total number and rating will increase.


However, this method has certain risks. If you forcefully merge variants in violation of the rules, you may be caught by Amazon and your account may be blocked. The following points are minefields that will explode if you step on them. You must avoid them:


1. Do not force upload of categories that do not support uploading variations just for the sake of review.

2. Bundle unrelated products together to create variations.

3. Product color batch updates, added and replaced sub-bodies are not added by uploading new SKUs, but directly modifying the content and replacing the images in the existing variant information.

4. The categories filled in by the parent and child are inconsistent

5. Forced merging of zombie listings


<<:  Daily Sharing (September 9)

>>:  What are the common and alternative routines and methods for Amazon keyword research?

Recommend

What is Bain Capital? Bain Capital Review

Bain Capital was founded in 1984 and is a global a...

What is sunhilltoy? sunhilltoy review

sunhilltoy focuses on designer toys, collectibles,...

Amazon's Q3 net profit of 10 billion boosts stock price

Everyone, please check whether the storage capaci...

What is Ulmart? Ulmart Review

Ulmart is Russia's largest e-commerce company,...

What is eClincher? eClincher Review

eClincher enables you and your team to accelerate ...

US retail sales increased 8.5% year-on-year in January! Demand for furniture and home furnishings soared!

<span data-shimo-docs="[[20,"获悉,根据美国零售联合会(...

What is Shopdeca? Shopdeca Review

Shopdeca is an Indonesian e-commerce platform that...

The shipment was rejected?! Something went wrong with FBA!

Just at the end of March, there was a very importa...

What is KeyworX? KeyworX Review

Keyworx is a tool for tracking products based on k...

What is a variant? Splitting and merging variants

<span data-shimo-docs="[[20,"一、什么是亚马逊变体&qu...

What is LivingSocial? LivingSocial Review

LivingSocial is located in Washington, D.C. It was...

What is PPC Scope? PPC Scope Review

PPC Scope is a tool designed for Amazon PPC advert...