Skip to content

E-commerce and point of sale

How to find and size your Shopify data.

Find how many orders, customers and products your Shopify store holds, and how the order CSV, report exports and the Admin API pull a full history.

Get your data pricedAll guides

Find how much you have

  1. Open Orders in the Shopify admin. The analytics bar at the top shows Total Orders for the date range you select, compared with the period before. Use it for a quick read of recent volume, then move to the all-time count below.

  2. For the all-time count, go to Analytics, then Reports, click the Category filter, choose Orders and open Orders over time. Set the date range to begin the day you opened the store. The report shows how many orders were received in that range. Shopify notes that an edit made after the order day appears as its own order in this report, so the total can read slightly high.

  3. Cross-check with a file. On the Orders page click Export, choose Orders by date, enter your first and last order dates, pick a file format under Export as and click Export orders. Shopify emails the file to you and to the store owner. In the CSV, extra line items sit on their own rows, so count the distinct, non-blank values in the Name column to get orders instead of rows.

  4. For customers, open Customers, click Export, choose All customers and click Export customers. Shopify emails the file when it covers more than 50 customers. The customer file carries Total Orders and Total Spent columns, and counting its rows gives your customer total.

  5. For products, open Products, click Export and choose All products. Note the count for your description, but expect the order history to carry most of the value.

  6. For the start date, sort the order export by its Created at column, which holds the date the customer completed the order, and read the earliest one. A developer can also run the Admin API ordersCount query, which returns a count plus a precision flag and stops at 10,000 unless the limit argument is set to null.

What to put on your intake

Your intake has five boxes for each system. Here is what goes in each one for Shopify.

What does it hold?
Orders with line items, discounts, shipping and refunds, customer profiles, and the product catalog, plus in-person sales if you use Shopify POS. Say which of these you rely on and whether you run one store or several.
Data types
Structured records for orders, customers and products. Add Text only if your orders carry real written notes (the order file has a Notes column). Add Image only for product photos you took yourself, since the product CSV does not include image files.
How big is it?
Choose Orders and enter the all-time order count. Put customer and product counts in the description, and say whether your figure includes cancelled, archived and draft orders.
Verified or estimated
Verified when the count comes from an order export that covers your whole history, counted by distinct order name. Estimated when it comes from one year of data, the analytics bar alone or an older figure.
Records start
The earliest order date in the export. If you moved to Shopify from another platform, the older orders live in that platform, so add it as its own system.

Exporting the full history

If a buyer licenses your records, this is how the full history comes out of Shopify.

  1. A full-history export happens only after a license is signed and the scope is agreed: which stores, which record types, which date range, and whether in-person POS sales are in.

  2. Orders file. The store owner, or a staff member with the Export permission for Orders, opens Orders, clicks Export, chooses Orders by date with a start and end date, picks a file format and clicks Export orders. Shopify emails the CSV to that person and to the store owner. Shopify's own examples say an export of fewer than 100,000 items might finish in under an hour and one of 400,000 might take around four hours, and a failed export sends an email saying so. Long histories are easier to handle in date slices.

  3. Customers and products. Customers, then Export, then All customers, produces a customer CSV that Shopify limits to 15 MB, so split a large list by filter or segment. Products, then Export, then All products, produces the catalog file. Keep the original product file untouched, because Shopify warns that sorting it in a spreadsheet can leave product variants or image URLs disassociated.

  4. Reports. Open a report under Analytics, then Reports, and use Export. Shopify offers CSV, XML, JSONL and Parquet for most reports. These are summaries, so treat them as a companion to the order file and not a replacement for it.

  5. API route for a complete, repeatable pull. A developer creates a custom app in the Dev Dashboard and runs a GraphQL Admin API bulk query. Shopify runs it in the background and gives back a URL for a JSONL file of the results. A bulk query has to finish within 10 days, and the download link expires after a week. By default an app sees only the last 60 days of orders, and older ones need the read_all_orders scope, which Shopify must approve, so ask your developer to check how that applies to your app.

  6. Payments. Orders can also be exported with transaction histories, which list the gateway, card type and amount for captured payments. You will not need that file, because payment detail is excluded.

  7. Under the license, customer names, emails, phone numbers and addresses are removed from order, customer and note fields before delivery, and payment, card and gateway references are excluded.

We only ask for an export after you sign a license and agree the scope. Sizing your data for the intake never needs one.

Limits to know

  • Shopify's export article gives no maximum order count. It says an export of up to 50 orders or the current page downloads to your device, while larger exports and exports by date are emailed to the person who exported and to the store owner.
  • Rows in the order CSV are line items, not orders. Orders with several items repeat on extra rows with many fields left blank, so a raw row count overstates your order total.
  • The Orders over time report counts a later edit to an order as a separate order, so use it as an estimate and the export as the verified figure.
  • Apps get the last 60 days of orders by default. The read_all_orders scope needs Shopify's approval, so a developer should confirm access to your older orders before you plan an API pull.
  • The ordersCount query is capped at 10,000 by default, and its precision field says whether the number is exact or an estimate. Pass a null limit and check that precision before you report the figure as verified.
  • If an order came through a third-party checkout app, Shopify says the app decides which data it passes along, so some fields can be empty even when your store has the data. Reviews, loyalty and subscription apps keep their own records outside these exports.
  • Erasing a customer's personal data redacts details such as name and address but leaves the profile and its order history, while deleting a customer profile removes the whole profile. Expect a few redacted rows in a long history.
  • A deactivated store's information is guaranteed for two years, and it cannot be reactivated once that data is deleted. If you are closing or pausing a store, take the exports first.
  • Shopify says the order file includes POS fields such as Employee, Location and Device ID, so a store with in-person sales has staff names in its export.
  • Shopify's help for custom apps says Custom Level 2 PII apps need the Grow plan or higher. Ask your developer which customer data an export app will touch.

This guide isn't legal advice. Check your contracts, and any recording-consent rules that apply, with your own lawyer.

Why buyers value it

A Shopify store keeps the whole retail loop in one place: what was bought together, which discount applied, how it shipped, what came back and what was refunded. Each order has an outcome attached, which is what separates real commerce records from scraped product pages.

For AI buyers building merchandising, pricing, support and fulfillment tools, several years of orders show seasonality, discount response and return patterns. That is hard to learn from public sources, and it gets more useful the longer the unbroken history runs.

What stays private

Customer names, emails, phone numbers, billing and shipping addresses, and personal details typed into order notes are removed or replaced before delivery under the license. Payment references, gateway data and card details are excluded, along with staff names and logins, app tokens and anything that identifies one shopper.

Product copy and photos that came from a supplier or brand belong to them, so they are excluded unless you can show you own them. Third-party app data, such as reviews or loyalty balances, is left out unless it is listed as its own system.

Common questions

The export pages we read for orders, customers and products do not name a plan requirement, and Shopify says the main analytics features are available on any subscription plan. Custom apps that touch customer data at Level 2 need the Grow plan or higher, so ask Shopify Support what applies to your store before you plan an API pull.

Count orders. Line items are the detail inside an order, so mention the average items per order in the description if you know it. Counting distinct, non-blank values in the Name column of the order CSV gives you orders.

No. Buyers license de-identified operating records. Names, contact details and addresses come out before delivery, and what remains is the basket, the discount, the shipping method and the outcome.

Sources

Vendor documentation, checked . Screens and plans change, so if a step looks different in your account, check with Shopify.

Related guides for systems that often sit alongside it.

Accounting and payables

QuickBooks

Find how many transactions and projects QuickBooks holds, online or desktop, and how a full-history export works.