[object Object]

← back to Designer Wallcoverings

China Seas reconcile (DTD-A): source china_seas_catalog 106 Commercial Wallcovering -> Wallcovering; local mirror 24 small-line -> Fabric; backups + rollback

4af735f68ee4f5bab3a414615d033c3747571827 · 2026-06-30 09:36:50 -0700 · Steve Abrams

Files touched

Diff

commit 4af735f68ee4f5bab3a414615d033c3747571827
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 30 09:36:50 2026 -0700

    China Seas reconcile (DTD-A): source china_seas_catalog 106 Commercial Wallcovering -> Wallcovering; local mirror 24 small-line -> Fabric; backups + rollback
---
 ...seas_commercial_wc_before_20260630T163348Z.json |  1 +
 .../mirror_smallline_before_20260630T163603Z.json  |  1 +
 .../fix-china-seas-product-type.sql                | 33 ++++++++++++++++++++++
 .../fix-mirror-smallline-type.sql                  | 28 ++++++++++++++++++
 .../rollback-china-seas-product-type.sql           | 16 +++++++++++
 5 files changed, 79 insertions(+)

diff --git a/shopify/scripts/reconcile/china-seas-type-fix/backups/china_seas_commercial_wc_before_20260630T163348Z.json b/shopify/scripts/reconcile/china-seas-type-fix/backups/china_seas_commercial_wc_before_20260630T163348Z.json
new file mode 100644
index 00000000..0ce8185c
--- /dev/null
+++ b/shopify/scripts/reconcile/china-seas-type-fix/backups/china_seas_commercial_wc_before_20260630T163348Z.json
@@ -0,0 +1 @@
+[{"id":1033,"mfr_sku":"712121","pattern_name":"Capri Black_on_Off_White Screen Printed Wallcovering","color_name":"Beige","dw_sku":"DWCW-712146","shopify_product_id":"gid://shopify/Product/6604491358259","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.128104+00:00"}, {"id":1034,"mfr_sku":"712221","pattern_name":"Capri Coral_on_Off_White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-712246","shopify_product_id":"gid://shopify/Product/6604491391027","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.12887+00:00"}, {"id":1035,"mfr_sku":"712321","pattern_name":"Capri Gold_Metallic_on_Off_White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-712346","shopify_product_id":"gid://shopify/Product/6604491423795","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.129663+00:00"}, {"id":1036,"mfr_sku":"712421","pattern_name":"Capri Soft_Pink_on_Off_White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-712446","shopify_product_id":"gid://shopify/Product/6604491456563","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.13059+00:00"}, {"id":1037,"mfr_sku":"712521","pattern_name":"Capri Turquoise_on_Off_White Screen Printed Wallcovering","color_name":"Beige","dw_sku":"DWCW-712546","shopify_product_id":"gid://shopify/Product/6604491489331","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.131384+00:00"}, {"id":1239,"mfr_sku":"733621","pattern_name":"Island Ikat Gray on White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-733646","shopify_product_id":"gid://shopify/Product/6604499419187","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.233411+00:00"}, {"id":1240,"mfr_sku":"733721","pattern_name":"Island Ikat Pale Aqua on White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-733746","shopify_product_id":"gid://shopify/Product/6604499451955","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.234071+00:00"}, {"id":1241,"mfr_sku":"733821","pattern_name":"Island Ikat Palm Green on White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-733846","shopify_product_id":"gid://shopify/Product/6604499484723","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.234768+00:00"}, {"id":1242,"mfr_sku":"733921","pattern_name":"Island Ikat Pistachio on White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-733946","shopify_product_id":"gid://shopify/Product/6604499517491","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.235408+00:00"}, {"id":1243,"mfr_sku":"734021","pattern_name":"Island Ikat Zibby Blue on White Screen Printed Wallcovering","color_name":"Powder Blue","dw_sku":"DWCW-734046","shopify_product_id":"gid://shopify/Product/6604499583027","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.236134+00:00"}, {"id":1311,"mfr_sku":"740821","pattern_name":"Kediri Batik Navy Charcoal Gray on Off White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-740846","shopify_product_id":"gid://shopify/Product/6604503973939","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.34615+00:00"}, {"id":1358,"mfr_sku":"745521","pattern_name":"Macoco II Turquoise on White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-745546","shopify_product_id":"gid://shopify/Product/6604505677875","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.369803+00:00"}, {"id":1359,"mfr_sku":"745621","pattern_name":"Macoco Reverse wallcovering Black on Almost White Screen Printed Wallcovering","color_name":"Black","dw_sku":"DWCW-745646","shopify_product_id":"gid://shopify/Product/6604505710643","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.370669+00:00"}, {"id":1363,"mfr_sku":"746021","pattern_name":"Magic Garden Reverse Gray on Off White Screen Printed Wallcovering","color_name":"Gray","dw_sku":"DWCW-746046","shopify_product_id":"gid://shopify/Product/6604505841715","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.372792+00:00"}, {"id":1372,"mfr_sku":"746921","pattern_name":"Maze Navy on White Patent Vinyl Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-746946","shopify_product_id":"gid://shopify/Product/6604506169395","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.373452+00:00"}, {"id":1373,"mfr_sku":"747021","pattern_name":"Maze Reverse Two Color Light Orange New Shrimp Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-747046","shopify_product_id":"gid://shopify/Product/6604506202163","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.374097+00:00"}, {"id":1374,"mfr_sku":"747121","pattern_name":"Maze Reverse Two Color Lilac Purple Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-747146","shopify_product_id":"gid://shopify/Product/6604506234931","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.374872+00:00"}, {"id":1375,"mfr_sku":"747221","pattern_name":"Maze Reverse Two Color Turquoise Dark Turquoise Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-747246","shopify_product_id":"gid://shopify/Product/6604506267699","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.375862+00:00"}, {"id":1376,"mfr_sku":"747321","pattern_name":"Maze Salmon on Almost White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-747346","shopify_product_id":"gid://shopify/Product/6604506300467","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.376636+00:00"}, {"id":1377,"mfr_sku":"747421","pattern_name":"Maze White on White Patent Vinyl Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-747446","shopify_product_id":"gid://shopify/Product/6604506333235","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.377498+00:00"}, {"id":1414,"mfr_sku":"751121","pattern_name":"Nairobi Beige on Almost White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-751146","shopify_product_id":"gid://shopify/Product/6604507643955","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.392286+00:00"}, {"id":1415,"mfr_sku":"751221","pattern_name":"Nairobi French Green on Almost White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-751246","shopify_product_id":"gid://shopify/Product/6604507676723","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.392937+00:00"}, {"id":1416,"mfr_sku":"751321","pattern_name":"Nairobi Pale Gray on Almost White Screen Printed Wallcovering","color_name":"Light Gray","dw_sku":"DWCW-751346","shopify_product_id":"gid://shopify/Product/6604507709491","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.393569+00:00"}, {"id":1417,"mfr_sku":"751421","pattern_name":"Nairobi Pale Lavender on Almost White Screen Printed Wallcovering","color_name":"Lavender","dw_sku":"DWCW-751446","shopify_product_id":"gid://shopify/Product/6604507742259","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.39411+00:00"}, {"id":1418,"mfr_sku":"751521","pattern_name":"Nairobi Powder Blue on Almost White Screen Printed Wallcovering","color_name":"Periwinkle","dw_sku":"DWCH-510609","shopify_product_id":"gid://shopify/Product/6604507807795","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.394696+00:00"}, {"id":1419,"mfr_sku":"751621","pattern_name":"Nairobi Red on Almost White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCH-510610","shopify_product_id":"gid://shopify/Product/6604507840563","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.395185+00:00"}, {"id":1420,"mfr_sku":"751721","pattern_name":"Nairobi Teal on Almost White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCH-510611","shopify_product_id":"gid://shopify/Product/6604507873331","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.395867+00:00"}, {"id":1421,"mfr_sku":"751821","pattern_name":"Nairobi White on Almost White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCH-510612","shopify_product_id":"gid://shopify/Product/6604507906099","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.396698+00:00"}, {"id":1489,"mfr_sku":"758721","pattern_name":"Peacock Background Batik Jungle Green on Off White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-758746","shopify_product_id":"gid://shopify/Product/6604510298163","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1573,"mfr_sku":"767121","pattern_name":"Raffles New Blue on White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-767146","shopify_product_id":"gid://shopify/Product/6604513214515","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.491911+00:00"}, {"id":1702,"mfr_sku":"780621","pattern_name":"Terrace New Apple on Off Screen Printed Wallcovering","color_name":"Cream","dw_sku":"DWCW-780646","shopify_product_id":"gid://shopify/Product/6604517703731","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.560271+00:00"}, {"id":1714,"mfr_sku":"781821","pattern_name":"Twigs Soft Green Dark Green on Off White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCW-781846","shopify_product_id":"gid://shopify/Product/6604518096947","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.567804+00:00"}, {"id":1743,"mfr_sku":"784721","pattern_name":"Victoria French Green on Off White Screen Printed Wallcovering","color_name":"Cream","dw_sku":"DWCW-784746","shopify_product_id":"gid://shopify/Product/6604519079987","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.573332+00:00"}, {"id":1753,"mfr_sku":"785721","pattern_name":"Ziggurat Jungle Green on Off White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-785746","shopify_product_id":"gid://shopify/Product/6604519440435","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.578233+00:00"}, {"id":1754,"mfr_sku":"785821","pattern_name":"Ziggurat Lavender on White Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCW-785846","shopify_product_id":"gid://shopify/Product/6604519473203","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.579078+00:00"}, {"id":1789,"mfr_sku":"926421","pattern_name":"Hulai Batik Green Yellow on White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-926446","shopify_product_id":"gid://shopify/Product/6605285359667","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1790,"mfr_sku":"927021","pattern_name":"II Blue Ikat Grayish Windsor on White Screen Printed Wallcovering","color_name":"Powder Blue","dw_sku":"DWCS-927046","shopify_product_id":"gid://shopify/Product/6605285425203","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1794,"mfr_sku":"936221","pattern_name":"Kediri Batik Pale Putty Beige Teal Blue Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-936246","shopify_product_id":"gid://shopify/Product/6605285556275","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-03-20T20:10:17.889358+00:00"}, {"id":1795,"mfr_sku":"937721","pattern_name":"Kyoto Two Colors Soft French Green Windsor Blue Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-937746","shopify_product_id":"gid://shopify/Product/6605285621811","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1796,"mfr_sku":"937821","pattern_name":"Lila Stripe Blue on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-937846","shopify_product_id":"gid://shopify/Product/6605285654579","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1797,"mfr_sku":"937921","pattern_name":"Lila Stripe Navy on White Linen Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCS-937946","shopify_product_id":"gid://shopify/Product/6605285687347","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1798,"mfr_sku":"938021","pattern_name":"Lila Stripe Soft Chartreuse on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-938046","shopify_product_id":"gid://shopify/Product/6605285720115","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1799,"mfr_sku":"938121","pattern_name":"Lila Stripe Soft Gray on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-938146","shopify_product_id":"gid://shopify/Product/6605285752883","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1800,"mfr_sku":"938221","pattern_name":"Lila Stripe Soft Lavender on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-938246","shopify_product_id":"gid://shopify/Product/6605285818419","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1801,"mfr_sku":"938321","pattern_name":"Lila Stripe Soft Pink on White Linen Screen Printed Wallcovering","color_name":"Beige","dw_sku":"DWCS-938346","shopify_product_id":"gid://shopify/Product/6605285916723","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1802,"mfr_sku":"940921","pattern_name":"Lulu Stripe Aqua on White Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-940946","shopify_product_id":"gid://shopify/Product/6605285949491","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1803,"mfr_sku":"941021","pattern_name":"Lulu Stripe Blue on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-941046","shopify_product_id":"gid://shopify/Product/6605285982259","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1804,"mfr_sku":"941121","pattern_name":"Lulu Stripe Navy on White Linen Screen Printed Wallcovering","color_name":"White","dw_sku":"DWCS-941146","shopify_product_id":"gid://shopify/Product/6605286047795","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1805,"mfr_sku":"941221","pattern_name":"Lulu Stripe Soft Chartreuse on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-941246","shopify_product_id":"gid://shopify/Product/6605286080563","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1806,"mfr_sku":"941321","pattern_name":"Lulu Stripe Soft Gray on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-941346","shopify_product_id":"gid://shopify/Product/6605286113331","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1807,"mfr_sku":"941421","pattern_name":"Lulu Stripe Soft Lavender on White Linen Screen Printed Wallcovering","color_name":"Off-White","dw_sku":"DWCS-941446","shopify_product_id":"gid://shopify/Product/6605286146099","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":1808,"mfr_sku":"941521","pattern_name":"Lulu Stripe Soft Pink on White Linen Screen Printed Wallcovering","color_name":"Beige","dw_sku":"DWCS-941546","shopify_product_id":"gid://shopify/Product/6605286178867","product_type":"Commercial Wallcovering","is_live":true,"updated_at":"2026-06-26T14:52:50.418141+00:00"}, {"id":3829,"mfr_sku":"301963W","pattern_name":"Paradise Garden","color_name":"Rose on Brown","dw_sku":"DWCH-510192","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}, {"id":3830,"mfr_sku":"301961W","pattern_name":"Paradise Garden","color_name":"Rose on Chartreuse","dw_sku":"DWCH-510191","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}, {"id":3831,"mfr_sku":"301960WCSTB","pattern_name":"Paradise Garden","color_name":"Rose on Turquoise","dw_sku":"DWCH-510190","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}, {"id":3832,"mfr_sku":"301965W","pattern_name":"Paradise Garden","color_name":"Turquoise on Brown","dw_sku":"DWCH-510193","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}, {"id":3833,"mfr_sku":"301967W","pattern_name":"Paradise Garden","color_name":"Turquoise on Pistachio","dw_sku":"DWCH-510194","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}, {"id":3837,"mfr_sku":"302400W","pattern_name":"Vanderpoel Stripe","color_name":"Black Sienna on Off White","dw_sku":"DWCH-510242","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}, {"id":3847,"mfr_sku":"302308WP","pattern_name":"Terrace","color_name":"New Apple on Off White","dw_sku":"DWCH-510240","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:54.432272+00:00"}, {"id":3955,"mfr_sku":"2510-0BWP","pattern_name":"Maze","color_name":"Beige on Almost White","dw_sku":"DWCH-510147","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.810283+00:00"}, {"id":3956,"mfr_sku":"2510-14WP","pattern_name":"Maze","color_name":"Yellow on Almost White","dw_sku":"DWCH-510151","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.825151+00:00"}, {"id":3957,"mfr_sku":"2510-03WP","pattern_name":"Maze","color_name":"Jungle Green on Almost White","dw_sku":"DWCH-510143","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.841148+00:00"}, {"id":3958,"mfr_sku":"2510-01WP","pattern_name":"Maze","color_name":"Turquoise on Almost White","dw_sku":"DWCH-510141","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.855354+00:00"}, {"id":3959,"mfr_sku":"2510-02WP","pattern_name":"Maze","color_name":"Magenta on Almost White","dw_sku":"DWCH-510142","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.871457+00:00"}, {"id":3960,"mfr_sku":"2510-15WP","pattern_name":"Maze","color_name":"Navy on Almost White","dw_sku":"DWCH-510152","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.885722+00:00"}, {"id":3961,"mfr_sku":"2510-04WP","pattern_name":"Maze","color_name":"Camel on Almost White","dw_sku":"DWCH-510144","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.90146+00:00"}, {"id":3962,"mfr_sku":"2510-08WP","pattern_name":"Maze","color_name":"French Blue on Almost White","dw_sku":"DWCH-510146","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.916681+00:00"}, {"id":3963,"mfr_sku":"2510-12WP","pattern_name":"Maze","color_name":"Purple on Almost White","dw_sku":"DWCH-510149","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.930114+00:00"}, {"id":3964,"mfr_sku":"2510-15WPV","pattern_name":"Maze","color_name":"Navy on White Patent Vinyl","dw_sku":"DWCH-510153","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.943399+00:00"}, {"id":3965,"mfr_sku":"2510-07WP","pattern_name":"Maze","color_name":"Brown on Almost White","dw_sku":"DWCH-510145","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.954937+00:00"}, {"id":3966,"mfr_sku":"2510-11WP","pattern_name":"Maze","color_name":"Black on Almost White","dw_sku":"DWCH-510148","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.966553+00:00"}, {"id":3967,"mfr_sku":"2510-00PV","pattern_name":"Maze","color_name":"White on  White Patent Vinyl","dw_sku":"DWCH-510140","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.978998+00:00"}, {"id":3968,"mfr_sku":"2510-13WP","pattern_name":"Maze","color_name":"Salmon on Almost White","dw_sku":"DWCH-510150","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:55.991026+00:00"}, {"id":3969,"mfr_sku":"2520-01OWP","pattern_name":"Maze Reverse Two Colors","color_name":"Turquoise Dark Turquoise","dw_sku":"DWCH-510154","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:56.006275+00:00"}, {"id":3970,"mfr_sku":"2520-05OWP","pattern_name":"Maze Reverse Two Colors","color_name":"Light Orange New Shrimp","dw_sku":"DWCH-510156","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:56.021097+00:00"}, {"id":3971,"mfr_sku":"2520-04OWP","pattern_name":"Maze Reverse Two Colors","color_name":"Lilac Purple","dw_sku":"DWCH-510155","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:56.03466+00:00"}, {"id":4027,"mfr_sku":"6760WP-14","pattern_name":"Macoco Reverse","color_name":"Black on Almost White","dw_sku":"DWCH-510569","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:56.854577+00:00"}, {"id":4028,"mfr_sku":"6750WP-05","pattern_name":"Macoco II","color_name":"Turquoise on  White","dw_sku":"DWCH-510568","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:56.869317+00:00"}, {"id":4071,"mfr_sku":"6460-32WP","pattern_name":"Island Ikat","color_name":"Pale Aqua on White","dw_sku":"DWCH-510528","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.485794+00:00"}, {"id":4072,"mfr_sku":"6460-30WP","pattern_name":"Island Ikat","color_name":"Pumice on White","dw_sku":"DWCH-510527","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.499566+00:00"}, {"id":4073,"mfr_sku":"6460-03WP","pattern_name":"Island Ikat","color_name":"Zibby Blue on White","dw_sku":"DWCH-510523","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.512655+00:00"}, {"id":4074,"mfr_sku":"6460-09WP","pattern_name":"Island Ikat","color_name":"Palm Green on White","dw_sku":"DWCH-510525","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.52722+00:00"}, {"id":4075,"mfr_sku":"6460-33WP","pattern_name":"Island Ikat","color_name":"Black on White","dw_sku":"DWCH-510529","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.538863+00:00"}, {"id":4076,"mfr_sku":"6460-26WP","pattern_name":"Island Ikat","color_name":"Pistachio on White","dw_sku":"DWCH-510526","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.552671+00:00"}, {"id":4077,"mfr_sku":"6460-05WP","pattern_name":"Island Ikat","color_name":"Brown on White","dw_sku":"DWCH-510524","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:57.567555+00:00"}, {"id":4137,"mfr_sku":"8220WP-05OWP","pattern_name":"Twigs","color_name":"Soft Green Dark Green on Off White","dw_sku":"DWCH-510654","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:58.41612+00:00"}, {"id":4207,"mfr_sku":"8170WP-06OWP","pattern_name":"Kediri Batik","color_name":"Navy Charcoal Gray on Off White","dw_sku":"DWCH-510651","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.412548+00:00"}, {"id":4216,"mfr_sku":"2110-100AWP","pattern_name":"Nairobi","color_name":"White on Almost White","dw_sku":"DWCH-510035","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.537351+00:00"}, {"id":4217,"mfr_sku":"2110-103AWP","pattern_name":"Nairobi","color_name":"Beige on Almost White","dw_sku":"DWCH-510037","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.552091+00:00"}, {"id":4218,"mfr_sku":"2110-105AWP","pattern_name":"Nairobi","color_name":"Powder Blue on Almost White","dw_sku":"DWCH-510039","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.566795+00:00"}, {"id":4219,"mfr_sku":"2110-106AWP","pattern_name":"Nairobi","color_name":"French Green on Almost White","dw_sku":"DWCH-510040","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.578712+00:00"}, {"id":4220,"mfr_sku":"2110-104AWP","pattern_name":"Nairobi","color_name":"Pale Lavender on Almost White","dw_sku":"DWCH-510038","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.592729+00:00"}, {"id":4221,"mfr_sku":"2110-102AWP","pattern_name":"Nairobi","color_name":"Pale Gray on Almost White","dw_sku":"DWCH-510036","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.608159+00:00"}, {"id":4222,"mfr_sku":"2110-109AWP","pattern_name":"Nairobi","color_name":"Teal on Almost White","dw_sku":"DWCH-510042","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.622904+00:00"}, {"id":4223,"mfr_sku":"2110-108AWP","pattern_name":"Nairobi","color_name":"Red on Almost White","dw_sku":"DWCH-510041","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.641785+00:00"}, {"id":4224,"mfr_sku":"2110-10AWP","pattern_name":"Nairobi","color_name":"Black on Almost White","dw_sku":"DWCH-510043","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.657257+00:00"}, {"id":4225,"mfr_sku":"2110-10WP","pattern_name":"Nairobi","color_name":"Black on Off White","dw_sku":"DWCH-510044","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.668743+00:00"}, {"id":4226,"mfr_sku":"619-20","pattern_name":"Tableau II","color_name":"Sky on White Matte","dw_sku":"DWCH-510489","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.680711+00:00"}, {"id":4227,"mfr_sku":"6170-22WWP","pattern_name":"Ziggurat","color_name":"Orange on White","dw_sku":"DWCH-510487","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.695825+00:00"}, {"id":4228,"mfr_sku":"6170-25WP","pattern_name":"Ziggurat","color_name":"Black on White","dw_sku":"DWCH-510488","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:03:59.711339+00:00"}, {"id":4379,"mfr_sku":"CP1060W-01","pattern_name":"Capri","color_name":"Soft Pink on Off White","dw_sku":"DWCH-510812","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:04:01.852775+00:00"}, {"id":4380,"mfr_sku":"CP1060W-02","pattern_name":"Capri","color_name":"Turquoise on Off White","dw_sku":"DWCH-510813","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:04:01.864257+00:00"}, {"id":4381,"mfr_sku":"CP1060W-03","pattern_name":"Capri","color_name":"Coral on Off White","dw_sku":"DWCH-510814","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:04:01.87579+00:00"}, {"id":4382,"mfr_sku":"CP1060W-08","pattern_name":"Capri","color_name":"Black on Off White","dw_sku":"DWCH-510816","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:04:01.886809+00:00"}, {"id":4383,"mfr_sku":"CP1060W-04","pattern_name":"Capri","color_name":"Gold Metallic on Off White","dw_sku":"DWCH-510815","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T20:04:01.897393+00:00"}, {"id":4415,"mfr_sku":"HC1850W-04AWP","pattern_name":"Medara","color_name":"Brown Navy on Almost White","dw_sku":"DWCH-510840","shopify_product_id":null,"product_type":"Commercial Wallcovering","is_live":null,"updated_at":"2026-06-23T22:01:11.849383+00:00"}]
diff --git a/shopify/scripts/reconcile/china-seas-type-fix/backups/mirror_smallline_before_20260630T163603Z.json b/shopify/scripts/reconcile/china-seas-type-fix/backups/mirror_smallline_before_20260630T163603Z.json
new file mode 100644
index 00000000..5214c285
--- /dev/null
+++ b/shopify/scripts/reconcile/china-seas-type-fix/backups/mirror_smallline_before_20260630T163603Z.json
@@ -0,0 +1 @@
+[{"id":4095373,"shopify_id":"gid://shopify/Product/7866944127027","vendor":"Charles Burger","title":"Jardin Des Plantes Print, Multi Wallcoverings | Charles Burger","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:11.839567"}, {"id":4109028,"shopify_id":"gid://shopify/Product/7866944159795","vendor":"Charles Burger","title":"Mevlana Allover, Multi Bleu Wallcoverings | Charles Burger","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:32.084146"}, {"id":4109029,"shopify_id":"gid://shopify/Product/7866944225331","vendor":"Charles Burger","title":"Mevlana Allover, Multi Vert Wallcoverings | Charles Burger","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:32.08535"}, {"id":4114742,"shopify_id":"gid://shopify/Product/7866951696435","vendor":"Cloth and Paper","title":"Pale Green on Westover Wallcoverings | Cloth and Paper","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:39.390073"}, {"id":4117629,"shopify_id":"gid://shopify/Product/7866951729203","vendor":"Cloth and Paper","title":"Pink on Westover Wallcoverings | Cloth and Paper","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:44.639258"}, {"id":4102077,"shopify_id":"gid://shopify/Product/7866951761971","vendor":"Cloth and Paper","title":"Light Blue on Westover Wallcoverings | Cloth and Paper","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:22.340262"}, {"id":4110986,"shopify_id":"gid://shopify/Product/7866944028723","vendor":"Home Couture","title":"Multi Green / Brown / Beige on Ivory Wallcoverings | Home Couture","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:34.654909"}, {"id":4110984,"shopify_id":"gid://shopify/Product/7866944061491","vendor":"Home Couture","title":"Multi Blue / Green / Beige Wallcoverings | Home Couture","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:34.651934"}, {"id":4110985,"shopify_id":"gid://shopify/Product/7866944094259","vendor":"Home Couture","title":"Multi Emerald Green / Brown / Beige Wallcoverings | Home Couture","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:34.653153"}, {"id":4068326,"shopify_id":"gid://shopify/Product/7866951893043","vendor":"Plains","title":"Bahama Cloth II, Oyster Wallcoverings | Plains","product_type":"Wallcovering","synced_at":"2026-06-24T07:18:26.094793"}, {"id":4068324,"shopify_id":"gid://shopify/Product/7866951925811","vendor":"Plains","title":"Bahama Cloth II, Aqua Wallcoverings | Plains","product_type":"Wallcovering","synced_at":"2026-06-24T07:18:26.088964"}, {"id":4068325,"shopify_id":"gid://shopify/Product/7866951958579","vendor":"Plains","title":"Bahama Cloth II, Medium Celadon Wallcoverings | Plains","product_type":"Wallcovering","synced_at":"2026-06-24T07:18:26.092045"}, {"id":4071218,"shopify_id":"gid://shopify/Product/7866917519411","vendor":"Quadrille","title":"Bird Toile II, Light Plum on Light Tint Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:18:30.548265"}, {"id":4071219,"shopify_id":"gid://shopify/Product/7866917552179","vendor":"Quadrille","title":"Bird Toile II, Pink on Light Tint Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:18:30.549755"}, {"id":4071220,"shopify_id":"gid://shopify/Product/7866917584947","vendor":"Quadrille","title":"Bird Toile II, Sky Blue on Light Tint Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:18:30.550722"}, {"id":4115080,"shopify_id":"gid://shopify/Product/7866917617715","vendor":"Quadrille","title":"Palm One Color, Lavender on Tint Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:40.069939"}, {"id":4115081,"shopify_id":"gid://shopify/Product/7866917650483","vendor":"Quadrille","title":"Palm One Color, Windsor on Tint Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:40.071509"}, {"id":4115079,"shopify_id":"gid://shopify/Product/7866917683251","vendor":"Quadrille","title":"Palm One Color, Camel on Tint Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:40.06885"}, {"id":4113582,"shopify_id":"gid://shopify/Product/7866943832115","vendor":"Quadrille","title":"Ophelia, Multi Raspberry Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:37.778203"}, {"id":4113581,"shopify_id":"gid://shopify/Product/7866943864883","vendor":"Quadrille","title":"Ophelia, Multi Greens Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:37.777097"}, {"id":4113580,"shopify_id":"gid://shopify/Product/7866943897651","vendor":"Quadrille","title":"Ophelia, Multi Blues on White Wallcoverings | Quadrille","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:37.775872"}, {"id":4132118,"shopify_id":"gid://shopify/Product/7866951794739","vendor":"Suncloth","title":"Turquoise on White Suncloth Wallcoverings | Suncloth","product_type":"Wallcovering","synced_at":"2026-06-24T07:20:08.325551"}, {"id":4138215,"shopify_id":"gid://shopify/Product/7866951827507","vendor":"Suncloth","title":"Yellow on White Suncloth Wallcoverings | Suncloth","product_type":"Wallcovering","synced_at":"2026-06-24T07:20:17.887696"}, {"id":4113635,"shopify_id":"gid://shopify/Product/7866951860275","vendor":"Suncloth","title":"Orange on White Suncloth Wallcoverings | Suncloth","product_type":"Wallcovering","synced_at":"2026-06-24T07:19:37.845173"}]
diff --git a/shopify/scripts/reconcile/china-seas-type-fix/fix-china-seas-product-type.sql b/shopify/scripts/reconcile/china-seas-type-fix/fix-china-seas-product-type.sql
new file mode 100644
index 00000000..52285df3
--- /dev/null
+++ b/shopify/scripts/reconcile/china-seas-type-fix/fix-china-seas-product-type.sql
@@ -0,0 +1,33 @@
+-- China Seas product_type reconciliation (DTD verdict A — "reconcile both now")
+-- Steve HARD RULE: China Seas is RESIDENTIAL — Fabrics + Wallcovering ONLY, never "Commercial Wallcovering".
+-- Source-table fix that defuses the live-regression vector: a future sync/push could otherwise
+-- re-introduce "Commercial Wallcovering" onto the already-correct live Shopify products from this stale source.
+--
+-- Scope:
+--   (A) 52 LIVE rows  : product_type='Commercial Wallcovering' AND shopify_product_id ~ '\d'  (committed DTD scope, the regression vector)
+--   (B) 54 NON-LIVE   : product_type='Commercial Wallcovering' with no Shopify id (same hard-rule violation; pre-empts a future live vector)
+-- Both are corrected to 'Wallcovering' (residential). Idempotent: re-running is a no-op once clean.
+-- Local Mac2 working/reference DB only. Reversible via rollback-china-seas-product-type.sql.
+
+\set ON_ERROR_STOP on
+BEGIN;
+
+-- before snapshot
+\echo '== BEFORE =='
+SELECT (shopify_product_id ~ '\d') AS is_live, product_type, count(*)
+FROM china_seas_catalog
+WHERE product_type = 'Commercial Wallcovering'
+GROUP BY 1,2 ORDER BY 1 DESC;
+
+UPDATE china_seas_catalog
+   SET product_type = 'Wallcovering',
+       updated_at   = now()
+ WHERE product_type = 'Commercial Wallcovering';
+
+-- after snapshot — expect ZERO Commercial Wallcovering rows
+\echo '== AFTER (expect 0 Commercial Wallcovering) =='
+SELECT count(*) AS remaining_commercial_wallcovering
+FROM china_seas_catalog
+WHERE product_type = 'Commercial Wallcovering';
+
+COMMIT;
diff --git a/shopify/scripts/reconcile/china-seas-type-fix/fix-mirror-smallline-type.sql b/shopify/scripts/reconcile/china-seas-type-fix/fix-mirror-smallline-type.sql
new file mode 100644
index 00000000..c10d9578
--- /dev/null
+++ b/shopify/scripts/reconcile/china-seas-type-fix/fix-mirror-smallline-type.sql
@@ -0,0 +1,28 @@
+-- Local shopify_products MIRROR reconciliation (DTD verdict A, step 2)
+-- The Mac2-local mirror is a derived cache and was stale vs the already-correct LIVE store:
+-- the 24 Quadrille-family small-line products (Suncloth, Quadrille, Home Couture, Plains,
+-- Charles Burger, Cloth and Paper) are Fabric on live but still showed Wallcovering here.
+-- No Mac2 scheduler refreshes this mirror (the daily sync cron runs on Kamatera against
+-- Kamatera's DB), so a targeted local correction is used instead of a 160k full re-sync.
+-- Reversible: backups/mirror_smallline_before_<TS>.json + rollback below.
+\set ON_ERROR_STOP on
+BEGIN;
+\echo '== BEFORE =='
+SELECT vendor, product_type, count(*) FROM shopify_products
+ WHERE vendor IN ('Charles Burger','Cloth and Paper','Home Couture','Plains','Quadrille','Suncloth')
+ GROUP BY 1,2 ORDER BY 1,2;
+
+UPDATE shopify_products
+   SET product_type = 'Fabric', synced_at = now()
+ WHERE vendor IN ('Charles Burger','Cloth and Paper','Home Couture','Plains','Quadrille','Suncloth')
+   AND product_type = 'Wallcovering';
+
+\echo '== AFTER (expect all 6 small lines = Fabric) =='
+SELECT vendor, product_type, count(*) FROM shopify_products
+ WHERE vendor IN ('Charles Burger','Cloth and Paper','Home Couture','Plains','Quadrille','Suncloth')
+ GROUP BY 1,2 ORDER BY 1,2;
+COMMIT;
+
+-- ROLLBACK (manual): set product_type back to 'Wallcovering' for the gids in the backup json:
+--   UPDATE shopify_products SET product_type='Wallcovering'
+--    WHERE shopify_id IN (<gids from mirror_smallline_before_*.json>);
diff --git a/shopify/scripts/reconcile/china-seas-type-fix/rollback-china-seas-product-type.sql b/shopify/scripts/reconcile/china-seas-type-fix/rollback-china-seas-product-type.sql
new file mode 100644
index 00000000..73851100
--- /dev/null
+++ b/shopify/scripts/reconcile/china-seas-type-fix/rollback-china-seas-product-type.sql
@@ -0,0 +1,16 @@
+-- ROLLBACK for fix-china-seas-product-type.sql
+-- Restores product_type='Commercial Wallcovering' to the exact rows backed up in
+--   backups/china_seas_commercial_wc_before_<TS>.json
+-- Usage: psql "host=/tmp dbname=dw_unified" \
+--   -v ids="$(python3 -c "import json,glob;f=sorted(glob.glob('backups/china_seas_commercial_wc_before_*.json'))[-1];print(','.join(str(r['id']) for r in json.load(open(f))))")" \
+--   -f rollback-china-seas-product-type.sql
+-- (or just edit the IN-list below to the ids from the backup json)
+
+\set ON_ERROR_STOP on
+BEGIN;
+UPDATE china_seas_catalog
+   SET product_type = 'Commercial Wallcovering',
+       updated_at   = now()
+ WHERE id IN (:ids);
+SELECT count(*) AS restored FROM china_seas_catalog WHERE product_type='Commercial Wallcovering';
+COMMIT;

← a324b3e2 Quadrille family reclassification: 3 Alan Campbell + 24 smal  ·  back to Designer Wallcoverings  ·  auto-save: 2026-06-30T09:39:21 (3 files) — pending-approval/ 15339851 →