← back to Dw Add Sellable Variant Tk10902

tk10875-codex/README.md

25 lines

# TK-10875 — independent Codex classification

This is a read-only classifier and dry-run pilot for the ACTIVE products in the local
`dw_unified.shopify_products` mirror where `has_product_variant IS NOT TRUE`.

Run:

```sh
node analyze-readonly.mjs
```

Safety properties:

- every SQL call runs in a single explicit `READ ONLY` transaction;
- only `SELECT` or `WITH` statements are accepted by the runner;
- staging matches are exact (`mfr_sku`, `dw_sku`, or Shopify product id), never fuzzy;
- ambiguous multi-row catalog matches are counted but excluded from the pilot;
- Coordonné `price_retail` remains retail evidence only, not cost;
- the script writes only `classification.json` and `pilot-sample.json` beside itself;
- there is no activation flag, mutation query, Shopify request, or production-write path.

`classification.json` contains fleet buckets and aggregate staging coverage.
`pilot-sample.json` contains at most ten unique exact matches per tested vendor, labeled
either `DRY_RUN_ELIGIBLE_COST_INPUT` or `HOLD_COST_SEMANTICS`.