Bulk Update Products

SHOPLINE_All-Plan.jpg

 

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

_____2018-01-03___1_12_24.jpg

 

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.

bulk_update_EN.png

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.

bulk_update_email_EN.png

 

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

 

d. Price:

you can change the regular price, sale price of the main product and the price of variations

Note 1: 
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.

Note 2: 
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

 

f. SKU:

you can edit product and variation SKU

 

g. location ID

you can edit location ID


h. 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). 
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.

bulk_update_V2_EN.png

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.

 

*Please be noted that if there is any failed result, do not upload the failure report for update, please export the latest update file instead.

Have more questions? Submit a request

Comments