wowprompt

Product variant naming and SKU code scheme for a catalogue

Designs a consistent SKU code pattern and variant naming rules for a product catalogue, then applies them to the products given. Use it when a store's codes are inconsistent, before listing on several marketplaces, or before moving to a new inventory system.

A SKU pattern with a segment table, naming rules for variants, and a table applying the scheme to each product and variant
The output this prompt produced, unedited.

The prompt

Goal

Create one SKU and variant naming scheme that stays readable, unique and stable as the catalogue grows.

Inputs

  • What the store sells: [e.g. cotton kurtas and dupattas]
  • Variant attributes in use: [e.g. colour, size, fabric, pack size]
  • Products and variants to code: [paste product names with their variants]
  • Sales channels: [own website, Amazon, Flipkart, Meesho, offline]
  • Existing codes to keep, if any: [paste or none]

Steps

  1. Choose three to five segments, such as category, style number, colour and size, in a fixed order.
  2. Set a short code list for each segment, using letters and numbers only.
  3. Write variant naming rules for titles, such as attribute order and how colours and sizes are written.
  4. Apply the scheme to every product and variant in the input.
  5. Note how to add a new colour, size or product without breaking the pattern.

Output format

  • SKU pattern, for example CAT-STYLE-CLR-SZ, with a table: | Segment | Meaning | Length | Code list |
  • Variant naming rules as a numbered list.
  • Applied table: | Product | Variant | SKU | Variant name |
  • Three lines on extending the scheme.

Check before answering

  • Every SKU in the applied table is unique.
  • No SKU uses spaces, slashes or characters that confuse spreadsheets, such as leading zeros that can drop.
  • Codes do not encode price or anything that changes over time.
  • Every SKU stays under 20 characters, so it fits common marketplace fields.
sku code formatsku naming conventionproduct variant naminginventory sku systemecommerce catalogue setupproduct code generator

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity