Ok. I think I figured out what the problem is (sorta)
Something within the CSV import process is creating NULL ShippingTemplates and PayTemplates entries and pushes the user created entry further and further down the list which increments its PaymentTemplateID which explains the flakiness I was experiencing as match on ID worked at one point of time and then suddenly it doesn’t.
I matched on PaymentTemplateID = 157 and got Paypal.
I matched on Name = Paypal and got nothing.
I did a single entry CSV import (with matching broken) to see if it incremented the template table but it did not.
I postulate the same issue also exists with Diagram and Shipping and all the other fields that I don’t use.
Should the program be autogenerating NULL template entries?
In the meantime I’ll just match on the respective IDs.
-Alan