Bulk Update Your Products

What is a Bulk Upload Sheet?

If you have a large quantity of products to be uploaded or updated, you may use a Bulk Upload sheet to add/edit your product information. The information is filled up via a Microsoft Excel Sheet. The Bulk Upload sheet is especially useful for you to update your product’s prices and stocks as well as adding or removing products.

NOTE : This feature is more effective if you have a large quantity of products that you would like to add/edit. It may be easier to add/edit your products from your dashboard if you have a small number of products.

Below is an image of the Bulk Upload Template.

 

Updating new products via a Bulk Upload Sheet

1. Download a Bulk Upload sheet filled with your existing product information so that you can update any product information of your choice more efficiently and conveniently. To retrieve your Bulk Upload Sheet, click on Products , then Bulk Upload Products‘. Please read the the instructions given. Next. click on here‘ at the end of the first sentence on “How to bulk update existing products”.

 

2. You will receive an email attached with your Bulk Upload sheet in Microsoft Excel form. Download your Bulk Upload sheet.

 

3. Your product information that were initially filled when uploading your products would appear under Columns A to Column Y. Column A (Product ID) should be left undisturbed as it is essential for your product update.

Columns in Red are mandatory to fill, while columns in Green are optional.

Rows 4 and 5 provide more details on the column definition and how to fill them up while Row 6 provides an example for your reference.

 

4. Once you have completed updating your product information, save it and ‘choose file’ to select the file to upload onto your Dropee dashboard. Then click on Upload‘.

5. You will receive a summary on the numbers of products that were successfully updated. For products that were invalid, you may download the details of the error in order to make your corrections on the recently updated Bulk Upload sheet in order to validate them. Click on ‘Download Now‘ to do so.