How to Optimize your SKUs and Enhance Sales with Online Merchandising


Share on LinkedIn

An SKU or a Stock Keeping Unit is a vital part of retail inventory management. It helps retailers organize, optimize, and keep track of product information, accurately.

SKUs and Their Relevance in Retail Merchandising

You sell a large number of products in your business. Even if you own a single small store, you still need to keep track of and manage several different products. Add to this your online stores and tracking of individual products complicates further. You will have a variety of information about the product stored in your database like the product name, manufacturer/supplier, current stock, prices, etc. An SKU or a Stock Keeping Unit is a unique identifier for each product sold in your shop. It is specific to your business and helps you keep track of various items in your inventory.

Have you ever used a Walmart SKU specific inventory checker? These tools ask you to enter the SKU of the product. You get accurate information about the stock availability, price, in which locations it is available, etc. The Walmart inventory checker tool does an SKU lookup on Walmart SKU data in the relevant location according to your zip code, to provide you this information.

Designing Your SKUs

You can design your SKUs to help identify all key information about the product like its brand, category, type, color, size, etc. Stock Keeping Units can be as simple or as complex as you like.

They are different from other general identifiers like UPCs and ISBNs because they are specific to your store or retail chain. UPCs and ISBNs are common across the retail landscape, they don’t hold any data unique to your business.

With SKUs, you can properly encode various information relevant to your store. It is entirely in your hands irrespective of who your suppliers are. You can then use an SKU lookup to seamlessly track and manage items in your inventory.

What Can You Encode into Your SKUs?

With an SKU, you can encode product category or department, product type, size, color, and other relevant information. For instance, if you sell clothes, you may have categories and variations within them:

Gender Category Type Size Color
Male (M) Shirt (01) Casual (1) Large (L) Blue (BU)
Female (F) Pants (02) Formal (2) Small (S) Black (BK)
Female (F) Skirt (03) Party (3) Medium (M) Red (RD)
Girl (G) Pants(02) Jeans (4) Medium (M) Green(GN)
Boy (B) Pants (02) Jeans (4) Medium (M) Grey (GY)

So, your SKU for a blue jeans large size for a man may look like this – M024LBU008. A Red Casual Shirt for a woman, medium size, may look like this F011MRD003. A Girl’s casual shirt, small blue may have this SKU – G011SBU005. These make an SKU lookup easier and more meaningful.

The codes for gender, size, category, type, color, etc, once defined, may be used in different combinations to identify various garments. The final three numbers are just sequential numbers used to number the items in that category/type/size/color for that gender/age. This section can also help you keep track of whether the item is old or new if you number the stock as they come in.

You may also choose to include more information like a brand/manufacturer. For instance, you may have an encoding for brands like this:

Levi’s – X01 Wrangler – X02 Lee Jeans – X03

In this case, you may identify a men’s medium size Blue Levi’s jeans like this – M024X01MBU453

If your business is a retail chain, you may want to keep track of inventory and sales by each store. So, you may have an encoding for your store locations like this – S01, S02, S03.

In that case, you may identify an Allen Solly women’s blue shirt, formal, large size, sold in your store location 3 as- S03F012X12LBU054.

Using this type of encoding lets you extract a lot of information about the item just based on the SKU, without doing an SKU Lookup in your database to retrieve more information. Just a visual SKU lookup lets you know in which store this sale was made, the brand, whether it was for a man or woman or a child, the type, size, color, etc.

SKU Format Best Practices

When designing your SKU structure, it is good to follow certain rules:

1. Keep it simple: SKU names should be easy to understand and self-explanatory. This makes it easy for different departments in your company – operations, customer support, logistics, etc. to access and decode the SKUs without any confusion.

2. No Zero at the Start: Never begin with a zero. Computers are designed to deal with numbers. If you use a pure number format in your SKUs and you begin with a zero, your inventory system or your analytics program might eliminate the 0 at the beginning, as a zero at the start has no value. Always begin with a nonzero number or a letter.
Make it Alphanumeric: Use alphanumeric SKUs, they provide more flexibility and can help you provide visual cues as to whether you are looking at brand info, gender, type, size, etc.

3. No Spaces: Never use spaces, these too might get truncated during processing. If you need separators in your SKUs, use “_” or “-”. Do not use “/”, “%”, “$” or other special characters, these too might cause confusions.
Keep It Short: Do not make your SKUs too long, try to limit the SKUs to 8 to 12 characters. If you are a huge store chain, selling multiple products from different brands, you may need longer SKUs. Even in these cases, try not to go beyond 16 or 18 characters. In some instances your employees or your customers might need to write down the SKU by hand – for instance, to do an SKU lookup. Having a 32-character SKU is just going to make this task a lot harder.

4. Avoid Number-Letter Confusions: Try to avoid using letters that look like numbers, like I, l, etc, as they may be confused with each other or the number 1. The letter O might also be confused with zero (0). These letters make it harder to get quick visual cues from the SKUs.
Do not use manufacturer numbers or UPCs as your SKU, they will not provide information that is relevant to your business.

The Uses of SKUs

Designing a good SKU structure can help you get a lot of information about the item from the SKU code itself.
A simple visual SKU lookup on a customer receipt, for instance, may help identify the brand, the gender, style, size, color and even the store location where it was sold.

Your SKUs help in correctly retrieving prices and in updating your inventory to reflect up-to-date stock levels.
You can convert your SKUs into barcodes to automatically scan in product information at checkout.
You can track and compare competitor stocks and optimize your stocks to fill gaps and take advantage of shortages.
You can use your SKU format to determine relationships between products and provide suggestions to customers about related or alternative products when they’re shopping. All this depends on how well you have designed your SKU format, and your SKU lookup system.

Many customers check product availability in big box stores in their region, for instance by utilizing a Walmart inventory checker. If your store competes with Walmart on certain items, you can also use Walmart inventory checker tools to compare and adjust Walmart SKUs’ stock levels and prices.

You may also provide such an SKU lookup facility on your website for customers to use, allowing them to quickly check availability while shopping online or to find where the item is available before they visit a brick & mortar store. Walmart SKU search option is a great example of this kind of inventory lookup facility.
Having a uniform SKU format also helps you in shipping the right products quickly and keeping a close eye on logistics and inventory.

SKUs have another use, you can look up similar products listed on competitor websites. For instance, Intelligence Node provides an SKU API along with its retail solutions. This can be used to search for product matches, using images. descriptions, UPCs etc. You will get clear and structured information that includes product images, description, and price, You can get matches across different retailers.

How Optimized SKUs help with Online Merchandising

Today’s consumers are demanding and expect a personalized, seamless experience while shopping. This has made online visual merchandising as important as in-store merchandising in ensuring engaging and exciting shopping experience. Merchandisers have to ensure they keep updating the online store to showcase the best, top-selling, and in-demand products to attract customer attention. Having a 360-degree view of and easy access to optimized SKUs is essential to churn out attractive assortments, update online merchandise quickly to be in-line with the latest trends, ship the right products quickly, and win at the online merchandising game.

Stock Keeping Units (SKUs) are a must-have for retailers to keep up in this dynamic, fast-paced retail environment. They make it easy to find relevant information from a product identifier, information that is highly specific to your business. They provide a way for your employees and even your customers to quickly use an SKU lookup to check for product availability. Using SKUs is vital even for small retail businesses. Design a good SKU format today and start reaping its benefits across your retail value chain.

Get real-time product insights with a simple SKU lookup. Our high-frequency scraping lets you access accurate, precise data with ease. Get a demo.

Tullika Tiwary
I would like to take the privilege of introducing me as one of the retail analytics researcher. I analyse data and predict trends based on that.


Please use comments to add value to the discussion. Maximum one link to an educational blog post or article. We will NOT PUBLISH brief comments like "good post," comments that mainly promote links, or comments with links to companies, products, or services.

Please enter your comment!
Please enter your name here