I am currently experiencing this issue where every alternate row it shows as “Post is Not a Product”. I understand this problem is due to woocommerce already have another item using the same id. However, I have changed the id a few times but it is still the same rows that are having this problem.
How do I know which are the id range that has been used?
Your understanding is correct about “Post is Not a Product”. This error occurs when there is an already existing post with the same ID on your site. You can view the post ID’s in the wp_posts table of your database.