search

woocommerce / woocommerce-admin

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

[GlobalStep]: The Analytics Order filter for Attribute fails to work for Simple products, Grouped Products and External/Affiliated products with attributes added. #6447

Closed gglobalstep closed 2 years ago

gglobalstep commented 3 years ago

Bug Description:

The Analytics Order filter for Attribute fails to work for Simple products, Grouped Products and External/Affiliated products with attributes added.

Environment:

Windows 10, macOS High Sierra v10.13.6 Browser: Chrome(Version 88.0.4324.104) (64-bit) Firefox(Version 83.0)(64-bit) Safari: v13.1.2(13609.3.5.1.5)

Steps To Reproduce:

  1. Create any test site using JN site.
  2. Install and activate all the required plugins
  3. Add various products such as Simple products, Grouped Products or External/Affiliated
  4. Also add attributes to all the above products created
  5. Place an order for all the products you have just created.
  6. Go to Analytics-Orders, and from show dropdown select "Advanced Filters"
  7. Click on "Add a Filter" option and select Attribute
  8. Filter search by specific attribute say Material: Cotton
  9. Observe that results shown below are just for Variable product orders as per attribute filter, it fails to work for Simple products, Grouped Products and External/Affiliated products with attributes added.

Note: It only works for Variable product

Actual Result:

The Analytics Order filter for Attribute fails to work for Simple products, Grouped Products and External/Affiliated products with attributes added.

Expected Result:

The Analytics Order filter for Attribute should work for Simple products, Grouped Products and External/Affiliated products with attributes added.

Video:

https://user-images.githubusercontent.com/41110392/109028413-c9cb5100-76e7-11eb-8d8a-72fc20cac43c.mp4

Isolating the problem (mark completed items with an [x]):

``` ` ### WordPress Environment ### WordPress address (URL): https://classical-whippet.jurassic.ninja Site address (URL): https://classical-whippet.jurassic.ninja WC Version: 5.0.0 REST API Version: ✔ 5.0.0 WC Blocks Version: ✔ 4.0.0 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.9.0 Log Directory Writable: ✔ WP Version: 5.6.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache/2.4.46 (Unix) OpenSSL/1.0.2g PHP Version: 7.4.15 PHP Post Max Size: 1 GB PHP Time Limit: 30 PHP Max Input Vars: 5000 cURL Version: 7.47.0 OpenSSL/1.0.2g SUHOSIN Installed: – MySQL Version: 5.7.33-0ubuntu0.16.04.1-log Max Upload Size: 512 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.1.0 WC Database Prefix: wp_ Total Database Size: 4.81MB Database Data Size: 3.21MB Database Index Size: 1.60MB wp_woocommerce_sessions: Data: 0.02MB + 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.02MB + 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_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 2.05MB + Index: 0.09MB + Engine InnoDB wp_postmeta: Data: 0.20MB + Index: 0.17MB + Engine InnoDB wp_posts: Data: 0.08MB + 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_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_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + 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_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ### Post Type Counts ### attachment: 26 page: 6 post: 2 product: 19 product_variation: 57 revision: 2 shop_order: 5 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (13) ### Query Monitor: by John Blackbourn – 3.6.7 Akismet Anti-Spam: by Automattic – 4.1.8 Companion Plugin: by Osk – 1.18 Creative Mail by Constant Contact: by Constant Contact – 1.3.2 Facebook for WooCommerce: by Facebook – 2.3.1 Jetpack by WordPress.com: by Automattic – 9.4 Klarna Payments for WooCommerce: by krokedil klarna automattic – 2.2.0 Google Ads & Marketing by Kliken: by Kliken – 1.0.7 Mailchimp for WooCommerce: by Mailchimp – 2.5.0 Mollie Payments for WooCommerce: by Mollie – 6.1.0 WooCommerce Beta Tester: by WooCommerce – 2.0.2 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.40 WooCommerce: by Automattic – 5.0.0 ### Inactive Plugins (1) ### Hello Dolly: by Matt Mullenweg – 1.7.2 ### Dropin Plugins (1) ### db.php: Query Monitor Database Class ### Settings ### API Enabled: – Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) 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#6 - /shop/ Cart: woocommerce/woocommerce#7 - /cart/ Checkout: woocommerce/woocommerce#8 - /checkout/ My account: woocommerce/woocommerce#9 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Twenty Twenty Version: 1.6 Author URL: https://wordpress.org/ 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: 22 Oldest: 2021-02-24 07:25:59 +0000 Newest: 2021-02-24 15:03:24 +0000 ` ```
juliaamosova commented 3 years ago

Hi @gglobalstep,

Thank you for reporting the issue. The functionality of the Analytics section 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.

ilyasfoo commented 3 years ago

I'm able to reproduce this with WooCommerce 5.0.0 and WooCommerce Admin 2.1.0. It seems that in orders advanced filters, attribute filtering works by filtering orders that contains variable products that have the attribute value assigned to a particular variation.

image

This is definitely off, attribute filtering should apply to all products with the assigned attribute.

image

chihsuan commented 2 years ago

Closing this since this bug is over 6 months old. p90Yrv-2Bc-p2