Thanks for the reply, Mike.
It does do that, but not all the time. Seems that if you update an order and make a correction it doesn’t update all the fields. Whichever way, for some reason these fields get out of sync for my customer and the owner wants to eliminate human error by not having that second set of fields.
I have a very similar requirement landwire.
Basically what we need is an object_id column on the wp_term_relationships table.