Shopify orders vs GA4 purchases

Shopify export

In Admin, open Orders → Export → Export orders. Keep Name, Id, Created at, Currency, Subtotal or Total, Financial Status, Paid at, Canceled at, Refunded Amount, Payment Method and Source. Extra line-item rows become one order. An aggregate Sales report cannot identify missing orders.

GA4 export

In Explore, make a flat free-form table with Transaction ID and Date as rows, Purchase revenue and Ecommerce purchases as values, and no segments or pivot columns. Use a purchase-event filter for original purchase values. Export CSV for the same completed period. A standard report also works if it contains those order-level columns; save Sheets as CSV. BigQuery CSV needs transaction_id, date, purchase_revenue, currency and optionally ecommerce_purchases.

Value and currency

Google’s purchase value normally excludes tax and shipping; some Shopify integrations send checkout total. Check the Revenue mapping. Reports use the GA4 property currency even when a Currency dimension is included; BigQuery can use local currency per row. Different or unknown currencies go to review. No exchange rates are applied. Net refunds subtract the exported Refunded Amount, which may include tax or shipping.

Time and IDs

Dates use the GA4 property time zone you enter. Shopify Created at is the order date, not necessarily the payment date. Match by ID across days, then flag date differences. Name, order number, Id and an exported checkout token are candidate keys. A leading #, spaces and numeric leading zeros are normalized only when the candidate stays unique. Custom prefixes remain. Ambiguous matches need review.

Expectedness

Cancelled before payment, explicit test orders, POS/draft/manual sources, explicit subscription renewals and fully refunded orders are shown separately. They are not counted as lost. Full refunds may still have had an original purchase. Server integrations may send offline orders. A standard CSV may not identify tests or renewals; absence of a marker proves neither.

Limits

Refund events are not matched separately. Missing IDs cannot identify an order. Repeated GA4 IDs may be export dimension splits or repeated collection; the tool sums their values and flags them. Inspect sampling, thresholds, row limits, retention, filters, consent and recent-data delays before treating an export as complete. Modelled or attributed totals cannot all be reconstructed order by order.

Privacy

Files are read in page memory. The comparison does not send or store file contents, order IDs or derived numbers. Clear the files or close the page when finished. Ordinary site visit measurement follows your cookie settings.

Sources: Shopify orders export, GA4 Explorations, GA4 currency, GA4 metric definitions. Checked 27 October 2026.