Two files attached:
BRANDMODELSIZE - This is a list of all the pump types
Note that there are really only eight types: Wright TRA10, Wright TRA20, Ampco ZP1, Ampco ZP2, Waukesha Universal 1, Waukesha Universal 2, Alfa Laval SCCP 1, Alfa Laval SCCP2 - they just come in a variety of sizes
Making it less/more confusing, there's really just four manufacturers making two sets: Wright TRA10 = Ampco ZP1 = Waukesha Universal 1 = Alfa Laval SCCP 1
PARTPRODUCTS - This a list of all the individual pump parts
There's a lot of erroneous columns in the PARTPRODUCTS file, but it would be nice/appreciated if we could keep/import most columns (even if they're only seen by the admin).
I don't know how easy/hard it is to import all these columns. If each column represents any more than a moderate additional effort, we can neglect quite a few of them (e.g. SELLABLE, PUBLISH, DESC_SIZE_WRIGHT, DESC_SIZE_WAUKESHA, etc.) and consolidate the redundant ones (e.g. UC1_SERIES, UC2_SERIES, UC3_SERIES...