Below are the order fields that can be manually exported, please note that orders cannot be created via an import.
Order Details | |||
Order Total * | Order Date | Total Less VAT | Total Less VAT |
Order VAT |
Order Shipping | Item Code | Reship Code |
Last Updated | Dispatched By | Tracking ID | Status |
Vendor TX Code | Voucher Code | Purchase Reference | Order Type |
Order Weight |
* When downloading the order totals, they will be added to each order line by default, though you can opt to only display on the first product line. This helps spreadsheet sorting.
Product Details | |||
Product Code | Product Brand | Product | Option Code |
Option Weight |
Options | Option Qty | Item Price |
Item Weight | Item Total Weight |
Customer Details | |||
Full Name | Forename | Surname | Email Address |
Cust Tel 1 | Cust Tel 2 | Cust Tel 3 | Delivery Name |
Delivery Address Company | Del Address Line 1 | Del Address Line 2 | Delivery Town |
Delivery County | Delivery Postcode | Delivery County | Billing Address Company |
Billing Address Line 1 | Billing Address Line 2 | Billing Town | Billing County |
Billing Postcode | Billing County | Delivery Notes | Customer Signup Code |
Group Name | Account Customer | Guest Customer |
Filters
You can manipulate your results with the following filter options:
Filter by Status: Incomplete, Open, Processing, Cancelled, Dispatched, Refunded and Reshiped.
Filter by Date: You can specify the from and to date (day, month, & year) for orders downloaded.
Filter by Order Number Range: You can enter your order number range, eg from order number '1000' to order number '1250'.