This worked perfectly, thanks!
Very same issue. We migrated a site to a test server. It still shows the products just fine on the live server, but on the test server, the products do not appear. But I know they are there because, like above, the Published shows a number.
Have looked to see if there are other instances of WooCommerce installed on the same server, and there are not. Also have all plugins other than WC turned off.
Help?
dollar_dad thanks so much for this fix!