# Import Sales (Invoices)
Importing Sales in XPOS
=======================
The **Import Sale** feature allows you to add **multiple sales records at once** using an Excel file, saving time and manual effort.
1. Steps to Import Sales
-------------------------------------------------------------
### Step 1: Open Import Sale Page
1. Go to **Sales → Import Sale**.
[](https://learn.defy.com.fj/uploads/images/gallery/2026-02/yXGrTYaX7fUtJmX6-screenshot-2026-02-10-131111.png)
### Step 2: Download the Template
1. Click **Download Template**.
[](https://learn.defy.com.fj/uploads/images/gallery/2026-02/n8Ew6rjCJyIuSlk6-screenshot-2026-02-10-131641.png)
2. This file contains the required columns and instructions.
3. Do not rename or remove any column headings.
### Step 3: Fill in Sale Details
1. Open the downloaded Excel file.
2. Enter all sale data as per the instructions shown on the Import Sale page.
3. Ensure values such as dates, product names, quantities, and prices follow the specified format.
### Step 4: Upload the File
1. Save the completed Excel file.
2. Click **Choose File** and select the file.
3. Click **Submit** to import the sales.
2. Handling Import Errors
--------------------------------------------------------------
- If the system shows errors after uploading, it means some data does not follow the required format.
- Review the error message.
- Correct the data in the Excel file.
- Upload the file again.
3. Understanding “Group Sell Line By” Field
--------------------------------------------------------------------------------
The **Group Sell Line By** option tells the system **which rows belong to the same sale**.
### How It Works:
- You must select a column that uniquely identifies a sale.
- All rows with the same value in that column will be grouped into one invoice.
### Example:
- If your Excel file contains an **Invoice\_Number** column:
- All products from the same invoice should have the same Invoice\_Number.
- Select **Invoice\_Number** in the **Group Sell Line By** dropdown.
This ensures the system creates **one sale per invoice number** instead of multiple separate sales.
4. “You Cannot Select a Field Twice” Error
-------------------------------------------------------------------------------
### Cause:
This error occurs when the **same column name is mapped more than once** during the import process.
### Solution:
1. Review the column mapping table.
2. Make sure each field is selected **only once**.
3. Remove duplicate selections.
4. Proceed with the import again.