Auto-generate SKUs with Mechanic.

Mechanic is an automation and development platform for Shopify. :)

Auto-generate SKUs

by Isaac Bowen (team@usemechanic.com)

Save time by letting this task keep your variant SKUs up to date, generating them based on your product handle, and the initials of each variant option. Useful for large catalogs, or for anyone who has a consistent SKU format. Like all tasks, this one is easy to update for your business's needs - get in touch if you need a hand.

Runs when a product is created and when a product is updated. Configuration includes product options to keep unabbreviated.

15-day free trial – unlimited tasks

Documentation

This task automatically maintains SKUs for your product variants, by combining these elements and joining them with a dash:

  1. The last portion of the product handle (e.g. 503, if your product is available at myshop.com/products/stylish-shirt-503)
  2. The capital letters of the variant's first option (e.g. H if the option is Heather gray, or HG if the option is Heather Gray)
  3. The capital letters of the variant's second option, if there is one
  4. The capital letters of the variant's third option, if there is one

(To use the product option's full value, instead of abbreviating it, add the option name to the "Product options to keep unabbreviated" list.)

To illustrate, a shirt available at myshop.com/products/stylish-shirt-503, with options for size and color, might have these SKUs auto-generated:

  • Medium, Black: 503-M-B
  • XL, Heather gray: 503-XL-H
  • Small, Red: 503-S-R

To update your product handle, so as to control the first portion of generated SKUs, open the product in the Shopify admin, scroll to the bottom of the page, click "Edit website SEO", and update the "URL and handle" field to taste. :)

Developer details

Mechanic is designed to benefit everybody: merchants, customers, developers, agencies, Gurus, everybody.

That’s why we make it easy to configure automation without code, why we make it easy to tweak the underlying code once tasks are installed, and why we publish it all here for everyone to learn from.

Events
when a product is created (shopify/products/create)
when a product is updated (shopify/products/update)
Options
product options to keep unabbreviated (array)
Script
{% if event.preview %}
  {% action "shopify" %}
    [
      "update",
      ["variant", 1234567890],
      {
        "sku": "503-XL-H"
      }
    ]
  {% endaction %}
{% elsif product.variants.size == 1 %}
  {"log": "The product only has one variant, and therefore has no product options from which a SKU can be generated; skipping update"}
{% else %}
  {% assign all_caps = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" %}

  {% assign sku_base = product.handle | split: "-" | last | upcase %}

  {% for variant in product.variants %}
    {% assign variant_sku_generated = sku_base %}

    {% assign variant_options = array %}
    {% assign variant_options[0] = variant.option1 %}
    {% assign variant_options[1] = variant.option2 %}
    {% assign variant_options[2] = variant.option3 %}

    {% assign variant_option_names = product.options | map: "name" %}

    {% for variant_option in variant_options %}
      {% if variant_option == blank %}
        {% continue %}
      {% endif %}

      {% if options.product_options_to_keep_unabbreviated__array contains variant_option_names[forloop.index0] %}
        {% assign variant_sku_generated = variant_sku_generated | append: "-" | append: variant_option %}
      {% else %}
        {% assign variant_option_abbreviation = "" %}
        {% assign variant_option_characters = variant_option | split: "" %}
        {% for variant_option_character in variant_option_characters %}
          {% if all_caps contains variant_option_character %}
            {% assign variant_option_abbreviation = variant_option_abbreviation | append: variant_option_character %}
          {% endif %}
        {% endfor %}

        {% if variant_option_abbreviation == blank %}
          {% assign variant_option_abbreviation = variant_option_characters[0] | upcase %}
        {% endif %}

        {% assign variant_sku_generated = variant_sku_generated | append: "-" | append: variant_option_abbreviation %}
      {% endif %}
    {% endfor %}

    {% if variant_sku_generated != variant.sku %}
      {% action "shopify" %}
        [
          "update",
          ["variant", {{ variant.id | json }}],
          {
            "sku": {{ variant_sku_generated | json }}
          }
        ]
      {% endaction %}
    {% endif %}
  {% endfor %}
{% endif %}
Mechanic tasks are written in Liquid, which makes them easy to write and easy to modify. Learn more about our platform.