Variant Grid Audit

What it does

Audit explicit product option grids, missing combinations, discontinued exclusions and SKU identity conflicts.

Model and scope

products define product_id, 1–3 ordered option dimensions, exact text allowed values and excluded complete tuples. variants define unique variant_id, product_id, sku, options and active/discontinued status. The exact Cartesian grid is capped at 10000 per product and 20000 per request. Subtract exclusions before counting expected combinations. Duplicate variant IDs are invalid; duplicate option tuples and shared SKU identities are reported. A discontinued variant outside an approved exclusion remains a review item.

Try saying

Compare my color and size variants against the approved choices; show missing combinations and SKU collisions.

Check the discontinued exclusions before marking a variant missing.

Runtime and outputs

Reads supplied normalized JSON and creates result.json, report.md and rows.csv with input and output hashes. Preserve raw CSV; ask the assistant to normalize exports against the bundled input reference. Python 3.10+ standard library only; no paid data key or MochiLab backend needed. Optional explanation uses your current agent model and its ordinary service costs separately. Existing output directories are refused. Includes fictional examples and independent offline domain tests. No API/store changes, uploads, automatic tasks, notifications, legal or tax decisions.

References

• Primary reference 1 ↗
• Primary reference 2 ↗