Import, export and reports
Open Import & export in the dashboard. Every import is validated first: you see how many rows would be created, updated or skipped and every error with its row number before anything is written. Finished imports are kept in the import history and their error report can be downloaded as CSV.
CSV rules
- UTF-8 (Excel CSV files with BOM are fine). The delimiter (comma or semicolon) is detected automatically. The first row is the header; header names are case-insensitive and spaces become
_. - Money columns use decimal notation in the order or store currency (
129.99or129,99), not minor units. - Lists (tags, image URLs) are separated with
|,,or;inside the cell. - Booleans accept
true,yes,1,y,tandtak. - Modes: create or update (upsert) or create only (existing records are skipped and reported as warnings).
Products
One row per variant. Rows with the same slug (or the same title when slug is empty) form one product.
| Column | Required | Notes |
|---|---|---|
title | ✓ on the first row of a product | |
slug | Generated from the title when empty; used to find existing products | |
description | HTML or plain text | |
status | draft (default), active, archived | |
vendor, product_type, tags | ||
tax_class | standard (default), reduced, super_reduced, zero | |
option1_name, option1_value … option3_name, option3_value | Variant options, e.g. Size / M | |
sku, barcode | SKUs must be unique within the file | |
price | ✓ | Decimal, ≥ 0 |
compare_at_price, cost | Decimal | |
stock, weight_grams | Whole numbers | |
image_url (or images) | Public http(s) image URLs; added only when the product has no images yet | |
seo_title, seo_description |
Duplicate checks: repeated SKUs in the file and repeated option combinations within one product are reported as errors.
Customers
| Column | Required | Notes |
|---|---|---|
email | ✓ | Matched case-insensitively against existing customers; duplicates in the file are errors |
first_name, last_name, phone, company, vat_id, note | ||
language | pl (default) or en | |
accepts_marketing | Boolean | |
tags | List | |
address_line1, address_line2, address_city, address_postal_code, address_country | Creates a default address when the customer has none; country is a 2-letter code |
Historical orders
Use this to bring order history from another platform. Rows with the same order_ref become one order; each row is one line item. Imported orders are tagged imported and ref:<order_ref>, so importing the same file twice skips orders that already exist. Historical imports never change stock and never send notifications.
| Column | Required | Notes |
|---|---|---|
order_ref | ✓ | Your previous order number |
email | ✓ on the first row of an order | Customer is found or created |
created_at | Date (YYYY-MM-DD or ISO) | |
currency | PLN, EUR or USD (default: store currency) | |
payment_status | Default paid | |
fulfillment_status | Default fulfilled | |
sku or title | ✓ | SKU links the line to an existing variant |
quantity | Default 1 | |
unit_price | ✓ | Decimal |
tax_rate | Percent, e.g. 23 | |
shipping_total, discount_total | Decimal, taken from the first row | |
first_name, last_name, phone, line1, line2, city, postal_code, country_code | Shipping address |
Exports
| Export | Contents |
|---|---|
| Products & variants | One row per variant, same columns as the product importer (round-trip safe) |
| Customers | Customer fields, default address, order count and total spent |
| Orders | One row per line item with order totals, statuses and addresses |
| Customer data (GDPR) | Everything about one customer as JSON, from the customer page |
| Full store backup | Settings, catalog, customers, orders, invoices, discounts, shipping and taxes as one JSON file (admins only, customer passwords excluded) |
Reports for accounting
| Report | Where | Contents |
|---|---|---|
| Invoice register (CSV) | Invoices → Accounting export | Number, kind, dates, buyer, VAT ID, net / VAT / gross per rate, currency, paid |
| Invoice line items (CSV) | Invoices → Accounting export | Every invoice line with net, VAT rate, VAT and gross |
| Full invoice JSON | Invoices → Accounting export | Complete invoice documents for accounting software |
| VAT sales report | Import & export → Accounting reports | Paid orders for a month grouped by country and VAT rate (useful for OSS) |
| Inventory valuation | Import & export → Accounting reports | Stock × cost and stock × price per variant |
Exports respect the filters currently set on the list you export from.