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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 361 | 2021-08-17 00:19:45 | RH28230012 | RH28230012 | <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> |
Ball Joint | TrueDrive | Brakes, Suspension & Steering | Ball Joints & Components | Ball Joints | false | 12.72 | 0.00 | 6.99 | 0.00 | 0.00 | 0.00 | Ball Joint - Front, Driver or Passenger Side, Lower | [{"label":"Location","value":"Front, Driver Or Passenger Side, Lower"},{"label":"Type","value":"Non-greasable"},{"label":"Replaces OE Number","value":"51220TS9A01"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Warranty","value":"1-year TrueDrive 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 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 | [{"year":"2014","make":"Honda","model":"Civic","submodel":"Si","engine":"All Engines"}] | 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 | {
"78": {
"category_2.id": 78,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Ball Joints & Components",
"category_2.slug": "ball-joints-and-components",
"category_2.count_parts": 4322,
"category_2.category_3_id": {
"45701334": {
"category_3.id": 45701334,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Ball Joints",
"category_3.slug": "ball-joints",
"category_3.count_parts": 4300
}
}
},
"67": {
"category_2.id": 67,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Brake Discs, Pads & Calipers",
"category_2.slug": "brake-discs-pads-and-calipers",
"category_2.count_parts": 51685,
"category_2.category_3_id": {
"3196": {
"category_3.id": 3196,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Brake Disc and Pad Kit",
"category_3.slug": "brake-disc-and-pad-kit",
"category_3.count_parts": 12852
}
}
}
} |
78 | 2021-08-24 01:56:16 | Ball Joints & Components | ball-joints-and-components | 4322 | { "45701334": { "category_3.id": 45701334, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Ball Joints", "category_3.slug": "ball-joints", "category_3.count_parts": 4300 } } | 45701334 | 2021-08-24 01:57:58 | Ball Joints | ball-joints | 4300 |
| 362 | 2021-08-16 23:54:32 | RA76010002P | RA76010002P | <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 | 205.84 | 600.05 | 99.99 | 12.99 | 0.00 | 0.00 | Bumper Cover - Rear, 1 Piece, Primed | [{"label":"Location","value":"Rear"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Primed"},{"label":"Parking Aid Sensor Holes","value":"Without parking aid sensor holes"},{"label":"Receiver And Tow Hook Hole","value":"Without tow hook hole"},{"label":"License Plate Provision","value":"Without license plate provision"},{"label":"Material","value":"Plastic"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"04715TX6A50ZZ"},{"label":"Replaces Partslink Number","value":"AC1100177"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2017","make":"Acura","model":"ILX","submodel":"All Submodels","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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
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 |
| 363 | 2021-08-16 23:54:32 | REPA010368P | REPA010368P | <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 | 206.93 | 598.19 | 79.99 | 12.99 | 0.00 | 0.00 | Bumper Cover - Front, 1 Piece, Primed | [{"label":"Location","value":"Front"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Primed"},{"label":"Parking Aid Sensor Holes","value":"Without parking aid sensor holes"},{"label":"Material","value":"Plastic"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"04711TV9A00ZZ"},{"label":"Replaces Partslink Number","value":"AC1000189"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2017","make":"Acura","model":"ILX","submodel":"All Submodels","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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
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 |
| 364 | 2021-08-16 23:54:32 | REPA010368PQ | REPA010368PQ | <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 | Auto Body Parts & Mirrors | Bumpers & Components | Bumper Cover | false | 252.41 | 465.34 | 64.99 | 12.99 | 0.00 | 0.00 | Bumper Cover - Front, 1 Piece, Primed, CAPA Certified | [{"label":"Location","value":"Front"},{"label":"Certification","value":"CAPA Certified"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Primed"},{"label":"Parking Aid Sensor Holes","value":"Without parking aid sensor holes"},{"label":"Material","value":"Plastic"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"04711TV9A00ZZ"},{"label":"Replaces Partslink Number","value":"AC1000189C"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2017","make":"Acura","model":"ILX","submodel":"All Submodels","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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
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 |
| 365 | 2021-08-16 23:54:32 | SET-REPA010368P-2 | SET-REPA010368P-2 | <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 | 392.13 | 758.15 | 124.65 | 20.78 | 0.00 | 0.00 | Bumper Cover - Front and Rear, 2 Pieces, Primed | [{"label":"Location","value":"Front And Rear"},{"label":"Components","value":"(2) Bumper Covers"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Primed"},{"label":"Parking Aid Sensor Holes","value":"Without parking aid sensor holes"},{"label":"Material","value":"Plastic"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Replaces OE Number","value":"04711TV9A00ZZ, 04715TX6A50ZZ"},{"label":"Replaces Partslink Number","value":"AC1000189, AC1100177"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2017","make":"Acura","model":"ILX","submodel":"All Submodels","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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
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 |
| 366 | 2021-08-17 00:19:45 | AC26EL | AC26EL | <p>Kool Vue Mirrors are your most affordable OE replacement mirrors and they are manufactured from the highest quality, corrosion-resistant materials to withstand all types of weather. Kool Vue specializes in producing mirrors for all vehicle makes and models; Our mirrors go through rigorous weather, swing, and vibration testing to make sure you receive the highest quality mirrors. <b>Backed by a 1-year Kool Vue limited warranty - you can't go wrong with Kool Vue Mirrors!</b></p><p><i>Wave lines on Mirror Glasses should not be used to identify Heated Mirrors as more and more newer applications no longer put wave lines on heated mirrors.</i></p> |
Mirror | Kool Vue | Auto Body Parts & Mirrors | Mirrors & Components | Mirrors | false | 72.00 | 392.70 | 9.99 | 0.00 | 0.00 | 0.00 | Mirror - Driver Side, Power, Heated, Folding, Paintable | [{"label":"Location","value":"Driver Side"},{"label":"Vehicle Body Type","value":"Sedan"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Glass Operation","value":"Power Glass"},{"label":"Heated","value":"Heated"},{"label":"Folding Type","value":"Manual Folding"},{"label":"Color\u002FFinish","value":"Paintable"},{"label":"Puddle Light Included","value":"Without Puddle Light"},{"label":"Memory Recall","value":"Without memory"},{"label":"Auto-Dimming","value":"Without Auto-Dimming"},{"label":"Blind Spot Detection","value":"Without Blind Spot Feature"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"76258TX6A01-PFM"},{"label":"Replaces Partslink Number","value":"AC1320116"},{"label":"Warranty","value":"1-year Kool Vue limited 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 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"}] |
true | false | [{"year":"2013","make":"Acura","model":"ILX","submodel":"Hybrid","engine":"All Engines"}] | 42 | 2021-08-24 01:51:59 | Kool Vue | kool-vue | 7027 | 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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
3 | 2021-08-24 01:56:16 | Mirrors & Components | mirrors-and-components | 8688 | { "45701335": { "category_3.id": 45701335, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Mirrors", "category_3.slug": "mirrors", "category_3.count_parts": 7259 } } | 45701335 | 2021-08-24 01:57:58 | Mirrors | mirrors | 7259 |
| 367 | 2021-08-17 00:19:45 | AC26ER | AC26ER | <p>Kool Vue Mirrors are your most affordable OE replacement mirrors and they are manufactured from the highest quality, corrosion-resistant materials to withstand all types of weather. Kool Vue specializes in producing mirrors for all vehicle makes and models; Our mirrors go through rigorous weather, swing, and vibration testing to make sure you receive the highest quality mirrors. <b>Backed by a 1-year Kool Vue limited warranty - you can't go wrong with Kool Vue Mirrors!</b></p><p><i>Wave lines on Mirror Glasses should not be used to identify Heated Mirrors as more and more newer applications no longer put wave lines on heated mirrors.</i></p> |
Mirror | Kool Vue | Auto Body Parts & Mirrors | Mirrors & Components | Mirrors | false | 72.00 | 447.07 | 9.99 | 0.00 | 0.00 | 0.00 | Mirror - Passenger Side, Power, Heated, Folding, Paintable | [{"label":"Location","value":"Passenger Side"},{"label":"Vehicle Body Type","value":"Sedan"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Glass Operation","value":"Power Glass"},{"label":"Heated","value":"Heated"},{"label":"Folding Type","value":"Manual Folding"},{"label":"Color\u002FFinish","value":"Paintable"},{"label":"Puddle Light Included","value":"Without Puddle Light"},{"label":"Memory Recall","value":"Without memory"},{"label":"Auto-Dimming","value":"Without Auto-Dimming"},{"label":"Blind Spot Detection","value":"Without Blind Spot Feature"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"76208TX6A01-PFM"},{"label":"Replaces Partslink Number","value":"AC1321116"},{"label":"Warranty","value":"1-year Kool Vue limited 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 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"}] |
true | false | [{"year":"2013","make":"Acura","model":"ILX","submodel":"Hybrid","engine":"All Engines"}] | 42 | 2021-08-24 01:51:59 | Kool Vue | kool-vue | 7027 | 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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
3 | 2021-08-24 01:56:16 | Mirrors & Components | mirrors-and-components | 8688 | { "45701335": { "category_3.id": 45701335, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Mirrors", "category_3.slug": "mirrors", "category_3.count_parts": 7259 } } | 45701335 | 2021-08-24 01:57:58 | Mirrors | mirrors | 7259 |
| 368 | 2021-08-17 00:19:45 | SET-AC26ER | SET-AC26ER | <b>KOOL VUE POWERED MIRRORS, HEATED, MANUAL FOLDING, SET OF 2</b><p>This Kool Vue OE Replacement Mirror is manufactured from the highest quality, corrosion-resistant materials at an affordable price. Backed by 1-year Kool Vue limited warranty -- Kool Vue specializes in producing the highest quality mirrors for all vehicle makes and models!</p><p><b><i>Wave lines on Mirror Glasses should not be used to identify Heated Mirrors as more and more newer applications no longer put wave lines on heated mirrors.</i></b></p> |
Mirror | Kool Vue | Auto Body Parts & Mirrors | Mirrors & Components | Mirrors | false | 127.48 | 442.71 | 14.57 | 0.00 | 0.00 | 0.00 | Mirror - Driver and Passenger Side (Pair), Power, Heated, Folding, Paintable | [{"label":"Location","value":"Driver And Passenger Side"},{"label":"Components","value":"(2) Mirrors"},{"label":"Vehicle Body Type","value":"Sedan"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Glass Operation","value":"Power Glass"},{"label":"Heated","value":"Heated"},{"label":"Folding Type","value":"Manual Folding"},{"label":"Color\u002FFinish","value":"Paintable"},{"label":"Puddle Light Included","value":"Without Puddle Light"},{"label":"Memory Recall","value":"Without memory"},{"label":"Auto-Dimming","value":"Without Auto-Dimming"},{"label":"Blind Spot Detection","value":"Without Blind Spot Feature"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Replaces OE Number","value":"76208TX6A01-PFM, 76258TX6A01-PFM"},{"label":"Replaces Partslink Number","value":"AC1321116, AC1320116"},{"label":"Warranty","value":"1-year Kool Vue limited 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 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"}] |
false | false | [{"year":"2013","make":"Acura","model":"ILX","submodel":"Hybrid","engine":"All Engines"}] | 42 | 2021-08-24 01:51:59 | Kool Vue | kool-vue | 7027 | 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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
3 | 2021-08-24 01:56:16 | Mirrors & Components | mirrors-and-components | 8688 | { "45701335": { "category_3.id": 45701335, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Mirrors", "category_3.slug": "mirrors", "category_3.count_parts": 7259 } } | 45701335 | 2021-08-24 01:57:58 | Mirrors | mirrors | 7259 |
| 369 | 2021-08-16 23:54:32 | RA07010002 | RA07010002 | <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> |
Grille Assembly | Replacement | Auto Body Parts & Mirrors | Grilles & Components | Grille Assembly | false | 75.60 | 0.00 | 16.99 | 0.00 | 0.00 | 0.00 | Grille Assembly - Textured Black Shell and Insert | [{"label":"Type","value":"Grille"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Color\u002FFinish","value":"Textured Black Shell and Insert"},{"label":"Material","value":"Plastic"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Replaces OE Number","value":"71121TX6A51"},{"label":"Replaces Partslink Number","value":"AC1200129"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"}] |
false | false | [{"year":"2017","make":"Acura","model":"ILX","submodel":"Base","engine":"All Engines","fnotes":"For Models Without Adaptive Cruise Control"}] | 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
}
}
},
"3": {
"category_2.id": 3,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Mirrors & Components",
"category_2.slug": "mirrors-and-components",
"category_2.count_parts": 8688,
"category_2.category_3_id": {
"45701335": {
"category_3.id": 45701335,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Mirrors",
"category_3.slug": "mirrors",
"category_3.count_parts": 7259
}
}
},
"5": {
"category_2.id": 5,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Grilles & Components",
"category_2.slug": "grilles-and-components",
"category_2.count_parts": 932,
"category_2.category_3_id": {
"95": {
"category_3.id": 95,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Grille Assembly",
"category_3.slug": "grille-assembly",
"category_3.count_parts": 636
}
}
}
} |
5 | 2021-08-24 01:56:16 | Grilles & Components | grilles-and-components | 932 | { "95": { "category_3.id": 95, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Grille Assembly", "category_3.slug": "grille-assembly", "category_3.count_parts": 636 } } | 95 | 2021-08-24 01:57:58 | Grille Assembly | grille-assembly | 636 |
| 370 | 2021-08-16 23:54:32 | STP28OEREP31 | 28OEREP31 | <p><strong>SURESTOP – OE REPLACEMENT BRAKE DISC AND PAD KITS</strong></p><p>Replacing your brakes is an investment, so if you choose to restore your stock brakes use the OE replacement brake disc and pad kit by SureStop and enjoy cost savings, better stopping power and a lot less dust and noise. SureStop is a leader in high performing yet affordable replacement brakes that meet strict OE quality standards for the ultimate in safety and performance.</p><ul><li>SureStop Semi-metallic pads have a higher friction coefficient than competing brands</li><li>SureStop shims feature dual rubber layers instead of steel for 6 times less noise</li><li>Pad surfaces are thermal-scorched for fast break-in</li><li>Meet factory specifications</li><li>Low-dust formula for cleaner wheels</li><li>Rotors and pads included</li><li>SureStop brake kit is less expensive than doing brakes at a dealership or buying premium aftermarket brakes</li></ul> |
Brake Disc and Pad Kit | SureStop | Brakes, Suspension & Steering | Brake Discs, Pads & Calipers | Brake Disc and Pad Kit | false | 65.49 | 100.63 | 24.99 | 0.00 | 0.00 | 0.00 | SureStop Rear Replacement Brake Disc and Pad Kit - 2-Wheel Set, Models With Rear Disc | [{"label":"Location","value":"Rear"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Disc Design","value":"Plain Surface"},{"label":"Warranty","value":"3-year or 36,000-mile limited warranty"},{"label":"Disc Material","value":"Cast Iron"},{"label":"Disc Diameter","value":"11.09 in."},{"label":"Pad Material","value":"OE Replacement"},{"label":"Quantity Sold","value":"2-Wheel Set"},{"label":"Series","value":"SureStop OE Replacement"},{"label":"Interchange Part Number","value":"KOE3128"},{"label":"Disc Hat Finish","value":"Natural - Unplated"},{"label":"Disc Finish","value":"Natural - Unplated"},{"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 Chromium (hexavalent compounds), Lead and lead compounds, Antimony oxide (Antimony trioxide), and Nickel (Metallic), 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"}] |
true | false | [{"year":"2005","make":"Honda","model":"Accord","submodel":"Hybrid","engine":"6 Cyl 3.1L","fnotes":"enginedesignationname: R18Z1, GAS, Sedan"}] | 370 | 2021-08-24 01:51:59 | SureStop | surestop | 3544 | 4 | 2021-08-24 01:54:29 | Brakes, Suspension & Steering | brakes-suspension-and-steering | 143562 | {
"78": {
"category_2.id": 78,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Ball Joints & Components",
"category_2.slug": "ball-joints-and-components",
"category_2.count_parts": 4322,
"category_2.category_3_id": {
"45701334": {
"category_3.id": 45701334,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Ball Joints",
"category_3.slug": "ball-joints",
"category_3.count_parts": 4300
}
}
},
"67": {
"category_2.id": 67,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Brake Discs, Pads & Calipers",
"category_2.slug": "brake-discs-pads-and-calipers",
"category_2.count_parts": 51685,
"category_2.category_3_id": {
"3196": {
"category_3.id": 3196,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Brake Disc and Pad Kit",
"category_3.slug": "brake-disc-and-pad-kit",
"category_3.count_parts": 12852
}
}
}
} |
67 | 2021-08-24 01:56:16 | Brake Discs, Pads & Calipers | brake-discs-pads-and-calipers | 51685 | { "3196": { "category_3.id": 3196, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Brake Disc and Pad Kit", "category_3.slug": "brake-disc-and-pad-kit", "category_3.count_parts": 12852 } } | 3196 | 2021-08-24 01:57:58 | Brake Disc and Pad Kit | brake-disc-and-pad-kit | 12852 |
| 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 |