In this article:

SKU Generator in Google Sheets [2024 Update]

How to Make an SKU Generator in Google Sheets

1. Copy The Lido SKU Generator Sample Sheet

Copy the Lido SKU Generator Template here. A new tab or window will open, asking you to copy the template. Click Make a copy.

SKU generator google sheets

The SKU Generator Template by Lido has three sheets. The first sheet contains the instructions on using it. The second sheet is for the categories to be used in creating SKUs. The third sheet is for listing the items and generating the SKUs themselves. 

google sheets SKU generator

2. List Down the Categories for Generating SKUs

Click the Categories tab. You will see the following sheet:

SKU generator in google sheets‍

Row 2 contains checkboxes. To include a category, tick the checkbox above it. For example, to include CATEGORY 1 in the SKU, we tick the checkbox in its column.

Tick checkbox to Enable category in SKU generator

After selecting it, we add the category name in the cell below the checkbox. 

Input category name for sku generator in google sheets

After adding the category name, we then list the category options under it and their corresponding codes on the side.

Input sku category options with their code in google sheets

We repeat this for the other categories we set. 

The sheet can accommodate up to six categories and twenty options each. For our example, we have a clothes shop and we want to generate SKU numbers for the items. The selected categories and their corresponding options are

Brand: Peace Mankind, Quizmaster

Type: T-Shirt, V-Neck

Color: White, Black, Brown, Green, Orange, Blue

Design: Orchid, Oak, Sea, Mountains

Size: Small, Medium, Large, Extra Large

And their corresponding codes  are assigned in the columns to their right. 

Sku generator categories in google sheets

3. Add the Items and Set Their Categories

After setting the categories, we can now add the items and set their categories. Click the Items sheet tab. You will get the following interface. 

how to make an SKU generator in google sheets

Input the items in the first column starting from Row 2. 

Items added to sku generator in google sheets

Afterwards, select the categories for each of the items listed by selecting them from the drop-down lists. 

Sku generated in google sheets after input of item categories

As you select the categories, you will see the SKU being generated real-time. Once you finish selecting the categories, you can now copy the generated SKUs on the last column.


How to Change the Format of the SKU Generator?

The formula for generating the SKU in the template is


This generates a SKU where the codes form a continuous string:


You can add dashes between each part of the code to make it more readable. Use this formula:


The resulting SKU is


Finally, if you don’t want numbers to be automatically generated as part of the SKU, use either of the two formulas:

With dashes


Without dashes


To customize the formula, check our tutorials on CONCATENATE and TEXT below:

CONCATENATE Google Sheets: The Ultimate Guide [2023]

How to Convert Numbers to Strings in Google Sheets -

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started