Exporting Orders
Export your Lemon Squeezy store’s orders.
A store’s orders can be exported at any time via the “Export” button on the Orders page.
The generated CSV file will be emailed to the store owner’s email address.
The CSV file contains the following columns:
| Column name | Notes |
|---|---|
identifier | Lemon Squeezy ID (only used internally) |
order_number | The order’s numerical ID (displayed in your dashboard, receipts, and Customer Portal) |
product_name | The name of the product purchased |
variant_name | The name of the product variant purchased |
user_name | The customer’s full name |
user_email | The customer’s email address |
city | The city entered at checkout (legacy field) |
country | The two-letter code of the country chosen at checkout (e.g. “DE”) |
postal_code | The postcode entered at checkout |
card_brand | The lowercase name of the card brand (e.g. “mastercard”, “amex”). Will be empty for non-card payments |
card_last_four | The last four digits of the card. Will be empty for non-card payments |
currency | The currency displayed at checkout (payments are always made in USD) |
currency_rate | The exchange rate used at checkout to display in your store’s currency, in decimal format (e.g. “7.75”). Will be “1” if currency is USD |
subtotal | The price of the product, in USD cents (e.g. $10 will be “1000”) |
discount_total | The total discount amount applied to the order, in USD cents (e.g. $10 will be “1000”) |
tax | The tax total of the order, in USD cents (e.g. $10 will be “1000”) |
total | The total charged to the customer, in USD cents (e.g. $10 will be “1000”) |
tax_name | The type of tax added to the order (e.g. “VAT”, “GST”, “Sales tax”) |
tax_rate | Tax rate percentage, in decimal format (e.g. “7.75”, “0”) |
tax_number | Optional tax number added by the customer at checkout |
date_utc | When the order was placed, in UTC |