"""Build a clean structured extract from In-Stock Kitchen Catalog 2026 spreads.""" from __future__ import annotations import json from pathlib import Path OUT = Path(r"E:/2026/plytixmage_dbs_data/audit_reports/instock_kitchen_2026_useful_extract.json") # Manually curated from PDF text (spreads layout mixes columns; fields verified from page text). COLLECTIONS = [ { "name": "Grace Snow White", "door_style": "Shaker – White Painted Finish", "overlay": "Standard Overlay – Framed", "construction_note": "PARTICLE BOARD CONSTRUCTION / NEW ITEM", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 1999, "10x10x10_u_shape": 4685}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr"], "available": ["Brentwood", "Baltimore"], }, "taxonomy": True, "brochure": True, "notes": "Featured on cover/page 2 of in-stock catalog; NOT in 2025-26 General Catalog kitchen section", }, { "name": "Belmont Drift White", "door_style": "Shaker – White Stain Finish", "overlay": "Standard Overlay", "warranty": "1 Year Limited", "bundle_prices": {"8x10_l_shape": 1507}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr"], "available": ["Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Belmont Toffee Pecan", "door_style": "Shaker – Pecan Stain Finish", "overlay": "Standard Overlay", "warranty": "1 Year Limited", "bundle_prices": {"8x10_l_shape": 1725}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr"], "available": ["Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Chesapeake Golden Oak", "door_style": "Recessed Flat Panel – Light Oak Stain Finish", "overlay": "Standard Overlay", "warranty": "1 Year Limited", "bundle_prices": {"8x10_l_shape": 1644}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr"], "available": ["Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Plymouth Espresso Maple", "door_style": "Recessed Flat Panel – Espresso Stain Finish", "overlay": "Standard Overlay", "construction_note": "PARTICLE BOARD CONSTRUCTION", "warranty": "1 Year Limited", "bundle_prices": {"8x10_l_shape": 2195}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr", "Brentwood"], "available": ["Baltimore"], }, "taxonomy": True, "brochure": False, "notes": "Needs Brochure_Data JSON", }, { "name": "Anna Stone Gray", "door_style": "Shaker – Gray Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 2834}, "availability": { "grab_and_go": ["Bellmawr", "North Bergen"], "available": ["Keyport", "Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Anna Snow White", "door_style": "Shaker – White Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 2834}, "availability": {"grab_and_go": ["ALL LOCATIONS"], "available": []}, "taxonomy": True, "brochure": True, }, { "name": "Anna Caramel Harvest", "door_style": "Shaker – Stained Birch", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 3116}, "availability": {"grab_and_go": ["ALL LOCATIONS"], "available": []}, "taxonomy": True, "brochure": True, }, { "name": "Anna Natural Rift White Oak", "door_style": "Shaker – Rift-Cut White Oak", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 4800}, "availability": { "grab_and_go": ["Keyport"], "available": ["North Bergen", "Bellmawr", "Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Maya Snow White", "door_style": "Shaker – White Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 2472}, "availability": {"grab_and_go": ["ALL LOCATIONS"], "available": []}, "taxonomy": True, "brochure": True, }, { "name": "Maya Natural Rift White Oak", "door_style": "Shaker – Rift-Cut White Oak", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 3116}, "availability": {"grab_and_go": [], "available": ["ALL LOCATIONS"]}, "taxonomy": True, "brochure": True, }, { "name": "Harriet Pearl White", "door_style": "Shaker – Soft White Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 4800}, "availability": {"grab_and_go": [], "available": ["ALL LOCATIONS"]}, "taxonomy": True, "brochure": True, }, { "name": "Maya Black Rift White Oak", "door_style": "Shaker – Rift-Cut White Oak", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 4800}, "availability": {"grab_and_go": [], "available": ["ALL LOCATIONS"]}, "taxonomy": True, "brochure": True, }, { "name": "Eleanor Snow White", "door_style": "Shaker – White Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 3116}, "availability": { "grab_and_go": ["Bellmawr", "Brentwood"], "available": ["Keyport", "North Bergen", "Baltimore"], }, "taxonomy": True, "brochure": True, }, { "name": "Eleanor Ocean Blue", "door_style": "Shaker – Blue Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 3116}, "availability": { "grab_and_go": ["Bellmawr", "Brentwood"], "available": ["Keyport", "North Bergen", "Baltimore"], }, "taxonomy": True, "brochure": True, }, { "name": "Sanibel", "door_style": "Raised Panel – Antique White Paint with Charcoal Glaze", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "1 Year Limited", "bundle_prices": {"8x10_l_shape": 3219}, "availability": { "grab_and_go": [], "available": ["Baltimore"], # paired with Riley on spread; verify store map }, "taxonomy": False, "brochure": True, "notes": "Needs taxonomy JSON entry; has Sanibel_site.json", }, { "name": "Riley", "door_style": "Raised Panel – White Painted Finish with Gray Accent Glaze", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "1 Year Limited", "bundle_prices": {"8x10_l_shape": 3219}, "availability": {"grab_and_go": [], "available": ["Baltimore"]}, "taxonomy": False, "brochure": True, "notes": "Needs taxonomy JSON entry; has Riley_0226.json", }, { "name": "Metro Mist", "door_style": "Recessed Panel – Light Grey Stain Finish", "overlay": "Standard Overlay", "construction_note": "PLYWOOD / Blum soft-close", "warranty": "Lifetime Limited", "bundle_prices": {"8x10_l_shape": 2888}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr"], "available": ["Baltimore", "Brentwood"], }, "taxonomy": False, "brochure": True, "notes": "Needs taxonomy as metro-mist / fabuwood-metro-mist", }, { "name": "Metro Frost", "door_style": "Recessed Panel – White Painted Finish", "overlay": "Standard Overlay", "construction_note": "PLYWOOD / Blum soft-close", "warranty": "Lifetime Limited", "bundle_prices": {"8x10_l_shape": 2888}, "availability": { "grab_and_go": ["Keyport", "North Bergen", "Bellmawr"], "available": ["Baltimore", "Brentwood"], }, "taxonomy": False, "brochure": True, "notes": "Needs taxonomy; brochure is QuestMetroFrost_site.json", }, { "name": "Hallmark Frost", "door_style": "Raised Panel – White Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION", "warranty": "Lifetime Limited", "bundle_prices": {"8x10_l_shape": 3080}, "availability": { "grab_and_go": ["Keyport", "Bellmawr"], "available": ["North Bergen", "Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Galaxy Horizon", "door_style": "Shaker – Gray Stain Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD / Blum / Other Colors Available", "warranty": "Lifetime Limited", "bundle_prices": {"8x10_l_shape": 3691}, "availability": { "grab_and_go": ["Keyport", "Bellmawr"], "available": ["North Bergen", "Baltimore", "Brentwood"], }, "taxonomy": True, "brochure": True, }, { "name": "Hurston Midnight Espresso", "door_style": "Shaker – Espresso Stain Finish", "overlay": "Standard Overlay", "construction_note": "PLYWOOD CONSTRUCTION / Other Colors Available", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 2885}, "availability": { "grab_and_go": ["Bellmawr", "Baltimore", "Brentwood"], "available": ["Keyport", "North Bergen"], }, "taxonomy": True, "brochure": True, }, { "name": "Cooper Slate Gray", "door_style": "Shaker – Slate Grey Stain Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION / Other Colors Available", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 3307}, "availability": { "grab_and_go": ["North Bergen", "Bellmawr", "Baltimore", "Brentwood"], "available": ["Keyport"], }, "taxonomy": True, "brochure": True, }, { "name": "Merrill Polar White", "door_style": "Recessed Panel – White Painted Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION / Other Colors Available", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 3307}, "availability": { "grab_and_go": ["North Bergen", "Bellmawr", "Baltimore", "Brentwood"], "available": ["Keyport"], }, "taxonomy": True, "brochure": True, }, { "name": "Johnson Sandstone", "door_style": "Shaker – Sandstone Stain Finish", "overlay": "Full Overlay", "construction_note": "PLYWOOD CONSTRUCTION / Made in USA (general catalog)", "warranty": "5 Year Limited", "bundle_prices": {"8x10_l_shape": 4381}, "availability": { "grab_and_go": ["North Bergen", "Bellmawr", "Baltimore", "Brentwood"], "available": ["Keyport"], }, "taxonomy": True, "brochure": True, }, ] ACCESSORIES = { "cabinet_pullouts": [ "HS-BP-BF3/BF6", "HS-SP-B09", "HS-SP-B12/B15", "HS-TD-B09", "HS-TD-B12", "HS-SP-WF330/336/342/636", "HS-SP-WF630/642", "HS-UT-B09/B12", "HS-ML-BASEFH", "HS-WPDS-24/36", "HS-SP-W09", "HS-SP-W12", "HS-TR-B15S/B18D/B21D", ], "cabinet_inserts": [ "HS-BCS", "HS-BCL", "HS-CT-S/L", "HS-CCB-B18/B21/B24", "HS-CDT-B18/B24", "HS-CDT-B15/B21/B30/B36", "HS-KCUP-B18/B24", ], } report = { "source": r"C:/Users/Mohsin.Abbas/Downloads/In-Stock-Kitchen-Catalog-2026-spreads.pdf", "pages": 9, "what_this_pdf_adds_vs_general_catalog": [ "Grace Snow White featured (missing from General Catalog kitchen section)", "Per-collection 8'x10' L-shape kitchen bundle price", "Per-collection store availability: Grab & Go vs Available by location", "Door style / construction / overlay / warranty / plywood vs particle board", "NEW ITEM flag (Grace)", "Cabinet pullouts + inserts SKUs (HS-* accessories)", ], "locations": ["Keyport", "North Bergen", "Bellmawr", "Baltimore", "Brentwood"], "availability_legend": { "green_grab_and_go": "Take home from store today", "blue_available": "At another location; arrives in less than 1 week", }, "collections": COLLECTIONS, "still_missing_taxonomy": [c["name"] for c in COLLECTIONS if not c["taxonomy"]], "still_missing_brochure": [c["name"] for c in COLLECTIONS if not c["brochure"]], "accessories": ACCESSORIES, } OUT.write_text(json.dumps(report, indent=2), encoding="utf-8") print("collections", len(COLLECTIONS)) print("missing taxonomy:", report["still_missing_taxonomy"]) print("missing brochure:", report["still_missing_brochure"]) print("wrote", OUT)