Practical Lens 67: Product variants need their own identity

Parent product

The shared product family that groups legitimate variants, such as one shoe model offered in several sizes and colours.

Variant

One specific purchasable selection with its own item identifier and its own price, availability, URL state and image.

Why this happens

Storefronts often display several variants on one page while feeds export one row per item. If parent and item identifiers are confused, or if the selected page state is not preserved in the URL, the image, price, availability and cart action can refer to different versions of the product.

What this usually indicates

• Several variants reuse one item ID.
• The parent SKU is submitted as if it were a purchasable item.
• A feed URL opens the page with a different variant selected.
• The image does not change with colour or configuration.
• Availability is recorded at parent level although variants differ.
• The cart receives a different item from the visible selection.

What to verify (evidence-only)

1. Choose one variant family. Start with a high-value product whose variants differ in price or stock.
2. Separate group and item IDs. Give every purchasable variant one stable item ID and use a different shared group ID.
3. Open every variant URL. Confirm the intended option is selected without another click.
4. Compare the full fact set. Check title, option, image, price, availability and structured or feed data for the same item ID.
5. Test the cart outcome. Add the visible variant and verify that the cart retains the same item, options and price.

Terminal check: find variant identity failures

Open Terminal in the folder containing variant-check.csv, paste the command and press Enter. The expected result is every duplicate item ID or failed page, feed or cart match.

python3 -c 'import csv,sys,collections; r=list(csv.DictReader(open(sys.argv[1],encoding="utf-8-sig"))); c=collections.Counter(x["item_id"] for x in r); bad=[x for x in r if c[x["item_id"]]>1 or any(x[k].strip().lower()!="yes" for k in ("page_match","feed_match","cart_match"))]; [print("{} | {} | {} | owner: {}".format(x["group_id"],x["item_id"],x["variant"],x["owner"])) for x in bad]; print("Variant failures: {}/{}".format(len(bad),len(r)))' variant-check.csv

Business meaning: any listed row can present or sell a different variant from the one the customer intended.

PowerShell check: find variant identity failures

Open PowerShell in the folder containing the same CSV, paste the commands and press Enter. The expected result is the same list and count.

$rows = Import-Csv .\variant-check.csv
$duplicates = $rows | Group-Object item_id | Where-Object Count -gt 1 | Select-Object -ExpandProperty Name
$issues = $rows | Where-Object { $duplicates -contains $_.item_id -or $_.page_match -ne 'yes' -or $_.feed_match -ne 'yes' -or $_.cart_match -ne 'yes' }
$issues | Format-Table group_id,item_id,variant,owner -AutoSize
'Variant failures: {0}/{1}' -f $issues.Count,$rows.Count

Business meaning: resolve the exact item-level mismatch before approving the family for another shopping surface.