You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
| part.id | part.ts | part.part_number | part.manufacturer_number | part.description | part.part_name | part.brand | part.category_1 | part.category_2 | part.category_3 | part.is_universal | part.price_regular | part.price_list | part.price_shipping | part.price_handling | part.price_special | part.price_core | part.part_title | part.part_attributes | part.is_best_seller | part.is_made_to_order | part.fit_notes | brand.id | brand.ts | brand.title | brand.slug | brand.count_parts | category_1.id | category_1.ts | category_1.title | category_1.slug | category_1.count_parts | category_1.category_2_id | category_2.id | category_2.ts | category_2.title | category_2.slug | category_2.count_parts | category_2.category_3_id | category_3.id | category_3.ts | category_3.title | category_3.slug | category_3.count_parts |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 451 | 2021-08-16 23:54:32 | RA28840001 | RA28840001 | <p><strong>TrueDrive is the true choice for aftermarket suspension and ride control.</strong> No matter where the road takes you, our products keep your vehicle strong and steady so you can drive with confidence.</p><p>TrueDrive products are engineered and manufactured to strict production standards to provide smooth handling and a solid foundation. With application-specific fitment and world-class quality assurance, TrueDrive offers easy installation and peace of mind for technicians and DIYers alike. All TrueDrive products include a 1-year, unlimited-mileage warranty.</p> |
Wheel Bearing | TrueDrive | Engine & Drivetrain | Wheel Hubs, Bearings, and Components | Wheel Bearing | false | 29.99 | 76.17 | 9.19 | 0.00 | 0.00 | 0.00 | Wheel Bearing - Front, Driver or Passenger Side, Sold individually | [{"label":"Location","value":"Front, Driver Or Passenger Side"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Condition","value":"New"},{"label":"Warranty","value":"1-year TrueDrive unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"44300STK951"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Interchange Part Number","value":"0514187, H510092, 7350011, 44300STK951"},{"label":"Prop 65 Warning","value":"\u003Cp\u003E\u003Cb\u003E\u003Cimg src=\"https:\u002F\u002Fcld.partsimg.com\u002Fimage\u002Fupload\u002Fimages\u002Fwarning_a.jpg\" alt=\"Warning Symbol\" width=\"28\" height=\"22\" \u002F\u003EWARNING: This product can expose you to chemicals including Lead and Mineral Oils, which are known to the State of California to cause cancer and birth defects or other reproductive harm. For more information go to \u003Ca href=\"https:\u002F\u002Fwww.p65warnings.ca.gov\"\u003Ewww.P65Warnings.ca.gov\u003C\u002Fa\u003E.\u003C\u002Fb\u003E\u003C\u002Fp\u003E"}] |
true | false | [] | 218 | 2021-08-24 01:51:59 | TrueDrive | truedrive | 19641 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"53": {
"category_2.id": 53,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Wheel Hubs, Bearings, and Components",
"category_2.slug": "wheel-hubs-bearings-and-components",
"category_2.count_parts": 8368,
"category_2.category_3_id": {
"2056": {
"category_3.id": 2056,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Wheel Bearing",
"category_3.slug": "wheel-bearing",
"category_3.count_parts": 1155
}
}
},
"46": {
"category_2.id": 46,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Radiators, Fans, Cooling Systems & Components",
"category_2.slug": "radiators-fans-cooling-systems-and-components",
"category_2.count_parts": 19954,
"category_2.category_3_id": {
"45701337": {
"category_3.id": 45701337,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Water Pumps & Components",
"category_3.slug": "water-pumps-and-components",
"category_3.count_parts": 3449
}
}
},
"51": {
"category_2.id": 51,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Electronic Control Modules, Ignition & Distributors",
"category_2.slug": "electronic-control-modules-ignition-and-distributors",
"category_2.count_parts": 7916,
"category_2.category_3_id": {
"1802": {
"category_3.id": 1802,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Ignition Coil",
"category_3.slug": "ignition-coil",
"category_3.count_parts": 2795
}
}
}
} |
53 | 2021-08-24 01:56:16 | Wheel Hubs, Bearings, and Components | wheel-hubs-bearings-and-components | 8368 | { "2056": { "category_3.id": 2056, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Wheel Bearing", "category_3.slug": "wheel-bearing", "category_3.count_parts": 1155 } } | 2056 | 2021-08-24 01:57:58 | Wheel Bearing | wheel-bearing | 1155 |
| 452 | 2021-08-16 23:54:32 | SET-RA28840001-2 | SET-RA28840001-2 | <p><strong>TrueDrive is the true choice for aftermarket suspension and ride control.</strong> No matter where the road takes you, our products keep your vehicle strong and steady so you can drive with confidence.</p><p>TrueDrive products are engineered and manufactured to strict production standards to provide smooth handling and a solid foundation. With application-specific fitment and world-class quality assurance, TrueDrive offers easy installation and peace of mind for technicians and DIYers alike. All TrueDrive products include a 1-year, unlimited-mileage warranty.</p> |
Wheel Bearing | TrueDrive | Engine & Drivetrain | Wheel Hubs, Bearings, and Components | Wheel Bearing | false | 47.49 | 163.88 | 10.68 | 0.00 | 0.00 | 0.00 | Wheel Bearing - Front, Driver and Passenger Side, Set of 2 | [{"label":"Location","value":"Front, Driver And Passenger Side"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Condition","value":"New"},{"label":"Warranty","value":"1-year TrueDrive unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"44300STK951"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Components","value":"(2) Wheel Bearings"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Interchange Part Number","value":"0514187, H510092, 7350011, 44300STK951"},{"label":"Prop 65 Warning","value":"\u003Cp\u003E\u003Cb\u003E\u003Cimg src=\"https:\u002F\u002Fcld.partsimg.com\u002Fimage\u002Fupload\u002Fimages\u002Fwarning_a.jpg\" alt=\"Warning Symbol\" width=\"28\" height=\"22\" \u002F\u003EWARNING: This product can expose you to chemicals including Lead and Mineral Oils, which are known to the State of California to cause cancer and birth defects or other reproductive harm. For more information go to \u003Ca href=\"https:\u002F\u002Fwww.p65warnings.ca.gov\"\u003Ewww.P65Warnings.ca.gov\u003C\u002Fa\u003E.\u003C\u002Fb\u003E\u003C\u002Fp\u003E"}] |
true | false | [] | 218 | 2021-08-24 01:51:59 | TrueDrive | truedrive | 19641 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"53": {
"category_2.id": 53,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Wheel Hubs, Bearings, and Components",
"category_2.slug": "wheel-hubs-bearings-and-components",
"category_2.count_parts": 8368,
"category_2.category_3_id": {
"2056": {
"category_3.id": 2056,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Wheel Bearing",
"category_3.slug": "wheel-bearing",
"category_3.count_parts": 1155
}
}
},
"46": {
"category_2.id": 46,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Radiators, Fans, Cooling Systems & Components",
"category_2.slug": "radiators-fans-cooling-systems-and-components",
"category_2.count_parts": 19954,
"category_2.category_3_id": {
"45701337": {
"category_3.id": 45701337,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Water Pumps & Components",
"category_3.slug": "water-pumps-and-components",
"category_3.count_parts": 3449
}
}
},
"51": {
"category_2.id": 51,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Electronic Control Modules, Ignition & Distributors",
"category_2.slug": "electronic-control-modules-ignition-and-distributors",
"category_2.count_parts": 7916,
"category_2.category_3_id": {
"1802": {
"category_3.id": 1802,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Ignition Coil",
"category_3.slug": "ignition-coil",
"category_3.count_parts": 2795
}
}
}
} |
53 | 2021-08-24 01:56:16 | Wheel Hubs, Bearings, and Components | wheel-hubs-bearings-and-components | 8368 | { "2056": { "category_3.id": 2056, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Wheel Bearing", "category_3.slug": "wheel-bearing", "category_3.count_parts": 1155 } } | 2056 | 2021-08-24 01:57:58 | Wheel Bearing | wheel-bearing | 1155 |
| 453 | 2021-08-16 23:54:32 | H2118401 | 18401 | <p><strong>HUSKY LINERS WEATHERBEATER FLOOR MATS</strong></p><p>Husky Liners’ WeatherBeater floor mats are laser- and CAD-designed with exact-fitting contours and elevated side walls to keep your carpet clean even in the worst weather conditions. Husky Liners, a leading manufacturer of mud guards and related accessories, utilizes the latest advances in design and technology to bring owners of cars and trucks the best protective products possible.</p><ul><li>Side walls protect against spillage while precision-formed grooves protect your feet from water and muck</li><li>Exclusive FormFit Edge door threshold contains mud and dirt without obstructing entry or exit</li><li>Stay-Put Cleats on underside keep mat firmly placed with no additional fasteners</li><li>Simple to clean and install, and built to last</li><li>Perfectly suits multitude of makes and models</li><li>Sturdy, premium rubberized materials stand up to harshest chemicals</li><li>Laser- and CAD-designed to perfectly fit your floorboard</li></ul> |
Floor Mats | Husky Liners | Interior Accessories | Floor Mats & Liners | Floor Mats | false | 72.99 | 139.99 | 11.99 | 0.00 | 0.00 | 0.00 | 18401 Black Floor Mats, Front Row | [{"label":"Location","value":"Front Row"},{"label":"Warranty","value":"Lifetime Husky Liners limited warranty"},{"label":"Material","value":"Made of Rubberized\u002FThermoplastic"},{"label":"Quantity Sold","value":"2 Pieces"},{"label":"Series","value":"Weatherbeater Series"},{"label":"Type","value":"Molded Floor Liner"},{"label":"Mfr Color Finish","value":"Black"},{"label":"Style","value":"All-Weather Style"},{"label":"Row","value":"First Row"},{"label":"Prop 65 Warning","value":"\u003Cp\u003E\u003Cb\u003E\u003Cimg src=\"https:\u002F\u002Fcld.partsimg.com\u002Fimage\u002Fupload\u002Fimages\u002Fwarning_a.jpg\" alt=\"Warning Symbol\" width=\"28\" height=\"22\" \u002F\u003EWARNING: This product can expose you to chemical which is known to the State of California to cause cancer and birth defects or other reproductive harm. For more information go to \u003Ca href=\"https:\u002F\u002Fwww.p65warnings.ca.gov\"\u003Ewww.P65Warnings.ca.gov\u003C\u002Fa\u003E.\u003C\u002Fb\u003E\u003C\u002Fp\u003E"},{"label":"Color Finish","value":"Black"}] |
true | false | [{"year":"2014 - 2015","make":"Acura","model":"MDX","submodel":"Base","engine":"All Engines"},{"year":"2017 - 2018","make":"Acura","model":"MDX","submodel":"Base","engine":"All Engines"},{"year":"2019 - 2020","make":"Acura","model":"MDX","submodel":"All Submodels","engine":"All Engines"},{"year":"2014 - 2018","make":"Acura","model":"MDX","submodel":"SH-AWD","engine":"All Engines"},{"year":"2018","make":"Acura","model":"MDX","submodel":"Sport Hybrid","engine":"All Engines"}] |
9 | 2021-08-24 01:51:59 | Husky Liners | husky-liners | 1567 | 5 | 2021-08-24 01:54:29 | Interior Accessories | interior-accessories | 55935 | {
"94": {
"category_2.id": 94,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Floor Mats & Liners",
"category_2.slug": "floor-mats-and-liners",
"category_2.count_parts": 7818,
"category_2.category_3_id": {
"3961": {
"category_3.id": 3961,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Floor Mats",
"category_3.slug": "floor-mats",
"category_3.count_parts": 7818
}
}
}
} |
94 | 2021-08-24 01:56:16 | Floor Mats & Liners | floor-mats-and-liners | 7818 | { "3961": { "category_3.id": 3961, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Floor Mats", "category_3.slug": "floor-mats", "category_3.count_parts": 7818 } } | 3961 | 2021-08-24 01:57:58 | Floor Mats | floor-mats | 7818 |
| 454 | 2021-08-16 23:54:32 | H2119401 | 19401 | <p><strong>HUSKY LINERS WEATHERBEATER FLOOR MATS</strong></p><p>Husky Liners’ WeatherBeater floor mats are laser- and CAD-designed with exact-fitting contours and elevated side walls to keep your carpet clean even in the worst weather conditions. Husky Liners, a leading manufacturer of mud guards and related accessories, utilizes the latest advances in design and technology to bring owners of cars and trucks the best protective products possible.</p><ul><li>Side walls protect against spillage while precision-formed grooves protect your feet from water and muck</li><li>Exclusive FormFit Edge door threshold contains mud and dirt without obstructing entry or exit</li><li>Stay-Put Cleats on underside keep mat firmly placed with no additional fasteners</li><li>Simple to clean and install, and built to last</li><li>Perfectly suits multitude of makes and models</li><li>Sturdy, premium rubberized materials stand up to harshest chemicals</li><li>Laser- and CAD-designed to perfectly fit your floorboard</li></ul> |
Floor Mats | Husky Liners | Interior Accessories | Floor Mats & Liners | Floor Mats | false | 72.49 | 139.99 | 11.99 | 0.00 | 0.00 | 0.00 | 19401 Black Floor Mats, Second Row | [{"label":"Location","value":"Second Row"},{"label":"Warranty","value":"Lifetime Husky Liners limited warranty"},{"label":"Material","value":"Made of Rubberized\u002FThermoplastic"},{"label":"Quantity Sold","value":"1 Piece"},{"label":"Series","value":"Weatherbeater Series"},{"label":"Type","value":"Molded Floor Liner"},{"label":"Mfr Color Finish","value":"Black"},{"label":"Style","value":"All-Weather Style"},{"label":"Row","value":"Second Row"},{"label":"Prop 65 Warning","value":"\u003Cp\u003E\u003Cb\u003E\u003Cimg src=\"https:\u002F\u002Fcld.partsimg.com\u002Fimage\u002Fupload\u002Fimages\u002Fwarning_a.jpg\" alt=\"Warning Symbol\" width=\"28\" height=\"22\" \u002F\u003EWARNING: This product can expose you to chemical which is known to the State of California to cause cancer and birth defects or other reproductive harm. For more information go to \u003Ca href=\"https:\u002F\u002Fwww.p65warnings.ca.gov\"\u003Ewww.P65Warnings.ca.gov\u003C\u002Fa\u003E.\u003C\u002Fb\u003E\u003C\u002Fp\u003E"},{"label":"Color Finish","value":"Black"}] |
true | false | [{"year":"2014 - 2015","make":"Acura","model":"MDX","submodel":"Base","engine":"All Engines"},{"year":"2017 - 2018","make":"Acura","model":"MDX","submodel":"Base","engine":"All Engines"},{"year":"2019 - 2020","make":"Acura","model":"MDX","submodel":"All Submodels","engine":"All Engines"},{"year":"2014 - 2018","make":"Acura","model":"MDX","submodel":"SH-AWD","engine":"All Engines"},{"year":"2018","make":"Acura","model":"MDX","submodel":"Sport Hybrid","engine":"All Engines"}] |
9 | 2021-08-24 01:51:59 | Husky Liners | husky-liners | 1567 | 5 | 2021-08-24 01:54:29 | Interior Accessories | interior-accessories | 55935 | {
"94": {
"category_2.id": 94,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Floor Mats & Liners",
"category_2.slug": "floor-mats-and-liners",
"category_2.count_parts": 7818,
"category_2.category_3_id": {
"3961": {
"category_3.id": 3961,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Floor Mats",
"category_3.slug": "floor-mats",
"category_3.count_parts": 7818
}
}
}
} |
94 | 2021-08-24 01:56:16 | Floor Mats & Liners | floor-mats-and-liners | 7818 | { "3961": { "category_3.id": 3961, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Floor Mats", "category_3.slug": "floor-mats", "category_3.count_parts": 7818 } } | 3961 | 2021-08-24 01:57:58 | Floor Mats | floor-mats | 7818 |
| 455 | 2021-08-17 00:19:45 | REPA313506 | REPA313506 | <p><strong>WATER PUMP </strong></p><p>DriveMotive® water pumps feature a smooth-turning bearing assembly and precision-designed impeller for quiet, efficient performance.</p><p><strong>Features & Benefits:</strong></p><p><u>Exact Fit, Easy Installation </u></p><ul><li>Designed as a direct replacement for your original water pump.</li><li>Exact-tolerance machining process and OE-matched components ensure a seamless fit.</li></ul><p><u>Low-Friction Bearing Assembly</u></p><ul><li>Low-friction bearing assembly eliminates noise and increases service life.</li></ul><p><u>Premium Seal Prevents Leaks</u></p><ul><li>Premium gasket (included where applicable) ensures leak-free performance.</li></ul><p><u>Tried and Tested</u></p><ul><li>Each water pump is rigorously tested for OE-matched flow.</li></ul><p><u>State-of-the-Art Design Process</u></p><ul><li>State-of-the-art design process guarantees an impeller that creates excellent coolant flow and a housing that resists leaks.</li></ul> |
Water Pump | DriveMotive | Engine & Drivetrain | Radiators, Fans, Cooling Systems & Components | Water Pumps & Components | false | 29.99 | 43.21 | 9.19 | 0.00 | 0.00 | 0.00 | Water Pump - | [{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"19200RDVJ01"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Pulley Included","value":"With Pulley"},{"label":"Prop 65 Warning","value":"\u003Cp\u003E\u003Cb\u003E\u003Cimg src=\"https:\u002F\u002Fcld.partsimg.com\u002Fimage\u002Fupload\u002Fimages\u002Fwarning_a.jpg\" alt=\"Warning Symbol\" width=\"28\" height=\"22\" \u002F\u003EWARNING: This product can expose you to chemicals including Lead, which is known to the State of California to cause cancer and birth defects or other reproductive harm. For more information go to \u003Ca href=\"https:\u002F\u002Fwww.p65warnings.ca.gov\"\u003Ewww.P65Warnings.ca.gov\u003C\u002Fa\u003E.\u003C\u002Fb\u003E\u003C\u002Fp\u003E"},{"label":"Gasket Included","value":"With Gasket"},{"label":"Condition","value":"New"},{"label":"Warranty","value":"1-year DriveMotive unlimited-mileage warranty"},{"label":"Quantity Sold","value":"Sold individually"}] |
true | false | [{"year":"2004","make":"Acura","model":"TL","submodel":"Base","engine":"6 Cyl 3.3L","fnotes":"Metal Impeller"}] | 455 | 2021-08-24 01:51:59 | DriveMotive | drivemotive | 1356 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"53": {
"category_2.id": 53,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Wheel Hubs, Bearings, and Components",
"category_2.slug": "wheel-hubs-bearings-and-components",
"category_2.count_parts": 8368,
"category_2.category_3_id": {
"2056": {
"category_3.id": 2056,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Wheel Bearing",
"category_3.slug": "wheel-bearing",
"category_3.count_parts": 1155
}
}
},
"46": {
"category_2.id": 46,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Radiators, Fans, Cooling Systems & Components",
"category_2.slug": "radiators-fans-cooling-systems-and-components",
"category_2.count_parts": 19954,
"category_2.category_3_id": {
"45701337": {
"category_3.id": 45701337,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Water Pumps & Components",
"category_3.slug": "water-pumps-and-components",
"category_3.count_parts": 3449
}
}
},
"51": {
"category_2.id": 51,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Electronic Control Modules, Ignition & Distributors",
"category_2.slug": "electronic-control-modules-ignition-and-distributors",
"category_2.count_parts": 7916,
"category_2.category_3_id": {
"1802": {
"category_3.id": 1802,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Ignition Coil",
"category_3.slug": "ignition-coil",
"category_3.count_parts": 2795
}
}
}
} |
46 | 2021-08-24 01:56:16 | Radiators, Fans, Cooling Systems & Components | radiators-fans-cooling-systems-and-components | 19954 | { "45701337": { "category_3.id": 45701337, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Water Pumps & Components", "category_3.slug": "water-pumps-and-components", "category_3.count_parts": 3449 } } | 45701337 | 2021-08-24 01:57:58 | Water Pumps & Components | water-pumps-and-components | 3449 |
| 456 | 2021-08-16 23:54:32 | RH50460007 | RH50460007 | <p><strong>DriveWire is the premium choice for aftermarket automotive electronics.</strong> Our standard-setting technologies are designed to achieve one simple goal-making your daily driver function the way it's supposed to, every time.</p><p>DriveWire products are engineered with consistent performance, longevity, and consumer safety in mind. With application-specific fitment and world-class quality assurance, DriveWire offers easy installation and peace of mind for technicians and DIYers alike. All DriveWire products include a 1-year, unlimited-mileage warranty.</p> |
Ignition Coil | DriveWire | Engine & Drivetrain | Electronic Control Modules, Ignition & Distributors | Ignition Coil | false | 22.79 | 0.00 | 6.99 | 0.00 | 0.00 | 0.00 | Ignition Coil - 6 Cylinder, 3.5 Liter Engine | [{"label":"Notes","value":"5.69 in. length"},{"label":"Replaces OE Number","value":"305205G0A01"},{"label":"Configuration","value":"3 Blade Male Terminals"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Warranty","value":"1-year DriveWire unlimited-mileage warranty"},{"label":"Prop 65 Warning","value":"\u003Cp\u003E\u003Cb\u003E\u003Cimg src=\"https:\u002F\u002Fcld.partsimg.com\u002Fimage\u002Fupload\u002Fimages\u002Fwarning_a.jpg\" alt=\"Warning Symbol\" width=\"28\" height=\"22\" \u002F\u003EWARNING: This product can expose you to chemicals including Lead, which is known to the State of California to cause cancer and birth defects or other reproductive harm. For more information go to \u003Ca href=\"https:\u002F\u002Fwww.p65warnings.ca.gov\"\u003Ewww.P65Warnings.ca.gov\u003C\u002Fa\u003E.\u003C\u002Fb\u003E\u003C\u002Fp\u003E"}] |
true | false | [{"year":"2014","make":"Honda","model":"Crosstour","submodel":"EX-L","engine":"6 Cyl 3.5L"}] | 355 | 2021-08-24 01:51:59 | DriveWire | drivewire | 1623 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"53": {
"category_2.id": 53,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Wheel Hubs, Bearings, and Components",
"category_2.slug": "wheel-hubs-bearings-and-components",
"category_2.count_parts": 8368,
"category_2.category_3_id": {
"2056": {
"category_3.id": 2056,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Wheel Bearing",
"category_3.slug": "wheel-bearing",
"category_3.count_parts": 1155
}
}
},
"46": {
"category_2.id": 46,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Radiators, Fans, Cooling Systems & Components",
"category_2.slug": "radiators-fans-cooling-systems-and-components",
"category_2.count_parts": 19954,
"category_2.category_3_id": {
"45701337": {
"category_3.id": 45701337,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Water Pumps & Components",
"category_3.slug": "water-pumps-and-components",
"category_3.count_parts": 3449
}
}
},
"51": {
"category_2.id": 51,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Electronic Control Modules, Ignition & Distributors",
"category_2.slug": "electronic-control-modules-ignition-and-distributors",
"category_2.count_parts": 7916,
"category_2.category_3_id": {
"1802": {
"category_3.id": 1802,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Ignition Coil",
"category_3.slug": "ignition-coil",
"category_3.count_parts": 2795
}
}
}
} |
51 | 2021-08-24 01:56:16 | Electronic Control Modules, Ignition & Distributors | electronic-control-modules-ignition-and-distributors | 7916 | { "1802": { "category_3.id": 1802, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Ignition Coil", "category_3.slug": "ignition-coil", "category_3.count_parts": 2795 } } | 1802 | 2021-08-24 01:57:58 | Ignition Coil | ignition-coil | 2795 |
| 457 | 2021-08-16 23:54:32 | RA01030014P | RA01030014P | <p>Manufactured from top quality components, this is your best option and inexpensive replacement for your rebuild, repair, and maintenance needs - an OE replacement product for your damaged or aged factory part.</p><p><b>Replacement - the most affordable brand name for replacement parts that you need!</b> Replacement is a professional brand for autobody, lighting parts, electrical, brake, suspension, intake and exhaust, and cooling and heating products. All Replacement brands include 1-year, unlimited-mileage warranty.</p> |
Bumper Cover | Replacement | Auto Body Parts & Mirrors | Bumpers & Components | Bumper Cover | false | 295.52 | 0.00 | 65.99 | 12.99 | 0.00 | 0.00 | Front Bumper Cover, Primed | [{"label":"Location","value":"Front"},{"label":"Notes","value":"Without headlight washer holes"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Primed"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"04711TZ5A70ZZ"},{"label":"Replaces Partslink Number","value":"AC1000192"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2019","make":"Acura","model":"MDX","submodel":"Sport Hybrid","engine":"All Engines"}] | 3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 1 | 2021-08-24 01:54:29 | Auto Body Parts & Mirrors | auto-body-parts-and-mirrors | 50206 | {
"1": {
"category_2.id": 1,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Bumpers & Components",
"category_2.slug": "bumpers-and-components",
"category_2.count_parts": 6512,
"category_2.category_3_id": {
"1": {
"category_3.id": 1,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Cover",
"category_3.slug": "bumper-cover",
"category_3.count_parts": 3393
}
}
}
} |
1 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 6512 | { "1": { "category_3.id": 1, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Cover", "category_3.slug": "bumper-cover", "category_3.count_parts": 3393 } } | 1 | 2021-08-24 01:57:58 | Bumper Cover | bumper-cover | 3393 |
| 458 | 2021-08-16 23:54:32 | RA01030014PQ | RA01030014PQ | <strong> CAPA CERTIFIED </strong><p>Manufactured from top quality components, this is your best option and inexpensive replacement for your rebuild, repair, and maintenance needs - an OE replacement product for your damaged or aged factory part.</p><p><b>Replacement - the most affordable brand name for replacement parts that you need!</b> Replacement is a professional brand for autobody, lighting parts, electrical, brake, suspension, intake and exhaust, and cooling and heating products. All Replacement brands include 1-year, unlimited-mileage warranty.</p> |
Bumper Cover | Replacement | Auto Body Parts & Mirrors | Bumpers & Components | Bumper Cover | false | 346.59 | 0.00 | 64.99 | 12.99 | 0.00 | 0.00 | CAPA Certified Front Bumper Cover, Primed | [{"label":"Location","value":"Front"},{"label":"Notes","value":"Without headlight washer holes"},{"label":"Certification","value":"CAPA Certified"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Primed"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"04711TZ5A70ZZ"},{"label":"Replaces Partslink Number","value":"AC1000192C"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2019","make":"Acura","model":"MDX","submodel":"Sport Hybrid","engine":"All Engines"}] | 3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 1 | 2021-08-24 01:54:29 | Auto Body Parts & Mirrors | auto-body-parts-and-mirrors | 50206 | {
"1": {
"category_2.id": 1,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Bumpers & Components",
"category_2.slug": "bumpers-and-components",
"category_2.count_parts": 6512,
"category_2.category_3_id": {
"1": {
"category_3.id": 1,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Cover",
"category_3.slug": "bumper-cover",
"category_3.count_parts": 3393
}
}
}
} |
1 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 6512 | { "1": { "category_3.id": 1, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Cover", "category_3.slug": "bumper-cover", "category_3.count_parts": 3393 } } | 1 | 2021-08-24 01:57:58 | Bumper Cover | bumper-cover | 3393 |
| 459 | 2021-08-16 23:54:32 | RA76010023P | RA76010023P | <p>Manufactured from top quality components, this is your best option and inexpensive replacement for your rebuild, repair, and maintenance needs - an OE replacement product for your damaged or aged factory part.</p><p><b>Replacement - the most affordable brand name for replacement parts that you need!</b> Replacement is a professional brand for autobody, lighting parts, electrical, brake, suspension, intake and exhaust, and cooling and heating products. All Replacement brands include 1-year, unlimited-mileage warranty.</p> |
Bumper Cover | Replacement | Exterior Accessories | Bumpers & Components | Bumper Cover | false | 318.83 | 0.00 | 59.99 | 12.99 | 0.00 | 0.00 | Rear, Upper Bumper Cover, Primed | [{"label":"Location","value":""},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"04715TZ5A60ZZ, 04715TZ5A00ZZ"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Color Finish","value":"Primed"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Material","value":"Plastic"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Parking Aid Sensor Holes","value":"With parking aid sensor holes"},{"label":"Interchange Part Number","value":"04715TZ5A60ZZ, 04715TZ5A00ZZ, AC1100179"},{"label":"Replaces Partslink Number","value":"AC1100179"}] |
true | false | [{"year":"2017","make":"Acura","model":"MDX","submodel":"All Submodels","engine":"All Engines","fnotes":""}] | 3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 6 | 2021-08-24 01:54:29 | Exterior Accessories | exterior-accessories | 60595 | {
"112": {
"category_2.id": 112,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Bumpers & Components",
"category_2.slug": "bumpers-and-components",
"category_2.count_parts": 18381,
"category_2.category_3_id": {
"4406": {
"category_3.id": 4406,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Cover",
"category_3.slug": "bumper-cover",
"category_3.count_parts": 7708
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4406": { "category_3.id": 4406, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Cover", "category_3.slug": "bumper-cover", "category_3.count_parts": 7708 } } | 4406 | 2021-08-24 01:57:58 | Bumper Cover | bumper-cover | 7708 |
| 460 | 2021-08-16 23:54:32 | RA76010023PQ | RA76010023PQ | <strong> CAPA CERTIFIED </strong><p>Manufactured from top quality components, this is your best option and inexpensive replacement for your rebuild, repair, and maintenance needs - an OE replacement product for your damaged or aged factory part.</p><p><b>Replacement - the most affordable brand name for replacement parts that you need!</b> Replacement is a professional brand for autobody and lighting parts; it also carries electrical, brake, suspension, intake and exhaust, and cooling and heating products. All Replacement brands include 1-year, unlimited-mileage warranty.</p> |
Bumper Cover | Replacement | Exterior Accessories | Bumpers & Components | Bumper Cover | false | 326.93 | 0.00 | 59.99 | 12.99 | 0.00 | 0.00 | CAPA Certified Rear, Upper Bumper Cover, Primed | [{"label":"Location","value":""},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"04715TZ5A60ZZ, 04715TZ5A00ZZ"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Color Finish","value":"Primed"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Material","value":"Plastic"},{"label":"Certification","value":"CAPA Certified"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Parking Aid Sensor Holes","value":"With parking aid sensor holes"},{"label":"Interchange Part Number","value":"04715TZ5A60ZZ, 04715TZ5A00ZZ, AC1100179"},{"label":"Replaces Partslink Number","value":"AC1100179C"}] |
true | false | [{"year":"2017","make":"Acura","model":"MDX","submodel":"All Submodels","engine":"All Engines","fnotes":""}] | 3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 6 | 2021-08-24 01:54:29 | Exterior Accessories | exterior-accessories | 60595 | {
"112": {
"category_2.id": 112,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Bumpers & Components",
"category_2.slug": "bumpers-and-components",
"category_2.count_parts": 18381,
"category_2.category_3_id": {
"4406": {
"category_3.id": 4406,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Cover",
"category_3.slug": "bumper-cover",
"category_3.count_parts": 7708
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4406": { "category_3.id": 4406, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Cover", "category_3.slug": "bumper-cover", "category_3.count_parts": 7708 } } | 4406 | 2021-08-24 01:57:58 | Bumper Cover | bumper-cover | 7708 |
| part.id | part.ts | part.part_number | part.manufacturer_number | part.description | part.part_name | part.brand | part.category_1 | part.category_2 | part.category_3 | part.is_universal | part.price_regular | part.price_list | part.price_shipping | part.price_handling | part.price_special | part.price_core | part.part_title | part.part_attributes | part.is_best_seller | part.is_made_to_order | part.fit_notes | brand.id | brand.ts | brand.title | brand.slug | brand.count_parts | category_1.id | category_1.ts | category_1.title | category_1.slug | category_1.count_parts | category_1.category_2_id | category_2.id | category_2.ts | category_2.title | category_2.slug | category_2.count_parts | category_2.category_3_id | category_3.id | category_3.ts | category_3.title | category_3.slug | category_3.count_parts |