Product Variants 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick variants sku

Standardize Variant SKU Naming Convention Across a Collection

Rewrite every variant SKU in a collection to follow one naming pattern, mapping option values to codes without breaking existing order history.

📋 Prompt
Run in Sidekick
Standardize the SKUs for every variant in the [COLLECTION_NAME] collection to follow this pattern: [SKU_PATTERN, e.g. {vendor-code}-{product-code}-{size-code}-{color-code}].

Use these code mappings:

  Vendor codes: [VENDOR_CODE_MAP]
  Size codes: [SIZE_CODE_MAP]
  Color codes: [COLOR_CODE_MAP]


Steps:

  Generate the new SKU for every variant and show me a before/after table (old SKU -> new SKU) for the whole collection.
  Flag any new SKUs that would collide with an existing SKU elsewhere in the store, and stop those from being applied until I resolve the conflict.
  Flag any variants where an option value has no entry in the code maps above, and ask me for the missing code instead of guessing.
  Note that changing a SKU does not affect historical order records, but confirm this explicitly before applying.


After I approve the table, apply the new SKUs and give me a downloadable summary of every change made, plus a count of skipped/flagged variants.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions