Follow the steps below on how to import products via bulk import function on the backend.
To bulk import a list of products, access the Product main page and click on Bulk Import Products. There are two types of Product Import Template: Basic Import Template and Advanced Import Template.
Download Product Import Template
(A) Basic Import Template
1. Click on Basic Import Template to download the basic version of product import template.
2. Open up the downloaded basic_product_template.csv. And remove the irrelevant data from the template.
3. Fill up in the columns accordingly.
💡 Any optional columns which do not carry any data can be deleted to enhance data import speed.
For more information on the column details, refer to Product Basic Import Template Columns.
(B) Advanced Import Template
1. Click on Advanced Import Template to download the advanced version of product import template.
2. Open up the downloaded advance_product_template.csv. Remove all irrelevant data from the template.
3. Fill up in the columns accordingly.
💡 Any optional columns which do not carry any data can be deleted to enhance data import speed.
For more information on the column details, refer to Product Advanced Import Template Columns.
Import Template into Backend
1. Save the CSV file once all data has been input into the spreadsheet.
2. Import data
a. Click on Choose File to select the updated CSV file.
b. (or) Drag the downloaded CSV file to the Choose File area, “+” icon will be shown.
c. Click on Begin Import.
3. Once uploaded, users will be directed to this screen.
4. Wait until the Pending status turns Valid.
a. Click on Cancel Import to return to the previous page.
b. Click on Start Import to begin importing the products data in the CSV file.
5. Should there be Invalid status, users must take note of the error messages.
a. Click on Cancel Import to return to the previous page.
b. Users should amend the CSV file according to the remark given.
c. Re-import the CSV file once done.
Users should take note of common error messages during the process of bulk importing products data into backend portal. For more information, refer to Common Error Messages for Bulk Import.
7. Upon successfully importing products, users will be prompted the total number of products imported. Click on Complete to return to the Product main page.
