You can export orders for your accounting, move the voucher data to another site, or bring in gift cards you already sold.
Export orders as CSV
Open the Export as CSV tab under Orders (or Tools → Export Orders (CSV)), choose the Order date (Last month, This month, All time or your own dates), the Payment status and the Format, and click Download CSV. Choose Excel Europe for the semicolon format that Excel opens straight into columns in most European languages.
Move vouchers to another site
- On the old site click Export Database under Orders. You get a JSON file with the vouchers and their activity.
- On the new site click Import Database under Orders, choose the JSON file and import it. The data is merged into that site.
Import orders from a CSV file
Open Tools → Import Orders, choose your CSV file and click Import. Save the file as UTF-8. The first row is treated as a header and skipped. The columns must be in this order:
Id, Order type, Template ID, Item category ID, Item ID, Buying for, From name, To name, Amount, Message, First name, Last name, Email, Address, Postcode, Payment method, Shipping, Shipping email, Shipping method, Expiry, Voucher code, Voucher PDF link, Order date, Status, Payment status, Language, Phone
The file from Export as CSV has a different column layout, so it cannot be imported as it is.
- A row with the payment status Paid gets its balance at once.
- A row with an empty voucher code gets a new code.
- A row is skipped when its code is invalid, already in use or repeated in the file. The page tells you how many rows were skipped. A code has 4 to 40 letters, digits or hyphens.
Gift cards that are already printed
To add a few printed cards, use a manual order and enter the code from the card in Existing card code (optional). The card and the order then share one balance. For many cards, use the CSV import with the printed codes in the Voucher code column.