How to Generate Bulk Product SKUs for WooCommerce

3 min read by Mohammad Shoeb

How to Generate Bulk Product SKUs for WooCommerce

A SKU is the internal code you use to identify a product, and typing them by hand across a catalog is slow and error-prone. The good news is that SKUs follow patterns, so you can generate them in bulk from a simple scheme instead of inventing each one. This guide covers what makes a SKU good and how to build a whole batch at once.

What a SKU actually is

SKU stands for Stock Keeping Unit. It is a unique internal code that you assign to a product so you can track stock, search orders, and reference items across your store and any tools you connect to it. It is not the barcode (that is the UPC or EAN) and it is not visible to customers unless you choose to show it.

In WooCommerce, every SKU must be unique. If you try to save a product with a SKU that already exists, WooCommerce blocks it with a duplicate error. That single rule is why a consistent generation scheme matters so much: it guarantees you never collide.

What makes a good SKU scheme

A strong SKU is short, consistent, and just meaningful enough to read at a glance. Build it from segments:

  • Category - a short prefix like TS for t-shirts or MUG.
  • Attribute - color, size, or material, like BLK or LG.
  • Number - a sequential or product number, like 0042.

That gives you something like TS-BLK-0042. A few rules keep them clean:

  • Keep them short. Long SKUs are hard to scan and read aloud.
  • Be consistent. Use the same segment order and length for every product.
  • Avoid spaces and special characters. Stick to letters, numbers, and dashes.
  • Avoid ambiguous characters. The letter O and zero, or I and 1, cause mistakes.
  • Keep them unique. WooCommerce will reject duplicates anyway.

Generate them in bulk from a pattern

Once you have a scheme, you do not need to type each code. The WooCommerce SKU Generator lets you define a pattern with a prefix and a number sequence, then produces the whole batch at once. Here is the flow:

  1. Open the WooCommerce SKU Generator and set your prefix, like TS-BLK-.
  2. Choose your starting number and padding, so 1 becomes 0001.
  3. Set how many SKUs you need, and the tool generates the full sequence.
  4. Copy the list and paste it into your product spreadsheet or CSV.

Everything runs in your browser, so nothing about your catalog is uploaded anywhere. You get a ready-to-paste column of unique, consistent codes in seconds.

Apply them to your products

With your SKUs generated, drop them into the SKU column of your product import CSV, or paste them one by one into the Inventory tab of each product under Products > Edit. Because every code came from the same pattern, your catalog stays tidy and every SKU stays unique. If you ever add a new variant, just continue the number sequence from where you left off.

Pick a scheme once, generate the batch, and never type a SKU by hand again.

WooCommerceWordPressHow-to

← All posts