Order Analytics doesn’t work with advanced “Attribute” filter

Resolved Chad Reitsma
(@chadreitsma)

2 years, 8 months ago

Hey guys,

Trying to list orders using the advanced filter by “attribute” doesn’t display any orders.

We created a product attribute called “Designer” and assigned that to multiple products. We then created a few test orders with those product (they are marked as complete)

The orders show up in the main Analytics dashboard if I click on “Analytics -> Orders” – but as soon as I add an advanced filter for that attribute, nothing is displayed.

I’ve already tried clearing the analytics cache and re-importing the historical data.

Not sure if this is a bug, or what else to do. Appreciate any advice!

Cheers,
C.

Viewing 12 replies - 1 through 12 (of 12 total)

MayKato
(@maykato)

2 years, 8 months ago

Hello,

I’ve tried this on my test sites, and I could not reproduce the same issue. To troubleshoot, could you share the following?

Screenshot of “Analytics > Orders” with advanced filters: I recommend https://snipboard.io for easily sharing screenshots – please follow the instructions on the page, then paste the URL in this chat. It works with Chrome, Firefox, Safari, and Edge.

System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

Thread Starter Chad Reitsma
(@chadreitsma)

2 years, 8 months ago

Here’s a screenshot showing the advanced filters:
https://snipboard.io/whXv8n.jpg

Here is a screenshot showing the order containing the product that has the attribute. It is a virtual product, and the price is $0.00 because this user has a subscription which entitles them to free downloads.
https://snipboard.io/awx3cU.jpg

Plugin Support abwaita a11n
(@abwaita)

2 years, 8 months ago

Hi @chadreitsma,

Thanks for sharing the screenshots.

I’m looking at the following screenshot:

Link to image: https://snipboard.io/dxPaGk.jpg

Just to check, did the customer purchase the product with the attribute Designerand value Janice Allen? The search filter seems quite too specific here, and it could be that the customer bought an item with a different Designer value.

You could try reviewing the order or making a test order for a product with the Designer attribute and Janice Allen value and see if it shows up.

Let us know what you find out.
Thanks.

MayKato
(@maykato)

2 years, 7 months ago

Hi @chadreitsma

We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.

Thread Starter Chad Reitsma
(@chadreitsma)

2 years, 7 months ago

Hey guys,

As mentioned – yes the customer purchased the item – we have tested it several times. It just doesn’t work.

Thread Starter Chad Reitsma
(@chadreitsma)

2 years, 7 months ago

Re-opened here: https://wordpress.org/support/topic/order-analytics-doesnt-work-with-advanced-attribute-filter-2/

Mirko P.
(@rainfallnixfig)

2 years, 7 months ago

Hi @chadreitsma,

Thanks for getting back.

I’ve now reopened this thread as your issue seems not yet resolved. We normally close the topic if there is no response within a week for the health of the forum.

Just to check this further, if you clear the advanced filter and select the date when the order was completed, can you see the order details under the Orders tab at the bottom?

We’ll go further from there.

Thread Starter Chad Reitsma
(@chadreitsma)

2 years, 7 months ago

Thanks Mirko, that makes sense – I was away on holiday and wasn’t responding quickly enough 🙂

Yes, we can see the orders, these products all have the “Designer” Attribute, and the Term: Janice Allen

Orders:
https://snipboard.io/EZjWKc.jpg

Product Attributes:
https://snipboard.io/M2aQcy.jpg

Mirko P.
(@rainfallnixfig)

2 years, 7 months ago

Hey there,

Thank you for the detailed screenshots. This sounds like a bug, so please open up an issue on GitHub:

https://github.com/woocommerce/woocommerce/issues

You can get feedback directly from developers there.

Thanks!

Thread Starter Chad Reitsma
(@chadreitsma)

2 years, 7 months ago

Will do, thanks!

Thread Starter Chad Reitsma
(@chadreitsma)

2 years, 7 months ago

Bug report submitted here:
https://github.com/woocommerce/woocommerce/issues/30695

Mirko P.
(@rainfallnixfig)

2 years, 7 months ago

Great! Thanks for opening the issue on Github.

WooCommerce developers will check it and provide feedback directly on the open issue, so for now I’m going to close this thread. Feel free to open a new topic if you have further questions!

Cheers.