orvis erp export issues

[hexfusion]

• canonical/variant description needs a whitespace filter
• Orvis Fish Skulls what is manf sku?
• Canonical only product should have a full ALU
• Rods have attributes in the description and no attributes in system. This needs resolved. ie "Orvis Clearwater 4-weight 8'6" Fly Rod"
• I think we need a way to predetermine if an item is a variant besides the same code. From looking at the datafile if an item has the same first 2 words and the ALU has the 1st 2 letter/numbers the same it is a variant and the description should be the item including the repeating name.

[hexfusion]

Looking at this further it seems that they intentionally do this with rods only for the most part. I guess to show each rod individually on the site. Which I do not want to do. So I think we can predict breaking out the variants for rods from description.

[hexfusion]

alu/upc needs formatting for excel.

upc* numeric with no decimal alu * not sure a few odd balls here.