12/21/2023 0 Comments Starters orders 6 custom scheduleThis is the first draft of the database that we would like to propose to build out custom tables. As we go further along in the implementation, we plan to publish upgrade guides to support the adoption of custom order tables.ĭuring the rollout, we aim to keep this feature strictly opt-in in the beginning, giving everyone enough time to make their shops compatible. Backward Compatibilityįor this project, we expect that some work may be required by extensions and custom code developers to take full benefit of the new table structure. We aim to complete the initial implementation by early Q3 2022. Reliability – it should be easier to take and restore targeted backups, implement read/write locks and prevent race conditions.Simplicity – being independent of WP posts should help in finding where underlying data lives, understand its structure and allowing developers to modify WooCommerce with more finesse.Scalability – by having dedicated tables (and therefore dedicated indexes, less busy tables, less read/write ops etc), we aim to enable shops of all sizes to scale further without the need for expert intervention.There are 3 main properties we’d like to improve by bringing custom order tables to WC core: While these WordPress-provided APIs and tables have served us well over the years, we now want to take a step further with a rock-solid and easy-to-understand database structure that is intentionally designed for commerce needs. We still utilize wp_post and wp_postmeta table structures to store this information for WooCommerce stores even with the CRUD layer. This was done to enable the possibility to migrate to different data stores for objects that use the CRUD layer later on, such as products, orders, or coupons. This release included the introduction of CRUD classes that provide abstraction above direct database access. Background and scopeīack in 2017, WooCommerce 3.0 was released. This is a complex project, so we are going to reach out often to you for feedback as we continue with the implementation. With this post, we announce with much excitement that we have started working on an implementation of custom tables for orders. This is something that we also wanted to do for some time, but have shied away from actually committing to implementation so far largely due to the complexity of making this type of change, without adversely affecting existing sites and extensions. Over the years, we have frequently received requests to implement custom tables for various WooCommerce entities (orders, products, coupons, etc).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |