Guides
Export your workspace
Everything Puntjes holds for your business can leave with you: at any time, on every plan, at no charge. The button on your account page hands over your customer base at once; every other category is yours by asking, and this page is the register of what that means and in which formats.
How to get it
- Open your account page in the admin portal and go to the Export your customers panel.
- Press Export my customers. Puntjes builds the file in the background, so you can close the page. For anything beyond your customer base, mail the address the panel names.
- You get an email at the address of your login when it is ready, usually within minutes.
- Download it from your account page. Sign in first: the archive holds your customers' personal data, so the link works only for an admin of your workspace.
An archive stays available for seven days and is removed after that. You can ask for one export per hour, and your account page shows the latest one. Only an admin of the workspace can ask; a member cannot. An archive we build because you asked for it by mail follows the same rules once it is ready.
What is in the archive
The archive is a zip. Every file in it is one JSON array, in UTF-8, with dates written as
ISO 8601 and amounts in cents. Field names are the ones the API uses, so a
client that already reads the API reads the archive too. manifest.json names every file with its
row count, the moment the export was made, and which of the two you asked for.
What the button gives you
One file: your customer base. That is what a shop asks for when it wants its customers back, and it is the only thing the account page hands over on its own.
| File | What it holds |
|---|---|
customers.json | Your customers with their identifiers, the loyalty-card code, and the consent to marketing email with when and how it was given or withdrawn. Anonymised customers are not in it, since nothing about them is left. |
What you get by asking
The eighteen files below are yours as well, free of charge. Mail the address on your account page and we build the full archive for you, within thirty days at the latest. We ask by mail rather than by button because these files hold your logins, your invoices and the history of who changed what, and almost nobody needs them until they are leaving.
| File | What it holds |
|---|---|
wallets.json | The points balance of every customer. |
ledger_entries.json | Every movement of points, with its type, the balance after it and the transaction that caused it. |
transactions.json | Every purchase, with its line items, the location, and the points it earned. |
rewards.json | Your rewards, with stock and validity, deleted ones included and marked. |
redemptions.json | Every reward a customer redeemed, with its code and status. |
vendor.json | Your business profile: names, contact details, VAT number, invoice address, the settings of your programme, and your own sending domain when you set one. |
addresses.json | The addresses of your locations, with the coordinates we found for them. |
branches.json | Your locations, with the external id your systems use for each. |
users.json | The logins on your workspace: name, email address, role and language. Never a password. |
products.json | Your products, deleted ones included and marked as such. |
earn_rules.json | Your earn rules and the history of changes to them. |
campaigns.json | Your campaigns and their schedule, deleted ones included and marked. |
campaign_awards.json | The points a campaign awarded on a purchase. |
campaign_moment_awards.json | The points a campaign awarded on a moment such as a birthday. |
campaign_vouchers.json | The vouchers campaigns handed out, with their code and whether they were used. |
invoices.json | The invoices Puntjes sent you: number, date, amount and status. |
api_clients.json | Your API clients: id, label and location. Never a secret. |
audit_log.json | Who changed what in your workspace, and when. |
After you cancel
Cancelling does not remove your data. Your workspace stays until the end of the period you paid for and the retention period after it, and you can ask for an export for as long as it does. How long that is, and what is removed at the end of it, is on the page about your data. If you want your data gone sooner, you delete your account and workspace from your account page.