Overview

The Automotive Warehouse Distributors Association (AWDA) developed a series of "Minimum Common Requirement Specifications" based upon the AAIA's Product Information Exchange Standard (PIES). The AWDA Requirements provide both standardized header names and identification of high-priority fields to populate, that can be delivered by common "Flat File" formats (Tab Separated Values (TSV), Comma Separated Values (CSV), Pipe Separated Values (PSV), or Excel). The complete spec can be viewed at their website: http://www.aftermarket.org/Segments/awda/AWDA-Common-Product-Data-Requirement.


Starter Templates

We have two templates available to get started from scratch. Use the AWDA Excel file for AWDA standard-compliant flat files. Use the Enhanced PIES 6.5 Template to generate a standard-compliant XML file with a richer support for additional XML attributes/fields (product data!).

Minimalist/Conforming AWDA Template File

This is a copy & paste from the AWDA PIES 6.5 Documentation Packet, with a minor number of edits and supplemented with additional comments. The ordering is based upon the standard, as well as the column names. Note: All fields are NOT required, but this is representative of what fields most Warehouse/Distributors look for.

Download Common Requirements AWDA PIES Template

Enhanced PIES 6.5 Template File

This is an enhanced AWDA Template File. Non-Standard AWDA columns are included, as well as initial support for a Product Image in a flat-file format. Important Note: Formatting of the file has been altered, and is NOT compliant with the AWDA column ordering-spec. We have taken liberties to add additional columns, ensure similar columns are now grouped together, and added additional comments to the fields. Based upon initial feedback, we believe this should be an easy, materially comprehensive, and accessible way to generate a PIES 6.5 compliant file with just Excel.

Download Extended AWDA PIES Template


Customizing Existing Templates

Wether you are extending an earlier version of the AWDA Template file, or just using a receiver-custom file format, we support a fairly wide-range of column names. If you don't see a column you need supported, feel free to Contact Us.

Recognized Headers

We have a cheat sheet below for the recognized column headers:

Field ID Field Name Aliases
A23 Brand Owner AAIAID
A52 Price Sheet Number D05
A55 Superseded Price Sheet # Superseded Price Sheet Number
D25 Price Sheet Effective Date A70, Price Sheet Level Effective Date, Price Effective Date
D30 Price Sheet Expiration Date A75, Price Sheet Level Expiration Date
B03 Hazardous Material Flag Y/N Hazardous Material Code (Y/N), Hazardous Indicator
B10 Item Level GTIN Item Level GTIN (UPC), Item UPC (GTIN-14)
B11 Item Level GTIN Qualifier
B15 Part Number Supplier Part Number
B20 AAIA Brand ID Brand AAIAID, Brand ID Number
B25 Brand Label
B27 SubBrand AAIAID
B28 SubBrand Label
B30 ACES Applications Application Flag
B32 Item Quantity Size
B33 Item Quantity Size UOM
B34 Container Type
B35 Quantity Per Application Qualifier
B40 Quantity Per Application
B41 Quantity Per Application UOM
B50 Available Date
B55 Minimum Order Quantity Min Order Qty
B56 Minimum Order Quantity UOM
B60 Product Group Code
B61 Product Sub-Group Code
B62 Product Category Code
B64 Part Type ID Part Terminology ID, AAIA Part Terminology ID, Part Type (AAIA)
C10(ABR) Product Description - Abbreviated - 12 C05 (ABR)
C10(SHO) Product Description - 20 C05 (SHO), Product Description - Short - 20, Short Description, Part Description – Short, Short Description (SHO)
C10(INV) Product Description - 40 C05 (INV), Product Description - Invoice - 40
C10(DEF) AAIA Part Type Description C05 (DEF)
C10(ASC) Associated Comments - 2000 C05 (ASC)
C10(KEY) Key Search Words - 2000 C05 (KEY)
C10(LAB) Label Description - 80 C05 (LAB)
C10(DES) Product Description - 80 C05 (DES), Product Description - Long - 80, Long Description, Part Description – Long, Long Description (DES)
C10(SHP) Shipping Restrictions - 2000 C05 (SHP)
C10(SLA) Slang Restrictions - 2000 C05 (SLA)
C10(UNS) UN/SPSC Description - 80 C05 (UNS)
C10(VMR) VMRS Description C05 (VMR)
C10(ASM) Application Summary C05 (ASM), Application Summary Description, Application Summary - 2000
C10(EXT) Product Description - Extended 240 C05 (EXT)
C10(MKT) Marketing Description - 2000 C05 (MKT)
D41 Price UOM
D40(WD1) WD Price D35 (WD1), Invoice Cost, Item WD Price
D40(CRW) WD Core D35 (CRW), Item WD Core Price
D40(JBR) Jobber Price D35 (JBR), Item Jobber Price, Jobber (JBR)
D40(CRJ) Jobber Core D35 (CRJ), Item Core Jobber Price
D40(DLR) Dealer Price D35 (DLR), Dealer, Item Dealer Price
D40(DLN) Non-Stock Dealer D35 (DLN)
D40(USR) User D35 (USR), User Price
D40(RET) Retail D35 (RET), Retail Price, Item Retail Price, Suggested Retail, Suggested Retail (RET)
D40(LST) List Price D35 (LST), List, List (LST), Item List Price
D40(ZZ1) User Defined Price D35 (ZZ1), AAP Cost, AAP Cost (ZZ1)
D40(ZZ2) User Defined Price 2 D35 (ZZ2), AAP Core Cost, AAP Core Cost (ZZ2)
D45 Price Break Quantity D45 (WD1)
D46 Price Break Quantity UOM D46 (WD1)
D40(AC1) Special Additional Cost 1 Price D35 (AC1)
D41(AC1) Special Additional Cost 1 Price UOM
D45(AC1) Special Additional Cost 1 Price Break Quantity
D46(AC1) Special Additional Cost 1 Price Break Quantity UOM
D40(AC2) Special Additional Cost 2 Price D35 (AC2)
D41(AC2) Special Additional Cost 2 Price UOM
D45(AC2) Special Additional Cost 2 Price Break Quantity
D46(AC2) Special Additional Cost 2 Price Break Quantity UOM
D40(CR1) Core 1 Price D35 (CR1)
D41(CR1) Core 1 Price UOM
D45(CR1) Core 1 Price Break Quantity
D46(CR1) Core 1 Price Break Quantity UOM
D40(CR2) Core 2 Price D35 (CR2)
D41(CR2) Core 2 Price UOM
D45(CR2) Core 2 Price Break Quantity
D46(CR2) Core 2 Price Break Quantity UOM
D40(CR3) Core 3 Price D35 (CR3)
D41(CR3) Core 3 Price UOM
D45(CR3) Core 3 Price Break Quantity
D46(CR3) Core 3 Price Break Quantity UOM
D40(CR4) Core 4 Price D35 (CR4)
D41(CR4) Core 4 Price UOM
D45(CR4) Core 4 Price Break Quantity
D46(CR4) Core 4 Price Break Quantity UOM
D40(CRG) Good Core Price D35 (CRG)
D41(CRG) Good Core Price UOM
D45(CRG) Good Core Price Break Quantity
D46(CRG) Good Core Price Break Quantity UOM
D41(CRJ) Jobber Core Price UOM
D45(CRJ) Jobber Core Price Break Quantity
D46(CRJ) Jobber Core Price Break Quantity UOM
D41(CRW) WD Core Price UOM
D45(CRW) WD Core Price Break Quantity
D46(CRW) WD Core Price Break Quantity UOM
D41(DLN) Non-Stock Dealer Price UOM
D45(DLN) Non-Stock Dealer Price Break Quantity
D46(DLN) Non-Stock Dealer Price Break Quantity UOM
D41(DLR) Dealer Price UOM
D45(DLR) Dealer Price Break Quantity
D46(DLR) Dealer Price Break Quantity UOM
D40(DLV) Volume Dealer Price D35 (DLV)
D41(DLV) Volume Dealer Price UOM
D45(DLV) Volume Dealer Price Break Quantity
D46(DLV) Volume Dealer Price Break Quantity UOM
D40(FLT) Fleet Price D35 (FLT)
D41(FLT) Fleet Price UOM
D45(FLT) Fleet Price Break Quantity
D46(FLT) Fleet Price Break Quantity UOM
D40(INM) Master Installer Price D35 (INM)
D41(INM) Master Installer Price UOM
D45(INM) Master Installer Price Break Quantity
D46(INM) Master Installer Price Break Quantity UOM
D40(INN) NS Installer Price D35 (INN)
D41(INN) NS Installer Price UOM
D45(INN) NS Installer Price Break Quantity
D46(INN) NS Installer Price Break Quantity UOM
D40(INP) Installer Preferred Price D35 (INP)
D41(INP) Installer Preferred Price UOM
D45(INP) Installer Preferred Price Break Quantity
D46(INP) Installer Preferred Price Break Quantity UOM
D40(INS) Stocking Installer Price D35 (INS)
D41(INS) Stocking Installer Price UOM
D45(INS) Stocking Installer Price Break Quantity
D46(INS) Stocking Installer Price Break Quantity UOM
D40(JBC) Conf-Jobber Price D35 (JBC)
D41(JBC) Conf-Jobber Price UOM
D45(JBC) Conf-Jobber Price Break Quantity
D46(JBC) Conf-Jobber Price Break Quantity UOM
D40(JBN) NS Jobber Price D35 (JBN)
D41(JBN) NS Jobber Price UOM
D45(JBN) NS Jobber Price Break Quantity
D46(JBN) NS Jobber Price Break Quantity UOM
D41(JBR) Jobber Price UOM
D45(JBR) Jobber Price Break Quantity
D46(JBR) Jobber Price Break Quantity UOM
D41(LST) List Price UOM
D45(LST) List Price Break Quantity
D46(LST) List Price Break Quantity UOM
D40(MEC) Mechanic Price D35 (MEC)
D41(MEC) Mechanic Price UOM
D45(MEC) Mechanic Price Break Quantity
D46(MEC) Mechanic Price Break Quantity UOM
D40(PKP) Pickup Price D35 (PKP)
D41(PKP) Pickup Price UOM
D45(PKP) Pickup Price Break Quantity
D46(PKP) Pickup Price Break Quantity UOM
D40(PRO) Special Promo Price D35 (PRO)
D41(PRO) Special Promo Price UOM
D45(PRO) Special Promo Price Break Quantity
D46(PRO) Special Promo Price Break Quantity UOM
D40(QOT) Quote Price D35 (QOT)
D41(QOT) Quote Price UOM
D45(QOT) Quote Price Break Quantity
D46(QOT) Quote Price Break Quantity UOM
D40(RAC) Racer Price D35 (RAC)
D41(RAC) Racer Price UOM
D45(RAC) Racer Price Break Quantity
D46(RAC) Racer Price Break Quantity UOM
D41(RET) Retail Price UOM
D45(RET) Retail Price Break Quantity
D46(RET) Retail Price Break Quantity UOM
D40(RMP) Retail MAP Price D35 (RMP)
D41(RMP) Retail MAP Price UOM
D45(RMP) Retail MAP Price Break Quantity
D46(RMP) Retail MAP Price Break Quantity UOM
D40(TRD) Trade Price D35 (TRD)
D41(TRD) Trade Price UOM
D45(TRD) Trade Price Break Quantity
D46(TRD) Trade Price Break Quantity UOM
D40(UNL) Unilateral Price Price D35 (UNL)
D41(UNL) Unilateral Price Price UOM
D45(UNL) Unilateral Price Price Break Quantity
D46(UNL) Unilateral Price Price Break Quantity UOM
D41(USR) User Price UOM
D45(USR) User Price Break Quantity
D46(USR) User Price Break Quantity UOM
D41(WD1) Distributor Price UOM
D40(WLS) Wholesaler Price D35 (WLS)
D41(WLS) Wholesaler Price UOM
D45(WLS) Wholesaler Price Break Quantity
D46(WLS) Wholesaler Price Break Quantity UOM
D40(WMP) Wholesale MAP Price D35 (WMP)
D41(WMP) Wholesale MAP Price UOM
D45(WMP) Wholesale MAP Price Break Quantity
D46(WMP) Wholesale MAP Price Break Quantity UOM
D41(ZZ1) User Defined 1 Price UOM
D45(ZZ1) User Defined 1 Price Break Quantity
D46(ZZ1) User Defined 1 Price Break Quantity UOM
D41(ZZ2) User Defined 2 Price UOM
D45(ZZ2) User Defined 2 Price Break Quantity
D46(ZZ2) User Defined 2 Price Break Quantity UOM
D40(ZZ3) User Defined 3 Price D35 (ZZ3)
D41(ZZ3) User Defined 3 Price UOM
D45(ZZ3) User Defined 3 Price Break Quantity
D46(ZZ3) User Defined 3 Price Break Quantity UOM
D40(ZZ4) User Defined 4 Price D35 (ZZ4)
D41(ZZ4) User Defined 4 Price UOM
D45(ZZ4) User Defined 4 Price Break Quantity
D46(ZZ4) User Defined 4 Price Break Quantity UOM
D40(ZZ5) User Defined 5 Price D35 (ZZ5)
D41(ZZ5) User Defined 5 Price UOM
D45(ZZ5) User Defined 5 Price Break Quantity
D46(ZZ5) User Defined 5 Price Break Quantity UOM
D40(ZZ6) User Defined 6 Price D35 (ZZ6)
D41(ZZ6) User Defined 6 Price UOM
D45(ZZ6) User Defined 6 Price Break Quantity
D46(ZZ6) User Defined 6 Price Break Quantity UOM
D40(ZZ7) User Defined 7 Price D35 (ZZ7)
D41(ZZ7) User Defined 7 Price UOM
D45(ZZ7) User Defined 7 Price Break Quantity
D46(ZZ7) User Defined 7 Price Break Quantity UOM
D40(ZZ8) User Defined 8 Price D35 (ZZ8)
D41(ZZ8) User Defined 8 Price UOM
D45(ZZ8) User Defined 8 Price Break Quantity
D46(ZZ8) User Defined 8 Price Break Quantity UOM
D40(ZZ9) User Defined 9 Price D35 (ZZ9)
D41(ZZ9) User Defined 9 Price UOM
D45(ZZ9) User Defined 9 Price Break Quantity
D46(ZZ9) User Defined 9 Price Break Quantity UOM
E10(CCL) Core Class
E10(CGR) Core Group
E10(CPN) Core Part Number
E10(CXP) Core Return Days to Expiry
E10(EMS) Emission Code
E10(MSD) MSDS Sheet Number
E10(MSR) MSDS Sheet Available Y/N MSDS Required Flag, MSDS Sheet Available
E10(OEM) Original Equipment Manufacturer
E10(OEP) OEM's Part Number
E10(OSN) Original Supplier
E10(OSP) Original Supplier Part Number
E10(PTN) Part Number - Old
E10(PTS) Part Number Superseded To
E10(REF) Refurbished Part
E10(REM) Remanufactured Part
E10(RET) Return Code
E10(WD1) Warranty Distance
E10(WD2) Warranty Distance UOM
E10(WS1) Warranty Special
E10(WS2) Warranty Special UOM
E10(WT1) Warranty Time
E10(WT2) Warranty Time UOM
E10(RST) Regulating State
E10(RPC) Regulating Postal Code
E10(RCS) Regulating County, State
E10(RCT) Regulating City, State
E10(CTO) Country of Origin (Primary) Country of Origin
E10(CTP) Country of Origin 2
E10(CTQ) Country of Origin 3
E10(CTR) Country of Origin 4
E10(CTS) Country of Origin 5
E10(HAC) Canadian Harmonizing Tariff Code
E10(HSB) Harmonized Tariff Code (Schedule B) Harmonized Tariff (Sch B), NAFTA Harmonized Tariff Code (Schedule B)
E10(HTS) Harmonized Tariff Code (HTS)
E10(NAF) NAFTA Preference Criterion Code
E10(LIF) Life Cycle Status Code Life Cycle Status
E10(LIS) Life Cycle Status Description
E10(TAX) Taxable Y/N Taxable
E10(HZ1) Item (SKU) Level Special Handling Code
E10(NPC) National Popularity Code Popularity Code
E10(NPD) National Popularity Description
E10(TMC) Trading Partner Movement Code
E10(PLC) Maximum Cases per Pallet Layer
E10(PLM) Pallet Layer Maximum
E10(STA) Stock Status
H05(EA) Each Package Level GTIN Each Package GTIN-14, Package (Each) Level GTIN (UPC)
H10(EA) Each Package Bar Code Characters Each Package Bar Code Char, Item Bar Code
H21(EA) Each Package Inner Quantity Units per Item
H22(EA) Each Package Inner Quantity UOM H15(EA), Each Package UOM (EA), Each Package UOM, Item Unit of Measure
H20(EA) Quantity of Eaches in Package (Each) Quantity of Eaches (Each Package)
H25(EA) Each Height Each Height (Inches), Package (Each) Height, Item Height
H30(EA) Each Width Each Width (Inches), Package (Each) Width, Item Width
H35(EA) Each Length Each Length (Inches), Package (Each) Length, Item Depth
H40(EA) Each Dimensions UOM UOM For Dimensions (Each)
H45(EA) Each Weight Each Weight (Gross Pounds), Package (Each) Weight, Item Weight
H46(EA) Each Weight UOM UOM For Weight (Each)
H47(EA) Each Dimensional Weight
H55(EA) Each Stacking Factor
H05(PK) Inner Pack Level GTIN Inner Pack Package Level GTIN, Inner Pack GTIN-14, Inner Package UPC
H10(PK) Inner Package Bar Code Characters Inner Pack Bar Code Characters, Inner Pack Package Bar Code Characters, Inner Pack Bar Code Char., Inner Package Bar Code
H22(PK) Inner Pack Inner Quantity UOM H15(PK), Inner Pack UOM (PK), Inner Package UOM
H20(PK) Inner Pack Quantity of Eaches in Package Quantity of Eaches in Inner Pack, Items per Inner Pack
H25(PK) Inner Pack Height (Inches) Inner Pack Height
H30(PK) Inner Pack Width (Inches) Inner Pack Width
H35(PK) Inner Pack Length (Inches) Inner Pack Length
H40(PK) Inner Pack Dimensions UOM UOM For Dimensions (Inner Pack)
H45(PK) Inner Pack Weight (Gross Pounds) Inner Pack Weight
H46(PK) Inner Pack Weight UOM UOM For Weight (Inner Pack)
H47(PK) Inner Pack Dimensional Weight
H55(PK) Inner Pack Stacking Factor
H05(CA) Case Package Level GTIN Case Package GTIN-14, Pkg LevelGTIN UPC (Case), Case UPC
H10(CA) Case Package Bar Code Characters Case Bar Code Characters, Case Bar Code
H22(CA) Case Package Inner Quantity UOM H15(CA), Case Package UOM (CA)
H20(CA) Quantity of Eaches in Case Case Quantity of Eaches in Package, Quantity of Eaches in Package (Case), Items per Case
H25(CA) Case Height Case Height (Inches), Height (Case)
H30(CA) Case Width Case Width (Inches), Width (Case)
H35(CA) Case Length Case Length (Inches), Length (Case)
H40(CA) Case Dimensions UOM UOM For Dimensions (Case)
H45(CA) Case Weight Case Weight (Gross Pounds), Weight (Case)
H46(CA) Case Weight UOM UOM For Weight (Case)
H47(CA) Case Dimensional Weight
H55(CA) Case Stacking Factor
H05(PL) Pallet Package GTIN Pallet Package GTIN-14, Pallet Package Level GTIN, Pallet UPC
H10(PL) Pallet Bar Code Characters Pallet Package Bar Code Characters, Pallet Bar Code
H22(PL) Pallet Package Inner Quantity UOM H15(PL), Pallet UOM (PL)
H20(PL) Quantity of Eaches in Pallet Pallet Quantity of Eaches in Package, Items per Pallet
H25(PL) Pallet Height Pallet Height (Inches)
H30(PL) Pallet Width Pallet Width (Inches)
H35(PL) Pallet Length Pallet Length (Inches)
H40(PL) Pallet Dimensions UOM UOM For Dimensions (Pallet)
H45(PL) Pallet Weight Pallet Weight (Gross Pounds)
H46(PL) Pallet Weight UOM UOM For Weight (Pallet)
H47(PL) Pallet Dimensional Weight
H55(PL) Pallet Stacking Factor
J33 Hazardous Material Description J25, Hazmat Description
J32 Hazardous Class Code Hazardous Materials Class Code, Hazmat Class Code
P05 File Name Image File Name
P10 Asset Type
P15 File Type
P20 Representation Actual/Rep
P25 File Size
P30 Resolution
P35 Color Mode
P40 Background
P45 Orientation View Image View
P50 Asset Height
P55 Asset Width
P60 Asset Dimension UOM
P65 Additional Info
P70 Asset Detals/Description Asset Details, Asset Description
P75 File Path
P80 URI URL
P90 File Date Modified
P91 Asset Effective Date
P92 Asset Expiration Date
P98 Asset Country Code
P99 Asset Language Code
P80 (PAG) Link to Manufacturer Page (Website) Link to Supplier Page (Web)