fbpx Skip to main content

creating SKU numbers

“How do I name my SKUs?”  This is a very common question among product businesses trying to get started. This can be more painful than coming up with names for your children!

Creating a consistent naming system for all your SKUs, whether you have two or 2000 products, will help you become more efficient and save you a lot of time and hassle in the long run Naming all future SKU’s will become much easier after you come up with a standard methodology you can fall back on whenever you need a new SKU. 

In this article, we’ll cover:

What is a SKU Number? 

SKU stands for “Stock Keeping Unit.” A SKU number is a number or short abbreviation that retailers use to identify their products and variations.

Each unique product typically has a unique SKU. That SKU can be used internally, as well as on your channels and with your suppliers when you order.

Why SKUs are Important for Your Business 

SKUs are important because they help you track your inventory for many purposes, including:

  • Inventory quantity tracking
  • Fulfillment purposes
  • Forecasting
  • Ordering

SKU codes are an integral factor in scaling a business. They can be used across many areas of your business, including:  

  • Product packaging 
  • Product shelves in warehouses or product fulfillment centers 
  • Picking lists 
  • Order receipts and invoices 
  • Online store dashboards, including marketplaces 
  • Sales reports 
  • Accounting dashboards 
  • Inventory management system dashboards 

SKUs help to shorten identifiers from long & lengthy descriptions, while staying specific to an item.   They can be easily searched for, clearly identified, and are fast to type.   

Imagine trying to use a description for everything instead of a SKU.  If you had to type “Yellow shirt, size 4, puff sleeves” every time you were referencing this one product, it would be very difficult to keep things clean.  If instead this product is consistently referred to as YSH-4-PS, it becomes much easier to reference consistently across the different areas of your business.

Some of the benefits of proper SKU naming include: 

  • Easy identification of products and their variations 
  • Increased efficiency, accuracy, and speed of fulfillment 
  • Reduced errors in product warehousing & shipping 
  • Assistance in inventory tracking and management
  • Increased speed and accuracy when ordering

How to Create SKU Numbers 

You can always randomly generate number and letter combinations when coming up with SKUs but we strongly recommend against going with this approach.  SKUs are much more useful and easier to use when they can be read as a description of the product, identifying many of the product’s most important characteristics. 

Any parameters you use to identify your products can be abbreviated in the form of letters and numbers that enable you to easily distinguish one product from another.  You can create it based on:  

  • The product’s manufacturer 
  • Product name 
  • Model 
  • Size 
  • Color 
  • Description 
  • Material 
  • Any other specified parameters 

For example, consider in the table below how the ending SKU clearly identifies the style, color, and size of the product.

Here is another example of a cleaning company’s products:

Someone with a little experience in these companies could tell you exactly what product the SKU was referencing. without needing a lengthy product description. 

These are some best practices to consider as you get started: 

  1. Try to stick to one SKU naming formula for all products. 
  2. The best SKUs are between 8-12 characters, and definitely under 16. 
  3. Keep them easy to read and understand. 
  4. Try to avoid confusing letters, numbers, and special characters. 
  5. Avoid starting a SKU with a zero (Excel will edit out the beginning zero if you put it in a spreadsheet, creating a lot of hassle and headache). 
  6. Arrange SKU in order of importance, typically generic to specific attributes. 
  7. The best SKUs have easily identifiable attributes and qualities. 

 These are the steps we recommend for coming up with SKUs for your products: 

Step 1: Start SKU Numbers with the Main Identifier

What is the most important identifying feature of the item? The first 2-3 letters or numbers of the SKU should indicate this. This can be a category, department, manufacturer, or some other main identifier.

Step 2: Use Middle Numbers for Unique Identifiers

What is the next most important thing that identifies the item? The middle section is best for colors, sizes, item type, etc.

Step 3: Use Last Numbers for Additional Identifiers

Is there anything else you need to identify this item quickly and easily? Use the last few letters/numbers for it. This can also be a sequential number – like 001, 002, or 003 – to identify how old an item is (older items will have smaller numbers).

Establish a a coding system around some of your identifiers. Ask yourself “What makes this product different from my other products?

Make a list of all the parameters for all your products and how you will identify various aspects of them. Consistency is crucial in this process.

Here are some examples: 

Creating these coding systems will make it easier to scale later as you add more products to your catalog.  

Here are some examples, as given by eshopbox.com 

  • If you sell apparel, you can include brand, item type, material, color, size.
  • If you sell computers, you can include brand, model, color, warranty, and accessories.
  • If you sell coffee mugs, you can include design, size, and color.
  • If you sell crockery sets, you can include brand, item type, material, color, size, and quantity of items within the set.  

If this seems too complicated, especially if you have a LOT of products to name, you may want to consider a SKU name generator like Zoho, TradeGecko, Gorgias, or 3DSellers 

Good Examples of SKU Naming:  

Daily Planners  

  • 2021 Daily Planner, Red with Color-Coded Tabs = DP21-RD-T  
  • 2022 Daily Planner, Black with Color-Coded Tabs = DP22-BK-T  

Shoes  

  • Under Armour Blue Tennis Shoes, Size 10 = UA-T-BL-10  
  • Nike Orange Running Shoes, Size 8 ½ = N-R-OR-8.5  

Plates  

  • 10-inch Dinner Plates, White, Set of 6 = DPLT10-WH-6  
  • 8-inch Dinner Plates, Blue, Set of 10 = DPLT8-BL-10  

T-Shirts  

  • Men’s T-Shirt, White, Medium = TS-M-WH-M  
  • Women’s T-Shirt, White, Small = TS-F-WH-S  

How LedgerGurus Can Help You

Keeping track of SKUs manually isn’t all that difficult if you only have a few. But when you start getting hundreds or even thousands, the time it takes to keep track of them manually becomes burdensome. When you are far enough along in your business that you’re interested in utilizing an inventory management system, consider LedgerGurus in helping you get it set up. An IMS is a much better alternative to death by spreadsheets, if you can help it.  

If you find yourself getting overwhelmed and you’re ready for some help in either implementing a tool or running it, make sure to let us know. We’re happy to help!

Kelley Birrell

Kelley is the Content Manager for LedgerGurus. She oversees all the content creation, capitalizing on the expertise of so many talented people inside LedgerGurus. She lives in Kansas. Fall is her favorite season, and seeing the maple trees glowing in the sun fills her heart with joy!