The challenge
The company, a Scandinavian fashion retailer, operates inventory across multiple warehouse locations managed within Sage Intacct. Their Shopify storefront needed to display accurate available-to-sell quantities, but the standard integration approach aggregated inventory without distinguishing between locations — causing availability figures on Shopify to reflect stock that was reserved, in transit, or held in non-fulfillable locations. Custom warehouse mapping logic was required to ensure Shopify showed only genuinely available inventory.
What we built
- Built custom warehouse mapping logic within the Shopify-Sage Intacct integration that selectively aggregated inventory from designated fulfillable Intacct locations into Shopify availability figures
- Implemented location filter rules to exclude reserved stock, in-transit inventory, and non-fulfillable warehouse positions from the Shopify-facing quantity calculation
- Established configurable warehouse-to-channel mapping so different Shopify sales channels or product categories could draw availability from different Intacct location subsets
- Created automated inventory quantity push workflows triggered by Intacct stock movements, ensuring Shopify reflected location-specific changes without delay
- Built reconciliation logging to provide the operations team with audit visibility into how Shopify quantities were derived from Intacct warehouse data
The outcome
- Shopify inventory availability accuracy improved significantly, with figures reflecting only genuinely fulfillable stock from designated warehouse locations
- Oversell incidents caused by Shopify displaying unavailable or reserved inventory reduced following deployment of warehouse mapping logic
- Operations team gained configurable control over which Intacct locations contributed to Shopify availability, enabling location strategy adjustments without reengineering
- Customer experience improved as displayed product availability more reliably matched actual fulfillment capability