TK-10877: feed-pricing staging tables (wp+fabric, trade+retail, distinct from legacy catalogs)

5516c54178e23cd81b769056dd3f54f366726371 · 2026-08-26 09:34:36 -0700 · Steve Abrams

Files touched

A scripts/create_feed_pricing_tables.sql

Diff

commit 5516c54178e23cd81b769056dd3f54f366726371
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Aug 26 09:34:36 2026 -0700

    TK-10877: feed-pricing staging tables (wp+fabric, trade+retail, distinct from legacy catalogs)
---
 scripts/create_feed_pricing_tables.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/scripts/create_feed_pricing_tables.sql b/scripts/create_feed_pricing_tables.sql
new file mode 100644
index 0000000..a9e52c3
--- /dev/null
+++ b/scripts/create_feed_pricing_tables.sql
@@ -0,0 +1,22 @@
+-- TK-10877: dedicated feed-pricing staging tables (full wp+fabric universe from the .design feeds).
+-- One row per priceable colorway base code. Kept DISTINCT from the wallpaper-heavy legacy *_catalog tables.
+-- trade_usd = ssp_usd/2 (verified invariant); retail_usd = trade_usd/0.65/0.85. NULL price = feed miss (never fabricated).
+CREATE TABLE IF NOT EXISTS sanderson_feed_pricing (
+  base_code    text PRIMARY KEY,
+  mfr_sku      text,
+  product_type text,                 -- 'wallcovering' | 'fabric'
+  pattern      text,
+  color        text,
+  collection   text,
+  width        text,
+  length       text,
+  ssp_usd      numeric,
+  trade_usd    numeric,
+  retail_usd   numeric,
+  image        text,
+  harvested_at timestamptz DEFAULT now()
+);
+CREATE TABLE IF NOT EXISTS harlequin_feed_pricing (LIKE sanderson_feed_pricing INCLUDING ALL);
+CREATE TABLE IF NOT EXISTS zoffany_feed_pricing   (LIKE sanderson_feed_pricing INCLUDING ALL);
+CREATE TABLE IF NOT EXISTS scion_feed_pricing     (LIKE sanderson_feed_pricing INCLUDING ALL);
+CREATE TABLE IF NOT EXISTS morris_feed_pricing    (LIKE sanderson_feed_pricing INCLUDING ALL);

← 004cd21 TK-10877: generalized SDG feed harvester (full wp+fabric enu · back to Sanderson Onboard · auto-data-snapshot: 2026-08-26T09:38:32 (9 data files) — pil e99ff7c →