Can’t filter out by attributes

Hi @geomatha,

On Analytics –> Orders, I can use advanced filters to filter out by product name, for example But if I try to filter by attributes, it just won’t work. The name of the attribute is “Proveedor”, and I notice that when I start typing, I get two options that look identical: “Proveedor”. None works. Any ideas?

From what I understand, you’re having trouble with filtering by attributes in the Analytics –> Orders section of your WooCommerce store. Specifically, you’re encountering issues with the attribute “Proveedor”.

Let’s try a few steps to troubleshoot this issue:

1. Clear Cache and Cookies: Sometimes, your browser cache can cause issues with how pages are displayed or functions are executed. Please try clearing your browser’s cache and cookies, then attempt the filtering again.
2. Update your plugins and themes: An outdated plugin or theme could be causing conflicts with WooCommerce. Please ensure that all your plugins and themes are up to date.
3. Check for Duplicate Attributes: It’s possible that there are two “Proveedor” attributes in your database. You can check this by navigating to Products –> Attributes in your WordPress dashboard. If there are duplicates, consider deleting one and ensure all your products are using the same attribute.
4. Data Synchronization: WooCommerce uses a system called Action Scheduler for data syncing. It could be that your data is not fully synchronized. You can check if there are any pending actions by going to Tools –> Status –> Scheduled Actions. If there are any ‘pending’ actions, try running them manually.
5. Check for a plugin conflict: Another plugin might be interfering with WooCommerce. Try deactivating other plugins temporarily to see if that resolves the issue. If it does, reactivate them one by one to identify which one is causing the conflict.
6. Test for a theme conflict: Your theme could also be causing the issue. Try switching to a basic theme like Storefront temporarily to see if the issue persists. Here’s a handy guide on testing for conflicts: ?? How to Test for Plugin and Theme Conflicts.

If the issue persists after trying these steps, could you please provide a screenshot of your Analytics –> Orders page and your Products –> Attributes settings? This will help us better understand the issue. You can share screenshots at https://snipboard.io. Just follow the instructions on the page and paste the URL in your response.

Sharing your site’s System Status report will also help us understand your site’s setup and identify the problem. You can find it via WooCommerce > Status. Select Get system report and then Copy for support.

If there are any fatal error logs, please share those as well. You can find them under WooCommerce > Status > Logs.

Once you’ve gathered this information, please paste it inside a Code block in your reply, or use https://pastebin.com to paste it and share the link with us.

Thanks for your patience and cooperation in this matter! We’re here to help you get this sorted.

Thanks @bisratlearn! I disabled the two other plugins I use (Warp iMagick – Image Compressor and Easy Hide Login) and tried with Storefront Theme (I use Deli Theme) on a new firefox private window (no cookies nor cache) and problem persisted. Everything is up to date. There are no Duplicate attributes (screenshot attached)

I attach screenshots of everything. There were two pending actions and I ran them but they didn’t seem to have to do with it. (screenshot attached)

thanks again!!
Screenshots:

https://next.geoma.casa/index.php/s/XFQtK2EmkmGCFPr

` WordPress Environment

WordPress address (URL): https://alma.geoma.casa<br>Site address (URL): https://alma.geoma.casa<br>WC Version: 8.2.1<br>REST API Version: ? 8.2.1<br>WC Blocks Version: ? 11.1.2<br>Action Scheduler Version: ? 3.6.3<br>Log Directory Writable: ?<br>WP Version: 6.3.2<br>WP Multisite: –<br>WP Memory Limit: 768 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: es_ES<br>External object cache: – Server Environment

Server Info: LiteSpeed<br>PHP Version: 7.4.33<br>PHP Post Max Size: 128 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 10000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w

SUHOSIN Installed: –<br>MySQL Version: 8.0.32-cll-lve<br>Max Upload Size: 128 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

WC Database Version: 8.2.1<br>WC Database Prefix:<br>Total Database Size: 20.41MB<br>Database Data Size: 16.02MB<br>Database Index Size: 4.39MB<br>woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>woocommerce_order_itemmeta: Data: 0.39MB + Index: 0.34MB + Engine InnoDB<br>woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>actionscheduler_actions: Data: 0.42MB + Index: 0.42MB + Engine InnoDB<br>actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>actionscheduler_logs: Data: 0.31MB + Index: 0.20MB + Engine InnoDB<br>commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>comments: Data: 0.13MB + Index: 0.09MB + Engine InnoDB<br>links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>options: Data: 9.20MB + Index: 0.17MB + Engine InnoDB<br>postmeta: Data: 2.52MB + Index: 0.83MB + Engine InnoDB<br>posts: Data: 0.30MB + Index: 0.22MB + Engine InnoDB<br>term_relationships: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>usermeta: Data: 0.11MB + Index: 0.09MB + Engine InnoDB<br>users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wc_product_meta_lookup: Data: 1.52MB + Index: 0.83MB + Engine InnoDB<br>wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB Post Type Counts

attachment: 398<br>nav_menu_item: 21<br>page: 9<br>post: 1<br>product: 592<br>product_variation: 46<br>revision: 11<br>shop_coupon: 2<br>shop_order: 55<br>wp_global_styles: 2 Security

Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (3)

Easy Hide Login: by Arshid – 1.0.9<br>Warp iMagick - Image Compressor: by PageSpeed Club – 1.9.5.1<br>WooCommerce: by Automattic – 8.2.1 Inactive Plugins (3)

A2 Optimized WP: by A2 Hosting – 3.0.6.6<br>Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3<br>Jetpack: by Automattic – 11.2.1 Settings

API Enabled: –<br>Force SSL: –<br>Currency: CLP ($)<br>Currency Position: left<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 0<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)

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

Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Shop base: ? Page not set<br>Cart: #6 - /cart/<br>Checkout: #7 - /checkout/<br>My account: #8 - /my-account/<br>Terms and conditions: ? Page not set Theme

Name: Storefront<br>Version: 4.5.3<br>Author URL: https://woocommerce.com/<br>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<br>WooCommerce Support: ? Templates

Overrides: – Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>settings<br>async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-11-02 19:09:45 -04:00<br>Options: ?<br>Notes: 145<br>Onboarding: completed Action Scheduler

Complete: 1,300<br>Oldest: 2023-10-02 02:06:06 +0000<br>Newest: 2023-11-01 19:48:44 +0000

Failed: 10<br>Oldest: 2023-02-15 04:07:37 +0000<br>Newest: 2023-11-01 19:52:04 +0000

Pending: 2<br>Oldest: 2023-11-01 23:50:15 +0000<br>Newest: 2023-11-01 23:50:15 +0000 Status report information

Generated at: 2023-11-01 15:57:33 -04:00<br>`

Hi @geomatha

Thanks for shairng the requested information above.

Can you please share if you are filtering orders for simple products under Analytics > Orders?

If so, kindly be informed that this was raised as a feature request: https://github.com/woocommerce/woocommerce/pull/37385 however, this was closed as it’s not yet a priority this time.

However, I’m adding this thread as a comment to this closed bug report as well: https://github.com/woocommerce/woocommerce/issues/32237

In the meantime, can you please share with us what you are trying to achieve on your site so that we can point you in the right direction?

Once we have more information, we’ll be able to assist you further.

Thanks! Yes, Analytics– Orders.

So sorry to hear this…. in my opinion, the UX suggests it should work.

My case is almost the same as the person reporting the bug. The attribute we are using is “proveedor”, which is the supplier of the product. Could also be the “author” We need a report with all the products, that have been ordered within specific dates, of every specific supplier, so we can order them their monthly order.

I hope the bug gets solved.

Can you think of a workaround in the meanwhile?

thanks!

Hi @geomatha

At the time being, we can’t give you an estimate for when the team will look into or fix the issue as bug reports are prioritised based on a few criteria. Please subscribe to the comments or GitHub here if you’d like to receive updates.

If you have any other questions, feel free to ask.

Thanks!

Thanks. I hope this gets attention soon.

Thanks!