{"id":16882503,"date":"2023-07-10T07:33:01","date_gmt":"2023-07-10T07:33:01","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/insert-products-directly-into-mysql\/"},"modified":"2023-07-10T07:33:01","modified_gmt":"2023-07-10T07:33:01","slug":"insert-products-directly-into-mysql","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/insert-products-directly-into-mysql\/","title":{"rendered":"Insert products directly into mysql"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I have to insert over a million products from XML files.<br \/>I have a script using WC_Product_Simple() , set_name(), set_description(), add_meta_data() etc. <br \/>But this script only imports 5 products\/minute. It would take months&#8230;<br \/>It is only the insertion part that is slow, reading the XML is very fast.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So I wonder if it wouldn&#8217;t be more efficient to directly insert the products in mysql without using WooCommerce functions?<br \/>If so, how to do it ? What would be the table schema?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks for your help !<\/p>\n","protected":false},"template":"","class_list":["post-16882503","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16882503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16882503\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16882503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}