Construction / Surface Coatings Company

The challenge

The company, a surface coatings manufacturer, operates one of the most complex multi-channel commercial footprints in its segment: direct-to-consumer and commercial sales, Amazon FBA for marketplace fulfillment, Amazon FBM for self-fulfilled marketplace orders, retail EDI via SPS Commerce for national retail distribution, Salesforce for CRM and sales pipeline management, and Sage Intacct for financial consolidation. Every channel generated data that needed to flow accurately into Intacct for financial reporting, while Salesforce needed visibility into order activity across all revenue streams.

What we built

• Built a centralized integration architecture connecting all five platforms — Sage Intacct, Amazon FBA, Amazon FBM, SPS Commerce, and Salesforce — through a unified data orchestration layer
• Integrated Amazon FBA order, fulfillment, and inventory data into Sage Intacct for automated revenue recognition and channel-level financial reporting
• Connected Amazon FBM order and shipment workflows to Intacct with FBM-specific fulfillment logic distinct from FBA operations
• Implemented SPS Commerce EDI transaction flows — purchase orders, order acknowledgments, advance ship notices, and invoices — integrated with Intacct for retail channel financial management
• Established Salesforce CRM synchronization with order activity data from all channels, giving the sales team a consolidated view of customer revenue across Amazon, EDI retail, and direct channels

The outcome

• Sage Intacct consolidated financial data from all five revenue channels automatically, enabling comprehensive channel-level reporting without manual data aggregation
• Amazon FBA and FBM operations managed through integrated workflows, eliminating separate manual processes for each Amazon fulfillment model
• SPS Commerce EDI retail compliance maintained through automated transaction management, reducing chargeback exposure from major retail partners
• Salesforce provided the sales team with a full cross-channel customer revenue picture, enabling more informed account management and growth planning