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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
381 | 2021-08-16 23:54:32 | P15TDBK7347 | TDBK7347 | <p><strong>POWERSTOP TRACK DAY BRAKE DISC AND PAD KIT</strong></p><p>For the enthusiast who spends weekends at the track, PowerStop has engineered a powerful combination of carbon fiber-metallic Track Day brake pads and uniquely formulated Track Day Hi-Carbon brake discs. The Track Day brake pads are designed to bite when cold and get stronger as temperatures rise, while the Hi-Carbon brake discs create more friction while also resisting warping and cracking under high heat conditions. PowerStop Extreme Performance Brake Systems, a team with over 200 years of combined automotive experience, is a world-renowned leader in brake technology and product development.</p><ul><li>Rigorously tested on the track to ensure performance</li><li>Pad compound made from unique carbon fiber-metallic formula</li><li>High-carbon metal formula less prone to deformation and cracking</li><li>Slots wipe debris from pads, holes circulate cooling air</li><li>Less vibration due to precision machining and mill balancing</li><li>Strong bite when cold, braking power increases as temperatures rise</li><li>Brake pedal is easy to modulate, feel is exceptional</li></ul> |
Brake Disc and Pad Kit | Powerstop | Brakes, Suspension & Steering | Brake Discs, Pads & Calipers | Brake Disc and Pad Kit | false | 134.00 | 197.35 | 39.99 | 0.00 | 0.00 | 0.00 | Powerstop Front Brake Disc and Pad Kit - Track Day Performance 2-Wheel Set | [{"label":"Location","value":"Front"},{"label":"Recommended Use","value":"Performance Replacement"},{"label":"Disc Design","value":"Plain Surface"},{"label":"Warranty","value":"3-year \u002F 36000-mile Powerstop limited warranty"},{"label":"Pad Material","value":"Ceramic"},{"label":"Quantity Sold","value":"2-Wheel Set"},{"label":"Includes","value":"Powerstop Autospecialty Rotors And Powerstop Track Day Brake Pads"},{"label":"Series","value":"Track Day"}] |
true | false | [{"year":"2019","make":"Honda","model":"Civic","submodel":"Si","engine":"4 Cyl 1.5L","fnotes":"enginedesignationname: L15B7"}] | 371 | 2021-08-24 01:51:59 | Powerstop | powerstop | 23183 | 4 | 2021-08-24 01:54:29 | Brakes, Suspension & Steering | brakes-suspension-and-steering | 143562 | {
"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 |
382 | 2021-08-16 23:54:32 | P15TDSK3128 | TDSK3128 | <p><strong>POWERSTOP TRACK DAY SPEC BRAKE DISC AND PAD KITS </strong></p><p>Replacing brakes is a big investment, especially if you strictly use your car on the track. But if you choose a Track Day Spec brake disc and pad kit by PowerStop, you’ll get longer life out of your pads and rotors – without going broke. PowerStop Extreme Performance Brake Systems, a team with over 200 years of combined automotive experience, is a world-renowned leader in brake technology and product development.</p><ul><li>Special formula preserves rotors and expands the life of your pads (Hi-Carbon Track Day discs and Track Day Spec pads included)</li><li>Track-tested to ensure optimum performance</li><li>Offers fantastic pedal response</li><li>Designed specifically for track-only race cars</li><li>Metallic/carbon fiber formulation maximizes friction and reduces wear of rotors</li><li>Rotors crafted to resist warping and deliver ultimate dependability</li></ul> |
Brake Disc and Pad Kit | Powerstop | Brakes, Suspension & Steering | Brake Discs, Pads & Calipers | Brake Disc and Pad Kit | false | 115.99 | 193.02 | 8.99 | 0.00 | 0.00 | 0.00 | Powerstop Rear Brake Disc and Pad Kit - Track Day Spec Performance 2-Wheel Set | [{"label":"Location","value":"Rear"},{"label":"Recommended Use","value":"Track\u002Fracing"},{"label":"Disc Design","value":"Plain Surface"},{"label":"Warranty","value":"3-year \u002F 36000-mile Powerstop limited warranty"},{"label":"Disc Diameter","value":"11.08 in."},{"label":"Pad Material","value":"Ceramic"},{"label":"Quantity Sold","value":"2-Wheel Set"},{"label":"Includes","value":"Powerstop Autospecialty Rotors And Powerstop Track Day Spec Brake Pads"},{"label":"Series","value":"Track Day Spec"},{"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 Arsenic, Chromium (Hexavalent compounds), Lead, Nickel, Cobalt and Antimony Trioxide, 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":"Notes","value":"Solid Disc Construction; Includes Pad Shims"}] |
true | false | [{"year":"2005","make":"Honda","model":"Accord","submodel":"Hybrid","engine":"6 Cyl 3.1L","fnotes":"FWD"}] | 371 | 2021-08-24 01:51:59 | Powerstop | powerstop | 23183 | 4 | 2021-08-24 01:54:29 | Brakes, Suspension & Steering | brakes-suspension-and-steering | 143562 | {
"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 |
383 | 2021-08-16 23:54:32 | REPA762109 | REPA762109 | <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 Reinforcement | Replacement | Exterior Accessories | Bumpers & Components | Bumper Reinforcement | false | 76.53 | 262.28 | 14.62 | 0.00 | 0.00 | 0.00 | Rear Bumper Reinforcement | [{"label":"Location","value":"Rear"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Replaces OE Number","value":"71530TX6A00"},{"label":"Material","value":"Steel"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Interchange Part Number","value":"71530TX6A00, AC1106136"},{"label":"Replaces Partslink Number","value":"AC1106136"}] |
true | false | [{"year":"2013","make":"Acura","model":"ILX","submodel":"Dynamic","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": {
"4409": {
"category_3.id": 4409,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Reinforcement",
"category_3.slug": "bumper-reinforcement",
"category_3.count_parts": 1039
}
}
},
"115": {
"category_2.id": 115,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Fog Lights, Driving Lights, Components & Accessories",
"category_2.slug": "fog-lights-driving-lights-components-and-accessories",
"category_2.count_parts": 2477,
"category_2.category_3_id": {
"5249": {
"category_3.id": 5249,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Fog Lights & Components",
"category_3.slug": "fog-lights-and-components",
"category_3.count_parts": 2323
}
}
}
} |
112 | 2021-08-24 01:56:16 | Bumpers & Components | bumpers-and-components | 18381 | { "4409": { "category_3.id": 4409, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Bumper Reinforcement", "category_3.slug": "bumper-reinforcement", "category_3.count_parts": 1039 } } | 4409 | 2021-08-24 01:57:58 | Bumper Reinforcement | bumper-reinforcement | 1039 |
384 | 2021-08-16 23:54:32 | REPA107901 | REPA107901 | <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> |
Fog Light | Replacement | Exterior Accessories | Fog Lights, Driving Lights, Components & Accessories | Fog Lights & Components | false | 69.34 | 165.55 | 9.99 | 0.00 | 0.00 | 0.00 | Fog Light Assembly - Driver or Passenger Side | [{"label":"Location","value":"Front, Driver or Passenger Side"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"33900T0AA01"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Assembly","value":"With bulb(s)"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Interchange Part Number","value":"33900T0AA01, AC2592111"},{"label":"Replaces Partslink Number","value":"AC2592111"}] |
true | false | [{"year":"2010","make":"Acura","model":"RDX","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": {
"4409": {
"category_3.id": 4409,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Reinforcement",
"category_3.slug": "bumper-reinforcement",
"category_3.count_parts": 1039
}
}
},
"115": {
"category_2.id": 115,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Fog Lights, Driving Lights, Components & Accessories",
"category_2.slug": "fog-lights-driving-lights-components-and-accessories",
"category_2.count_parts": 2477,
"category_2.category_3_id": {
"5249": {
"category_3.id": 5249,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Fog Lights & Components",
"category_3.slug": "fog-lights-and-components",
"category_3.count_parts": 2323
}
}
}
} |
115 | 2021-08-24 01:56:16 | Fog Lights, Driving Lights, Components & Accessories | fog-lights-driving-lights-components-and-accessories | 2477 | { "5249": { "category_3.id": 5249, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Fog Lights & Components", "category_3.slug": "fog-lights-and-components", "category_3.count_parts": 2323 } } | 5249 | 2021-08-24 01:57:58 | Fog Lights & Components | fog-lights-and-components | 2323 |
385 | 2021-08-16 23:54:32 | SET-REPA107901-2 | SET-REPA107901-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> |
Fog Light | Replacement | Exterior Accessories | Fog Lights, Driving Lights, Components & Accessories | Fog Lights & Components | false | 131.75 | 342.76 | 11.83 | 0.00 | 0.00 | 0.00 | Fog Light Assembly - Driver and Passenger Side | [{"label":"Location","value":"Front, Driver and Passenger Side"},{"label":"Recommended Use","value":"OE Replacement"},{"label":"Replaces OE Number","value":"33900T0AA01"},{"label":"Returns Policy","value":"90-Day Return Policy"},{"label":"Components","value":"(2) Fog Lights"},{"label":"Assembly","value":"With bulb(s)"},{"label":"Warranty","value":"1-year Replacement unlimited-mileage warranty"},{"label":"Quantity Sold","value":"Set of 2"},{"label":"Interchange Part Number","value":"33900T0AA01, AC2592111"},{"label":"Replaces Partslink Number","value":"AC2592111"}] |
true | false | [{"year":"2010","make":"Acura","model":"RDX","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": {
"4409": {
"category_3.id": 4409,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Bumper Reinforcement",
"category_3.slug": "bumper-reinforcement",
"category_3.count_parts": 1039
}
}
},
"115": {
"category_2.id": 115,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Fog Lights, Driving Lights, Components & Accessories",
"category_2.slug": "fog-lights-driving-lights-components-and-accessories",
"category_2.count_parts": 2477,
"category_2.category_3_id": {
"5249": {
"category_3.id": 5249,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Fog Lights & Components",
"category_3.slug": "fog-lights-and-components",
"category_3.count_parts": 2323
}
}
}
} |
115 | 2021-08-24 01:56:16 | Fog Lights, Driving Lights, Components & Accessories | fog-lights-driving-lights-components-and-accessories | 2477 | { "5249": { "category_3.id": 5249, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Fog Lights & Components", "category_3.slug": "fog-lights-and-components", "category_3.count_parts": 2323 } } | 5249 | 2021-08-24 01:57:58 | Fog Lights & Components | fog-lights-and-components | 2323 |
386 | 2021-08-16 23:54:32 | GPD6513285 | 6513285 | *-*-* | A/C Compressor | GPD | Engine & Drivetrain | Heating, Air Conditioning & Components | A/C Clutches, Compressors & Components | false | 183.47 | 258.02 | 13.99 | 0.00 | 0.00 | 0.00 | A/C Compressor, Sold individually | [{"label":"Condition","value":"New"},{"label":"Warranty","value":"1-year limited warranty"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Numberof Grooves","value":"7-Groove Pulley"},{"label":"Clutch Included","value":"With clutch"}] | true | false | [{"year":"2015","make":"Honda","model":"CR-V","submodel":"Touring","engine":"4 Cyl 2.4L","fnotes":"TRSE09"}] | 386 | 2021-08-24 01:51:59 | GPD | gpd | 13347 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"49": {
"category_2.id": 49,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Heating, Air Conditioning & Components",
"category_2.slug": "heating-air-conditioning-and-components",
"category_2.count_parts": 26049,
"category_2.category_3_id": {
"5563": {
"category_3.id": 5563,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "A/C Clutches, Compressors & Components",
"category_3.slug": "a-c-clutches-compressors-and-components",
"category_3.count_parts": 9614
}
}
},
"52": {
"category_2.id": 52,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Cranks, Pistons, Oil & Components",
"category_2.slug": "cranks-pistons-oil-and-components",
"category_2.count_parts": 14558,
"category_2.category_3_id": {
"5178": {
"category_3.id": 5178,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Oiling System",
"category_3.slug": "oiling-system",
"category_3.count_parts": 4429
}
}
}
} |
49 | 2021-08-24 01:56:16 | Heating, Air Conditioning & Components | heating-air-conditioning-and-components | 26049 | { "5563": { "category_3.id": 5563, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "A/C Clutches, Compressors & Components", "category_3.slug": "a-c-clutches-compressors-and-components", "category_3.count_parts": 9614 } } | 5563 | 2021-08-24 01:57:58 | A/C Clutches, Compressors & Components | a-c-clutches-compressors-and-components | 9614 |
387 | 2021-08-16 23:54:32 | GPD9642515 | 9642515 | <p><b>GPD A/C SERVICE KITS</b></p><p>These are highly quality engineered GPD’s OE replacement A/C service kits to meet OE quality and performance standards.</p><p>Kit component parts:</p><ul><li>(1) A/C Compressor</li><li>(1) A/C Accumulator</li><li>(1) A/C Orifice Tube</li><li>(1) A/C O-Ring and Gasket Seal Kit</li></ul> | A/C Compressor | GPD | Engine & Drivetrain | Heating, Air Conditioning & Components | A/C Clutches, Compressors & Components | false | 223.02 | 311.57 | 8.99 | 0.00 | 0.00 | 0.00 | A/C Compressor Kit, Includes (1) A/C Compressor, (1) A/C Accumulator, (1) A/C Orifice Tube, (1) A/C O-Ring and Gasket Seal Kit | [{"label":"Notes","value":"Kit component parts: (1) A\u002FC Compressor, (1) A\u002FC Accumulator, (1) A\u002FC Orifice Tube, (1) A\u002FC O-Ring and Gasket Seal Kit"},{"label":"Condition","value":"New"},{"label":"Clutch Included","value":"With clutch"},{"label":"Number of Grooves","value":"7-Groove Pulley"},{"label":"Quantity Sold","value":"Kit"},{"label":"Warranty","value":"1-year limited warranty"}] |
false | false | [{"year":"2017","make":"Acura","model":"ILX","submodel":"Base","engine":"4 Cyl 2.4L","fnotes":"TRSE09"}] | 386 | 2021-08-24 01:51:59 | GPD | gpd | 13347 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"49": {
"category_2.id": 49,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Heating, Air Conditioning & Components",
"category_2.slug": "heating-air-conditioning-and-components",
"category_2.count_parts": 26049,
"category_2.category_3_id": {
"5563": {
"category_3.id": 5563,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "A/C Clutches, Compressors & Components",
"category_3.slug": "a-c-clutches-compressors-and-components",
"category_3.count_parts": 9614
}
}
},
"52": {
"category_2.id": 52,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Cranks, Pistons, Oil & Components",
"category_2.slug": "cranks-pistons-oil-and-components",
"category_2.count_parts": 14558,
"category_2.category_3_id": {
"5178": {
"category_3.id": 5178,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Oiling System",
"category_3.slug": "oiling-system",
"category_3.count_parts": 4429
}
}
}
} |
49 | 2021-08-24 01:56:16 | Heating, Air Conditioning & Components | heating-air-conditioning-and-components | 26049 | { "5563": { "category_3.id": 5563, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "A/C Clutches, Compressors & Components", "category_3.slug": "a-c-clutches-compressors-and-components", "category_3.count_parts": 9614 } } | 5563 | 2021-08-24 01:57:58 | A/C Clutches, Compressors & Components | a-c-clutches-compressors-and-components | 9614 |
388 | 2021-08-16 23:54:32 | HENH97W05 | H97W05 | <p><strong>HENGST OE REPLACEMENT OIL FILTER</strong></p><p>Constructed with service-friendly, robust materials for optimal filtration and long product life, Hengst OE Replacement oil filter delivers reliable protection against engine contaminants. It facilitates proper lubrication of moving parts and provides clean oil supply to engine components.</p><ul><li>Resistant to pressure of up to 20 bar and withstands temperature of up to 160°C</li><li>Extremely durable design with replaceable filter insert</li><li>Effectively removes metal abrasions, dust and other residues down to 10 μm (0.01 mm)</li><li>Offers clean oil supply to minimize emissions and fuel consumption</li><li>Prevents premature wear of engine components</li></ul><p>Founded in 1958, Hengst is a world-renowned manufacturer of top-quality filtration products for marine applications, agricultural equipment and passenger cars.</p> |
Oil Filter | Hengst | Engine & Drivetrain | Cranks, Pistons, Oil & Components | Oiling System | false | 8.49 | 0.00 | 8.99 | 0.00 | 0.00 | 0.00 | Oil Filter - Spin-on, Direct Fit, Sold individually | [{"label":"Recommended Use","value":"OE Replacement"},{"label":"Warranty","value":"24-month or 24,000-mile limited warranty"},{"label":"Product Fit","value":"Direct Fit"},{"label":"Quantity Sold","value":"Sold individually"},{"label":"Type","value":"Spin-on"}] | true | false | [{"year":"1997","make":"Ford","model":"Probe","submodel":"GT","engine":"6 Cyl 2.5L","fnotes":"Eng. VIN: B, Spin-On"}] | 1 | 2021-08-24 01:51:59 | Hengst | hengst | 486 | 3 | 2021-08-24 01:54:29 | Engine & Drivetrain | engine-and-drivetrain | 188010 | {
"49": {
"category_2.id": 49,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Heating, Air Conditioning & Components",
"category_2.slug": "heating-air-conditioning-and-components",
"category_2.count_parts": 26049,
"category_2.category_3_id": {
"5563": {
"category_3.id": 5563,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "A/C Clutches, Compressors & Components",
"category_3.slug": "a-c-clutches-compressors-and-components",
"category_3.count_parts": 9614
}
}
},
"52": {
"category_2.id": 52,
"category_2.ts": "2021-08-24 01:56:16",
"category_2.title": "Cranks, Pistons, Oil & Components",
"category_2.slug": "cranks-pistons-oil-and-components",
"category_2.count_parts": 14558,
"category_2.category_3_id": {
"5178": {
"category_3.id": 5178,
"category_3.ts": "2021-08-24 01:57:58",
"category_3.title": "Oiling System",
"category_3.slug": "oiling-system",
"category_3.count_parts": 4429
}
}
}
} |
52 | 2021-08-24 01:56:16 | Cranks, Pistons, Oil & Components | cranks-pistons-oil-and-components | 14558 | { "5178": { "category_3.id": 5178, "category_3.ts": "2021-08-24 01:57:58", "category_3.title": "Oiling System", "category_3.slug": "oiling-system", "category_3.count_parts": 4429 } } | 5178 | 2021-08-24 01:57:58 | Oiling System | oiling-system | 4429 |
389 | 2021-08-16 23:54:32 | W24444921 | 444921 | <p><strong>WEATHERTECH DIGITALFIT FLOOR LINERS</strong></p><p>Manufactured from sophisticated thermoplastics, WeatherTech’s DigitalFit floor liners protect carpeted areas as well as a person’s feet and clothes from spills, debris and dirt. WeatherTech, the leading manufacturer of direct fit floor liners and functional automotive accessories, was recently recognized by the International Automotive Task Force (IATF) for its excellent quality practices.</p><ul><li>Protects the entire selected floor area</li><li>Channels allow snow, mud, dirt and liquids to filter down, away from feet</li><li>Pleasant-touch top surface</li><li>Bottom surface design keeps liner from moving</li><li>Patented heavy-duty thermoplastic composition</li><li>Easy to empty and hose or wipe off</li><li>Fits perfectly by vehicle year, make and model</li><li>100% made in the USA</li><li>Available in grey, tan or black for front, middle or third row seating areas</li></ul> |
Floor Mats | Weathertech | Interior Accessories | Floor Mats & Liners | Floor Mats | false | 127.95 | 127.95 | 0.00 | 0.00 | 0.00 | 0.00 | Black Floor Mats, Front Row | [{"label":"Location","value":"Front Row"},{"label":"Warranty","value":"Lifetime Weathertech limited warranty"},{"label":"Material","value":"Made of Thermoplastic"},{"label":"Quantity Sold","value":"2 Pieces"},{"label":"Series","value":"DigitalFit 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":"Color Finish","value":"Black"}] |
true | false | [{"year":"2013","make":"Acura","model":"ILX","submodel":"All Submodels","engine":"All Engines","fnotes":""}] | 13 | 2021-08-24 01:51:59 | Weathertech | weathertech | 15192 | 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 |
390 | 2021-08-16 23:54:32 | W24444922 | 444922 | <p><strong>WEATHERTECH DIGITALFIT FLOOR LINERS</strong></p><p>Manufactured from sophisticated thermoplastics, WeatherTech’s DigitalFit floor liners protect carpeted areas as well as a person’s feet and clothes from spills, debris and dirt. WeatherTech, the leading manufacturer of direct fit floor liners and functional automotive accessories, was recently recognized by the International Automotive Task Force (IATF) for its excellent quality practices.</p><ul><li>Protects the entire selected floor area</li><li>Channels allow snow, mud, dirt and liquids to filter down, away from feet</li><li>Pleasant-touch top surface</li><li>Bottom surface design keeps liner from moving</li><li>Patented heavy-duty thermoplastic composition</li><li>Easy to empty and hose or wipe off</li><li>Fits perfectly by vehicle year, make and model</li><li>100% made in the USA</li><li>Available in grey, tan or black for front, middle or third row seating areas</li></ul> |
Floor Mats | Weathertech | Interior Accessories | Floor Mats & Liners | Floor Mats | false | 94.95 | 94.95 | 0.00 | 0.00 | 0.00 | 0.00 | Black Floor Mats, Second Row | [{"label":"Location","value":"Second Row"},{"label":"Warranty","value":"Lifetime Weathertech limited warranty"},{"label":"Material","value":"Made of Thermoplastic"},{"label":"Quantity Sold","value":"1 Piece"},{"label":"Series","value":"DigitalFit 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":"Color Finish","value":"Black"}] |
true | false | [{"year":"2013","make":"Acura","model":"ILX","submodel":"All Submodels","engine":"All Engines","fnotes":""}] | 13 | 2021-08-24 01:51:59 | Weathertech | weathertech | 15192 | 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 |
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 |