Support » Plugin: WooCommerce » Products not visible in shop / loop

  • Resolved vi54

    (@vi54)


    I have 16 products in my database of which only 13 are showing when I enable : hide out of stock products.

    I have experimented with:

    //update_post_meta( $product_id, ‘_stock’, 0 ); // stock count
    //update_post_meta( $product_id, ‘_stock_status’, ‘outofstock’ ); // stock status

    this worked fine… Then I reversed the process
    //update_post_meta( $product_id, ‘_stock’, 100 ); // stock count
    //update_post_meta( $product_id, ‘_stock_status’, ‘instock’ ); // stock status

    All items are back in stock and I have double checked the settings and all settings are Product visibility: Store and search results

    Resume:
    I have 16 instock items in my WooCommerce admin all are visible set in store and search results.
    Hide out of stock items checked only shows 13 products in my loop/loop…
    When I disable hide out of stock items I see 16 products in my shop/loop…

    All products that are not directly visible from the shop can be linked and viewed at page level and even purchased.

    When I duplicate the product that is not showing up this way… it becomes visible…

    So I guess there an out of stock area that I am missing?
    Does anyone know what I am missing here?

    Thank you for your expert advise.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support laceyrod a11n

    (@laceyrod)

    Automattic Happiness Engineer

    Hi @vi54

    Thanks for reaching out. What a strange issue going on!

    I was thinking perhaps these missing products were variable products that you might have had marked as Out of Stock at a parent level or some scenario like that, but since you’re able to actually add the product to cart and purchase it…that’s what’s strange!

    Can you send us a screenshot of the product data box for the items that are missing? Also, would you mind copying and pasting your System Status Report into this thread so that we can check for any red flags there? You can find this by going to WooCommerce > Status > System Status > Get System Report in your WP-Admin dashboard.

    Thanks and looking forward to your reply!

    Thread Starter vi54

    (@vi54)

    Thank you very much.
    That could be very well indeed… I use a plugin to set some optional product items. Now that I think of that…

    The data box is all good. I can’t upload screenshots here. But I can asure that the data box is: published, public, current date, shop and search visible.

    Is there a hook or script to update ALL stocks? Regardless of what product type?

    Here is the status report:
    ### WordPress Environment ###

    WordPress address (URL): edit for privacy
    Site address (URL): edit for privacy
    WC Version: 4.9.0
    REST API Version: ✔ 4.9.0
    WC Blocks Version: ✔ 4.0.0
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.8.3
    Log Directory Writable: ✔
    WP Version: 5.6
    WP Multisite: –
    WP Memory Limit: 819 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: nl_NL
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.4.14
    PHP Post Max Size: 256 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 5000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.27-MariaDB-1:10.3.27+maria~focal
    Max Upload Size: 256 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    WC Database Version: 4.9.0
    WC Database Prefix: ff_
    Totale databasegrootte: 1081.38MB
    Database datagrootte: 736.85MB
    Database index grootte: 344.53MB
    ff_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    ff_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    ff_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_actionscheduler_actions: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
    ff_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_actionscheduler_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    ff_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    ff_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_options: Data: 3.48MB + Index: 0.17MB + Engine InnoDB
    ff_postmeta: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
    ff_posts: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
    ff_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_sliders: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_slides: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_snippets: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    ff_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    ff_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    ff_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    ff_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    ff_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    ff_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    ff_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    ff_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

    ### Post Type Counts ###

    acf-field: 2
    acf-field-group: 1
    attachment: 27
    customize_changeset: 8
    elementor_library: 1
    nav_menu_item: 3
    page: 7
    post: 2
    product: 22
    revision: 44
    shop_order: 4
    uni_cpo_option: 1
    wapf_product: 3

    ### Security ###

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

    ### Active Plugins (12) ###

    Advanced Custom Fields PRO: door Elliot Condon – 5.9.3
    Advanced Product Fields for WooCommerce: door StudioWombat – 1.3.4
    Codefragmenten: door Code Snippets Pro – 2.14.0
    Elementor: door Elementor.com – 3.0.16
    Envato Market: door Envato – 2.0.6
    WPBakery Page Builder: door Michael M – WPBakery.com – 6.5.0
    Loco Translate: door Tim Whitlock – 2.5.0
    WPC Product Timer for WooCommerce: door WPClever.net – 3.0.0
    WooCommerce Checkout Field Editor Pro: door ThemeHiGH – 2.9.5 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.0
    WOOF – WooCommerce Products Filter: door realmag777 – 1.2.4.2
    WooCommerce: door Automattic – 4.9.0
    WOOF by Category: door KAGG Design – 2.11

    ### Inactive Plugins (2) ###

    WP-Optimize – Clean, Compress, Cache: door David Anderson
    Ruhani Rabin
    Team Updraft – 3.1.6

    WP Fastest Cache: door Emre Vona – 0.9.1.4

    ### 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)
    instock (instock)
    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: #20 – /shop/
    Winkelmand: #21 – /cart/
    Afrekenen: #22 – /checkout/
    Mijn account: #23 – /my-account/
    Algemene voorwaarden: #1246 – /algemene-voorwaarde/

    ### Theme ###

    Name: Flatsome
    Version: 3.13.1
    Author URL: http://www.uxthemes.com/
    Child Theme: ❌ – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt
    raden we het gebruik van een child thema aan. Zie: Hoe maak je een child thema

    WooCommerce Support: ✔

    ### Templates ###

    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product-cat.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    flatsome/woocommerce/content-product_cat.php

    ### Action Scheduler ###

    Afgerond: 260
    Oldest: 2021-01-05 14:03:37 +0100
    Newest: 2021-01-14 13:53:03 +0100

    • This reply was modified 1 year, 5 months ago by vi54.
    Plugin Support laceyrod a11n

    (@laceyrod)

    Automattic Happiness Engineer

    Hey @vi54

    Thanks for your reply!

    The data box is all good. I can’t upload screenshots here. But I can asure that the data box is: published, public, current date, shop and search visible.

    Makes sense. I just wanted to make sure the stock settings were properly listed but since you were able to add to cart, I don’t suspect there’s an issue there.

    A thought…are the products showing up as in stock in the WordPress database?

    That could be very well indeed… I use a plugin to set some optional product items. Now that I think of that…

    I did see the Advanced Product Fields for WooCommerce plugin, and while I’m not 100% certain of what it does, I would recommend testing with this disabled just to rule it out.

    Outside of that, while you don’t have a lot of plugins installed, your theme does have quite a few template overrides. I would also recommend running a full conflict test to see if the problem still persists with just WooCommerce and a default theme active: https://docs.woocommerce.com/document/woocommerce-self-service-guide/

    Please take these steps and let us know how this goes.

    Plugin Support abwaita a11n

    (@abwaita)

    Hi @vi54,

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!

    If you have further questions, please feel free to open a new topic.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Products not visible in shop / loop’ is closed to new replies.