Skip to Content
Order Invoicer

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

  1. Open the connector’s Orders page.
  2. Click Export.
  3. 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.
  4. 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

ColumnContent
Order numberThe order’s number in your store.
Order dateThe order’s date.
Invoice numberThe invoice’s number in your invoicing software. Empty for a draft or an order without an invoice.
Invoice dateThe invoice’s date (see below).
StatusInvoice created, Draft, Not created or Deleted.
ReasonWhy 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.

On this page