[SAMPLE DATA] SyncRange BFCM Reporting Template - SAMPLE DATA (fake numbers)

	A	B	C	D	E
1	SyncRange BFCM Reporting Template for Shopify (Google Sheets)
2	A free Black Friday Cyber Monday dashboard built on raw SyncRange exports. Every number recalculates when SyncRange syncs.
3	SAMPLE DATA COPY: every order, product, customer ID and number in this file is fake, generated for screenshots.
4	SET UP IN 3 STEPS
5	1. Copy this sheet: File > Make a copy. Work only in your copy.
6	2. Connect SyncRange: start free at syncrange.com (no credit card required) or install SyncRange from the Shopify App Store, and connect your Shopify store. Add your copy as a Google Sheets destination (Select an Existing Sheet).
7	3. Create and schedule the exports below (Replace mode, rolling date range), then open Settings and type the exact tab names SyncRange created into the Tab name column.
8
9	Export to create	Source	Tabs to include	Date range	Feeds these tabs
10	BFCM_Shopify (required)	Shopify	Orders, Sales Metrics, Line Items, Refund Analysis, Discounts	Last 90 days, scheduled daily	BFCM Summary, Daily, Hourly, Top Products, Discounts, Customers, Refunds
11	BFCM_LY_Shopify (one-time)	Shopify	Orders, Sales Metrics	Custom range 2025-11-01 to 2025-12-15, Run now	YoY and the Last-year column on BFCM Summary
12	BFCM_History (optional, one-time)	Shopify	Orders	Custom range up to 1 year (or Maximum), Run now	More accurate new vs returning customers
13	Start with BFCM_Shopify: it feeds every tab except YoY. The last-year and history exports are one-time and each use another exporter slot, so check your plan on syncrange.com/pricing.
14
15	Which tabs need what
16	Shopify only	BFCM Summary, Daily, Hourly, Top Products, Discounts, Customers, Refunds
17	Needs last-year exports	YoY and the Last-year BFCM column on BFCM Summary (static: one-time export)
18
19	Data check	Value
20	Shopify rows found (Orders / Sales Metrics / Line Items)	507 / 507 / 1006
21	Latest Shopify order date	2026-12-07
22	Freshness	OK
23	Last-year Shopify loaded	Yes
24
25	Troubleshooting
26	A tab shows zeros: open Settings and check Rows found. 'Tab not found' means the tab name in Settings does not match the tab SyncRange created (tab names come from the export name).
27	Days are missing: make sure the export date range covers the windows in Settings, and that Order Date arrives as a date or YYYY-MM-DD text.
28	Everything is zero after a sync: Settings > Store currency must match the Currency column (leave it blank to include every currency).
29	Hourly peaks look shifted: set Order hour offset in Settings.
30	Never type in or add columns to the raw tabs (Raw_..., LY_..., Hist_...): Replace mode clears and rewrites them on every sync. Columns are found by header name, so column order does not matter.
31	Refund numbers change after Cyber Monday: expected. Refunds keep arriving for weeks, so re-sync in December.
32
33	Made by SyncRange. Field definitions: https://syncrange.com/docs/shopify-data-reference/ \| Start free, no credit card required: https://syncrange.com
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100