Insert products directly into mysql

[ad_1]

Hello

I have to insert over a million products from XML files.
I have a script using WC_Product_Simple() , set_name(), set_description(), add_meta_data() etc.
But this script only imports 5 products/minute. It would take months…
It is only the insertion part that is slow, reading the XML is very fast.

So I wonder if it wouldn’t be more efficient to directly insert the products in mysql without using WooCommerce functions?
If so, how to do it ? What would be the table schema?

Thanks for your help !

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer