Lifetime updates. Come back once in a while to stay updated of new versions of this database.

1985-2021 Auto Parts Catalog Data by Car Make, Year, Model, Trim/Engine & Brand w/ Images

Database Description:

This United States auto parts catalog data set (5th edition, 2021) is comprised of a 13.8 GB database (MySQL or CSV) with 521,648 vehicle car parts of 59 makes from year 1985 to 2021 by 5,698 part categories and 217 manufacturer brands, in 16 related data tables. Media assets are 520,830 high resolution part images (123.2 GB, about 247KB per JPEG image) and 5,336 part category image files.

You can search parts by:

1. Year (37) + Make (1,608) => Model (17,299) => Trim / Submodel (41,064) => Engine (63,076) => Part (521,648)
2. Brand (217) => Part (521,648) 3. Category 1 (8) => Category 2 (158) => Category 3 (5,698) => Part (521,648)

Each part has one or more part numbers (100%), manufacturer number (100%), text description (99.9%), part name (100%), brand (100%), categories 1 / 2 / 3 (100%), list prices (100%), part images (99.8%), part title (99.9%), fit notes (96.8%), and part attributes (99.4%) with 642 unique attributes, of which the most are: Warranty (94.8%), Location (62.0%), Product Fit (51.8%), Series (49.5%), Recommended Use (45.9%), Prop 65 Warning (42.8%), Notes (35.2%), Replaces OE Number (28.7%), Material (25.8%), Type (20.9%), Interchange Part Number (20.7%), Color Finish (19.5%), Returns Policy (19.4%), Condition (15.8%), Replaces Partslink Number (15.1%), Color/Finish (9.6%), Design (9.3%), Components (8.7%), Includes (6.8%).

Each part has a large no-watermark catalog photo picture referenced by part.id to part_image.part_id. Car parts data in the database are organized by car makes, years, models, sub-models / trims, engines and part brands.

Top categories: Auto Body Parts & Mirrors (50,206), Headlights & Lighting (21,442), Engine & Drivetrain (188,010), Brakes, Suspension & Steering (143,562), Interior Accessories (55,935), Exterior Accessories (60,595), Wheels (296), Tools & Garage (1,602).

Sub categories with over 10,000 distinct parts: Brake Discs, Pads & Calipers (51,685), Seats, Seat Covers & Accessories (27,089), Heating, Air Conditioning & Components (26,049), Radiators, Fans, Cooling Systems & Components (19,954), Shocks, Struts & Components (18,820), Bumpers & Components (18,381), Cams, Timing & Valvetrain (17,025), Control Arms, Thrust Arms & Components (16,194), Cranks, Pistons, Oil & Components (14,558), Air Filters & Intake Systems (13,660), Axles, Driveshaft & 4WD (12,316), Fuel Systems & Components (11,607), Exhaust, Headers, Manifolds Mufflers & Components (11,466), Tie Rods, Steering Racks, Gearboxes & Components (10,641)

The 4th and the 3rd edition of this database are also included in the order for you to download after payment.

Database Meta:

  • Size: 13.8 GB + 123.2 GB
  • Images / Multi-media: 520,830 JPEG image files, 123.2 GB. File path: {part_image.path} by {part_image.part_id} to {part.id}
  • Last updated: Aug. 28th, 2021
  • Formats Included: MySQL dump .sql text file, CSV for MS Excel
  • Tables: 16

Buy Now & Download: $659.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: 1985-2021 Auto Parts Catalog Data by Car Make, Year, Model, Trim/Engine & Brand w/ Images for Sale

Table Details (Data Structure / Schema):

  • brand
    Records:217

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. count_parts: int(10) unsigned
  • category_1
    Records:8

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. count_parts: int(10) unsigned
  • category_1_image
    Records:8

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. source_content_type: varchar(255)
    4. hash_file_content: varchar(255)
    5. size: bigint(20) unsigned
    6. path: varchar(2047)
    7. title: varchar(255)
    8. category_1_id: bigint(20) unsigned
  • category_2
    Records:158

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. category_1_id: bigint(20) unsigned
    6. count_parts: int(10) unsigned
  • category_2_image
    Records:145

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. source_content_type: varchar(255)
    4. hash_file_content: varchar(255)
    5. size: bigint(20) unsigned
    6. path: varchar(2047)
    7. title: varchar(255)
    8. category_2_id: bigint(20) unsigned
  • category_3
    Records:5,698

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. category_2_id: bigint(20) unsigned
    6. count_parts: int(10) unsigned
  • category_3_image
    Records:5,183

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. source_content_type: varchar(255)
    4. hash_file_content: varchar(255)
    5. size: bigint(20) unsigned
    6. path: varchar(2047)
    7. title: varchar(255)
    8. category_3_id: bigint(20) unsigned
  • engine
    Records:63,076

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. cylinders: varchar(255)
    4. liter: varchar(255)
    5. year: varchar(255)
    6. make: varchar(255)
    7. model: varchar(255)
    8. submodel: varchar(255)
    9. submodel_id: bigint(20) unsigned
    10. count_parts: int(10) unsigned
  • make
    Records:1,608

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. year: varchar(255)
    6. year_id: bigint(20) unsigned
    7. count_parts: int(10) unsigned
  • model
    Records:17,299

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. year: varchar(255)
    6. make: varchar(255)
    7. make_id: bigint(20) unsigned
    8. count_parts: int(10) unsigned
  • part
    Records:521,648

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. part_number: varchar(255)
    4. manufacturer_number: varchar(255)
    5. description: mediumtext
    6. part_name: varchar(255)
    7. brand: varchar(255)
    8. brand_id: bigint(20) unsigned
    9. category_1: varchar(255)
    10. category_2: varchar(255)
    11. category_3: varchar(255)
    12. category_1_id: bigint(20) unsigned
    13. category_2_id: bigint(20) unsigned
    14. category_3_id: bigint(20) unsigned
    15. is_universal: varchar(255)
    16. price_regular: decimal(10,2) unsigned
    17. price_list: decimal(10,2) unsigned
    18. price_shipping: decimal(10,2) unsigned
    19. price_handling: decimal(10,2) unsigned
    20. price_special: decimal(10,2) unsigned
    21. price_core: decimal(10,2) unsigned
    22. part_title: varchar(255)
    23. part_attributes: mediumtext
    24. is_best_seller: varchar(255)
    25. is_made_to_order: varchar(255)
    26. fit_notes: mediumtext
  • part_image
    Records:520,830

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. source_content_type: varchar(255)
    4. hash_file_content: varchar(255)
    5. size: bigint(20) unsigned
    6. path: varchar(2047)
    7. title: varchar(255)
    8. part_id: bigint(20) unsigned
  • submodel
    Records:41,064

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)
    5. year: varchar(255)
    6. make: varchar(255)
    7. model: varchar(255)
    8. model_id: bigint(20) unsigned
    9. count_parts: int(10) unsigned
  • vehicle
    Records:63,076

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. year: varchar(255)
    4. make: varchar(255)
    5. model: varchar(255)
    6. submodel: varchar(255)
    7. cylinders: varchar(255)
    8. liter: varchar(255)
    9. year_id: bigint(20) unsigned
    10. make_id: bigint(20) unsigned
    11. model_id: bigint(20) unsigned
    12. submodel_id: bigint(20) unsigned
    13. engine_id: bigint(20) unsigned
    14. _url: varchar(255)
    15. count_parts: int(10) unsigned
  • vehicle_x_part
    Records:84,796,836

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. vehicle_id: bigint(20) unsigned
    4. part_id: bigint(20) unsigned
  • year
    Records:37

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. title: varchar(255)
    4. slug: varchar(255)

Buy Now & Download: $659.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • Auto parts inventory management software
  • New & used auto parts online shopping store / affiliate site
  • Aftermarket automobile / automotive related website / wholesale manufacturer
  • Automobile repair service site
  • Automobile information site / community enhancement
  • Auto body parts directory lookup and reference

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.