[NSFW] filter by orders attributes

Hi @jgitta. Can you share a screenshot showing a sample custom search that you are referring to please??

Yes. Here is a short screencast on what I am trying to do for this customer,

https://jghud.com/4q

Hi @jgitta. Please share your system report with me. You can find it by going to WooCommerce > Status > Get system report and then click Copy for support to be able to paste it in your reply.

### WordPress Environment ###

WordPress address (URL): https://peekabooonline.com
Site address (URL): https://peekabooonline.com
WC Version: 5.1.0
REST API Version: ? 5.1.0
WC Blocks Version: ? 4.4.3
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.0.2
Log Directory Writable: ?
WP Version: 5.7
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.8
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.52.1
OpenSSL/1.0.2u

SUHOSIN Installed: –
MySQL Version: 5.7.31
Max Upload Size: 64 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: wpmn_
Total Database Size: 100.91MB
Database Data Size: 75.83MB
Database Index Size: 25.08MB
wpmn_woocommerce_sessions: Data: 5.37MB + Index: 0.13MB + Engine MyISAM
wpmn_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmn_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_order_items: Data: 0.59MB + Index: 0.31MB + Engine MyISAM
wpmn_woocommerce_order_itemmeta: Data: 4.10MB + Index: 3.22MB + Engine MyISAM
wpmn_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmn_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpmn_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpmn_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_actionscheduler_actions: Data: 0.74MB + Index: 0.30MB + Engine MyISAM
wpmn_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmn_actionscheduler_logs: Data: 0.57MB + Index: 0.38MB + Engine MyISAM
wpmn_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmn_comments: Data: 1.63MB + Index: 0.59MB + Engine MyISAM
wpmn_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmn_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_options: Data: 16.66MB + Index: 0.64MB + Engine MyISAM
wpmn_postmeta: Data: 33.94MB + Index: 13.20MB + Engine MyISAM
wpmn_posts: Data: 6.99MB + Index: 1.54MB + Engine MyISAM
wpmn_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_termmeta: Data: 0.11MB + Index: 0.08MB + Engine MyISAM
wpmn_terms: Data: 0.07MB + Index: 0.13MB + Engine MyISAM
wpmn_term_relationships: Data: 0.47MB + Index: 1.04MB + Engine MyISAM
wpmn_term_taxonomy: Data: 0.09MB + Index: 0.08MB + Engine MyISAM
wpmn_usermeta: Data: 2.20MB + Index: 1.39MB + Engine MyISAM
wpmn_users: Data: 0.12MB + Index: 0.13MB + Engine MyISAM
wpmn_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_customer_lookup: Data: 0.15MB + Index: 0.17MB + Engine MyISAM
wpmn_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_order_product_lookup: Data: 0.63MB + Index: 0.52MB + Engine MyISAM
wpmn_wc_order_stats: Data: 0.22MB + Index: 0.14MB + Engine MyISAM
wpmn_wc_order_tax_lookup: Data: 0.09MB + Index: 0.10MB + Engine MyISAM
wpmn_wc_point_of_sale_sale_reports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_pos_grid_tiles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_wc_product_meta_lookup: Data: 0.37MB + Index: 0.46MB + Engine MyISAM
wpmn_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmn_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmn_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpmn_woocommerce_gc_activity: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpmn_woocommerce_gc_cards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpmn_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmn_woocommerce_square_customers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmn_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmn_yith_wcwl: Data: 0.17MB + Index: 0.09MB + Engine MyISAM
wpmn_yith_wcwl_lists: Data: 0.18MB + Index: 0.12MB + Engine MyISAM
wp_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB

### Post Type Counts ###

attachment: 4526
babystreet-portfolio: 12
custom_css: 1
nav_menu_item: 20
page: 19
pos_grid: 1
pos_outlet: 1
pos_receipt: 1
pos_register: 2
pos_session: 206
pos_temp_order: 2
post: 14
product: 1885
product_variation: 2340
pwbe_filter: 1
revision: 843
shop_coupon: 2
shop_order: 2941
shop_order_refund: 81
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (21) ###

Query Monitor: by John Blackbourn – 3.6.7
Babystreet Plugin: by theAlThemist – 1.3.7
Contact Form 7: by Takayuki Miyoshi – 5.4
Envato Market: by Envato – 2.0.6
GA Google Analytics: by Jeff Starr – 20210211
Jetpack by WordPress.com: by Automattic – 9.5
WPBakery Page Builder: by Michael M - WPBakery.com – 6.3.0
PW WooCommerce Bulk Edit Pro: by Pimwick
LLC – 2.280

reCaptcha for WooCommerce: by I Thirteen Web Solution – 2.12
Slider Revolution: by ThemePunch – 6.2.22
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.50

Woocommerce Partial Shipment: by Vikram S – 2.5
Woocommerce Blocker: by theDotstore – 1.9.3
WooCommerce Stripe Gateway: by WooCommerce – 5.0.0
WooCommerce Gift Cards: by SomewhereWarm – 1.6.1
Point of Sale for WooCommerce: by Actuality Extensions – 5.4.1
WooCommerce Shipping & Tax: by Automattic – 1.25.10
WooCommerce: by Automattic – 5.1.0
WordPress Importer: by wordpressdotorg – 0.7
WP Mail SMTP: by WPForms – 2.7.0
YITH WooCommerce Wishlist: by YITH – 3.0.20

### Inactive Plugins (3) ###

Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.8
Mailchimp for WooCommerce: by Mailchimp – 2.5.1
Simple User Avatar: by Matteo Manna – 3.1

### Dropin Plugins (1) ###

db.php: Query Monitor Database Class

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
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: #10 - /shop/
Cart: #11 - /cart/
Checkout: #12 - /checkout/
My account: #13 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Babystreet Child
Version: 1.0.0
Author URL: https://www.althemist.com
Child Theme: ?
Parent Theme Name: Babystreet
Parent Theme Version: 1.5.0
Parent Theme Author URL: https://www.althemist.com
WooCommerce Support: ?

### Templates ###

Overrides: babystreet/woocommerce/archive-product.php
babystreet/woocommerce/cart/cart.php
babystreet/woocommerce/content-product-cat.php
babystreet/woocommerce/content-product.php
babystreet/woocommerce/content-single-product.php
babystreet/woocommerce/content-widget-product.php
babystreet/woocommerce/content-widget-reviews.php
babystreet-child/woocommerce/emails/admin-new-order.php
babystreet/woocommerce/global/quantity-input.php
babystreet/woocommerce/global/sidebar.php
babystreet/woocommerce/global/wrapper-end.php
babystreet/woocommerce/global/wrapper-start.php
babystreet/woocommerce/loop/add-to-cart.php
babystreet/woocommerce/loop/loop-end.php
babystreet/woocommerce/loop/loop-start.php
babystreet/woocommerce/loop/orderby.php
babystreet/woocommerce/loop/pagination.php
babystreet/woocommerce/loop/price.php
babystreet/woocommerce/loop/sale-flash.php
babystreet/woocommerce/myaccount/my-account.php
babystreet/woocommerce/product-searchform.php
babystreet/woocommerce/single-product/meta.php
babystreet/woocommerce/single-product/product-image.php
babystreet/woocommerce/single-product/related.php
babystreet/woocommerce/single-product/title.php
babystreet/woocommerce/single-product.php

### Gift Cards ###

Database Version: 1.6.1
Loopback Test: ?
Task Queueing Test: ?

### Action Scheduler ###

Complete: 2,999
Oldest: 2021-03-26 13:21:57 -0500
Newest: 2021-04-01 05:45:58 -0500

### Status report information ###

Generated at: 2021-04-01 10:13:45 -05:00

Hi @jgitta. Thank you for sharing your system status report. I don’t see any red flags but I also was unable to replicate the issue on my test site using the same version of WooCommerce as you. One thought that comes to mind is did you rename the attributes at any point?

My suggested next step is to do some conflict testing using our guide here – https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Hi @jgitta. We haven’t heard from you in a while so I’m going to go ahead and mark this thread as resolved. If you still need help with this issue or have any other questions about the WooCommerce plugin, please start a new thread.