Connect · Pillar 02
ERP integration that leaves the core alone.
Your ERP is the system of record and it should stay that way. The answer to a gap in it is almost never a customisation that makes the next upgrade impossible.
What is ERP integration?
ERP integration is connecting an enterprise resource planning system to the other applications a business runs — e-commerce, CRM, warehouse management, carriers, customer portals and reporting — so the ERP stays the single system of record while the surrounding tools read from and write to it through supported interfaces rather than direct database access.
- The ERP keeps owning stock, pricing, costing and the ledger.
- Extensions sit outside the core, so upgrades stay possible.
- Integration uses supported APIs, never unsanctioned database writes.
Why it matters
The two ways ERP programmes go wrong.
The first is over-customisation. The ERP does not quite fit, so it gets modified — and each modification makes the next version upgrade harder, until the business is stranded on a release that is no longer supported and the vendor cannot help. We see the end state of this often, and by then the only routes out are expensive.
The second is the opposite: nothing is integrated, so the ERP is surrounded by spreadsheets and rekeying, and the system of record is quietly no longer the record. The way through the middle is to extend around the ERP and integrate into it, leaving the core as the vendor shipped it.
How we protect the upgrade path
The customisation trap
Every ERP engagement starts with these constraints written down, because they are what keeps you able to take the vendor’s next release:
- You are several versions behind because upgrading would break custom code.
- Stock in the ERP and stock on the website routinely disagree.
- Orders from the webshop are rekeyed into the ERP by hand.
- Despatch and carrier labelling happen outside the ERP entirely.
- Management reporting is rebuilt in Excel from ERP exports every month.
- A consultant writes directly to ERP tables, and everyone hopes for the best.
Scope
What ERP integration covers.
We are not an ERP reseller and we do not implement ERPs from scratch. We connect and extend the one you run.
-
E-commerce & marketplaces
Products, pricing, stock and orders synchronised both ways between the ERP and your web channels, with availability that reflects what is genuinely sellable.
-
Warehouse & despatch
Picking, packing, carrier selection and label generation driven from ERP data, with tracking and proof of delivery written back against the order.
-
CRM & service
Customer, credit, order history and delivery status shared with CRM and support, so commercial teams work from the ERP’s truth rather than a copy of it.
-
Extensions outside the core
The functionality the ERP lacks, built as a separate application reading and writing through supported interfaces. Your upgrade path survives intact.
-
Reporting & data warehouse
ERP data replicated into a reporting store, so analysis never competes with transactions for resources and month end does not slow the warehouse down.
-
Governance & audit
Documented interfaces, change control and audit trails for everything written back, which is what your auditors and the ERP vendor will both want to see.
Deliverables
What good ERP integration delivers.
Success here is partly what you gain and substantially what you stop losing.
-
An ERP you can still upgrade
Because the extensions are outside the core, the vendor’s next release is a planned project rather than an impossibility. This is the most valuable and least visible outcome.
-
Stock figures that agree everywhere
One authoritative availability number, derived in the ERP and published to every channel, so overselling and the goodwill cost of it stop.
-
Orders that flow without hands
Web, EDI and portal orders landing in the ERP validated and priced, with no rekeying step and no transcription errors to credit later.
-
Reporting that does not fight the ERP
Analysis runs against a replica, so finance can work at month end without slowing down despatch, and the ERP is not tuned for two conflicting jobs.
Is this the right answer?
When erp integration is worth doing — and when it is not.
We would rather lose a project at this stage than six weeks in. If the right-hand column describes you, say so and we will tell you what we would do instead.
Worth doing when
- Stock in the ERP and stock on your website routinely disagree.
- Web or EDI orders are rekeyed into the ERP by hand.
- Management reporting is rebuilt in Excel from ERP exports every month.
- You need capability the ERP lacks and do not want to customise the core.
Probably not when
- The ERP is genuinely the wrong system and no amount of integration fixes that.
- A consultant is already writing directly to ERP tables and that is not going to stop.
- You want the core modified to match a process you could change instead.
- Nobody can tell you which interfaces your ERP vendor actually supports.
How we deliver
How we work around an ERP.
Carefully, and in the vendor’s supported directions. The constraints are agreed in writing before we build anything.
-
Phase one
Interface survey
What your ERP genuinely supports — APIs, web services, staging tables, supported extension points — and what is off limits. Output is a written integration standard for the estate.
-
Phase two
The highest-volume flow
Usually orders in or stock out. Built through supported interfaces, with reconciliation proving the ERP and the channel agree.
-
Phase three
Extend around the gap
The missing functionality, built as a separate application alongside the ERP rather than inside it, sharing its data through the standard from phase one.
-
Phase four
Replicate for reporting
ERP data into a reporting store on a schedule the operation can absorb, so analysis and transactions stop competing.
What you receive
The things that actually land.
Artefacts, not adjectives. Everything below is listed in the scope document before a phase starts, so “done” is a defined state rather than an opinion.
-
An interface survey
What your ERP genuinely supports — APIs, web services, staging tables, extension points — and what is off limits. Becomes the standard every future integration is built to.
-
Integrations through supported routes
Built so the vendor can still support you and the next version upgrade is a planned project rather than an impossibility.
-
One availability figure
Derived in the ERP accounting for allocation, goods in transit, minimum levels and multiple locations, then published to every channel.
-
A reporting replica
ERP data copied into a reporting store on a schedule the operation can absorb, so month end does not compete with despatch.
-
Extensions outside the core
Missing functionality built as a separate application that shares ERP data through sanctioned interfaces.
-
Governance documentation
Documented interfaces, change control and audit trails for everything written back — what your auditors and your ERP vendor will both ask for.
Golden Triangle
ERP in Midlands manufacturing and distribution.
This corridor runs more ERP per square mile than most of the UK, and a lot of it is heavily aged.
- Manufacturing ERP MRP and routings Bills of materials, routings, work orders and capacity planning make manufacturing ERP integration materially harder than distribution. Getting works-order data out for reporting is a common first project.
- Multi-depot distribution Stock by location Businesses across the M1 and M6 corridor hold stock in several depots and often at a 3PL. Publishing one honest availability figure from that is the integration that pays for itself fastest.
- Aged on-premise estates Versions behind A great many Triangle manufacturers run an ERP release that is years old because customisation blocked the upgrade. Unpicking that into supported extensions is frequently the brief.
We work on ERP estates for manufacturers and distributors in Coventry, Birmingham, Derby, Nottingham, Leicester, Northampton and the surrounding industrial belt.
Technology
ERPs we work with.
Through supported interfaces in every case. Where an ERP offers no sanctioned route we build a controlled staging layer rather than writing to its tables.
- Sage 200 & 50
- Dynamics 365 Business Central
- SAP Business One
- Epicor
- NetSuite
- Infor
- Bespoke & legacy ERP
- Reporting replicas
- Integration middleware
- EDI & file exchange
Where we deliver this
ERP Integration across the Golden Triangle.
35 locations, each with a page written for it — the sectors it is actually built on, and what that means for this work. See all areas we serve.
Northamptonshire 10
Warwickshire 5
West Midlands 5
Buckinghamshire 4
Leicestershire 4
Staffordshire 4
Derbyshire 1
Greater London 1
Nottinghamshire 1
Questions
ERP integration, answered plainly.
The questions that decide whether you will still be able to upgrade.
Should we customise our ERP or integrate around it?
Integrate around it, in nearly every case. Core customisation is the single most common reason businesses end up stranded on an unsupported ERP release, because each modification has to be reworked at every upgrade. Building the missing capability as a separate application that talks to the ERP through supported interfaces gives you the same functionality and keeps the upgrade path open.
Can you integrate with an old on-premise ERP?
Usually yes. Older systems often lack a modern API, so we use what they do offer — web services, supported staging tables, import and export routines driven automatically, or a read replica for reporting. We avoid unsanctioned writes to ERP tables, because that is how data integrity and vendor support are both lost.
Why do stock figures differ between our ERP and our website?
Because the website is usually working from a copy that updates on a schedule, and because “available” is a calculation rather than a number — it has to account for allocated stock, goods in transit, minimum levels and multiple locations. We derive one availability figure in the ERP, publish it to every channel, and reconcile continuously so the discrepancy is visible if it ever returns.
Do you implement ERP systems?
No. We are not a reseller and we do not run ERP selection or implementation programmes. We integrate and extend the ERP you already have, which means we have no commercial reason to recommend replacing it — and we will tell you when the honest answer is that the ERP is fine and the problem is elsewhere.
How do we report on ERP data without slowing the system down?
By replicating the data you need into a separate reporting store on a schedule the operation can absorb, then running all analysis against that. This stops month-end reporting competing with despatch for the same database, and it lets you keep history that the ERP would otherwise archive away.
How much does ERP integration cost?
A single high-volume flow — web orders into the ERP, or stock out to the channels — is typically a low five-figure project. Larger programmes covering warehouse, carriers, CRM and reporting are phased, and the interface survey that comes first is a small fixed-price piece of work that is useful regardless of what you build next.
Will this affect our ERP support contract?
It should not, and that is the point of working only through supported interfaces. Unsanctioned writes to ERP tables are what void support and corrupt data, which is why we do not do them. Where an ERP offers no sanctioned route we build a controlled staging layer and document it, so your vendor can see exactly what touches what.
Can we still upgrade the ERP afterwards?
Yes, and protecting that is the main reason to extend around rather than customise within. Because the extensions are separate applications talking through supported interfaces, a vendor upgrade becomes a planned project with a test cycle rather than a rewrite of bespoke code. Losing the upgrade path is how businesses end up stranded on an unsupported release.
How current does the integrated data need to be?
It depends on the decision it supports, and over-specifying it is expensive. Stock published to a website usually needs to be near real time; reporting data usually does not. We agree the latency per flow in the interface survey rather than defaulting everything to instant, because constant polling of an ERP has a real cost.
Do you work with ERPs you have not seen before?
Regularly. The first phase is the interface survey precisely because every ERP is different and the documentation is often optimistic. We establish empirically what the system will actually let us do before anything is designed around it, which is also when we find out whether the vendor’s API does what the brochure says.
Related services
Part of the same picture.
-
Connect
API Development
APIs and integrations so data is entered once and moves on its own.
Explore -
Build
Legacy Replacement
Replacing the system nobody dares touch, without stopping the business.
Explore -
Automate
Data Pipelines
Data moved, cleaned and reconciled on a schedule, so reporting has one source.
Explore
Next step
Find out what your ERP actually supports.
An interface survey establishes the sanctioned ways in and out of your ERP and becomes the standard every future integration is built to. Short, fixed price, and yours to keep.