← back to Dw Dead Image Recovery
allow Carlisle staging while keeping it offline
94c41e55ed2666a7bb6393de9a5aae80777c12fc · 2026-09-01 22:01:23 -0700 · Steve Abrams
Files touched
M data/tk11050-item3/audit-distinct-sku-gap.shM data/tk11050-item3/backfill-one.sh
Diff
commit 94c41e55ed2666a7bb6393de9a5aae80777c12fc
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Tue Sep 1 22:01:23 2026 -0700
allow Carlisle staging while keeping it offline
---
data/tk11050-item3/audit-distinct-sku-gap.sh | 5 +++--
data/tk11050-item3/backfill-one.sh | 6 ++++--
2 files changed, 7 insertions(+), 4 deletions(-)
diff --git a/data/tk11050-item3/audit-distinct-sku-gap.sh b/data/tk11050-item3/audit-distinct-sku-gap.sh
index 2695b8a..6eb7a95 100755
--- a/data/tk11050-item3/audit-distinct-sku-gap.sh
+++ b/data/tk11050-item3/audit-distinct-sku-gap.sh
@@ -16,8 +16,9 @@ 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/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)$'
+# item-4, known exception. Armani/Casa confirmed excluded by Steve 2026-09-01. Carlisle may be
+# crawled/backfilled to staging but must stay offline (no Shopify onboarding/publish).
+SKIP='^(armani_casa_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 8290aaf..288529c 100755
--- a/data/tk11050-item3/backfill-one.sh
+++ b/data/tk11050-item3/backfill-one.sh
@@ -7,9 +7,11 @@ 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;;
+ armani_casa_catalog)
+ echo "Refusing excluded catalog: $T (Steve, 2026-09-01)" >&2; exit 2;;
esac
+# Carlisle is staging/crawl-only by Steve directive (2026-09-01). This loader writes only the
+# local catalog table; it must never be composed with Shopify onboarding or publish actions.
KAM="root@45.61.58.125"
KPSQL="psql -h 127.0.0.1 -U dw_admin -d dw_unified -tA"
WORK=/tmp/tk11050-item3
← c1caf71 exclude dead catalog lines from reconciliation
·
back to Dw Dead Image Recovery
·
TK-11048: verify Versa dead-image recovery (13 negative-case 10b13e4 →