The “bulk update products” feature allows you to manage products in large quantity effectively. You can do the following actions to update products:
- 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.
- You can update product data, including:
a. Price: 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 follow the price of the main product.
If you want to set different prices to variations, please uncheck the "all variations have the same price” first.
b. Inventory: 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)
c. Product Cost: you can edit the cost of the main product
d. Product SKU: you can edit the SKU of the main products or variations
e.Publish/ unpublish products: you can change the status of products to published/ unpublished
Please note that the columns that are marked “do not edit” (product ID, product name, SL_Key) should not be edited, or there will be errors in your upload.
- Upload the edited file
- After uploading the file, you can check the updated product details in “bulk import/update preview” page, example as shown in the picture below.
If all information is correct, click the “Confirm Update” button to update your products.
You can also click the “Reupload file” button to re-upload your file if needed.
If there are any problems with the edited file, we will show you the error(s). (e.g.column four is error for negative price ). You will have to revise your file and reupload it.
- You can check the update action progress in "bulk import/update log" after the file is successfully uploaded.