When you are switching from another system and maintain sales on the excel file, you can use this feature by importing a bulk sales using excel file.
Go to Sale > 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 the submit button.
Change it accordingly and proceed.
Common Error:
It may display some error after uploading if some data added in the Excel file is not as mentioned in the instructions.
While importing an Excel file for import sale you have to select the option "Group Sell Line By".
This field is used for the system to know which lines need to be in a single sale.
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 the Invoice_Number option in the “Group Sell Line By” dropdown field.
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
If you want to remove any column during import, you can select the skip option in the dropdown.
Last updated
