fbpx

Data Processing

I am writing this guide as I am learning this product data and vehicle fitment world. I started down this rabbit hole and there is a never-ending learning curve. I hope that this will help you cut through some of the BS and get right to the tools you need. Three users could be helped here manufacturers, Distributors, and Resellers. I don’t know much about the info that Distributors would need but I would guess it is similar to Resellers. This guide is mainly for the Performance Aftermarket parts, OE Replacement Aftermarket parts is a whole different can of worms, although they have a lot of similar needs.

Data Standardization is done by AutoCare Association – https://www.autocare.org/ they are the association that created and manages the ACES and PIES Standards

 

Terms

Fitment:

What vehicles each part is made to fit on.

ACES:

The standard data format for product vehicle fitment data. Standardize by AutoCare Association, it stands for Aftermarket Catalog Exchange Standard. ACES Standards are basically data files that contain the vehicle aftermarket part numbers and the vehicles that those part numbers fit. No product data is provided with ACES.

PIES:

The standard data format for product information like description, attributes, measurements, and more. Standardize by AutoCare Association, it stands for Product Information Exchange Standard. PIES Standards are basically data file that contains all the information about vehicle aftermarket parts. Unless in a flat format it is mostly unreadable by humans and must be processed by software to be used on any eCommerce or Catalog system.

API:

Is a digital handshake and communication between software that allows websites to talk to other websites and databases. It stands for Application Programming Interface.

CSV:

A raw spreadsheet format that can be used in any spreadsheet software. Stands for Comma-separated values.

Flat CSV or excel:

For this article and from what I have found in the automotive industry, this term means a file that has all the product information and data on one row of a spreadsheet.

eCommerce Platforms:

WordPress/WooCommerce:

WordPress is an open-source software to build websites and the plugin WooCommerce is the shopping cart and catalog software built for it. It is the cheapest eCommerce option and can be difficult to manage. However, it also allows the most freedom and editability with the most 3rd party plugin and developer network. This is what I use as I am on a shoestring budget and I don’t like to be limited by the platform.

Data Importing/exporting via flat CSV

Shopify

Very popular, very editable, very secure eCommerce platform. This is the solution for 90% of small to medium businesses out there. I have not personally used this platform but know many who have. Your monthly fees can start to add up because of several of its feature costs per-month. It can remove some of the development and testing headaches that come with WordPress but you pay for that.

Data Importing/exporting via flat CSV

Volusion:

I don’t know much about Volusion. From what I understand it is a simple drag and drop program. I do know that importing and export product data is from a flat CSV file.

Data Importing/exporting via flat CSV

Joomla:

Open-Source website building software, much smaller than WordPress and such has less 3rd party support and developers. Personality I have never used it and I’m sure it is just like any tool and software. Some guys DeWalt some use Milwaukee, they both get the job done.

Data Importing/exporting via: Unknown at this time

Durpal:

Open-Source website building software, much smaller than WordPress and such has less 3rd party support and developers. Personality I have never used it and I’m sure it is just like any tool and software. Some guys DeWalt some use Milwaukee, they both get the job done.

Data Importing/exporting via: Unknown at this time I am going to guess Flat CSV as this is the platform ASAP Network uses.

Magento:

Very popular with developers as if you know how to code it is a very powerful platform, great for large stores. It is open-source code but there is a cost to use the platform and you have to request a demo to get accurate pricing.

Data Importing/exporting via: Unknown at this time

BigCommerce:

Another very popular option for large eCommerce stores. It is also popular with developers who can control the coding. It can quickly get expensive as if you want product filtering that automatically bumps you up to $300 a month. Also, the prices can change bases on your sales volume. API connections also just your monthly fee. Many of the plugins are also monthly fees.

Data Importing/exporting via: Unknown at this time

Data Suppliers

Paramount Data Management Inc:

 

https://pdm-automotive.com/

For Resellers:

Free for data receivers. Sign up, request, and download data. Download data in ACES and PIES format. Simple and easy to use back end. No Flat CSV files available.

Images must be downloaded to be uploaded to your website. 

Advantages: One Dashboard for multiple API. Products can be filtered by vehicle, type, and more. 

API: $99 a month

Can also API to SEMA CO-OP and DCI for $10 one fee per brand

For Manufactures:

 

SEMA CO-OP Data:

https://www.semadatacoop.org/

For Resellers:

You don’t need to be a SEMA member to access this data but will cost $100 a month to access data if you are not.

Sign up for an account, request data from manufacturers, and download data to ACES and PIES format. The dashboard is not intuitive and can take a bit of getting used to. They do offer a short training webinar and there are lots of how-to videos.

Images must be downloaded to be uploaded to your website. 

Flat CVS Files are also available for download from some manufactures. 

The WooCommerce Plugin is basically useless as the data cannot be formatted before importation. So, unless you want to use their product title format, info, product categories it will not help you add products to your website. I have not used the Shopify plugin, but I would imagine it would be the same.

API: Yes

For Manufactures: You must be a SEMA member to have your data in their system. They are available to help map your raw data. There are also different price point levels for how your data is stored and accessed.

Catalog Rack by DCI

https://www.catalograck.com/

For Resellers:

Catalog Rack from DCI is free for data receivers, Sign up, request data and download to ACES and PIES data. Flat CSV files available with a $100 monthly subscription.

The dashboard is a simple clickable list and you selected the distributor that you use for each manufacture. 

Images are hosted by manufacturers. 

API:

For Manufactures:

ASAP Network

https://www.asapnetwork.org/

Easiest to read Flat CSV files. They do not offer ACES and PIES data. 

The dashboard is user-friendly to request data from manufactures.

Images are hosted on ASAP network Server.

The only downside is you have to leave the window open as the data is processed to be downloaded, then it will redirect to the processed data download page. If you close the processed data download page it is hard, might not be possible, to find the processed data download page again. 

API:

They have API connection options for a monthly fee based on the number of calls.

Opticat

https://opticat.net/

No downloadable data but working towards supplying “Load Sheet”

API:

Yes

 

Data Processing:

Paramount Data Management Inc.

For Resellers:

PDM Receiver+ program can translate ACES and PIES data from SEMA CO-OP DCI and PDM to one dashboard. It can process the data to API for $99/Monthly and to Excel for an additional $99 a month. The Export Builder Plus (Excel download) program can format that Excel into your format, set fees apply. Each brand from outside PDM is a one time $10 fee.

No Data translation is available.

For Manufactures:

 

Cellacore

 

http://cellacore.com/ – The best system for using data from manufactures. 

For Resellers:

Their Data processing system is call Product Desk and it can help you process any data into a format that is usable for your website. It connects and manages your data via API connection for most eCommerce platforms. The price is $400/month for the first 20,000 products and .02 cents for each additional product. There is also a setup fee based on your needs.

The main advantage of their system is the term translation table. That can help format the supplied product categories and other terms into the product categories and terms you want to use.

For Manufactures: 

They do not map raw data, you can, however, use Product Desk to import data and map it yourself to ACES and PIES or other formats.

 

ASAP Network

https://www.asapnetwork.org/

For Resellers:

There is no data processing offered to reformat the data in their system.

For Manufactures:

They take the raw data from manufactures then format it into a flat CSV file to provide resellers clean data.

Anzael

https://www.anzael.com/

For Resellers:

They can and are willing to build you any tool you want. It can process any data format into any other format you are looking for. 

The VCDB tool can take any PIES and ACES data and convert it into a Flat CSV or any other format required.

For Manufactures:

Anzael will take any product data and map it into the standard ACES and PIES data. They will also take the ACES and PIES you have generated check your data to make sure that it is correctly formatted to PIES and ACES. The azFitment from Anzael tool that can map product fitment data for Amazon, eBay, AutoZone, NewEgg, Wal-Mart, and more. The VCDB tool can take any PIES and ACES data and convert it into a Flat CSV or any other format required.

Vertical Development Inc.

http://www.verticaldev.com/

For Reseller:

No Options

For Manufactures:

Their “vCatalog” will process your raw product data and format it to the ACES and PIES Standard Price is case-by-case with a minimum of $500 per file.

ShowMeTheParts.com is a program that allows distributors to access the manufacturers product data in an easy to use online format that can be searched. The products in their catalog can API connect to your website and allow for Year Make Model lookup or VIN lookup. It can export PIES data into a flat CSV file but will not export ACES data. It is free to lookup parts in the catalog but to API or export data it is a $2,400 annual fee with a one-time setup fee. They mostly deal with OEM Replacement parts but now also have DCI’s Data as well, allowing for some Performance Aftermarket parts. For manufacture to have their parts listed in their catalog it a starting fee of $1,500.

Data Here To There

http://dataheretothere.com/

For Reseller:

Their system can import any data format and process it to be API’s to most eCommerce platforms. Their system has a term translation table. This can help format the supplied product categories and other terms into the product categories and terms you want to use.

They have access to several product databases to allow for quick integration. You must be approved by manufacture to get the data just like all data providers, however you can only get the data if you use their system.

For Manufactures:

They have lots of data mapping and management solutions. 

Parts Hub

https://partshub.com/

For Reseller:

None

For Manufactures:

Allows you to process your product data into ACES and PIES format

Syndigo

Syndigo – https://www.syndigo.com/

They will take your raw product info and build the ACES and PIES data for your products. 

eCat Solution

eCat Solution – https://ecatsolution.com/

They will take your raw product info and build the ACES and PIES data for your products. 

Shopping Cart Elite

Shopping Cart Elite – https://www.shoppingcartelite.com/

Convert any raw data into ACES and PIES, when using their custom website build.

Autology

Autology – http://www.autologydata.com/

Process raw data into ACES and PIES.

Parts Square

Parts Square – https://square.parts/

Raw data to ACES and PIES

Fitment Processing Only

PC Fitment

PC Fitment – https://pcfitment.com/

PC Fitment’s program can help you create and manage your product fitment data and provide a ACES file. They will also submit your data to Amazon for use in the Amazon Parts Finder.

API connection to Big Commerce.

Custom Websites

Auto Parts Shopping Cart

https://www.autopartsshoppingcart.com/

If you cash this is the option to pick. 

This custom website will API connect to SEMA CO-Data, Turn 14, and ASAP network. Hosted on their servers and provides every but the Firewall.

Cellacore

http://cellacore.com/

The best option if you are looking to modify data, or do fancy data filtering

Big Commerce Platform – They can custom build your website to have all kinds of fancy fitment and filtering options for your data. Like engine fitment, advanced fitment to include trim packages, filtering options that change based on the product category, and more. It is hosted and has all the features of Big Commerce.

ASAP Network

https://www.asapnetwork.org/

They also offer turnkey websites built in Drupal that will automatically update when their database is updated. Can only API connect to their data, all others can be uploaded with CSV file if formatted correctly.

Anzael

https://www.anzael.com/

WordPress based eCommerce website but it is a locked out WordPress meaning limited edits to their theme can be made. Only approve plugins can be used. It cannot accept ACES and PIES data.

Frooition

Frooition – https://www.frooition.com/

Recommend website builder of PC Fitment

Shopping Cart Elite

Shopping Cart Elite – https://www.shoppingcartelite.com/

YMM look up with ACES data and integration with SEMA Co-OP and several other brands that they manage. 

Web Shop Manager

Web Shop Manager – https://webshopmanager.com/

Year, Make, Model selection with ACES data

Data connection to SEMA CO-OP and DCI

Parts Square

Parts Square – https://square.parts/

Hosted on their servers. Optional product fulfillment service. Data integration. 

Gravity Shift Digital

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.

Other Tools

iSHOP – From AutoCare Association

This is a service shop program to allow technicians to get the info and parts they need.