Skip to content
Outrich Data

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

  1. 01On the Orders page, sort and filter your orders.
  2. 02Click Export.
  3. 03In the Export orders window, select the option for the orders you want, for example Orders by date with a start and end date.
  4. 04Under Export as, select a file format.
  5. 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

  1. 01In the Shopify admin, go to Customers.
  2. 02Click Export.
  3. 03Choose Current page, All customers, Selected customer or the customers matching your filters.
  4. 04Under Fields included, check Customer tags and Customer metafields if you want them.
  5. 05Choose CSV for Excel, Numbers, and other spreadsheet programs, or Plain CSV file.
  6. 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

  1. 01In the Shopify admin, go to Products and click Export.
  2. 02Choose the current page, all products, selected products or the products matching your search and filters.
  3. 03Choose the CSV type: for spreadsheet programs, or plain CSV.
  4. 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

  1. 01Run the query normally first to confirm the app has access.
  2. 02Start the export with the bulkOperationRunQuery mutation, passing the GraphQL query.
  3. 03Poll the bulk operation until its status is completed.
  4. 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 exportWhat it contains
Orders CSVOne row per line item with buyer, totals, status, billing and shipping addresses, payment and risk columns.
Transaction histories CSVCaptured payments only: order, payment method, kind, gateway, status, amount, currency and card type.
Customers CSVFirst Name, Last Name, Email, default address fields, Phone, marketing consent flags, Total Spent, Total Orders, Note, Tax Exempt and Tags.
Products CSVProducts and their variants, with columns such as Fulfillment service, Inventory tracker, SEO Title and SEO Description.
Bulk operation JSONLWhatever 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?
Size decides. Up to 50 orders or 50 customers download in the browser. Anything larger, any order export by date, and any export of all products is sent by email, to you and also to the store owner.
Does the Shopify product export include images?
No. Product images are not included in the CSV. The file also does not show which collections a product belongs to.
How do I export more Shopify data than the CSV screens allow?
Use bulk operations in the GraphQL Admin API. An app starts a query with bulkOperationRunQuery, Shopify runs it in the background, and the result is a JSONL file behind a signed link that expires after one week.
Does Outrich Data connect to our Shopify store?
No. Outrich Data does not install an app or hold a staff account in your store. Your own staff run the exports and decide which columns are removed before anything is shared.

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.

esc