Why hospital cloud ERP migrations stall (and how to fix the item master)

Gartner research indicates that 83% of data migration projects either fail entirely or significantly exceed their original budgets and schedules. Symmetric Health Solutions finds that for most health systems, these failures are not caused by the software itself, but by an item master that is incompatible with the rigid data structures of modern cloud platforms like Oracle, Infor, or Workday. To ensure a successful transition, organizations must standardize their product foundation with verified GTINs, accurate UNSPSC classifications, and CMS-validated HCPCS codes before attempting to load data into a new environment.

The hard stop: Why cloud ERPs reject legacy hospital data

Most legacy Enterprise Resource Planning (ERP) systems in healthcare function as permissive databases. They allow for free-text manufacturer names, inconsistent units of measure, and fragmented catalog numbers. Because these older systems were designed primarily for basic purchasing, they often lack the strict validation rules required by modern cloud-based alternatives. When a supply chain team attempts to port this legacy data into a modern cloud environment, the system often rejects the records entirely or creates a "data swamp" that breaks downstream clinical workflows.

Modern cloud systems act as the central nervous system for the hospital, connecting supply chain, finance, and clinical documentation. Because these systems are highly integrated, they require a clean, structured data hierarchy to function. If a record is missing a mandatory field—such as a UNSPSC code for spend categorization or a GTIN for barcode scanning—the migration stalls. This isn't just an IT problem; it is a clinical risk. If the item master is not ready for a Point-of-Use (POU) inventory system implementation, clinicians cannot accurately document the supplies used in a procedure, leading to billing gaps and inventory stockouts.

Symmetric Health Solutions specializes in this transition by providing the infrastructure required to bridge the gap between legacy mess and cloud readiness. By mapping over 1,600 attributes to customer ERP systems, the platform replaces fragmented entries with a unified product foundation. This preparation ensures that when the "go-live" date arrives, the system is populated with data that is already validated against manufacturer and regulatory sources, preventing the manual rework that typically consumes 60 to 90 days of an implementation timeline.

Diagnosis: Why the legacy item master breaks the migration

The primary reason a legacy item master fails during a cloud migration is a lack of standardization across identifying attributes. In a legacy system, "Medtronic" might be entered ten different ways: "Medtronic Inc," "Medtronic USA," "Medtronic Sofamor Danek," or simply "Medtr." While a human buyer might understand these are the same entity, a cloud ERP will treat them as separate manufacturers, creating thousands of duplicate records and making a unified spend analysis impossible.

Missing GTINs and packaging hierarchy

A significant bottleneck in ERP and EMR migrations is the absence of a complete packaging hierarchy. Modern healthcare supply chains increasingly rely on Global Trade Item Numbers (GTINs) to track products from the loading dock to the patient's bedside. Legacy item masters often only store a single catalog number, ignoring the critical relationships between a "each," a "box," and a "case."

Without verified GTINs, point-of-use systems cannot recognize scanned barcodes. This leads to manual workarounds where staff must type in catalog numbers, increasing the risk of error. Furthermore, modern cloud systems like Oracle or Infor often prevent the editing of an item’s packaging level once transactions have occurred. If the data is not cleansed and reviewed before the first purchase order is cut, the organization is locked into a flawed data structure that requires complex, retrospective fixes.

Inaccurate UNSPSC and classification gaps

Financial leaders moving to the cloud expect real-time visibility into spend trends. This visibility depends entirely on UNSPSC (United Nations Standard Products and Services Code) classifications. If the legacy item master has inconsistent or missing classifications, the cloud ERP cannot accurately categorize spend.

Across the hospitals that Symmetric Health Solutions has supported, it is common to find that 30% to 50% of the item master lacks a standardized spend category. Without these codes, value analysis teams cannot perform "apples-to-apples" comparisons between clinically equivalent products. This lack of transparency is a major contributor to the estimated $25.4 billion in annual supply chain overspend across U.S. hospitals, according to data on healthcare supply chain waste.

The solution: Standardizing the product foundation

Fixing a broken item master is not a task that should be handled during the migration itself. Instead, it must be addressed as a prerequisite. Successful health systems treat data cleansing as a separate, specialized stream of work that runs parallel to the technical ERP configuration. Symmetric Health Solutions provides the tools and clinical expertise to execute this cleansing without taxing internal hospital staff.

Audit and deduplicate legacy records

The first step in any migration-ready strategy is a comprehensive audit of the existing item master. This involves more than just finding exact matches; it requires identifying "fuzzy" duplicates where different descriptions refer to the same product. At Boston Medical Center, this level of data integrity and spend analysis identified over $2 million in supply chain savings.

By resolving these duplicates before they enter the new cloud environment, the hospital reduces the size of its database, simplifies the search experience for clinicians, and ensures that contract compliance is calculated against the total volume of a product, rather than being split across multiple fragmented records. You can learn more about this process in the Boston Medical Center case study.

Enrich with verified identifiers

Once the duplicates are resolved, the remaining records must be enriched. Symmetric Health Solutions unifies data from more than 400 regulatory, manufacturer, and distributor sources to rebuild item records. This enrichment includes:

• HCPCS codes: Validating codes against current CMS standards to ensure billing accuracy.
• Country of origin: Verifying the manufacturing location through FDA registrations and label images, which is critical for supply resiliency and managing tariff exposure.
• Clinical flags: Adding indicators for sterility, latex content, and implant status to support patient safety and EMR integration.

This level of detail is what allows a cloud ERP to transition from a simple purchasing tool to a true clinical intelligence platform. When every item is enriched with these attributes, the system can automatically suggest clinically comparable substitutes during a backorder event.

Automate bidirectional ERP updates

Manual data entry is the enemy of a successful migration. To maintain the integrity of the newly cleansed data, Symmetric Health Solutions utilizes pre-built, bidirectional integrations with major cloud systems. This means that as manufacturers update their product specifications or as new GTINs are released, the updates flow directly into the hospital's Oracle, Infor, or Workday environment. This integration and automation capability removes the burden of manual stewardship from the supply chain team and ensures the data remains migration-ready at all times.

When manual cleanup is not enough

Many hospital IT directors believe they can handle item master cleanup using internal spreadsheets or a "one-time" service from their ERP vendor. However, the scale of data change in the healthcare industry makes manual cleanup a losing battle. Suppliers make roughly 10 million item data changes every year, and GPOs process thousands of contract changes monthly.

A manual cleanup project is often obsolete by the time the migration actually reaches the "go-live" phase. Furthermore, manual efforts lack the clinical depth provided by a dedicated data intelligence platform. For example, a non-clinical data entry clerk might not recognize the nuance between two types of orthopedic implants that appear similar in a catalog but have different clinical indications.

Symmetric Health Solutions bridges this gap by combining machine learning with human clinical expertise. This approach ensures that the data is not just "clean" for the sake of the database, but "clinically accurate" for the sake of the surgeon and the patient. This is a foundational element of the Symmetric healthcare supply chain database, which serves as a reliable engine for organizations that need to move beyond simple data storage and into predictive analytics.

Prevention: Shifting toward continuous data stewardship

The most successful ERP migrations are those where the organization views data quality as a continuous journey rather than a destination. Once the initial migration is complete, the focus must shift to ongoing stewardship. This is particularly important for hospitals that are part of the Healthcare Industry Resilience Collaborative (HIRC). In January 2026, Symmetric Health Solutions joined and sponsored HIRC to support data accuracy and resiliency for more than 1,200 hospitals.

Continuous stewardship means:

• Regularly monitoring manufacturer registrations for changes in country of origin to mitigate supply chain risk.
• Automating the addition of new items to the master through a validated "virtual catalog" rather than manual entry.
• Using supply chain intelligence to monitor contract misalignment and identify new substitution opportunities as clinical equivalents enter the market.

By maintaining a "clean" item master post-migration, hospitals can avoid the "data drift" that typically necessitates another massive cleanup project five years down the road. Joseph D'Amore, MDM Manager at Boston Medical Center, has noted that Symmetric's expertise in this area can dramatically impact an organization's efficiencies and bottom line. When the data is trusted, every other part of the hospital—from finance to clinical operations—functions more effectively.

If your organization is currently planning an ERP upgrade or struggling with a stalled cloud migration, the solution starts with the data. A messy item master will break even the most sophisticated software. By focusing on standardization, enrichment, and automation today, you can ensure your system provides the visibility and efficiency promised by the cloud.

Request a free Item Master Audit from Symmetric Health Solutions to identify duplicate records, missing classifications, and enrichment opportunities before your next system upgrade. Taking this step now can save hundreds of hours of manual rework and ensure a successful, data-driven go-live.