Hello,
I have experience of working with wp all import, handling and modifying data. I shall function to its fields, take all the data pointers and make necessary changes before adding/updating product.
You seemed to have quite a few scenarios I shall make sure all are taken into consideration.
Please get in touch, I can finish this tomorrow.
Thanks