No Imported Products Show Up in a Frontend Search
-
We recently added 5,000 products to our website using the built-in Woocommerce importer.
Not one of them appears in the front end search results when we search for them. 100% of them appear in the Admin search perfectly.
We cleared the WP Rocket Cache 5 times, so that’s not the issue.
Ideas?
Example:
Search title:
Marantz PMD-602A 2-Channel DSLR Audio InterfaceURL:
https://djdeals.com/product/marantz-pmd-602a-2-channel-dslr-audio-interface/Search results:
https://djdeals.com/product-categories/?product_cat=&post_type=product&s=Marantz+PMD-602A+2-Channel+DSLR+Audio+Interface“No products were found matching your selection.”
-
Hi @joyryde ,
This is possible if the visibility of the products are set to “Shop” only. Can you please open the product pages and check the visibility options, they should be set to “Shop and Search results” in order to show in search. Please see the screenshot for reference:
https://d.pr/i/Y6X4hBDo let us know if you have any further queries.
All 9,000 products on the website show this:
“Catalog visibility: Shop and search results”
We just created 2 new products as a test, both show up in the search results immediately, not one of the 5,000 items we imported shows up.
Test result:
https://djdeals.com/product-categories/?product_cat=&post_type=product&s=SHURE+SE425
Hi @joyryde ,
We just created 2 new products as a test, both show up in the search results immediately, not one of the 5,000 items we imported shows up.
That is odd. I tested by importing products on a test site and they show up in search results as expected.
Could you please share a copy of your site’s System Status so we can understand the sertup better? 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.
### WordPress Environment ### WordPress address (URL): https://djdeals.com Site address (URL): https://djdeals.com WC Version: 4.8.0 REST API Version: ? 4.8.0 WC Blocks Version: ? 3.8.1 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 1.7.3 Log Directory Writable: ? WP Version: 5.6 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.13 PHP Post Max Size: 512 MB PHP Time Limit: 90 PHP Max Input Vars: 5000 cURL Version: 7.73.0 OpenSSL/1.1.1h SUHOSIN Installed: – MySQL Version: 5.6.41-84.1 Max Upload Size: 512 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 4.8.0 WC Database Prefix: ccutf_ Total Database Size: 334.75MB Database Data Size: 238.94MB Database Index Size: 95.81MB ccutf_woocommerce_sessions: Data: 9.46MB + Index: 0.26MB + Engine MyISAM ccutf_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ccutf_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_woocommerce_order_items: Data: 0.34MB + Index: 0.16MB + Engine MyISAM ccutf_woocommerce_order_itemmeta: Data: 1.96MB + Index: 1.31MB + Engine MyISAM ccutf_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ccutf_woocommerce_tax_rate_locations: Data: 0.08MB + Index: 0.10MB + Engine MyISAM ccutf_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ccutf_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM ccutf_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM ccutf_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_actionscheduler_actions: Data: 2.23MB + Index: 0.51MB + Engine MyISAM ccutf_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ccutf_actionscheduler_logs: Data: 1.05MB + Index: 0.75MB + Engine MyISAM ccutf_ac_abandoned_cart_history_lite: Data: 0.48MB + Index: 0.01MB + Engine MyISAM ccutf_ac_email_templates_lite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_ac_guest_abandoned_cart_history_lite: Data: 0.04MB + Index: 0.01MB + Engine MyISAM ccutf_ac_sent_history_lite: Data: 0.01MB + Index: 0.00MB + Engine MyISAM ccutf_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_advanced_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_advanced_notification_triggers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM ccutf_aiowps_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_aiowps_failed_logins: Data: 1.13MB + Index: 0.26MB + Engine MyISAM ccutf_aiowps_global_meta: Data: 17.52MB + Index: 0.00MB + Engine MyISAM ccutf_aiowps_login_activity: Data: 0.05MB + Index: 0.01MB + Engine MyISAM ccutf_aiowps_login_lockdown: Data: 0.37MB + Index: 0.07MB + Engine MyISAM ccutf_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_blc_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_blc_instances: Data: 0.08MB + Index: 0.03MB + Engine MyISAM ccutf_blc_links: Data: 0.46MB + Index: 0.05MB + Engine MyISAM ccutf_blc_synch: Data: 0.14MB + Index: 0.11MB + Engine MyISAM ccutf_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM ccutf_comments: Data: 1.54MB + Index: 0.71MB + Engine MyISAM ccutf_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_options: Data: 8.65MB + Index: 1.65MB + Engine MyISAM ccutf_postmeta: Data: 79.12MB + Index: 22.54MB + Engine MyISAM ccutf_posts: Data: 29.78MB + Index: 2.48MB + Engine MyISAM ccutf_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_rank_math_404_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_rank_math_analytics_gsc: Data: 21.55MB + Index: 38.13MB + Engine InnoDB ccutf_rank_math_analytics_objects: Data: 2.52MB + Index: 1.52MB + Engine InnoDB ccutf_rank_math_internal_links: Data: 0.09MB + Index: 0.03MB + Engine MyISAM ccutf_rank_math_internal_meta: Data: 0.19MB + Index: 0.15MB + Engine MyISAM ccutf_rank_math_redirections: Data: 0.18MB + Index: 0.02MB + Engine MyISAM ccutf_rank_math_redirections_cache: Data: 0.07MB + Index: 0.03MB + Engine MyISAM ccutf_rank_math_sc_analytics: Data: 51.21MB + Index: 15.19MB + Engine MyISAM ccutf_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ccutf_termmeta: Data: 0.17MB + Index: 0.11MB + Engine MyISAM ccutf_terms: Data: 1.94MB + Index: 2.49MB + Engine MyISAM ccutf_term_relationships: Data: 1.92MB + Index: 3.41MB + Engine MyISAM ccutf_term_taxonomy: Data: 1.74MB + Index: 1.64MB + Engine MyISAM ccutf_usermeta: Data: 1.70MB + Index: 0.88MB + Engine MyISAM ccutf_users: Data: 0.08MB + Index: 0.09MB + Engine MyISAM ccutf_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM ccutf_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ccutf_wc_customer_lookup: Data: 0.15MB + Index: 0.10MB + Engine MyISAM ccutf_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_wc_order_product_lookup: Data: 0.14MB + Index: 0.11MB + Engine MyISAM ccutf_wc_order_stats: Data: 0.09MB + Index: 0.06MB + Engine MyISAM ccutf_wc_order_tax_lookup: Data: 0.04MB + Index: 0.04MB + Engine MyISAM ccutf_wc_product_meta_lookup: Data: 0.58MB + Index: 0.64MB + Engine MyISAM ccutf_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ccutf_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_wpmailsmtp_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM ccutf_xoo_wl_list: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ccutf_xoo_wl_list_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ### Post Type Counts ### attachment: 14891 custom_css: 3 customize_changeset: 57 mc4wp-form: 1 mgmlp_media_folder: 35 nav_menu_item: 17 oembed_cache: 300 page: 19 post: 2 product: 8374 product_variation: 435 revision: 24 saswp: 1 shop_coupon: 34 shop_order: 1475 shop_order_refund: 157 turbo-sidebar-cpt: 1 wphb_minify_group: 1 yith_best_price: 4 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (59) ### 404page - your smart custom 404 error page: by Peter Raschendorfer – 11.2.6 Actionable Google Analytics: by Tatvic – CC-V3-3.6 All In One WP Security: by Tips and Tricks HQ Peter Petreski Ruhul Ivy – 4.4.5 Attachment Pages Redirect: by Samuel Aguilera – 1.1.1 Better Search Replace: by Delicious Brains – 1.3.4 Booster Plus for WooCommerce: by Pluggabl LLC – 5.3.5 Broken Link Checker: by WPMU DEV – 1.11.15 Bulk remove posts from category: by MasterNs – 3.1.1 CMB2: by CMB2 team – 2.7.0 Custom Related Products for WooCommerce: by Scott Nelle – 1.3 Customer Reviews for WooCommerce: by Customer Reviews – 3.138 Exclude Image Thumbnails From UpdraftPlus Backups: by Dream-Encode – 1.0.2 Disable auto-update Email Notifications: by Email Marketing WP – 1.2 Disable Comments: by WPDeveloper – 2.0.2 Disable Real MIME Check: by Sergey Biryukov – 1.0 WooCommerce Discontinued Products: by Leon @ 211J – 1.1.5 Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.1 Google Customer Reviews for WooCommerce: by eCreations – 2.6.12 Enable Media Replace: by ShortPixel – 3.5.0 Flexible Shipping UPS: by WP Desk – 1.10.3 Imsanity: by Exactly WWW – 2.7.1 Jetpack by WordPress.com: by Automattic – 9.2.1 Kirki Customizer Framework: by David Vongries – 3.1.6 Perfect Brands for WooCommerce: by QuadLayers – 1.8.5 Plugins Garbage Collector (Database Cleanup): by Vladimir Garagulya – 0.12 reSmush.it Image Optimizer: by reSmush.it – 0.3.11 Schema & Structured Data for WP & AMP: by Magazine3 – 1.9.58 Seo 301 Meta: by Mian Shahzeb – 1.9 Rank Math SEO: by Rank Math – 1.0.54.3 Simple Basic Contact Form: by WPKube – 20200901 SSL Insecure Content Fixer: by WebAware – 2.7.2 Statically: by Statically – 0.9.1 Swap Google Fonts Display: by Gijo Varghese – 1.0.6 Trustpilot-reviews: by Trustpilot – 2.5.813 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.43 Woocommerce Waitlist( Back in stock notifier ): by – 2.4 Shipping Insurance WC Addon: by David Myles – 1.0.6 WooCommerce UPC, EAN, and ISBN: by Scott Bolinger – 0.4.0 Premmerce WooCommerce Customers Manager: by premmerce – 1.1.11 Woo Image SEO: by Danail Emandiev – 1.0.2 Product Feed PRO for WooCommerce: by AdTribes.io – 9.2.6 Stripe For WooCommerce: by Payment Plugins [email protected] – 3.2.9 Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.8.3 WooCommerce Advanced Notifications: by WooCommerce – 1.2.29 WooCommerce Amazon Fulfillment: by Never Settle – 3.3.5 WooCommerce Checkout Add-Ons: by SkyVerge – 2.5.0 WooCommerce Conditional Shipping and Payments: by SomewhereWarm – 1.8.10 WooCommerce PayPal Payments: by WooCommerce – 1.0.3 WooCommerce Shipping & Tax: by Automattic – 1.25.4 WooCommerce Shipping Tracking: by Lagudi Domenico – 27.2 WooCommerce USPS Shipping: by WooCommerce – 4.4.49 WooCommerce - StampscomEndicia Integration: by Stamps.comEndicia – 2.0.0 WooCommerce: by Automattic – 4.8.0 WP Mail SMTP: by WPForms – 2.5.1 WP Rocket: by WP Media – 3.8.0.1 WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.3 WP YouTube Lyte: by Frank Goossens (futtta) – 1.7.15 YITH Purchased Column for WooCommerce: by YITHEMES – 1.1.8 ### Inactive Plugins (0) ### ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ? Force SSL: ? Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) outofstock (outofstock) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ? ### WC Pages ### Shop base: #8409 - /product-categories/ Cart: #6 - /cart/ Checkout: #7 - /checkout/ My account: #8 - /my-account/ Terms and conditions: #8792 - /djdeals-com-terms-conditions/ ### Theme ### Name: Universal Store Version: 1.0.5 Author URL: https://themes4wp.com/ Child Theme: ? Parent Theme Name: MaxStore Parent Theme Version: 1.5.2 Parent Theme Author URL: https://themes4wp.com WooCommerce Support: ? ### Templates ### Archive Template: Your theme has a woocommerce.php file you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues. Overrides: – ### Action Scheduler ### Complete: 5,953 Oldest: 2020-12-10 11:11:51 -0500 Newest: 2020-12-17 11:15:31 -0500 Failed: 4 Oldest: 2019-06-06 12:50:21 -0400 Newest: 2020-01-23 15:17:16 -0500 Pending: 4 Oldest: 2020-12-17 11:30:31 -0500 Newest: 2020-12-23 10:32:25 -0500
I read a post that said that imported products won’t show in in search results when they are imported after a theme has been activated.
We imported these products this month, the theme has been active for 3 years.
We tried switching from the child theme we use, to the parent theme, and the products appear in the results in the parent theme.
Upon switching back to the child theme, they do not appear.
Example:
https://djdeals.com/product-categories/?product_cat=&post_type=product&s=SR470
No result.
So now we know that the theme is somehow magically hiding the products in the search results…but how would we fix it?
I found the problem.
We had a custom code that hid the discontinued products from the results, the person who wrote it must have screwed it up and it somehow caused this issue.
When I remove the code, the imported products show up.
Here is the code:
// Hide Discontinued Products add_filter( 'woocommerce_product_query_meta_query', 'show_only_products_with_not_discontinued_meta', 10, 2 ); function show_only_products_with_not_discontinued_meta( $meta_query, $query ) { // Only on shop pages if( ! is_shop() ) return $meta_query; $meta_query[] = array( 'key' => '_is_discontinued', 'compare' => 'NOT EXIST' ); return $meta_query; }
Hi @joyryde ,
It seems the custom code hides the products that are not discounted. I’d recommend reaching out to the developer who wrote the code in case you want to continue using the custom code, but still show the imported products in search results.
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.
Yes, this one is resolved, thanks!
- The topic ‘No Imported Products Show Up in a Frontend Search’ is closed to new replies.