Crate and Barrel Product Search Scraper: Extract Home Furnishing Data

---

What Is Crate and Barrel?

Crate and Barrel is a prominent online and physical retailer specializing in home furnishings, decor, and lifestyle products. With thousands of active listings across furniture, tableware, lighting, and accessories, the platform offers rich product data ideal for competitive analysis, price tracking, and market research. Manually collecting this information is tedious and error-prone — the Crate and Barrel Product Search Scraper automates extraction of comprehensive product records at scale.

---

Overview

The Crate and Barrel Product Search Scraper extracts detailed product information from search results and category pages, converting listings into clean, structured datasets. It supports two flexible scraping modes:

• URL-based scraping — Directly harvest from specific category or search result URLs
• Keyword-based search — Find products using keywords and advanced filters (price range, sorting, stock status)

This scraper is ideal for:

• E-commerce analysts tracking pricing trends and competitive positioning
• Market researchers studying home furnishing demand and product assortments
• Aggregator platforms building unified furniture marketplaces
• Price monitoring services automating daily rate collection
• Business intelligence teams benchmarking competitor inventory

The scraper gracefully handles URL failures, supports large-scale collection via pagination, and returns richly structured product data ready for analysis.

---

Input Format & Configuration

The scraper accepts JSON input with two distinct operational modes:

Mode 1: Scrape by URLs

{
  "urls": [
    "https://www.crateandbarrel.com/furniture/1",
    "https://www.crateandbarrel.com/search?query=sofa"
  ],
  "max_items_per_url": 200,
  "ignore_url_failures": true
}

Parameter	Type	Description
urls	Array	Direct links to product category or search result pages on Crate and Barrel
max_items_per_url	Integer	Maximum products to extract per URL (e.g., 200 items)
ignore_url_failures	Boolean	If true, continues scraping if some URLs fail; if false, stops on first failure

Use case: When you already have specific category or search URLs, copy-paste them directly into this array.

Mode 2: Scrape by Search Filters

{
  "keyword": "sofa",
  "sort_by": "newestFirst",
  "in_stock": true,
  "price_range": "10-15",
  "max_items_per_url": 200
}

Parameter	Type	Options	Description
keyword	String	Any search term	Search for products by keyword (e.g., "sofa", "dining table")
sort_by	String	priceLowToHigh, priceHighToLow, rating, bestSelling, newestFirst, or empty for relevance	Sort results by preferred ranking
in_stock	Boolean	true / false	Filter to in-stock items only
price_range	String	Format: "min-max" (e.g., "100-500")	Limit results to a specific price bracket
max_items_per_url	Integer	Any number	Maximum products collected per search page

Use case: When researching a product category or price segment without predefined URLs.

Tip: Only use one mode per run. Leave urls empty when using keyword-based search, or leave keyword fields empty when using URL-based scraping.

---

Output Format

Sample output

{
  "sku": 322117,
  "option_choice_parameter": null,
  "name": "Lounge Sofa (62\"-105\")",
  "description": null,
  "formatted_price": "<span class=\"reg\" ><span class=\"regPrice\">$1,549.00 - $2,649.00</span></span>",
  "regular_price": 0,
  "current_price": 1549,
  "price_type": 0,
  "markdown_type": 0,
  "shipping_message": null,
  "title": null,
  "navigate_url": "/lounge-93-sofa/s322117",
  "family_id": 59041,
  "product_image": null,
  "family_image": null,
  "miniset_type": 0,
  "image_name": null,
  "image_path": "CB_F21_UP_1_500_Hor_001",
  "wide_image_path": null,
  "image_url": "https://cb.scene7.com/is/image/Crate/CB_F21_UP_1_500_Hor_001/$web_plp_card$/240201114920/sofas.jpg",
  "image_url_high_res": "https://cb.scene7.com/is/image/Crate/CB_F21_UP_1_500_Hor_001/$web_plp_card_hires$/240201114920/sofas.jpg",
  "rollover_image_url": "https://cb.scene7.com/is/image/Crate/CB_F21_FD_46_103_Hor_v1_Hero_PDP/$web_plp_card$/260915040039/CB_F21_FD_46_103_Hor_v1_Hero_PDP.jpg",
  "image_names": null,
  "color_bar": {
    "choices": [
      {
        "choice_code": 398,
        "option_code": 1,
        "option_choice_parameter": "",
        "sku": 322117,
        "sku_property": 0,
        "name": "Taft Cement",
        "description": "Taft Cement",
        "image_url": "https://cb.scene7.com/is/image/Crate/choice_398zm/$web_swatch_chip_high_mod$/260915035904/choice_398zm.jpg",
        "sequence": 3600,
        "is_selected": true,
        "image_map_area": {
          "title": "Taft Cement",
          "coords": {
            "x1": 0,
            "y1": 0,
            "x2": 30,
            "y2": 14,
            "formatted_value": "0,0,30,14"
          },
          "is_selected": true,
          "style_top": 18,
          "style_left": 0
        },
        "navigate_url": null
      },
      {
        "choice_code": 3467,
        "option_code": 1,
        "option_choice_parameter": "",
        "sku": 505694,
        "sku_property": 0,
        "name": "Mossa Chai",
        "description": "Mossa Chai",
        "image_url": "https://cb.scene7.com/is/image/Crate/choice_3467zm/$web_swatch_chip_high_mod$/260915035933/choice_3467zm.jpg",
        "sequence": 1101,
        "is_selected": false,
        "image_map_area": {
          "title": "Mossa Chai",
          "coords": {
            "x1": 30,
            "y1": 0,
            "x2": 60,
            "y2": 14,
            "formatted_value": "30,0,60,14"
          },
          "is_selected": false,
          "style_top": 18,
          "style_left": 30
        },
        "navigate_url": null
      },
      {
        "choice_code": 3468,
        "option_code": 1,
        "option_choice_parameter": "",
        "sku": 209854,
        "sku_property": 0,
        "name": "Mossa Olive",
        "description": "Mossa Olive",
        "image_url": "https://cb.scene7.com/is/image/Crate/choice_3468zm/$web_swatch_chip_high_mod$/260915035933/choice_3468zm.jpg",
        "sequence": 8106,
        "is_selected": false,
        "image_map_area": {
          "title": "Mossa Olive",
          "coords": {
            "x1": 60,
            "y1": 0,
            "x2": 90,
            "y2": 14,
            "formatted_value": "60,0,90,14"
          },
          "is_selected": false,
          "style_top": 18,
          "style_left": 60
        },
        "navigate_url": null
      },
      {
        "choice_code": 355,
        "option_code": 1,
        "option_choice_parameter": "1,355",
        "sku": 520326,
        "sku_property": 400,
        "name": "View White",
        "description": "View White",
        "image_url": "https://cb.scene7.com/is/image/Crate/choice_355zm/$web_swatch_chip_high_mod$/260915035933/choice_355zm.jpg",
        "sequence": 50,
        "is_selected": false,
        "image_map_area": {
          "title": "View White",
          "coords": {
            "x1": 90,
            "y1": 0,
            "x2": 120,
            "y2": 14,
            "formatted_value": "90,0,120,14"
          },
          "is_selected": false,
          "style_top": 18,
          "style_left": 90
        },
        "navigate_url": null
      },
      {
        "choice_code": 401,
        "option_code": 1,
        "option_choice_parameter": "1,401",
        "sku": 520326,
        "sku_property": 400,
        "name": "Taft Pearl",
        "description": "Taft Pearl",
        "image_url": "https://cb.scene7.com/is/image/Crate/choice_401zm/$web_swatch_chip_high_mod$/260915035904/choice_401zm.jpg",
        "sequence": 1450,
        "is_selected": false,
        "image_map_area": {
          "title": "Taft Pearl",
          "coords": {
            "x1": 120,
            "y1": 0,
            "x2": 150,
            "y2": 14,
            "formatted_value": "120,0,150,14"
          },
          "is_selected": false,
          "style_top": 18,
          "style_left": 120
        },
        "navigate_url": null
      }
    ],
    "color_image_map": "https://cb.scene7.com/is/image/Crate/?fmt=png-alpha&size=147,14&origin=17,-3&layer=1&pos=0,13&src=Crate/choice_398zm&size=27,17&cropN=0,.2,.8,.4&cache=on&layer=2&pos=30,13&src=Crate/choice_3467zm&size=27,17&cropN=0,.2,.8,.4&cache=on&layer=3&pos=60,13&src=Crate/choice_3468zm&size=27,17&cropN=0,.2,.8,.4&cache=on&layer=4&pos=90,13&src=Crate/choice_355zm&size=27,17&cropN=0,.2,.8,.4&cache=on&layer=5&pos=120,13&src=Crate/choice_401zm&size=27,17&cropN=0,.2,.8,.4&cache=on",
    "color_bar_count": 5,
    "plus_more": {
      "show_plus_more": true,
      "plus_more_text": "+ More",
      "plus_more_count": 13
    },
    "navigate_url": "/lounge-93-sofa/s322117",
    "spill_position": 0,
    "is_interactive": true,
    "family_id": 59041,
    "formatted_price": null,
    "current_price": 0,
    "regular_price": 0,
    "family_color_bar": true,
    "item_color_bar": false
  },
  "rating_value": null,
  "review_count": 0,
  "quantity_item": 1,
  "sku_property": 0,
  "images": null,
  "line_level_messages": {
    "primary": {
      "style_type": null,
      "message_type": 0,
      "long_message": "",
      "short_message": "",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    },
    "secondary": {
      "style_type": null,
      "message_type": 0,
      "long_message": "",
      "short_message": "",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    },
    "shipping": {
      "style_type": null,
      "message_type": 0,
      "long_message": "",
      "short_message": "",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    },
    "marketing": {
      "style_type": "Primary",
      "message_type": 2,
      "long_message": "2,500+ 5-Star Reviews",
      "short_message": "2,500+ 5-Stars",
      "popup_name": null,
      "popup_details": "Lounge Collection",
      "has_popup": false
    },
    "availability": {
      "style_type": null,
      "message_type": 0,
      "long_message": "",
      "short_message": "",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    },
    "personalization": {
      "style_type": null,
      "message_type": 0,
      "long_message": "",
      "short_message": "",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    },
    "new": {
      "style_type": "",
      "message_type": 6,
      "long_message": "New",
      "short_message": "New",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    },
    "final_sale": {
      "style_type": null,
      "message_type": 0,
      "long_message": "",
      "short_message": "",
      "popup_name": "",
      "popup_details": "",
      "has_popup": false
    }
  },
  "current_price_min": 1549,
  "current_price_max": 1549,
  "product_sequence": 0,
  "summary": null,
  "category_family_template_type": 0,
  "department": null,
  "showcase_data": {
    "cgi_sku": null,
    "name": "Lounge Sofa (62\"-105\")",
    "image_src": "https://cb.scene7.com/is/image/Crate/CB_F21_UP_1_500_Hor_001/$web_product_hero$&/240201114920/sofas.jpg",
    "navigate_url": "/lounge-93-sofa/s322117",
    "image_name": "CB_F21_UP_1_500_Hor_001",
    "category_name": "default",
    "macro": "$web_pdp_main_carousel_med$",
    "origin_url": "https://www.crateandbarrel.com",
    "site": "Crate",
    "images": [
      {
        "is_video": false,
        "is360": false,
        "is_visualization": false,
        "is_monogramming_option_image": false,
        "video_source": null,
        "thumb_nail_source": null,
        "thumb_nail_source_hires": null,
        "portrait_src": "https://cb.scene7.com/is/image/Crate/CB_F21_UP_1_500_Hor_001/$web_plp_card$&fmt=png-alpha/240201114920/sofas.jpg",
        "portrait_src_hires": "https://cb.scene7.com/is/image/Crate/CB_F21_UP_1_500_Hor_001/$web_plp_card_hires$&fmt=png-alpha/240201114920/sofas.jpg",
        "thumb_nail_alternate": null,
        "zoom_image": null,
        "zoom_image_hi_res": null,
        "image360_source": null,
        "is_dimension_image": false,
        "is_special_order_image": false,
        "visualization_source": null,
        "customer_id": null,
        "image_caption": null
      },
      {
        "is_video": false,
        "is360": false,
        "is_visualization": false,
        "is_monogramming_option_image": false,
        "video_source": null,
        "thumb_nail_source": null,
        "thumb_nail_source_hires": null,
        "portrait_src": "https://cb.scene7.com/is/image/Crate/CB_F21_FD_46_103_Hor_v1_Hero_PDP/$web_plp_card$&fmt=png-alpha/260915040039/CB_F21_FD_46_103_Hor_v1_Hero_PDP.jpg",
        "portrait_src_hires": "https://cb.scene7.com/is/image/Crate/CB_F21_FD_46_103_Hor_v1_Hero_PDP/$web_plp_card_hires$&fmt=png-alpha/260915040039/CB_F21_FD_46_103_Hor_v1_Hero_PDP.jpg",
        "thumb_nail_alternate": null,
        "zoom_image": null,
        "zoom_image_hi_res": null,
        "image360_source": null,
        "is_dimension_image": false,
        "is_special_order_image": false,
        "visualization_source": null,
        "customer_id": null,
        "image_caption": null
      },
      {
        "is_video": false,
        "is360": false,
        "is_visualization": false,
        "is_monogramming_option_image": false,
        "video_source": null,
        "thumb_nail_source": null,
        "thumb_nail_source_hires": null,
        "portrait_src": "https://cb.scene7.com/is/image/Crate/CB_SP26_CCL_09_301_Hor_001_V2x_ALT_PDP/$web_plp_card$&fmt=png-alpha/260915040039/CB_SP26_CCL_09_301_Hor_001_V2x_ALT_PDP.jpg",
        "portrait_src_hires": "https://cb.scene7.com/is/image/Crate/CB_SP26_CCL_09_301_Hor_001_V2x_ALT_PDP/$web_plp_card_hires$&fmt=png-alpha/260915040039/CB_SP26_CCL_09_301_Hor_001_V2x_ALT_PDP.jpg",
        "thumb_nail_alternate": null,
        "zoom_image": null,
        "zoom_image_hi_res": null,
        "image360_source": null,
        "is_dimension_image": false,
        "is_special_order_image": false,
        "visualization_source": null,
        "customer_id": null,
        "image_caption": null
      },
      {
        "is_video": false,
        "is360": false,
        "is_visualization": false,
        "is_monogramming_option_image": false,
        "video_source": null,
        "thumb_nail_source": null,
        "thumb_nail_source_hires": null,
        "portrait_src": "https://cb.scene7.com/is/image/Crate/CB_F25_CSR_06_104_Ver_001v3_PDP/$web_plp_card$&fmt=png-alpha/260915040039/CB_F25_CSR_06_104_Ver_001v3_PDP.jpg",
        "portrait_src_hires": "https://cb.scene7.com/is/image/Crate/CB_F25_CSR_06_104_Ver_001v3_PDP/$web_plp_card_hires$&fmt=png-alpha/260915040039/CB_F25_CSR_06_104_Ver_001v3_PDP.jpg",
        "thumb_nail_alternate": null,
        "zoom_image": null,
        "zoom_image_hi_res": null,
        "image360_source": null,
        "is_dimension_image": false,
        "is_special_order_image": false,
        "visualization_source": null,
        "customer_id": null,
        "image_caption": null
      }
    ],
    "legend_carousel_settings": null,
    "enable_unified_showcase_image_for_list": true,
    "show_backplate": true
  },
  "image_gallery": null,
  "registry_qty_wants": 0,
  "sustainability": {
    "landing_message": "<a href=\"/responsible-design/1\">Learn more about our commitment to Responsible Design</a>\r\n <svg class=\"svg-icon-arrow-cta\" aria-hidden=\"true\" focusable=\"false\"><use xlink:href=\"#svg-icon-arrow-cta\"></use></svg>",
    "icons": [
      {
        "type": 100,
        "name": "FSC® Certified",
        "svg_names": {
          "bug": "svg-icon-csr-bug-fsc",
          "badge": "svg-icon-csr-bug-fsc"
        },
        "title": "FSC® Certified",
        "message": "<h3 class=\"text-md-bold fsc-title\">FSC® Certified</h3> <p>These products are made with sustainable wood from forests certified to be responsibly managed, environmentally sound and socially beneficial.</p>",
        "certificate_id": "",
        "testing_institute": "",
        "sequence": 1
      }
    ],
    "is_drawer_open_by_default": false
  },
  "collection_code": 0,
  "from_url": "https://www.crateandbarrel.com/furniture/1"
}

Each product record contains 41 structured fields:

Product Identity & SKU

Field	Meaning
SKU	Stock Keeping Unit — unique product identifier
Family ID	Related product family grouping for variants
Name	Product name as displayed on the listing
Title	Display title (may differ slightly from name)
Option Choice Parameter	Variant options selected (e.g., color, size)
SKU Property	Additional SKU attributes or metadata

Product Details & Description

Field	Meaning
Description	Full product description including materials, dimensions, features
Summary	Condensed product overview
Department	Product category (e.g., Furniture, Tableware, Lighting)
Category Family Template Type	Template classification for the product family
Collection Code	Assigned product collection or line code

Pricing Information

Field	Meaning
Formatted Price	Price displayed to customers (e.g., "$299.99")
Regular Price	Original list price before discounts
Current Price	Active sale or discounted price
Current Price Min	Lowest price variant in the product family
Current Price Max	Highest price variant in the product family
Price Type	Pricing model (e.g., single price, range)
Markdown Type	Discount classification (e.g., clearance, sale)

Availability & Shipping

Field	Meaning
Quantity Item	Units currently in stock
Shipping Message	Delivery info (e.g., "Ships in 2-3 weeks")

Images & Visual Assets

Field	Meaning
Product Image	Primary product photo
Family Image	Image representing the product family
Image Name	File name of the primary image
Image Path	Internal path to the image
Image URL	Full URL to standard-resolution product image
Image URL High Res	High-resolution image link for zoomed viewing
Wide Image Path	Path to extra-wide format product photo
Rollover Image URL	Alternate image shown on hover
Image Names	Array of all associated image file names
Image Gallery	Collection of all product images

Customer Feedback & Ratings

Field	Meaning
Rating Value	Average star rating (e.g., 4.5)
Review Count	Total number of customer reviews

Navigation & URLs

Field	Meaning
Navigate URL	Direct product page URL

Additional Data

Field	Meaning
Color Bar	Color swatches or variant indicators
Miniset Type	Classification for bundled or mini product sets
Line Level Messages	Promotional or informational banners
Showcase Data	Featured or highlighted product attributes
Registry Quantity Wants	Wishlist/registry popularity metrics
Sustainability	Eco-friendly certifications or claims
Product Sequence	Display order in the result set

---

How to Use

Step 1: Choose Your Scraping Mode

Decide whether to scrape specific URLs or search by filters.

Step 2: Configure Input

• For URLs: Paste category or search result links into the urls array
• For keywords: Enter a search term, optional price range, sorting preference, and stock filter

Step 3: Set Collection Limits

Adjust max_items_per_url to control data volume (lower = faster, higher = more complete)

Step 4: Run the Scraper

Launch the scraper and monitor the execution log for any URL failures or issues

Step 5: Export & Integrate

Download the results as JSON, CSV, or Excel and load into your analytics tool, spreadsheet, or database

Best practices:

• Use keyword search for exploratory research; use URL mode for consistent, repeatable harvests
• Set ignore_url_failures: true for large runs to prevent interruptions
• Start with lower max_items_per_url values to test, then increase for full collection
• For price monitoring, set your price_range to your target segment to reduce noise

---

Use Cases & Business Applications

• Competitive pricing intelligence: Track Crate and Barrel's pricing, discounts, and markdowns against competitors
• Inventory monitoring: Identify trending products, stock status changes, and new arrivals
• Market research: Analyze product assortments, feature prevalence, and customer sentiment via reviews
• Aggregator platforms: Feed curated furniture listings into custom comparison or shopping tools
• SEO & content marketing: Gather product data to fuel blog comparisons or buying guides
• Business analytics: Benchmark product performance by category, price tier, and customer rating

By automating data collection, teams save dozens of hours per month and gain real-time visibility into the home furnishing market.

---

Conclusion

The Crate and Barrel Product Search Scraper delivers reliable, structured product data from one of the web's largest home furnishing retailers. With dual scraping modes, 41 comprehensive output fields, and flexible filtering, it powers competitive analysis, price monitoring, and market research workflows. Whether you're tracking a single category or building a full product aggregator, this scraper handles the data extraction so you can focus on insights.