Earlier this year, WooCommerce announced it would create an MVP for custom order tables by 2022, a significant improvement that delivers substantial performance gains for stores. The WooCommerce development team is now calling for developers, agencies, and hosting companies to test the migration of the initial implementation of customer order tables named High_performance Order Storage or short HPOS.
Note: Since WooCommerce 7.1, this feature can be activated.
Read more about it on WooCommerce:
https://woocommerce.com/document/high-performance-order-storage/
The testing process will migrate orders from wp_posts and wp_postmeta
to four new custom order tables:
- wp_wc_orders
- wp_wc_orders_addresses
- wp_wc_orders_operational_data
- wp_wc_orders_meta
The test setup requires a staging environment including WP-CLI and a staging database prepared with order data.
A WooCommerce migration testing guide by WooCommerce core developer Vedanshu Jain describes the custom code developers need to add to enable custom order tables. Once enabled, developers can migrate the tables using WP-CLI or via the Action Scheduler.
Jain is asking for feedback from anyone who wants to help the migration process with details about the number of orders, server storage size, DB version, and whether time has run out or if different batch size is more appropriate.
Upgrading WooCommerce to use custom order tables will be a significant change that will impact extension developers in different ways. The development team intends to release an upgrade guide to support the adoption of custom order tables after the migrations are complete. Later this year, when the update is expected to be rolled out to the core plugin, WooCommerce plans to initially offer it on an opt-in basis only to give store owners time to make their sites compatible.
Source: WP Tavern