High-Performance Order Storage moves orders out of the posts table, and the compatibility mode that writes to both is the part to plan around. The four queries were…
Nine template overrides in the theme, of which four had been superseded by upstream changes and were being loaded in place of maintained files. A template override is…
Order statuses are registered post statuses prefixed with wc-, which means a custom one is a core registration and the twenty-character post status limit applies. Both steps are…
3.6 added lookup tables, which is WooCommerce admitting postmeta does not scale. What they contain, what they do not, and the regeneration nobody schedules.
3.6 in April added wc_product_meta_lookup, a flat table of the attributes catalogue queries filter on — which is WooCommerce accepting that postmeta does not scale. The table is…
The privacy tooling that arrived in core 4.9.6 and WooCommerce 3.4 covers the standard data, and everything a custom plugin stored is yours to declare. The pagination in…
Querying orders with WP_Query couples the code to orders being posts, which is the thing WooCommerce spent 3.0 making replaceable. It returns order objects rather than posts, so…
Orders live in wp_posts with their data in wp_postmeta, which means a shop with two hundred thousand orders has a postmeta table with several million rows shared with…