WooCommerce HPOS - New Feature in WordPress Takes Online Shops to the Next Level

WooCommerce recently introduced the new High Performance Order Storage feature (HPOS for short). With this feature, the long-known performance problems in online shops with many orders are now permanently solved. WooCommerce shops thereby reach a new level.

The Need for Clean Storage of Large Volumes of Order Data in WooCommerce

As WooCommerce continues to dominate the e-commerce landscape (about 23% of all shops worldwide), the need for high-performance order storage (so-called High-Performance Order Storage, or HPOS) becomes increasingly critical. For WordPress developers and online shop owners, optimizing the storage of orders is not just a luxury; it is a necessity to scale your business.

The current standard storage system via the WordPress posts table is functional, but it struggles to meet the demands of large-scale operations. This can lead to longer loading times that affect both user experience and SEO ranking.

Furthermore, stagings, safe updates, and the import of backups have so far always been associated with the problem that orders received in the meantime would be lost.

The Problem with the Current Order Storage

WooCommerce currently relies on the `wp_posts` table to store order data. Although this table serves its purpose in terms of performance for smaller shops, it becomes a bottleneck for larger operations. The `wp_posts` table is not optimized for thousands of stored entries that are continuously queried and therefore represents a performance limitation.

As the WooCommerce online shop grows, the table becomes overloaded not only with orders but also with posts, pages, and other data types. This lack of data separation can lead to slow query performance that affects the speed of your online shop. For WordPress developers and online shop owners, this is a significant problem. Slow performance can lead to a poor user experience, which in turn can affect revenue and SEO ranking. Therefore, a more efficient storage solution is required to address these limitations.

The New Custom Table Solution

On the database side, WooCommerce is therefore introducing a new custom table specifically designed for storing order data. This is a turning point for WordPress developers and online shop owners struggling with performance issues and messy data migrations. The custom table aims to streamline data storage and make it more efficient and scalable.

One outstanding feature is the optimized query performance. Unlike the `wp_posts` table, this custom table is designed to handle high volumes of order data without delays. This results in faster data retrieval, which is crucial for large shops. The new table also enables more advanced features, such as specialized indexing and data retrieval methods. These improvements contribute to a more robust and high-performing WooCommerce ecosystem and address the limitations of the current storage system.

Benefits of HPOS

Speed Improvements

The High-Performance Order Storage (HPOS) system is built for speed. By using a custom table for order data, query performance is significantly improved. This is especially beneficial for large WooCommerce shops where fast data retrieval is essential.

Data Separation

Separating the order data into its own custom table has benefits that go beyond speed. It simplifies the process of staging and backups and enables more targeted data management. While there are no plugins for this yet, it is certain that staging and backup tools will soon follow suit here. This separation also improves data integrity and reduces the risk of data loss.

Integration

Integrating HPOS into your WooCommerce shop is a straightforward process. However, it is important to test thoroughly to ensure compatibility with other plugins and themes. WooCommerce provides comprehensive documentation that guides you through the integration process, making it easier for WordPress developers to implement this feature.

You reach the new feature via „WooCommerce / Settings / Advanced / Features“ and activate „High Performance Order Storage“ there. The feature is then already activated for new orders.

Interestingly, WooCommerce currently additionally offers a dual storage option. This means you can use both the new HPOS system and the traditional `wp_posts` table simultaneously. This flexibility enables a smooth transition. Especially at the beginning, the option „Keep the posts and orders tables in sync“ must additionally be selected.

If there are incompatible plugins, the option to use HPOS deactivates itself. In any case, it is therefore advisable to enable „Keep the posts and orders tables in sync“.

Future Plans

The development of High-Performance Order Storage (HPOS) is an ongoing process aimed at revolutionizing the efficiency of WooCommerce. However, it is important to understand that this feature will not be used in all WooCommerce shops overnight, completely replacing the old variant.

One of the main reasons for the gradual rollout is the need for compatibility with existing plugins. WooCommerce is working intensively to ensure that HPOS is compatible with the ecosystem of plugins that many shops rely on.

Further links:
WooCommerce HPOS Roadmap
WooCommerce HPOS Documentation