Zend certified PHP/Magento developer

How to transfer products from Magento 2.4.2-p1 to Magento 2.4.4 which give Errors during export and then import?

We have a live production Magento ver. 2.4.2-p1 with 2224 products but have a lot of problems which stem from me using the official Magento Migration Tool to migrate from Magento 1.x.

Because of this, I have decided to built a new Magento 2.4.4 website and instead of using the Migration Tool, export the products from our live Magento ver. 2.4.2-p1 store and import them into the 2.4.4. When doing that, I got a bunch of unique Errors such as meta description too long, SKU number Errors etc. and the end result is that the store I’m building only has 2049 products. We are, therefore, missing 175 products. I tried to fix the Errors in different ways including splitting the CSV file into multiple smaller files but it seems there is no easy way to fix the variety of Errors.

Is there any other way I could transfer the 175 missing products other than making a list and doing it manually? I would prefer not to use Migration Tools as I believe they cause a lot of other problems.