When you import orders for sales popups via CSV, your new or recently migrated Shopify store can show real purchase activity from day one—without waiting weeks for new checkouts to accumulate. If you just moved your catalog from WooCommerce, BigCommerce, or Squarespace, or if you already sell the same products at a retail pop-up stall or on a marketplace, those completed purchases are genuine social proof.
The rule that matters most is honesty: every row in your CSV must be a real order that actually happened, with its true purchase date and product details. This guide walks through when a CSV recent sales popup makes sense, how to map and clean your spreadsheet, and how to upload it in Sam FOMO. For a complete overview of every notification format on Shopify, see our social proof guide for Shopify.
When should you import orders via CSV instead of syncing from Shopify?
For most active stores, automatic Shopify order syncing is the right choice because new purchases appear automatically and order tags filter out non-retail transactions. However, importing a CSV solves three legitimate data gaps when you migrate social proof orders to Shopify:
| Store scenario | Why live Shopify sync falls short | How a Custom CSV file helps |
|---|---|---|
| Platform migration (WooCommerce, BigCommerce, Magento) | Your Shopify admin starts with zero paid orders unless you run a paid order-migration tool | Displays real recent purchases from your previous store while your new checkout builds history |
| Multi-channel or offline retail (POS, market stalls, Etsy) | Off-Shopify sales for the same SKUs do not appear in your online store’s Orders list | Lets you feature verified sales of the exact same products from your other channels |
| Seasonal stores returning after a break | Shopify’s standard read_orders API scope only reads orders created within the last 60 days (Shopify API access scopes) | Displays real orders from your previous season with their true dates until fresh orders arrive |
| Steady daily or weekly orders on Shopify | Live orders already sit in your Shopify admin | Skip CSV import—use Recent orders from Shopify instead |
If you are launching a brand-new product line with zero sales on any channel, do not invent CSV rows to make the store look busy. Start with the zero-order playbook in social proof for new stores.
What are the honesty and compliance rules for CSV sales popups?
A CSV uploader gives you direct control over the text and timestamps that appear in a corner notification. Because nothing stops a spreadsheet editor from typing fictional names or changing dates, platforms and consumer protection regulators draw a bright line between migrating real orders and fabricating activity:
- Shopify App Store policy: Under Section 1.1.4 of Shopify’s App Store requirements (Use only factual information), apps and stores must not use falsified data to deceive buyers, explicitly naming “fake reviews or false purchase notifications.”
- US FTC rules on deceptive endorsements and social proof: Under the FTC Consumer Reviews and Testimonials Rule (16 CFR Part 465) and Section 5 of the FTC Act, misrepresenting that consumers bought or endorsed a product is a deceptive practice. See our breakdown of fake social proof and FTC rules for details.
- Customer data minimization: Under Shopify’s protected customer data framework and Article 5(1)(c) of the European Union’s General Data Protection Regulation (GDPR), you should only process and display the minimum data needed—never street addresses, full names, phone numbers, or email addresses.
To keep a CSV recent sales popup honest:
- Delete all sample rows included in the downloadable CSV template before saving your file.
- Never alter
order_timetimestamps to make a three-week-old order read “Just now.” - Only include products you actively sell on your Shopify store today, linking each row to the matching Shopify product page.
What columns does the Sam FOMO CSV template require?
In Sam FOMO, clicking Download the sample CSV inside the Recent Sales editor downloads salespop_sample.csv (Recent Sales guide). The uploader accepts .csv files up to 5 MB and recognizes nine column headers.
Every field is optional, and you must keep the exact header spelling from the sample file so the parser maps each column to its storefront variable:
| CSV column header | Popup variable | What to put in the column | Formatting notes & fallback behavior |
|---|---|---|---|
customer_fist_name | {{first_name}} | Buyer’s given name (e.g., Emma) or leave blank | Keep the exact header spelling (customer_fist_name) from salespop_sample.csv |
customer_last_name | {{last_name}} | Leave blank for buyer privacy | Avoid showing surnames on public storefronts |
customer_city | {{city}} | Shipping or billing city (e.g., Austin) | If left blank, Sam FOMO drops {{city}} and its adjacent comma or bullet automatically |
customer_province | {{province}} | State, province, or region code (e.g., TX or Ontario) | Automatically omitted along with its separator if blank |
customer_country | {{country}} | Country name (e.g., United States) | Provides broad geographic proof when you omit city |
order_time | {{order_time}} | ISO 8601 timestamp (e.g., 2026-11-05T14:30:00.000Z) | Storefront converts this to relative time (7 days ago) in the shopper’s language |
product_name | {{product_name}} | Product title as sold on your Shopify store | Shown in bold inside the notification card |
product_image | Thumbnail image | Full https://cdn.shopify.com/... image URL | If blank, the popup hides the image box cleanly |
product_link | Product click URL | Full URL to the Shopify product page (/products/handle) | Makes the product title clickable in the popup |
One helpful detail built into Sam FOMO’s storefront renderer: when a row leaves an optional location field empty—such as customer_province on an order from the UK or customer_city on a privacy-trimmed row—the template engine automatically strips the empty variable and the separator next to it (,, •, ·, |, or -). You never get awkward punctuation like "Emma in , United States" on screen.
How do you map exported orders from another platform into the CSV?
If you export a raw order spreadsheet from Shopify (Orders > Export), WooCommerce, or a marketplace, its columns will not match salespop_sample.csv out of the box. Raw order exports also include billing emails, street addresses, and payment gateway IDs that do not belong in a popup app.
Follow these four steps to convert a raw order export into a clean Sam FOMO upload file:
1. Copy only the columns the popup uses
Open salespop_sample.csv in Google Sheets, Excel, or Numbers, delete the three sample rows (John Doe, Jane Smith, Mike Johnson), and map your source columns:
- First name (
customer_fist_name): Map from your export’s shipping first name. If your export combines first and last name into a singleShipping Namecolumn, split the column on the first space and discard the surname. - Location (
customer_city,customer_province,customer_country): Copy fromShipping City,Shipping Province(orShipping Province Code), andShipping Country. For digital downloads or event tickets that have no shipping address, use the billing city and country. - Timestamp (
order_time): Copy the original creation or payment timestamp (such asCreated atorPaid at) and format it as an ISO 8601 UTC string (YYYY-MM-DDTHH:mm:ss.000Z). Do not leaveorder_timeblank on historical orders; iforder_timeis empty, the parser falls back to the upload time, which would make old orders display as “just now.”
2. Collapse multi-line-item orders into single rows
In a standard Shopify order export CSV, an order with three items takes up three rows: the first row holds the customer’s name, city, country, and timestamp, while rows two and three contain only the extra Lineitem name values with blank address cells.
Before importing into your CSV recent sales popup:
- Either filter your spreadsheet to keep only the primary row for each order (where the city and timestamp are populated), or
- Fill down the customer location and
order_timevalues if you want separate notifications for each item in a multi-product order.
3. Update product_link and product_image to your Shopify URLs
If you are migrating from another platform or importing marketplace orders, the product URLs in your old export point to your old domain or marketplace listing. Replace them before uploading:
- Set
product_linkto the live product URL on your Shopify store (such as/products/linen-shirton your.myshopify.comor custom domain). If a link uses your.myshopify.comdomain, Sam FOMO automatically rewrites the path to open on the shopper’s current domain and market locale. - Set
product_imageto the Shopify CDN image URL for that product (fromcdn.shopify.com). On the storefront, Sam FOMO automatically requests a lightweight160pxthumbnail from Shopify’s CDN so full-size product photos never slow down your page.
4. Sort rows in the order you want them to play
When Sam FOMO uses Recent orders from Shopify, it sorts synced orders newest-first automatically. When you use Custom CSV file, Sam FOMO preserves the exact row order of your spreadsheet. Sort your spreadsheet with your most recent real orders at the top so visitors see the freshest purchases first.
How do you clean non-retail rows and protect buyer privacy before uploading?
In Sam FOMO, the Hide test orders checkbox and Exclude orders with these tags filter only apply to Recent orders from Shopify (excluding test, wholesale and flagged orders). They do not filter rows inside a Custom CSV file.
Before you export your final .csv, clean the sheet manually:
- Remove test, canceled, and refunded orders. Filter your source export by financial status (
paid) and delete any row whereCancelled atis populated or where you placed a checkout test. - Strip wholesale, B2B, and staff orders. Delete distributor invoices, influencer gifting orders, and warranty replacement shipments so only standard retail purchases remain.
- Delete fraud-flagged or card-testing rows. High-risk orders often contain gibberish first names or reshipper addresses that look fake on a storefront. Clean them out of your historical CSV. Going forward on Shopify, you can stop abusive checkouts, disposable emails, and known bad addresses before payment is captured by setting up checkout fraud prevention rules with LabX Fraud & IP Blocker. Its Shopify Checkout Validation Function runs server-side at checkout and cannot be bypassed, whereas storefront rules run in the browser—keeping fraudulent orders out of both your Shopify admin and your live sales popups.
- Apply privacy-first formatting. Leave
customer_last_nameblank on every row. If you sell sensitive products, luxury goods, or ship into small towns or EU countries covered by GDPR (Regulation (EU) 2016/679), leavecustomer_fist_nameandcustomer_cityblank as well and useSomeone in {{country}} bought {{product_name}}in your message template. Read our guide on sales popup customer privacy for tier-by-tier examples.
How do you upload a CSV for Recent Sales popups in Sam FOMO?
Sam FOMO is free to install, Built for Shopify, and rated 4.6★ from 17 reviews on the Shopify App Store (Oct 2026). Once your .csv file is ready, uploading it takes a couple of minutes.
Step 1: Enable the Sam Boost Sales app embed
Open Sam FOMO in your Shopify admin. If you have not enabled the theme embed yet, click Enable in the setup guide on the app home, confirm Sam Boost Sales is toggled on in your theme editor’s App embeds panel, and click Save (install and enable guide).
Step 2: Create or open a Recent Sales notification
Go to Notifications in the Sam FOMO menu. Click Create notification, choose Recent Sales, and click Add—or click the edit icon on an existing Recent Sales notification (create a notification).
Step 3: Write the popup message with variables
In the Content section, edit the Message and Caption fields using the clickable variable pills (Recent Sales guide):
- First name + city: Message
{{first_name}} in {{city}} bought {{product_name}}· Caption{{country}} • {{order_time}} - Anonymous buyer + country: Message
Someone in {{country}} bought {{product_name}}· Caption{{order_time}}
Step 4: Select Custom CSV file and upload your spreadsheet
Under Show notifications from, select Custom CSV file:
- If you still need the template headers, click Download the sample CSV under How to use to download
salespop_sample.csv. - Drag and drop your prepared
.csvfile (up to 5 MB) into the Upload Sales Pop CSV dropzone, or click to select it from your computer. - Sam FOMO parses the file in your browser and validates the headers against the nine supported column names.
- During import, the uploader automatically strips completely empty rows and removes duplicate entries that share the same first name, last name, product name, and
order_time. A banner confirms how many entries were processed and how many empty or duplicate rows were removed.
Step 5: Inspect Data preview and adjust timing
Once the upload finishes, check the Data preview card right below the dropzone. It displays the first 5 rows (First Name, Last Name, Product, City, Country, and formatted Order Time) along with a badge showing the total row count.
Next, open the sections below Content (design, placement and timing guide):
- Design: Choose Classic, Trust Badge, Dark Mode, or Urgency, and tick Match store style to inherit your theme’s typography, corner radius, and colors.
- Placement: Pick the screen corner, choose which pages display the popup under Show on, and set a separate mobile position under More placement options so the card never covers your sticky Add to Cart bar.
- Timing: Expand More timing options and tick Show each only once or cap the maximum notifications per page. This is especially important when importing a smaller CSV of 15 or 30 historical orders so shoppers never see the same order twice.
- Translations: If you sell internationally, Sam FOMO formats relative order times (
{{order_time}}) in 13 supported storefront languages automatically; add translated message text in the Translations section (localized social proof guide).
Switch the live preview between Desktop and Mobile, then click Save in the top bar.
When should you switch from a CSV file to live Shopify orders?
A CSV import is a bridge for your migration or offline sales, not a file you want to maintain by hand every week. Because Custom CSV file notifications do not append new Shopify checkouts automatically, plan your handoff to live orders as soon as your Shopify checkout gains traction:
- After your store processes its first 10 to 20 retail orders on Shopify, open your Recent Sales notification in Sam FOMO (how to add sales popups to Shopify).
- Under Show notifications from, switch from Custom CSV file to Recent orders from Shopify. (Sam FOMO keeps your uploaded CSV cached in the editor while you preview, so you can compare both feeds before saving.)
- Set Time range to Last 30 days (or Custom days from current, up to 60 days), tick Hide test orders, add any non-retail tags like
wholesaleorstaffunder Exclude orders with these tags, and click Sync orders now. - Verify your live orders in Orders preview and click Save.
- Check Analytics in Sam FOMO (analytics and usage guide) to monitor Impressions, Visitors, Clicks, Click-through rate, and Close rate across mobile and desktop.
Frequently asked questions
Can I import historical orders from another platform into a Shopify sales popup?
Yes, as long as every row in your CSV represents a real customer purchase for a product you sell on your Shopify store. In Sam FOMO, open your Recent Sales notification, select Custom CSV file under Show notifications from, download the sample CSV template, map your real orders to the columns, and upload the file (up to 5 MB).
What columns are in the Sam FOMO sample CSV file?
The sample CSV (salespop_sample.csv) uses nine optional column headers: customer_fist_name, customer_last_name, customer_city, customer_province, customer_country, order_time, product_name, product_image, and product_link. Keep the exact header spelling from the sample file so the uploader maps each column to your popup variables.
Why does Shopify only sync the last 60 days of orders by default?
Under Shopify’s Admin API access scopes, the standard read_orders scope covers orders created within the last 60 days unless an app requests and receives separate read_all_orders approval. If your store is returning from a seasonal break and your real orders are older than 60 days, uploading a CSV lets you display those historical orders with their true purchase dates.
Do tag and test-order exclusions apply to a Custom CSV file in Sam FOMO?
No. The Hide test orders checkbox and Exclude orders with these tags list only filter orders fetched under Recent orders from Shopify. When you upload a Custom CSV file, Sam FOMO removes blank rows and duplicate entries automatically, so you should delete any test, wholesale, canceled, or refunded rows in your spreadsheet before uploading.
Should I change the order_time column in my CSV to make old orders look recent?
Never. Changing historical timestamps to make months-old orders read "2 minutes ago" misleads shoppers and turns a real sale into a false purchase notification. Keep the original purchase timestamp in ISO 8601 format so the popup shows the true order age, or hide the time variable if you prefer not to show dates.
Sources
- Shopify Developer Docs: Shopify API access scopes (read_orders 60-day window)
- Shopify Developer Docs: App Store requirements, 1.1.4 Use only factual information
- Shopify Developer Docs: Work with protected customer data
- US Government Publishing Office: 16 CFR Part 465, Rule on the Use of Consumer Reviews and Testimonials
- EUR-Lex: Regulation (EU) 2016/679 (General Data Protection Regulation)
Part of our guide: Social proof →