I posted this in r/WooCommerce, but I never get any response there. Many more users here.
Is the product ID in multiple tables? That would obviously be a problem if I only changed it in one, but can. I change it in all related tables and effectively re-order my products? I am a tad bit compulsive, and it is unsettling the way my product list is so “out of order”. I am sure I am the only person to have this affliction. I can keep swallowing the discomfort if I must. My fear is that it will build up and I will start needing outlets for the pent up frustration. I don’t want to start kicking puppies or something. Maybe I can seek a good therapist to help me, if I must. I think re-ordering the products would be cheaper though, if it is possible.
I suppose I could also use the import/export functions to move the data to a spreadsheet, then delete everything and import it all back in the correct order. Seems like a reasonable solution, but certainly not the fastest if I can do it with phpMyAdmin.