Book My Growth Assessment
insights

Custom Software for Manufacturing: ERP, IoT, and the Shop Floor

The manufacturing software that moves product fastest is the one that fits your specific processes — not the one that covers the most industries in the sales brochure.

Ravve Jay Prevendido
Ravve Jay Prevendido·Aug 25, 2024·5 min read
17+ industry awards · Brand architect behind OWWA, Nuvia & 100+ brands · ravvejay.com
Share
Custom Software for Manufacturing: ERP, IoT, and the Shop Floor

The promise of enterprise resource planning in manufacturing has always been one system that connects the shop floor to the supply chain to the finance department. The reality for most mid-market manufacturers is a patchwork: a large ERP (SAP, Oracle, Microsoft Dynamics) that handles finance and procurement well, a separate MES (Manufacturing Execution System) that may or may not integrate cleanly, machine data that lives in proprietary SCADA systems with no API, and a scheduling process that still runs on spreadsheets because the ERP's production scheduling module requires a dedicated consultant every time something changes.

Custom software in manufacturing does not typically replace the ERP — the financial and compliance functions of a mature ERP represent years of configuration that is expensive to recreate. What custom software replaces is the gap between the ERP and the shop floor: the real-time visibility into production status, the machine monitoring that predicts maintenance needs before a breakdown stops a shift, the production scheduling that accounts for actual machine capacity rather than theoretical capacity. This is the layer where manufacturers compete on operational efficiency, and it is the layer where generic software rarely fits well enough to win.

ERP integration without the ERP tax

The ERP integration problem in manufacturing is both technical and contractual. On the technical side, major ERPs expose their data through a combination of APIs (SAP's Business Application Programming Interface, Oracle's REST APIs, Microsoft's Business Central connector), database views, and flat-file exports — each with different latency, completeness, and reliability characteristics. Custom software that needs production order status from SAP in near-real-time faces different engineering challenges than software that can batch-sync overnight.

The contractual side: ERP vendors charge for API access, for additional named users, and for integration modules that seem basic but are priced as premium add-ons. A custom shop-floor dashboard that reads production order status from SAP needs either a licensed SAP integration layer (expensive) or a custom connector built against SAP's documented APIs (technically complex but one-time cost). Most manufacturers find the custom connector is worth the upfront engineering once the recurring license savings are calculated over a three-year horizon.

Event-driven integration: rather than polling the ERP every N minutes, subscribe to change events when the ERP supports it — lower latency, lower load on the ERP, more reliable data.

Data normalization layer: ERPs store dates, units of measure, and part numbers in proprietary formats. A normalization layer between the ERP and the custom application prevents integration bugs from propagating into production decisions.

Write-back architecture: determine upfront which data flows from the ERP to the shop floor and which flows back. Bidirectional sync without clear data ownership creates conflict resolution problems.

IoT on the shop floor: from sensor data to actionable intelligence

The cost of industrial IoT sensors has dropped dramatically since 2020, making machine monitoring feasible for mid-market manufacturers who could not have justified the investment five years ago. Temperature sensors, vibration sensors, current monitors, and cycle counters can now be deployed at a cost where the ROI from a single avoided unplanned shutdown pays for a year of sensors. The engineering challenge has shifted from "can we afford the sensors" to "what do we do with the data."

A custom IoT platform for manufacturing typically involves: edge devices or industrial gateways that collect sensor data and buffer it locally (critical for shop floor environments where network connectivity is intermittent), a time-series database (InfluxDB, TimescaleDB, or a managed service like AWS Timestream) for efficient storage and querying of high-volume sensor readings, alerting logic that distinguishes normal variation from anomalies requiring attention, and dashboards that give machine operators and maintenance engineers the view they need without requiring them to understand the underlying data platform.

Predictive maintenance is the most commonly cited ROI for manufacturing IoT, and the data supports it: Deloitte has reported that predictive maintenance reduces breakdowns by up to 70% and maintenance costs by 25-30% for manufacturers with sufficient sensor coverage and data quality. The key qualification is data quality: predictive models trained on incomplete or noisy sensor data produce false positives that erode operator trust and false negatives that let real failures through. The sensor installation and data quality work is not glamorous, but it determines whether the predictive maintenance system is actually useful.

Production scheduling that reflects actual capacity

ERP production scheduling modules are built on a model of standard capacity: machine center A can produce X units per hour, five days a week, eight hours a day. Real manufacturing has machine-specific cycle times that vary with operator and tooling, setups that take different amounts of time depending on what ran before, unplanned downtime that creates cascading schedule disruptions, and priority changes that come from the sales floor mid-shift. Standard capacity models produce schedules that require manual adjustment before they can be executed.

Custom scheduling systems — finite capacity schedulers that model actual rather than theoretical capacity — can consume real-time machine status from IoT sensors, pull order priorities from the ERP, and generate schedules that reflect what the shop floor can actually execute. The computational complexity of optimal scheduling (it is NP-hard for non-trivial configurations) means custom schedulers typically use heuristic optimization rather than guaranteed optimality, but heuristic schedules based on real data routinely outperform optimal schedules based on wrong assumptions.

The most expensive software a manufacturer runs is the spreadsheet that the production scheduler builds every morning because the ERP's output is not usable directly.

How TTGC approaches manufacturing software

Ravve Jay Prevendido and the TTGC team approach manufacturing software with a pragmatic integration-first philosophy: keep what works in your existing ERP, replace what does not work at the shop floor layer, and connect them with a clean data architecture that makes both sides more useful. For manufacturers evaluating where to start, modernizing legacy systems without halting your business covers the migration strategy. Schedule a conversation at /growth-assessment.

Manufacturing software that actually reflects your shop floor — connect with TTGC to scope your build.

Book a free Brand and Growth Assessment and see exactly how Through The Glass Creatives would approach it.

Get Your Free AssessmentGet Your Free Assessment

Sources

  1. Deloitte — "The smart factory: responsive, adaptive, connected manufacturing" (2023).
  2. McKinsey & Company — "Industry 4.0: capturing value at scale" (2024).
  3. Gartner — Magic Quadrant for Manufacturing Execution Systems (2024).
  4. IDC — IoT in manufacturing: deployment patterns and ROI benchmarks (2024).

Results shared by Through The Glass Creatives Global and its founders are not typical and are not a guarantee of your success. Ravve Jay Prevendido and Mherie Vic Palomo Prevendido are experienced business owners, and your results will vary depending on your industry, effort, application, experience, and market conditions. We do not guarantee that you will achieve specific outcomes by using our services. Consequently, your results may significantly vary. We do not give investment, tax, or other financial advice. Case studies and client experiences are mentioned for informational purposes only. The information contained within this website is the property of Through The Glass Creatives Global - FZCO. Any use of the images, content, or ideas expressed herein without the express written consent of Through The Glass Creatives Global FZCO is prohibited. Copyright © 2026 Through The Glass Creatives Global FZCO. All Rights Reserved.