Why Jewelry Buying Agencies Drown in SKUs

We sat with the operations lead at a Mumbai-based jewelry buying agency last month. Fourteen vendors across Jaipur, Rajkot, and Coimbatore. About 9,400 active SKUs feeding three retail accounts in the US and one department store buyer in Germany.

She opened her laptop and showed us a single supplier folder. 612 product images. 47 of them were variants of the same hoop earring in different gold weights. None were named consistently. The price sheet was a separate WhatsApp PDF from three weeks earlier. Two of the variants in the folder were already discontinued.

This is not a furniture problem. A furniture buying agency manages maybe 200 to 800 SKUs per supplier. A jewelry agency routinely handles 600 to 2,000 per supplier, and most of those SKUs have three to eight legitimate variants by metal weight, stone setting, or finish.

If you assume 14 suppliers and an average of 1,100 SKUs each, you are at roughly 15,400 line items the agency is responsible for keeping accurate. The Mumbai team had two people doing this manually.

When we mapped where their week actually went, the breakdown was uncomfortable.

• Variant reconciliation — 38% of catalog time. Same product, four metal weights, three stone options, photographed inconsistently across visits.
• Price sheet chasing — 22%. Gold and silver prices move daily. Suppliers send updated WhatsApp PDFs whenever they feel like it.
• Hallmark and certification tracking — 14%. BIS hallmark for India sales, separate import certs for EU buyers, gemstone certificates for anything over $200 wholesale.
• Image cleanup — 19%. Backgrounds inconsistent across vendors, scale references missing, color cast varies by supplier camera.
• Actually presenting to buyers — 7%. The reason the agency exists.

The German department store buyer told the agency she opens about 40% of their PDFs. The US specialty buyers open closer to 60%. Industry benchmarks for unified buying-agency catalogs sit closer to 75% open rates when the format is consistent across vendors.

The drop-off is not interest. It is friction. A buyer reviewing earrings does not want to translate four supplier formats in her head. She wants one view: piece, materials, weight, available variants, MOQ, hallmark status, lead time, landed cost estimate. When that view does not exist, she pages through 12 PDFs and orders from the three suppliers whose formats she already understands. The other 11 vendors lose the season.

They did not try to fix everything. They picked the one bottleneck that touched every other problem: variant reconciliation. Until variants were treated as structured attributes instead of separate SKU rows, every other workflow downstream was duplicated.

They restructured how each supplier delivered new collections. Instead of one folder per piece with ad-hoc image names, every piece had a parent SKU with up to eight variant slots tagged by metal, stone, and finish. The supplier still photographed each variant, but the agency now had a single product record per design instead of eight.

That one change collapsed their catalog from 15,400 line items to about 4,800 parent SKUs with structured variants. Reconciliation time dropped roughly in half. Price-sheet updates now propagated to all variants at once. Hallmark status was tracked per parent SKU instead of per row.

It also gave them something to send buyers: one product page per design, with a clean variant selector. The German buyer's open rate moved from 40% to a number the agency would not let us publish, but the Q1 reorder volume from her account was up meaningfully.

If you are running a jewelry-accessories agency and your catalog feels heavier than your peers in furniture or home textiles, you are not imagining it. The variant density is real, and so is the tax it puts on a two-person ops team.

The fix is not more headcount. The fix is treating variants as a first-class concept in your catalog, not as separate SKUs that happen to look similar. Anything that does not enforce that structure is going to keep duplicating the work downstream.

This is exactly the kind of vendor-management bottleneck we built Poly9's Product Catalog and Collection Builder to handle, with multi-variant SKUs and per-buyer presentation views as the default rather than the workaround. If you are a buying agency drowning in variants, those two features are the place to start.