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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 210 | 2021-08-16 23:54:32 | S016701 | S016701 | <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 Guard | Replacement | Exterior Accessories | Bumpers & Components | Bumper Guard | false | 20.99 | 97.36 | 6.49 | 0.00 | 0.00 | 0.00 | Bumper Guard - Front, Passenger Side, Primed | [{"label":"Location","value":"Front, Passenger Side"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"7172165DC0ZA4"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Interchange Part Number","value":"7172165DC0ZA4, SZ1005102"},{"label":"Replaces Partslink Number","value":"SZ1005102"},{"label":"Color Finish","value":"Primed"}] |
true | false | [{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLX Plus SE","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Limited","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Plus","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Touring","engine":"All Engines"},{"year":"2002 - 2003","make":"Suzuki","model":"XL-7","submodel":"Limited","engine":"6 Cyl 2.7L"},{"year":"2002","make":"Suzuki","model":"XL-7","submodel":"Base","engine":"6 Cyl 2.7L"},{"year":"2002 - 2003","make":"Suzuki","model":"XL-7","submodel":"Touring","engine":"6 Cyl 2.7L"},{"year":"2002","make":"Suzuki","model":"XL-7","submodel":"Plus","engine":"6 Cyl 2.7L"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLS Plus SE","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLS Plus","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLX Plus","engine":"All Engines"},{"year":"2003","make":"Suzuki","model":"Grand Vitara","submodel":"Base","engine":"All Engines"},{"year":"2004 - 2005","make":"Suzuki","model":"Grand Vitara","submodel":"LX","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"Limited","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"JLX","engine":"All Engines"},{"year":"2004 - 2005","make":"Suzuki","model":"Grand Vitara","submodel":"EX","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"JLS","engine":"All Engines"}] |
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": {
"4424": {
"category_3.id": 4424,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Guard",
"category_3.slug": "bumper-guard",
"category_3.count_parts": 31
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4424": { "category_3.id": 4424, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Guard", "category_3.slug": "bumper-guard", "category_3.count_parts": 31 } } | 4424 | 2021-08-24 01:57:58 | Bumper Guard | bumper-guard | 31 |
| 211 | 2021-08-16 23:54:32 | S016702 | S016702 | <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 Guard | Replacement | Exterior Accessories | Bumpers & Components | Bumper Guard | false | 20.99 | 37.81 | 6.49 | 0.00 | 0.00 | 0.00 | Bumper Guard - Front, Driver Side, Primed | [{"label":"Location","value":"Front, Driver Side"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"7173165DC0ZA4"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Interchange Part Number","value":"7173165DC0ZA4, SZ1004102"},{"label":"Replaces Partslink Number","value":"SZ1004102"},{"label":"Color Finish","value":"Primed"}] |
true | false | [{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Plus","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Limited","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLX Plus SE","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Touring","engine":"All Engines"},{"year":"2002 - 2003","make":"Suzuki","model":"XL-7","submodel":"Limited","engine":"6 Cyl 2.7L"},{"year":"2002","make":"Suzuki","model":"XL-7","submodel":"Base","engine":"6 Cyl 2.7L"},{"year":"2002 - 2003","make":"Suzuki","model":"XL-7","submodel":"Touring","engine":"6 Cyl 2.7L"},{"year":"2002","make":"Suzuki","model":"XL-7","submodel":"Plus","engine":"6 Cyl 2.7L"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLS Plus SE","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLS Plus","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLX Plus","engine":"All Engines"},{"year":"2003","make":"Suzuki","model":"Grand Vitara","submodel":"Base","engine":"All Engines"},{"year":"2004 - 2005","make":"Suzuki","model":"Grand Vitara","submodel":"LX","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"Limited","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"JLX","engine":"All Engines"},{"year":"2004 - 2005","make":"Suzuki","model":"Grand Vitara","submodel":"EX","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"JLS","engine":"All Engines"}] |
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": {
"4424": {
"category_3.id": 4424,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Guard",
"category_3.slug": "bumper-guard",
"category_3.count_parts": 31
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4424": { "category_3.id": 4424, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Guard", "category_3.slug": "bumper-guard", "category_3.count_parts": 31 } } | 4424 | 2021-08-24 01:57:58 | Bumper Guard | bumper-guard | 31 |
| 212 | 2021-08-16 23:54:32 | SET-REPF016703 | SET-REPF016703 | <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 Guard | Replacement | Exterior Accessories | Bumpers & Components | Bumper Guard | false | 62.99 | 216.94 | 9.60 | 0.00 | 0.00 | 0.00 | Bumper Guard - Front, Driver and Passenger Side, Textured Black | [{"label":"Location","value":"Front, Driver And Passenger Side"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"AL3Z17E810A, AL3Z17E811A"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Components","value":"(2) Bumper Trims"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Interchange Part Number","value":"AL3Z17E810A, FO1055180, AL3Z17E811A, FO1054180"},{"label":"Replaces Partslink Number","value":"FO1055180, FO1054180"}] |
true | false | [{"year":"2010 - 2014","make":"Ford","model":"F-150","submodel":"SVT Raptor","engine":"8 Cyl 6.2L"},{"year":"2010","make":"Ford","model":"F-150","submodel":"SVT Raptor","engine":"8 Cyl 5.4L"}] | 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": {
"4424": {
"category_3.id": 4424,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Guard",
"category_3.slug": "bumper-guard",
"category_3.count_parts": 31
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4424": { "category_3.id": 4424, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Guard", "category_3.slug": "bumper-guard", "category_3.count_parts": 31 } } | 4424 | 2021-08-24 01:57:58 | Bumper Guard | bumper-guard | 31 |
| 213 | 2021-08-16 23:54:32 | SET-REPF017101 | SET-REPF017101 | <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 Guard | Replacement | Exterior Accessories | Bumpers & Components | Bumper Guard | false | 26.99 | 227.44 | 14.00 | 0.00 | 0.00 | 0.00 | Bumper Trim - Front, Driver and Passenger Side, Set of 2, Textured Black | [{"label":"Location","value":"Front, Driver And Passenger Side"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"9L3Z17E810B"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Components","value":"(4) Bumper Trims"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Interchange Part Number","value":"9L3Z17E810B, FO1053100"},{"label":"Replaces Partslink Number","value":"FO1053100"}] |
true | false | [{"year":"2014","make":"Ford","model":"F-150","submodel":"Lariat","engine":"6 Cyl 3.5L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"King Ranch","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"King Ranch","engine":"6 Cyl 3.5L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"FX4","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"FX2","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"FX4","engine":"6 Cyl 3.5L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"FX2","engine":"6 Cyl 3.5L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"FX4","engine":"8 Cyl 6.2L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"FX2","engine":"8 Cyl 6.2L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"Lariat","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"STX","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XL","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XLT","engine":"8 Cyl 5.0L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XL","engine":"6 Cyl 3.5L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"Lariat","engine":"8 Cyl 6.2L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XLT","engine":"8 Cyl 6.2L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XLT","engine":"6 Cyl 3.7L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XLT","engine":"6 Cyl 3.5L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"XL","engine":"6 Cyl 3.7L"},{"year":"2014","make":"Ford","model":"F-150","submodel":"STX","engine":"6 Cyl 3.7L"}] |
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": {
"4424": {
"category_3.id": 4424,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Guard",
"category_3.slug": "bumper-guard",
"category_3.count_parts": 31
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4424": { "category_3.id": 4424, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Guard", "category_3.slug": "bumper-guard", "category_3.count_parts": 31 } } | 4424 | 2021-08-24 01:57:58 | Bumper Guard | bumper-guard | 31 |
| 214 | 2021-08-16 23:54:32 | SET-S016701 | SET-S016701 | <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 Guard | Replacement | Exterior Accessories | Bumpers & Components | Bumper Guard | false | 39.99 | 135.17 | 7.98 | 0.00 | 0.00 | 0.00 | Bumper Guard - Front, Driver and Passenger Side, Primed | [{"label":"Location","value":"Front, Driver And Passenger Side"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"7172165DC0ZA4, 7173165DC0ZA4"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Components","value":"(2) Bumper Trims"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Interchange Part Number","value":"7172165DC0ZA4, SZ1005102, 7173165DC0ZA4, SZ1004102"},{"label":"Replaces Partslink Number","value":"SZ1005102, SZ1004102"},{"label":"Color Finish","value":"Primed"}] |
true | false | [{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLX Plus SE","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Limited","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Plus","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"XL-7 Touring","engine":"All Engines"},{"year":"2002 - 2003","make":"Suzuki","model":"XL-7","submodel":"Limited","engine":"6 Cyl 2.7L"},{"year":"2002","make":"Suzuki","model":"XL-7","submodel":"Base","engine":"6 Cyl 2.7L"},{"year":"2002 - 2003","make":"Suzuki","model":"XL-7","submodel":"Touring","engine":"6 Cyl 2.7L"},{"year":"2002","make":"Suzuki","model":"XL-7","submodel":"Plus","engine":"6 Cyl 2.7L"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLS Plus SE","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLS Plus","engine":"All Engines"},{"year":"2001","make":"Suzuki","model":"Grand Vitara","submodel":"JLX Plus","engine":"All Engines"},{"year":"2003","make":"Suzuki","model":"Grand Vitara","submodel":"Base","engine":"All Engines"},{"year":"2004 - 2005","make":"Suzuki","model":"Grand Vitara","submodel":"LX","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"Limited","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"JLX","engine":"All Engines"},{"year":"2004 - 2005","make":"Suzuki","model":"Grand Vitara","submodel":"EX","engine":"All Engines"},{"year":"2001 - 2002","make":"Suzuki","model":"Grand Vitara","submodel":"JLS","engine":"All Engines"}] |
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": {
"4424": {
"category_3.id": 4424,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Guard",
"category_3.slug": "bumper-guard",
"category_3.count_parts": 31
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4424": { "category_3.id": 4424, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Guard", "category_3.slug": "bumper-guard", "category_3.count_parts": 31 } } | 4424 | 2021-08-24 01:57:58 | Bumper Guard | bumper-guard | 31 |
| 215 | 2021-08-16 23:54:32 | RB32430001 | RB32430001 | <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> |
Engine Coolant Pipe O-Ring | Replacement | Engine & Drivetrain | Radiators, Fans, Cooling Systems & Components | Coolant Hoses & Components | false | 6.10 | 25.58 | 6.49 | 0.00 | 0.00 | 0.00 | Engine Coolant Pipe O-Ring | [{"label":"Location","value":"Front"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Quantity Sold","value":"Kit"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Interchange Part Number","value":"111414399752"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Notes","value":"Collapsible Water Transfer Pipe Coolant Tube O-rings and Seal Kit"}] |
true | false | [] | 3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"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": {
"5392": {
"category_3.id": 5392,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Coolant Hoses & Components",
"category_3.slug": "coolant-hoses-and-components",
"category_3.count_parts": 4935
}
}
},
"58": {
"category_2.id": 58,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Axles, Driveshaft & 4WD",
"category_2.slug": "axles-driveshaft-and-4wd",
"category_2.count_parts": 12316,
"category_2.category_3_id": {
"2539": {
"category_3.id": 2539,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Differential",
"category_3.slug": "differential",
"category_3.count_parts": 1012
}
}
},
"50": {
"category_2.id": 50,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Air Filters & Intake Systems",
"category_2.slug": "air-filters-and-intake-systems",
"category_2.count_parts": 13660,
"category_2.category_3_id": {
"1680": {
"category_3.id": 1680,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Intake Manifold",
"category_3.slug": "intake-manifold",
"category_3.count_parts": 2158
}
}
}
} |
46 | 2021-08-24 01:56:16 | Radiators, Fans, Cooling Systems & Components | radiators-fans-cooling-systems-and-components | 19954 | { "5392": { "category_3.id": 5392, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Coolant Hoses & Components", "category_3.slug": "coolant-hoses-and-components", "category_3.count_parts": 4935 } } | 5392 | 2021-08-24 01:57:58 | Coolant Hoses & Components | coolant-hoses-and-components | 4935 |
| 216 | 2021-08-16 23:54:32 | RH54640001 | RH54640001 | <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> |
Differential Mount | Replacement | Engine & Drivetrain | Axles, Driveshaft & 4WD | Differential | false | 26.49 | 35.84 | 6.49 | 0.00 | 0.00 | 0.00 | Differential Mount, Sold individually | [{"label":"Location","value":"Rear"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Interchange Part Number","value":"905539, A65010, 1042079, 50721S5C013"},{"label":"Replaces OE Number","value":"50721S5C013"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Notes","value":"Insulator bushing"}] |
true | false | [] | 3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"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": {
"5392": {
"category_3.id": 5392,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Coolant Hoses & Components",
"category_3.slug": "coolant-hoses-and-components",
"category_3.count_parts": 4935
}
}
},
"58": {
"category_2.id": 58,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Axles, Driveshaft & 4WD",
"category_2.slug": "axles-driveshaft-and-4wd",
"category_2.count_parts": 12316,
"category_2.category_3_id": {
"2539": {
"category_3.id": 2539,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Differential",
"category_3.slug": "differential",
"category_3.count_parts": 1012
}
}
},
"50": {
"category_2.id": 50,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Air Filters & Intake Systems",
"category_2.slug": "air-filters-and-intake-systems",
"category_2.count_parts": 13660,
"category_2.category_3_id": {
"1680": {
"category_3.id": 1680,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Intake Manifold",
"category_3.slug": "intake-manifold",
"category_3.count_parts": 2158
}
}
}
} |
58 | 2021-08-24 01:56:16 | Axles, Driveshaft & 4WD | axles-driveshaft-and-4wd | 12316 | { "2539": { "category_3.id": 2539, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Differential", "category_3.slug": "differential", "category_3.count_parts": 1012 } } | 2539 | 2021-08-24 01:57:58 | Differential | differential | 1012 |
| 217 | 2021-08-16 23:54:32 | RD54100001 | RD54100001 | <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> |
Air Charge Temperature Sensor | Replacement | Engine & Drivetrain | Air Filters & Intake Systems | Intake Manifold | false | 12.99 | 0.00 | 6.49 | 0.00 | 0.00 | 0.00 | Air Charge Temperature Sensor | [{"label":"Quantity Sold","value":"Sold individually"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Interchange Part Number","value":"AX116, 68050010AA"},{"label":"Replaces OE Number","value":"68050010AA"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Notes","value":"4-Prong Blade Male Terminal; 1 Female Connector"}] | true | false | [{"year":"2003 - 2007","make":"Dodge","model":"Ram 3500","submodel":"SLT","engine":"6 Cyl 5.9L"},{"year":"2003 - 2007","make":"Dodge","model":"Ram 3500","submodel":"Laramie","engine":"6 Cyl 5.9L"},{"year":"2006 - 2007","make":"Dodge","model":"Ram 3500","submodel":"Sport","engine":"6 Cyl 5.9L"},{"year":"2003 - 2007","make":"Dodge","model":"Ram 3500","submodel":"ST","engine":"6 Cyl 5.9L"},{"year":"2007","make":"Dodge","model":"Ram 3500","submodel":"TRX4","engine":"6 Cyl 5.9L"},{"year":"2003 - 2003","make":"Dodge","model":"Ram 2500","submodel":"Laramie","engine":"6 Cyl 5.9L"},{"year":"2005 - 2007","make":"Dodge","model":"Ram 2500","submodel":"Laramie","engine":"6 Cyl 5.9L"},{"year":"2003 - 2004","make":"Dodge","model":"Ram 2500","submodel":"SLT","engine":"6 Cyl 5.9L"},{"year":"2006 - 2007","make":"Dodge","model":"Ram 2500","submodel":"SLT","engine":"6 Cyl 5.9L"},{"year":"2006 - 2007","make":"Dodge","model":"Ram 2500","submodel":"Sport","engine":"6 Cyl 5.9L"},{"year":"2006 - 2007","make":"Dodge","model":"Ram 2500","submodel":"TRX4","engine":"6 Cyl 5.9L"},{"year":"2003 - 2004","make":"Dodge","model":"Ram 2500","submodel":"ST","engine":"6 Cyl 5.9L"},{"year":"2006 - 2007","make":"Dodge","model":"Ram 2500","submodel":"ST","engine":"6 Cyl 5.9L"}] |
3 | 2021-08-24 01:51:59 | Replacement | replacement | 82563 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"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": {
"5392": {
"category_3.id": 5392,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Coolant Hoses & Components",
"category_3.slug": "coolant-hoses-and-components",
"category_3.count_parts": 4935
}
}
},
"58": {
"category_2.id": 58,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Axles, Driveshaft & 4WD",
"category_2.slug": "axles-driveshaft-and-4wd",
"category_2.count_parts": 12316,
"category_2.category_3_id": {
"2539": {
"category_3.id": 2539,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Differential",
"category_3.slug": "differential",
"category_3.count_parts": 1012
}
}
},
"50": {
"category_2.id": 50,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Air Filters & Intake Systems",
"category_2.slug": "air-filters-and-intake-systems",
"category_2.count_parts": 13660,
"category_2.category_3_id": {
"1680": {
"category_3.id": 1680,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Intake Manifold",
"category_3.slug": "intake-manifold",
"category_3.count_parts": 2158
}
}
}
} |
50 | 2021-08-24 01:56:16 | Air Filters & Intake Systems | air-filters-and-intake-systems | 13660 | { "1680": { "category_3.id": 1680, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Intake Manifold", "category_3.slug": "intake-manifold", "category_3.count_parts": 2158 } } | 1680 | 2021-08-24 01:57:58 | Intake Manifold | intake-manifold | 2158 |
| 218 | 2021-08-16 23:54:32 | RL28150005 | RL28150005 | <p><strong>TRUEDRIVE® CONTROL ARM </strong></p><p>When the going gets tough, precision-engineered TrueDrive® control arms handle road imperfections quietly and smoothly, delivering superior performance that you can count on.</p><p><strong>Features & Benefits</strong>:</p><p><span style="text-decoration: underline;">Engineered For Optimum Safety and Comfort</span></p><p style="padding-left: 30px;">•Robust design process ensures smooth, comfortable operation100% of the time.</p><p style="padding-left: 30px;">•Bushings made from premium materials eliminate noise.</p><p><span style="text-decoration: underline;">Protective Rust-Inhibitive Coating</span></p><p style="padding-left: 30px;">•Proprietary rust-inhibitive coating defends against dirt, salt, and other contaminants to promote longevity.</p><p><span style="text-decoration: underline;">Heat-Treated Metal Forging Process</span></p><p style="padding-left: 30px;">•State-of-the-art metal forging process guarantees an ultra-tough product that continues to deliver—year after year and mile after mile.</p> |
Control Arm | TrueDrive | Brakes, Suspension & Steering | Control Arms, Thrust Arms & Components | Control Arms & Components | false | 62.49 | 141.39 | 10.99 | 0.00 | 0.00 | 0.00 | Control Arm Front Lower Rearward Passenger Side For RWD Models | [{"label":"Location","value":"Front, Passenger Side, Lower, Rearward"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"4862050070"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Design","value":"Forged"},{"label":"Greasable","value":"Non-greasable"},{"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"},{"label":"Warranty","value":"1-year TrueDrive unlimited-mileage warranty"},{"label":"Bushing Included","value":"With bushing(s)"},{"label":"Bushing Material","value":"Rubber bushing"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Ball Joint Included","value":"Without ball joint(s)"},{"label":"Interchange Part Number","value":"CMS861076, 524024, RK642988, 4862050070"},{"label":"Adjustability","value":"Non-Adjustable"}] |
true | false | [] | 218 | 2021-08-24 01:51:59 | TrueDrive | truedrive | 19641 | 4 | 2021-08-24 01:54:29 | Brakes, Suspension & Steering | brakes-suspension-and-steering | 143562 | {
"69": {
"category_2.id": 69,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Control Arms, Thrust Arms & Components",
"category_2.slug": "control-arms-thrust-arms-and-components",
"category_2.count_parts": 16194,
"category_2.category_3_id": {
"5395": {
"category_3.id": 5395,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Control Arms & Components",
"category_3.slug": "control-arms-and-components",
"category_3.count_parts": 15517
}
}
}
} |
69 | 2021-08-24 01:56:16 | Control Arms, Thrust Arms & Components | control-arms-thrust-arms-and-components | 16194 | { "5395": { "category_3.id": 5395, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Control Arms & Components", "category_3.slug": "control-arms-and-components", "category_3.count_parts": 15517 } } | 5395 | 2021-08-24 01:57:58 | Control Arms & Components | control-arms-and-components | 15517 |
| 219 | 2021-08-16 23:54:32 | RL28150006 | RL28150006 | <p><strong>TRUEDRIVE® CONTROL ARM </strong></p><p>When the going gets tough, precision-engineered TrueDrive® control arms handle road imperfections quietly and smoothly, delivering superior performance that you can count on.</p><p><strong>Features & Benefits</strong>:</p><p><span style="text-decoration: underline;">Engineered For Optimum Safety and Comfort</span></p><p style="padding-left: 30px;">•Robust design process ensures smooth, comfortable operation100% of the time.</p><p style="padding-left: 30px;">•Bushings made from premium materials eliminate noise.</p><p><span style="text-decoration: underline;">Protective Rust-Inhibitive Coating</span></p><p style="padding-left: 30px;">•Proprietary rust-inhibitive coating defends against dirt, salt, and other contaminants to promote longevity.</p><p><span style="text-decoration: underline;">Heat-Treated Metal Forging Process</span></p><p style="padding-left: 30px;">•State-of-the-art metal forging process guarantees an ultra-tough product that continues to deliver—year after year and mile after mile.</p> |
Control Arm | TrueDrive | Brakes, Suspension & Steering | Control Arms, Thrust Arms & Components | Control Arms & Components | false | 62.49 | 141.39 | 10.99 | 0.00 | 0.00 | 0.00 | Control Arm Front Lower Rearward Driver Side For RWD Models | [{"label":"Location","value":"Front, Driver Side, Lower, Rearward"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"4864050070"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Design","value":"Forged"},{"label":"Greasable","value":"Non-greasable"},{"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"},{"label":"Warranty","value":"1-year TrueDrive unlimited-mileage warranty"},{"label":"Bushing Included","value":"With bushing(s)"},{"label":"Bushing Material","value":"Rubber bushing"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Ball Joint Included","value":"Without ball joint(s)"},{"label":"Interchange Part Number","value":"CMS861075, 524023, RK642208, 4864050070"},{"label":"Adjustability","value":"Non-Adjustable"}] |
true | false | [] | 218 | 2021-08-24 01:51:59 | TrueDrive | truedrive | 19641 | 4 | 2021-08-24 01:54:29 | Brakes, Suspension & Steering | brakes-suspension-and-steering | 143562 | {
"69": {
"category_2.id": 69,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Control Arms, Thrust Arms & Components",
"category_2.slug": "control-arms-thrust-arms-and-components",
"category_2.count_parts": 16194,
"category_2.category_3_id": {
"5395": {
"category_3.id": 5395,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Control Arms & Components",
"category_3.slug": "control-arms-and-components",
"category_3.count_parts": 15517
}
}
}
} |
69 | 2021-08-24 01:56:16 | Control Arms, Thrust Arms & Components | control-arms-thrust-arms-and-components | 16194 | { "5395": { "category_3.id": 5395, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Control Arms & Components", "category_3.slug": "control-arms-and-components", "category_3.count_parts": 15517 } } | 5395 | 2021-08-24 01:57:58 | Control Arms & Components | control-arms-and-components | 15517 |
| 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 |