Guides
Exporting your data
Exporting your data
Products, customers and orders each export as a CSV from their list screen — Products, Customers, Orders → Export. The file downloads straight to your machine; nothing is emailed and nothing is queued.
The column names match Shopify's exports, so these files open in the same spreadsheets and import into the same tools without renaming anything.
Exporting needs the matching view permission — View products, View customers, View orders.
Products
Downloads as products_export.csv.
One row per variant, not per product. A product with three sizes is three rows sharing a Handle, and only the first carries the title and description — the same layout Shopify uses.
| Column | |
|---|---|
Handle | The product's URL slug, and the key an import matches on |
Title, Body (HTML), Tags | Product content |
Published, Status | Visibility on the storefront |
Option1 Name / Value … Option3 | Up to three variant options |
Variant SKU, Variant Inventory Qty | Stock |
Variant Price, Variant Compare At Price, Variant Barcode | Pricing and identifiers |
Image Src, Image Position | Media |
SEO Title, SEO Description | Search listing |
Because Handle is the match key, an exported file re-imported updates the products rather than duplicating them — which makes export → edit in a spreadsheet → import a safe way to do a bulk price change.
Customers
Downloads as customers_export.csv. One row per customer, with their default address flattened into it.
| Column | |
|---|---|
First Name, Last Name, Email, Phone | Identity |
Accepts Email Marketing | Marketing consent |
Default Address Address1 / Address2 / City / Province / Zip / Country / Phone | Default address |
Total Spent, Total Orders | Lifetime totals |
A customer with several saved addresses exports only the default one.
Handle this file carefully. It is personal data — names, phone numbers, home addresses — and marketing consent. Only
Accepts Email Marketing = yescustomers may be emailed marketing.
Orders
Downloads as orders_export.csv.
One row per line item. A three-item order is three rows sharing the same Name (the order number), with the order-level totals repeated on each. Summing the Total column therefore over-counts — deduplicate by Name first.
| Column | |
|---|---|
Name, Created at | Order number and date |
Email, Phone | Customer contact |
Financial Status, Paid at, Fulfillment Status | Where the order stands |
Currency, Subtotal, Shipping, Taxes, Total | Money |
Discount Code, Discount Amount | Discounts applied |
Shipping Method, Tracking Number | Delivery |
Payment Method | Which provider took the payment |
Notes, Tags | Your own annotations |
Lineitem quantity / name / variant / sku / price | The item on this row |
Shipping Name / Address1 / Address2 / City / Province / Zip / Country / Phone | Delivery address |
Exporting a subset
The order export honours the filters on the Orders screen — fulfillment status, payment status and search. Filter the list to what you want, then Export, and only those orders are written. Exporting unfiltered gives you everything.
Importing back
Products, customers and orders can all be imported from the same format — Products → Import, Customers → Import, Orders → Import. See Customers for how a customer import matches existing records.
Updated 15 September 2026