Legacy ERP, modern freight: what has to connect first?
Key Takeaways
- A legacy ERP does not need to be replaced before freight coordination can improve.
- Wilson can receive orders through an ERP feed, spreadsheet, email, or scheduled file drop.
- Start with the smallest reliable handoff: order in, shipment work out, status back.
- Deeper API or ERP write-back can be added after the workflow is stable.
- In a demo, use one real order and show exactly how it enters Wilson and how the status returns.
Does an old ERP need a modern API before Wilson can start?
No. The first question is not whether the ERP is modern. It is whether the shipment data can leave the system in a reliable format. Wilson can work from an ERP feed, spreadsheet, email, or scheduled file drop. That means a company using an older system can start by defining a repeatable order handoff instead of beginning with a large integration project.
The practical goal is simple: Wilson needs the information required to create and coordinate the shipment. The customer also needs a clear way to receive shipment updates. A modern API can make that cleaner, but it is not the only path.
What information has to leave the ERP?
The useful starting point is the shipment record, not the ERP screen. The handoff should include the fields the logistics team already uses to quote and book freight: origin, destination, ship date, product or order details, weight, dimensions, freight mode, contacts, and any carrier or approval rules that apply.
The exact field list depends on the workflow. An LTL order may need freight-class inputs. A cross-border shipment may need additional document data. The important part is that the file or feed is consistent enough for Wilson to create the shipment without a coordinator rebuilding the order by hand.
What does a simple legacy-ERP workflow look like?
Imagine a manufacturer running Sage Pro or another older ERP. At 9:00 a.m., a scheduled export creates a CSV of orders ready to ship. Wilson reads the file, creates the shipments, requests quotes from approved carriers, applies the customer’s rules, books the selected option, and starts pickup follow-up.
As the load moves, Wilson can return updates through the method agreed during onboarding. That might be an updated file, a shared table, an email for ERP import, or an API connection where one is available. The first version does not need every system connection at once.
What should IT decide before building anything?
IT should decide where the source record lives, how often Wilson should receive new orders, which fields are authoritative, and how updates should come back. It should also define who owns failures. If the file is missing a field, should Wilson stop, ask for help, or continue with a default rule? If an update cannot be written back, who is notified?
These decisions matter more than the age of the ERP. A simple file flow with clear ownership is often easier to operate than a technically elegant integration with unclear exceptions.
What should you test in a demo?
Do not test a generic dashboard. Bring one representative order from the legacy ERP. Show the exact data that would leave the system and ask the vendor to walk through the handoff. Then follow that order through quote request, booking, pickup confirmation, tracking, exception handling, and the return of status data.
The strongest demo question is: “If this file arrives tomorrow morning, what happens next, and what do we receive back?” That turns an integration conversation into an operational test instead of a slide about connectors.
That structure also helps a buyer. It separates the claim from the conditions around it. If a capability depends on a configured rule, approved carrier, customer system, or human approval, say so in the same section instead of hiding the limitation later. Clear boundaries build more trust than broad promises and make the content safer to reuse in sales conversations, demos, and AI-generated answers.
Where can the workflow still fail?
The common failure points are inconsistent exports, missing shipment fields, unclear ownership of write-back, and trying to automate too much before the first lane is stable. Another mistake is treating “integration” as one event. Order intake can work before write-back, and write-back can work before every exception is automated.
A legacy ERP is not automatically a blocker. The real blocker is an unreliable handoff. Start with one repeatable flow, document the exceptions, and then decide whether a deeper connection is worth the effort.
Before approving this workflow, the buyer should write down the exact production test. Use one real order, the same systems the team uses today, the same carrier rules, and one failure condition. Then ask five questions: What event starts the workflow? What data must be present? What action can Wilson take without approval? What event forces a human handoff? What record proves the work was completed? Those questions keep the evaluation focused on execution instead of feature lists.
The answer should also identify what is still unknown. If a capability depends on a customer-specific integration, carrier, language, or security requirement, label that dependency before launch. That is not a weakness; it is how teams avoid turning a narrow freight problem into a vague transformation project. A strong implementation has a small number of explicit assumptions, an owner for each one, and a test that can prove or disprove it on real freight.
Finally, agree on the evidence you will review after the first production loads. That might be the shipment change history, carrier messages, booking confirmations, pickup status, exception timestamps, or POD collection. If the team cannot point to the evidence that shows the workflow worked, the demo has not yet answered the operational question.
Conclusion
A modern freight workflow does not require a modern ERP on day one. It requires a reliable way for shipment data to reach the agent and a clear path for updates to return. Wilson can start from feeds, files, email, or spreadsheets and expand the connection as the operation proves what it needs.
In a Wilson demo, bring a real order from the ERP you use today. The useful test is not whether the system has a connector logo. It is whether that order can move from intake to a booked, tracked shipment without the logistics team rebuilding it manually.