Automattic / woocommerce-subscriptions-core

Subscriptions core package for WooCommerce
Other
81 stars 29 forks source link

Add HPOS compatibility for the `orders_by_type_query` filter box in the order listing screen #501

Closed a-danae closed 9 months ago

a-danae commented 10 months ago

Fixes #496

Description

image

How to test this PR

  1. Go to WooCommerce -> Settings -> Advanced -> Features. /wp-admin/admin.php?page=wc-settings&tab=advanced&section=features
  2. Under Experimental features, select "High performance order storage (new)", enable "Keep the posts and orders tables in sync (compatibility mode)", and save
  3. Go to WooCommerce -> Orders. /wp-admin/admin.php?page=wc-orders
  4. Confirm that the "shop_order_subtype" dropdown filter shows up next to "Filter by registered customer"
  5. As a shopper, get the following if you don't have them already:
    • A subscription
    • A renewal for the subscription
    • A resubscribed subscription
    • An order with a non-subscription product
    • A switched subscription
  6. Go to WooCommerce -> Orders
  7. Filter by each option from the dropdown and confirm that the results match the filter. Because we're missing the "Subscription relationship" column, I used the results from when "WordPress post tables" is enabled instead of HPOS as a reference

Product impact

francoishvz commented 10 months ago

6734041-zd-a8c