Install Data2Sales AI
Faster access, offline browsing, and a one-tap shortcut on your home screen.
The Ferguson Home Products dataset is a clean, structured, analysis-ready database of 231.83K records across 88 data fields, sourced from fergusonhome.com and refreshed monthly. Every record is standardised for enrichment, lead generation, market research and competitor analysis — ready to import into your CRM or data pipeline.
Key fields: url, item id, variant id, gtin, mpn, title, description, condition, product category, category tree, and 78 more. See the full data dictionary below.
This is a pay-per-record dataset with a minimum order of 70,000 records. See the order panel for live pricing in your currency (₹ for India, $ elsewhere) — the total scales with the number of records you choose, so the more you buy, the larger the order.
| mpn | url | gtin | title | item id | db source |
|---|---|---|---|---|---|
| 813612 | https://www.fergusonhome.com/grandeur-wi... | Windsor Solid Brass Rose Passage Door Kn... | 1515676 | 1784608596805 | |
| 2500-5623-10 | https://www.fergusonhome.com/newport-bra... | Vespera 1.5 GPM Cold Water Dispenser | 821557 | 1784608596805 | |
| K-3505-45 | https://www.fergusonhome.com/kohler-k-35... | Wellworth 1.6 GPF Two Piece Toilet with... | 561045 | 1784608596805 | |
| 3-5011-20 | https://www.fergusonhome.com/oxygen-ligh... | Fugit 18" Wide LED Bath Bar | 1705654 | 1784608596805 | |
| KB1605FL | https://www.fergusonhome.com/kingston-br... | Heritage 1.2 GPM Centerset Bathroom Fauc... | 1544220 | 1784608596805 | |
| 916-4W-PN-G44 | https://www.fergusonhome.com/innovations... | Cone 4 Light 38" Wide Vanity Light | 1888026 | 1784608596805 | |
| 451411TWB | https://www.fergusonhome.com/emtek-45141... | Rectangular Sectional Single Cylinder Ke... | 209221 | 1784608596805 | |
| 813862 | https://www.fergusonhome.com/grandeur-ca... | Carre Solid Brass Tall Plate Rose Right... | 1500009 | 1784608596805 | |
| 1103-66.20-AB | https://www.fergusonhome.com/california-... | Asilomar Widespread Lever Handle Floor M... | 1369375 | 1784608596805 | |
| G-5950C-LM49D-PNP | https://www.fergusonhome.com/graff-g-595... | Sospiro 1.2 GPM Cold Water Dispenser | 1953406 | 1784608596805 |
Sample@if($records) of 231.83K records@endif — 88 fields total. Purchase to unlock the full dataset.
| Column | Description | Type | Fill rate |
|---|---|---|---|
| url | Product detail page URL | Url | 100% |
| item_id | Unique product ID | Text | 100% |
| variant_id | Unique variant ID | Text | 100% |
| gtin | Universal product identifier (GTIN, UPC, ISBN, 8-14 digits) | Text | 0% |
| mpn | Manufacturer part number (max 70 chars) | Text | 90.91% |
| title | Product title | Text | 100% |
| description | Full product description | Text | 100% |
| condition | Condition of product (e.g., new, used, refurbished) | Text | 0% |
| product_category | Category path | Text | 99.51% |
| category_tree | Hierarchical category breadcrumb with names and URLs | Array | 99.51% |
| brand | Product brand | Text | 100% |
| material | Primary material(s) (max 100 chars) | Text | 0.01% |
| dimensions | Overall dimensions in LxWxH unit format (e.g., 12x8x5 in) | Text | 0% |
| length | Individual dimension - length (requires width, height, and dimensions_unit) | Number | 0% |
| width | Individual dimension - width (requires length, height, and dimensions_unit) | Number | 0% |
| height | Individual dimension - height (requires length, width, and dimensions_unit) | Number | 0.03% |
| dimensions_unit | Dimensions unit (e.g., in, cm - required if length/width/height provided) | Text | 0.03% |
| weight | Product weight (numeric value) | Number | 0% |
| item_weight_unit | Product weight unit (e.g., lb, kg - required if weight provided) | Text | 0% |
| age_group | Target demographic (newborn, infant, toddler, kids, adult) | Text | 0% |
| image_url | Main product image URL | Text | 100% |
| additional_image_urls | Extra product images (comma-separated list) | Array | 11.22% |
| video_url | Product video URL (must be publicly accessible) | Text | 0% |
| additional_video_urls | Extra product videos (must be publicly accessible) | Array | 0% |
| model_3d_url | 3D model URL (GLB/GLTF preferred) | Text | 0% |
| price | Regular price | Text | 99.98% |
| sale_price | Discounted price | Text | 9.75% |
| sale_price_start_date | Sale start date (ISO 8601 format, e.g., 2025-07-01) | Text | 0% |
| sale_price_end_date | Sale end date (ISO 8601 format, e.g., 2025-07-15) | Text | 0% |
| unit_pricing_measure | Unit price measure (e.g., 16 oz - requires base_measure) | Text | 0% |
| base_measure | Base measure for unit pricing (e.g., 1 oz - requires unit_pricing_measure) | Text | 0% |
| pricing_trend | Pricing trend description (max 80 chars, e.g., 'Lowest price in 6 months') | Text | 0% |
| availability | Product availability (in_stock, out_of_stock, pre_order, etc.) | Text | 100% |
| availability_date | Availability date | Text | 0% |
| expiration_date | Remove product after this date (ISO 8601 format, must be future date) | Text | 0% |
| pickup_method | Pickup options (in_store, reserve, not_supported) | Text | 0% |
| pickup_sla | Pickup SLA (e.g., 1 day - requires pickup_method) | Text | 0% |
| group_id | Variant group ID (same for all variants) | Text | 100% |
| listing_has_variations | Indicates if the listing has variations | Boolean | 100% |
| variant_dict | Variant attributes map as JSON object (e.g., { 'color': 'Blue', 'size': '10' }) | Object | 0% |
| variant_attributes | Currently selected variant attributes as name-value pairs | Array | 100% |
| variants | All available variant options grouped by type | Array | 100% |
| item_group_title | Group product title (max 150 chars, avoid all-caps) | Text | 0% |
| color | Variant color (max 40 chars) | Text | 0.03% |
| size | Variant size (max 20 chars, recommended for apparel) | Text | 0% |
| size_system | Size system (2-letter country code per ISO 3166, e.g., US) | Text | 0% |
| gender | Gender target (male, female, unisex) | Text | 0% |
| offer_id | Offer ID (SKU+seller+price, unique within feed, recommended) | Text | 0% |
| custom_variant1_category | Custom variant dimension 1 category (e.g., Size_Type) | Text | 0% |
| custom_variant1_option | Custom variant 1 option (e.g., Petite / Tall / Maternity) | Text | 0% |
| custom_variant2_category | Custom variant dimension 2 category (e.g., Wood_Type) | Text | 0% |
| custom_variant2_option | Custom variant 2 option (e.g., Oak / Mahogany / Walnut) | Text | 0% |
| custom_variant3_category | Custom variant dimension 3 category (e.g., Cap_Type) | Text | 0% |
| custom_variant3_option | Custom variant 3 option (e.g., Snapback / Fitted) | Text | 0% |
| shipping_price | Shipping method/cost/region (format: country:region:service_class:price, e.g., US:CA:Overnight:16.00 USD) | Text | 0% |
| delivery_estimate | Estimated arrival date (ISO 8601 format, must be future date) | Text | 0% |
| is_digital | Indicates if the product is digital (true/false) | Boolean | 0.03% |
| store_name | Seller name | Text | 100% |
| seller_url | Seller page URL | Text | 100% |
| seller_privacy_policy | Seller-specific privacy policy URL | Text | 100% |
| seller_tos | Seller-specific terms of service URL | Text | 100% |
| accepts_returns | Accepts returns (true/false) | Boolean | 0% |
| return_deadline_in_days | Days allowed for return (positive integer) | Number | 0% |
| accepts_exchanges | Accepts exchanges (true/false) | Boolean | 0% |
| return_policy | Policy URL | Text | 100% |
| return_window | Days allowed for return | Number | 100% |
| popularity_score | Popularity indicator (0-5 scale or merchant-defined, recommended) | Number | 0% |
| return_rate | Return rate percentage (0-100%) | Number | 0% |
| warning_url | Product warning URL (must resolve HTTP 200) | Text | 0% |
| age_restriction | Minimum purchase age (positive integer, recommended) | Number | 0% |
| review_count | Number of product reviews (non-negative) | Number | 94.11% |
| star_rating | Average review score (0-5 scale) | Number | 23.29% |
| store_review_count | Number of brand/store reviews (non-negative) | Number | 0% |
| store_star_rating | Average store rating (0-5 scale) | Number | 0% |
| q_and_a | FAQ content (recommended) | Array | 0% |
| reviews | Review entries (recommended) | Array | 23.29% |
| product_attributes | Product attributes and specifications as name-value pairs | Array | 0.03% |
| features | Product feature bullet points | Array | 0% |
| related_products | Related, similar, or frequently bought together products | Array | 0% |
| related_product_id | Related product IDs (recommended, comma-separated) | Array | 0% |
| relationship_type | Relationship type (part_of_set, required_part, often_bought_with, substitute, different_brand, accessory) | Text | 0% |
| target_countries | Target countries of the item | Array | 100% |
| store_country | Store country of the item | Text | 100% |
| geo_price | Price by region with ISO 4217 currency (e.g., 79.99 USD for California) | Text | 0% |
| geo_availability | Availability per region (e.g., in_stock for Texas, out_of_stock for New York) | Text | 0% |
| category_urls | List of category URLs for the product breadcrumb trail | Array | 99.51% |
| all_variations | all_variations | Boolean | 0% |
| timestamp | Date | — |
The Ferguson Home Products dataset contains approximately 231.83K records across 88 fields, refreshed monthly.
It is priced per record with a minimum order of 70,000 records. See the order panel on this page for live pricing in your currency (₹ for India, $ elsewhere) — the total scales with the number of records you select.
Fields include url, item id, variant id, gtin, mpn, title, description, condition and more — the complete list is in the data dictionary on this page.
It is aggregated from fergusonhome.com and other public, compliant sources, then cleaned, standardised and de-duplicated before delivery.
As a structured CSV/Excel export ready for CRM import or BI analysis, delivered after purchase. A free sample is available on this page.
The dataset is refreshed monthly so records stay accurate for outreach and analysis.
Instant download · verified data
231,830 records available · built from the live database at purchase, delivered as CSV.
Subscribe to access unlimited downloads of themes, videos, graphics, plugins, and more premium assets for your creative needs.
Last Update:
Aug 19, 2026 05:45 AM
Published:
Jul 21, 2026 11:25 AM
Country:
United States
Total records:
231,830
Category:
