Create Meaningful SKU Number & Barcode

2 part related question

  1. How to create a meaningful SKU number… I am not sure how generally SKU numbers are created, is it random or is it shorthand code based on the description

  2. How to generate barcode ?

A SKU or barcode could be a random string of numbers, or it could follow a code. This would be a personal preference. You could generate them in Airtable by using RECORD_ID() to make sure they’re all unique, or you could develop you’re own naming convention.

For instance if you have several categories, you could assign a number to each and construct the barcode from there. Such as "Red" = 1, "Blue" = 2, "Orange" = 3; "Small" = 1, "Medium" = 2, "Large" = 3. A “medium red” product would have a barcode of “21”.

If you want a barcode image, use one of the following:

1 Like

Thank you !!! This is exactly what I am looking for so here is my scenario

Columns I have

  • Product Category (Single Select of options)
  • Substrate (Single Select)
  • Output Quality (Single Select)
  • Size (Single Select)
  • Product Name

Product Name

To create the SKU here is what I would like to see

Product Category
if Product Category has selection of Mural, output will be MUR
if Product Category has selection of Magnets, output will be MAG

Output Quality
if Class has selection of Economy, output will be EC
if Class has selection of Deluxe, output will be DX
if Class has selection of Premium, output will be PM
if Class has selection of Platinum, output will be PT

substrate
if substrate has selection of Canvas, output will be CN
if substrate has selection of Wood, output will be WD

Size

  • if size column has selection of 08x 10, output will be 0810 (no spacing and removing the ‘x’)
  • if size column has selection of 16 x 20, output will be 1824 (no spacing and removing the ‘x’)
  • if size column has selection of 18 x 24, output will be 1824 (no spacing and removing the ‘x’)

Product Name
this will display the product name but removing all spaces between the words and capitalizing the 1st letter of each word: for example Winter Glaciers will be WinterGlaciers

Example sku output:

MUR-EC-CN-1824-WinterGlaciers

Well this could all be done in a formula like this:

SWITCH(
   {Product Category},
   "Mural", "MUR",
   "Magnets", "MAG"
) & "-" &
SWITCH(
   {Class},
   "Economy", "EC",
   "Deluxe", "DX",
   "Premium", "PM",
   "Platinum", "PT"
) & "-" &
SWITCH(
   {Substrate},
   "Canvas", "CN",
   "Wood", "WD"
) & "-" &
SUBSTITUTE({Size}, " x ", "") & "-" & 
SUBSTITUTE({Product Name}, " ", "")

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.