The Challenge: Dual-Channel Inventory Chaos

As Velvet & Vine expanded their online presence, the disconnect between their Shopify store and physical boutique became increasingly problematic. Customers would order items online only to receive cancellation notices when the physical store had already sold the last item. Staff spent hours weekly manually reconciling stock levels.

The core operational issues were:

• Manual Reconciliation: Staff manually updated spreadsheets to track stock movements between online and physical channels, consuming 12+ hours weekly.
• Customer Dissatisfaction: 15% of online orders were cancelled due to inaccurate stock information, damaging brand reputation.
• Lost Sales Opportunities: Online shoppers abandoned carts when items showed out of stock, even when physical stores had inventory.

The Solution: Real-Time Inventory Synchronisation

Edderton Scott implemented a real-time inventory sync system that connected Shopify with their point-of-sale system, creating a single source of truth for stock levels across all sales channels.

Inventory Synchronisation Flow
Shopify Store
→
Central Inventory Hub
→
POS System

Real-time bidirectional sync ensures stock levels are accurate across all sales channels, updating within seconds of any sale or return.

Phase 1: System Integration & Data Migration

We began by integrating Shopify’s API with their point-of-sale system, migrating all historical stock data into a centralised inventory database that served as the single source of truth.

Phase 2: Real-Time Sync Implementation

We developed a custom sync engine that updated stock levels in real-time across all channels, with configurable rules for safety stock and reorder points.

• Real-time stock updates across Shopify and POS within 2 seconds of any transaction
• Automated safety stock alerts when inventory drops below predetermined thresholds
• Integrated purchase order generation based on sales velocity and lead times

“The inventory sync system has transformed our operations. We’ve eliminated customer disappointment from out-of-stock issues, and our team now focuses on serving customers rather than reconciling spreadsheets. It’s given us the confidence to expand into new sales channels.”

— Isabella Chen, Retail Operations Director at Velvet & Vine

The Outcome

The real-time inventory sync system reduced stock discrepancies by 98%, virtually eliminating cancelled orders due to inventory errors. Staff saved 12 hours weekly previously spent on manual reconciliation, redirecting this time to customer service and merchandising. Lost sales from abandoned carts decreased by 85%, contributing to a 22% increase in online conversion rates within the first quarter of implementation.