Automotive Parts Database

Status
Not open for further replies.

chusteczka

Diamond Member
Apr 12, 2006
3,399
3
71
This last month I have been searching for an Auto Parts Database for a specific eCommerce application. Similar to the kind used in Rock Auto's website.

I even emailed and asked Rock Auto if I could purchase their data and they referred me to the Automotive Aftermarket Industry Association. A search through the AAIA website appears unrelated to my needs. Rock Auto appears to be involved with Keystone Automotive as shown by this page.

The database provided on ScrapingWeb does not have the data or database setup that I am looking for. The ScrapingWeb database may be interacted with here. http://www.autopartswar.com/

Does anyone have any experience with or know where an auto parts database may be purchased or leased?

Here is the data that I have found useful. Maybe you know of more possibilities that I have missed.


Google Search - auto parts (data | database)
Google Search - oem engine parts (data | database)


Automotive Aftermarket Industry Association


Database and eCommerce Software Solutions
http://www.motor.com/
http://www.keystoneautomotive.com/
http://www.coresense.com/
http://www.alldata.com/
http://www.activant.com/automotive-aftermarket/
http://www.enigma.com/industries/automotive.cfm


Parts Interchange Database
http://www.interchangeinc.com/
http://hollanderinterchange.net/


Environmental Protection Agency (EPA) Data
Test Car List Data Files (1984 - 2012)
Green Vehicle Guide


Ixvar - CRM Exporter
http://crm-exporter.com/
http://crm-exporter.com/_common/dump_one.sql

Mitchell International - Insurance Automotive Repair data
http://www.mitchell.com/

Jato Dynamics
http://www.jato.com/USA/Pages/Default.aspx


EDIT: Added EPA, Ixvar CRM, Mitchell, and Jato.
 
Last edited:

Raizinman

Platinum Member
Sep 7, 2007
2,355
75
91
meettomy.site
Not exactly sure of what your needs are? Are you looking to create an online database similar to Advance or Auto Zone so that Internet users can look up their own parts? Are you looking to create a database for new or used parts?

Back prior to when computers first got into the auto parts stores, I was involved in putting data from the parts catalogs into computer databases so that auto parts stores would be able to reference and look up parts, as the catalogs were taking up all the counters.
 

chusteczka

Diamond Member
Apr 12, 2006
3,399
3
71
My need is for a very specific subset of an online database for webcustomers to look up their make and model to find the thread size of the drain plug in their vehicle.

At this point, three of the six companies above have informed me they do not carry the data I need. I do have a few paper catalogs that can be used but prefer not to recreate what should be a simple purchase.

It would seem a single company could request, receive, and consolidate all the parts information for the various automotive manufacturers. This seems to be what Motor, Keystone, CoreSense, and AllData have done and I am still waiting to hear from three of them.

Your comment about data entry from parts catalogs confirms suspicions of a lacking common standard for parts databases. There was an initiative in 2009 for development of a standard and free parts database, called Free-Cat.com but this appears to have failed.

A search for this Free-Cat article to reference here, brought up a discussion with some interesting information.


workshop.search-autoparts.com - Discussion - Electronic Catalogs
Electronic catalogs
In recent years, one of the most heated debates has been between paper vs. electronic catalogs. Most realize that the computer is the way of the future, but still cling to their paper catalogs because of the ease of use and the many mistakes that are attributed to e-catalogs. Now, a not-for-profit group backed by a group of eight leading auto parts manufacturers has launched a new method called FreeCat and touted it as a faster, free, comprehensive e-catalog for the aftermarket industry. You'll be hearing more about this in the pages of Aftermarket Business in the future, but for now, what are your thoughts? What does the future of cataloging hold? Would you be willing to give Free-Cat a try?
The next generation
Our current means of distributing application information are by paper catalogs, online manaufacturer website catalogs, and 3rd-party electronic catalogs. Manufacturers would love to get rid of the costly paper catalogs, but they will probably never be entirely gone. Online sites are very helpful as a "final word" on a specific application in a specific product line. But eveyone who sells parts for a living goes first to the comprehensive electronic catalog that is integrated with their point-of-sale system. This option is expensive, both for the users and for the manufacturer, as the 3rd-party data provider extracts payments from both ends. Data can be as much as a year behind, depending on the priorities of the system provider, and the amount of money the manufacturer contributes. The major cataloging providers have a vested interest in the status quo, and big revenue stream to defend. It's a racket, and we users are paying the price.

Is the price too high? That is certainly debatable. Electronic cataloging pays for itself every day. The companies who built the current systems have made our work days a lot more pleasant and efficient. But we have been working that model for decades now, and it's time to move to the next generation.

Ultimately, application information needs to be hosted by each manufacturer on their own systems, and the information updated constantly at the source. The POS system providers and online cataloging sites will privide a custom framework to access each manufacturers data as a seamless catalog much as we see now. Each manufacturer woould be independently responsible for providing accurate and timely data for their line, via secure internet access through the POS/cataloging software. The linkage would be transparent to the user at the counter. Each electronic catalog provider would still differentiate their POS product by the quality of the user interface, but the data would be the same for all players. This would eliminate the long waits - and large fees - for data to be entered and checked by the 3rd party company The result will be the best possible data set for the resellers, at far less cost.

We need to get there, and we are already way behind. The ACES & PIES standards are a big step toward that. The first vertical market IT provider who pulls this together will hit a home run, and we will be better off as an industry when it happens.

A consolidated auto parts electronic database appears to be a niche business opportunity but will unfortunately depend on the individual auto manufacturers.


Here is a discussion thread with a large list of URL's.
Parts Plus - Manufacturer Link & Online Catalogs
 

jargoncherry

Junior Member
Jun 13, 2012
1
0
0
Any update on this? We are also looking for data similar to @chusteczka. Any leads appreciated. Thanks much
 

chusteczka

Diamond Member
Apr 12, 2006
3,399
3
71
Ixvar - CRM Exporter
http://crm-exporter.com/
http://crm-exporter.com/_common/dump_one.sql

Mitchell International - Insurance Automotive Repair data
http://www.mitchell.com/

Jato Dynamics
http://www.jato.com/USA/Pages/Default.aspx


As a followup, it seems that my data needs are not large enough to require a full database and the few that I did contact, did not have the specific data that I needed. Also, it seems the EPA data may actually fulfill my specific needs when combined with the data I have already developed.
 
Last edited:

taptun

Junior Member
Aug 22, 2012
1
0
0
This last month I have been searching for an Auto Parts Database for a specific eCommerce application. Similar to the kind used in Rock Auto's website.

I even emailed and asked Rock Auto if I could purchase their data and they referred me to the Automotive Aftermarket Industry Association. A search through the AAIA website appears unrelated to my needs. Rock Auto appears to be involved with Keystone Automotive as shown by this page.

The database provided on ScrapingWeb does not have the data or database setup that I am looking for. The ScrapingWeb database may be interacted with here. http://www.autopartswar.com/

Does anyone have any experience with or know where an auto parts database may be purchased or leased?

Here is the data that I have found useful. Maybe you know of more possibilities that I have missed.


Google Search - auto parts (data | database)
Google Search - oem engine parts (data | database)


Automotive Aftermarket Industry Association


Database and eCommerce Software Solutions
http://www.motor.com/
http://www.keystoneautomotive.com/
http://www.coresense.com/
http://www.alldata.com/
http://www.activant.com/automotive-aftermarket/
http://www.enigma.com/industries/automotive.cfm


Parts Interchange Database
http://www.interchangeinc.com/
http://hollanderinterchange.net/


Environmental Protection Agency (EPA) Data
Test Car List Data Files (1984 - 2012)
Green Vehicle Guide


Ixvar - CRM Exporter
http://crm-exporter.com/
http://crm-exporter.com/_common/dump_one.sql

Mitchell International - Insurance Automotive Repair data
http://www.mitchell.com/

Jato Dynamics
http://www.jato.com/USA/Pages/Default.aspx


EDIT: Added EPA, Ixvar CRM, Mitchell, and Jato.

Hi

My name is Alexey and I have read your post regarding e-commerce catalog and to tell you the truth I am looking for the integrated parts website also. I am out in Russia and such a website would be a great business opportunity. For now I am not able to figure out who is the affiliate or dropship provider for hundreds of similar websites that offer parts on the net. Have you solved this?
I did some extensive research but it seem that the source is very well hidden by most of the sites. But still it is very apparent that they are all linked to the same source, since functionality, navigation, pricing, and images are exactly the same. Seems that most of these sites are prebuilt and have API integration but to whom? that is the question.
There are amazon and comission junction affiliate providers, but what they do is redirect traffic via links and banners, where auto parts websites keep customers in the same place.

Would you mind sharing your discoveries?
I would greatly appreciate it, besides that I am also looking for help in US. Given that I am in Russia, it is hard to find a store that ships parts to Russia at reasonable cost. When we talking about large quantities, I have a cargo service that does the shipping for me, but when it comes to small orders then there is a problem. This could be a good opportunity, given that the e-commerce catalog is discovered and hopefully works as affiliate or dropship.

Thank you
 

chusteczka

Diamond Member
Apr 12, 2006
3,399
3
71
Everything I am aware of has been added to the first post here in this thread.

Personally, I have actually stopped pursuing this investigation since my basic, limited, and highly specific need for the engine oil drain plug size has been fulfilled.

Other people are free to add more information as they need.

The primary solutions appear to be motor.com, KeystoneAutomotive.com, CoreSense.com, AllData.com, Activant.com, and Enigma.com as listed above.

With you being in Russia, you will also need access to the European cars, such as Citroen and others that may not be available here in America.
 

ajmax2013

Junior Member
Feb 24, 2013
2
0
0
Hello guys
I am not sure if you guys stopped researching or you already have found what you wear looking for but I fount something interesting from here
https://forums.digitalpoint.com/thr...ypes-240k-photos-279-brands-120-make.1504188/

http://www.scrapingweb.com/databases/autoparts-database.html

I am not defiantly reseller or any relation with the seller, I am looking for same Scorsese to implement car parts lockup in my own website, I was wondering if you guys already know these links and have any experience with, would you recommend to buy ?
regards
AJ
 

NewTechTester

Banned
Apr 27, 2013
1
0
0
Chusteczka,

Were you able to find what you were looking for. How much do you think this kind of database would worth?
 

JonThanx

Banned
Jun 14, 2013
1
0
0
Hello,

I work for a company who focuses on helping eCommerce companies acquire product information similar to what you're describing.

However, our business model is not to purchase a pool of data. We offer an automated software which allows customers to acquire the product information directly from a manufacturer without any hassle.

We do have several companies in the automotive space, and you could check out our website to learn more
Thanx!
Jon
 
Last edited by a moderator:

Yinxie

Banned
Jul 20, 2013
1
0
0
Hi guys,

I am a new member of the forum and I have the same need as Alexey in Russia. I am based in Nigeria and I would like to avail myself of the same opportunities that the database will provide. Please have you been able to move forward on this? I will appreciate any update.

Regards,

Yinka
 
Status
Not open for further replies.