The challenge
The company, Australia's largest pop culture retailer, operates both a high-volume online store and physical retail locations processing in-store transactions through Square POS. Without integration between Square and Brightpearl, in-store sales existed in a completely separate data silo — inventory deducted at POS did not automatically update Brightpearl, creating stock discrepancies that caused online oversell and inaccurate inventory reporting across the business.
What we built
- Integrated Square POS with Brightpearl so all in-store sales transactions posted automatically as Brightpearl orders, creating a unified order record across all channels
- Built real-time inventory deduction logic so Square POS sales immediately reduced available stock in Brightpearl, preventing online oversell of in-store-purchased items
- Implemented customer profile synchronization between Square and Brightpearl, consolidating in-store and online purchase history under unified customer records
- Configured product catalog synchronization so Brightpearl served as the master SKU and pricing source for Square POS terminals
- Established daily reconciliation reporting across Square and Brightpearl transaction data to support accurate financial close processes
The outcome
- In-store and online inventory data unified within Brightpearl for the first time, eliminating cross-channel stock discrepancies
- Online oversell events caused by unsynced in-store purchases reduced significantly following integration deployment
- Unified customer records spanning in-store and online purchase history enabled more effective CRM and loyalty program targeting
- Operations team gained a single, accurate view of total business inventory and sales performance across all retail channels