skills.rest
zenbuapps
zenbuappsOFFICIAL
Explore all skills by this author →
GitHub

woocommerce-hpos

Migrate WooCommerce order data to HPOS tables and query via CLI tools.

1|Updated Mar 6, 2026
Search Tags:#migration#woocommerce#database-schema#hpos#order-storage#wc-get-orders
One-click install
npx skills add https://github.com/zenbuapps/zenbu-powers --skill woocommerce-hpos
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: woocommerce-hpos
Source: https://github.com/zenbuapps/zenbu-powers/tree/main/skills/woocommerce-hpos
Command: npx skills add https://github.com/zenbuapps/zenbu-powers --skill woocommerce-hpos

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Consolidates WooCommerce order data into HPOS tables to simplify access and improve performance.

Core Features & Use Cases

  • HPOS core tables and data stores (wp_wc_orders, wp_wc_order_addresses, wp_wc_order_operational_data, wp_wc_orders_meta)
  • Migration patterns: CRUD operations from wp_posts/wp_postmeta to WC_Order objects
  • CLI tools and querying APIs (wp wc hpos, meta_query, field_query, date_query)
  • Plugin compatibility declaration and cross-datastore synchronization

Quick Start

Explain how to enable HPOS for a WooCommerce store and perform a sample data migration using the CLI and querying.

Frequently Asked Questions about woocommerce-hpos

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate WooCommerce orders to HPOS tables from the posts table?▼

To migrate WooCommerce orders to HPOS, you use CRUD migration patterns and CLI tools to transition data from wp_posts and wp_postmeta into dedicated HPOS tables like wp_wc_orders and wp_wc_order_addresses. This consolidation simplifies access and improves performance.

What is the HPOS database schema for WooCommerce order storage?▼

The HPOS database schema for WooCommerce order storage consists of core tables including wp_wc_orders, wp_wc_order_addresses, wp_wc_order_operational_data, and wp_wc_orders_meta. These tables consolidate order data to simplify access and improve performance compared to the posts table.

How do I query WooCommerce orders using HPOS APIs after migration?▼

You query WooCommerce orders using HPOS APIs and CLI tools by utilizing wc_get_orders along with meta_query, field_query, and date_query parameters. These querying APIs allow efficient retrieval of WC_Order objects directly from the HPOS data stores.

Does HPOS support cross-datastore synchronization and plugin compatibility?▼

HPOS supports plugin compatibility declaration and cross-datastore synchronization to ensure integrations function correctly. This allows plugins to declare compatibility and maintain data consistency across both the traditional posts and new HPOS data stores during the transition.

What CLI tools are available for enabling WooCommerce HPOS and performing data migration?▼

WooCommerce provides CLI tools under the wp wc hpos command to enable HPOS and perform sample data migration. These CLI tools guide the process of consolidating order data into HPOS tables and troubleshooting integration across various store sizes.

When should I not use HPOS for WooCommerce order storage?▼

You should carefully evaluate HPOS limitations when your store relies on plugins lacking explicit compatibility declarations or requiring cross-datastore synchronization. Troubleshooting integration issues is necessary when migrating CRUD operations from posts to HPOS tables for non-compatible extensions.

Related Skills

Explore More Software Engineering Skills→
Lonsdale201Lonsdale201
21

wc-hpos-compatibility

Declare WooCommerce HPOS compatibility and migrate order data access to HPOS backends.

Community
Advanced
AytsuuAytsuu

benchmark

Measure and compare web application and API performance metrics before and after changes.

Community
Advanced
OrcaQubitsOrcaQubits
35

woo-setup

Install and configure WooCommerce development environments using WP-CLI and wp-env.

Official
Intermediate
xukrutdonutxukrutdonut

wpclaw-connector

Fetch orders, products, and store status from WooCommerce via WPClaw.

Community
Intermediate