How to Generate Standardized SKUs for Your Wholesale Flower Products

Quick test. Open your product list and look at the first 20 SKUs. Are they consistent? Can a new warehouse employee look at any SKU and immediately know what product it refers to without looking it up?

If you're like most wholesale flower distributors I've talked to, the answer is somewhere between "sort of" and "absolutely not." And you're not alone -- SKU chaos is one of the most universal problems in the wholesale flower industry.

I've seen SKU systems that started organized and decayed over time. I've seen SKU systems that were never organized to begin with. I've seen wholesalers with no SKU system at all, just product names that vary depending on who entered them. And I've seen the downstream damage all of these cause: order errors, picking mistakes, inventory discrepancies, and hours of wasted time every week.

Here's how to fix it, whether you're starting from scratch or cleaning up years of accumulated mess.

Why SKU Chaos Happens in Flowers

The wholesale flower industry has a SKU problem that most other industries don't, and it comes down to a few factors that compound on each other.

The product matrix is enormous. A single rose isn't just "a rose." It's a variety (Freedom, Mondial, Playa Blanca, Explorer -- there are hundreds), a color, a stem length (40cm, 50cm, 60cm, 70cm), and a pack size (bunch of 10, bunch of 25, box). The number of possible combinations for just roses can run into the thousands.

Naming isn't standardized across the industry. Your supplier calls it "Ruscus Italian." Another supplier calls it "Italian Ruscus." A third calls it "Ruscus, Italian Green." The florist calls it "Italian." There's no industry-wide naming convention, so every wholesaler ends up with their own idiosyncratic system.

Seasonal products rotate constantly. You might carry dahlias for four months, then they're gone for eight. When they come back next season, does someone create a new SKU or find the old one? In practice, they often create a new one, and now you have duplicate SKUs for the same product.

Multiple people add products over time. The person who set up your original catalog had a system. Then they left, and the next person had a different system. Then a third person started adding products "temporarily" without any system at all. Five years later, your SKU list is an archaeological dig of different conventions.

What a Good Flower SKU Looks Like

A good SKU for wholesale flowers should be:

• Human-readable. Someone should be able to glance at it and have a reasonable idea what the product is.
• Systematic. Every SKU follows the same pattern.
• Unique. No two products share a SKU, ever.
• Compact. Short enough to fit on a label, speak over the phone, or scan quickly on a pick list. Ideally under 15 characters.

Here's a structure that works extremely well for wholesale flowers:

[CAT]-[VAR]-[COL]-[SIZE]

Where:

• CAT = Category code (3 characters): ROS (roses), TRP (tropicals), GRN (greens/fillers), GAR (garden flowers), DRI (dried/preserved), HRD (hard goods)
• VAR = Variety code (3-4 characters): FREE (Freedom), MOND (Mondial), PLAY (Playa Blanca), RUSC (Ruscus), HYDR (Hydrangea)
• COL = Color code (3 characters): RED, WHT, PNK, LAV, YEL, MIX, GRN, BLU
• SIZE = Size or unit indicator: 50 (50cm), 60 (60cm), B25 (bunch of 25), B10 (bunch of 10), STM (single stem), BX (box)

Examples in practice:

A new employee can look at ROS-FREE-RED-50 and know it's a rose, Freedom variety, red, 50cm stem. No lookup needed. That clarity cascades through every part of your operation: faster picking, fewer errors, simpler inventory counts, and cleaner order processing.

Cleaning Up an Existing Mess

If you already have hundreds of products with inconsistent SKUs, a full overhaul feels daunting. Here's a phased approach that works without shutting down operations.

Phase 1: Define Your Conventions (1 hour)

Before changing a single SKU, write down your rules. What are your category codes? How do you abbreviate variety names? What's your color code list? What are your size/unit options?

Keep the rules on one page. Seriously. If your SKU convention can't fit on a single sheet of paper, it's too complicated and nobody will follow it.

Phase 2: Tackle Your Top 50 Products (2-3 hours)

Sort your products by order volume. The top 50 products probably account for 70-80% of your orders. Reassign SKUs for those 50 products using your new conventions. Update them in your system, your pick lists, and your catalog.

This alone will dramatically reduce day-to-day confusion because the products your team handles most frequently will now have clean, readable SKUs.

Phase 3: Work Through the Rest in Batches (ongoing)

Set a target of re-SKUing 20-30 products per week. At that pace, a catalog of 400 products takes about 15 weeks to fully convert. That sounds slow, but it's sustainable. A crash conversion where you change everything at once is a recipe for chaos during the transition.

Phase 4: Deprecate Old SKUs (after full conversion)

Once every product has a new SKU, keep the old SKUs in your system as aliases for 90 days. Some florists may have saved your old SKUs in their ordering notes, and you don't want orders to break. After 90 days, retire the old codes.

Common SKU Mistakes to Avoid

I've seen a lot of SKU systems, and the same mistakes come up repeatedly:

Using sequential numbers. SKU-001, SKU-002, SKU-003. These tell you absolutely nothing about the product. Your warehouse team has to look up every single one. It's technically a SKU system but practically useless.

Making SKUs too long. ROSE-FREEDOM-RED-50CM-BUNCH25-GRADE1-ECUADOR is a product description, not a SKU. Keep it under 15 characters. Your pick lists and labels will thank you.

Including price in the SKU. Some wholesalers embed the price tier in the SKU code. This breaks every time prices change. SKUs should identify the product, not its economics.

Using special characters. Stick to letters, numbers, and hyphens. Slashes, periods, spaces, and other characters cause problems in software systems, barcode scanners, and CSV exports.

Not accounting for pack size. "ROS-FREE-RED-50" is the same stem whether you sell it in bunches of 10 or bunches of 25. But those are different products with different prices. Your SKU system needs to differentiate them.

The Auto-Generation Advantage

Here's the brutal truth about manual SKU creation: it works until it doesn't. Someone forgets the convention. Someone abbreviates a variety name differently. Someone accidentally creates a SKU that already exists. The entropy always wins eventually.

This is why auto-generated SKUs are so valuable. You define the rules once -- your category codes, your abbreviation patterns, your size formats -- and the system generates consistent SKUs for every new product. No human judgment calls. No "wait, how did we abbreviate chrysanthemum again?" moments.

Auto-generation also catches duplicates before they happen. Try to add a product that matches an existing SKU pattern, and the system flags it. This alone prevents the most common source of SKU chaos: the accidental duplicate.

For wholesalers who are setting up a new catalog or migrating from an unstructured system, auto-generated SKUs can save dozens of hours of tedious manual work. Instead of sitting with a spreadsheet and carefully typing out 300 SKU codes, you enter your product information and let the system do the formatting.

How SKU Discipline Pays Off

Clean SKUs aren't glamorous. Nobody starts a flower business because they're passionate about product coding systems. But the downstream effects touch almost everything:

Faster picking. Your warehouse team can read a pick list and immediately know what to grab. No hunting, no guessing, no asking "is this the 50cm or the 60cm?"

Fewer order errors. When a florist orders ROS-FREE-RED-60, there's no ambiguity about what she wants. Compare that to "50 red roses" -- which variety, which length, which pack size?

Simpler inventory counts. Physical inventory counts go dramatically faster when every product has a unique, readable identifier. Instead of squinting at product names and trying to match them to a spreadsheet row, your team scans through organized SKU codes.

Better data over time. When your SKUs are consistent, you can actually track sales trends, identify your best and worst sellers, and make informed purchasing decisions. Messy SKUs make this analysis nearly impossible.

Smoother onboarding. New employees learn a systematic SKU convention in a day. Learning 400 arbitrary product codes takes months.

Getting Started for Free

You have two paths here, and both work.

Path 1: Manual. Use the conventions I laid out above, create a spreadsheet template with your codes, and start assigning SKUs by hand. This is free, it works, and it's perfectly fine for a wholesaler with a small catalog who wants complete control.

Path 2: Software-assisted. Use a product management system that auto-generates SKUs based on your rules. Faster, less error-prone, and scales better as your catalog grows.

PetalPost includes auto-generated SKUs as part of the free product catalog. You add your products with their details -- variety, color, size, pack format -- and the system generates consistent, standardized SKUs automatically. It's one less thing to manage manually, and it ensures every product in your catalog follows the same conventions from day one.

CTA: PetalPost gives wholesale distributors a digital catalog and B2B portal on a free (Starter) tier -- no credit card required. Start at api.petalpost.shop.

Start Now, Even If It's Messy

Don't wait for a perfect system. The best time to standardize your SKUs was when you started your business. The second best time is now.

If you have 400 products with chaotic SKUs, you don't have to fix them all today. Start with your top 50. Get those clean and consistent. Then work through the rest over the next few months. Every batch you convert reduces errors, speeds up operations, and makes your catalog more professional.

The flower industry has a lot of problems that require significant investment to solve. SKU standardization isn't one of them. It just requires a decision to stop tolerating the chaos, a one-page set of rules, and the discipline to follow them.

Your warehouse team will notice the difference in a week. Your florists will notice in a month. And six months from now, you'll wonder how you ever operated without a real SKU system.