API Case Study
Store and ERP, Connected So Nothing Is Typed Twice
An online retailer copied orders from its store into its ERP by hand, and stock was never quite right. Custom APIs now keep orders, stock and prices in sync between the two.
Results at a glance
- 0Manual re-keying of ordersPeriod not stated · Internal measure
- 4 wkFrom kickoff to livePeriod not stated · Internal measure
The challenge: Orders copied by hand, stock always a little wrong
Each day, someone exported orders from the store and keyed them into the ERP, then updated stock levels back in the store by hand. The two were always slightly out of step, so items showed as available when they were not, and prices did not always match.
- Orders were exported and re-keyed into the ERP.
- Stock was updated in the store by hand, late.
- Prices in the store and ERP could drift apart.
- Oversells and corrections cost the team time.
The solution: Custom APIs that keep both systems in sync
New orders are pushed to the ERP as they happen, stock changes flow back to the store, and price updates go out to both. Webhooks trigger each sync the moment something changes, so the systems stay matched without anyone touching them.
- Orders pushed to the ERP as they are placed.
- Stock levels synced back to the store.
- Price changes pushed to both systems.
- Webhooks trigger each sync in real time.
How it was delivered: Mapped the data, then connected it safely
We ran the sync alongside the manual process first to check the figures, then switched it on fully.
The integration went live in four weeks.
The outcome: Orders flow straight through, stock stays accurate
The team no longer fixes oversells or chases mismatches, and the store and ERP agree.
Related service
EngineeringRelated
More case studies
More case studies, and the case studies hub.
- ResourceCase studiesCase studies of ERP, AI and custom software projects delivered by TCB Infotech: the problem…
- Case studyOdoo eCommerceHow a direct-to-consumer online retailer connected its catalog to live stock in Odoo eCommerce…
- Case studyOdoo POS for retailHow a multi-store retailer connected nine stores on Odoo POS with a one-click daily close and 22% fewer stock errors…
- Case studyAI Finance AgentA finance AI agent reads supplier invoices, matches them to orders and prepares entries for approval…
- Case studySupport ChatbotA support AI chatbot grounded in the help centre and orders now answers about 70% of routine questions instantly…
- Case studyAuto Parts Order CyclesAn automotive parts manufacturer connected sales…
- Case studyLead-Gen ChatbotA lead-generation chatbot qualified visitors, captured details into the CRM and booked demos after hours…
- Case studyB2B Ordering AppA self-service B2B ordering web app let trade customers of a distributor order online around the clock…
- Case studyContractor Project CostingA building contractor put BOQ, procurement, billing and cost on one ERPNext system across eight projects…
- Case studyInfrastructure ProjectsAn infrastructure EPC firm ran packages, subcontractors and multi-stage billing on SAP S/4HANA…
- Case studyDairy PlantA dairy processor put milk intake, batch traceability, quality and cold-chain dispatch on one ERPNext system…
- Case studySix-College UniversityA six-college university group ran programs, enrollment, exams and finance on one ERPNext platform…