Q4 2024 (October 1 – December 31) · Source: Square POS export · 8,909 line items · 4,624 transactions
Three issues are costing you money: product name fragmentation hiding your true bestsellers, stockouts during peak buying periods, and 82% of revenue from customers you can't identify or remarket to.
40 products went to zero inventory for 2+ weeks during Q4. Customers wanted these products and couldn't buy them. Most critical: Wingspan went out of stock Dec 10 and never restocked — peak gift-buying season for a proven seller.
View all stockout events →36 products appear under multiple names in your POS system. Your velocity reports, bestseller lists, and reorder triggers are wrong because the same product is split across 2-3 entries. Example: "Dragon Shield Sleeves" appears as 3 different items.
See the fragmentation →Only 25 customers are identified by name, accounting for 17.7% of revenue ($35,941). The remaining $167,265 came from walk-ins you can't email about prereleases, text when their staple comes in, or track over time.
View customer breakdown →November drove 43.8% of Q4 revenue, boosted by Foundations (Nov 15), Surging Sparks (Nov 8), and Black Friday. December started strong but dropped sharply after Dec 23.
Friday revenue averages $2,847/day vs. $684 on other weekdays. Events (FNM, Commander nights) drive traffic; adjacent purchases drive margin.
TCG Sealed drives traffic but thin margins. Board Games and Supplies are your profit engines.
| Category | Revenue | % of Total | Est. Margin | Note |
|---|---|---|---|---|
| TCG Sealed | $69,090 | 34.0% | 21.4% | High volume, low margin |
| TCG Singles | $48,769 | 24.0% | 38.2% | Healthy margin |
| Board Games | $40,641 | 20.0% | 48.1% | Strong margin |
| Supplies | $24,385 | 12.0% | 55.7% | Best margin category |
| Events | $12,192 | 6.0% | 85.0% | Entry fees |
| Other | $8,128 | 4.0% | 42.0% | — |
TCG Sealed accounts for 34% of revenue but only 21% margin. One box of Foundations Draft at $109.99 makes you $18. One set of Dragon Shield Sleeves at $11.99 makes you $6.70. Per dollar invested, sleeves return 3x more margin.
Your POS allows free-text entry. The same product gets entered differently by different staff, splitting its sales across multiple records. Your bestseller reports are wrong.
Your POS shows these as three separate products:
| Product (Normalized) | Variants | Combined Revenue | Example POS Names |
|---|---|---|---|
| Pokemon Surging Sparks Booster Box | 3 | $5,676 | PKM SS BB, Pokemon SS Booster, Surging Sparks Box |
| MTG Foundations Draft Booster Box | 4 | $4,892 | FDN Draft BB, MTG Found Draft, Foundations Draft Box |
| Dragon Shield Sleeves – Matte Black | 3 | $2,773 | DS Matte Black, Dragon Shield Black, DS Sleeves Black |
| Ultra Pro Deck Box | 2 | $1,456 | UP Deck Box, Ultra Pro DB |
Products that were selling consistently, then went to zero for 2+ weeks. These are likely out-of-stock events, not demand changes. Customers wanted these and couldn't buy them.
Wingspan was selling steadily through November — a proven holiday gift game. It went to zero around Dec 10 and never restocked. That's your highest-demand window for board games, and one of your proven sellers was missing from the shelf. Estimated lost revenue: $180–$360.
| Product | Out of Stock | Days | Status |
|---|---|---|---|
| Wingspan | Dec 10 – Dec 31 | 21 | Never restocked |
| Ticket to Ride | Dec 15 – Dec 28 | 13 | Restocked Dec 28 |
| Pokemon ETB (Surging Sparks) | Nov 22 – Dec 6 | 14 | Restocked Dec 6 |
| Commander Precon (Duskmourn) | Oct 18 – Nov 1 | 14 | Restocked Nov 1 |
You have names for 25 customers. They account for 17.7% of revenue. The other 82.3% is invisible — you can't remarket to them.
| Customer | Revenue | Visits/Week | Primary Category |
|---|---|---|---|
| Mike T. | $7,858 | 4.4 | TCG Singles |
| Sarah K. | $3,241 | 2.1 | Board Games |
| James R. | $2,876 | 3.2 | TCG Sealed |
| David L. | $2,445 | 1.8 | TCG Singles |
| Chris M. | $2,102 | 2.4 | Supplies |
If you captured email/phone at checkout for just 20% of walk-in transactions, you'd have 740 contactable customers by end of Q1. That's a mailing list for prerelease announcements, restock alerts, and event promotion.
Upload your Square export. We'll identify stockouts, fragmentation issues, and customer visibility gaps specific to your store.
Request a Free Inventory Audit →