Air Brite Labs
Build with Air Brite Labs

Have an idea?
Let's build it.

From first concept to scalable launch, our engineers help you move forward.

Discuss your project

Wholesale System Integration

Project Overview

Client IndustryWholesale Distribution (Industrial Supplies)
Business TypeB2B wholesale distributor serving ~2,800 business customers across 4 regional warehouses
Project Duration15 week
AI Service ProvidedAPI and System Integration
Technologies UsedNode.js, REST and SOAP APIs, NetSuite ERP, Manhattan WMS, Shopify Plus (B2B), AWS (Lambda, SQS, EventBridge), PostgreSQL

The Client Challenge

The client, a B2B industrial supplies distributor operating four regional warehouses, ran on three core systems NetSuite for ERP and financials, Manhattan for warehouse management, and a recently launched Shopify Plus B2B storefront that didn’t talk to each other.

The operational consequences:

  • Inventory levels shown on the e-commerce storefront were updated via a manual nightly export/import process, meaning customers frequently saw products as available that were actually out of stock at their nearest warehouse, leading to canceled orders and customer frustration.
  • Orders placed through the online storefront had to be manually re-entered into NetSuite by an order processing team, introducing data entry errors and delaying order fulfillment by up to a full business day.
  • Warehouse staff using Manhattan WMS had no real-time visibility into online order priority or customer-specific fulfillment requirements set up in NetSuite, occasionally causing fulfillment sequencing issues for time-sensitive customer orders.
  • Pricing and customer-specific discount agreements, managed in NetSuite, weren’t reflected accurately on the storefront, requiring manual price overrides for many B2B customers with negotiated pricing.
  • The manual, three-system process required a team of 4 order processing staff essentially dedicated to re-keying and reconciling data between systems a cost the distributor recognized as unsustainable as online order volume grew.
  • Leadership wanted to grow the e-commerce channel significantly but recognized the current manual integration approach would require proportional staff growth to match, undermining the economics of the online growth strategy.

Our Solution

Air Brite Labs designed and built a real-time integration layer connecting NetSuite, Manhattan WMS, and Shopify Plus, eliminating the manual data re-entry and reconciliation process and giving all three systems a consistent, real-time view of inventory, orders, and pricing.

Key capabilities delivered:

  • Real-time inventory synchronization — stock levels across all four warehouses sync from Manhattan WMS to the Shopify storefront continuously, eliminating the stale inventory data that had been causing canceled orders.
  • Automated order flow — orders placed on the storefront flow automatically into NetSuite and Manhattan without manual re-entry, cutting order processing time and eliminating re-keying errors.
  • Customer-specific pricing sync — negotiated pricing and discount agreements managed in NetSuite now reflect automatically on the storefront for each logged-in B2B customer, eliminating manual price override work.
  • Warehouse-aware fulfillment routing — orders route to the correct regional warehouse automatically based on customer location and real-time stock availability, rather than defaulting to a single fulfillment center.
  • Fulfillment priority visibility — customer-specific fulfillment requirements and order priority set in NetSuite are now visible to Manhattan WMS warehouse staff, resolving the sequencing issues that had affected time-sensitive orders.
  • Exception handling and alerting — integration failures or data mismatches trigger automatic alerts to the operations team rather than silently causing downstream errors, replacing what had been a purely reactive discovery process.

Technical Approach

Integration Architecture: Built a custom middleware integration layer on AWS Lambda, rather than relying on a generic iPaaS tool, given the complexity of the client’s specific NetSuite customizations and Manhattan WMS configuration that off-the-shelf connectors didn’t adequately support.

Inventory Sync: Event-driven synchronization using AWS Event Bridge inventory changes in Manhattan WMS trigger near-real-time updates to Shopify’s inventory levels per warehouse location, replacing the prior nightly batch export/import process entirely.

Order Flow: Orders placed on Shopify trigger a Lambda-based workflow that creates the corresponding sales order in NetSuite via NetSuite’s SuiteTalk API (SOAP-based) and simultaneously creates the fulfillment request in Manhattan WMS via its REST API, with AWS SQS providing reliable message queuing to handle volume spikes without dropped orders.

Pricing Integration: Built a synchronization service that pulls customer-specific pricing and contract terms from NetSuite and applies them to the corresponding customer accounts on Shopify Plus’s B2B pricing functionality, keeping negotiated pricing consistent across systems without manual maintenance.

Warehouse Routing Logic: Built custom routing logic that considers customer shipping address, product availability across all four warehouses, and shipping cost optimization to automatically determine the correct fulfillment warehouse for each order.

Error Handling & Monitoring: Every integration point includes structured error handling with automatic retry logic for transient failures and alerting (via email and Slack) for issues requiring human intervention, replacing what had been silent failures discovered only when a customer complained.

Data Layer: PostgreSQL used as an intermediary data store for integration state tracking and reconciliation logging, providing an audit trail across the three-system data flow that didn’t exist previously.

Implementation Process

  • Discovery & Requirement Analysis (Weeks 1–3): Mapped the existing manual data flow between all three systems in detail, including undocumented NetSuite customizations and Manhattan WMS configuration specifics that needed to be accounted for in the integration design.
  • Prototype / PoC (Weeks 4–5): Built and validated the inventory synchronization flow first, as the highest-impact, most contained integration point, testing against real inventory data from one warehouse before expanding.
  • Development (Weeks 6–10): Built the full order flow integration, pricing synchronization, and warehouse routing logic across all four warehouse locations.
  • Integration (Week 11): Connected all integration points into the unified middleware layer and configured error handling and alerting.
  • Testing (Weeks 12–13): Ran the integration in parallel with the existing manual process for two weeks, comparing order accuracy and inventory sync reliability before removing the manual fallback process.
  • Deployment (Week 14): Fully cut over to the automated integration, retiring the manual order re-entry and nightly inventory export process.
  • Optimization (Week 15 and ongoing): Tuned warehouse routing logic based on real order and shipping cost data, refined alerting thresholds to reduce noise while catching genuine issues.

Key Features Delivered

  • Real-time, warehouse-level inventory synchronization between Manhattan WMS and Shopify Plus
  • Automated order flow from Shopify to NetSuite and Manhattan without manual re-entry
  • Customer-specific pricing synchronization reflecting NetSuite contract terms on the storefront
  • Automated, warehouse-aware order fulfillment routing across four locations
  • Fulfillment priority visibility for warehouse staff based on NetSuite customer requirements
  • Structured error handling with automatic retry and human alerting for integration failures
  • Full audit trail of order and inventory data flow across all three systems

Business Results

  • Order-related customer cancellations due to inventory discrepancies dropped by an estimated 80%
  • Order processing time from storefront to warehouse fulfillment dropped from up to 24 hours to near real-time
  • The dedicated order re-entry function was eliminated, reallocating the equivalent of roughly 3 full-time staff to other operational priorities
  • Pricing-related customer service inquiries decreased significantly following automated pricing synchronization
  • The distributor grew online order volume by over 50% year-over-year without adding order processing headcount, directly supporting the leadership team’s e-commerce growth strategy
  • Warehouse fulfillment sequencing errors related to missing priority information were largely eliminated

Technology Stack

LayerTechnology
Integration MiddlewareNode.js, AWS Lambda
MessagingAWS SQS, EventBridge
ERPNetSuite (SuiteTalk API)
Warehouse ManagementManhattan WMS (REST API)
E-CommerceShopify Plus (B2B)
DatabasePostgreSQL

Why the Solution Worked

The integration succeeded because it was purpose-built around the client’s specific system configurations rather than forced through a generic integration platform that couldn’t accommodate their particular NetSuite customizations and Manhattan WMS setup. Understanding those specifics upfront avoided the common failure mode of an off-the-shelf connector that works for a simplified version of the business but breaks against real-world configuration complexity.

Running the new integration in parallel with the existing manual process before fully cutting over was equally important for a distributor that couldn’t afford order processing disruptions. That validation period caught discrepancies early, giving the operations team confidence in the automated system before the manual safety net was removed.

Future Scalability

The integration architecture is built to support the distributor’s continued e-commerce growth, including:

  • Adding EDI integration for large enterprise customers who require electronic data interchange for purchase orders
  • Extending warehouse routing logic to support drop-shipping arrangements as the product catalog grows
  • Adding a fifth regional warehouse to the routing and inventory sync logic as the company’s physical footprint expands
  • Building customer-facing real-time order tracking using the now-integrated order and fulfillment data

Because the integration layer is built as modular, event-driven services rather than a single monolithic connector, adding new systems or expanding to new warehouses extends the existing architecture rather than requiring a rebuild.

Final Outcome

The distributor replaced a manual, error-prone, and increasingly unsustainable three-system data reconciliation process with a real-time integration that scales with order volume rather than requiring proportional headcount growth. The e-commerce channel leadership wanted to grow now has the operational foundation to support that growth economically.

Ready to Connect Your Business Systems ?

If disconnected systems are creating manual work, errors, or growth constraints, Air Brite Labs can help you build integrations that give your team one consistent, real-time view across your business.

testimonialtestimonialtestimonial
TRUSTED BY 200+ FOUNDERS