Import Sales Order

Reference Number: Reference number of a sales order.
Multiple items under a sales order can be imported, which are grouped under a single reference number.
Multiple sales orders can be imported, which are grouped under different reference numbers.
Location Name: Sale location name.
Device Name: Stock transferred to location name.
Navigation: Main Menu --> Account & Settings --> Licences --> Name
Employee Username: Employee’s user name under whose name the sale should be assigned.
Item Name: Name of the item variation.
SKU: SKU of the item variation.
Item Quantity: Quantity of stock sold.
MRP: MRP of the item variation.
Price: Selling price of the item variation.
Tax: Tax component of the item variation. If an item has multiple tax components, separate tax components with comma. For example tax1,tax2,tax3.
Payment Method Name: Mode of payment.
Cash
Credit
Cheque
Card
Split
Online
No Sale
Phonepe
Google Pay
UPI
Paytm
Swiggy
Zomato
Other
Card Details: Last 4 digits of Credit / Debit number.
Customer Code: Code of the customer. The customer should exist in the backend to be used here.
Navigation: Main Menu --> Customers
Created Date: Sale Date YYYY-MM-DD
Batch Id: Batch ID of the item sold.

Note: Columns names marked with RED colour in Download Sample XL sheet are mandatory fields.

Updated on: 06 / 10 / 2021