A shampoo is rarely just one formula.
What begins as a successful base can quickly become a sulfate-free alternative, an EU-compliant version, a lower-cost SKU, a retailer-exclusive fragrance, a concentrated refill format, or a reformulation prompted by an ingredient shortage. Add differences in packaging, local labelling, claims and manufacturing requirements, and one product concept can soon produce dozens of valid formulations.
That does not automatically mean the portfolio is out of control. In home and personal care, it is often the natural result of serving different markets, customers, price points and consumer expectations.
The challenge is preserving the connection between those formulas as the portfolio grows. Teams need to know which formulations are related, what changed between versions, why those changes were made, and how they affected performance, cost, compliance and manufacturability.
When this information is spread across spreadsheets, shared drives and individual scientists’ knowledge, that becomes increasingly difficult.
When Variants Become Hard to Manage
Formula variants usually emerge for sensible reasons.
A regulatory team may need a preservative-free option for a particular market. Procurement may request a substitute after a supplier discontinues a surfactant. A retailer may want an exclusive fragrance or a specific claim. A brand team may set a new sustainability target that requires alternative ingredients, lower water content or compatibility with recycled packaging.
Each change may affect only a small part of the formula. But the operational impact can be much larger.
A new version still needs to be tested. It may need fresh stability data, compatibility checks, sensory evaluation, cost calculations, safety review or manufacturing validation. It may also create further downstream variants as teams adapt that version for other markets or product lines.
Over time, the organisation can lose a clear view of what is actually in the portfolio.
A formulator may know that a particular “final” spreadsheet is based on an earlier regional version, which itself replaced an ingredient used in the original base formula. But if that relationship exists only in filenames, folder structures or someone’s memory, it is difficult for anyone else to find, verify or reuse.
The Problem Is Not Just Too Many Files
The issue is not simply that formulation teams have a large number of spreadsheets. The real problem is that disconnected files make it difficult to understand the consequences of a change across the wider portfolio.
Imagine a key raw material is being phased out by a supplier. R&D, procurement and regulatory teams may need to answer several urgent questions:
- Which active formulas contain the material?
- Which variants use it above a certain concentration?
- Which regions, brands or retail customers are affected?
- Has the organisation already tested a viable substitute?
- What happened when that substitute was used in comparable formulas?
- Which products may require reformulation, retesting or relabelling?
In a spreadsheet-based environment, finding those answers often means searching file names, opening documents one by one, comparing versions manually and asking experienced formulators to reconstruct what happened.
That work is slow, difficult to audit and easy to get wrong.
It also creates avoidable repetition. A team may repeat an experiment because the relevant work cannot be found. Another scientist may test an ingredient combination that failed months earlier in a related formulation. A procurement change may trigger unnecessary reformulation work because no one can quickly see where an alternative material has already been qualified.
As the number of variants rises, so does the cost of fragmented knowledge.
Formulations Need Context, Not Just Version Numbers
A scalable formulation process does not depend on preventing variants. Variants are often necessary. Instead, it gives every formulation a clear place within a connected product and data structure.
A formulation should be more than an attached spreadsheet. Its ingredient list, concentrations, supplier information, processing steps, target properties, cost, test results and change history should be captured in a way that can be searched, compared and linked.
That means a team can see that a particular shampoo variant came from a specific base formula, identify the ingredients that changed, and understand why the change was made.
For example, a sulfate-free version might retain the original conditioning system and fragrance while replacing the surfactant blend. The record should show not only that the substitution happened, but also the reason for it, the performance targets, the stability results, the cost impact and any manufacturing adjustments required.
That context matters when the formula is revisited six months later, or when another team needs to create a related product.
Instead of starting with a blank spreadsheet or relying on memory, the team can build from validated knowledge.
Better Traceability Supports Better Decisions
Connected formulation data makes it easier to answer practical questions before they become major projects.
A scientist can identify all formulas containing a particular ingredient, then narrow the list by product category, concentration, market or development status. A regulatory team can see which variants may be affected by a new restriction. Procurement can assess exposure to a supplier change. Product managers can compare how retailer-specific versions differ from the core formula.
Most importantly, teams can see the relationship between a formulation change and its outcome.
Did replacing an ingredient improve biodegradability but reduce foam performance? Did a lower-cost substitute create a viscosity issue? Did the formula pass accelerated stability testing but create a processing problem at manufacturing scale?
When formula versions are connected to test data and project decisions, those answers do not disappear into separate documents. They become part of the product’s technical history.
That helps teams make faster decisions with more confidence and gives them a clearer basis for deciding when a new experiment is genuinely needed.
Why This Matters for AI-Enabled R&D
AI can help formulation teams identify patterns, compare historical work and suggest promising areas for investigation. But its value depends on the quality and structure of the underlying data.
If formulation details are locked in inconsistent spreadsheets, test results sit in separate folders and version history is unclear, an AI system has limited context to work with. It may retrieve incomplete information, overlook comparable experiments or identify correlations that are not meaningful.
For AI to support better formulation decisions, it needs reliable links between ingredients, concentrations, process conditions, test methods and measured outcomes.
A structured data foundation allows teams to ask more useful questions:
- Which ingredient combinations have delivered the target foam profile in sulfate-free shampoos?
- Which substitutes have worked when a specific surfactant was unavailable?
- What changes have improved stability without increasing formula cost beyond target?
- Which historical variants are most relevant to a new regional compliance requirement?
The goal is not to replace formulation expertise. It is to make existing R&D knowledge easier to find, evaluate and apply.
Start With One Complex Product Family
Most organisations do not need to transform every legacy formula at once.
A practical starting point is a product family where formulation complexity is already causing delays: a shampoo range with regional adaptations, a household cleaning portfolio with retailer-specific SKUs, or a personal care platform undergoing an ingredient transition.
Bring the base formulas, variants, raw materials and relevant test data for that family into a connected environment. Define how teams will record parent formulas, derivative variants and the reason behind each change.
Then, as new work begins, every variant can retain its connection to the formula and evidence that came before it.
For home and personal care R&D teams, the objective is not to reduce the number of formulations at all costs. It is to ensure that every formulation remains understandable, searchable and connected to the decisions that created it.
.png)
.png)
