Export guide · Checked against Shopify documentation 2026-11-17
How to export all your data from Shopify
Staff with the Export permission for each area export orders, customers and products as CSV files from the Shopify admin: open Orders, Customers or Products and click Export. Small exports download in the browser. Larger ones are emailed to the person exporting and to the store owner. Developers can pull full datasets as JSONL through bulk operations.
Who can export from Shopify
Export is a separate permission for each kind of record. At the time of checking, Shopify's store permissions list has an Export permission under Orders, another under Draft orders, one under Products that covers product and inventory data, one under Customers that is required for exporting customer profiles, and one under Gift cards. Being able to view orders does not by itself grant the right to export them, so check the role of whoever will run this.
Shopify builds in a control on staff exports. When someone who is not the store owner exports customers or products, or a large set of orders, the file is also sent to the store owner's email address. Plan for that if the owner's inbox is shared.
The API route needs an app. A bulk query needs the same access as the equivalent normal query, and a missing scope returns an ACCESS_DENIED error. Public and custom apps created by Partners have to enable bulk queries in the Dev Dashboard, and access must be re-enabled if the app has not run a bulk operation in 31 days.
How to export, step by step
Route 1 of 4
Export orders to CSV
Staff with the Orders Export permission
- 01On the Orders page, sort and filter your orders.
- 02Click Export.
- 03In the Export orders window, select the option for the orders you want, for example Orders by date with a start and end date.
- 04Under Export as, select a file format.
- 05Click Export orders to get all order information, or Export transaction histories to get transaction information only.
Exporting up to 50 orders, or the current page, downloads the CSV to your device. Larger exports, and any export by date, are emailed to you and to the store owner. You get an email if the export fails.
Route 2 of 4
Export customers to CSV
Staff with the Customers Export permission
- 01In the Shopify admin, go to Customers.
- 02Click Export.
- 03Choose Current page, All customers, Selected customer or the customers matching your filters.
- 04Under Fields included, check Customer tags and Customer metafields if you want them.
- 05Choose CSV for Excel, Numbers, and other spreadsheet programs, or Plain CSV file.
- 06Click Export customers.
Up to 50 customers download in the browser. More than 50 are emailed. Tags and metafields are only in the file if you check their boxes.
Route 3 of 4
Export products to CSV
Staff with the Products Export permission
- 01In the Shopify admin, go to Products and click Export.
- 02Choose the current page, all products, selected products or the products matching your search and filters.
- 03Choose the CSV type: for spreadsheet programs, or plain CSV.
- 04Click Export products.
All products and filtered sets are always emailed. The current page or a selection downloads in the browser unless a product has more than 100 variants, in which case it is emailed.
Route 4 of 4
Export through bulk operations in the GraphQL Admin API
Developer with an app that has access to the data being queried
- 01Run the query normally first to confirm the app has access.
- 02Start the export with the bulkOperationRunQuery mutation, passing the GraphQL query.
- 03Poll the bulk operation until its status is completed.
- 04Download the JSONL file from the signed link in the url field.
If an operation fails partway, partialDataUrl gives the data retrieved so far. Shopify recommends parsing the JSONL one line at a time to limit memory use.
What comes out
Every admin export is a UTF-8 encoded CSV, the only encoding Shopify imports or exports. Customers and products offer two flavors, one tuned for spreadsheet programs and one plain. The orders file has one row per line item: an order with several items repeats on extra rows, and many order-level fields are blank on those rows. A parser has to group line-item rows back into their order before any analysis. The export reflects each order as it was when created, so later product edits do not show.
The orders CSV is wide. It carries buyer contact fields, financial and fulfillment status with timestamps, totals, discount code and amount, a set of Lineitem columns (quantity, name, price, SKU), full Billing and Shipping address blocks, Notes and Note Attributes, Payment Method, Payment References, Refunded Amount, Employee, Location, Tags, Risk Level and Source. The transaction histories file is narrow: Order, Name, Payment Method, Kind, Gateway, Created At, Status, Amount, Currency and Card Type.
Bulk operations return JSONL, one JSON object per line. Children of a nested connection, such as the line items of an order, get their own lines after the parent, each with a __parentId field that points back to it.
| In the export | What it contains |
|---|---|
| Orders CSV | One row per line item with buyer, totals, status, billing and shipping addresses, payment and risk columns. |
| Transaction histories CSV | Captured payments only: order, payment method, kind, gateway, status, amount, currency and card type. |
| Customers CSV | First Name, Last Name, Email, default address fields, Phone, marketing consent flags, Total Spent, Total Orders, Note, Tax Exempt and Tags. |
| Products CSV | Products and their variants, with columns such as Fulfillment service, Inventory tracker, SEO Title and SEO Description. |
| Bulk operation JSONL | Whatever the GraphQL query asked for, with child objects linked to parents by __parentId. |
Before you rely on it
Limits and gotchas.
- Exported customer files are limited to 15 MB.
- Large order exports take time. Shopify's own examples are under an hour for fewer than 100,000 items and about 4 hours for 400,000.
- The transaction histories export includes only captured payments. Authorization data is not included.
- The Discount Code column in the orders CSV leaves out automatic discounts.
- The products CSV does not include product images, and it does not show which collections a product belongs to.
- A products export can time out when there are thousands of variants. Shopify's fix is to filter the product list into smaller subsets and export each one.
- Bulk operation download links expire after one week. A bulk query must finish within 10 days, can contain at most five connections, and can nest connections no deeper than two levels.
Handle with care
Personal data inside a Shopify export.
- These exports hold customer and payment-related personal data, and should be handled as such.
- Buyer name, email and phone number on every order and customer row.
- Billing and shipping names, street addresses, cities, postal codes and phone numbers.
- Payment method, payment references and IDs, gateway and card type.
- Total Spent and Total Orders per customer, plus marketing consent for email, SMS and WhatsApp.
- Free text: order Notes, Note Attributes, customer Note and Tags, which staff use for anything.
- The Employee column on each order.
An export is a copy outside the access controls of Shopify. Store it encrypted, limit who can open it and delete working copies when you are done. The personal data scrubber removes common identifiers in your browser before a file is shared.
What the export can be worth
Outrich Data is a direct buyer of de-identified company data for AI training, from companies with 50 or more employees. We never connect to your Shopify account: your team runs the export above and removes what is out of scope. Not every export qualifies, and a rights review comes before any offer.
Questions
Exporting from Shopify: common questions.
Why was my Shopify export emailed instead of downloaded?
Does the Shopify product export include images?
How do I export more Shopify data than the CSV screens allow?
Does Outrich Data connect to our Shopify store?
Sources
Steps were checked against Shopify documentation on 2026-11-17. Vendors change menus, plans and limits, so confirm against the linked pages. Shopify is a trademark of its owner. Outrich Data is not affiliated with Shopify.
Find out if your data qualifies.
Eleven questions, about five minutes, no call required. You get an answer on screen and a written follow-up.