# Import Products

<span style="font-size:14pt;">Importing Products – Step-by-Step Guide</span>
----------------------------------------------------------------------------

### Step 1: Open Import Page

1. Go to **Products** in the menu.
2. Click on **Import Products**.

![](https://billing.admin.defy.com.fj/media/eljin-kumar/XPOS/Import%20Product/Import%20Product.png)

### Step 2: Download the Template

1. Download the **import template file**.
2. 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.

![](https://billing.admin.defy.com.fj/media/eljin-kumar/XPOS/Import%20Product/Download%20Template%20File.png)

### Step 3: Fill in Product Details

1. Enter all product information under the correct columns.
2. Follow the format mentioned in the template for each field.

### Step 4: Upload the File

1. After completing the file, upload it using the **Import** option.
2. Wait for the system to process the file.

![](https://billing.admin.defy.com.fj/media/eljin-kumar/XPOS/Import%20Product/Submit%20import%20product%20.png)

<span style="font-size:14pt;">Common Import Errors and How to Fix Them</span>
-----------------------------------------------------------------------------

### Error 1: “UNIT not found”

**Reason:**  
The unit mentioned in the Excel file does not exist in the system.

**Solution:**

1. Go to **Products → Units**.
2. Add the required unit.
3. Re-upload the import file.

### Error 2: “The separation symbol could not be found”

**Reason:**  
The expiry date format is incorrect.

**Solution:**

1. In Excel, select the **expiry date column**.
2. Change the cell format to **Text**.
3. Enter the date in this format:  
    **MM-DD-YYYY** (example: `11-25-2018`)
4. Save the file and import again.

<span style="font-size:14pt;">Handling Unclear or Unexpected Errors</span>
--------------------------------------------------------------------------

Sometimes the system may show unclear errors such as:

- “Non-numeric value encountered”
- Other undefined import errors

### Best Practice to Resolve This

1. Split your Excel file into smaller files.
2. For example:
    
    
    - If you have **500 products**, divide them into **two files of 250 products each**.
3. Import each file separately.

This helps identify problematic records and reduces system errors.<span style="font-size:14pt;"></span>