There are three worksheets in the RPMWare ES Import Template Excel Workbook:

  1. Import: The data-entry sheet for the brand(s) you will be importing.
  2. Valid Attributes: A detailed list of valid Year, Make, Model, Submodel, etc. combinations.
  3. Countries: A list of valid country codes.

The table below describes each of the columns in the Import worksheet. You should add your products to this worksheet. The other worksheets are for reference only.

BrandName Optional
Reference field to assist in building your load file. This data will NOT be imported into RPMWare.
BrandId Required
Id corresponding to the Brand you created. To determine the Id navigate to the Product Group in the RPMWare Product Manager. The Id is listed with the Brand details.
GroupName Optional
Reference field to assist in building your load file. This data will NOT be imported into RPMWare.
GroupId Required
Id corresponding to the Product Group you created. To determine the Id navigate to the Product Group in the RPMWare Product Manager. The Id is listed with the Product Group details.
PartNumber Required
Manufacturer's part number.
MSRP Optional
Manufacturer's Suggested Retail Price.
Jobber Optional
Manufacturer's Jobber Price.
MAP Optional
Manufacturer's Minimum Advertised Price.
StartYear Required
Start Year for the Vehicle application you are entering. If the part you are entering is a Universal part, enter 0.
EndYear Required
End Year for the Vehicle application you are entering. If the part you are entering is a Universal part, enter 0.
Make Required
Make of the vehicle application. Only one Make per row.
Acceptable Values: Acura, Ford, Mazda (Full list in Valid Attributes worksheet)
Model Required
Model of the vehicle application. Only one Model per row.
Acceptable Values: Integra, F-150, Golf (Full list in Valid Attributes worksheet)
Submodel Optional See Notes
SubModel of the vehicle application
Acceptable Values: Type S, GTI (Full list in Valid Attributes worksheet)
Cyl Optional See Notes
Number of Cylinders of the vehicle application
Acceptable Values: H4, V8 (Full list in Valid Attributes worksheet)
Lit Optional See Notes
Liters of the vehicle application
Acceptable Values: 1.8, 4.6, 5.0 (Full list in Valid Attributes worksheet)
Fuel Optional See Notes
Fuel Type of the vehicle application
Acceptable Values: Gas, Diesel (Full list in Valid Attributes worksheet)
FuelDel Optional See Notes
Fuel Delivery of the vehicle application
Acceptable Values: FI: Fuel Injected; CARB: Carbureted
ASP Optional See Notes
Aspiration of the vehicle application
Acceptable Values: N: Naturally Aspirated; S: Supercharged; T: Turbo
EngDesg Optional See Notes
Engine of the vehicle application
Acceptable Values: B18C1, 2JZGTE, LS1 (Full list in Valid Attributes worksheet)
VehicleNotes Optional
Notes pertaining to the Vehicle the item fits. All notes must be separated by a semicolon ;.
Example: AWD; 5Speed; Excl ABS; Coupe
ItemNotes Optional
Notes pertaining to the Item. Usually indicates specifics of an item. All notes must be separated by a semicolon ;. If an Item is Universal, ItemNotes should act as a short description of the item itself.
Example: Complete Set; Incl Hardware; Stainless Steel
Specs Optional
Name/Value pairs that specify attributes of the Item. Specs must be entered as such: Spec: Value;. Each Spec must be separated by a semicolon ;.
Example: Color: Red; Material: Aluminum; Axle: Front
ItemWeight Optional
Weight specific to the shippable PartNumber. If no ItemWeight is specified the PartNumber will default to the Group's weight.
Length Optional
Length of the item's shipping box in inches.
Acceptable Values: 1, 2.2, etc.
Width Optional
Width of the item's shipping box in inches.
Acceptable Values: 1, 2.2, etc.
Height Optional
Height of the item's shipping box in inches.
Acceptable Values: 1, 2.2, etc.
COO Optional
The Country of Origin for the item.
Acceptable Values: US, CA, JP (Full list in Countries worksheet)
ItemLevelGTIN Optional
The GTIN (UPC) for the item.
Note: Most items specify ItemLevelGTIN or PackageLevelGTIN, not both.
PackageLevelGTIN Optional
The GTIN (UPC) for the item's package
Note: Most items specify ItemLevelGTIN or PackageLevelGTIN, not both.
PartTypeId Optional
Auto Care Association internal reference to the Product Classification Database (PCdb) used in generating PIES documents.
EXPICodes Optional
Auto Care Association internal reference to the Product Classification Database (PCdb) used in generating PIES documents.

Notes

  1. If the Item you are entering is Universal or fits all possible entries – leave blank.
  2. If the item you are entering fits more than one possible entry – use a semicolon ; to separate acceptable entries.