WooCommerce Google Merchant Data Feed Fix

I'm experiencing multiple issues with my WooCommerce Google Product Feed the feed that google pulls on its own not a feed that we send to google merchant the feed that google pulls from our website. We have about 90,000 listings that have been disapproved by Google due to missing weights but the attributes do have weights, and the platform is still attempting to pull sold products. I need an expert who can troubleshoot this situation and get our feed back on track.

Specific Issues:
- Missing weights for products: Google is flagging many of our listings due to this issue.
- Google pulling sold products: We need to stop Google from attempting to list products that are no longer available.
- Products being disapproved: A large number of our listings have been disapproved by Google, which is impacting our visibility and sales.

Previous Attempts to Resolve:
I have hired a few people to try to fix this issue but no one has been able to find a solution.

Tools Used:
We are using the WooCommerce Google Product Feed plugin for our integration with Google Merchant.

Ideal Skills and Experience:
- Proficiency in WooCommerce and Google Merchant.
- Experience with troubleshooting data feed issues.
- Familiarity with the WooCommerce Google Product Feed plugin.
- Strong problem-solving skills.

I look forward to hearing from experts who can help me get this situation resolved. Thank you.