Articles on: Upload/Import Files

Import Sales Order

Import Sales Order


  1. 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.
  1. Location Name: Sale location name.
  2. Device Name: Stock transferred to location name.

Navigation: Main Menu --> Account & Settings --> Licences --> Name

  1. Employee Username: Employee’s user name under whose name the sale should be assigned.
  2. Item Name: Name of the item variation.
  3. SKU: SKU of the item variation.
  4. Item Quantity: Quantity of stock sold.
  5. MRP: MRP of the item variation.
  6. Price: Selling price of the item variation.
  7. Tax: Tax component of the item variation. If an item has multiple tax components, separate tax components with comma. For example tax1,tax2,tax3.
  8. Payment Method Name: Mode of payment.
  • Cash
  • Credit
  • Cheque
  • Card
  • Split
  • Online
  • No Sale
  • Phonepe
  • Google Pay
  • UPI
  • Paytm
  • Swiggy
  • Zomato
  • Other
  1. Card Details: Last 4 digits of Credit / Debit number.
  2. Customer Code: Code of the customer. The customer should exist in the backend to be used here.
  3. Navigation: Main Menu --> Customers
  4. Created Date: Sale Date YYYY-MM-DD
  5. 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

Was this article helpful?

Share your feedback

Cancel

Thank you!