How to mass import product from excel

Created by Yee Sin Lum, Modified on Tue, 20 Sep 2022 at 05:12 AM by Yee Sin Lum

Go to backend and login

Go to items>product information

Click on import

Tick the boxes accordingly (if unsure, just tick all)

Select whether to replace existing item information. (select yes to update product information according to barcode number)(select no when creating new item)

Click on select to select your files

Click on upload to complete the upload

Wait for the upload to finish. If upload fail, it will prompt an error message below

You can click on download import template to get a template excel and fill it up accordingly.

Note: The max amount of item you can upload at a time is 1500.

Note: The file must be in xls format and less than 3m

Note: The barcode number should only be filled with Numbers (you can add a few alphabet and a dash. Eg. S1000-1)

Note: You need to filled up all compulsory field(you can fill up stock and cost price as zero if you do not require them)

Note: Ensure all prices field and stock amount are in number format.


May use the file format we attached below.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article