Rona.ca products unified schema
Use our RONA Product dataset to gain comprehensive insights into home improvement product offerings, pricing strategies, and inventory availability across one of Canada's leading hardware retailers. Access detailed information on thousands of products spanning categories like bathroom fixtures, building materials, and home essentials to inform competitive analysis, pricing decisions, and market positioning. Popular use cases include competitive pricing intelligence, product assortment optimization, brand performance tracking, and market trend analysis. Use it for enrichment, market research, and lead generation — sample the fields free, then pull the records you need on demand.
Data-fields
88
Total records
287.33K
Price
up to $0.005/record
Min order
$350
Data sample
Description
Statistics
Dictionary
Related
Data sample
| mpn | url | gtin | title | item_id | db_source | timestamp | variant_id |
|---|---|---|---|---|---|---|---|
| https://www.rona.ca/en/p%72oduct/take-me-home-woodvale-black-cane-arm- | TAKE ME HOME Woodvale Black Cane Arm Chair | 332051414 | 1780807276046 | 2026-06-07 | 332051414 | ||
| https://www.rona.ca/en/p%72oduct/corliving-ethan-distressed-dark-grey- | CorLiving Ethan Distressed Dark Grey Fluted Glass 3-Door Sideboard w/ | 332065826 | 1780807276046 | 2026-06-07 | 332065826 | ||
| https://www.rona.ca/en/p%72oduct/brassex-jia-grey-upholstered-queen-pl | Brassex Jia Grey Upholstered Queen Platform Bed w/ Headboard | 332074791 | 1780807276046 | 2026-06-07 | 332074791 | ||
| https://www.rona.ca/en/%70roduct/unitool-regular-impact-socket-black-s | Unitool Regular Impact Socket - Black - Steel - 1/2-in Drive x 3/8-in | 051123727 | 1780807276046 | 2026-06-07 | 16825130 | ||
| https://www.rona.ca/en/p%72oduct/generation-lighting-bayside-1-light-o | Generation Lighting Bayside 1-Light Outdoor Wall Sconce - White | 332090787 | 1780807276046 | 2026-06-07 | 332090787 | ||
| https://www.rona.ca/en/p%72oduct/bestar-pur-83-in-bark-grey-closet-org | Bestar Pur 83-in Bark Grey Closet Organizer | 330834404 | 1780807276046 | 2026-06-07 | 330834404 | ||
| https://www.rona.ca/en/p%72oduct/homcom-shoe-bench-with-padded-seat-an | HOMCOM Shoe Bench with Padded Seat and Flip Drawer for 8 Pairs - White | 332092996 | 1780807276046 | 2026-06-07 | 332092996 | ||
| https://www.rona.ca/en/p%72oduct/dundee-deco-falkirk-perth-24-in-x-24- | Dundee Deco Falkirk Perth 24-in x 24-in Damask Antique Silver Surface- | 331059204 | 1780807276046 | 2026-06-07 | 331059204 | ||
| https://www.rona.ca/en/p%72oduct/ideal-security-keyed-deadbolt-white-b | Ideal Security Keyed Deadbolt - White | 332086425 | 1780807276046 | 2026-06-07 | 332086425 | ||
| https://www.rona.ca/en/p%72oduct/dewalt-tstak-black-plastic-tool-organ | DEWALT TSTAK Black Plastic Tool Organizer Box - 17.3 x 7.3 x 13-in | 000332002 | 1780807276046 | 2026-06-07 | 00278103 | ||
| https://www.rona.ca/en/%70roduct/richelieu-fort-greene-139-mm-contempo | Richelieu Fort Greene 139-mm Contemporary Rectangle Metal Pull - Brush | 330613357 | 1780814478687 | 2026-06-07 | 330613357 | ||
| https://www.rona.ca/fr/produit/chemise-a-col-rond-tilley-tuff-pour-hom | Chemise à col rond Tilley Tuff pour hommes avec isolation thermique bl | 90056043 | 1780814478687 | 2026-06-07 |
Description
The Rona.ca products unified schema dataset standardizes rona.ca data into analysis-ready fields:
url, item_id, variant_id, gtin, mpn, title, description, condition, and more.
Use our RONA Product dataset to gain comprehensive insights into home improvement product offerings, pricing strategies, and inventory availability across one of Canada's leading hardware retailers. Access detailed information on thousands of products spanning categories like bathroom fixtures, building materials, and home essentials to inform competitive analysis, pricing decisions, and market positioning. Popular use cases include competitive pricing intelligence, product assortment optimization, brand performance tracking, and market trend analysis.
Common uses include enrichment, lead generation, market and competitor research, and feeding downstream AI models.
287.33K records available, refreshed monthly, from $0.005 per record — minimum order $350. Preview a sample free before you buy.
Record updates over time
Data dictionary
| Column name | Description | Type | Fill rate |
|---|---|---|---|
| url | Product detail page URL | Url |
100%
|
| item_id | Unique product ID | Text |
100%
|
| variant_id | Unique variant ID | Text |
99.02%
|
| gtin | Universal product identifier (GTIN, UPC, ISBN, 8-14 digits) | Text |
0%
|
| mpn | Manufacturer part number (max 70 chars) | Text |
0%
|
| title | Product title | Text |
100%
|
| description | Full product description | Text |
99.56%
|
| condition | Condition of product (e.g., new, used, refurbished) | Text |
0%
|
| product_category | Category path | Text |
100%
|
| category_tree | Hierarchical category breadcrumb with names and URLs | Array |
100%
|
| brand | Product brand | Text |
97.01%
|
| material | Primary material(s) (max 100 chars) | Text |
0%
|
| 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%
|
| dimensions_unit | Dimensions unit (e.g., in, cm - required if length/width/height provided) | Text |
0%
|
| 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 |
99.99%
|
| additional_image_urls | Extra product images (comma-separated list) | Array |
0%
|
| 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.22%
|
| sale_price | Discounted price | Text |
8.93%
|
| 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 |
79.67%
|
| 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 |
0%
|
| 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 |
1.32%
|
| variants | All available variant options grouped by type | Array |
1.32%
|
| item_group_title | Group product title (max 150 chars, avoid all-caps) | Text |
0%
|
| color | Variant color (max 40 chars) | Text |
0%
|
| 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%
|
| store_name | Seller name | Text |
100%
|
| seller_url | Seller page URL | Text |
100%
|
| seller_privacy_policy | Seller-specific privacy policy URL | Text |
99.99%
|
| seller_tos | Seller-specific terms of service URL | Text |
99.99%
|
| 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 |
99.03%
|
| return_window | Days allowed for return | Number |
98.64%
|
| 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 |
0%
|
| star_rating | Average review score (0-5 scale) | Number |
0%
|
| 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 |
0%
|
| product_attributes | Product attributes and specifications as name-value pairs | Array |
0%
|
| 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 |
100%
|
| all_variations | Boolean |
0%
|
|
| timestamp | Date |
%
|