If your Windchill and ERP are "connected" by Excel files, you don't have an integration, you have a workaround
Most manufacturing companies running Windchill will tell you they already have some kind of connection with their ERP. And technically, they are right. Data moves between the two systems. BOMs get transferred. Item lists are updated. Engineering changes eventually make their way into production.
The question is how.
In the vast majority of small and mid-sized industrial companies, the answer is the same: someone exports data from Windchill into a spreadsheet, works on it, and uploads it into the ERP. Or the other way around. Sometimes with a bit of scripting on top. Sometimes entirely by hand.
That is not an integration. That is a workaround that has become invisible because everyone has learned to live with it.
How spreadsheet-based transfers become the standard
This is not a criticism of the people who set it up. When a company first implements Windchill and an ERP, a full real-time integration is rarely the priority. There is a go-live deadline, a limited budget, and a team that needs to start working. Someone figures out a process using export files, it works well enough, and it becomes the de facto method.
Years later, that same process is still running. It has been documented, it has been handed from one person to the next, and it has become so embedded in daily operations that nobody questions it anymore. It is just how things work here.
The problem is not the spreadsheet itself. The problem is what happens when the business grows, the product catalogue expands, the pace of engineering changes accelerates, and the volume of data that needs to move between systems increases. What was manageable at fifty items becomes a liability at five hundred.
The real cost of moving data through files
Spreadsheet-based transfers between Windchill and ERP create a specific set of problems that rarely show up in a single dramatic failure. They accumulate quietly, in the background, until they become impossible to ignore.
Version mismatches
By the time a file is exported, processed, reviewed and imported into the ERP, the source data in Windchill may have already changed. Engineering revisions move faster than manual transfer cycles. Production ends up working from a BOM that is one or two iterations behind the current design — and in many cases, nobody knows until something goes wrong on the shop floor.
Human error at every step
Every manual intervention in the transfer process is a potential point of failure. A column mapped incorrectly. A row accidentally deleted. A filter applied to the wrong field. These are not exceptional events. They are routine, and they have routine consequences: rework, incorrect procurement orders, and inventory built around obsolete configurations.
Dependency on specific people
In most companies using this model, the transfer process is only fully understood by one or two individuals. When those people are unavailable — on holiday, sick, or simply gone — the process slows down or stops entirely. The organization has built a critical operational dependency around a manual routine.
No traceability
When data moves through a spreadsheet, the audit trail disappears. If a BOM error is discovered three months later, tracing it back to a specific file version, a specific transfer, or a specific decision is extremely difficult. For companies operating in regulated industries or with strict quality requirements, this is not just an inconvenience — it is a compliance risk.
The time nobody accounts for
Someone has to prepare the file, validate it, send it, confirm receipt, and troubleshoot when something does not match. This work does not show up in any integration budget because it is absorbed by the team as part of their normal workload. But it represents real hours, every week, spent on data logistics instead of engineering or operations.
Spreadsheet-based transfer vs. real-time integration with ISFsoft Connect
When the workaround stops working
There are usually clear signals that the spreadsheet transfer model has reached its limit, even if they are not immediately recognized as integration problems.
Engineering change cycles slow down because the effort required to push changes through to ERP creates a bottleneck. Product launches take longer than they should because teams spend days reconciling data before anyone can commit to a manufacturing plan. Quality incidents increase and trace back to BOM inconsistencies between what engineering defined and what production received. And the people managing the transfer process start spending more and more time on it, with less and less time for anything else.
At this point, the question is no longer whether to improve the integration. The question is how long the organization can afford to wait.
What a real integration between Windchill and ERP looks like
A proper integration does not mean replacing the spreadsheet with a more sophisticated spreadsheet. It means eliminating the manual transfer step entirely.
When Windchill and ERP are connected through a dedicated integration layer, product data flows automatically and in a controlled way. New items created in Windchill are reflected in ERP without manual intervention. BOM structures and revisions are synchronized as soon as they are released. Engineering Change Notices trigger the corresponding updates in ERP in real time. And every transaction is logged, traceable and auditable.
The operational impact is significant. Version mismatches disappear because there is no delay between the source data and the downstream system. Errors caused by manual handling are eliminated. The people who were managing the transfer process are freed to do higher-value work. And the organization gains a level of operational confidence in its data that simply does not exist when spreadsheets are in the middle.
ISFsoft Connect: built for Windchill environments
ISFsoft Connect is an integration platform designed specifically to connect Windchill PLM with ERP systems. It works as an Enterprise Service Bus, managing the synchronization of product data, engineering structures and operational information between both platforms in a controlled, bidirectional and traceable way.
The processes it supports cover the full scope of what companies currently manage through manual transfers: item creation and updates, BOM synchronization, Engineering Change Notice and ECO flows, manufacturing process plans, and option and variant expressions. All of it automated. All of it logged.
ISFsoft Connect also handles the heterogeneity that is typical in real industrial environments — different ERP systems, different data formats, different protocols — without requiring companies to standardize their entire technology stack first.
The result is an integration that does not depend on a spreadsheet, does not depend on a specific person, and does not introduce a manual step between what engineering defines and what operations receives.
If your Windchill–ERP connection currently runs through files, that is where to start.
Learn more about ISFsoft Connect and how it replaces manual data transfers with a real integration between Windchill and ERP ››
How Figueras Seating eliminated manual data management in Windchill without changing their PLM
There is a situation that many Windchill environments share, even in companies that have invested heavily in PLM: the system holds the data, but people are still doing the work of moving it.
Every new project triggers a wave of manual tasks. Items created one by one. BOMs copied and adjusted by hand. Files sent to suppliers without any guarantee they are the right version. And underneath it all, a Windchill environment quietly filling up with outdated and duplicated content that no one has time to clean.
This is not a technology problem in the sense that Windchill is broken. It is a workflow problem — and it tends to go unnoticed precisely because teams adapt to it. They build routines around the gaps. Until the volume grows too large, or a mistake costs too much, or someone stops to calculate how many engineering hours are spent on data management instead of engineering.
Figueras Seating reached that point.
A precision business with a manual data problem
Figueras designs and manufactures premium seating for auditoriums, theatres, cinemas, and stadiums in more than 150 countries. Every installation is different: seat dimensions, curvature, positioning, and finish are all defined by the specific geometry of each venue. There is no off-the-shelf configuration — each project is a custom engineering exercise.
That level of customization generates a high volume of items, versions, and CAD documents. And for every project, that data had to be loaded manually into their ERP system (Microsoft Navision), with no automated connection between PLM and ERP.
The consequences were predictable, though no less costly for being so.
The four problems that were costing the most
1. Loading project data into Windchill and ERP was slow, manual, and error-prone
Each new project meant creating and updating items one by one across both systems. With complex, customized BOMs — where every seat in a venue can have its own configuration — the volume of manual input was significant. And manual input means inconsistencies: data that does not match between systems, items created with errors, versions that diverge.
The time cost was real. So was the risk. In a business where every installation is unique and tolerances are tight, a data error does not stay in a spreadsheet — it travels downstream into production.
2. Windchill was accumulating noise it could not clean itself
Without an automated and controlled flow for creating and updating items, obsolete and duplicated content builds up over time. Items that were replaced but never removed. Versions that should have been superseded but were not. A PLM environment that was meant to be the single source of truth was instead becoming a source of uncertainty.
Cleaning this manually is time-consuming and disruptive. Most teams deprioritize it. The noise grows.
3. Errors in data became errors in production
When the connection between engineering data and manufacturing is handled by people rather than systems, the margin for error is wide. An outdated BOM reaching the shop floor. A component specified incorrectly because the item in ERP did not reflect the latest version in Windchill. Rework, delays, costs that should not have been there.
In high-precision, high-customization manufacturing, the cost of a data error is not just the error itself — it is everything that flows from it before anyone catches it.
4. Suppliers and partners were working without version certainty
Distributing project documentation to external partners — suppliers, subcontractors, site teams — was done without a controlled mechanism to ensure they always received the correct, current files. 2D drawings and 3D models sent outside Windchill lose their connection to the source. Someone builds from a drawing that has since been updated, and no one necessarily knows until it becomes a problem on site.
What changed with Windchill Utilities
Two applications from the Windchill Utilities suite addressed these problems directly.
Bulk Creation & Update Tools introduced an automated, Excel-driven interface between Windchill and Navision. Instead of creating and updating items manually in each system, the team now manages data through a structured process that keeps both platforms consistent. The Windchill mBOM and the ERP BOM for each project stay aligned, without manual synchronization.
Download Baseline Components gave the team a controlled mechanism for distributing project documentation externally. Files — primary content, attachments, and object representations — are grouped into structured baselines directly from Windchill, ensuring that suppliers and partners always receive the correct version of 2D and 3D files. Windchill remains the single, authoritative source.
The results
- Manual input eliminated across complex, customized BOMs — significantly reducing both time and errors when loading project data.
- Obsolete and duplicated items no longer accumulate, removing the overhead of periodic cleanup and restoring confidence in the PLM environment.
- Fewer errors reaching production, with a direct impact on rework costs, delivery speed, and product quality.
- Suppliers and partners always receive the correct, up-to-date file versions — distributed directly from Windchill baselines.
- A stable, maintainable environment that can evolve alongside both Windchill and ERP without accumulating technical debt.
Is your team spending engineering hours on data management?
If any of the situations above feel familiar, the gap is likely not in your PLM platform — it is in the workflow connecting it to the rest of your operation.
Windchill Utilities by ISFsoft is a suite of productivity applications designed to automate routine tasks, eliminate manual data management, and keep your Windchill environment clean, consistent, and ready to scale.
Explore Windchill Utilities →
See how other manufacturers are working smarter with Windchill
Figueras is not the only company that has transformed the way it manages engineering data. Explore more real-world examples of how ISFsoft helps manufacturing teams eliminate inefficiencies, connect their systems, and get more out of their PLM investment.