Duplicate SKUs Are Quietly Killing Your Cannabis Margins

Somewhere in your catalog right now, the same product is probably living under two different SKU codes. Maybe it's "Gelato 41 3.5g" and "Gelato #41 1/8." Maybe it's a METRC package that got imported twice during a busy receiving shift. Maybe it's a budtender who created a new item on the fly because the right one wasn't showing up, and nobody ever cleaned it up afterward.

These aren't rare edge cases. They're a structural feature of how cannabis retail operates - and they're eroding margins in ways that rarely show up cleanly on a P&L.

---

The Scale of the Problem

Retail industry research estimates that inventory distortion - driven substantially by duplicate and inaccurate SKU data - costs global retailers more than $1.77 trillion annually. Cannabis operators inherit every one of those problems and then layer on state-by-state track-and-trace requirements, high catalog churn, and limited access to capital. The result is that bad SKU data hits harder here than almost anywhere else in retail.

When even 3–7% of an active catalog consists of duplicate or near-duplicate products, realistic range for most operators, the downstream effects compound quickly:

• 100–300 basis points of margin leakage from mispriced items, misallocated discounts, and vendor terms negotiated against inaccurate volume figures
• 10–25% excess working capital locked in safety stock that planners over-buffer because demand signals are fragmented across duplicate identifiers
• Elevated compliance risk in markets like California, where audit discrepancy tolerances can run as low as 5%, and duplicate packages in METRC can push operators past that threshold without any physical product being missing

These aren't hypothetical risks. They're a predictable consequence of the environments most cannabis retailers operate in.

---

How Cannabis Creates the Perfect Conditions for Duplicate SKUs

Three forces work together to make duplication nearly inevitable without active governance.

Multi-system complexity. Cannabis retailers typically maintain at least three parallel inventory views simultaneously: physical stock, track-and-trace (METRC or equivalent), and POS or e-commerce. Each has separate identifiers. When synchronization fails teams often resolve the discrepancy by creating a new record rather than mapping to an existing one. The most common version: a METRC package gets imported into POS twice, creating two products pointing to the same physical inventory.

Strain naming chaos. Unlike traditional CPG, cannabis has no standardized product naming convention. The same eighth can legitimately appear as "Gelato 41," "Gelato #41," "Gelato 3.5g," or "Gelato 3.5 gram" depending on who entered it and when. Each variation can generate a new SKU. When combined with batch-to-batch potency updates recorded as distinct products, it's common for a single physical product to accumulate several active identifiers over a few months.

Rapid assortment turnover. Cannabis markets move fast - new strains, limited drops, evolving form factors. Operators add SKUs frequently to keep menus current, but invest far less in end-of-life management. The long tail fills up with overlapping records, and because no single SKU looks obviously wrong, the duplicates survive.

---

The Three Ways Margins Bleed

1. COGS distortion. Duplicate SKUs often carry different cost histories - different vendor prices, freight allocations, or promotional adjustments applied at different times. When sales for the same physical product scatter across multiple identifiers, margin analytics become unreliable. One copy of the SKU looks high-margin, the other looks like a drag. Pricing and buying decisions get made against the wrong numbers.

2. Working capital inflation. When demand for a product is split across two or three duplicate SKUs, each one appears more volatile and less predictable than it actually is. Planners respond rationally to that signal: they hold more safety stock. Multiply that across a catalog of hundreds or thousands of items, and the result is meaningful cash tied up in inventory that wouldn't be needed if the data were clean.

3. Compliance exposure. In METRC, the same physical batch can be represented as two distinct packages - a common side effect of incomplete receiving workflows or system conversions. Those duplicate packages cascade downstream into POS, then into reporting. When state auditors check, inventory appears to exist in two places simultaneously. Even with zero actual diversion, the operator faces the burden of demonstrating that - a costly and distracting process that clean data would have prevented entirely.

---

What Clean SKU Data Actually Unlocks

The inverse is worth stating clearly. Operators who invest in SKU hygiene don't just eliminate losses - they gain a genuine analytical edge.

With consolidated, deduplicated product records, demand forecasting becomes meaningfully more accurate because historical sales reflect true velocity rather than fragmented signals. Category profitability becomes trustworthy, which makes vendor negotiations and assortment decisions easier to defend. Marketing attribution improves, because CRM and promotional programs are no longer crediting the wrong SKU for a sale. And compliance posture strengthens, because METRC records align with what's physically on the shelf.

Cross-industry data supports this. CPG benchmarks show that roughly 20% of SKUs in large portfolios are marginal contributors - duplicates or near-duplicates that add complexity without adding revenue. Companies that have rationalized their catalogs consistently report improved forecasting accuracy and lower carrying costs, without meaningful revenue loss.

---

A Practical Starting Point

Fixing this doesn't require a multi-year transformation. Most operators can get meaningful signal in a few weeks by pulling a unified SKU extract from POS, METRC, and any active e-commerce or marketplace platforms, then running basic fuzzy-matching logic against brand, strain, package size, and potency fields. The clusters that emerge - groups of records that represent the same product under different identifiers - typically reveal both the scope of the problem and where the greatest financial impact is concentrated.

From there, the path is straightforward: designate a single canonical record for each cluster, clean up the regulatory package records, archive the duplicates, and establish a centralized item creation workflow so new duplicates don't re-enter the catalog.

The cannabis industry is young enough that most operators are still defining their core data architecture. Getting SKU governance right now - before catalogs grow another order of magnitude - is significantly easier than cleaning it up later. And in a margin environment this tight, the cost of waiting is real.