search

woocommerce / woocommerce-admin

(Deprecated) This plugin has been merged to woocommerce/woocommerce
https://woocommerce.github.io/woocommerce-admin/#/
Other
362 stars 144 forks source link

Unable to Filter Customers by "Total Spend" or "AOV" #4346

Closed fhaps closed 4 years ago

fhaps commented 4 years ago

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:

  1. Go to WooCommerce > Customers.
  2. Click on the dropdown menu under Show:
  3. Select to add an Advanced Filter.
  4. Choose Total Spend or AOV.
  5. 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]):

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 – 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 ` ```
juliaamosova commented 4 years ago

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.

psealock commented 4 years ago

Thanks for the bug report @fhaps. This will fix the issue, https://github.com/woocommerce/woocommerce-admin/pull/4356