How do I create SKUs?

This article talks about the importance of SKUs and how to create them so that you can price your products and start trading.

Setting up SKUs is an important step as a Convictional user. A SKU used to stand for “shelf keeping unit” and it meant a unique product that lined the shelves in a retail store. Today it means a unique code that represents a variation of a product.

What Is A SKU

If you sell products that vary in size, color and shape, each one will have a SKU attached to it that represents which one it is. Similar to a product code, it’s a way to identify the variation of the product.

When it comes to inventory and pricing systems, the SKU is used to determine what price to set and how much inventory is left in stock. Convictional uses SKUs for both these reasons, so having SKUs setup is important.

How To Pick SKUs

If you don’t have SKUs for your products yet, it may be daunting to try and come up with unique codes for each one. The shortcut that most people use is to have a part that represents the product, and then add a suffix for each product option. So it ends up looking like this: code-size-color.

Example: Picking SKUs

Let’s do an example:

  • We have two products, a Long Sleeve Shirt and a Short Sleeve Shirt.

  • We need a way to tell our customers how much we have in stock and how much we charge for each.

  • Each shirt comes in a few sizes (Small, Medium and Large) and colors (Black and White).

  • In total, there are 12 different SKUs (one for each product, size and color)

Let’s give each one a code. Say, “long” and “short”. Now, let’s add a suffix for size and color. Usually people use dashes rather than spaces to separate the components of the SKU. So when you put it all together, it looks like this:

  • short-small-black

  • short-small-white

  • short-medium-black

  • short-medium-white

  • short-large-black

  • short-large-white

  • long-small-black

  • long-small-white

  • long-medium-black

  • long-medium-white

  • long-large-black

  • long-large-white

People used to try and make their SKUs as short as possible (ie. “lng-lg-blk”) but most systems in today’s world can handle longer SKU names, and it makes it way easier to tell what product they represent if you use vowels and provide as much context around the SKU as possible.

Setting Up SKUs

If you already have SKUs, or once you have chosen what they will be, the next step is to attach them to products. If you are using Convictional directly to manage products, there is an easy way to do this in the admin. Click on Products > The product you want and then enter a SKU in the “Sku” field under variants.

If you are uploading products, there is a field in the CSV template in our Product CSV Uploads guide that allows you to enter the SKU. This will ensure that your products successfully upload with the right SKU and pricing/inventory attached to them. If you have any questions about the impact of this, contact support.

If you are using a platform to sync your products to Convictional, we recommend that you setup SKUs in that platform. Shopify, for example, has a similar field for setting up the SKU for each of your products. You can even bulk update them, so it’s pretty easy to do once you decide what you want to use.

How We Use SKUs

Convictional uses SKUs in three important ways: it’s how we tell products apart from each other, it’s how we keep your customers or suppliers in sync about pricing, and it’s how we update inventory in (most) platforms.

The SKU you use on a product has to match the one you use on your price list. This way, we can ensure that a particular trading partner only has access to SKUs you want them to have access to. Likewise, we can make sure they know what you have in stock, and finally that they (or their customer) pay the right amount for the product. Without SKUs, we have to try and figure out which products match which prices and there isn’t a good way to do it. Product descriptions, titles and other data tend to change over time, but SKUs are forever.


  • SKUs are really important for syncing pricing and inventory

  • We need SKUs in order to help with integrations

  • SKUs need to be the same on your price lists and in your products

  • We can help you create SKUs if you don’t have any

  • We can help you make sure the SKUs match up if you do have them setup already