Billiard Factory Revenue Operations

Billiard Factory had grown to 4,000+ SKUs across physical showrooms and digital channels, but their product data lived in silos. The ERP said one thing, the website said another, and showroom staff were making pricing decisions from outdated spreadsheets. Revenue attribution was guesswork — they couldn't tell which channels were actually driving sales, and inventory decisions were reactive instead of strategic. Manual coordination between systems was consuming 15+ hours per week across their operations team.

Build a unified product data architecture that feeds every sales channel from a single source of truth. Enable real-time revenue attribution across physical and digital touchpoints. Eliminate manual data reconciliation and give the leadership team a clear picture of what's selling, where, and why.

I architected a unified product data engine that connects their ERP to Shopify Plus through n8n automation workflows. Every SKU — pricing, inventory levels, specifications, and imagery — now syncs in real-time across all channels. I built a cross-channel revenue attribution model that tracks customer journeys from first touch through purchase, regardless of whether the sale closes online or in-showroom. The operations team went from 15+ hours of manual reconciliation per week to near-zero. The unified data layer also enabled demand-signal forecasting — the system now identifies which products are trending before they sell out, enabling proactive inventory decisions instead of reactive restocking.