# Import Sale

### <span id="bkmrk-import-sale-1">Import Sale</span>

To add bulk sales to the system, you can use this feature.

### <span id="bkmrk-steps-to-import-sale-1">Steps to import sale:</span>

[![image.png](https://docs.senangurus.com/uploads/images/gallery/2025-10/scaled-1680-/ljKimage.png)](https://docs.senangurus.com/uploads/images/gallery/2025-10/ljKimage.png)

Go to Sale &gt; Import Sale.

Click the ‘Download Template’ button to download the template file.

Once downloaded, open it and add the required details. While adding the details follow the instructions mentioned on the import sale page itself.

Save the excel file and upload it by clicking the choose file button and pressing submit button.

**NOTE:** It may display some error after uploading if some data added in the excel file are not as per mentioned in the instructions.

Change it accordingly and proceed.

### <span id="bkmrk-%E2%80%9Cgroup-sell-line-by%E2%80%9D-1">“Group sell line by” field in import sale:</span>

While importing an Excel file for import sale you have to select the option “**Group Sell Line By**“.

<div class="fusion-text fusion-text-1" id="bkmrk-this-field-is-used-f"><div aria-labelledby="message-username-1154644158938628126 uid_1 message-content-1154644158938628126 uid_2 message-timestamp-1154644158938628126" aria-roledescription="Message" aria-setsize="-1" class="message-2CShn3 cozyMessage-1DWF9U groupStart-3Mlgv1 wrapper-30-Nkg cozy-VmLDNB zalgo-26OfGz" data-list-item-id="chat-messages___chat-messages-1154643497287168080-1154644158938628126" role="article" tabindex="-1"><div class="contents-2MsGLg"><div class="markup-eYLPri messageContent-2t3eCI" id="bkmrk-this-field-is-used-f-1">This field is used for the system to know which lines need to be in a single sale.</div></div><div class="buttonContainer-1502pf"><div aria-label="Message Actions" class="buttons-3dF5Kd container-2gUZhU isHeader-2bbX-L" role="group"><div class="buttonsInner-1ynJCY wrapper-2vIMkT"><div aria-expanded="false" aria-label="More" class="button-3bklZh" role="button" tabindex="0">  
</div></div></div></div></div></div>For example, if you add an **Invoice\_Number** column in the Excel import file, then all lines from one sale will have the same **Invoice\_Number**.

In this case, you need to select **Invoice\_Number** option in the **“Group Sell Line By”** dropdown field.

### <span id="bkmrk-%E2%80%9Cyou-cannot-select-a-1">“**You cannot select a field twice**” Issue and Solution:</span>

You may encounter this issue while you import an Excel file using the Sale Import feature.

This issue happens when the same option name is chosen for multiple columns in the import table

[![](https://ultimatefosters.com/wp-content/uploads/2023/02/importsale1-300x140.png)](https://ultimatefosters.com/wp-content/uploads/2023/02/importsale1.png)

If you want to remove any column during import, you can select the **SKIP** option in the dropdown.