Import files

Not on Shopify, or want to add older figures? Upload your data as a CSV file.

Where to upload what

• Go to Products and click Connect data (Dutch app: Gegevens koppelen). Choose Shopify, Picqer, Odoo or CSV. CSV takes you to Products › Import, for products and packaging.
• Monthly sales and monthly parcels are uploaded under Reporting › Sales data.

Members, admins and owners can upload. Every kind has a Download template button: a CSV with all columns and made-up example rows. Start from that.

The file

• CSV only. Excel files are refused. In Excel choose File › Save as › CSV UTF-8.
• Encoding UTF-8 (otherwise Windows-1252). Separator comma, semicolon, tab or |: EuroPlaybook detects it.
• Column names may be English or Dutch (for example artikelnummer for sku, aantal for quantity); case and accents do not matter.
• At most 10 MB and 200,000 rows. Split a bigger file by period.
• No personal data. Columns that look like it are removed in your browser before the upload, and you are told which. An e-mail address in a cell blocks the upload.
• If any row has an error, nothing is imported. You see which rows to fix.

Values

• Decimals: 12.5 or 12,5.
• Weight: in grams (net_weight_g, mass_g) or milligrams (*_mg, whole number). No kilograms.
• Yes/no: yes/no, true/false, 1/0, ja/nee, or x for yes.
• Countries: two-letter code (NL, BE, DE); country names work too.
• Month: 2026-03 or any date in that month (2026-03-15, 15-03-2026).

Columns per kind

Required columns are bold. Columns marked (form) may be left out: you then fill in the value in the upload form.

Kind	Columns
Products	sku, title, brand_name, gtin, hs_code, country_of_origin, net_weight_g or net_weight_mg, is_kit, is_electrical, is_textile, components (SKU:qty;SKU:qty), asin, bol, shopify
Packaging (one row per material)	item_code, material, mass_g or mass_mg, sku, item_name, role, layer (sales, grouped, transport), quantity, per_units, household, channel, fulfilment, rigidity (rigid, flexible), separable, recycled_content_pct, supplier, valid_from, valid_to
Monthly sales	month (form), sku, ship_from_country (form), ship_to_country, channel (form), quantity, seller_vat, marketplace, buyer_type, fulfilment, kind (sale, return), orders, net_amount, currency, exclusion
Monthly parcels	month (form), ship_from_country (form), ship_to_country, size_class (lt40, 40to90, gt90), parcels, household

Fixed values: channel is webshop, bol, amazon, odoo or other; buyer_type is consumer, business_end_user, reseller or unknown; fulfilment is own, fba, lvb or 3pl.

Period and uploading again

• Products and packaging have no period. Rows are added or updated; nothing is deleted. Leave Packaging valid from empty and the packaging applies to all sales, also earlier ones.
• For sales and parcels you choose the Period: from the file, one month, quarter, year or from – to. If the file has no month column, all rows count in the month you choose.
• Uploading the same kind of data for the same period again replaces the earlier upload. A period that only partly overlaps an earlier upload is refused, and so is an upload into a locked or filed period.