RPMWareES-Import-2-0.markdown

RPMWare ES Import 2.0

The RPMWare import process is being updated to support ACES/PIES fields

Import Format

• Columns A thru AA (listed below) remain the same.
• Columns AB thru AF are deleted (ItemLevelGTIN, PackageLevelGTIN, PartTypeId, EXPICodes, INFO)
• Any number of custom columns can be added using the format (below).

Custom Column Format

• | indicates or e.g. ACES or PIES
• Brackets [ ] are delimiters but should not be included in column names.

For single-level fields:

[ACES|PIES].[AttributeName]
ACES.BodyType
PIES.PartTypeID

For multi-level fields:

[ACES|PIES].[AttributeGroup].[AttributeName]
PIES.Description.MKT
PIES.PriceType.LST

Database Changes

• Values currently in PrivateAttributes table will be moved to the appropriate PIES table.
• PrivateAttributes table will be deleted.
• Values in the following items table columns will be moved to the appropriate PIES table and the columns deleted:
  • PartTypeID
  • ItemLevelGTIN
  • PackageLevelGTIN
  • EXPICodes

Appendix

Import Columns

• GroupName
• GroupId
• BrandId
• PartNumber
• MSRP
• Jobber
• MAP
• StartYear
• EndYear
• Make
• Model
• SubModel
• Cyl
• Lit
• Fuel
• FuelDel
• ASP
• EngDesg
• VehicleNotes
• ItemNotes
• Specs
• ItemWeight
• Length
• Width
• Height
• COO

This will work. To make things a tad easier to sort through, we need exports of valid ACES and PIES field names. We should tack these on as additional sheets in the RPMWareES workbook like we do for Valid Applications and COO.