Woocommerce product lookup not working correctly

Hello,

As a first step, could you 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.

Hey Maykato,

Thank you for the advice. Here is the report:

### WordPress Environment ###

WordPress address (URL): https://shop-pop.nl
Site address (URL): https://shop-pop.nl
WC Version: 5.6.0
REST API Version: ? 5.6.0
WC Blocks Version: ? 5.5.1
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.5.1
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: nl_NL
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.3.23
PHP Post Max Size: 512 MB
PHP Time Limit: 300
PHP Max Input Vars: 5000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.24-MariaDB-cll-lve
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.6.0
WC Database Prefix: wp_
Totale databasegrootte: 115.64MB
Database datagrootte: 90.40MB
Database index grootte: 25.24MB
wp_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 3.44MB + Index: 1.92MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 2.52MB + Index: 0.80MB + Engine InnoDB
wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
wp_hostnet_mailer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 3.50MB + Index: 0.28MB + Engine InnoDB
wp_postmeta: Data: 8.52MB + Index: 4.03MB + Engine InnoDB
wp_posts: Data: 2.52MB + Index: 0.39MB + Engine InnoDB
wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides: Data: 0.16MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.16MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_soo_wishlists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_soo_wishlists_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_statistics_exclusions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_statistics_historical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_statistics_pages: Data: 2.52MB + Index: 5.23MB + Engine InnoDB
wp_statistics_search: Data: 0.22MB + Index: 0.33MB + Engine InnoDB
wp_statistics_useronline: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_statistics_visit: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_statistics_visitor: Data: 5.52MB + Index: 8.58MB + Engine InnoDB
wp_statistics_visitor_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.08MB + Index: 0.13MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 0.20MB + Index: 0.08MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 0.41MB + Index: 0.14MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpml_mails: Data: 45.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 1164
customize_changeset: 3
custom_css: 2
custom_order_status: 10
mc4wp-form: 1
nav_menu_item: 92
page: 28
portfolio: 15
post: 18
product: 212
product_variation: 276
revision: 296
shop_coupon: 1
shop_order: 539
wcccf: 3
wccpf: 6
wpcf7_contact_form: 2

### Security ###

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

### Active Plugins (40) ###

Access Category Password: door Jojaba – 1.5.1
All-in-One WP Migration Unlimited Extension: door ServMask – 2.42
All-in-One WP Migration: door ServMask – 7.46
Classic Editor: door WordPress Contributors – 1.6.2
Klik om te chatten: door HoliThemes – 3.3.9
Contact Form 7: door Takayuki Miyoshi – 5.4.2
GDPR Cookie-toestemming: door WebToffee – 2.0.5
Custom Order Status for WooCommerce Pro: door Tyche Softwares – 2.0.3
Dupliceer pagina: door mndpsingh287 – 4.4.1
Easy WP SMTP: door wpecommerce
alexanderfoxc – 1.4.7

Facebook for WooCommerce: door Facebook – 2.6.1
Site Kit by Google: door Google – 1.39.0
Hostnet Mailer: door Mike de Heij – 3.3
WPBakery Page Builder: door Michael M - WPBakery.com – 6.6.0
Kadence WooCommerce Email Designer: door Kadence WP – 1.4.7
Kirki Customizer Framework: door David Vongries – 3.1.9
Mailchimp voor WooCommerce: door Mailchimp – 2.5.2
MC4WP: Mailchimp for WordPress: door ibericode – 4.8.6
Meta Box: door MetaBox.io – 5.4.6
Mollie-betalingen voor WooCommerce: door Mollie – 6.5.2
PixelYourSite: door PixelYourSite – 8.2.6
Rearrange Woocommerce Products: door Aslam Doctor – 2.3.6
Redirection: door John Godley – 5.1.3
Slider Revolution: door ThemePunch – 6.4.6
Sober Addons: door UIX Themes – 1.5.2
Soo Demo Importer: door SooThemes – 1.1
Soo Product Filter: door UIX Themes – 1.0.8
Soo Wishlist: door UIX Themes – 1.2.5
Trustpilot-reviews: door Trustpilot – 2.5.886
Variation Swatcher for WooCommerce: door ThemeAlien – 1.0.11
WC Fields Factory: door Saravana Kumar K – 3.0.3
Advanced Order Export For WooCommerce: door AlgolPlus – 3.1.9
WOOCS - WooCommerce Currency Switcher: door realmag777 – 1.3.7
WooCommerce Email Test: door RaiserWeb – 1.2.2
WooCommerce MyParcel: door MyParcel – 4.4.5
WooCommerce: door Automattic – 5.6.0
Wordfence Security: door Wordfence – 7.5.5
WP Instagram Widget: door Scott Evans – 2.0.3
WP Mail Logging: door Wysija – 1.9.8
WP Statistics: door Verona Labs – 13.1

### Inactive Plugins (3) ###

GA Google Analytics: door Jeff Starr – 20210719
Jetpack: door Automattic – 10.0
reSmush.it Image Optimizer: door reSmush.it – 0.4.1

### 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: ?

### WC Pages ###

Winkelbasis: #4 - /shop/
Winkelmand: #2451 - /winkelmand/
Afrekenen: #2452 - /afrekenen/
Mijn account: #7 - /mijn-account/
Algemene voorwaarden: #2621 - /help/algemene-voorwaarden/

### Theme ###

Name: Sober Child Theme
Version: 1.0.0
Author URL: https://uix.store
Child Theme: ?
Parent Theme Name: Sober
Parent Theme Version: 3.1.1
Parent Theme Author URL: https://uix.store
WooCommerce Support: ?

### Templates ###

Overrides: sober/woocommerce/cart/cart-shipping.php
sober/woocommerce/cart/cart.php
sober/woocommerce/cart/mini-cart.php versie 3.7.0 is verouderd. De hoofdversie is 5.2.0
sober/woocommerce/checkout/form-checkout.php
sober/woocommerce/checkout/form-coupon.php
sober/woocommerce/checkout/form-login.php
sober/woocommerce/checkout/review-order.php versie 3.8.0 is verouderd. De hoofdversie is 5.2.0
sober/woocommerce/global/form-login.php
sober/woocommerce/global/quantity-input.php
sober/woocommerce/global/wrapper-end.php
sober/woocommerce/global/wrapper-start.php
sober/woocommerce/loop/add-to-cart.php
sober/woocommerce/loop/price.php
sober/woocommerce/loop/result-count.php
sober/woocommerce/myaccount/dashboard.php
sober/woocommerce/myaccount/form-edit-account.php
sober/woocommerce/myaccount/form-login.php
sober/woocommerce/myaccount/my-address.php
sober/woocommerce/notices/error.php
sober/woocommerce/notices/success.php
sober/woocommerce/order/form-tracking.php
sober/woocommerce/single-product/add-to-cart/external.php
sober/woocommerce/single-product/add-to-cart/grouped.php versie 4.0.0 is verouderd. De hoofdversie is 4.8.0
sober/woocommerce/single-product/add-to-cart/simple.php
sober/woocommerce/single-product/add-to-cart/variable.php
sober/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
sober/woocommerce/single-product/product-image.php
sober/woocommerce/single-product/product-thumbnails.php
sober/woocommerce/single-product/related.php
sober/woocommerce/single-product/review-meta.php
sober/woocommerce/single-product/tabs/additional-information.php
sober/woocommerce/single-product/tabs/tabs.php
sober/woocommerce/single-product/up-sells.php
sober/woocommerce/single-product-reviews.php

Outdated Templates: ?
					
					
						Leer hoe te updaten

### Action Scheduler ###

Afgerond: 7.751
Oldest: 2021-08-28 13:47:06 +0000
Newest: 2021-09-17 09:07:32 +0000

Mislukt: 54
Oldest: –
Newest: –

In afwachting: 3
Oldest: 2021-09-17 09:11:20 +0000
Newest: 2021-09-17 14:46:31 +0000

### Status report information ###

Generated at: 2021-09-17 09:09:19 +00:00

Hi @oscarvanv,

Thanks for sending over your System Status.

Provided the fact you have more than three “hoodie” products this sounds to be an issue caused by a conflicting theme or plugin.

Please make a backup and change the theme to Storefront. Check if the search result only shows three hoodies. If not, you will know the theme is causing this issue and therefore reach out to the theme authors for further assistance.

If you still can only fetch only three results, go on and deactivate all other plugins except WooCommerce and check again. Reactivate your other plugins, one by one, testing after each, until you find the one causing conflict.

You can find a more detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.

Thanks.

Hi there,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.