Products not displaying in store even if they are published and visible
-
There are some products that will not display in the store.
One group of them are all the same brand: Silfen.So when i go to the brand archive for silfen, I see no products:
https://gvq9u1a4vt-staging.wpdns.site/brand/silfen/
But you can see it found 10 results, but none are displaying,If you search for Silfen, you still get nothing:
https://gvq9u1a4vt-staging.wpdns.site/?s=silfen&post_type=productBut the products exists and are visible in store. Here is one example:
https://gvq9u1a4vt-staging.wpdns.site/nettbutikk/vesker-bags/silfen-crossbody-bag-bibbi/
I have tried everything, from rebuilding all indexes/dbs etc. No luck as of yet. I have changed theme to storefront and deactivated EVERY other plugin. Still no change.
I have no clue. It started after I updated plugins and WP last week.
I will try to roll back DB a week back and see if it helps.
Any other suggestions would be great!The page I need help with: [log in to see the link]
-
### WordPress Environment ###WordPress address (URL): https://gvq9u1a4vt-staging.wpdns.siteSite address (URL): https://gvq9u1a4vt-staging.wpdns.siteWC Version: 7.8.0REST API Version: ? 7.8.0WC Blocks Version: ? 10.2.3Action Scheduler Version: ? 3.5.4Log Directory Writable: ?WP Version: 6.2.2WP Multisite: –WP Memory Limit: 1 GBWP Debug Mode: ?WP Cron: ?Language: en_USExternal object cache: –### Server Environment ###Server Info: ApachePHP Version: 7.4.33PHP Post Max Size: 100 MBPHP Time Limit: 600PHP Max Input Vars: 100000cURL Version: 7.87.0OpenSSL/1.1.1pSUHOSIN Installed: –MySQL Version: 8.0.33Max Upload Size: 100 MBDefault Timezone is UTC: ?fsockopen/cURL: ?SoapClient: ?DOMDocument: ?GZip: ?Multibyte String: ?Remote Post: ?Remote Get: ?### Database ###WC Database Version: 7.8.0WC Database Prefix: N849SbE_Total Database Size: 140.81MBDatabase Data Size: 92.44MBDatabase Index Size: 48.37MBN849SbE_woocommerce_sessions: Data: 15.52MB + Index: 0.16MB + Engine InnoDBN849SbE_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDBN849SbE_woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDBN849SbE_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.48MB + Engine InnoDBN849SbE_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDBN849SbE_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_actionscheduler_actions: Data: 1.52MB + Index: 0.98MB + Engine InnoDBN849SbE_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_actionscheduler_logs: Data: 1.52MB + Index: 0.48MB + Engine InnoDBN849SbE_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_comments: Data: 0.23MB + Index: 0.28MB + Engine InnoDBN849SbE_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_mclean_refs: Data: 0.31MB + Index: 0.00MB + Engine InnoDBN849SbE_mclean_scan: Data: 0.06MB + Index: 0.02MB + Engine InnoDBN849SbE_options: Data: 7.52MB + Index: 1.75MB + Engine InnoDBN849SbE_postmeta: Data: 31.56MB + Index: 20.06MB + Engine InnoDBN849SbE_posts: Data: 6.52MB + Index: 4.91MB + Engine InnoDBN849SbE_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_slides: Data: 0.06MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_sbi_feed_caches: Data: 0.08MB + Index: 0.02MB + Engine InnoDBN849SbE_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_sbi_instagram_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDBN849SbE_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_shortpixel_postmeta: Data: 0.02MB + Index: 0.08MB + Engine InnoDBN849SbE_shortpixel_queue: Data: 13.52MB + Index: 0.83MB + Engine InnoDBN849SbE_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDBN849SbE_term_taxonomy: Data: 0.09MB + Index: 0.11MB + Engine InnoDBN849SbE_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_terms: Data: 0.09MB + Index: 0.09MB + Engine InnoDBN849SbE_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_usermeta: Data: 0.16MB + Index: 0.03MB + Engine InnoDBN849SbE_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDBN849SbE_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDBN849SbE_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_wc_order_product_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDBN849SbE_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDBN849SbE_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDBN849SbE_wc_product_attributes_lookup: Data: 3.52MB + Index: 4.52MB + Engine InnoDBN849SbE_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_wc_product_meta_lookup: Data: 3.52MB + Index: 10.09MB + Engine InnoDBN849SbE_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_wdr_order_item_discounts: Data: 0.05MB + Index: 0.05MB + Engine InnoDBN849SbE_wdr_rules: Data: 0.19MB + Index: 0.00MB + Engine InnoDBN849SbE_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDBN849SbE_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDBN849SbE_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDBN849SbE_wpml_mails: Data: 0.05MB + Index: 0.00MB + Engine InnoDBN849SbE_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDBN849SbE_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDBwp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_options: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDBwp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDBwp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDBwp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB### Post Type Counts ###attachment: 6062custom_css: 1elementor_library: 14mc4wp-form: 1nav_menu_item: 110page: 26product: 2774product_variation: 6477shop_coupon: 4shop_order: 182shop_order_refund: 4wp_global_styles: 1wpcf7_contact_form: 1### Security ###Secure connection (HTTPS): ?Hide errors from visitors: ?Error messages should not be shown to visitors.### Active Plugins (1) ###WooCommerce: by Automattic – 7.8.0### Inactive Plugins (35) ###Code Snippets: by Code Snippets Pro – 3.4.0Contact Form 7: by Takayuki Miyoshi – 5.7.7Default Attributes for WooCommerce: by Condless – 1.1.4Dintero Checkout for WooCommerce Payment Methods: by DinteroKrokedil – 1.6.0Elementor: by Elementor.com – 3.13.4Facebook for WooCommerce: by Facebook – 3.0.24FlyingPress: by – 3.9.6Geenie gender-filter: by Bagh Zamir – 2022.11.25Instagram Feed Pro Developer: by Smash Balloon – 6.1Jetpack: by Automattic – 12.2Kirki Customizer Framework: by Themeum – 4.2.0Klarna Order Management for WooCommerce: by klarnakrokedil – 1.7.2Klarna Payments for WooCommerce: by krokedilklarnaautomattic – 3.0.7Loco Translate: by Tim Whitlock – 2.6.4maco.io - Base product handling: by Maksimer – 1.6.0maco.io - Base product variation attributes handling: by Maksimer – 1.4.0Mailchimp for WooCommerce: by Mailchimp – 2.8.3MC4WP: Mailchimp for WordPress: by ibericode – 4.9.5Media Cleaner: by Jordy Meow – 6.6.4Novaworks: by Novaworks – 1.0.4Object Cache Pro: by Rhubarb Group – 1.17.1Perfmatters: by forgemedia – 2.1.0Resize Image After Upload: by ShortPixel – 1.8.6ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 5.2.3Slider Revolution: by ThemePunch – 6.5.11Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.22Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.18Woo Discount Rules: by Flycart – 2.6.0Woo Discount Rules PRO 2.0: by Flycart – 2.5.2WP-Optimize - Clean, Compress, Cache: by David AndersonRuhani RabinTeam Updraft – 3.2.15WPForms Lite: by WPForms – 1.8.2.1WP Mail Logging: by WP Mail Logging Team – 1.11.1WP Mail SMTP: by WP Mail SMTP – 3.8.0YITH WooCommerce Wishlist: by YITH – 3.21.0Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5### Dropin Plugins (1) ###maintenance.php: maintenance.php### Must Use Plugins (1) ###CDN Cache Plugin: by – 1.1.3### Settings ###API Enabled: ?Force SSL: –Currency: NOK (kr)Currency Position: leftThousand Separator: ,Decimal Separator: .Number of Decimals: 2Taxonomies: 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: –HPOS feature screen enabled: –HPOS feature enabled: –Order datastore: WC_Order_Data_Store_CPTHPOS data sync enabled: –### WC Pages ###Shop base: #6 - /nettbutikk/Cart: #2815 - /handlekurv/Checkout: #2816 - /kasse/My account: #2817 - /min-side/Terms and conditions: ? Page not set### Theme ###Name: StorefrontVersion: 4.3.0Author URL: https://woocommerce.com/Child Theme: ? – 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 themeWooCommerce Support: ?### Templates ###Overrides: –### Admin ###Enabled Features: activity-panelsanalyticsproduct-block-editorcouponscustomer-effort-score-tracksimport-products-taskexperimental-fashion-sample-productsshipping-smart-defaultsshipping-setting-tourhomescreenmarketingmobile-app-bannernavigationonboardingonboarding-tasksremote-inbox-notificationsremote-free-extensionspayment-gateway-suggestionsshipping-label-bannersubscriptionsstore-alertstransient-noticeswoo-mobile-welcomewc-pay-promotionwc-pay-welcome-pageDisabled Features: core-profilerminified-jsnew-product-management-experienceproduct-variation-managementsettingsasync-product-editor-category-fieldDaily Cron: ? Next scheduled: 2023-06-20 14:37:37 +02:00Options: ?Notes: 47Onboarding: completed### Action Scheduler ###Canceled: 3Oldest: 2023-05-24 13:14:37 +0200Newest: 2023-06-19 15:38:54 +0200Complete: 2,461Oldest: 2023-05-22 08:42:18 +0200Newest: 2023-06-19 18:00:40 +0200Failed: 315Oldest: 2022-05-12 13:34:08 +0200Newest: 2023-06-19 15:45:06 +0200Pending: 2Oldest: 2023-06-19 19:17:56 +0200Newest: 2023-06-20 07:30:45 +0200### Status report information ###Generated at: 2023-06-19 18:29:59 +02:00
Found out. It was a sync issue. Products were created with weird settings by sync all of a sudden.
Hi @baggyno
Thanks for reaching out!
Found out. It was a sync issue. Products were created with weird settings by sync all of a sudden.
I’m glad you were able to find a solution to your inquiry here and thanks for sharing it with the community too! ??
Cheers!
- The topic ‘Products not displaying in store even if they are published and visible’ is closed to new replies.