Case Study | Lighting Distribution
Lighting Supply: 500K SKU ERP Integration
500,000 SKUs and a legacy ERP that wasn’t ready.
INDUSTRY
Lighting Distribution
PLATFORM
Magento
MODEL
B2B + B2C Hybrid
FOCUS
ERP Integration & Large Catalog
The challenge
Scale meets legacy systems
Managing 500,000+ SKUs is not a standard eCommerce problem. The company serves contractors ordering 100 fixture units for commercial projects and homeowners buying a single pendant.
Great Plains ERP manages manufacturing, inventory, and accounting, but wasn’t designed for bidirectional sync with modern eCommerce. Without tight integration, the website showed products in stock when GP had zero inventory.
Orders placed online didn’t reach GP for manual processing. Contractors couldn’t trust inventory visibility. The operational team spent hours on manual reconciliation.
Building the bridge
ERP meets modern eCommerce
eBridge Connections creates continuous bidirectional sync between Great Plains and Magento. Product pricing, inventory levels, and customer records synchronize automatically.
RapidFlow manages bulk product imports. SearchSpring replaces native search for fast faceted navigation by fixture type, wattage, color temperature, and installation method.
What we delivered
From disconnected systems to unified operations
Real-time GP-to-Magento sync
When GP inventory changes, the website reflects it within hours. When a contractor orders online, it appears in GP complete with customer data and line items – ready for fulfillment.
500K products without breaking
MySQL reconciliation scripts identify products missing images, wrong pricing, or disconnected attributes. Operations fixes data quality systematically, not reactively.
Dual pricing, single platform
Contractors see volume-based and account-specific rates. Homeowners see retail pricing. Customer group assignment happens automatically. B2B orders follow a separate fulfillment pipeline.
SearchSpring product discovery
Fast faceted navigation across half a million products by fixture type, wattage, color temperature, and installation method. Standard search can’t handle this scale.
Payment and fraud security
Braintree processes transactions. Kount fraud detection screens orders without blocking legitimate transactions for both consumer and contractor order sizes.
The bottom line
Your ERP isn’t holding you back – disconnection is.
Contractors can trust what they see on the website. Orders placed online appear immediately in the fulfillment system. The operations team recovered significant time.
Frequently Asked Questions
Yes. A well-engineered integration bridge (like eBridge Connections) creates continuous bidirectional sync. Your ERP and eCommerce work together – contractors get digital ordering, your team gets their time back.
Automated reconciliation scripts identify products missing images, wrong pricing, or disconnected attributes. The operations team fixes issues systematically through reports, not by hunting for problems reactively.
If your ERP and your storefront are running as separate systems and your team is bridging the gap manually, let’s talk about connecting them properly.
Ready to connect your ERP to modern eCommerce?
Let us discuss what you’re building.
We respond within one business day.