Auto-Generate SKUs for New Shopify Products

4 min setup
No coding required
Runs automatically

Products added without SKUs make inventory, fulfillment and reporting harder. This workflow fills in a SKU for every variant of a new product that doesn't have one, built from a prefix you choose, the product type and the variant's options, so every item is trackable from day one.

Shopify logo icon
A product is added to Shopify
Go through each of the product's variants
Skip variants that already have a SKU
Shopify logo icon
Save the generated SKU on the variant in Shopify

How it works

4 steps to give every new product variant a consistent SKU without typing them

Shopify logo icon

A product is added to Shopify

App connector: Shopify • Time to complete: 1 minute

Runs when a new product is created.

Go through each of the product's variants

App connector: Loop • Time to complete: 1 minute

Loop over the new product's variants.

Skip variants that already have a SKU

App connector: Filter • Time to complete: 1 minute

Continue only when the variant's SKU is blank.

Shopify logo icon

Save the generated SKU on the variant in Shopify

App connector: Shopify • Time to complete: 1 minute

Set the variant's SKU to a pattern such as PREFIX-PRODUCTTYPE-OPTION1-OPTION2-last 4 digits of the variant ID, uppercased with spaces replaced by dashes.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to give every new product variant a consistent SKU without typing them

Get setup in 4 minutes.

Use this template →

FAQs

Will this overwrite SKUs I already entered?

No. The filter skips any variant that already has a SKU.

Can I change the SKU format?

Yes. Edit the pattern in the Update Product Variant step, for example to use the vendor instead of the product type.

Does it work for products created by an import?

Yes. Any product created in Shopify, whether by hand, CSV or another app, triggers it.

Personalize this template

Customize this workflow even further:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

give every new product variant a consistent SKU without typing them

4 min setup • Fully supported if you need help