The “bulk update products” feature allows you to manage products in large quantity effectively. You can do the following actions to update products:
1. Download current products information: My products > bulk import/update
In the second section of the bulk import/update page, you can export your existing products (add-on items excluded). You will receive the excel file by email.
Please be noted that a maximum of 500 main products may be updated at once, therefore, the exported file will be split by 500 main products.
Ex. A shop contains 689 main products, you will receive a mail that has 2 update file download links, one with 500 main products, the other with 189 main products.
2. You can update product data, including:
a. Product name (Chinese & English)
you can edit product name
Note: at least one of Chinese or English name is required.
b. Preorder Product
you can set preorder status for product
c. Publish Status
you can set publish status for product
you can change the regular price, sale price of the main product and the price of variations
If you have set “all variations have the same price”, the price of variations will show "same price".
If you want to set different prices to variations, please uncheck the "all variations have the same price” first.
If you have set “hide price”, the price of variations and main product will show "Hide Price".
If you want to change prices, please uncheck the "hide price” first.
e. Product Cost:
you can edit the cost of the main product
you can edit product and variation SKU
g. location ID
you can edit location ID
You can check the current inventory of products in column "Quantity" of your downloaded file but DO NOT EDIT this column.
If you want to change the quantity of the product, please fill the value you want to add or reduce by in column "Update Quantity" (if you want to reduce quantity, remember to put “-” before the value e.g. -10)
Note: if you want to set limited inventory to “unlimited quantity” product, please change “unlimited quantity” to N first, or your edit will not be applied).
Also, the default quantity after you change "unlimited quantity" to N will be the inventory quantity that you have set before changing "unlimited quantity" to Y, so we recommend you change the quantity after the update process.
*Please be noted that the columns that are marked “do not edit” (product ID, SL_Key...etc) should not be edited, or there will be errors in your upload.
3. Upload the edited file
4. You can check the update action progress in "bulk import/update log" after the file is successfully uploaded.
If there are products that can't be successfully updated, you can download the failure report for reference.
If the updated file contains both valid and invalid product, the valid product will still be updated, only the update of invalid product will be blocked.