Customer story · EU fashion retailer
Custom NetSuite-Magento integration syncing 50,000 SKUs, customer-group pricing, real-time stock, and order data both directions. Replaced an off-the-shelf connector that was timing out and causing oversells.
The problem
An EU fashion retailer running Magento Open Source 2.4.5 plus NetSuite for ERP. They had been using a popular third-party Magento-NetSuite connector that handled small catalogs adequately but was timing out and dropping sync runs as their catalog grew past 30,000 SKUs. By the time they hit 50,000 SKUs, daily syncs were completing only 60 to 70 percent of the time, leading to stock-out mismatches and a noticeable oversell rate. They needed reliable sync without the cost of jumping to Adobe Commerce.
What we did
Custom NetSuite-Magento integration replacing the off-the-shelf connector. Architecture: batched sync (5,000 SKUs per batch with parallel workers), incremental sync (only changed records pushed, full reconciliation weekly), idempotent writes (so a failed batch can re-run without duplicating data), full audit trail (every sync event logged with row counts and error rates), and queue-based retry (transient failures retry inside the queue rather than dying). Built as a custom Magento module plus a Node worker hosted alongside their NetSuite instance.
The outcome
Daily sync completion rate went from 60 to 70 percent to 100 percent across 90 days post-launch. Sync runtime dropped from 4-6 hours (when it completed) to 35-50 minutes. Oversell rate, which had been 1.2 percent of orders before, fell to under 0.1 percent. Customer-service tickets related to "ordered out-of-stock product" dropped roughly 90 percent. Total integration build six weeks plus two weeks parallel-running both systems before cutting over.