Not all instock products are shown on the shop page

Hi @koalakommerce

Thanks for reaching out!

I understand that there are in stock products that are not being displayed on your site, correct?

Can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?

If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.

You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

Let us know how it goes!

Hi @xue28,
thanks for your reply.

I understand that there are?in stock?products that are not being displayed on your site, correct?

Yes this is correct.

Can you please try to switch to the?default Storefront theme?and only WooCommerce plugin is enabled and see if this works?

Did this and the problem is still there.

If this did not resolve the issue, please share your?System Status Report, that will help us further troubleshoot.

This is the report:

`
### WordPress Environment ###

WordPress address (URL): XXXXXX
Site address (URL): XXXXXX
WC Version: 7.2.2
REST API Version: ?</img> 7.2.2
WC Blocks Version: ?</img> 8.9.2
Action Scheduler Version: ?</img> 3.4.0
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?</img>
Language: de_DE
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.26
PHP Post Max Size: 330 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.81.0
OpenSSL/3.0.2

SUHOSIN Installed: –
MySQL Version: 10.6.11-MariaDB-0ubuntu0.22.04.1
Max Upload Size: 290 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

### Database ###

WC Database Version: 7.2.2
WC Database Prefix: 95zJw5_
Total Database Size: 360.12MB
Database Data Size: 225.30MB
Database Index Size: 134.82MB
95zJw5_woocommerce_sessions: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
95zJw5_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
95zJw5_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
95zJw5_woocommerce_order_items: Data: 0.22MB + Index: 0.08MB + Engine InnoDB
95zJw5_woocommerce_order_itemmeta: Data: 1.52MB + Index: 3.03MB + Engine InnoDB
95zJw5_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
95zJw5_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
95zJw5_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
95zJw5_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
95zJw5_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_actionscheduler_actions: Data: 19.55MB + Index: 19.13MB + Engine InnoDB
95zJw5_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_actionscheduler_logs: Data: 16.55MB + Index: 12.03MB + Engine InnoDB
95zJw5_advanced_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_advanced_notification_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_alm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_borlabs_cookie_statistics: Data: 1.52MB + Index: 0.73MB + Engine InnoDB
95zJw5_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
95zJw5_comments: Data: 1.52MB + Index: 0.86MB + Engine InnoDB
95zJw5_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_options: Data: 31.56MB + Index: 17.13MB + Engine InnoDB
95zJw5_popup_banners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_popup_banners_form_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_popup_banners_subscription_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_postmeta: Data: 90.61MB + Index: 59.22MB + Engine InnoDB
95zJw5_posts: Data: 42.55MB + Index: 6.05MB + Engine InnoDB
95zJw5_termmeta: Data: 0.09MB + Index: 0.17MB + Engine InnoDB
95zJw5_terms: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
95zJw5_term_relationships: Data: 2.52MB + Index: 2.52MB + Engine InnoDB
95zJw5_term_taxonomy: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
95zJw5_usermeta: Data: 1.52MB + Index: 0.52MB + Engine InnoDB
95zJw5_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
95zJw5_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
95zJw5_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
95zJw5_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_wc_customer_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
95zJw5_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
95zJw5_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
95zJw5_wc_order_product_lookup: Data: 0.16MB + Index: 0.19MB + Engine InnoDB
95zJw5_wc_order_stats: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
95zJw5_wc_order_tax_lookup: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
95zJw5_wc_product_attributes_lookup: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
95zJw5_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_wc_product_meta_lookup: Data: 1.52MB + Index: 2.89MB + Engine InnoDB
95zJw5_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_wpf_filters: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
95zJw5_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
95zJw5_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_yoast_indexable: Data: 7.52MB + Index: 6.53MB + Engine InnoDB
95zJw5_yoast_indexable_hierarchy: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
95zJw5_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
95zJw5_yoast_primary_term: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
95zJw5_yoast_seo_links: Data: 0.23MB + Index: 0.17MB + Engine InnoDB

### Post Type Counts ###

attachment: 3823
br_product_filter: 1
custom_css: 3
et_body_layout: 5
et_footer_layout: 1
et_header_layout: 1
et_pb_layout: 12
et_template: 6
et_theme_builder: 1
nav_menu_item: 31
page: 28
popup: 2
popup_theme: 8
post: 5
product: 1403
product_variation: 9206
revision: 4968
shop_coupon: 1
shop_order: 717
shop_order_refund: 198
wp_global_styles: 1

### Security ###

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

### Active Plugins (2) ###

woo-shipping-rate: by  –
WooCommerce: by Automattic – 7.2.2

### Inactive Plugins (5) ###

Product Filter by WooBeWoo: by WooBeWoo – 2.2.6
WooCommerce Admin: by WooCommerce – 3.3.2
WooCommerce Shipment Tracking: by WooCommerce – 1.6.28
Woo Product Filter PRO: by WooBeWoo – 2.2.5
WordPress Importer: by wordpressdotorg – 0.8

### Dropin Plugins (1) ###

maintenance.php: maintenance.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
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: –
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

### WC Pages ###

Shop base: #55 - /shop/
Cart: #57 - /warenkorb/
Checkout: #59 - /kasse/
My account: #61 - /mein-konto/
Terms and conditions: ?</img> Page not set

### Theme ###

Name: Storefront
Version: 4.2.0
Author URL: https://woocommerce.com/
Child Theme: ?</img> – 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
WooCommerce Support: ?</img>

### Templates ###

Overrides: –

### Admin ###

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

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ?</img> Next scheduled: 2023-01-07 15:55:27 +01:00
Options: ?</img>
Notes: 101
Onboarding: completed

### Action Scheduler ###

Complete: 67,167
Oldest: 2022-12-05 17:27:47 +0000
Newest: 2023-01-06 16:08:20 +0000

Failed: 8
Oldest: 2021-03-29 05:01:06 +0000
Newest: 2022-04-05 12:56:39 +0000

Pending: 1
Oldest: 2023-01-06 17:31:55 +0000
Newest: 2023-01-06 17:31:55 +0000


### Status report information ###

Generated at: 2023-01-06 17:31:17 +01:00
`

If you could also provide the?fatal error logs?(if any) under?WooCommerce > Status > Logs.

The latest fatal error log is from 2022-12-19 with this content: (removed the domain)

2022-12-19T11:02:39+00:00 CRITICAL Uncaught TypeError: substr(): Argument #1 ($string) must be of type string, array given in /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woo-product-filter/modules/woofilters/mod.php:353
Stack trace:
#0 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woo-product-filter/modules/woofilters/mod.php(353): substr()
#1 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woo-product-filter/modules/woofilters/mod.php(615): WoofiltersWpf->addCustomTaxQuery()
#2 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woo-product-filter/modules/woofilters/mod.php(685): WoofiltersWpf->getQueryVars()
#3 /var/www/vhosts/example.com/httpdocs/wp-includes/class-wp-hook.php(292): WoofiltersWpf->loadShortcodeProductsFilter()
#4 /var/www/vhosts/example.com/httpdocs/wp-includes/plugin.php(212): WP_Hook->apply_filters()
#5 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woocommerce/includes/shortcodes/class-wc-shortcode-products.php(235): apply_filters()
#6 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woocommerce/includes/shortcodes/class-wc-shortcode-products.php(60): WC_Shortcode_Products->parse_query_args()
#7 /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woocommerce/includes/class-wc-shortcodes.php(281): WC_Shortcode_Products->__construct()
#8 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(343): WC_Shortcodes::products()
#9 [internal function]: do_shortcode_tag()
#10 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(218): preg_replace_callback()
#11 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/module/Shop.php(666): do_shortcode()
#12 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/module/Shop.php(869): ET_Builder_Module_Shop->get_shop()
#13 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/class-et-builder-element.php(3056): ET_Builder_Module_Shop->render()
#14 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(343): ET_Builder_Element->_render()
#15 [internal function]: do_shortcode_tag()
#16 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(218): preg_replace_callback()
#17 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/main-structure-elements.php(3062): do_shortcode()
#18 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/class-et-builder-element.php(3056): ET_Builder_Column->render()
#19 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(343): ET_Builder_Element->_render()
#20 [internal function]: do_shortcode_tag()
#21 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(218): preg_replace_callback()
#22 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/main-structure-elements.php(1885): do_shortcode()
#23 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/class-et-builder-element.php(3056): ET_Builder_Row->render()
#24 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(343): ET_Builder_Element->_render()
#25 [internal function]: do_shortcode_tag()
#26 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(218): preg_replace_callback()
#27 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/main-structure-elements.php(1272): do_shortcode()
#28 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/includes/builder/class-et-builder-element.php(3056): ET_Builder_Section->render()
#29 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(343): ET_Builder_Element->_render()
#30 [internal function]: do_shortcode_tag()
#31 /var/www/vhosts/example.com/httpdocs/wp-includes/shortcodes.php(218): preg_replace_callback()
#32 /var/www/vhosts/example.com/httpdocs/wp-includes/class-wp-hook.php(292): do_shortcode()
#33 /var/www/vhosts/example.com/httpdocs/wp-includes/plugin.php(212): WP_Hook->apply_filters()
#34 /var/www/vhosts/example.com/httpdocs/wp-includes/post-template.php(253): apply_filters()
#35 /var/www/vhosts/example.com/httpdocs/wp-content/themes/Divi/page.php(46): the_content()
#36 /var/www/vhosts/example.com/httpdocs/wp-includes/template-loader.php(106): include('...')
#37 /var/www/vhosts/example.com/httpdocs/wp-blog-header.php(19): require_once('...')
#38 /var/www/vhosts/example.com/httpdocs/index.php(17): require('...')
#39 {main}
  thrown in /var/www/vhosts/example.com/httpdocs/wp-content/plugins/woo-product-filter/modules/woofilters/mod.php in Zeile 353

If more information is needed, I will be happy to provide it.

With kind regards,
Stefan

Hi @koalakommerce

Did this and the problem is still there.

This is quite weird. Can you please disable if you have any custom code on your site and see if this works?

Thanks for sharing the error logs. This is pointing to the Woo Product Filter PRO: by WooBeWoo – 2.2.5

Since this is a third-party plugin which we don’t provide support for (please see our Support Policy here), it would be best reaching out to the plugin’s developers for further assistance here.

https://www.ads-software.com/support/plugin/woo-product-filter/

All the best and hopefully, the issue will be fixed soon.