
Product Attribute database (PAdb)
The Product Attribute database (PAdb) is a fully normalized, relational database, that is used in conjunction with the Product Information Exchange Standard (PIESTM).
The PAdb contains product specific attributes (aka product specifications), including performance and physical attributes, which describe the form, fit and function of a product and standardizes it in a coded manner.
Talk to an Expert
Book a meeting with one of our experts for a free consultation on Data Standards, TrendLens, Demand Index, Data Standards API, or Catalog Assessment.
Book NowPAdb attributes are assigned to each product classification found in the Product Classification database (PCdb). PAdb attributes are assigned to each product classification found in the Product Classification database (PCdb).
0.0+ thousand
part attributes tied to
0.0+ thousand
part attribute associations
The standardization of product attribute information allows for this type of information to move efficiently and consistently across the industry.
Some examples of PAdb attributes include:Some examples of PAdb attributes include:
- Color
- Finish
- Material
- Outside Diameter
- Port Quantity
- Horsepower
Rich, complete, and accurate product attribute information is an essential component of marketing any product successfully. All customers, professional shop and retail consumers, rely on robust product attributes to make informed decisions and select the most appropriate product for their needs. Performance and physical attributes address the objective differences between two similar products. This information enables customers to make informed and knowledgeable decisions, and be fully aware of the differences between similar products.
The industry use of the Product Attribute database (PAdb) promotes increased speed to market for manufacturers and their trading partners who use the ACES® and PIESTM data standards, as it makes it easier to compile and display product content for web catalogs, websites and internal systems. Additionally, the PAdb promotes a positive user experience for consumers and allows consumers to compare products in their searches due to the information being displayed in a consistent manner.
Learn more aboutLearn more about
The Product Attribute database (PAdb) documentation found below is the latest version of the database documentation. This version, and all versions, are designed and maintained by the industry, for the industry, through industry
workgroups and the guidance of the Technology Standards Committee (TSC).
Data Rules and Policies
ER Diagram
Note: Our documentation is available to the public. To view and download documentation, please sign-in with your autocare.org login information to the Auto Care Digital Hub. If you do not have a login, please create an account.
DownloadDownload
The Product Attribute database (PAdb) and all other ACES® and PIESTM data standards supporting relational databases, can be managed and downloaded through the Auto Care Vehicle Information Portal (VIP).
The VIP platform allows users to view the contents of the PAdb, submit changes to existing records, request new records, as well as download the published database.
Publication Cycle (New Database Content Updates):
- Monthly (Manual Downloads - JSON, Access 2007, SQLServer2008 R2)
- Daily (API - JSON)
Release Notes: Click here
The Product Attribute database (PAdb) requires an annual paid subscription to view and download.
Note: Access to the VIP site does not require a paid active subscription. However, access to certain products within the site will require an active paid subscription. To access the VIP site, users are required to create an autocare.org account. Click here to create an account.
Frequently Asked QuestionsFrequently Asked Questions
SubscribeSubscribe
Ready to create and/or receive PIESTM XML files for your products?
STEP 1 | Subscribe to Reference Databases | |||
STEP 2 | Download Documentation | |||
STEP 3 | Create and/or receive PIESTM XML files for your products! |
Convenient, self-paced eLearning to help your more effectively communicate with your trading partners.
Data Standards eLearning from Auto Care helps aftermarket professionals learn how to use the data standards to speak the same technical language as their customers, getting the right part, to the right place, at the right time.
What’s New in PAdbWhat’s New in PAdb
Translations covering North, South and Central America are now available!
Auto Care Association offers translations for the data standards supporting databases (VCdb, Qdb, PCdb and PAdb) in the following languages:
- Spanish
- Canadian French
- Portuguese
Subscribing to these translation databases provides users the ability to easily translate the coded content within an ACES or PIES XML file.
Visit the subscriptions page to subscribe!
Heavy Duty Expansion
The Product Information Exchange Standard (PIES) was recently expanded for the heavy duty industry, as a result of an industry project managed by the Auto Care Association Community, HDDA: Heavy Duty, beginning with PIES Version 7.1 and newer.
This expansion included the addition of heavy duty fields into the PIES data standard, as well as the addition of product attributes in the Product Attribute database (PAdb)* for 20 product categories of heavy duty products found in the Product Classification database (PCdb), which are both utilized in the PIES data standard.
Heavy Duty companies can now use the PIES data standard to communicate their product information to their trading partners!