×
Bulk Upload Categories & Products

SalesPlay 'Back Office' > Main Menu > Products

Was this helpful?

⚠️ Important Guidelines Before Uploading

To avoid errors and ensure a smooth upload, please follow these rules:

  • Create categories first &ndash, The category names you enter in the CSV must match exactly with the ones already created in your POS system (case-sensitive).
  • Clear formatting &ndash, If copying data from Excel or Google Sheets, use &ldquo,Clear Format&rdquo, to remove hidden styles or characters.
  • No duplicate product codes &ndash, Every product must have a unique product_code.
  • Error messages &ndash, If something goes wrong, the system will show the row, column, and issue.
  • Shop-specific format &ndash, The CSV file is unique to each shop. Don&rsquo,t reuse the same file for other shops.
  • No emojis or special characters &ndash, Avoid using emojis, symbols (%, &,, @, etc.), or quotes in any fields.
  • Don&rsquo,t change headers &ndash, The CSV has 30 column headers. Do not rename, delete, or move them. Just fill in what you need.
  • Max 2000 rows per file &ndash, If you have more than 2000 products (e.g., 5500), split them into multiple CSV files.
  • Trim spaces &ndash, Remove extra spaces at the beginning or end of product names, codes, or prices.
  • Correct number format &ndash, Prices and stock values should be plain numbers (no currency symbols).
  • Don&rsquo,t leave key fields blank &ndash, At minimum, fill in the 5 basic columns (see below).
  • Correct file type &ndash, Save the file as CSV UTF-8 (Comma delimited).
  • Using non-English language? &ndash, Make sure to save the file as CSV UTF-8 (Comma delimited) to avoid upload errors.
  • Try a test upload &ndash, If you&rsquo,re new to this, try uploading 5 products first to make sure everything works.

1. Login POS Back Office > Select “ Products” from main menu > Go to the “Product list” > Click “ Import” button

 ,

  1. Click on &ldquo,Download template file&rdquo, and download CSV file

2. Note : If you are using other language please use the CSV UTF-8 (Comma delimited) (.csv) template.


3. Open the CSV File and enter relevant fields (sample has done for you)


4. Open the CSV File and enter relevant fields (sample has done for you)


5. After entered details Save the file


6.Click “Drag and drop files” area and upload the saved CSV file


7. Click “UPLOAD” button

 ,

  1. Click &ldquo,Confirm Import&rdquo, button

(Once the bulk upload completed, those products will be shown in Back Office products list section)

Was this helpful?

Still need help?