Adding huge datasets to Woocommerce

  • Hi Experts ??

    I’m stuck in a project where I need to insert more that 1 mio. products into woocommerce.

    All commercial import-products a much to slow (needing month). Even my tests with REST-Api and WP cli are much to slow.

    Now I think, the only way to proceed with the initial import is, to insert the products directly into the database.

    My questions now:

    Is there someone out in tge world, who wrote a litte documentation on where to insert what? I know, that there is a database documentation, but it’s not that simple and would need some weeks learnig, I think.
    It would be nice if there would be a sample sql-file, inserting one simple produkt into the affected tables. this product does not have variations but attributes and pictures.

    And: If someone has abetter idea on performant imports, I would be happy to hear about ..

    Thanks in advance! ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    I agree that a direct phpMyAdmin import file would be best. As you surmised, getting the WooCommerce data schema correct would be the biggest challenge. With that many products, you probably would even want to break up the import files into several parts. I’m not sure just how large an import file is feasible.

    If you need an example import file, I suggest exporting a number of products and their related data and using that as a guide for your import file. Do these products also have taxonomy terms assigned? Taxonomy schema is probably the most complex to understand, but it’s not really that bad. Obviously you’d need data from posts and postmeta table. I’m not sure what other WC tables you’d need, most are not directly related to products.

    If you started a new, empty WP database and only added a few sample products, it should be clear which WC tables you’d need to export as an example.

    Thread Starter wurzelsepp1

    (@alexprepo)

    Even phpMyAdmin does not properly handle imports of some Gigabytes. But importing it directly to the server works fine and within a few minutes.

    The idea, so export the tables first and then to examine the data, is nice but takes some extra investigations.

    I’m still hoping, that someone out there did the job before and is willing to share his/her sample script. ??

    Ifound a hundred questions like this on the web. it’s maybe even a business idea to write an importer for more than 1000 products… ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Adding huge datasets to Woocommerce’ is closed to new replies.