One Formula, Forty Variants

One product on the shelf can be forty formulations in the lab — here's how to keep them connected.
Table of Contents
5
min read

A shampoo is never just a shampoo. It's the base formula, plus the sulfate-free version, the EU-compliant version, the version with the fragrance the retailer asked for, the cost-reduced version for the value brand, the concentrated refill, and the one being reformulated for a recyclability claim. One product on the shelf can be forty formulations in the lab.

Every variant was developed, tested, and approved by someone. The question is whether your R&D organization can still see how they relate.

Why Do Home & Personal Care Product Lines Multiply Variants?

Because the business demands it. Regional regulations diverge, so the same product ships with different preservative systems in different markets. Retailers want exclusives; cost pressure forces substitutions on the value tier but not the premium one; sustainability commitments trigger rolling reformulation across entire portfolios. None of this is a failure of discipline — variant sprawl is what success looks like in CPG.

The failure happens in the data. Each variant typically starts as a copy: a spreadsheet duplicated, renamed, and edited. From that moment, the connection between parent and child exists only in someone's memory.

What Breaks When Variants Live in Disconnected Files?

The relationships disappear. When the base formula changes (a supplier discontinues an ingredient, a raw material is reclassified) there is no reliable way to answer the first question that matters: which variants inherit this change? Teams reconstruct the answer by hand, file by file, and hope nothing was missed.

Testing history fragments the same way. The stability data for variant 12 lives in one folder, the consumer panel results for variant 23 in another, and neither is searchable by what's actually in the formula. Scientists looking for "every variant where we used this surfactant above 2%" are searching file names and initials instead.

And work gets repeated. When formulation history isn't queryable, teams re-run experiments their own organization already ran. In our experience, recreating past work can cost a team around three months that access to the original data would have saved.

Filtered search in Uncountable titled "Variants containing SLES > 2%," showing five Everyday Care Shampoo variants — Base, EU-Compliant, Cost-Reduced, Concentrated Refill, and Fragrance-X — as rows, with columns for phase, Sodium Laureth Sulfate (SLES) in grams, and foam volume in milliliters.
Filtering for every shampoo variant with more than 2 g of SLES surfactant — the sulfate-free version drops out automatically — with foam volume alongside. More surfactant tracks with more foam: the cost-reduced variant (9 g) foams least, the concentrated refill (20 g) most.

How Do Connected Formulation Systems Handle Variants?

The variants stay linked — to their parent formula, to their test results, and to the reasoning behind each change. In a structured platform like Uncountable, a formulation is data, not a document: every ingredient, concentration, and process step is a queryable field, and every test result is attached to the exact version that produced it.

That changes the daily questions from archaeology to lookups. Which variants contain the ingredient being phased out? Filter and see. How did the sulfate-free variants perform on foam volume versus the base? Plot it. What did we change between version 7 and version 8 of the retailer exclusive, and why? It's in the version history.

This isn't theoretical for the industry. At Uncountable's 2026 Unify Summit in Philadelphia, R&D leaders from Indovinya — whose surfactants and specialty ingredients go into home and personal care products worldwide — presented alongside teams from Rogers Corporation and Avery Dennison's Taylor Adhesives, sharing how they're putting structured R&D data to work. The common thread across industries as different as elastomers, adhesives, and personal care ingredients: the teams moving fastest are the ones who structured their data first.

It also changes what's possible next. Structured, connected formulation history is the prerequisite for using machine learning to suggest candidates and reduce trial counts — models can only learn from data that's consistent enough to learn from. Structure first; the intelligence follows.

Where Should a Team Start?

Start with the portfolio's most variant-heavy product family and get its history into one structured system — formulas, versions, test results, linked. The payoff compounds from there: each new variant inherits its context instead of escaping it.

See Variant Management on Real Formulations

Book a personalized demo and we'll walk through how home & personal care teams manage variants, versions, and test data in one platform. Request a demo

Frequently Asked Questions

Why do home and personal care product lines have so many formulation variants?
Because the business requires it — regional regulations, retailer exclusives, value-tier cost reductions, and sustainability reformulations all multiply variants. The hard part isn't the sprawl itself; it's keeping each variant connected to its parent formula, its test results, and the reason behind every change.
What's the problem with managing formulation variants in spreadsheets?
Each variant usually starts as a copied, renamed spreadsheet, so the link between parent and child lives only in someone's memory. When a base formula changes, there's no reliable way to see which variants inherit it — and test history can't be searched by what's actually in the formula.
How does a connected formulation platform manage variants?
It keeps every variant linked to its parent formula, test results, and change history, with each ingredient and process step stored as a queryable field. Teams can filter variants by ingredient, compare performance across versions, and see exactly what changed between versions — turning investigations from archaeology into lookups.

Download our resource

It's completely free.

Related Articles