WooCommerce Custom Tables Initial Implementation Ready for Testing HPOS

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.

You can create a staging and testing site with the free plugin WP STAGING

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

Author: Rene Hermenau

I'm René Hermenau, founder of WP STAGING. I've been building WordPress infrastructure software since 2013 and writing code on GitHub since 2011. My repos live at github.com/rene-hermenau. WP STAGING started as a small developer project solving the same problem I kept hitting on client work: there was no fast, safe way to clone a WordPress site for staging or migration without breaking serialized data, file paths, or media references. Today we are a team of more than 10 people. The free plugin runs on hundreds of thousands of WordPress installations, and the Pro version powers backup, migration, and staging workflows for agencies, hosting platforms, and ecommerce stores. I'm still hands-on with the codebase and technical architecture. Our releases are built as a team, but many of the core architectural decisions are ones I helped design, test, and evolve over the years: how we handle large database exports, how we keep memory usage flat on multi-GB sites, and how we make migrations atomic against partially written tables. "When you touch code, leave it 10% better than before and write a test." If you're stuck on a WP STAGING question, the docs are at wp-staging.com/docs. If you hit a bug, file it on GitHub at github.com/wp-staging. Our team reads everything that lands there.