{"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. 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 This is a major modification, and the WooCommerce developers are aware of it. 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 They plan to start with orders first. The goal is to have them in their own table by the third quarter of 2022<\/strong>. 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}]}}
\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>\nWhy move WooCommerce data to separate tables?<\/h2>\n
\n
The online store in dedicated tables \u2013 a significant change!<\/h3>\n
\nThere are hundreds, if not thousands, of plugins that rely on the current structure.
\nThink of filters, coupons, descriptions, images, and more!<\/p>\nWhat’s the timeline for the new tables?<\/h3>\n
\nRemember: the transition is initially optional, according to the WooCommerce developers.
\nOther elements of the online store will follow in subsequent steps.<\/p>\n