No Imported Products Show Up in a Frontend Search

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support wpnomad a11n

    (@wpnomad)

    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/Y6X4hB

    Do let us know if you have any further queries.

    Thread Starter joyryde

    (@joyryde)

    All 9,000 products on the website show this:

    “Catalog visibility: Shop and search results”

    Thread Starter joyryde

    (@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.

    Test result:

    https://djdeals.com/product-categories/?product_cat=&post_type=product&s=SHURE+SE425

    Plugin Support wpnomad a11n

    (@wpnomad)

    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.

    Thread Starter joyryde

    (@joyryde)

    
### 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
    Thread Starter joyryde

    (@joyryde)

    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?

    Thread Starter joyryde

    (@joyryde)

    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;
}
    Plugin Support wpnomad a11n

    (@wpnomad)

    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.

    AJ a11n

    (@amandasjackson)

    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.

    Thread Starter joyryde

    (@joyryde)

    Yes, this one is resolved, thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘No Imported Products Show Up in a Frontend Search’ is closed to new replies.