Export your orders and their invoices
Download, for a period, the list of your orders with the invoice created in your invoicing software, or the reason there is none
To reconcile your sales with your accounts, or to answer your accountant, a connector’s Orders page offers an export: one row per order, with its invoice, and the reason when no invoice was created.
Download the export
- Open the connector’s Orders page.
- Click Export.
- Choose the period, by order date. If the list is filtered on dates, the period starts from those dates. A period covers one year at most.
- Choose the format, Excel (.xlsx) or CSV, then click Download.
Every order received over the period is in the file, including those without an invoice. Orders that no longer exist in your store are not.
The CSV file is UTF-8 encoded and its columns are separated by commas in English (semicolons in the other languages), so that it opens directly in Excel.
The columns
| Column | Content |
|---|---|
| Order number | The order’s number in your store. |
| Order date | The order’s date. |
| Invoice number | The invoice’s number in your invoicing software. Empty for a draft or an order without an invoice. |
| Invoice date | The invoice’s date (see below). |
| Status | Invoice created, Draft, Not created or Deleted. |
| Reason | Why the order has no usable invoice. Empty when the invoice is created. |
The invoice date
For Pennylane, Sellsy, Axonaut, Dolibarr, Odoo, Abby, VosFactures, Qonto and Zoho, it is the document’s date in your software, as shown on the connector’s Invoices page. For the other software, it is the day Order Invoicer created the invoice.
Statuses and their reasons
- Invoice created: the invoice exists in your invoicing software.
- Draft: the document was left as a draft in your software and has no number yet. Finalize it in your software.
- Deleted: the invoice was deleted in your invoicing software.
- Not created: no invoice exists for the order. The Reason column gives the one the orders list shows:
- a creation error, with its explanation, the same as on the order’s page;
- an order excluded from invoicing, or left out by the workflow’s filters (shipping country, tag, customer type or group, zero amount…);
- an order that hasn’t reached the status that triggers the invoice yet (paid, shipped…), or the delay before invoicing;
- a paused connector, a disabled workflow or an inactive subscription;
- otherwise, the order is waiting for its invoice to be created.
One invoice per order
The export gives each order’s invoice. Refund credit notes are not included.