[object Object]

← back to Dw Dead Image Recovery

exclude dead catalog lines from reconciliation

c1caf716338af3155a5c658bc110d7345731fd12 · 2026-09-01 21:58:46 -0700 · Steve Abrams

Files touched

Diff

commit c1caf716338af3155a5c658bc110d7345731fd12
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Sep 1 21:58:46 2026 -0700

    exclude dead catalog lines from reconciliation
---
 data/tk11050-item3/audit-distinct-sku-gap.sh | 5 +++--
 data/tk11050-item3/backfill-one.sh           | 4 ++++
 2 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/data/tk11050-item3/audit-distinct-sku-gap.sh b/data/tk11050-item3/audit-distinct-sku-gap.sh
index 25dcc31..2695b8a 100755
--- a/data/tk11050-item3/audit-distinct-sku-gap.sh
+++ b/data/tk11050-item3/audit-distinct-sku-gap.sh
@@ -15,8 +15,9 @@ if ! ssh -n "$KAM" "$KPSQL -v ON_ERROR_STOP=1 -c \"SELECT table_name FROM inform
 fi
 [ -s "$WORK/kam_tables.txt" ] || { echo "FATAL: Kamatera returned no catalog tables; refusing false-success." >&2; exit 2; }
 comm -12 "$WORK/mac2_tables.txt" "$WORK/kam_tables.txt" > "$WORK/both_all.txt"
-# EXCLUSIONS (per TK-11050): competitor-intel, staff-only, excluded vendor, item-2, item-4, known-exception
-SKIP='^(connie_our_catalog|connie_competitor_catalog|schumacher_catalog|fentucci_catalog|fentucci_naturals_catalog|koroseal_catalog|anna_french_catalog|rebel_walls_catalog|rebelwalls_catalog|spoonflower_catalog)$'
+# EXCLUSIONS (per TK-11050): competitor-intel, staff-only, excluded/dead vendor, item-2,
+# item-4, known exception. Armani/Casa + Carlisle confirmed dead lines by Steve 2026-09-01.
+SKIP='^(armani_casa_catalog|carlisle_catalog|connie_our_catalog|connie_competitor_catalog|schumacher_catalog|fentucci_catalog|fentucci_naturals_catalog|koroseal_catalog|anna_french_catalog|rebel_walls_catalog|rebelwalls_catalog|spoonflower_catalog)$'
 grep -vE "$SKIP" "$WORK/both_all.txt" > "$WORK/both_tables.txt"
 printf "%-32s %10s %10s %10s %10s %10s\n" table mac2_rows mac2_dsku kam_dsku KAMonly_REAL MAC2only
 printf "%-32s %10s %10s %10s %10s %10s\n" "-----" "-----" "-----" "-----" "-----" "-----"
diff --git a/data/tk11050-item3/backfill-one.sh b/data/tk11050-item3/backfill-one.sh
index 5ef57a0..8290aaf 100755
--- a/data/tk11050-item3/backfill-one.sh
+++ b/data/tk11050-item3/backfill-one.sh
@@ -6,6 +6,10 @@ set -euo pipefail
 T="${1:?usage: backfill-one.sh <table>}"
 case "$T" in (*[!a-z0-9_]*|''|*_catalog_prebackfill_bak) echo "Invalid catalog table: $T" >&2; exit 2;; esac
 case "$T" in (*_catalog) :;; (*) echo "Refusing non-catalog table: $T" >&2; exit 2;; esac
+case "$T" in
+  armani_casa_catalog|carlisle_catalog)
+    echo "Refusing dead-line catalog: $T (Steve, 2026-09-01)" >&2; exit 2;;
+esac
 KAM="root@45.61.58.125"
 KPSQL="psql -h 127.0.0.1 -U dw_admin -d dw_unified -tA"
 WORK=/tmp/tk11050-item3

← dc851eb harden catalog gap audit and bounded backfill  ·  back to Dw Dead Image Recovery  ·  allow Carlisle staging while keeping it offline 94c41e5 →