Bulk Uploading Products

This page explains how to upload your Bulk Upload Excel Template into the Dashboard. To download the Template and be guided on how to use the Template, you can visit the Bulk Upload Template Guide.

Uploading Into Dashboard

After saving your spreadsheet in .xls or .csv format, you can now upload into the Dashboard.

1. Click on ‘Bulk Upload’ in the Products listing page
2. Click to select and upload the saved spreadsheet, or drag it into the upload box.
3. After processing the records, a table will be displayed with two tabs

   1. Successful tab:

      The records in this tab are products that are successfully processed and validated. You can choose to edit each row and save changes.

   2. Invalid tab:

      This tab displays the Excel row numbers of records that failed to be uploaded because of certain issues it might have. If any records are invalid, you can still proceed to save and create the products that were successful.

What To Do If Records Are Invalid

If any records are invalid, you will have to re-upload a new excel sheet using the Template. Look through the invalid records and check for these:

1. All mandatory fields are inputted
2. Product image URL is a valid link
3. All inputs are in the correct formats (e.g only numbers in Price, Discount Value, Promo price columns)
4. Promo price value is less than the Normal price value

Using the Bulk Upload Excel Template, fill in the data of the invalid records again, making sure the inputs satisfy the requirements above. Save and upload into the Dashboard again for the fixed records to be saved.

FAQ:

1. Where can I find the Bulk Upload Excel Template?