An ERP-connected store that stopped finance re-keying payments
A distributor’s ageing store did not talk to its ERP, so inventory, orders and payments were reconciled by hand. The rebuilt store keeps 1,100+ SKUs, orders and payments in step with NetSuite.
Context
The client is a US wholesale distributor supplying retail stores in a national carrier’s network. Its retailers order in volume, on account, with pricing that depends on who they are and how much they buy. NetSuite is the system of record for products, inventory, customers and finance.
The problem
The existing store had been built before the ERP and never connected to it. Products and stock levels were maintained twice. Orders were exported and re-entered. Payments arrived by cheque or wire and finance matched them to invoices by hand. With 1,100+ SKUs and a growing retailer base, the manual work was becoming the bottleneck.
Our approach
We rebuilt the store on nopCommerce and made NetSuite the only place anyone edits a product, a price or a stock level.
- Two-way integration. Products, pricing tiers and inventory flow from NetSuite to the store; orders and customer changes flow back. Sync jobs are incremental and idempotent, so a failed run can be re-run without duplicating anything.
- Tiered pricing. Customer groups and quantity breaks are modelled in nopCommerce to mirror NetSuite’s price levels, so a retailer sees the same price online as on the invoice.
- Mobile-first checkout. Store managers order from the shop floor, so the checkout was designed for a phone first.
- ACH payments through NACHA files. Rather than a card processor, retailers pay by bank debit. The store generates NACHA-format files on a schedule for the client’s bank, and settlement status flows back to NetSuite, which removed the manual matching.
What we built
- A rebuilt nopCommerce store with customer-group pricing and quantity breaks.
- Two-way NetSuite integration for products, inventory, customers and orders.
- Scheduled ACH payment processing via NACHA files, with reconciliation back to the ERP.
- A mobile-first checkout and account area for retailers.
The result
Retailers order and pay online, inventory and orders stay in step with NetSuite, and finance stopped re-keying payments. The rebuild and integration took six months with one engineer as a dedicated resource.
Have a similar problem?
Tell us what you are building. Hiten reads every enquiry and replies within one working day.