I have a product that has a part number of "PS-185" (seal for a pool pump) however, this part fits several different pool pumps (A-C PUMP, AMERICAN-MARSH PUMPS, etc).
Here is my issue, each pool pump manufacturer uses the same "PS-185", however they give it a different part number for their pump. For example, "A-C Pump" will say that the replacement seal is a "52-113-592-801" ( "Mfg. Part No"), which is the "PS-185" ("Part No").
Ideally, the customer would be able to search for either the Mfg. Part No (Column I) or by the Pump Name (Column A).
Lastly, all Inventory should be using PS-185 .