The challenge
The company, a heritage specialty food and gift brand, operates its eCommerce channel through BigCommerce and its enterprise resource planning on Sage X3. Their business model includes seasonal gifting peaks and recurring subscription products that introduce order complexity not addressed by standard integration patterns. Connecting BigCommerce to Sage X3 required custom business logic to accurately handle subscription order lifecycles, seasonal product configurations, and the specific financial and inventory structures of Sage X3.
What we built
- Built a custom BigCommerce-to-Sage X3 integration with bespoke field mapping and transformation logic tailored to The company' Sage X3 configuration
- Implemented subscription order handling logic to correctly represent recurring BigCommerce subscription charges as distinct order types within Sage X3 for accurate financial treatment
- Configured seasonal product and gift set order routing rules within the integration layer to handle bundled SKU fulfillment and inventory deduction in Sage X3
- Established customer record creation and update logic from BigCommerce into Sage X3, maintaining consistent customer identity across both platforms
- Built inventory availability sync from Sage X3 back to BigCommerce with logic to reflect seasonal stock constraints and prevent oversell during high-demand gifting periods
The outcome
- Sage X3 received accurate, well-formed BigCommerce order data aligned to The company's financial structure, enabling clean ERP-based reporting and fulfillment
- Subscription order processing in Sage X3 became automated and consistent, eliminating manual handling of recurring order records
- Seasonal peak periods managed without operational disruption as inventory constraints in Sage X3 flowed automatically to BigCommerce availability
- The company gained a durable integration foundation capable of accommodating future product line expansions and operational changes