`thibaut-mfr-fix/BACKLOG.md`

35 lines
# Thibaut mfr-fix — BACKLOG (needs manual / sourced pattern names)

## A) Titles that still carry the SKU but can't be auto-fixed (      10)
No real Thibaut pattern name available — stripping the SKU would leave a color-only title.
Need the real pattern name sourced from Thibaut's catalog, then rebuild + de-SKU.

| product_id | mfr | current title |
|---|---|---|
| 1244068 | BELIZA | Beliza \| Thibaut |
| 1244067 | IPANEMA | Ipanema \| Thibaut |
| 1244069 | LANDRY | Landry \| Thibaut |
| 81496 | T64167 | T64167 Beige \| Thibaut |
| 81497 | T64178 | T64178 Yellow and Grey \| Thibaut |
| 82167 | T7617 | T7617 Aqua on Metallic \| Thibaut |
| 82168 | T7620 | T7620 Beige \| Thibaut |
| 82255 | T8605 | T8605 Pastel \| Thibaut |
| 82254 | T8610 | T8610 Cream \| Thibaut |
| 1244066 | TAMARAC | Tamarac \| Thibaut |

## B) ✅ DONE 2026-06-12 — Junk parenthetical tags stripped (160/160, 0 failed)
_Original note:_ ~160 active Thibaut products
Tags contain a garbage entry like `Thibaut Taluk Sisal(T41170)` (SKU embedded in a parenthetical name).
The clean mfr token has now been added alongside; these junk tags should be stripped in a follow-up pass.

## C) ⚠️ Jobs are in the WRONG queue DB — re-enqueue needed (2026-06-11)
The 1,096 jobs (1,027 tags + 69 titles) were enqueued into **Mac2 `dw_unified.shopify_api_queue`**, but the
`shopify-queue-worker` on Kamatera reads a **different** queue DB — proven: it processes `arte-title-rebuild`
jobs (ids ~873157) that do NOT exist in Mac2's `dw_unified`, and writes no completions back to Mac2.
**They will NOT drain.** The bidirectional replication does not carry this table to the worker's node.

**Next session:** find the worker's DB via `/root/DW-Agents/shopify-queue-worker/.env` `DB_URL`, then
regenerate the inserts from `thibaut_mfr_fix_staging` (lives on Mac2) against that DB. Worker is now
online + `pm2 save`d. Separately: `arte-title-rebuild` jobs are erroring `Product does not exist` on the
worker's DB (pre-existing stale-ID issue, not ours).