How do I update my product information?

Lazada Support Center

There are 2 methods to update product information (eg. Stock, Prices, Description), namely "Single Update", and "Mass/Bulk Upload".

Single update involves making the amendment(s) directly using the Sellercenter interface whereas Mass/Bulk Upload involves importing a file into the system.

Although it is a matter of preference, as both methods can be used for small or large volume of changes, it should be noted that there is definite advantage as to which to use as per volume of SKUs you want to update.

Click below on how to update different types of information:

Update Prices 
- Single Update for Prices
- Mass Update for Prices

Update Stock
- Single Update for Stock
- Mass Update for Stock

Update Products & Other details
- Single Update for Products & Other details
- Mass Update via CSV for Products & Other details
- Mass Update via Excel for Products & Other details



Update Prices

 

Single Update for Prices:

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

Step 2: Here, you can see all your products. You can search for a specific product using the search criteria (ShopSku/SellerSku/Name) or you can filter based on various status (live/best selling etc).

2.png

Step 3: Once you have found the SKU you want to update, refer to "Price" column, and click the 'pencil' icon that appears when you place your cursor over the price. 

Price1.png

 

Step 4: Edit the price, and click save.

save.png

You may do the same steps for Sale Price update.

For Sale Price, you must insert a valid start date. You may leave the end date empty.

 

 

Mass Update for Prices

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

Step 2: Click on "Import".

temp.png

Step 4: Click on "Price" to download the product update template.

dia.png

Step 5: In the Excel file, you may change Price, and SalesPrice as well as its corresponding Start/End date. Please note that date formats are to be YYYY-MM-DD.

ex.PNG

Step 6: After you have done the updates in the Excel file, you may upload it by going back to "Manage Products", and click "Import".

uup.png

Step 7: Click on "Import". Please select the Import Mode as "Update Price". If the Progress column say "Success" then you're done! 

Hist.png

With this file template, and import mode, the only information that will be updated are – Price, SalesPrice, SalesStartDate, SalesEndDate

 

 

Update Stock:

 

Single Update for Stock:

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

Step 2: Here, you can see all your products. You can search for a specific product using the search criteria (ShopSku/SellerSku/Name) or you can filter based on various status (live/best selling etc).

2.png

Step 3: Once you have found the SKU you want to update, refer to "Available" column, and click the 'pencil' icon that appears when you place your cursor over the stock quantity. 

stock1.png

Step 4: Edit the quantity in "allocated stock" field, and click save.

stock2.png

Step 5: After saving, your quantity will be updated!

savestock.png

 

 

Mass Update for Stock

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

Step 2: Click on "Import".

temp.png

Step 4: Click on "Stock" to download the product update template.

dia.png

Step 5: In the Excel file, you may change Quantity.

Step 6: After you have done the updates in the Excel file, you may upload it by going back to "Manage Products", and click "Import".

uup.png

Step 7: Click on "Import". Please select the Import Mode as "Update Stock". If the Progress column say "Success" then you're done! 

Hist.png

With this file template, and import mode, the only information that will be updated is Quantity.

 

 

Update Products & Other details

The mass update for products & other details allow you to update multiple columns of information (including price, stock etc) with one upload. This is extremely useful if for example, you would like to update price, and description at the same time using mass/bulk upload.

Please note that as part of one of the mass update processes involve exporting your products, which is currently in CSV format, it is mandatory that you install Apache OpenOffice

 

Single update for Products & Other details:

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

Step 2: Here, you can see all your products. You can search for a specific product using the search criteria (ShopSku/SellerSku/Name) or you can filter based on various status (live/best selling etc).

2.png

 Step 3: Once you have found the SKU you want to update, refer to the "Actions" column, and mouseover the "Actions" link. You will see a few options for you to choose from. Choose "Edit Details" to edit product information such as description, seller promotion etc.

deta.png

 

Step 4: Here, you may select any "section" of the SKU to edit. 

stage.png

 

Step 5: Click on the Finish stage once you're done editing (or you can click Next until the end)

done.png

 

 

Mass Update via CSV for Products & Other details

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

Step 2: Click on the "Export" button. You will then have the option of selecting the category of the products you want to export. 

export.png

 

Step 3: Click "Download" once the export file has been generated.

exportt.png

Step 4: Open the exported CSV file in OpenOffice. Follow the following format to open the file - Character set: UTF-8, Separator options: Separated by semicolon (;).

 

Step 5: Here you can edit the details you need. You can remove any columns that you are not updating EXCEPT SellerSku. SellerSku is mandatory for mass/bulk upload.

After you have done the updates in the CSV file, just save, and you may upload it by going back to "Manage Products", and click "Import"

uup.png

Mass Update via Excel for Products & Other details

You can use Excel to do a mass/bulk upload but the headers used differ from the Stock/Price Excel templates. You will need to copy the headers from the exported CSV product files. 

Step 1: Click on "Products" tab, then click on "Manage Products."

1.png

 

Step 2: Click on the "Export" button. You will then have the option of selecting the category of the products you want to export. 

export.png

 

Step 3: Click "Download" once the export file has been generated.

exportt.png

Step 4: Open the exported CSV file in OpenOffice. Follow the following format to open the file - Character set: UTF-8, Separator options: Separated by semicolon (;).

 

Step 5: Here you can copy the column headers you need. It must be noted that SellerSku is mandatory for mass/bulk upload.

Step 6: After you have done the updates in the Excel file, you may upload it by going back to "Manage Products", and click "Import".

uup.png

Was this article helpful? 0 out of 0 found this helpful