`SKU-ASSIGNMENT-NOTE.md`

24 lines
# Wolf Gordon SKU assignment — 2026-06-19

## What ran (SAFE, LOCAL, REVERSIBLE)
- `assign-skus.js --apply` assigned sequential DW SKUs to the 106
  `wolf_gordon_catalog` rows that had `dw_sku IS NULL`.
- Range assigned: **DWWG-535378 .. DWWG-535483** (continued from prior MAX 535377).
- Ordered by `id ASC` (deterministic, re-runnable).
- Existing dw_skus were REUSED, never renumbered (only NULL rows touched).
- Ran inside a transaction with a post-write duplicate-SKU guard.

## Final state of wolf_gordon_catalog.dw_sku
- 5483 rows, ALL with a conforming `DWWG-<seq>` SKU.
- min 530001, max 535483, 0 NULL, 0 non-conforming, 0 duplicates.

## Hard rule honored
Every DW SKU = `DWWG-<sequential>`. No manufacturer code embedded. No new
ad-hoc SKU format. Existing series + number reused where present.

## NOT done here (Steve-gated)
- No write to shopify_products or live Shopify.
- Legacy 1,068 Shopify SKUs (DWWG-AD10336 etc.) still on the OLD embedded
  scheme — migrating those is a destructive prod write awaiting sign-off.
- See reconcile.js for the legacy<->catalog dry-run reconciliation.