Woocommerce hide out of stock variations

Woocommerce hide out of stock variations how to#

About the proof of conceptД«ecause itвЂ™s only intended as a proof of concept, the solution linked above requires you to manually create and populate the database tables yourself, but the Pull Request contains CSV files and scripts to help streamline this process for folks who want to test it out. The result of this effort is a Pull Request on GitHub with a proof of concept that you can investigate and even test locally today. Using the lessons learned from previous initiatives, such as the implementation of custom tables in Action Scheduler 3.0 and the introduction of lookup tables in WooCommerce 3.6, the core team has recently dived into a new exploration of variation filtering using lookup tables as a stepping stone toward custom tables. Likewise, solving this problem involves migrating the data in the old tables to the new ones on live stores that are processing orders. Because WooCommerce is committed to preserving backwards compatibility, the introduction of custom tables requires a mechanism for synchronizing data between new and legacy tables. Transitioning to new core database tables would be a breaking change since many extensions expect data to be in the wp_post and wp_postmeta tables. You can see an initial exploration of custom tables in the WooCommerce Product Tables feature plugin that was introduced in 2018.ДЄdding the custom tables and data stores is only one piece of what needs to be a diligent solution though. The prevailing solution to the variations issue, and similar issues stemming from the underlying data storage architecture, is to introduce custom database tables for WooCommerce data along with data stores that abstract the database queries into a simple CRUD interface. Because of this, querying variations for operations like product filters and stock availability checks can create a big bottleneck that hinders a storeвЂ™s performance. Product data is stored in the wp_post and wp_postmeta tables in WordPress. The difficulty in properly supporting variation filtering stems from the underlying architecture of WooCommerce and how it is integrated with the WordPress APIs. Why is this functionality difficult to implement in WooCommerce?

This post provides an overview of that exploration along with a glimpse at what the final solution may look like.

Woocommerce hide out of stock variations how to#

Over the past several weeks, the WooCommerce Core team has put additional effort into an exploration of how to best implement the architectural changes that would allow improved filtering on variations. Developers in our community have likewise come up with their own innovative solutions and workarounds over time, but the promise of out-of-the-box variations filtering in WooCommerce has remained unfulfilled. Due to a number of interrelated factors that include technical challenges and competing priorities, however, this particular issue, despite its importance, has needed to be deferred multiple times. The WooCommerce Core team has been aware of this long-standing limitation and has attempted a few different solutions over the past few years.

This quirk makes it difficult for customers to find what theyвЂ™re looking for quickly, which ultimately translates to lost sales and lower revenues for merchants running WooCommerce. Many developers and merchants are likely familiar with a gap in WooCommerceвЂ™s functionality around filtering products based on their variations.