Offline sales
Settings → Destinations → Offline sales is one page for the whole store. Each sale is recorded once and sent to every pixel whose platform takes offline sales. Sales sent from your server through the API are website orders; use this page for the rest.
Orders brought in by an admin CSV import say where they were made, chosen per import: on the website (the default) are sent like server events, with each pixel's normal window and to every pixel; offline (in store, by phone) follow the rules on this page. Orders imported before this choice existed were all marked offline and keep that mark.
Which platforms take them
| Platform | Offline sales | Oldest accepted |
|---|---|---|
| Google Ads | Yes, marked IN_STORE | 90 days |
| Meta | Yes, marked physical_store | 62 days |
| Yes, marked offline | 7 days | |
| Yes, marked PHYSICAL_STORE | 7 days | |
| Snapchat | Yes, marked OFFLINE | 7 days |
| TikTok | Yes, marked offline, once the pixel has its Offline Event Set ID | 28 days |
| Microsoft Advertising | No: the UET Conversions API takes website events only | — |
| Google Analytics 4 | No: GA4 reports website and app visits; offline sales stay out of it | — |
| No: LinkedIn counts offline sales through their own conversion rules, which Trakbolt does not connect yet | — | |
| X | No: the X Conversions API takes website conversions only | — |
| Quora | No: Quora's Conversion API documents website events only | — |
| OpenAI Ads | No: OpenAI's Conversions API does not document an offline action source yet | — |
| Google Enhanced Conversions | No: it improves conversions your Google tag records on the website; offline sales go to Google Ads (Data Manager) | — |
A sale older than every connected pixel's window is quarantined. With no such pixel connected yet, the window is 90 days. A pixel with a shorter window skips the sale and logs why.
Record one sale
- Customer: email or phone is required. Name, city, state, zip and country improve matching; they leave Trakbolt only hashed.
- Order id: unique; a repeated one is refused. Generate makes one (OFF- and 8 letters or digits).
- Sale date and time, in the workspace time zone. Value and currency.
- Products (optional): product id, variant id, SKU, name, quantity. Each pixel's product details setting decides what is sent.
- Customer opted out of marketing: the sale is kept in your orders and never sent.
Upload a CSV
- Download the template and fill one sale per row.
- Check file: every row is checked (up to 10,000 rows, 5 MB). Nothing is sent yet.
- Review the rows: Ready or Quarantined, with the reason.
- Confirm and send: only Ready rows are sent. Or Discard the file.
order_id,sale_date,value,currency,email,phone,first_name,last_name,city,state,zip,country,product_id,variant_id,sku,product_name,quantity,opted_out OFF-7Q2K9M,2026-11-12 14:30,49.90,USD,jane@example.com,415 555 0100,Jane,Doe,San Francisco,CA,94105,US,P-100,V-100-B,MUG-BLUE,Blue mug,1,no
| Column | What to put | Example |
|---|---|---|
order_id | Your order or receipt number. Required, unique. | OFF-7Q2K9M |
sale_date | YYYY-MM-DD HH:MM in the workspace time zone (or ISO 8601 with a zone). Required. | 2026-11-12 14:30 |
value | The sale total, e.g. 49.90. Required. | 49.90 |
currency | 3-letter code, e.g. USD. Blank = the workspace currency. | USD |
email | Email or phone is required to match the customer. | jane@example.com |
phone | With country code where possible. | 415 555 0100 |
first_name | Improves matching. | Jane |
last_name | Improves matching. | Doe |
city | Improves matching. | San Francisco |
state | State or region code. | CA |
zip | Zip or postal code. | 94105 |
country | 2-letter code, e.g. US. | US |
product_id | Optional, one product per row. | P-100 |
variant_id | Optional. | V-100-B |
sku | Optional. | MUG-BLUE |
product_name | Optional. Not stored on healthcare workspaces. | Blue mug |
quantity | Whole number, default 1. | 1 |
opted_out | yes = customer opted out of marketing: recorded, never sent. | no |
Quarantine reasons
A quarantined row is never sent. Fix it in your file and upload again.
| Reason |
|---|
| Missing order id |
| Missing email and phone (needed to match the customer) |
| Sale date missing or not a date |
| Sale date is in the future |
| Too old for every connected platform |
| Order id already used |
| Value missing or not a number of 0 or more |
| Currency is not a 3-letter currency code |
| Product details incomplete (product id needed, quantity 1 to 1000) |
Statuses
| Status | Meaning |
|---|---|
| Ready | Passed every check. Sent when you confirm the upload (a recorded sale is sent right away). |
| Quarantined | Not sent. The reason is shown. |
| Submitted | Sent to the pixels that take it. Final: it cannot be edited or withdrawn. Each pixel's result is in the delivery log. |
Uploads are listed with their rows and counts: Waiting for confirmation, Submitted, Discarded.
Rules that apply
- Opted-out customers are recorded and never sent; the delivery log says “customer opted out of marketing (offline sale): recorded, never sent”.
- Each pixel's order rules, match keys and product details apply, as for online orders.
- Only people who came from this platform does not apply: the platform matches an offline sale by the customer's details.
- Healthcare workspaces: product names are not stored, product data is never sent, and contact details leave only hashed.