Import Products

Importing Products – Step-by-Step Guide 
 Step 1: Open Import Page 
 
 Go to Products in the menu. 
 Click on Import Products . 
 
 
 Step 2: Download the Template 
 
 Download the import template file . 
 This template contains all required column names and instructions. 
 
 
 Important: 
 
 Do not delete or rename any column headers. 
 Fill in the data exactly as shown in the template. 
 
 
 
 Step 3: Fill in Product Details 
 
 Enter all product information under the correct columns. 
 Follow the format mentioned in the template for each field. 
 
 Step 4: Upload the File 
 
 After completing the file, upload it using the Import option. 
 Wait for the system to process the file. 
 
 
 Common Import Errors and How to Fix Them 
 Error 1: “UNIT not found” 
 Reason: 
The unit mentioned in the Excel file does not exist in the system. 
 Solution: 
 
 Go to Products → Units . 
 Add the required unit. 
 Re-upload the import file. 
 
 Error 2: “The separation symbol could not be found” 
 Reason: 
The expiry date format is incorrect. 
 Solution: 
 
 In Excel, select the expiry date column . 
 Change the cell format to Text . 
 Enter the date in this format: 
 MM-DD-YYYY (example: 11-25-2018 ) 
 Save the file and import again. 
 
 Handling Unclear or Unexpected Errors 
 Sometimes the system may show unclear errors such as: 
 
 “Non-numeric value encountered” 
 Other undefined import errors 
 
 Best Practice to Resolve This 
 
 
 Split your Excel file into smaller files. 
 
 
 For example: 
 
 If you have 500 products , divide them into two files of 250 products each . 
 
 
 
 Import each file separately. 
 
 
 This helps identify problematic records and reduces system errors.