ERP integration

ERP integration designed around data ownership and operational reality.

We connect eCommerce platforms and custom applications to ERP systems for orders, customers, products, pricing, inventory and downstream status. The work begins by defining who owns each piece of data and what should happen when either system is unavailable.

The bigger picture

Start with the business and technical reality

ERP integration is often described as a list of endpoints, but the difficult decisions are operational. Should an online order be considered accepted before the ERP confirms it? Can customers change addresses after export? Which system calculates trade pricing? How quickly must stock changes reach the website? What happens to an order that fails validation?

We answer these questions before implementation because they determine transaction boundaries and recovery behaviour. A technically successful API call is not enough if the business cannot explain whether an order is complete, duplicated, rejected or waiting for intervention.

Integrations can be API-led, queue-based, scheduled or file-based depending on the ERP’s capability and the required timing.

Typical situations

When clients bring us in

  • Orders are manually keyed into ERP
  • ERP prices and website prices regularly diverge
  • Customer account data must be shared with B2B eCommerce
  • Product or stock updates take too long to reach the storefront
  • Failed orders require developers to recover them manually
  • A new ERP implementation needs a controlled eCommerce interface
The objective

What good delivery should leave behind

A successful engagement should improve more than the immediate feature or incident. It should make the system easier to understand, safer to change and more visible to the people responsible for operating it.

  • Clear technical ownership and responsibilities
  • Maintainable code and configuration
  • Visible failures rather than silent data loss
  • Controlled release and recovery paths
  • Documentation for future developers and operators
  • A sensible next-step roadmap rather than permanent firefighting
What the work covers

Technical depth across the parts that matter

The exact scope depends on the existing environment and commercial priorities. We focus on the areas that materially affect reliability, maintainability and delivery rather than adding process for its own sake.

Orders

Export validated orders, amendments where permitted, cancellations and relevant payment information.

Customers

Synchronise account identifiers, addresses, credit or trade information according to business rules.

Products & pricing

Move master data, customer-specific prices, tax or catalogue information where the ERP is authoritative.

Inventory

Publish appropriate sellable or available quantities without exposing internal warehouse complexity unnecessarily.

Status

Return acceptance, allocation, invoicing, fulfilment or other states required by eCommerce and service teams.

Control

Log, retry, reconcile and manually recover exceptions without duplicating transactions.

Problems we look for

Common failure patterns that create unnecessary cost

Many technical problems are recurring patterns rather than isolated defects. Identifying them early helps avoid repeatedly paying to treat the visible symptom.

  • Orders accepted online but rejected by ERP validation
  • Customer records duplicated because identifiers are inconsistent
  • Website stock reflecting raw ERP quantity instead of sellable availability
  • Pricing synchronisation overwriting intentional promotional logic
  • Retries creating duplicate orders
  • No reconciliation report between commerce and ERP
How we work

A controlled route from uncertainty to production

We prefer visible, reviewable delivery. The exact sequence changes with the project, but the principle is to reduce uncertainty early and keep each production change understandable.

01Map the order and data lifecycle
02Define authoritative systems
03Agree payloads and identifiers
04Implement and test one direction at a time
05Exercise duplicates, timeouts and invalid data
06Provide monitoring and operational reconciliation
Engineering judgement

Technology is part of the answer, not the starting question

We can work with modern APIs as well as older ERP interfaces using files, scheduled exports or middleware. The best integration is the one the operational team can trust and support, not necessarily the one using the newest transport.

Where specialist capability comes from our wider engineering team, we are transparent about the proposed delivery model and match the person or team to the actual requirement rather than presenting a long list of technologies as if every project needs all of them.

Delivery models

Use the level of ownership that fits your team

Defined project

Midoriweb owns an agreed scope with clear milestones, acceptance criteria and release responsibilities.

Specialist workstream

Bring us into one technically difficult area while your existing team or agency owns the wider programme.

Team augmentation

Add developers to your existing process for a fixed period or an ongoing roadmap.

Ongoing technical partner

Combine support, maintenance, monitoring and planned improvement under continuing technical ownership.

Frequently asked questions

Questions worth answering before work starts

Can you integrate Magento Open Source with an ERP?

Yes. Magento is a common integration endpoint and one of our core technical specialisms.

What if our ERP has no modern API?

File, SFTP, database or middleware-based interfaces can still be appropriate if they are designed with validation and recovery in mind.

Should stock be real-time?

It depends on the business. We assess overselling risk, warehouse behaviour, source-system performance and how frequently inventory actually changes.

How are failed orders handled?

We design explicit failure states, logging and a safe retry or manual recovery path.

Can you migrate an existing integration?

Yes. We can map current behaviour, identify hidden business rules and transition flows in controlled stages.

Can you work with our ERP supplier?

Yes. Joint interface definition and testing is normal on integration projects.

Related expertise

Continue exploring

Have a requirement in this area?

Send the current situation, desired outcome, platform or systems involved and any important deadline. We can review the detail first or discuss it in a short consultation.