ERP ecommerce integration, old ERP, legacy ERP, ERP API, B2B ecommerce, distributor ecommerce
ERP ecommerce integration: you can keep the old ERP
November 12, 2026
An old ERP is not a reason to wait. The four ways a store gets data from it, how fresh each keeps stock and prices, and seven questions to put in writing.
Executive summary
No, an old ERP is not a reason to wait before selling online. ERP ecommerce integration uses one of four methods: an API, scheduled file exports, direct database access, or middleware or a script. The method sets how fresh stock and prices are, so ask every vendor in writing which one it uses.
A dealer told me they will not do anything online until their new ERP is live. A prospect recently asked me whether to hold off on selling online until a new ERP is stable. Both are waiting on the wrong thing.
The rule I would put on the wall: your plans for the ERP can take years, but your online store should not wait for them.
Do you have to replace your ERP before selling online?
No. A store needs a way to read items, prices and stock out of the ERP and a way to write orders back in. Many ERPs offer at least one of those ways, so the real question is which one yours offers and who builds it.
Waiting for a new ERP is also a moving target. A dealer told me that dealers do not like being told what to do about their systems, which is why an ERP switch driven from outside stalls everything else. A switch date is the ERP's schedule. The store's schedule is its own.
The three jobs ERP, POS and store do are in the lumber yard software guide. This page is about the plumbing between them.
How does a store get data out of an old ERP?
A store reaches an ERP by an API, a file exchange, the database itself, or a go-between that polls. Four methods cover most systems I read about, and an ERP often offers more than one. This is my grouping of what the documentation below describes, not a vendor standard.
Here is what each method looks like in vendors' own words, with a summary table at the end of this section.
API
An API lets the store call the ERP directly. NetSuite's REST web services read and write records and run queries without custom scripts (Oracle). Paladin's eCommerce API is a REST API for stores running Paladin Point of Sale, and its README lists two calls: Get Inventory Item Data and Process Completed Invoice (Paladin GitHub).
The API is not always open. For BisTrack and Eagle, the Epicor products, the routes and the gaps are in the Epicor eCommerce integration guide. In short, integrator DCKAP calls the BisTrack Web API suited to live, API-driven integrations (DCKAP), while third-party grader Supergood says Eagle has no public API and a licensed one comes through Epicor or a certified reseller (Supergood). That is the grader's reading, so ask Epicor.
File export
File exchange means the ERP and the store trade files on a timer. Sage 100's Visual Integrator turns file-based data into scheduled imports and exports (Cleverence). BisTrack's eBusiness module imports XML, CSV or JSON files on a schedule too (DCKAP).
The cost is the gap: a price changed at 9:05 shows online after the next run, and someone has to set how often that run happens.
Database access
Some ERPs let a program read their database over ODBC. Reading is the safe half. For Sage 100, one integration guide says the ODBC driver is for reporting and read-only access, and that writing straight into tables bypasses validations and often breaks on upgrades (Cleverence). Use database reads for stock and price if nothing better exists. Do not let anything write orders that way.
Middleware or a script
Middleware is a go-between that polls one side and pushes to the other. QuickBooks Desktop is the clear case. Its Web Connector runs on the Windows machine that holds the company file and polls your service; Conductor's example file polls every 5 minutes, and Conductor says the connector can only work against the company file QuickBooks is actually allowed to use at that moment (Conductor). Sage 100 has no native, fully featured REST API according to the same Cleverence guide, so teams build or buy a REST gateway in front of it. That is the same pattern as a script: someone writes and maintains it.
Hosted middleware (iPaaS) can run real-time and batch jobs, says its vendor Jitterbit (Jitterbit). BigCommerce puts deployment at weeks for a packaged connector, weeks to months for iPaaS and months for custom middleware (BigCommerce). Those are a platform vendor's estimates, not measurements.
Other dealer systems say less. ACCEO says its Profitmaster offers "a range of APIs" for third-party solutions (ACCEO), and GenetiQ says it provides integration capabilities, including APIs (GenetiQ). ECI says Spruce eCommerce is directly connected to the Spruce database, and DMSi sells its own store, Agility Commerce Cloud; neither page names a method for outside stores (ECI, DMSi). For Prophet 21, Eclipse, Deacom, PRISM, Ogasys and Sandbox ERP I read no page that states a method, so I make no claim about them. Ask each vendor.
The freshness column below is the one that matters on a Tuesday morning: an API is fresh within the ERP's limits, a file is as old as its last run.
How fresh will your stock and prices be?
The freshest data comes from an API; the stalest from a file that runs nightly. Freshness has two parts: how fast the ERP can answer and how often the store asks.
An API can be as fresh as you need, up to the ERP's own limits. NetSuite governs web services concurrency per account, and each SuiteCloud Plus license adds 10 to the base limit (Oracle). QuickBooks Online allows 500 requests per minute per company, plus 10 concurrent requests per second per company and app, according to Apideck's summary of Intuit's limits (Apideck). A store with a large catalog and many buyers can hit a ceiling like that, which is why the vendor should tell you how stock is cached.
A fair test is to ask for a number: the oldest a stock count or price can be, in minutes. If the vendor says "real time" and cannot name a number, treat it as unknown. ECI says Spruce eCommerce updates in real time and gives no interval. The number is what you need.
What does each method cost you in effort?
An API costs the least effort when the vendor of the store builds and maintains it. Files and middleware cost more because someone on your side owns a schedule, a folder or a polling machine. Database access costs the most because a mistake there corrupts the ERP itself.
Effort is mostly about who is on the phone when it stops. DCKAP says someone has to configure the scheduled jobs and fix file formatting problems. Conductor ties the Web Connector to one Windows machine and one company file.
Licensing is the other cost. Ask whether the ERP vendor charges for API access and who pays. None of the pages I read states a price for BisTrack or Eagle access, so I will not guess one.
Which online offers are only a catalog on your domain?
An offer is only a catalog when it shows your products but cannot take an order that lands in the ERP. A store with a product list and no write-back gives a customer a pretty page and gives your staff a retyping job.
Three checks expose it. Does an order placed online appear in the ERP without anyone keying it? Does a trade customer see their own price, not the list price? Does the stock number come from today, not from the day of the last upload? Paladin's API shows what a real round trip looks like: one call to read inventory and one to write the completed invoice back so stock on hand stays correct. If a vendor cannot describe both directions, you are looking at a catalog.
Seven questions to ask in writing
Put these to every vendor and keep the replies. A vague answer is an answer.
- Which method (API, file, database, middleware) connects to my ERP and my exact version?
- Who holds the ERP's API license or credentials, and what does the ERP vendor charge for access?
- What is the oldest a stock count or a customer's price can be, in minutes, and what sets that number?
- Does an online order write back into the ERP on its own, or does staff retype it?
- What happens to online orders when the ERP is offline or being upgraded?
- Who gets the call when the connection breaks, and who pays when an ERP upgrade breaks it?
- What do you need from my data before you start, and what does it cost if it is not ready?
Question 6 matters because three parties can be involved: the ERP vendor, the store vendor and an integrator. Get one name in the reply.
When is waiting a few weeks the right call?
If a new ERP is weeks away, not years, and its data model will change, a short wait can be sensible. What to do in the meantime matters more than the wait.
Settle the items that carry over to any system. Item numbers, because every product on the store keys off them. Price levels, because trade customers see their own price. Units of measure. Customer account numbers. Clean those now and the work survives the move. Build the store against a messy item file and you do the job twice.
Replacing an ERP is a decision for your accounting, your counter and your yard. It should not also be the gate on your online sales. If the switch is a year out, do not wait a year.
Where ToolSwift fits
I run ToolSwift, so read this knowing which question I sell against. ToolSwift does not replace the system you run. It connects to it, so orders, pricing, inventory, invoices and payments sync with your ERP, and it connects today to sixteen named systems: Epicor (BisTrack, Eagle, Prophet 21, Eclipse), ECI (Spruce, Deacom), DMSi (Agility, Frameworks), Paladin, Genetiq, Sandbox ERP, Profit Master, PRISM, Ogasys/Acceo, QuickBooks and NetSuite (integrations). We build connectors for others, and our team does the setup. Put the seven questions above to us the way you would to any vendor, and judge the answers the same way. If your new ERP is weeks away, the item-number work above carries over either way. Book a demo and bring your ERP's name and version.
FAQ
Can a store connect to QuickBooks Desktop?
Yes, through the Web Connector, which polls from the Windows machine holding the company file. Changes wait for the next poll (Conductor).
Does an ERP without a public API block online sales?
No. Cleverence says Sage 100 ships no native, fully featured REST API, yet teams still connect it through the Business Object Interface, scheduled imports or a REST gateway (Cleverence).
Sources
All pages read November 11, 2026. Intuit's own developer pages did not load for the reader, so the QuickBooks Online limits come from Apideck; confirm them with Intuit.
Related in ToolSwift
Connected to the systems you already run
Sixteen ERP and accounting connections, and our team does the setup.