Create Meaningful SKU Number & Barcode

[HNC]

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 ?

[Kamille_Parks]

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:

Airtable

QR Code Maker - Apps - Airtable Marketplace

Create & customize QR codes in your tables on Airtable with the QR Code Maker app.

miniExtensions for Airtable

Generate Barcode Images in Bulk on Airtable - miniExtensions for Airtable

Turn barcodes into scannable barcode images and automatically upload them as Airtable attachments. Generate them all at once instead of doing it one by one.

[HNC]

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

[Kamille_Parks]

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}, " ", "")