Skip to content
trakbolt

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

PlatformOffline salesOldest accepted
Google AdsYes, marked IN_STORE90 days
MetaYes, marked physical_store62 days
PinterestYes, marked offline7 days
RedditYes, marked PHYSICAL_STORE7 days
SnapchatYes, marked OFFLINE7 days
TikTokYes, marked offline, once the pixel has its Offline Event Set ID28 days
Microsoft AdvertisingNo: the UET Conversions API takes website events only—
Google Analytics 4No: GA4 reports website and app visits; offline sales stay out of it—
LinkedInNo: LinkedIn counts offline sales through their own conversion rules, which Trakbolt does not connect yet—
XNo: the X Conversions API takes website conversions only—
QuoraNo: Quora's Conversion API documents website events only—
OpenAI AdsNo: OpenAI's Conversions API does not document an offline action source yet—
Google Enhanced ConversionsNo: 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
ColumnWhat to putExample
order_idYour order or receipt number. Required, unique.OFF-7Q2K9M
sale_dateYYYY-MM-DD HH:MM in the workspace time zone (or ISO 8601 with a zone). Required.2026-11-12 14:30
valueThe sale total, e.g. 49.90. Required.49.90
currency3-letter code, e.g. USD. Blank = the workspace currency.USD
emailEmail or phone is required to match the customer.jane@example.com
phoneWith country code where possible.415 555 0100
first_nameImproves matching.Jane
last_nameImproves matching.Doe
cityImproves matching.San Francisco
stateState or region code.CA
zipZip or postal code.94105
country2-letter code, e.g. US.US
product_idOptional, one product per row.P-100
variant_idOptional.V-100-B
skuOptional.MUG-BLUE
product_nameOptional. Not stored on healthcare workspaces.Blue mug
quantityWhole number, default 1.1
opted_outyes = 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

StatusMeaning
ReadyPassed every check. Sent when you confirm the upload (a recorded sale is sent right away).
QuarantinedNot sent. The reason is shown.
SubmittedSent 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.