Some products not showing when sorting products by price

Hey there,

Thanks for all of that information!

Here’s another idea: can you please go to Settings > Permalinks and click “save” at the bottom?

Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

Hi Hannah,
Thank you.
I tried the permalink suggestion, but unfortunately that hasnt solved the problem.

The site is running woocommerce multistore (https://woomultistore.com). All products have been copied over to the child stores (as evidenced when you sort via default method). The dev at multistore says that this is nothing to do with his plugin is ‘not involved in displaying things in any way.’ (We also tried disabling the multistore plugin and the issue still remained.

I have copied the system report below:

### WordPress Environment ###

Home URL: https://londonmutual.owncomforts.co.uk
Site URL: https://londonmutual.owncomforts.co.uk
WC Version: 3.5.1
Log Directory Writable: ?
WP Version: 4.9.8
WP Multisite: ?
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.1.24 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 512 MB
PHP Time Limit: 240
PHP Max Input Vars: 16000
cURL Version: 7.60.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 10.1.36-MariaDB-cll-lve
Max Upload Size: 15 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.5.1
WC Database Prefix: wp_4_
MaxMind GeoIP Database: ?
Total Database Size: 21.48MB
Database Data Size: 14.79MB
Database Index Size: 6.69MB
wp_4_woocommerce_sessions: ? Table does not exist
wp_4_woocommerce_api_keys: ? Table does not exist
wp_4_woocommerce_attribute_taxonomies: ? Table does not exist
wp_4_woocommerce_downloadable_product_permissions: ? Table does not exist
wp_4_woocommerce_order_items: ? Table does not exist
wp_4_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB
wp_4_woocommerce_tax_rates: ? Table does not exist
wp_4_woocommerce_tax_rate_locations: ? Table does not exist
wp_4_woocommerce_shipping_zones: ? Table does not exist
wp_4_woocommerce_shipping_zone_locations: ? Table does not exist
wp_4_woocommerce_shipping_zone_methods: ? Table does not exist
wp_4_woocommerce_payment_tokens: ? Table does not exist
wp_4_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
wp_4_woocommerce_log: ? Table does not exist
wp_4_commentmeta: Data: 0.00MB + Index: 0.00MB
wp_4_comments: Data: 0.01MB + Index: 0.01MB
wp_4_links: Data: 0.00MB + Index: 0.00MB
wp_4_options: Data: 0.75MB + Index: 0.07MB
wp_4_postmeta: Data: 12.01MB + Index: 5.97MB
wp_4_posts: Data: 1.45MB + Index: 0.38MB
wp_4_termmeta: Data: 0.01MB + Index: 0.02MB
wp_4_terms: Data: 0.01MB + Index: 0.01MB
wp_4_term_relationships: Data: 0.07MB + Index: 0.15MB
wp_4_term_taxonomy: Data: 0.01MB + Index: 0.01MB
wp_blogs: Data: 0.00MB + Index: 0.00MB
wp_blog_versions: Data: 0.00MB + Index: 0.00MB
wp_registration_log: Data: 0.00MB + Index: 0.00MB
wp_signups: Data: 0.00MB + Index: 0.01MB
wp_site: Data: 0.00MB + Index: 0.01MB
wp_sitemeta: Data: 0.11MB + Index: 0.01MB
wp_usermeta: Data: 0.35MB + Index: 0.02MB
wp_users: Data: 0.00MB + Index: 0.01MB

### Post Type Counts ###

acf-field: 12
acf-field-group: 4
attachment: 2060
br_force_sell: 6
customize_changeset: 2
nav_menu_item: 44
page: 16
post: 4
product: 421
product_variation: 410
revision: 37
shop_order: 9
static_block: 3
wpcf7_contact_form: 2

### Security ###

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

### Active Plugins (26) ###

Crafty Clicks Postcode Lookup: by Crafty Clicks – 1.2.8 – Not tested with the active version of WooCommerce
Force Sell for WooCommerce: by BeRocket – 3.0 – Not tested with the active version of WooCommerce
WooCommerce Credit Gateway: by CK Creative – 1.0 – Not tested with the active version of WooCommerce
WordPress Importer: by wordpressdotorg – 0.6.4
WooCommerce: by Automattic – 3.5.1
Advanced Custom Fields: by Elliot Condon – 5.7.7
Admin CSS MU: by Arun Basil Lal – 2.5
Booster for WooCommerce: by Algoritmika Ltd – 4.0.1 – Not tested with the active version of WooCommerce
Duplicate Menu: by Jonathan Christopher – 0.2.1
Electro Extensions: by MadrasThemes – 2.0.10 – Not tested with the active version of WooCommerce
Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 5.3.5
Limit Login Attempts Reloaded: by wpchefgadget – 2.7.1
Min and Max Quantity for WooCommerce: by BeRocket – 1.2.9.1 – Not tested with the active version of WooCommerce
Nav Menu Roles: by Kathy Darling – 1.9.2
Redux Framework: by Team Redux – 3.6.15
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.0.2
Sticky Menu (or Anything!) on Scroll: by Mark Senff – 2.1.1
WooCommerce Cost of Goods: by WooThemes / SkyVerge – 2.0.1 – 2.8.1 is available – Not tested with the active version of WooCommerce
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.18 – 1.10.20 is available – Not tested with the active version of WooCommerce
WP Mail SMTP: by WPForms – 1.3.3
WP Super Cache: by Automattic – 1.6.4
YITH WooCommerce Wishlist: by YITH – 2.2.5
YITH Purchased Column for WooCommerce: by YITHEMES – 1.1.2 – Not tested with the active version of WooCommerce
WPS Menu Exporter: by WPServeur
NicolasKulka – 1.2.1

WPBakery Page Builder: by Michael M - WPBakery.com – 5.5.2
WooCommerce Multistore: by Lykke Media AS – 2.0.3 – Not tested with the active version of WooCommerce

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
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)

### WC Pages ###

Shop base: #4 - /shop/
Basket: #5 - /basket/
Checkout: #6 - /checkout/
My account: ? Page not set
Terms and conditions: ? Page not set

### Theme ###

Name: Own Comfort Child
Version: 2.0.7
Author URL: https://www.ckcreativedesign.co.uk
Child Theme: ?
Parent Theme Name: Owncomforts
Parent Theme Version: 2.0.10
Parent Theme Author URL:
WooCommerce Support: ?

### Templates ###

Overrides: owncomfort/woocommerce/archive-product.php
owncomfort-child/woocommerce/content-product.php
owncomfort-child/woocommerce/emails/customer-on-hold-order.php
owncomfort-child/woocommerce/emails/customer-processing-order.php
owncomfort/woocommerce/global/quantity-input.php
owncomfort-child/woocommerce/single-product/meta.php
owncomfort-child/woocommerce/single-product/title.php

Hi, can you perhaps do a test on the products not showing, open them up in wp-admin and just resave them and see if they start showing up again?

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.