Version Specific Rules

Converting from 6.1.2 to 6.2

  • Need a default BrandAAIAID.
  • Change Item - Hazardaous Material Code from X to N.

Converting from 6.2 to 6.1.2

  • AttributeType may be too long. 6.2 - 80 characters, 6.1.2 - 20 characters

Converting from 6.2 to 6.3

  • Limit GTIN Qualifier to UP or EN
  • Drop EXPI PFP, PFU

Converting from 6.3 to 6.2

  • Drop AssetType LGO
  • Drop Market Copy Segment

Converting from 6.3 to 6.4

  • Drop Digital Asset Old Filename.

Converting from 6.4 to 6.5

  • Market Copy Type is required, so use GCC.
  • Kit segment will be converted by using the file Brand AAIA ID from the Component Brand AAIA ID. Description will be populated with “Not Supplied”.

Converting from 6.5 to 6.4

  • Drop any Market Copy that uses MarketCopySubCode, MarketCopySubCode Reference, or Record Sequence.
  • Drop and Attribute that uses Multi-Value Quantity, Sequence

Converting from 6.5 to 6.6

  • Drop Hazardous Class, Hazardous Material Class Code from HazMat.
  • Convert Interchange to new format. No new required elements.

Converting from 6.6 to 6.5

  • Drop interchanges where any of the following specified: SubBrand AAIAID, SubBrand Label, Reference Item.
  • Drop any interchanges having more that one part.

Converting from 6.6 to 6.7

(changes to digital assets)

  • Convert Details to DES description.
  • Convert Additional Info to ASC description.
  • Convert dates as required.

Converting from 6.7 to 6.6

  • Based on the length choose either Details or Additional Info from the descriptions.
  • Drop description if Sequence is used and greater than one. - Lose of information.

Converting from 6.7 to 7.0

  • REM was removed from PCdb around PIES 7.0. It was replaced with Product Condition (PRC). The converter will change REM=“Y” to PRC=“REM”, but doesn’t convert REM=“N” because there isn’t a unique translation.

Converting from 7.0 to 6.7

  • If Market Copy Record Sequence length > 3, drop (or should we just keep it and fail schema validation). This should be rare.

Converting from 7.0 to 7.1

  • Convert Height, etc. to Merchandising Height, etc.
  • Kits cannot be converted between 7.0 and 7.1 due to requirement of Component Part Terminology ID and Sold Separately.

Converting from 7.1 to 7.0

  • Reverse the package dimension mapping.
  • Drop kits that don’t have Component Part Number, Component Brand AAIA ID, Component ID Qualifier. These are required in PIES 7.0 and optional in PIES 7.1.
Revised: 2019-09-13