{"id":20991,"date":"2023-07-13T09:48:30","date_gmt":"2023-07-13T07:48:30","guid":{"rendered":"https:\/\/wpbeveiligen.nl\/?p=20991"},"modified":"2023-06-29T09:51:38","modified_gmt":"2023-06-29T07:51:38","slug":"woocommerce-gets-its-own-tables-in-the-database","status":"publish","type":"post","link":"https:\/\/wpbeveiligen.nl\/en\/woocommerce-gets-its-own-tables-in-the-database\/","title":{"rendered":"WooCommerce gets its own tables in the database"},"content":{"rendered":"

We all know WooCommerce as the miraculous plugin that turns WordPress into a full-fledged online store.<\/strong><\/p>\n

WooCommerce (created by Automatic, just like WordPress) heavily relies on the WordPress structure, especially in the database.
\nIn the past years, products have simply been stored as Custom Posts in the post and postmeta tables of the database, where pages and posts are also stored!<\/p>\n

This has been working well for years, allowing you to build and run even the largest online stores without issues.<\/p>\n

However, there has been a request from many developers, plugin builders, and even regular users to store WooCommerce data in separate tables in the database<\/em>.<\/p>\n

Why move WooCommerce data to separate tables?<\/h2>\n
    \n
  • It provides better organization<\/strong> in the database, making modifications<\/strong> easier to handle.<\/li>\n
  • It becomes easier to create backups of the online store and restore them<\/strong> without including unnecessary information.<\/li>\n
  • It has the potential to make the website, particularly product loading and information retrieval, faster<\/strong>.<\/li>\n<\/ul>\n

    The online store in dedicated tables \u2013 a significant change!<\/h3>\n

    This is a major modification, and the WooCommerce developers are aware of it.
    \nThere are hundreds, if not thousands, of plugins that rely on the current structure.
    \nThink of filters, coupons, descriptions, images, and more!<\/p>\n

    For this reason, transitioning to specific tables will be OPTIONAL in the initial phase. If your online store is not ready, you don’t have to make the switch just yet.<\/p>\n

    What’s the timeline for the new tables?<\/h3>\n

    They plan to start with orders first. The goal is to have them in their own table by the third quarter of 2022<\/strong>.
    \nRemember: the transition is initially optional, according to the WooCommerce developers.
    \nOther elements of the online store will follow in subsequent steps.<\/p>\n

    Source: [Developer.woocommerce.com](https:\/\/developer.woocommerce.com\/2022\/01\/17\/the-plan-for-the-woocommerce-custom-order-table\/)<\/p>\n","protected":false},"excerpt":{"rendered":"

    We all know WooCommerce as the miraculous plugin that turns WordPress into a full-fledged online store. WooCommerce (created by Automatic, just like WordPress) heavily relies on the WordPress structure, especially in the database. In the past years, products have simply been stored as Custom Posts in the post and postmeta tables of the database, where […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[196],"tags":[],"_links":{"self":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts\/20991"}],"collection":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/comments?post=20991"}],"version-history":[{"count":0,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/posts\/20991\/revisions"}],"wp:attachment":[{"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/media?parent=20991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/categories?post=20991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpbeveiligen.nl\/wp-json\/wp\/v2\/tags?post=20991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}