Turn a Shopify Order Export into Offline Conversions for Google Ads and Meta

How to turn Shopify orders into offline conversions

Shopify offline conversions are the sales your ad tags can't see: POS sales in your shop and phone orders you enter as draft orders. This tool reads the orders export described on Shopify's exporting orders page and writes the upload files for Google Ads and Meta, so those sales count toward the ads that brought the customers in.

1. Export your orders. In Shopify, go to Orders, pick a date range and click Export. Choose all order information and CSV. Drop the file here — Excel works too.
2. Check the columns. Shopify's column names (Name, Created at, Financial Status, Total, Source …) are matched automatically.
3. Choose which orders count. By default only paid POS and draft orders are used; other Source values are listed so you can add the ones that are offline sales. Canceled, refunded and unpaid orders are left out, partly refunded orders count with the refund taken off.
4. Type your conversion action name. It must match the Import action in Google Ads exactly.
5. Download your files. You get one Google Ads file (Data Manager, or a click file if you choose it), a Meta Events Manager file, a Conversions API request, and a list of every order with the reason it was used or not.

What to do next

1. Google Ads. Accept the customer data terms in Goals › Settings › Customer data use. Then upload the Data Manager file in Google Ads Data Manager and match each header to its field. Google accepts files with customer data only there now.
2. Upload one Google file only. The Data Manager file already holds the GCLID of orders that have one. Use the click file in Goals › Conversions › Uploads only instead of it, never as well.
3. Meta. In Events Manager, open Data sources, pick the dataset linked to your ad account, click Upload events, choose the CSV and check the column mapping before you start the upload.
4. Make it a habit. Export only new orders since your last upload, every few days, so the sales stay inside each platform's upload window.

Common problems with Shopify order exports

Online orders counted twice

If you upload every order, the purchases your Google tag and Meta pixel already recorded are counted a second time, and your cost per sale looks better than it is. Keep the default filter, which uses the Source column to leave online store orders out.

POS sales with no customer

A POS sale where nobody entered an email or phone number can't be matched to anyone who saw your ads. Those orders are listed so you can see how many sales you are missing.

Shopify order export totals don't match

Because only the first row of each order holds the total, adding up the Total column of the whole file gives a wrong number. The tool reads each order once. Amounts like 1.234,50 are read per value, and unclear ones like 1,250 are left out rather than guessed. The Data Manager file has no currency column, so orders in other currencies get their own files.

Google Ads enhanced conversions for Shopify not matching

Matches need correct customer data. The tool trims and lowercases emails and writes phones with the country code, using the billing country or your default.

Shopify export orders automatically

Shopify downloads up to 50 orders straight away and emails bigger exports to you, so check your inbox after you click Export. Filtering the order list by date before you export keeps each file small and avoids uploading the same sale twice.