Exporting Sales Orders
On the overview screen of sales orders, you can export the sales orders. You do this by selecting "import/export" at the top of the list, then clicking on "export orders" and a CSV file will be downloaded.
The following data is exported:
- Connector ID (to link different order lines to one order, important when importing!)
- Shop
- Order number
- Reference
- Status
- Creation date
- Shipping date
- Delivery note
- Customer: Customer number
- Customer: Name
- Customer: Contact
- Customer: Email
- Customer: Phone number
- Customer: GSM number
- Customer: VAT number
- Customer: Shipping address: Name
- Customer: Shipping address: Street 1
- Customer: Shipping address: Street 2
- Customer: Shipping address: Postcode
- Customer: Shipping address: Municipality
- Customer: Shipping address: Province
- Customer: Shipping address: Country
- Tracking number
- Serial numbers
- SKU
- Notes
- Warehouse location
- Batch number
- Expiration date
- Quantity
- Backorder
?> Tip Want to export two statuses (for example, 'in progress' and 'completed')? Then you need to export the entire list and create a filter in the export file.
Making CSV-file readable
The export will place all data in one column. To make the file readable, convert the file into a classic Excel spreadsheet. This can be done in several ways:
- In the CSV file, click on 'data' and then on 'text to columns'. Important here is that you set the delimiter to a comma.
- In the CSV file, click on 'data' and then on 'from text/csv'. You select the file to convert and check the delimiter.
- You use an online conversion tool to convert the CSV file into a readable Excel file