Woocommerce-admin: Unable to Filter Customers by "Total Spend" or "AOV"

Created on 12 May 2020 · 2Comments · Source: woocommerce/woocommerce-admin
Describe the bug
Under WooCommerce > Customers, I'm unable to add an advanced filter for Total Spend or AOV. Other filters do work.
To Reproduce
Steps to reproduce the behavior:
Go to WooCommerce > Customers.
Click on the dropdown menu under Show:
Select to add an Advanced Filter.
Choose Total Spend or AOV.
The screen goes blank.
Screenshots
Image Link: https://d.pr/i/lVvOxD
These errors appear on the browser console:
Image Link: https://d.pr/i/tQBXxQ
Isolating the problem (mark completed items with an [x]):
[x] I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
[x] This bug happens with a default WordPress theme active, or Storefront.
[x] I can reproduce this bug consistently using the steps above.
WordPress Environment
`
### WordPress Environment ###

WordPress address (URL): https://fernando.mystagingwebsite.com
Site address (URL): https://fernando.mystagingwebsite.com
WC Version: 4.1.0
REST API Version: ✔ 1.0.7
WC Blocks Version: ✔ 2.5.16
Action Scheduler Version: ✔ 3.1.5
WC Admin Version: ✔ 1.1.1
Log Directory Writable: ✔
WP Version: 5.4.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: ✔

### Server Environment ###

Server Info: nginx
PHP Version: 7.2.30
PHP Post Max Size: 2 GB
PHP Time Limit: 1200
PHP Max Input Vars: 6144
cURL Version: 7.69.1
OpenSSL/1.1.0l

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.21-MariaDB-log
Max Upload Size: 2 GB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.1.0
WC Database Prefix: wp_
Total Database Size: 6.57MB
Database Data Size: 3.29MB
Database Index Size: 3.28MB
wp_woocommerce_sessions: Data: 0.11MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_automatewoo_customers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_cart_notices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_customers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_followup_customer_carts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_orders: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_followup_email_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_followup_followup_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_order_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_order_items: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 1.02MB + Index: 0.08MB + Engine InnoDB
wp_postmeta: Data: 0.17MB + Index: 0.13MB + Engine InnoDB
wp_posts: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wcpv_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpv_per_product_shipping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_bookings_availability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_bookings_availabilitymeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_booking_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_cvo_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_deposits_payment_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_deposits_payment_plans_schedule: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_points_rewards_user_points: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_points_rewards_user_points_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_warranty_products: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_gpf_google_taxonomy: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_per_product_shipping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_pickup_locations_geodata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpml_mails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 26
aw_workflow: 2
custom_css: 1
customize_changeset: 4
def_reg_fields: 10
page: 18
post: 2
product: 21
product_variation: 7
revision: 21
shop_coupon: 1
shop_order: 11
wc_order_status: 11

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (1) ###

WooCommerce: by Automattic – 4.1.0

### Inactive Plugins (115) ###

Add To Cart Redirect for WooCommerce: by Jeroen Sormani – 1.0.3 – Installed version not tested with active version of WooCommerce 4.1.0
Akismet Anti-Spam: by Automattic – 4.1.5
ARI Adminer: by ARI Soft – 1.2.3
AutomateWoo: by WooCommerce – 4.9.3
Bookings Helper: by WooCommerce – 1.0.2 – Installed version not tested with active version of WooCommerce 4.1.0
Custom User Registration Fields for WooCommerce: by Addify – 1.5.2
Follow-Up Emails: by WooCommerce – 4.9.1
Gutenberg: by Gutenberg Team – 8.0.0
Homepage Control: by WooThemes – 2.0.3
Jetpack by WordPress.com: by Automattic – 8.5
Loco Translate: by Tim Whitlock – 2.3.3
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
Regiones de Chile para WooCommerce: by melvisnap <[email protected]> – 0.4 – Installed version not tested with active version of WooCommerce 4.1.0
Simple Image Sizes: by Rahe – 3.2.1
Storefront Blog Customiser: by WooCommerce – 1.3.0
Storefront Homepage Contact Section: by WooThemes – 1.0.5
Storefront Mega Menus: by WooCommerce – 1.6.2 – Installed version not tested with active version of WooCommerce 4.1.0
Storefront Parallax Hero: by WooCommerce – 1.5.7
Storefront Powerpack: by WooCommerce – 1.5.0
Storefront Product Pagination: by WooThemes – 1.2.4 – Installed version not tested with active version of WooCommerce 4.1.0
Storefront Product Sharing: by WooCommerce – 1.0.6
Testing Code: by Fernando Alvarez – 0.1
TLS 1.2 Compatibility Test: by Stranger Studios – 1.0.1
WooCommerce 360° Image: by WooCommerce – 1.1.14
WooCommerce Account Funds: by WooCommerce – 2.2.0
WooCommerce Additional Variation Images: by WooCommerce – 1.7.22
WooCommerce Admin: by WooCommerce – 1.1.1
WooCommerce Advanced Ajax Layered Navigation: by WooCommerce – 1.4.22
WooCommerce Advanced Product Labels: by Jeroen Sormani – 1.1.7 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Advanced Shipping Packages: by Jeroen Sormani – 1.1.6 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Affirm Gateway: by WooCommerce – 1.1.10 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Amazon Pay: by WooCommerce – 1.12.2
WooCommerce Anti Fraud: by WooCommerce – 2.7.1 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Australia Post Shipping: by WooCommerce – 2.4.23
WooCommerce Authorize.Net Gateway: by SkyVerge – 3.2.6
WooCommerce AvaTax: by SkyVerge – 1.9.5
WooCommerce Blocks: by Automattic – 2.5.15 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Bookings: by WooCommerce – 1.15.18
WooCommerce Box Office: by WooCommerce – 1.1.23
WooCommerce Brands: by WooCommerce – 1.6.17
WooCommerce Canada Post Shipping: by WooCommerce – 2.5.16
WooCommerce Cart Add-Ons: by WooCommerce – 1.5.28
WooCommerce Cart Notices: by SkyVerge – 1.11.4
WooCommerce Catalog Visibility Options: by Lucas Stark – 3.2.9
WooCommerce Checkout Field Editor: by WooCommerce – 1.5.32
WooCommerce Composite Products: by SomewhereWarm – 6.2.3
WooCommerce Conditional Shipping and Payments: by SomewhereWarm – 1.8.0
WooCommerce Cost of Goods: by SkyVerge – 2.9.6
WooCommerce Currency Converter: by WooCommerce – 1.6.20
WooCommerce Customer/Order/Coupon CSV Import Suite: by SkyVerge – 3.8.6
WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.0.12
WooCommerce Customer History: by Brian Richards – 1.2.1 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Deposits: by WooCommerce – 1.5.0
WooCommerce Disability VAT Exemption: by WooCommerce – 1.4.1 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Distance Rate Shipping: by Automattic – 1.0.21
WooCommerce Dropshipping: by WooCommerce – 2.1 (update to version 2.2 is available) – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Dynamic Pricing: by Lucas Stark – 3.1.19 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce EU VAT Number: by WooCommerce – 2.3.19
WooCommerce FedEx Shipping: by WooCommerce – 3.4.30
WooCommerce First Data Payeezy Gateway: by SkyVerge – 4.7.2
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.21
WooCommerce Google Product Feed: by Ademti Software Ltd. – 8.1.1
WooCommerce Group Coupons: by itthinx – 1.14.0 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Local Pickup Plus: by SkyVerge – 2.8.2
WooCommerce Measurement Price Calculator: by SkyVerge – 3.17.4
WooCommerce Memberships: by SkyVerge – 1.17.3
WooCommerce Min/Max Quantities: by WooCommerce – 2.4.16
WooCommerce Mix and Match Products: by Kathy Darling – 1.9.3
WooCommerce Multi-currency: by TIV.NET INC – 2.5.2 (update to version 2.5.4 is available) – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Name Your Price: by Kathy Darling – 3.0.4
WooCommerce One Page Checkout: by Automattic – 1.7.5
WooCommerce Order Barcodes: by WooCommerce – 1.3.17
WooCommerce Order Status Manager: by SkyVerge – 1.11.7
WooCommerce Payments (Beta): by Automattic – 0.9.1 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.21 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Photography: by WooCommerce – 1.0.23
WooCommerce Points and Rewards: by WooCommerce – 1.6.32
WooCommerce Pre-Orders: by WooCommerce – 1.5.25
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.8.4
WooCommerce Product Add-ons: by WooCommerce – 3.0.32
WooCommerce Product Bundles: by SomewhereWarm – 6.2.3
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.33
WooCommerce Product Documents: by SkyVerge – 1.11.3
WooCommerce Product Enquiry Form: by WooCommerce – 1.2.13
WooCommerce Products Compare: by WooCommerce – 1.0.19
WooCommerce Product Search: by itthinx – 2.21.0 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Product Vendors: by WooCommerce – 2.1.32
WooCommerce Royal Mail: by WooCommerce – 2.5.27
WooCommerce Sales Report Email: by WooCommerce – 1.1.13
WooCommerce Services: by Automattic – 1.23.0 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Servired/RedSys Spain Gateway: by José Conti – 7.1.0
WooCommerce Shipment Tracking: by WooCommerce – 1.6.22
WooCommerce Shipping Per Product v2: by WooCommerce – 2.3.9
WooCommerce Ship to Multiple Addresses: by WooCommerce – 3.6.17
WooCommerce Show Attributes: by Isabel Castillo – 1.6.4 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Smart Coupons: by StoreApps – 4.7.4
WooCommerce Splash Popup: by WooCommerce – 1.2.16
WooCommerce Square: by WooCommerce – 2.1.4 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Store Catalog PDF Download: by WooCommerce – 1.10.23
WooCommerce Store Credit: by Themesquad – 3.1.3
WooCommerce Stripe Gateway: by WooCommerce – 4.3.3 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Subscriptions: by WooCommerce – 3.0.4 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Subscriptions - Preserve Billing Schedule: by Prospress Inc. – 1.0.0 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Subscriptions Gifting: by WooCommerce – 2.1.0 – Installed version not tested with active version of WooCommerce 4.1.0
WooCommerce Table Rate Shipping: by WooCommerce – 3.0.26
WooCommerce UPS Shipping: by WooCommerce – 3.2.25
WooCommerce USPS Shipping: by WooCommerce – 4.4.43
WooCommerce Variation Swatches and Photos: by Lucas Stark – 3.1.1
WooCommerce Warranty Requests: by WooCommerce – 1.9.13
WooCommerce Xero Integration: by WooCommerce – 1.7.29 – Installed version not tested with active version of WooCommerce 4.1.0
WP Mail Logging: by MailPoet – 1.9.6
WP Reset: by WebFactory Ltd – 1.80
WP Rollback: by Impress.org – 1.7.0
WP Staging: by WP-Staging – 2.7.2
Yoast SEO: by Team Yoast – 14.0.4

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: Memcached

### Must Use Plugins (1) ###

WP Staging Optimizer: by René Hermenau – 1.2

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: composite (composite)
external (external)
grouped (grouped)
mix and match (mix-and-match)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ✔

### WC Pages ###

Shop base: woocommerce/woocommerce#5 - /shop/
Cart: woocommerce/woocommerce#6 - /cart/
Checkout: woocommerce/woocommerce#7 - /checkout/
My account: woocommerce/woocommerce#8 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: Storefront
Version: 2.5.6
Author URL: https://woocommerce.com/
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 60
Oldest: 2020-04-27 22:51:40 +0000
Newest: 2020-05-11 22:49:30 +0000

Pending: 4
Oldest: 2020-05-12 00:14:37 +0000
Newest: 2020-05-12 06:50:05 +0000

`
bug
Source
fhaps
All 2 comments

Hi @fhaps,
Thank you for reporting the issue. WooCommerce / Customers functionality is a part of WooCommerce Admin which is being developed in another repository: https://github.com/woocommerce/woocommerce-admin.
I am going to move your bug report there so that the right team could take a look further.