What is High-Performance Order Storage (HPOS)?

What is High-Performance Order Storage?

If you’re familiar with WooCommerce, and I’m sure you are since you are reading this article, you are most likely to have come across the term High-Performance Order Storage, or HPOS. But what is it, what does it do and why do you want it? These are some of the question marks that we’ll try to straighten out in this article.

What is High-Performance Order Storage in WooCommerce?

High-Performance Order Storage, or HPOS, is essentially a database structure that is designed for ecommerce. In essence it will enable a better, faster checkout experience for your customers and faster order processing for you as a merchant.

HPOS efficiently stores order information in custom tables optimized for WooCommerce queries. Using the Woo Create, Read, Update, Delete (CRUD) design. The HPOS optimization is designed to cause minimal disruption to the store’s performance.

The work with HPOS began in January 2022 and in May 2022 users were invited by Woo to start testing and provide feedback. In October 2023 HPOS was considered stable and as of WooCommerce version 8.2 it is enabled by default with new installations.

Krokedil plugins with HPOS support

Not all of the plugins developed by Krokedil are yet compatible with High-Performance Order Storage at the time of writing this article. However, most of the ones not yet compatible with HPOS are scheduled to be in the near future.

These are the plugins that are compatible with HPOS in May 2024:
Avarda Checkout
Dinero Checkout
Ingrid Delivery Checkout
Klarna Checkout
Klarna On-site Messaging
Klarna Order Management
Klarna Payments
Klarna Shipping Assistant
Krokedil Product Documents
Nexi Checkout
Payson Checkout
Post Purchase Upsell
ProTeria CloudConnect
Qliro One
User Switching for WooCommerce

What are the advantages with High-Performance Order Storage?

If you boil it down, HPOS introduces improvements in three crucial aspects vital for ecommerce.

Scalability:

As your customer base and order volumes grow, the strain on your store’s database increases, potentially hampering order processing and user experience. HPOS addresses this challenge by furnishing dedicated tables for critical data like orders and order addresses, alongside dedicated indexes. This approach minimizes read/write operations and table congestion, allowing ecommerce platforms of any size to scale up without intricate technical adjustments.

Reliability:

HPOS simplifies the process of implementing and restoring targeted data backups, mitigating concerns about losing crucial order details, inventory data, or client information. By utilizing reliable backups within customized order tables, it ensures data integrity and enables the implementation of read/write locks to prevent potential race conditions.

Simplicity:

Gone are the days of navigating through a huge database to locate essential data and WooCommerce records. With HPOS, users can effortlessly navigate through distinct tables and manage entries independently of the _posts table. This approach not only simplifies data retrieval but also enhances flexibility in developing extensions, implementing shop designs, and modifying WooCommerce functionalities according to specific requirements.

How to enable HPOS

As mentioned earlier in this article, High-Performance Order Storage is enabled by default with new installations as of WooCommere 8.2. If you installed WooCommerce prior to this version you can switch to HPOS via a simple setting. You can also switch back to WordPress posts storage at any time if you run into problems or have plugins that are not yet compatible with HPOS.

You can follow a step-by-step guide if you follow this link to the woocommerce.com documentation.

High-Performance Order Storage settins in WooCommerce

Do I have to enable HPOS?

No you don’t have to switch to HPOS. WooCommerce is encouraging it, but the feature is completely opt-in and you can switch at the time of your convenience.

Learn more about High-Performance Order Storage

If you want to read more about HPOS and get more detailed information you can visit the High-Performance Order Storage page in the WooCommerce documentation.

Featured WooCommerce plugins

featured-post-purchase-upsell

Post Purchase Upsell for WooCommerce

Increase the order value and get higher revenue. With Post Purchase Upsell, the customer can add additional products to their order after a completed purchase. They easily choose which of the selectable products they want to add and update their order with one click.
featured-partial-delivery

Partial Delivery for WooCommerce

Partial Delivery for WooCommerce enables merchants to ship parts of an order. Via a logical interface you are able to send one or several items in each delivery.
featured-krokedil-shipping-connector

Krokedil Shipping Connector

Book deliveries with nShift directly from WooCommerce with Krokedil Shipping Connector when you let your customers choose how and where the delivery is made with nShift Checkout or Klarna Shipping Assistant.