How to Find SKU Numbers (2024)

Verified & Reviewed

Last updated on January 12, 2024 Written By Rachel Hand

How to Find SKU Numbers (1)

Last updated on January 12, 2024 Written By Rachel Hand

How to Find SKU Numbers (2)

Subscribe for More

Table of Contents

** Minutes

What are SKU numbers?

Where do you find a SKU number?

How are SKU numbers used within ecommerce?

How to create SKU numbers for products

SKU number examples

How ShipBob’s SKU management works for retailers

How to find SKU number FAQs

Whether you have 3 products or 300, SKU numbers are one of the most useful tools for your business.

There are so many benefits: they simplify inventory management, increase visibility into inventory levels and sales data, and even improve the customer experience.

That said, there’s no one-size-fits-all way to create SKU numbers — and when it comes to finding SKU numbers, you’ll find that different brands use them in different ways. Without understanding their purpose, adopting a SKU system can get messy quickly.

In this article, we will discuss what SKUs are and how they can be found, as well as everything you need to know about how to create SKUs for products missing them, the best way to manage SKUs, and how you can find the right 3PL to help you seamlessly manage the entire process.

What are SKU numbers?

SKU (or stock keeping unit) numbers are custom alphanumeric codes that merchants assign to every unique product or product variety.

SKUs are typically 8-10 characters long, with each character (or sets of characters) representing a particular feature of the product that SKU is assigned to.

There are no standardized rules for creating SKU numbers. Rather, every business is free to create SKU numbers using whatever characters and referencing whatever features make the most sense for their operations. However, SKUs are most useful when they are simple and easy to understand.

Where do you find a SKU number?

SKU numbers can be found in a variety of places, both internal and in customer-facing.

Typically, SKU numbers are listed on the product’s packaging — usually above the product’s barcode, as seen below.

How to Find SKU Numbers (3)

While the 12-digit numeric code on the bottom is the product’s UPC (Universal Product Code), the alphanumeric code at the top is the SKU number (which is different from the UPC).

SKU codes are also sometimes located on the price tag of the product, especially for items like clothing and toys.

In physical stores, SKUs are occasionally listed on the shelves where their products are placed instead of being printed on the product itself. This allows the retail store workers to efficiently locate and manage the in-store inventory.

Products are not required to have SKUs — so if a product does not have an SKU printed anywhere on it or the packaging, the product either has not been assigned one yet or may only be listed online.

How to find SKU number for products online

To find a SKU online, try going to the product page on the business’s website. Many times, the SKU will be listed in the product description or in the other information provided.

However, ​​it’s important to note that the customer-facing version of a SKU is not always the same internal SKU number that a brand uses to organize products for storage and restocking purposes.

“After starting our search, we found that many 3PLs were not interested in working with us because we had too many SKUs and not enough volume to work with them. Others lacked the ability to ship internationally or only shipped using one carrier.

We then found ShipBob, who checked all the boxes. They have ended up being the perfect solution for us and we have never looked back!”

Waveform Lighting team

How are SKU numbers used within ecommerce?

There are several ways to use SKU numbers in ecommerce and retail. Here are just a few of the top reasons why ecommerce businesses utilize SKUs across their inventory.

Efficiently track all inventory

Because each SKU is unique, it gives you a way to distinguish between items. This, in turn, makes it easier to track the amounts, movements, and sale levels of individual products.

With SKUs, you can easily track the status of your inventory and how much you have in every storage and fulfillment location, which helps you to make more informed supply chain decisions.

Provide SKU product data

By adding SKU to all products, you are able to collect data from your inventory processes and better understand which products are selling well and which need a bit of a push.

In this way, SKUs provide much more detailed inventory data and can even help you audit your inventory and discover deadstock.

Forecast future sales

By making inventory tracking easier, SKUs subsequently enable you to forecast future demand and sales more accurately.

With every specific product segmented and tracked, you can study each product’s performance across a given period and analyze the customer trends.

You can also observe the order values and volume across different products, determine which products are being more profitable for your business, and make future purchasing decisions accordingly.

This lets you predict and prepare for customer demand and set your business up for success.

Set reorder points

Without a system for tracking and distinguishing products from each other, it can be hard to know when to reorder what products. By assigning each product a SKU, you gain a new level of inventory visibility, and can quickly identify which stock levels are running low.

Segmenting specific products via SKUs also enables you to set reorder points for each unique item. This ensures that the said item does not go out of stock while we wait for its inventory to be replenished.

“ShipBob’s analytics tool is also really cool. It helps us a lot with planning inventory reorders, seeing when SKUs are going to run out, and we can even set up email notifications so that we’re alerted when a SKU has less than a certain quantity left. There is a lot of value in their technology.”

Oded Harth, CEO & Co-Founder of MDacne

Create a better customer experience

Assigning SKUs to each product variety facilitates better inventory tracking, provides more detailed sales data, and helps you time replenishment correctly — all of which combine to better the customer experience.

Tracking SKU data helps you identify trends so that you can meet customer demand. Insight into SKU quantities at various locations helps prevent stockouts and backorders that drive customers to away from checkout and towards cart abandonment.

If you do stock out, SKUs can also be used to suggest similar items to customers.

How to create SKU numbers for products

SKUs are customizable — that is, there is no one set of conventions or rules that every business follows when creating SKUS. Rather, each business is free to create SKUs according to whatever system best suits their needs.

While it is possible to use a SKU generator to create your SKUs, there are certain aspects of the process that you’ll need to think through yourself. Here are a few tips and best practices to follow when creating SKUs.

1. Create a standard naming convention

Before doing anything else, your business should first establish a standard set of conventions for creating and assigning SKUs.

Decide what attributes you’ll want the SKU to catalog, and what order you’ll present those attributes in. Typically, top-level attributes like the type of item come first, and progressively specific identifiers (such as product name, part number, and/or model numbers) follow.

2. Make sure every SKU is unique

It is very important to ensure that every product has its own unique SKU. The point of giving every item a unique number is to distinguish each product from every other product, so having identical SKUs for two different products defeats the purpose.

If a product is ever retired or discontinued, its item number should not be reassigned to a different product. Businesses should also not simply adopt manufacturer’s SKUs or the UPC numbers — especially if you are a wholesaler, sell through B2B channels, or list products on online marketplaces such as Amazon or Walmart — as doing so may cause confusion.

3. Showcase SKUs that are alike

One of the best benefits of implementing SKUs is that doing so allows you to identify similar items and present them together, both in physical locations and on your online store.

Grouping similar SKUs not only keeps inventory organized, but could also provide quick and easy alternatives and close a sale if a customer’s desired item is sold out.

4. Add SKU basic information

When creating a SKU system, remember to record the dimensions and weight of each SKU. Many businesses tend to skip on this step, but it is necessary to accurately estimate your inventory capacity size.

5. Create an SKU management system

Creating and assigning SKUs doesn’t do much good unless you also have a SKU management system in place. SKU management systems streamline SKU tracking over time, both in physical storefronts or warehouses and for accounting purposes.

6. Implement SKU software

Implementing an inventory management system that lets you name, monitor, and track different SKUs is a game changer for inventory management.

The right software will automate much of the SKU management process, and view individual SKU levels, order histories, sales records, and shipment confirmations in detail.

You should also look for a solution that lets you set up reorder points for each SKU and bundles different SKUs together when needed.

SKU number examples

As an example, let’s say there is a small business that sells t-shirts, dresses, and shoes.

After auditing their inventory, the business decides that they want each SKU to communicate information about the following features:

  • Type of clothing (t-shirt, dress, or shoes)
  • Size
  • Color
  • Collection the item was released in (Fall, Spring, Summer, or Winter)

With this in mind, the business creates the following coding system for their SKUs:

Type of ClothingCodeSizeCodeColorCodeCollectionCode

T-Shirt

TS88RedRESpring

10

Dress

DR99BlueBLSummer

20

Shoes

SH1010GreenGRFall

30

VestVE1111YellowYWWinter

40

Using this coding system, the business can create and assign SKUs to their existing products. For instance:

ITEM: A T-shirt, size 10, in blue, released in the summer collection

SKU: TS-10-BL-20

ITEM: A dress, size 8, in green, released in the winter collection

SKU: DR-8-GR-40

Because the coding system was designed to fit the needs of the company that created it, the coding system can be modified when new items are added or when old items are deleted.

For example, if the company decides to introduce a pair of yellow shoes, they can simply add a code for the color purple to their system (such as YE or YW).

When creating SKUs, there are a few best practices to follow:

  • Try not to start SKUs with a 0, or include two lookalike characters that could easily be confused for one another (e.g. “0” and “O”, or “1” and “I”)
  • Avoid using special characters like &, %, or #.
  • Start SKUs with a letter whenever possible.

How ShipBob’s SKU management works for retailers

SKU creation and management can be time- and resource-consuming processes — but partnering with a tech-enabled 3PL like ShipBob can help you focus more on core competencies while freeing up your time.

Here are just some of the benefits of outsourcing inventory storage and order fulfillment to ShipBob.

Allows retailers to view inventory levels in real-time

ShipBob’s software allows its users to track inventory levels in real time at any of ShipBob’s fulfillment centers, so that you can access up-to-date data at any time across your distribution network.

With a more accurate understanding of inventory levels and movement, your business can more effectively forecast inventory demand and study purchasing patterns for each SKU to make better supply chain decisions.

Over time, this will help you achieve greater customer satisfaction and prevent stockouts and backorders.

“ShipBob’s analytics tool has been great to have. We can see inventory reconciliations and easily view SKU velocity, transit times, and inventory distribution recommendations.”

Pablo Gabatto, Business Operations Manager at Ample Foods

Set automatic reorder points

ShipBob software allows you to set up reorder points for every one of your SKUs so that you are automatically notified whenever an inventory item reaches its reorder threshold.

Not only does this save you the trouble of manually tracking many different SKUs, it also enables you to time replenishment perfectly across store locations so that customer demand is consistently met.

Set SKU packaging preferences

Sometimes, SKUs have specific packaging or handling needs. ShipBob’s interactive dashboard lets you add custom details to your products, including packing and shipping details.

Through Shipbob’s dashboard, you can choose whether each SKU is fragile, foldable, a poster, a book, or something else entirely. After choosing the product type, ShipBob will automatically adjust the packing process based on your preferences.

Request Fulfillment Pricing

How to find SKU number FAQs

Here are answers to the most common questions about how to find SKU numbers.

How can you find SKU numbers online?

How to Find SKU Numbers (4)

A product’s SKU number is typically listed in the product description on that product’s page within the business’s ecommerce website. However, that SKU may be for internal purposes only, and may not be useful customers looking to find the product elsewhere.

Is the SKU number the same as the product number?

How to Find SKU Numbers (5)

Despite being used interchangeably at times, SKU number and the product number are not the same thing. While SKUs are developed internally to manage inventory and are unique to them, product numbers are the manufacturer codes universal across all the retailers of the said product.

What is the best way to manage SKUs?

How to Find SKU Numbers (6)

SKU management can be both challenging and time-consuming. To save time and work, a growing ecommerce brand should consider partnering with a tech-enabled 3PL like ShipBob that allows them to focus on growth areas while still maintaining control of their inventory operations.

Is SKU management important for retailers?

How to Find SKU Numbers (7)

Yes. SKU management is important for both offline and online retailers because it gives them specific details about every item in their inventory, which can significantly improve order accuracy during the warehouse picking and packing process.

How to Find SKU Numbers (2024)

FAQs

How to search SKU numbers? ›

SKUs can be found on product labels, product descriptions on ecommerce websites, manufacturer websites, search engines, sales platform accounts, accounting software, and inventory management systems.

How do you find the total number of SKUs? ›

To calculate the number of SKUs in your inventory, you will need to consider all of the different product variations you offer. This includes variations in color, size, price, and more. The number of SKUs in your online store will be equal to the number of product variations.

How to get a SKU number for a product? ›

Here are common places where you can find SKU numbers: Product packaging: Manufacturers print the SKU number on product packaging. Look for a small label or printed number. Price tags: Retailers include SKU numbers on price tags, especially when selling in store.

How do you identify the SKU? ›

A stock keeping unit (SKU) is an alphanumeric code retailers use to identify and track a product. Retailers using SKUs will assign a unique code to each item in their inventory management software.

Is there a SKU database? ›

Stock Keeping Unit (SKU) data refers to a database that contains unique identifiers assigned to individual products in a retail or e-commerce setting. Examples of SKU data include product codes, descriptions, prices, and inventory levels.

How to choose SKU number? ›

SKU creation tips:
  1. Choose a simple, easy and logical structure.
  2. Use unique codes for each product.
  3. Avoid using letters that can be confused with numbers (e.g. O and 0)
  4. Document the SKU structure for ease of understanding.
Feb 21, 2024

What is the formula for SKU productivity? ›

Divide the number of SKUs in a range by the total number of SKUs, then multiply by 100 percent. That's your SKU ratio for each gross profit range. Next, calculate the sales ratio. Pick a period to cover, like a year, and add up the number of units sold in each gross profit range.

What is the rule for SKU? ›

A SKU needs to be 32 characters or fewer so that the same data fits in all systems. Make them unique. Don't reuse SKUs from previous seasons. Never start a SKU with a zero.

What is the pattern of SKU numbers? ›

Example SKU formats

She chooses to use a ten-digit numeric SKU format of ####-###-### . The digits, separated by hyphens, refer to brand, style, and size. For example, she uses the SKU 4225-776-3234 for pants that are brand 4225, leg style 776 (boot cut), and size 32x34 (waist and length).

What is an SKU example? ›

Examples of SKU codes

Product variation as the middle few characters (e.g., “BL” to indicate the color blue and “M” to indicate size M) Specific details such as brand and series as the last few characters (e.g., “A” to indicate brand A and “101” to indicate the series) Hyphens in between each product detail.

How to generate SKU numbers in Excel? ›

To create SKU numbers in Excel, start by setting up basic columns for product information. For example, enter the product brand in the first column and its type in the second. Then, add a third column for the SKU codes, using the "MID" function to extract specific parts of the data from the first two columns.

What does a SKU number consist of? ›

It consists of alphanumeric digits and a scannable bar code printed on a product label. The characters define a code that tracks the price, product details, manufacturer, and point-of-sale. SKUs may also be applied to intangible but billable products, such as units of repair time in an auto body shop or warranties.

How do I find my SKU? ›

Typically, SKU numbers are listed on the product's packaging — usually above the product's barcode, as seen below. While the 12-digit numeric code on the bottom is the product's UPC (Universal Product Code), the alphanumeric code at the top is the SKU number (which is different from the UPC).

How is SKU calculated? ›

Divide the number of SKUs in a range by the number of total SKUs (and multiply by 100) to get your SKU ratio for each range. Using the same gross profit ranges, note the number of units sold (in a given period of time).

How do I view SKU? ›

eCommerce Websites: SKU numbers are often displayed alongside the product description on eCommerce websites. Product Packaging and Labels: Most products feature a barcode or printed number on their packaging or labels.

Can I search by SKU number on Amazon? ›

SKUs are created by sellers to keep track of their inventory. Buyers cannot search Amazon by a seller SKU. Instead, buyers can search by ASIN – this is Amazon's unique number/code for a specific product.

Can I track a SKU number? ›

You can track inventory with SKUs by using an inventory tracking tool that integrates with your ecommerce platform and/or point-of-sale (POS) system and warehouse management system.

Can I lookup a product by serial number? ›

Once you've entered the serial number, the database will generate a report containing details such as the manufacturing date, location, model specifications, and warranty status. Some databases may even provide additional information such as repair history or recalls associated with that specific product.

Top Articles
Pumpkin Coconut Chicken Curry - Healthy Pumpkin Curry Recipe
Carnivore Cake Recipe
Jimmy Johns Delivery Hours
How to Create a Batch File in Windows? - GeeksforGeeks
Lifestyle | Stewartstown-Fawn Grove Daily Voice
Greater Keene Men's Softball
Miramar Water Utility
Who is on the FBI Most Wanted list cryptocurrency?
8776685260
Marie Temara Snapchat
Strange World Showtimes Near Harkins Metrocenter 12
Henry Ford Hospital: Ein Meisterwerk von Frida Kahlo
Craigslist Tuscarawas Pets
Magic Seaweed Pleasure Point
Chubbs Canton Il
Peraton Sso
Icy Veins Necromancer Diablo 4
Vector Driver Setup
Hsclink.health.unm.edu
Albany Want Ad Digest
13.2 The F Distribution and the F Ratio - Statistics | OpenStax
Spaghetti Models | Cyclocane
KMST ver. 1.2.178 – Tallahart & the Long Awaited Balance Patch!
Emma D'arcy Deepfake
Craigslist St. Paul
O'reilly's Eastman Georgia
Skyward Login Waxahachie
T-Zell-Leukämie mit großen granulären Lymphozyten - Altmeyers Enzyklopädie - Fachbereich Innere Medizin
Craigslist Lubbick
Walgreens On Nacogdoches And O'connor
Sotyktu Pronounce
Sealy Posturepedic Carver 11 Firm
Oldgamesshelf
Fedex Passport Locations Near Me
South Park Old Fashioned Gif
The Abduction of Heather Teague
10000 Blaulicht-Meldungen aus Baden-Württemberg | Presseportal
Harry Potter 3 123Movies
Costco Gasoline and Sam's Club Fuel Center Gas Savings - Consumer Reports
Claudia Capertoni Only Fans
My.chemeketa
Los Alamos Beach in Torremolinos: A Perfect Mediterranean Escape - Mama Málaga
Taika Waititi Birth Chart
Mudae Disable Tags
30 Day Long Range Weather for 82801 (Sheridan), Wyoming. Weather Outlook for 30 Days From Today.
Top Dog Boarding in The Hague with Best Prices on PetBacker
Comcast Business Downdetector
Victoria Maneskin Nuda
Babyrainbow Private
Samanthaschwartz Fapello
XY6020L 6-70V CNC einstellbares stabilisiertes Spannungsnetzteil Konstantspannung Konstantstrom 20A/1200W Buck-Modul Bewertungen
Baja Boats For Sale On Craigslist
Latest Posts
Article information

Author: Nicola Considine CPA

Last Updated:

Views: 6591

Rating: 4.9 / 5 (49 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Nicola Considine CPA

Birthday: 1993-02-26

Address: 3809 Clinton Inlet, East Aleisha, UT 46318-2392

Phone: +2681424145499

Job: Government Technician

Hobby: Calligraphy, Lego building, Worldbuilding, Shooting, Bird watching, Shopping, Cooking

Introduction: My name is Nicola Considine CPA, I am a determined, witty, powerful, brainy, open, smiling, proud person who loves writing and wants to share my knowledge and understanding with you.