Woocommerce: Any way to list all products *without* a specific attribute?

I’ve had to do something similar recently, create a list of all attributes by product and product variation.

I used SQL to produce the list. It’s a bit basic and I’m sure could be improved easily.

SELECT  wp_posts.id,wp_woocommerce_attribute_taxonomies.attribute_id, wp_woocommerce_attribute_taxonomies.attribute_name,wp_woocommerce_attribute_taxonomies.attribute_label, wp_posts.post_type, wp_posts.post_title FROM wp_woocommerce_attribute_taxonomies,wp_posts WHERE wp_posts.post_type="product_variation" OR wp_posts.post_type="product"

I hope that helps, or points you in the right direction

Cheers

David

Related Posts:

  1. Display single product attribute value on Shop page (Woocommerce)
  2. Get product details by url key in WordPress woocommerce
  3. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  4. Extend Woocommerce rest api routes fails
  5. woocommerce_before_calculate_totals in woocommerce 3.0
  6. How to get all attributes with their terms related to specific Woocommerce product category [closed]
  7. Remove “Choose An Option” on Product Variation & Auto Select Instead
  8. why featured product not updated in postmeta table in woocommerce?
  9. Programmatically adding product attributes to WP / Woo commerce
  10. Woocommerce custom search
  11. Get product variation attribute titles – WooCommerce
  12. How to change Attribute Type
  13. WooCommerce – buying as well as selling
  14. Is it possible to merge Woocommerce attributes? [closed]
  15. Best Practice – Customise a WooCommerce+WordPress Templates
  16. WooCommerce: One term for Many Product Attributes
  17. How to remove product attribute row woocommerce using code
  18. WooCommerce Simple Product Options List
  19. How to add product variations for large number of products in WooCommerce?
  20. WooCommerce: how to set stock per attribute on variable product
  21. Importing Attributes in to Woocommerce
  22. Woocommerce: Some action hooks not firing inside class [closed]
  23. Is it possible Different templates of products for specific category in WooCommerce?
  24. WooCommerce – Adding Product Attributes to CSV Export
  25. WordPress and WooCommerce How to Assign Attribute Based Pricing
  26. Create templates from attributes for categories
  27. Getting the gallery images from products in woocommerce?
  28. add_filter to modify woocommerce_cart_item_name hyperlink
  29. pre_get_posts with WooCommerce Shortcode Query
  30. How to add product images using script?
  31. Reverse engineering of WooCommerce Storefront filters
  32. Use WooCommerce function in other WordPress plugin
  33. WooCommerce – update order item price and recalculate totals
  34. Add product description (content) to WooCommerce customer processing order email
  35. Adding product SKU before cart item name in WooCommerce
  36. Woocommerce: How to remove page title from storefront theme homepage
  37. Remove checkout fields with Woocommerce depending on one of several shipping methods
  38. Replace one coupon to another after coupon added
  39. WooCommerce Multi-Currency shortcode not working
  40. Filter WooCommerce Orders query with user meta data
  41. How to unset fields in woocommerce product quick edit?
  42. rating, share and review issue for single WooCommerce page
  43. Delete All Product Images in phpmyadmin
  44. Custom PLU field in woocommerce email
  45. Add custom field to woocommerce variations [closed]
  46. Change how the Subtotal Price in cart being calculated [closed]
  47. Display Advanced Custom Fields value in Woocommerce admin order details
  48. Some images aren’t shown on wordpress after installation on host
  49. custom payment gateway in woocommerce failed to connect to remote api server
  50. WordPress & WooCommerce: Localhost, Staging and production environments and how to sync them without losing data
  51. PayPal Express on product page in WooCommerce – doesn’t seem to work on product page?
  52. Woocommerce – Want to block a user agent from accessing specific product pages
  53. Reset all stock status in woocommerce
  54. Additional fields on Woocommerce’s rating system
  55. Woocommerce product image [closed]
  56. Question on WooCommerce Syntax
  57. Tax are not showing on order while placing order with REST API
  58. woocommerce_new_product action doesn’t fire
  59. Change The Woocommerce Product Categories Dropdown Widget Placeholder Text
  60. minimum order item for certain products exempting 2 other products (in bulk)
  61. Is it possible to checkout with 2 different shipping options on a single order? [closed]
  62. Sender e-mail address, for new order email to customer, is suddenly wrong [closed]
  63. Undo WooCommerce CSV import
  64. A Woo commerce extension has deleted my old theme.How to undo? [closed]
  65. Woocommerce Advanced Shipping (WAS) condition is not being called when selecting “Ship to different address” [closed]
  66. Strip string from $_product->get_title() to get a cleaner mini-cart
  67. How to get all customers cart from woocommerce API?
  68. WooCommerce login redirect based on cart
  69. Woocommerce + Google Analytics (Conversion Rate Not Working)
  70. send order detail to swiftpos
  71. WordPress Woocommerce REST API JSON Error
  72. data-value for custom woocommerce field showing in code but not visable on page load
  73. Update user meta when customer update their first name
  74. call_user_func_array() expects parameter 1 to be a valid callback, class ‘WC_Rapyd’ does not have a method ‘install’
  75. How can we find a WooCommerce shop bottleneck? (only when cart is full)
  76. Conditional for product attribute page
  77. Setting Page Visibility for WooCommerce Default Page Doesn’t Work
  78. Deleted products from woocommerce are still in the database
  79. Remove cart functionality from WooCommerce so it doesn’t remember the products [closed]
  80. Apply CSS to certain product thumbnails only
  81. Overriding Plugin function in your child theme
  82. Files names changed (with strange characters) after being uploaded to cpanel
  83. woocommerce_add_to_cart custom function called several times
  84. Order Woocommerce Products by On Sale and Alphabetically
  85. Customer Email Address
  86. How to fix spacing in address tab in my account page
  87. Adding time of order to Admin email for new order
  88. Woocommerce list variations that are added already to cart in Single Product
  89. Uninitialised Parameters using woocommerce_checkout_update_order_meta hook
  90. Woocommerce customer role doesn’t change if user is already a subscriber [closed]
  91. Hide add to cart when product variation has no price or is unavailable
  92. How to get the WooCommercer product variation image
  93. how add css class to product boxes li, for img, add cart button, decs, price… [closed]
  94. How can I hide the entire “Shipping Details” block on the admin side of Woocommerce? [closed]
  95. How do I put woocommerce cart page to my checkout page? [closed]
  96. Decrease stock quantity when a variation is sold using Woocommerce
  97. Create WordPress account on different domain when WooCommerce order completed
  98. Creating a woocommerce order when a user creates an account
  99. I want to update shipping charge $0 for all Woocommeerce Subscription auto-renewal orders
  100. Conflict between Woocommerce Booking + Woocommerce Product Options [closed]