- Title
-
How AI-led SKU categorisation strengthened ERP migration for a global hospitality group
- Section
- Case study
- Summary
As part of a major ERP transformation, a global hospitality company was faced with the challenge of migrating a highly complex SKU catalogue. A manual approach risked creating a major resource drain, slowing down the programme, and introducing errors. While AI offered a way to address the scale of the challenge, success depended on accurately interpreting the organisation’s business-specific taxonomy and category rules. To achieve a high-quality migration, the organisation partnered with Efficio to combine its procurement and AI expertise.
The challenge
The organisation was migrating its entire SKU catalogue into Dynamics 365, requiring each item to be categorised through a five-level taxonomy. With the catalogue spanning millions of SKUs, manual classification was not a feasible solution. To further complicate the task, the categories were based on a taxonomy that demanded detailed interpretation of business documentation, accounting dictionaries, and product attributes.
Efficio’s approach
Efficio developed a custom AI-enabled SKU categorisation solution based on a five-layer large language model (LLM) architecture. Efficio utilised their deep procurement category knowledge to refine the client’s taxonomy to enable the LLM to accurately interpret it.
Bringing together procurement category knowledge, a strong understanding of the client’s business context, and technology expertise, the Efficio team was able to ensure accurate interpretation of the client’s taxonomy from the outset. This meant the solution was built in weeks rather than months, with the number of feedback loops with the client kept to a minimum.
The solution translated SKUs to English where necessary and categorised items for all levels, enabling a structured final review. The result was a scalable, automated categorisation tool that enabled the team to categorise each hotel’s historic catalogue items in under three hours with strong accuracy: 5–10 times faster than traditional, non-AI approaches.
Results
High accuracy
The model classified 85% of SKUs with high confidence, achieving over 95% accuracy within this cohort. Overall, 80% of SKUs were correct on the first pass, materially reducing rework.
Strong efficiency savings
The AI-enabled approach reduced manual review time and labour requirements dramatically, accelerating the migration process by 5–10x compared to previous non-AI methods.
Built-in scalability
The team established a fully automated, repeatable pipeline that automatically runs each time a hotel migrates to the new ERP.
Business enablement
A clean, fully classified SKU catalogue now supports reliable reporting and provides long-term procurement insight.
This project helped the hospitality company to quickly and accurately navigate one of its most complex barriers to ERP transformation. Beyond ensuring a successful migration, the new automated approach to SKU classification has created a robust foundation for high-quality data and reporting in the long term, supporting future procurement transformation.