Hi Viji

Sometimes bulk upload fails even if all conditions seem correct because of hidden formatting issues or minor mistakes in your CSV file. Here are some tips to help:

1. Clear formatting – If you copied data from Excel or Google Sheets, use “Clear Format” to remove hidden styles or characters.

   • In Excel: Select all cells → Home → Editing → Clear → Clear Formats.

2. Fill only the necessary columns – For a quick and simple upload, you only need to fill 5 columns in the CSV file.

3. Check for common issues:

   • Create categories first – Category names in the CSV must exactly match those in your POS (case-sensitive).

   • No duplicate product codes – Each product must have a unique product_code.

   • Trim spaces – Remove extra spaces at the beginning or end of product names, codes, or prices.

   • Avoid emojis or special characters – Don’t use symbols like %, &, @, quotes, or emojis.

   • Correct number format – Prices and stock should be plain numbers (no currency symbols).

   • Don’t change headers – The CSV has 30 column headers; do not rename, delete, or move them.

   • Max 2000 rows per file – Split files if you have more than 2000 products.

   • Shop-specific file – Each CSV is unique to the shop; don’t reuse for other shops.

   • Don’t leave key fields blank – At minimum, fill in the 5 basic columns.

   • Correct file type – Save as CSV UTF-8 (Comma delimited), especially for non-English languages.

Following these steps usually resolves most upload failures. You can also refer to the official guide here: SalesPlay Bulk Upload Help.