Master Data Management for FMCG Manufacturers: A Practical Guide

FMCG manufacturing looks deceptively straightforward from the outside. Make things. Move things. Sell things. Repeat at speed. The reality behind that is one of the most complex data environments in any industry. Thousands of active SKUs, each with their own material records, BOMs, formulations, packaging variants and regional specifications. Supplier relationships that span continents. Customers ranging from major grocery retailers with strict data compliance requirements to smaller regional distributors who all want something slightly different. New product launches happening constantly. Products being delisted, reformulated, repackaged. All of it running through an ERP system that depends on the accuracy of the data underneath it.

When that data is well governed, FMCG manufacturing runs at the pace it needs to. When it isn’t, the operational problems are significant, and they compound fast.

This guide covers what master data management actually looks like for FMCG manufacturers, where the specific challenges sit, and what good governance looks like in practice.

Why FMCG has a uniquely difficult master data problem

Most industries have complex master data. FMCG has a specific combination of factors that makes it particularly challenging.

Volume and velocity

An FMCG manufacturer might manage tens of thousands of active material records across multiple plants, with new products being introduced and existing products being changed continuously. The pace of change is relentless. A governance process that works well at low volume starts to break down when data requests are coming in daily across dozens of product categories.

Product variants and reformulations

A single product in FMCG is rarely a single SKU. There are size variants, regional variants, promotional packs, seasonal editions, reformulations driven by ingredient cost, regulatory change, or consumer preference. Each variant needs its own master data. Each reformulation touches BOMs, recipes, material specifications and potentially supplier records simultaneously.

Retailer compliance requirements

Major grocery retailers like Tesco, Sainsbury’s and ASDA have strict requirements for how product data is structured and submitted. Get the product hierarchy wrong, the unit of measure incorrect, or the trade unit configuration mismatched, and you risk a failed listing. In FMCG, a failed retailer listing isn’t a minor inconvenience. It’s lost revenue, a strained commercial relationship, and a scramble to fix data that should have been right in the first place.

Supply chain complexity

FMCG supply chains are long, multi-tiered, and often global. Accurate supplier master data, correct purchasing info records, and consistent material classification across sourcing regions aren’t just good practice. They’re operational prerequisites. When they’re wrong, procurement makes decisions based on incomplete spend visibility, supplier payments go to incorrect accounts, and sourcing alternatives are harder to find because the data that would identify them is fragmented.

Regulatory and labelling requirements

Food and beverage manufacturers operate under strict regulatory frameworks. Ingredients, allergens, nutritional data, and country of origin are all governed by regulation, and all of it traces back to master data. A wrong allergen classification in a product record isn’t just a data quality problem. It’s a potential recall and a regulatory incident.

The master data objects that matter most in FMCG

Not all master data is equally critical. In FMCG manufacturing, these are the objects where inaccuracy causes the most damage.

Material master

The foundation of everything. In FMCG this is particularly complex because a single finished product may have multiple associated material records — the finished good, the packaging components, the raw ingredients, the bulk intermediate. Each one needs to be accurate, consistently classified, and linked correctly in the product structure.

Bill of materials

In FMCG, the BOM defines the components that make up a finished and semi-finished product, including the raw materials, packaging, and sub-assemblies, in the quantities required to produce it. A BOM error doesn’t just affect production efficiency. It can affect product safety, regulatory compliance, and brand integrity. Governed BOM management isn’t optional in this sector.

Master recipes

A separate but closely related object to BOM, but where the BOM defines what goes into a product, the master recipe defines how it’s made. This covers the production steps, processing parameters, resource assignments, and the sequence in which operations are carried out. In food and beverage manufacturing, master recipes are particularly critical because they govern not just production efficiency but product consistency, quality standards, and in some cases, regulatory compliance. A BOM and its associated master recipe need to be governed together. A change to one almost always has implications for the other.

Vendor master

FMCG manufacturers typically manage hundreds or thousands of supplier relationships. Duplicate vendor records, outdated payment details, and inconsistent supplier classifications across finance and procurement are all common — and all expensive. Accurate vendor master data is also increasingly important for sustainability reporting, where supply chain traceability requirements are tightening across the EU and UK.

Customer master

Retailers have specific requirements for how they’re set up in supplier systems. The wrong pricing condition record, an incorrect delivery address, a customer hierarchy that doesn’t reflect how the retailer wants to receive orders — all of these create operational friction at the point of order and invoice. In a high-volume FMCG environment, that friction adds up quickly.

Product hierarchies and classification

How your products are classified internally determines how you report against them. Sales analysis, margin reporting, procurement spend — all of it depends on a consistent, well-governed product hierarchy. In FMCG, where category management is a commercial discipline in its own right, a fragmented product hierarchy means commercial decisions being made on data that doesn’t give the full picture.

Where it typically goes wrong

New product introduction

New product introduction (NPI) is where FMCG master data governance gets tested hardest. A new product launch involves creating multiple master data records simultaneously — the finished good, its packaging components, its raw material inputs, its BOM, its customer-specific pricing structures — and getting all of them right, in all the right systems, before the product needs to be available.

Most FMCG manufacturers manage NPI through a combination of spreadsheets, email workflows and direct ERP entry. It’s manual, it’s slow, and it’s error-prone. When something goes wrong during an NPI — a material created with the wrong unit of measure, a BOM linked to the wrong plant, a customer record missing a mandatory pricing condition — it delays the launch or creates problems the day the product first ships.

Governed NPI through an MDM platform changes this. A single structured request captures all the required data for all the required objects. Validation rules check it before it reaches the ERP. Approval workflows route it to the right people in the right order. The result is faster NPI with fewer errors — and a full audit trail of every decision made along the way.

Product reformulation

A reformulation in FMCG touches more data than most people realise. A new ingredient affects the BOM and recipe, potentially the allergen classification, possibly the material master for the ingredient itself, the supplier record if a new supplier is being introduced, and the regulatory documentation that sits around the product.

Without governed change management, reformulations get managed through informal processes that work until they don’t. The change gets made in the recipe system but doesn’t make it into the ERP BOM in time. The new allergen classification gets updated in one system but not another. The old ingredient stays on the purchasing info record and continues to be ordered after the reformulation has gone live.

Seasonal and promotional complexity

FMCG manufacturers run promotional packs, seasonal variants, and limited editions continuously. Each one requires master data, often quickly, often at the same time as regular operations are running at full pace. The pressure to get data created fast leads to shortcuts. Shortcuts lead to errors. Errors surface later as operational problems that take far longer to fix than the time saved by cutting corners.

Retailer-specific requirements

Different retailers want different things. One customer hierarchy structure for Tesco, another for Sainsbury’s, another for Ocado. Customer-specific trade units, pricing conditions, logistics configurations. In FMCG, managing customer master data isn’t just about keeping contact details up to date. It’s about maintaining a complex web of customer-specific configurations that directly affect how orders are processed and invoiced.

What good MDM governance looks like for FMCG manufacturers

A governed NPI workflow

New products should be introduced through a structured process that captures all required master data upfront, validates it against defined rules, routes approvals to the right stakeholders, and creates records in SAP automatically once approved. The goal is to compress NPI timelines and eliminate the errors that come from manual data entry under time pressure.

Change request management for reformulations and updates

Any change to a material master, BOM, recipe, or vendor record should go through a formal request process with approval workflow and full audit trail. This is particularly important in food and beverage, where a change to a recipe or ingredient source may have regulatory implications that need to be documented.

Validation rules that reflect FMCG-specific data standards

Generic validation isn’t enough. FMCG manufacturers need validation rules that reflect their specific classification standards, retailer compliance requirements, and regulatory obligations. Units of measure, allergen classifications, product hierarchies, trade unit configurations — all of these should be validated automatically before data enters SAP.

Supplier master governance that bridges finance and procurement

A single governed vendor record, created and maintained through a process that serves both finance and procurement, eliminates the duplicate supplier problem and provides the spend visibility that FMCG procurement teams need to manage supplier relationships effectively.

Mass processing capability for range reviews and seasonal cycles

FMCG manufacturers regularly need to make bulk changes — a seasonal range cutover, a rationalisation of slow-moving SKUs, a supplier consolidation. Mass processing through a governed MDM tool applies the same validation and approval logic to bulk changes as to individual ones, preventing the data quality problems that uncontrolled bulk updates typically create.

An example of FMCG Master Data Management

Princes, one of the UK’s leading food and beverage manufacturers, implemented our MDM solution, Maextro, to bring governance to their material master data management across their SAP landscape. Before Maextro, managing material master for finished goods alone was consuming approximately 51 working days of non-value-added processing time across departments. After implementation, they improved that by 75%. The same governed process that produced those numbers also applies to their BOM and routing data, giving Princes a single platform for managing the master data objects that their production operation depends on.

The FMCG data governance question worth asking

Most FMCG manufacturers know their master data isn’t perfect. The question is whether the cost of that imperfection is visible enough to act on.

The 51 working days of processing time that Princes were absorbing for finished goods material master alone wasn’t showing up as a line item on a P&L. It was showing up as people being busy, processes being slow, and errors that seemed isolated but kept happening. The cost was real. It just wasn’t labelled.

If your FMCG operation is managing master data through spreadsheets, email workflows and direct ERP entry, the cost of that approach is almost certainly higher than it looks. The question is whether you’re ready to make it visible and do something about it.

See how Maextro governs master data for FMCG and food and beverage manufacturers.