import json from pathlib import Path OUT = Path(r"E:\2026\plytixmage_dbs_data\Brochure_Data") OUT.mkdir(parents=True, exist_ok=True) docs = { "FabuwoodMetroMist_0326.json": { "source_document": { "collection_code": "MM", "file_name": "FabuwoodMetroMist_0326.pdf", "source_url": "https://www.homesurplus.com/wp-content/uploads/2026/03/FabuwoodMetroMist_0326.pdf", "source_kind": "pdf_brochure", "document_version_code": "V-0326", "pages": 2, "extracted_on": "2026-07-21", "notes": [ "Generated from brochure text extraction.", "Brand inferred safely from file name: Fabuwood.", "The newer-template availability split may have the same image/text inversion seen in Hallmark Frost, Galaxy Horizon, and Grace Snow White; this JSON currently preserves the flattened text grouping and should be confirmed against the rendered brochure image.", "SKU catalog was not exhaustively expanded in this draft; core brochure facts, packages, and availability are preserved." ] }, "collection": { "canonical_code": "metro-mist", "display_name": "Metro Mist", "brand_label": "Fabuwood", "line_name": "Metro", "color_label": "Mist", "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Beautiful recessed panel style cabinet line in a light gray stain finish." }, "availability": { "modes": [ { "code": "grab_and_go", "label": "Grab & Go", "meaning": "Take home today", "location_scope": ["Keyport", "North Bergen", "Bellmawr"], "source_confidence": "low", "source_note": "Taken from flattened text extraction only; newer-template sibling brochures may show the opposite grouping in the rendered page image." }, { "code": "available", "label": "Available", "meaning": "Available in 7 days or less", "location_scope": ["Brentwood", "Baltimore"], "source_confidence": "low", "source_note": "Taken from flattened text extraction only; newer-template sibling brochures may show the opposite grouping in the rendered page image." }, { "code": "special_order", "label": "Special Order", "meaning": "Additional items not shown above may be available for special order", "location_scope": "not location-specific in brochure" } ], "sku_scope_note": "Green SKUs only for locations designated as Grab & Go.", "disclaimer": "Line drawings may not accurately depict cabinet detail — speak to a sales representative for more information.", "finished_end_skins_note": "Finished end skins sold separately on base & wall cabinets." }, "matching_styles": [], "sample_products": [], "specifications": { "style": { "door_style": "Recessed Panel", "wood_species": None, "finish_type": "Light Gray Stain Finish", "overlay": "Partial Overlay", "cabinet_frame_style": "Framed", "drawer_front_style": "5-Piece Front", "drawer_interior_finish": "Natural Finish Interior", "cabinet_interior_finish": "Natural Finish Interior", "finished_side_panels_required": True, "finished_side_panels_note": "Brochure states unfinished side panels with matching skins available." }, "construction": { "door": { "frame_thickness_in": 0.75, "stile_width_in": 2.0, "rail_width_in": 2.0, "construction_method": "Mortise and Tenon", "frame_material": "Solid Wood", "center_panel_material": "MDF", "center_panel_thickness_in": 0.5 }, "drawer_front": { "frame_thickness_in": 0.75, "construction_method": "Solid Wood Frame", "frame_material": "Solid Wood", "center_panel_material": "MDF", "center_panel_thickness_in": 0.25, "piece_count": 5 }, "drawer_box": { "box_material": "Solid Wood", "joinery": "Dovetail", "box_thickness_in": 0.625, "bottom_material": "Plywood", "bottom_thickness_in": 0.375 }, "cabinet_box": { "face_frame_material": "Solid Wood", "face_frame_thickness_in": 0.75, "face_frame_width_in": 1.5, "side_panel_material": "Plywood", "side_panel_thickness_in": 0.5, "top_panel_material": "Plywood", "top_panel_thickness_in": 0.5, "bottom_panel_material": "Plywood", "bottom_panel_thickness_in": 0.5, "back_panel_material": "Plywood", "back_panel_thickness_in": 0.5, "shelf_material": "Plywood", "shelf_thickness_in": 0.625 } }, "hardware_features": { "door_hinges": {"brand": "Blum", "soft_close": True}, "drawer_slides": {"brand": "Blum", "extension": "Full Extension", "mount_type": "Undermount", "soft_close": True} }, "cabinet_features": { "assembly_methods": ["Dovetail", "Glued"], "panel_beam_material": "Plywood" } }, "kitchen_packages": [ {"package_code": "l_shape_8x10", "label": "8' x 10' L-Shape Kitchen", "price_usd": 2888}, {"package_code": "u_shape_10x10x10", "label": "10' x 10' x 10' U-Shape Kitchen", "price_usd": 6901} ], "normalization_seed_hints": { "sample_master_sku": None, "source_completeness": "core_brochure_facts_only" } }, "Riley_0226.json": { "source_document": { "collection_code": "RILEY", "file_name": "Riley_0226.pdf", "source_url": "https://www.homesurplus.com/wp-content/uploads/2026/03/Riley_0226.pdf", "source_kind": "pdf_brochure_plus_product_page", "document_version_code": "V-0226", "pages": 2, "extracted_on": "2026-07-21", "notes": [ "Generated from Riley brochure plus product page cross-check.", "Brand is not explicit in the extracted brochure/page text and should be confirmed before final outbound use.", "This draft captures brochure packages, availability, and page-visible construction facts; SKU catalog was not fully expanded." ] }, "collection": { "canonical_code": "riley", "display_name": "Riley", "brand_label": None, "line_name": "Riley", "color_label": None, "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Raised panel cabinet line in white painted finish with gray accent glaze." }, "availability": { "modes": [ {"code": "grab_and_go", "label": "Grab & Go", "meaning": "Take home today", "location_scope": ["Keyport", "North Bergen", "Bellmawr"]}, {"code": "available", "label": "Available", "meaning": "Available in 7 days or less", "location_scope": ["Brentwood", "Baltimore"]}, {"code": "special_order", "label": "Special Order", "meaning": "Additional items not shown above may be available for special order", "location_scope": "not location-specific in brochure"} ], "sku_scope_note": "Green SKUs only for locations designated as Grab & Go.", "disclaimer": "Line drawings may not accurately depict cabinet detail — speak to a sales representative for more information." }, "matching_styles": [], "sample_products": [], "specifications": { "style": { "door_style": "Raised Panel", "finish_type": "White Painted Finish with Gray Accent Glaze", "overlay": "Full Overlay", "cabinet_frame_style": "Framed", "drawer_front_style": "5-Piece Front", "drawer_interior_finish": "Natural Finish Interior", "cabinet_interior_finish": "White Veneer Finish Interior", "finished_side_panels_required": False, "finished_side_panels_note": "Brochure/page state finished side panels." }, "construction": { "door": { "frame_thickness_in": 0.75, "stile_width_in": 2.75, "rail_width_in": 2.75, "construction_method": "Mortise and Tenon", "frame_material": "Solid Maple/Birch", "center_panel_material": "MDF", "center_panel_thickness_in": 0.5 }, "drawer_front": { "frame_thickness_in": 0.75, "construction_method": "Solid Wood Frame", "center_panel_thickness_in": 0.25, "piece_count": 5 }, "drawer_box": { "box_material": "Solid Wood", "joinery": "Double Rabbet / Dovetail", "box_thickness_in": 0.625, "bottom_material": "Plywood", "bottom_thickness_in": 0.25 }, "cabinet_box": { "face_frame_material": "Solid Wood", "face_frame_thickness_in": 0.75, "face_frame_width_in": 1.5625, "side_panel_material": "Plywood", "side_panel_thickness_in": 0.5, "top_panel_material": "Plywood", "top_panel_thickness_in": 0.5, "bottom_panel_material": "Plywood", "bottom_panel_thickness_in": 0.5, "back_panel_material": "Plywood", "back_panel_thickness_in": 0.5, "shelf_material": "Plywood", "shelf_thickness_in": 0.625 } }, "hardware_features": { "door_hinges": {"adjustable_way": 6, "soft_close": True}, "drawer_slides": {"extension": "Three Quarter Extension", "mount_type": "Undermount", "soft_close": True} }, "cabinet_features": {"corner_braces_material": "Plastic", "assembly_methods": ["Cam Lock", "Glued"]}, "warranty": None }, "kitchen_packages": [ {"package_code": "l_shape_8x10", "label": "8' x 10' L-Shape Kitchen", "price_usd": 3219}, {"package_code": "u_shape_10x10x10", "label": "10' x 10' x 10' U-Shape Kitchen", "price_usd": 7680} ] }, "CoronetHoney_site.json": { "source_document": { "collection_code": "CORONET-HONEY", "file_name": None, "source_url": "https://www.homesurplus.com/coronet-honey/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": [ "Generated from collection product page because no brochure PDF was located.", "Page includes a limited-stock note for North Bergen only.", "No brochure-grade SKU/package catalog available from the page." ] }, "collection": { "canonical_code": "coronet-honey", "display_name": "Coronet Honey", "brand_label": None, "line_name": "Coronet", "color_label": "Honey", "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Warm raised panel cabinet collection with honey stain finish." }, "availability": { "modes": [], "page_note": "Product page states limited stock available and to contact North Bergen; no standard brochure location split available.", "limited_stock_contact_location": "North Bergen" }, "matching_styles": [], "sample_products": [], "specifications": { "style": { "door_style": "Raised Panel - Routed", "finish_type": "Honey Stain Finish", "overlay": "Partial Overlay", "cabinet_frame_style": "Framed", "drawer_front_style": "Slab", "drawer_interior_finish": "Natural Finish Interior", "cabinet_interior_finish": "Natural Finish", "finished_side_panels_required": False, "finished_side_panels_note": "Page states finished side panels." }, "construction": { "door": {"frame_thickness_in": 0.75, "stile_width_in": 2.0, "rail_width_in": 2.0, "construction_method": "Stile and Rail", "frame_material": "Plantation Hardwood", "center_panel_material": "Solid Routed Plantation Hardwood"}, "drawer_front": {"frame_thickness_in": 0.75, "material": "Solid Plantation Hardwood", "style": "Slab"}, "drawer_box": {"box_material": "Solid Wood", "joinery": "Dovetail", "box_thickness_in": 0.625, "bottom_material": "Plywood", "bottom_thickness_in": 0.25}, "cabinet_box": {"face_frame_material": "Solid Hardwood", "face_frame_thickness_in": 0.75, "face_frame_width_in": 1.5, "side_panel_material": "Plywood", "side_panel_thickness_in": 0.5, "top_panel_material": "Plywood", "top_panel_thickness_in": 0.5, "bottom_panel_material": "Plywood", "bottom_panel_thickness_in": 0.5, "back_panel_material": "Plywood", "back_panel_thickness_in": 0.125, "shelf_material": "Plywood", "shelf_thickness_in": 0.625} }, "hardware_features": { "door_hinges": {"concealed": True, "adjustable_way": 6}, "drawer_slides": {"extension": "Full Extension", "mount_type": "Under Mount", "weight_limit_lb": 100} }, "cabinet_features": {"assembly_methods": ["Pocket Screw", "Glued"], "panel_beam_material": "Plywood"} }, "kitchen_packages": [] }, "JohnsonWhite_site.json": { "source_document": { "collection_code": "JW", "file_name": None, "source_url": "https://www.homesurplus.com/johnson-kitchen-cabinets/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": [ "Generated from collection product page because no brochure PDF was located.", "Brand/line relationship inherited from Johnson Sandstone brochure sibling." ] }, "collection": { "canonical_code": "johnson-white", "display_name": "Johnson White", "brand_label": "Legion Manor", "line_name": "Johnson", "color_label": "White", "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": "value_select", "exclusive_to": None, "summary": "Clean shaker cabinet line in a cool white finish with solid slab drawer fronts." }, "availability": {"modes": [], "page_note": "No brochure-style location breakdown found on product page."}, "matching_styles": [], "sample_products": [], "specifications": { "style": {"door_style": "Shaker", "finish_type": "Cool White Finish", "overlay": "Full Overlay", "drawer_front_style": "Slab"}, "construction": { "cabinet_box": {"side_panel_material": "Particle Board", "side_panel_thickness_in": 0.375, "back_panel_material": "Vinyl Covered Board"}, "face_frame": {"material": "Solid Wood", "thickness_in": 0.75, "assembly_method": "Pocket Drilled and Screwed"}, "drawer_box": {"material": "MDF", "thickness_in": 0.5, "joinery": "Dovetail Standard"}, "door": {"frame_thickness_in": 0.75, "stile_width_in": 3.0, "rail_width_in": 3.0, "construction_method": "Mortise and Tenon", "center_panel_material": "Composite Board for paints / Veneer for stains", "center_panel_thickness_in": 0.25}, "shelves": {"wall_material": "MDF", "wall_thickness_in": 0.5, "base_material": "MDF", "base_thickness_in": 0.5} }, "hardware_features": {"drawer_slides": {"type": "Self-adjusting ballbearing nylon guides"}} }, "kitchen_packages": [] }, "MerrillSlate_site.json": { "source_document": { "collection_code": "MS", "file_name": None, "source_url": "https://www.homesurplus.com/merrill-slate-kitchen-cabinets/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": [ "Generated from collection product page because no brochure PDF was located.", "Brand/line relationship inherited from Merrill Polar White brochure sibling." ] }, "collection": { "canonical_code": "merrill-slate", "display_name": "Merrill Slate", "brand_label": "Port & Bell", "line_name": "Merrill", "color_label": "Slate", "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": "premium", "exclusive_to": "Home Surplus", "summary": "Deep and rich kitchen cabinet line in a slate finish." }, "availability": {"modes": [], "page_note": "No brochure-style location breakdown found on product page."}, "matching_styles": [], "sample_products": [], "specifications": { "style": {"finish_type": "Slate Finish", "overlay": "Full Overlay", "drawer_interior_finish": "Natural Wood Tone"}, "construction": { "cabinet_box": {"side_panel_material": "Plywood", "side_panel_thickness_in": 0.5, "top_panel_material": "Plywood", "bottom_panel_material": "Plywood"}, "face_frame": {"material": "Solid Birch", "thickness_in": 0.75, "width_in": 1.5}, "drawer_box": {"box_material": "Solid Wood", "joinery": "Dovetail", "box_thickness_in": 0.625, "bottom_material": "Veneered Plywood", "bottom_thickness_in": 0.375}, "door": {"frame_material": "Birch Solid Wood", "construction_method": "Cope-and-stick", "frame_thickness_in": 0.75, "stile_width_in": 2.75, "rail_width_in": 2.75, "center_panel_material": "Veneered Center Panel", "center_panel_thickness_in": 0.25}, "shelves": {"material": "Veneered Plywood", "thickness_in": 0.75} }, "hardware_features": {"drawer_slides": {"extension": "Full Extension", "mount_type": "Undermount", "soft_close": True, "weight_limit_lb": 100}, "door_hinges": {"adjustable_way": 6, "concealed": True}} }, "kitchen_packages": [] }, "QuestMetroFrost_site.json": { "source_document": { "collection_code": "QMF", "file_name": None, "source_url": "https://www.homesurplus.com/quest-metro-frost/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": ["Generated from collection product page because no brochure PDF was located."] }, "collection": { "canonical_code": "quest-metro-frost", "display_name": "Quest Metro Frost", "brand_label": None, "line_name": "Quest", "color_label": "Metro Frost", "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Bright, clean standard-overlay cabinet line in white painted finish." }, "availability": {"modes": [], "page_note": "No brochure-style location breakdown found on product page."}, "matching_styles": [], "sample_products": [], "specifications": { "style": {"door_style": "Recessed Panel", "finish_type": "White Painted Finish", "overlay": "Standard Overlay", "drawer_front_style": "5-Piece Front", "finished_side_panels_required": True, "finished_side_panels_note": "Page states unfinished exterior side panels."}, "construction": {"door": {"construction_method": "Mortise and Tenon", "center_panel_material": "MDF"}, "drawer_box": {"box_material": "Solid Wood", "joinery": "Dovetail", "box_thickness_in": 0.625}, "cabinet_box": {"face_frame_material": "Solid Wood", "side_panel_material": "Plywood", "side_panel_thickness_in": 0.5, "shelf_material": "Plywood", "shelf_thickness_in": 0.625}}, "hardware_features": {"door_hinges": {"brand": "Blum", "soft_close": True}, "drawer_slides": {"brand": "Blum", "extension": "Full Extension", "mount_type": "Undermount", "soft_close": True}} }, "kitchen_packages": [] }, "Sanibel_site.json": { "source_document": { "collection_code": "SANIBEL", "file_name": None, "source_url": "https://www.homesurplus.com/sanibel/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": [ "Generated from collection product page because no brochure PDF was located.", "Product page includes a Sample Door link, but exact SKU is not listed." ] }, "collection": { "canonical_code": "sanibel", "display_name": "Sanibel", "brand_label": None, "line_name": "Sanibel", "color_label": None, "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Raised panel kitchen cabinet line in antique white painted finish with charcoal glaze." }, "availability": {"modes": [], "page_note": "No brochure-style location breakdown found on product page."}, "matching_styles": [], "sample_products": [{"brochure_sku": "SD", "product_type": "sample_door", "label": "Sample Door", "source_confidence": "low", "source_note": "Product page exposes a sample door link but no explicit SKU."}], "specifications": { "style": {"door_style": "Raised Panel", "finish_type": "Antique White Paint with Charcoal Glaze", "overlay": "Full Overlay", "drawer_front_style": "5-Piece Front", "drawer_interior_finish": "Matching Finish Interior Surfaces", "cabinet_interior_finish": "Matching Finish Interior Surfaces"}, "construction": {"door": {"construction_method": "Mortise and Tenon Joinery", "center_panel_material": "MDF"}, "drawer_box": {"box_material": "Solid Wood", "joinery": "Double Rabbet", "box_thickness_in": 0.625}, "cabinet_box": {"face_frame_material": "Solid Maple Birch", "face_frame_thickness_in": 0.75, "side_panel_material": "Plywood", "side_panel_thickness_in": 0.5, "shelf_material": "Plywood", "shelf_thickness_in": 0.625}}, "hardware_features": {"door_hinges": {"adjustable_way": 6, "soft_close": True}, "drawer_slides": {"mount_type": "Undermount", "soft_close": True}} }, "kitchen_packages": [] }, "Whitney_site.json": { "source_document": { "collection_code": "WHITNEY", "file_name": None, "source_url": "https://www.homesurplus.com/whitney/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": ["Generated from collection product page because no brochure PDF was located."] }, "collection": { "canonical_code": "whitney", "display_name": "Whitney", "brand_label": None, "line_name": "Whitney", "color_label": None, "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Clean and bright recessed-panel cabinet line in antique white and glaze." }, "availability": {"modes": [], "page_note": "No brochure-style location breakdown found on product page."}, "matching_styles": [], "sample_products": [], "specifications": { "style": {"door_style": "Recessed Panel", "finish_type": "Antique White & Glaze", "overlay": "Full Overlay", "drawer_interior_finish": "Natural Birch", "cabinet_interior_finish": "Natural Birch"}, "construction": {"door": {"material": "Grade A Plywood", "thickness_in": 0.5}, "drawer_front": {"construction_method": "Mitred Mortise and Tenon", "frame_material": "Solid Birch", "center_panel_material": "MDF"}, "drawer_box": {"box_material": "Particle Box", "box_thickness_in": 0.625, "joinery": "Dovetailed"}, "cabinet_box": {"face_frame_material": "Solid Wood", "face_frame_thickness_in": 0.75, "shelf_material": "Grade A Plywood", "shelf_thickness_in": 0.75}}, "hardware_features": {"door_hinges": {"concealed": True, "soft_close": True}} }, "kitchen_packages": [] }, "Williamson_site.json": { "source_document": { "collection_code": "WILLIAMSON", "file_name": None, "source_url": "https://www.homesurplus.com/williamson/", "source_kind": "product_page", "document_version_code": None, "pages": None, "extracted_on": "2026-07-21", "notes": ["Generated from collection product page because no brochure PDF was located."] }, "collection": { "canonical_code": "williamson", "display_name": "Williamson", "brand_label": None, "line_name": "Williamson", "color_label": None, "category_l1": "Kitchen Cabinets", "product_family": "Cabinets", "marketing_positioning": None, "exclusive_to": None, "summary": "Raised panel cabinet line in antique white and glaze." }, "availability": {"modes": [], "page_note": "No brochure-style location breakdown found on product page."}, "matching_styles": [], "sample_products": [], "specifications": { "style": {"door_style": "Raised Panel", "finish_type": "Antique White & Glaze", "overlay": "Full Overlay", "drawer_interior_finish": "Natural Birch", "cabinet_interior_finish": "Natural Birch"}, "construction": {"door": {"material": "Grade A Plywood", "thickness_in": 0.5}, "drawer_front": {"construction_method": "Mitred Mortise and Tenon", "frame_material": "Solid Birch", "center_panel_material": "Solid Birch Raised Center Panel"}, "drawer_box": {"box_material": "Plywood Box", "box_thickness_in": 0.625, "joinery": "Dovetailed"}, "cabinet_box": {"face_frame_material": "Solid Wood", "face_frame_thickness_in": 0.75, "shelf_material": "Grade A Plywood", "shelf_thickness_in": 0.75}}, "hardware_features": {"door_hinges": {"concealed": True, "soft_close": True}} }, "kitchen_packages": [] } } for name, payload in docs.items(): (OUT / name).write_text(json.dumps(payload, indent=2, ensure_ascii=False) + "\n", encoding="utf-8") print("wrote", name)