In this article, you'll learn how to export sales data in Plug&Pay. The steps are based on exporting orders, but they work the same way for subscriptions and instalment payments.
Creating an export
To create an export of your orders, navigate to Sales > Orders, choose the type of orders you want to export and optionally set a filter. Then click the Export button.
ℹ️ You can export up to 500 lines at a time. Use the Filter option to split larger datasets into multiple exports.
In the pop-up that appears, you can decide the structure and file format of your export. Click Request export to export the data. The file is emailed to the email address you use to log in to Plug&Pay.
Export by
Order: Each order is exported as one line.
Order line: Each product is exported as a separate line, where an order bump, for example, counts as a separate line.
File format: Choose the desired file type.
Export fields
The data below is included in the export of your orders.
Order number | VAT ID | First name |
Products | Country | Surname |
Quantity | Email address | Street |
Subtotal | Phone | House number |
Shipping costs excl. VAT | Mollie customer ID | Addition |
VAT | SKU | Customer note |
Total | Ledger account | Mollie transaction ID |
Invoice date | ID | Standard VAT |
Payment date | Subscription | Reduced VAT |
Name | Status | Custom field 1 |
Address | Order bump | Custom field 2 |
Postcode | Free product | Affiliate |
City | Labels | Payment method |
Company | Notes | Original order |
Downloading an export
You can download your exports by navigating to the icon in the top right, where you choose Exports.
An overview of your exports appears, where you can download or delete them via the download or bin icon.
