Help Needed : Google Deindexing my Sites

Hi BHW brothers, I'm running to this headache lately and need some advices.

I have several E-commerce websites and they have been massively deindexed in a short period.

When I check site:domain it only leaves 1-5 pages on google search results. Even though it was indexing full (30 pages) before.

I have tried to submit each product link on google webmaster, split the sitemap, etc…

I use Woocommerce and upload multiple products at the same time through importing CSV.

1. Does Google penalize my site for uploading a 1000+ products woocommerce CSV? Even with a particular site with on 120+ products, they are still deindexed .

2. If one site goes from ~30 SERP pages down to 3-5 pages, will it be re-indexed automatically ? How long and how possible that is ?

Thank you all in advance. Love & peace.

check this link https://google.com/?gl=us&pws=0 with the site: operator and see if all of them appear

It can be 1-10 results.
Read this:
https://www.blackhatworld.com/seo/anyone-site-only-4-results-indexed-penalty-now.1318746/

Same problem. Is it because the speed that I import Woocommerce products too many in just 1 day ?

Remember that there million of urls on internet , focus on the categories if the product itself has no searches who care about it
but the category always have searches. by the way your product description are original or just copy paste them.

there are many reasons behind this Google loves fresh and unique content and natural back links if it finds any thing wrong at your website then it starts de-indexing at your site and remove website from its database.

Indexing few pages only is kind of penalty which is already discussed on BHW in some threads. Check those threads, one link above shared by a member.