Free tool

SKU Generator

Create consistent SKUs (item codes) from a category, a product name and its attributes. List several values for an attribute, such as sizes or colours, and every combination is generated in one go, ready to download as a CSV.

Free, no sign-up Runs in your browser Nothing is stored
Separate values with commas.

SKUs generated

0

Everything is calculated in your browser. Nothing you enter is sent to us or stored.

On this page
  1. What is an SKU?
  2. Rules for good SKU codes
  3. SKUs for product variants

What is an SKU?

An SKU (stock keeping unit) is the code you give each distinct item you stock: every size, colour, grade or pack of a product gets its own SKU. Stores, purchase, sales and accounts all use it to mean exactly the same item.

A good SKU can be read by a person. PLY-BWP-18M-8X4 tells anyone it is 18 mm BWP plywood in 8x4 sheets, while a random number tells them nothing.

Rules for good SKU codes

  • Go from general to specific: category, product, then attributes such as size and colour.
  • Keep the same order and length for every item, so codes sort and filter cleanly.
  • Use letters and numbers only, with one separator. Avoid spaces and symbols that break barcodes and spreadsheets.
  • Avoid look-alike characters such as O and 0, or I and 1, where they could be confused.
  • Never reuse a code for a different item, even after the old one is discontinued.
  • Do not put prices or supplier names in SKUs; they change, and the code should not.

SKUs are part of your master data. See our guide on master data management for keeping item masters clean.

SKUs for product variants

When one product comes in many sizes, thicknesses or colours, each combination needs its own SKU, but they should clearly belong together. That is what the attribute fields above do: three thicknesses and two sizes give six related SKUs that share a prefix.

In an ERP, the same structure lets you keep one product with variants, so stock, prices and BOMs can be managed together. See the BOM setup guide for variants in production.

Frequently asked questions

What is an SKU number?

A stock keeping unit code that uniquely identifies one item you stock, including its variant such as size, colour or pack.

How do you create an SKU?

Combine short codes for the category, the product and each attribute, in a fixed order with one separator, for example PLY-BWP-18M-8X4.

What is the difference between an SKU and a barcode?

The SKU is your internal item code. A barcode is a machine-readable image of a code, which can be the SKU itself or a global code such as an EAN. Create one with the barcode and QR generator.

Should SKUs include the supplier?

Usually not. The same item can come from several suppliers. Keep supplier details in the item master instead.

Can I import these SKUs into an ERP?

Yes. Download the CSV and use it when you set up item masters. DotOne item masters hold the SKU with its attributes, units, HSN and reorder levels.

Keep every SKU in one item master

DotOne holds SKUs with their attributes, units, HSN and reorder levels, and syncs items with Tally.