Get 70% off QuickBooks
for 3 months. 

Ends May 31st. 
Image Alt Text
inventory

How to create SKU numbers

What are SKUs?

SKU is short for Stock Keeping Unit, it is also sometimes known as the product code (not to be confused with a barcode).


If you are selling products it is important to set up your inventory management software correctly and one of the most, if not the most important, part of this setup is the product SKU.

Why do SKUs matter?

Coding your products correctly makes it easy for you, and others, to find, search and reference products from lists, invoices, order forms etc. Find out more about why SKUs are important.

Every variation of the product should have it’s own unique SKU. It acts like an abbreviation of the product details.

Download your Free SKU Code Generator!

Easily keep your product catalog organised.


Example of good SKUs

If you’re selling novelty coffee mugs and they come in three different colors then the SKUs might look something like this:

Coffee Mug Red, model no.1 = CM01-R

Coffee Mug White, model no.1 = CM01-W

Coffee Mug blue, model no.1 = CM01-B

In the example we have used the color variant, which distinguishes the items, as the last value in the SKU. By suffixing the SKU with the variant, we make the SKU easy to comprehend whilst still grouping together all the coffee mugs with CM01 for ease of use.

To learn more about SKUs, check out our eBook on Inventory Management: Everything you need to know

Lets do a slightly more complex example. This time we’ll add in a couple of variants i.e. season, product name, product type, size and color.

Summer 2012, Gecko Tee, Small, Red = S12T-Gec-RS

Summer 2012, Gecko Tee, Medium, Red = S12T-Gec-RM

Summer 2012, Ladybird Tee, Small, White = S12T-Lad-WS

Summer 2012, Ladybird Tee, Medium, White = S12T-Lad-WM

In the example above we have provided each of the variants with a unique, but easy to understand SKU.

Create and assign SKUs (Stock Keeping Units) for all your product variants

with this SKU generator

SKU Best Practices

Create SKUs that work for you. Make them simple enough so others would understand them. Use the first area of the SKU to group the products together and use the last part, after the dash, for the unique values.

Once you have your SKUs set up correctly you should find it much easier to manage orders and product lists. QuickBooks Commerce's order management system keeps to these best practices and we expect that each variant has it’s own unique SKU.

Inventory & order management software

All your products managed in one place. It's simple, efficient and easy to control.


Related Articles

Mail icon
Explore what you can do with QuickBooks
No Thanks

Explore what you can do with QuickBooks

Image Alt Text

See profit at a glance

Get a clear view of what you make and spend over time.
Teal blue circle with a white icon of a credit card with a circle of arrows in the top right corner

Pay your team

Get payroll done right, and payroll taxes done for you.
Image Alt Text

Get live expertise

Access personalized help and guidance right from the start.

Looking for something else?

QuickBooks

From big jobs to small tasks, we've got your business covered.

Firm of the Future

Topical articles and news from top pros and Intuit product experts.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.