This product is currently out of stock and unavailable
-
PART A
I have created a woocommerce website using crocoblock plugins ..and so far everything was running ok. Lately though appeared a very persistent issue with the stock. Some products appear as out of stock in the front end ..although when editing those products, they do have stock available ..and if updating the product (without changing something), the front end also shows correctly that it is in stock. The persisting issue is that even than I bulk updated all products (twice till now) after a few days the issue starts appearing randomly again.
“This product is currently out of stock and unavailable.”
This is the message shown by products that have the problem ..although they have stock available, and a simple update of the product solves the issue temporarily. Tried a few things ..disabled cache, disabled plugins to check for conflicts, reverted to a default theme, optimized the database, converted all tables to InnoDB, removed transients… Nothing seems to do the job – the problem is still there.
PART Ba key point is that a product that works ok, loads the variations as seen here: https://gyazo.com/0b29ddf234f0ab794176d9672d95d399
whereas a product with the stock issue, does not load the variations: https://gyazo.com/14512f7e44c1083b7a937824c1275d8c
A simple change in the product variations > Save changes ..or by simply updating the product (edit product page) ..corrects the issue. But after some days ..randomly, other products start behaving like this again.
PART CI migrated the site to a new server ..but unfortunately the issue persists. There is another clone on another host/server, litespeed, with less resources (so it loads very slow) ..BUT after the migration it sort of crashed and repaired itself (it looked like that) ..and then the problem disappeared! And still haven’t reappeared to my knowledge. Will have to thoroughly check again if this is the case indeed.
So at the moment, I have a freshly migrated site ..a staging site on the same server (both with the stock issue) ..and a third copy of the site on another host/server. It should plenty to help with the troubleshooting.
From what I see in other threads here and in github ..this is a persisting issue that has not been resolved for some time now.
Please advise
Kind thanks
-
Hello vaschops?,
Thank you for contacting WooCommerce support.
Appreciate your detailed explanation. This does seem like a persistent and unusual issue, especially considering it resolved itself when you cloned the site to another server.
To begin troubleshooting, could you share the System Status Report of the live site?
Also, provide the link to the GitHub threads you mentioned, as they might offer additional insights.Once we have that information, we can take a closer look at what’s happening.
Best regards.
WordPress Environment - LIVE SITE
WordPress address (URL): https://kushallday.gr
Site address (URL): https://kushallday.gr
WC Version: 9.3.3
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ? 3.8.2
Log Directory Writable: ?
WP Version: 6.6.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: – Server Environment
Server Info: LiteSpeed
PHP Version: 8.2.21
PHP Post Max Size: 512 MB
PHP Time Limit: 60
PHP Max Input Vars: 10000
cURL Version: 7.61.1
OpenSSL/1.1.1k
SUHOSIN Installed: –
MySQL Version: 10.6.19-MariaDB
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database
WC Database Version: 9.3.3
WC Database Prefix: kush_
Total Database Size: 184.87MB
Database Data Size: 125.97MB
Database Index Size: 58.90MB
kush_woocommerce_sessions: Data: 6.02MB + Index: 0.14MB + Engine InnoDB
kush_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_woocommerce_order_items: Data: 0.38MB + Index: 0.11MB + Engine InnoDB
kush_woocommerce_order_itemmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
kush_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_actionscheduler_actions: Data: 10.52MB + Index: 5.94MB + Engine InnoDB
kush_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_actionscheduler_logs: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
kush_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_comments: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
kush_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
kush_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
kush_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
kush_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_jet_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_post_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_search_suggestions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_search_suggestions_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_smart_filters_indexer: Data: 0.41MB + Index: 0.00MB + Engine InnoDB
kush_jet_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_litespeed_img_optming: Data: 0.17MB + Index: 0.22MB + Engine InnoDB
kush_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
kush_options: Data: 7.45MB + Index: 1.44MB + Engine InnoDB
kush_postmeta: Data: 17.55MB + Index: 8.03MB + Engine InnoDB
kush_posts: Data: 11.52MB + Index: 0.88MB + Engine InnoDB
kush_rank_math_analytics_gsc: Data: 3.52MB + Index: 4.98MB + Engine InnoDB
kush_rank_math_analytics_inspections: Data: 0.28MB + Index: 0.25MB + Engine InnoDB
kush_rank_math_analytics_objects: Data: 1.13MB + Index: 0.25MB + Engine InnoDB
kush_rank_math_internal_links: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
kush_rank_math_internal_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
kush_sellkit_applied_alert: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_sellkit_applied_coupon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_sellkit_applied_discount: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
kush_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
kush_term_relationships: Data: 0.38MB + Index: 0.20MB + Engine InnoDB
kush_term_taxonomy: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
kush_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_trp_dictionary_el_de_de: Data: 6.52MB + Index: 4.94MB + Engine InnoDB
kush_trp_dictionary_el_en_us: Data: 7.52MB + Index: 4.92MB + Engine InnoDB
kush_trp_gettext_de_de: Data: 3.52MB + Index: 3.42MB + Engine InnoDB
kush_trp_gettext_el: Data: 3.52MB + Index: 3.45MB + Engine InnoDB
kush_trp_gettext_en_us: Data: 3.52MB + Index: 3.44MB + Engine InnoDB
kush_trp_gettext_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_trp_gettext_original_strings: Data: 4.52MB + Index: 2.52MB + Engine InnoDB
kush_trp_original_meta: Data: 1.52MB + Index: 0.94MB + Engine InnoDB
kush_trp_original_strings: Data: 6.52MB + Index: 3.55MB + Engine InnoDB
kush_usermeta: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
kush_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
kush_vivawallet_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
kush_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
kush_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wc_customer_lookup: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
kush_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
kush_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_order_product_lookup: Data: 0.36MB + Index: 0.31MB + Engine InnoDB
kush_wc_order_stats: Data: 0.19MB + Index: 0.16MB + Engine InnoDB
kush_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_product_attributes_lookup: Data: 0.30MB + Index: 0.22MB + Engine InnoDB
kush_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wc_product_meta_lookup: Data: 0.20MB + Index: 0.39MB + Engine InnoDB
kush_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wfconfig: Data: 1.48MB + Index: 0.00MB + Engine InnoDB
kush_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wffilemods: Data: 10.52MB + Index: 0.00MB + Engine InnoDB
kush_wfhits: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
kush_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wfknownfilelist: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
kush_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
kush_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wfstatus: Data: 0.22MB + Index: 0.09MB + Engine InnoDB
kush_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpsc_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpsc_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpsc_options: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpsc_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpsc_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpsc_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB Post Type Counts
acf-field: 1
acf-field-group: 1
attachment: 1570
country_restriction: 1
custom_css: 3
cwginstocknotifier: 85
elementor_icons: 2
elementor_library: 48
elementor-hf: 2
es_template: 2
groovy_menu_preset: 1
is_search_form: 1
jet-engine: 8
jet-menu: 10
jet-popup: 10
jet-smart-filters: 16
jet-woo-builder: 13
kush-all-day-offers: 9
language_switcher: 4
nav_menu_item: 132
oembed_cache: 14
page: 23
post: 32
product: 829
product_variation: 985
revision: 7
seedprod: 1
sellkit_step: 4
sellkit-coupon: 1
sellkit-funnels: 1
shop_coupon: 5
shop_order: 1404
shop_order_refund: 1
viwec_template: 14
wc_afrsm: 1
wp_global_styles: 3
wp_navigation: 1
wpcode: 2 Security
Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (30)
Secure Custom Fields: by www.remarpro.com – 6.3.6.3
Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 4.9.0
Age Gate: by Phil Baker – 3.5.0
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.5.3
Copy & Delete Posts: by Inisev – 1.4.9
Disable Embeds: by Pascal Birchler – 1.5.0
Elementor: by Elementor.com – 3.24.7
Fr Custom Payment Gateway Icon for WooCommerce: by Fahri Rusliyadi – 1.1.2
Elementor Header & Footer Builder: by Brainstorm Force
Nikhil Chavan – 1.6.43
WPCode Lite: by WPCode – 2.2.2
JetEngine: by Crocoblock – 3.5.5
JetPopup: by Crocoblock – 2.0.6
JetSearch: by Crocoblock – 3.5.3
JetSmartFilters: by Crocoblock – 3.5.5
JetWooBuilder For Elementor: by Crocoblock – 2.1.14
LoginPress: by LoginPress – 3.2.1
Migrate Guru: by Migrate Guru – 5.65
Rank Math SEO: by Rank Math – 1.0.230
Side Cart WooCommerce: by XootiX – 2.5.5
TranslatePress - Business: by Cozmoslabs
Razvan Mocanu
Madalin Ungureanu – 1.3.7
TranslatePress - Multilingual: by Cozmoslabs
Razvan Mocanu
Madalin Ungureanu
Cristophor Hurduban – 2.8.7
UpdraftPlus - Backup/Restore: by TeamUpdraft
DavidAnderson – 1.24.6
Viva Wallet Smart Checkout: by Viva Wallet – 3.6.8
WooCommerce Smart COD: by woosmartcod.com – 1.7.2
Country Based Restrictions for WooCommerce: by zorem – 3.6.6
Booster for WooCommerce: by Pluggabl LLC – 7.2.3
WooCommerce: by Automattic – 9.3.3
Wordfence Security: by Wordfence – 7.11.7
WP Mail SMTP: by WP Mail SMTP – 4.1.1
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.6.0 Inactive Plugins (3)
Booster Plus for WooCommerce: by Pluggabl LLC – 7.1.8
Jupiter X Core: by Artbees – 4.7.8
LiteSpeed Cache: by LiteSpeed Technologies – 6.5.2 Settings
Legacy API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
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: –
Enforce Approved Product Download Directories: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – Logging
Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 3 KB WC Pages
Shop base: #27 - /shop/
Cart: #28 - /cart/ - Contains the [woocommerce_cart] shortcode
Checkout: #29 - /checkout/ - Contains the [woocommerce_checkout] shortcode
My account: #30 - /my-account/
Terms and conditions: ? Page not set Theme
Name: Hello Elementor Child
Version: 2.0.0
Author URL: https://elementor.com/
Child Theme: ?
Parent Theme Name: Hello Elementor
Parent Theme Version: 3.1.1
Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
WooCommerce Support: ? Templates
Overrides: /home/kushalld/public_html/wp-content/plugins/jet-woo-builder/templates/woocommerce/cart/cart-empty.php
/home/kushalld/public_html/wp-content/plugins/jet-woo-builder/templates/woocommerce/cart/cart.php
/home/kushalld/public_html/wp-content/plugins/jet-woo-builder/templates/woocommerce/checkout/form-checkout.php
/home/kushalld/public_html/wp-content/plugins/jet-woo-builder/templates/woocommerce/checkout/thankyou.php Admin
Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store
Disabled Features: experimental-blocks
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
Daily Cron: ? Next scheduled: 2024-10-21 17:54:35 +03:00
Options: ?
Notes: 188
Onboarding: completed Action Scheduler
Complete: 15,602
Oldest: 2024-09-20 10:46:53 +0300
Newest: 2024-10-21 10:36:40 +0300
Failed: 3,574
Oldest: 2022-04-18 20:58:47 +0300
Newest: 2024-09-24 15:07:42 +0300
Pending: 7
Oldest: 2024-10-21 10:41:40 +0300
Newest: 2024-11-02 02:09:32 +0200 Status report information
Generated at: 2024-10-21 10:41:30 +03:00
`WordPress Environment - STAGING SITE ON DIFFERENT SERVER - NO ISSUES
WordPress address (URL): https://kush.pixel-o.xyz
Site address (URL): https://kush.pixel-o.xyz
WC Version: 9.3.3
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ? 3.8.2
Log Directory Writable: ?
WP Version: 6.6.2
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: – Server Environment
Server Info: LiteSpeed
PHP Version: 8.0.30
PHP Post Max Size: 1 GB
PHP Time Limit: 180
PHP Max Input Vars: 3000
cURL Version: 7.87.0
OpenSSL/1.1.1w
SUHOSIN Installed: –
MySQL Version: 10.5.24-MariaDB-cll-lve
Max Upload Size: 1 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database
WC Database Version: 9.3.3
WC Database Prefix: kush_
Total Database Size: 154.15MB
Database Data Size: 100.26MB
Database Index Size: 53.89MB
kush_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_woocommerce_order_items: Data: 0.38MB + Index: 0.11MB + Engine InnoDB
kush_woocommerce_order_itemmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
kush_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_actionscheduler_actions: Data: 7.52MB + Index: 4.56MB + Engine InnoDB
kush_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_actionscheduler_logs: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
kush_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_comments: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
kush_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_e_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
kush_e_notes_users_relations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
kush_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
kush_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
kush_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_jet_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_post_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_search_suggestions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_search_suggestions_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_jet_smart_filters_indexer: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
kush_jet_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_litespeed_img_optming: Data: 0.17MB + Index: 0.22MB + Engine InnoDB
kush_options: Data: 4.50MB + Index: 0.36MB + Engine InnoDB
kush_postmeta: Data: 17.55MB + Index: 8.03MB + Engine InnoDB
kush_posts: Data: 11.52MB + Index: 0.72MB + Engine InnoDB
kush_rank_math_analytics_gsc: Data: 3.52MB + Index: 4.98MB + Engine InnoDB
kush_rank_math_analytics_inspections: Data: 0.28MB + Index: 0.25MB + Engine InnoDB
kush_rank_math_analytics_objects: Data: 0.41MB + Index: 0.14MB + Engine InnoDB
kush_rank_math_internal_links: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
kush_rank_math_internal_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
kush_sellkit_applied_alert: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_sellkit_applied_coupon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_sellkit_applied_discount: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
kush_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
kush_term_relationships: Data: 0.38MB + Index: 0.20MB + Engine InnoDB
kush_term_taxonomy: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
kush_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_trp_dictionary_el_de_de: Data: 6.52MB + Index: 4.92MB + Engine InnoDB
kush_trp_dictionary_el_en_us: Data: 7.52MB + Index: 4.92MB + Engine InnoDB
kush_trp_gettext_de_de: Data: 3.52MB + Index: 3.39MB + Engine InnoDB
kush_trp_gettext_el: Data: 3.52MB + Index: 3.42MB + Engine InnoDB
kush_trp_gettext_en_us: Data: 2.52MB + Index: 3.39MB + Engine InnoDB
kush_trp_gettext_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_trp_gettext_original_strings: Data: 4.52MB + Index: 1.52MB + Engine InnoDB
kush_trp_original_meta: Data: 1.52MB + Index: 0.94MB + Engine InnoDB
kush_trp_original_strings: Data: 6.52MB + Index: 3.55MB + Engine InnoDB
kush_usermeta: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
kush_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
kush_vivawallet_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
kush_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
kush_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wc_customer_lookup: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
kush_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
kush_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_order_product_lookup: Data: 0.36MB + Index: 0.31MB + Engine InnoDB
kush_wc_order_stats: Data: 0.19MB + Index: 0.16MB + Engine InnoDB
kush_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wc_product_attributes_lookup: Data: 0.22MB + Index: 0.16MB + Engine InnoDB
kush_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wc_product_meta_lookup: Data: 0.20MB + Index: 0.39MB + Engine InnoDB
kush_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wfconfig: Data: 0.52MB + Index: 0.00MB + Engine InnoDB
kush_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wfknownfilelist: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
kush_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kush_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
kush_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kush_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kush_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kush_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kush_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wppf_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wppf_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wppf_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wppf_options: Data: 0.28MB + Index: 0.03MB + Engine InnoDB
wppf_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wppf_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wppf_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wppf_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wppf_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wppf_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wppf_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wppf_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB Post Type Counts
acf-field: 1
acf-field-group: 1
attachment: 1566
country_restriction: 1
custom_css: 3
cwginstocknotifier: 85
elementor_icons: 2
elementor_library: 48
elementor-hf: 2
es_template: 2
groovy_menu_preset: 1
is_search_form: 1
jet-engine: 8
jet-menu: 10
jet-popup: 10
jet-smart-filters: 16
jet-woo-builder: 13
kush-all-day-offers: 9
language_switcher: 4
nav_menu_item: 132
oembed_cache: 14
page: 23
post: 30
product: 828
product_variation: 983
seedprod: 1
sellkit_step: 4
sellkit-coupon: 1
sellkit-funnels: 1
shop_coupon: 5
shop_order: 1401
shop_order_refund: 1
viwec_template: 14
wc_afrsm: 1
wp_global_styles: 3
wp_navigation: 1
wpcode: 2 Security
Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (28)
Advanced Custom Fields: by WP Engine – 6.3.6
Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 4.8.3
Age Gate: by Phil Baker – 3.5.0
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.5.1
Copy & Delete Posts: by Inisev – 1.4.9
Disable Embeds: by Pascal Birchler – 1.5.0
Elementor: by Elementor.com – 3.24.4
Fr Custom Payment Gateway Icon for WooCommerce: by Fahri Rusliyadi – 1.1.2
Elementor Header & Footer Builder: by Brainstorm Force
Nikhil Chavan – 1.6.42
WPCode Lite: by WPCode – 2.2.2
JetEngine: by Crocoblock – 3.5.5
JetPopup: by Crocoblock – 2.0.6
JetSearch: by Crocoblock – 3.5.3
JetSmartFilters: by Crocoblock – 3.5.5
JetWooBuilder For Elementor: by Crocoblock – 2.1.14
LoginPress: by LoginPress – 3.2.0
Rank Math SEO: by Rank Math – 1.0.228
Side Cart WooCommerce: by XootiX – 2.5.4
TranslatePress - Business: by Cozmoslabs
Razvan Mocanu
Madalin Ungureanu – 1.3.7
TranslatePress - Multilingual: by Cozmoslabs
Razvan Mocanu
Madalin Ungureanu
Cristophor Hurduban – 2.8.3
UpdraftPlus - Backup/Restore: by TeamUpdraft
DavidAnderson – 1.24.6
Viva Wallet Smart Checkout: by Viva Wallet – 3.6.8
WooCommerce Smart COD: by woosmartcod.com – 1.7.2
Country Based Restrictions for WooCommerce: by zorem – 3.6.6
Booster for WooCommerce: by Pluggabl LLC – 7.2.3
WooCommerce: by Automattic – 9.3.3
WP Mail SMTP: by WP Mail SMTP – 4.1.1
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.6.0 Inactive Plugins (8)
Booster Plus for WooCommerce: by Pluggabl LLC – 7.1.8
Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: by SeedProd – 6.18.9
Disable Cart Fragments: by Optimocha – 2.3
Jupiter X Core: by Artbees – 4.7.8
Migrate Guru: by Migrate Guru – 5.65
Temporary Login Without Password: by StoreApps – 1.8.3
Wordfence Security: by Wordfence – 7.11.7
WP Sheet Editor - WooCommerce Products (Premium): by WP Sheet Editor – 1.8.5 Settings
Legacy API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
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: –
Enforce Approved Product Download Directories: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – Logging
Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 0 B WC Pages
Shop base: #27 - /shop/
Cart: #28 - /cart/ - Contains the [woocommerce_cart] shortcode
Checkout: #29 - /checkout/ - Contains the [woocommerce_checkout] shortcode
My account: #30 - /my-account/
Terms and conditions: ? Page not set Theme
Name: Hello Elementor Child
Version: 2.0.0
Author URL: https://elementor.com/
Child Theme: ?
Parent Theme Name: Hello Elementor
Parent Theme Version: 3.1.1
Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
WooCommerce Support: ? Templates
Overrides: /home/pixeloxy/domains/pixel-o.xyz/public_html/kush/wp-content/plugins/jet-woo-builder/templates/woocommerce/cart/cart-empty.php
/home/pixeloxy/domains/pixel-o.xyz/public_html/kush/wp-content/plugins/jet-woo-builder/templates/woocommerce/cart/cart.php
/home/pixeloxy/domains/pixel-o.xyz/public_html/kush/wp-content/plugins/jet-woo-builder/templates/woocommerce/checkout/form-checkout.php
/home/pixeloxy/domains/pixel-o.xyz/public_html/kush/wp-content/plugins/jet-woo-builder/templates/woocommerce/checkout/thankyou.php Admin
Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store
Disabled Features: experimental-blocks
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
Daily Cron: ? Next scheduled: 2024-10-21 17:54:35 +03:00
Options: ?
Notes: 187
Onboarding: completed Action Scheduler
Complete: 10,771
Oldest: 2024-09-07 20:19:46 +0300
Newest: 2024-10-21 10:45:20 +0300
Failed: 3,575
Oldest: 2022-04-18 20:58:47 +0300
Newest: 2024-09-27 17:37:07 +0300
Pending: 7
Oldest: 2024-10-21 10:50:06 +0300
Newest: 2024-11-12 08:53:03 +0200 Status report information
Generated at: 2024-10-21 10:45:54 +03:00
`And here is a thread with good feedback:
I’m coming from the github issue mentioned above.
The values below are different from the staging site to the live site, with the staging site having more resources allocated. I don’t know if you can replicate the values on the live site, but if so, it might be a good thing to test.
WP Memory Limit: 2 GB
PHP Version: 8.0.30
PHP Post Max Size: 1 GB
PHP Time Limit: 180I tried tweaking the mentioned values ..but it did not directly remedy the products that show as out of stock (while the have stock) nor changed the message.
Only by updating a product (or by hitting the ‘Save changes’ button in Variations tab) restores the correct status in the front-end.I am not sure if after the changes the issue will be fixed or will be reproduced in the future.
But it definitely does not automatically fix products that currently show this ‘This product is currently out of stock and unavailable’.Furthermore ..some differences like the version of MySQL MariaDB ..I cant really tweak myself.
Truth is that more people are still coming in, stating the same issue in github ..and it is not easy to continuously monitor a store with hundreds of products.
There should be a way to fix this by scanning/regenerating/updating the variation tables.
One way would be to do it manually – using a tool like those available in Woocommerce > Status > Tools).
This might not solve the root/cause of the problem ..but it would definitely identify if an additional cron job is required to check variations ..or something like that.The other thing that Woocommerce team should clearly answer:
When and why this alternate message is displayed ‘This product is currently out of stock and unavailable’?
Normally when a product is out of stock it just shows the message ‘Out of stock’.
Hello vaschops,
Thank you for your reply.
You’re correct; WooCommerce typically displays “Out of stock” when a product is unavailable.
Could you please share a screenshot and a link to the page where you see the message, “This product is currently out of stock and unavailable“?
Checking the page will help us understand what might be causing this alternate message.
Looking forward to your response. ??
Here is a product with 2 variations that both have stock:
https://staging.kushallday.gr/en/shop/seedshop/cannabis-seeds/rainbows/Here is a product with 2 variations that none of them have stock + they do not display the expected ‘out of stock’ message:
https://staging.kushallday.gr/en/shop/seedshop/cannabis-seeds/gorilla-glue-4/Both of the above products have values for regular price + stock + manage stock is ticked
(example of how the variations tab looks: https://gyazo.com/11ff4f06cbb98ae475c5116b0671a8fa)And here is a product with 3 variations that none have stock and the correct message is displayed as expected:
https://staging.kushallday.gr/en/shop/seedshop/cannabis-seeds/strawberry-pie-auto/Hello vaschops,
Thank you for the additional details.
I see that the “Out of stock” message on your simple product isn’t the default, while it is on the variable product.
Could you disable all other plugins and switch to the Twenty Twenty-Four theme on your staging.kushallday.gr site? This will help us diagnose the issue more efficiently.
Looking forward to your response. ??
Please have a look now
Twenty Twenty-Four theme is enabled and ONLY WooCommerce plugin is active.
The product links provided in previous reply are still showing the wrong message, although they have stock available etc.
Hello vaschops,
Thank you for your reply.
I tried to replicate the issue on my test site but could not do so.
I still see the “Out of stock” message on Simple Products instead of “This product is currently out of stock and unavailable.“As a test could you create a new test product like I have done?
Then share the link with me.Here are the screenshots of my test product.
Looking forward to your response. ??
URGENT
We are talking about an issue that affects live sites.
The response time in this thread is very slow for this issue to get resolved soon.
I loose track of your replies.
If you are following the github thread you will see more people keep coming in with the same problem.
I understand that there are other issues and bugs to tackle by your team, but since it is not an isolated incident, someone has to be assigned in a devoted way to resolved this issue.Hi Zubair
Thanks for replying quickly – I missed your last reply.
Still, now that I read it I am not sure what you are investigating.There are simple products that show the correct ‘Out of stock’ message.
But randomly products go ‘bad’, showing the other “This product is currently out of stock and unavailable.“Here is a new simple product, setup according to your screenshot:
https://staging.kushallday.gr/shop/10-oh-hhc/a-new-test-product/And here is an older simple product:
https://staging.kushallday.gr/shop/lifestyle/headwear/rqs-snapback-green-cap/Both work correctly.
- You must be logged in to reply to this topic.