To export Shopify orders, open Orders in the Shopify admin, click Export, choose the orders or a date range and a CSV format. Up to 50 orders download at once; larger exports are emailed. The CSV has no campaign fields, so to see which ads led to which orders, pull each order's first and last visit with UTM parameters from the API and match them to your ad reports.
- The order CSV has one row per line item, with customer contact details and addresses on it.
- Products and customers export from their own pages; product images are not in the CSV.
- By default the API returns only the last 60 days of orders; older orders need extra access.
- UTM parameters and click IDs on the landing page URL are what tie an order to an ad.
How do you export Shopify orders, products and customers?
Each record type exports from its own page in the Shopify admin. For orders: "You can export a comma-separated values (CSV) spreadsheet of your orders from the Orders page of your Shopify admin" (Shopify Help Center). Sort and filter the list, click Export, pick the current page, selected orders or orders by date, choose a file format and click Export orders.
Small exports download in the browser. If you export more than 50 orders or export by date, "the CSV file is emailed to you and the store owner". Large stores should expect a wait: Shopify says an export with fewer than 100,000 items might complete in under an hour, "whereas an export with 400,000 items might take around 4 hours" (Shopify Help Center).
| Record | Where | What you get | Limits to know |
|---|---|---|---|
| Orders | Orders, Export | One CSV with a row per line item: totals, discounts, shipping, tax, payment and customer details | Over 50 orders or a date range is emailed to you and the store owner |
| Transaction histories | Orders, Export, Export transaction histories | Payment transactions per order | Captured payments only; authorization data is not included |
| Products | Products, Export | One CSV of product and variant details: titles, options, prices, SKUs and image URLs | Images are not in the file; a current-page or selected export is emailed if any product has more than 100 variants |
| Customers | Customers, Export | One CSV of customer profiles with contact details, default address and marketing consent | Files are limited to 15 MB; over 50 customers is emailed |
| Everything, at scale | GraphQL Admin API bulk operations | A JSONL file per query, with the fields you ask for | Needs an app with the right access scopes; last 60 days of orders by default |
Product images need their own step: "When you export your products, the images associated with each product aren't included in the CSV file" (Shopify Help Center). The customer export has a size cap: "Exported CSV files are limited to 15 MB in size" (Shopify Help Center).
What is in the Shopify order export CSV?
The file is flat, so an order with three products takes three rows: "orders with multiple line items display their additional line items on separate lines", and many fields on the extra rows are left blank (Shopify Help Center). Group by the Name column (the order number) or the Id column before you count orders or sum totals.
The documented columns cover the order (Name, Id, Created at, Financial Status, Fulfillment Status, Currency, Subtotal, Shipping, Taxes, Total, Discount Code, Discount Amount, Source, Tags, Risk Level), each line item (name, quantity, price, SKU, vendor), payment references, refunds and the customer: Email, Phone, Accepts Marketing, and full billing and shipping names and addresses.
Two things are missing for marketing analysis. The documented column list has no UTM, landing page or click ID field, so the CSV alone cannot tell you which ad produced an order. And the Discount Code column shows codes and manual discounts but, per Shopify, not automatic discounts.
Shopify data export by API for larger stores
For a full history, or for fields the CSV does not have, use the GraphQL Admin API. Bulk operations are built for this: "Shopify's infrastructure does the hard work of executing your query, and then provides you with a URL where you can download all of the data", and when the operation completes "a JSONL output file is available for download" (Shopify developer docs).
Check order history access first. "Only the last 60 days' worth of orders from a store are accessible from the Order object by default. If you want to access older records, then you need to request access to all orders" (Shopify developer docs).
The API is also where attribution lives. Each order has a customerJourneySummary: "The customer's visits and interactions with the online store before placing the order" (Shopify developer docs). Its first and last visits carry a landing page, a referrer URL and UTM parameters, described as "A set of UTM parameters gathered from the URL parameters of the referrer" (Shopify developer docs). Store staff can see the same data on an order page under Conversion summary, where visit details can include where the visitor came from and the UTM parameters (Shopify Help Center).
- Query orders with id, name, createdAt, totals, discount codes, line items and customerJourneySummary (first and last visit).
- Query products and variants separately and join on variant id or SKU.
- Keep the Shopify order id on every row. It is the join key for everything else.
- Leave customer contact fields out of the query unless you need them.
How do you export ad performance from Google Ads and Meta Ads Manager?
In Google Ads, open the page with the statistics table you want (campaigns, ad groups or ads), set the date range, columns and segments, then "Click the download icon in the upper right corner above the table." Google lists the formats: "Available formats include Excel CSV, TSV, PDF, XLSX, XML, and Google Sheets" (Google Ads Help). Segment by day so each row is one campaign or ad on one date.
Meta Ads Manager has an export option on its campaign, ad set and ad tables and in its reporting tool. Choose a daily breakdown and include the campaign, ad set and ad names and IDs, spend, impressions, clicks and purchases. Menu names change often, so follow the current steps in the Meta Business Help Center.
What makes the two sides join is the click. Google's auto-tagging adds a click ID to the landing page URL: "if someone clicks on your ad for www.example.com, the final URL will look like www.example.com/?gclid=123xyz" (Google Ads Help). Google describes the GCLID as a parameter that "identifies the campaign along with other attributes of the click associated with the ad for ad tracking and campaign attribution" (Google Ads Help). On other ad platforms, add UTM parameters to every ad URL and put the campaign and ad IDs in them.
Worked example: joining three orders to the ads that led to them
The join has two levels. Order level: read the UTM parameters and landing page URL of each order's last visit and match the campaign and ad IDs to rows in the ad export. Day level: sum orders and revenue by campaign and date and set them beside spend for the same campaign and date. The three orders below are fictional; amounts are in US dollars.
| Order | Total | Last visit in Shopify | Matching ad export row | Result |
|---|---|---|---|---|
| #1041, 2026-10-03 | 86.00 | utm_source=google, utm_campaign=brand_search, gclid on the landing page URL | Google Ads, campaign brand_search, 2026-10-03: spend 212.40, 310 clicks | Joined by campaign and date; the click ID gives a click-level match where a click report holds it |
| #1042, 2026-10-03 | 54.00 | utm_source=meta, utm_campaign=1203001, utm_content=ad_778 | Meta ad 778 in campaign 1203001, 2026-10-03: spend 96.15, 141 clicks | Joined to one ad by the IDs in the UTM parameters |
| #1043, 2026-10-04 | 120.00 | No UTM parameters; referrer is a search engine | None | Not attributed to an ad; count as organic or direct |
Expect gaps. Shopify notes that a conversion summary can be empty when "Apps and private browsers are preventing cookie tracking, and no source or landing page was captured for the order", when the order began as a draft, or when it did not come from the online store, and that summary details "might take up to 48 hours to display" (Shopify Help Center). Report the share of orders with no attribution next to the joined numbers.
Common mistakes when exporting and joining Shopify and ads data
Most bad joins come from a handful of avoidable errors.
- Counting CSV rows as orders. Rows are line items; group by order number first.
- Sorting a product CSV in a spreadsheet and re-importing it. Shopify warns that sorting can cause variants or image URLs to become disassociated.
- UTM names typed by hand, so one campaign appears under five spellings. Use the platform's campaign and ad IDs.
- Comparing platform-reported purchases with Shopify orders and expecting them to match. Each platform counts conversions under its own attribution rules.
- Mixing time zones and currencies between the store and the ad accounts.
- Exporting only the last 60 days through the API without noticing older orders are missing.
- Emailing the full order CSV around the team. It carries customer names, emails, phones and addresses.
Joined ads and order history as a data asset
A store that has run paid ads for a few years holds something hard to recreate: which creative and audience were shown, what was spent, which visits followed and which of those became orders, refunds and repeat purchases. Each side on its own is common. The joined record of spend to outcome is not.
AI data buyers have asked Origin for records from DTC brands whose ads data joins to Shopify orders. Origin is an independent data partner that helps companies work out whether records like these could be bought, and on what terms. The same export habits apply to your other systems: see the guides to exporting HubSpot data, exporting Salesforce data and exporting company records before closing.
Customer personal data comes out first. The order export carries names, emails, phone numbers and billing and shipping addresses, and Shopify treats "Customer data including name, address, phone, or email fields" as the higher of its two protected levels for apps (Shopify developer docs). Drop those columns, replace customer and order IDs with tokens that keep repeat purchases linked, and reduce addresses to a region (how to de-identify company data). Check what your privacy policy told customers and which privacy laws apply (GDPR and CCPA in data licensing).
Then check platform terms. Read the Shopify, Google Ads and Meta terms your accounts are under, and the terms of any app that touched the data, for limits on sharing exported reports and on using them to train models. This page is general information, not legal advice.
Does your company hold records like these? See what your data is worth.
Common questions
How do I export Shopify orders to CSV?
In the Shopify admin, go to Orders, filter the list if needed, click Export, choose the current page, selected orders or orders by date, pick a CSV format and click Export orders. Up to 50 orders download directly; larger exports are emailed.
How do I export Shopify products with their images?
Go to Products, click Export and choose which products and which CSV format. The file lists product and variant details with image URLs, but the images themselves are not in the CSV, so download them separately while the store is live.
Does the Shopify order export include customer emails and addresses?
Yes. The documented columns include Email, Phone and full billing and shipping names and addresses. Treat the file as personal data and remove those columns before sharing it outside the team.
What is the best Shopify data export method for a large store?
Bulk operations in the GraphQL Admin API. You submit one query, Shopify runs it in the background and returns a link to a JSONL file. Request access to all orders first, because the API returns only the last 60 days by default.
How can I see which ad a Shopify order came from?
Open the order and read the Conversion summary, or query customerJourneySummary through the API. The first and last visits show the landing page, referrer and UTM parameters, which you match to campaign and ad IDs in your ad exports.
Can I build an ecommerce dataset from my own Shopify store?
Yes. Export orders, products and customers, add visit and UTM data from the API, and join ad spend by campaign and date. Remove customer names, emails, phones and addresses before the dataset leaves the company.
Sources and further reading
- Shopify Help Center: Exporting orders
- Shopify Help Center: Exporting products
- Shopify Help Center: Importing and exporting customers with a CSV file
- Shopify Help Center: Conversion summary on an order
- Shopify developer docs: Order object (GraphQL Admin API)
- Shopify developer docs: CustomerVisit object (GraphQL Admin API)
- Shopify developer docs: Perform bulk operations with the GraphQL Admin API
- Shopify developer docs: Work with protected customer data
- Google Ads Help: Create, save, and schedule reports from your statistics tables
- Google Ads Help: About auto-tagging
- Google Ads Help: Google Click Identifier (GCLID), definition
