WooCommerce with inventory showing out of stock

  • Resolved thelapara

    (@thelapara)


    3 years, 6 months ago

    I have searched the internet and found nothing exactly to what I am experiencing. I have a brick and mortar store front with a point of sale system (POS) called Keystroke. I also have 2 different web sites running woocommerce. I have a plug-in that uploads my inventory and pricing from Keystroke to the products I have created in WooCommerce. It works great, it automatically as a task on my server every 10 minutes. It also downloads all my woocommerce orders into my brick and mortar POS. This program keeps my inventory synced between my store and on my woocommerce.

    Here’s my issue. About a year ago I noticed that items with inventory (both regular and variable items) were not showing on my web store front. I look at the product through the dashboard and the item is there with inventory and pricing. It says in green “In-Stock”. But it does not show on my web store page. If I go into the product and just change something, just about anything and save it, it corrects itself.

    One of the easiest ways to find these products with this issue is to sort my products either by in-stock or out of stock using the filter on the product dashboard. Out of stock items with this issue will show using the in-stock filter and in-stock items with this issue will show in the out-of stock filter.

    Steps to resolve:
    #1 – two different web sites with different themes having the same issue.
    #2 – Switched to the 2020 them and now the 2021 theme with no change
    #3 – All plug-ins and themes are updated
    #4 – Disable all plug-ins with same issue

    Not sure what else to do. It seems that the inventory and pricing updates but it is like woocommerce doesn’t realize it. I have to “wake it up” so to speak by going into the item and change something, anything.

    Any help would be appreciated.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hello @thelapara,

    It looks like the inventory metadata is not being stored properly when the products are being pulled from the POS software. Since it’s a 3rd party software, we don’t know how this software is trying to sync or save the data to WooCommerce. The best way forward is to contact the software developer and see if they can share some insight.

    Thanks!

    Thread Starter thelapara

    (@thelapara)

    I spoke to the developer and he said that this has to be a WooCommerce issue as the pricing and inventory is appearing in WooCommerce. He said that the fact that on the product dashboard that it will show an item “in-stock” and with an inventory count means that WooCommerce has the issue. If I sort the product dashboard by Out-of-Stock it will have “in-stock” items listed.

    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hi @thelapara,

    It will be great if you could share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

    Thanks!

    Thread Starter thelapara

    (@thelapara)

    Here is the system report.

    
### WordPress Environment ###

WordPress address (URL): https://lapdstore.com
Site address (URL): https://lapdstore.com
WC Version: 5.3.0
REST API Version: ? 5.3.0
WC Blocks Version: ? 4.9.1
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.2.6
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 77 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.18
PHP Post Max Size: 6 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.64.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.7.30-log
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.3.0
WC Database Prefix: axggqmqW
Total Database Size: 14.01MB
Database Data Size: 10.01MB
Database Index Size: 4.00MB
axggqmqWwoocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwoocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwoocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwoocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
axggqmqWwoocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwoocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwoocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
axggqmqWwoocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwoocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwoocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwoocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwoocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwoocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwoocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWactionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
axggqmqWactionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWactionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWactionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWcommentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWcomments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
axggqmqWgglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWlinks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWmailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWmailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWoptions: Data: 2.02MB + Index: 1.03MB + Engine InnoDB
axggqmqWpmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWpmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWpmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWpmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWpmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWpmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWpostmeta: Data: 0.42MB + Index: 0.47MB + Engine InnoDB
axggqmqWposts: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
axggqmqWssa_appointments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
axggqmqWssa_appointment_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWssa_appointment_types: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
axggqmqWssa_async_actions: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
axggqmqWssa_availability: Data: 0.02MB + Index: 0.16MB + Engine InnoDB
axggqmqWssa_availability_external: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
axggqmqWssa_staff: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
axggqmqWssa_staff_relationships: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
axggqmqWtermmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWterms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWterm_relationships: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
axggqmqWterm_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWusermeta: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
axggqmqWusers: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
axggqmqWwc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
axggqmqWwc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
axggqmqWwc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
axggqmqWwc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
axggqmqWwfconfig: Data: 1.30MB + Index: 0.00MB + Engine InnoDB
axggqmqWwfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwffilemods: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
axggqmqWwfhits: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
axggqmqWwfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
axggqmqWwfknownfilelist: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
axggqmqWwflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
axggqmqWwfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
axggqmqWwfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwfpendingissues: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
axggqmqWwfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
axggqmqWwfstatus: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
axggqmqWwftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
axggqmqWwpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 64
custom_css: 2
nav_menu_item: 3
page: 3
post: 1
product: 335
revision: 60
wpcf7_contact_form: 1

### Security ###

Secure connection (HTTPS): ?
					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ?

### Active Plugins (9) ###

Child Theme Configurator: by Lilaea Media – 2.5.8
Contact Form 7 Captcha: by 247wd – 0.0.8
Contact Form 7: by Takayuki Miyoshi – 5.4.1
Grid/List View for WooCommerce: by BeRocket – 1.1.2.1
MMWD Remove Add To Cart for WooCommerce: by McGregor Media Web Design – 1.4.17
wc-cf-keystroke-interface: by CF Consulting – 1.0
WooCommerce Payments: by Automattic – 2.4.0
WooCommerce: by Automattic – 5.3.0
Wordfence Security: by Wordfence – 7.5.3

### Inactive Plugins (0) ###

### Must Use Plugins (1) ###

1&1 Product Subdomain: by 1&1 – 1.1.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
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)
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 ###

Shop base: #6 - /
Cart: ? Page ID is set
but the page does not exist

Checkout: ? Page ID is set
but the page does not exist

My account: ? Page ID is set
but the page does not exist

Terms and conditions: ? Page not set

### Theme ###

Name: Twenty Twenty Child
Version: 1.5.1601070869
Author URL: https://www.ads-software.com/
Child Theme: ?
Parent Theme Name: Twenty Twenty
Parent Theme Version: 1.7
Parent Theme Author URL: https://www.ads-software.com/
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 3
Oldest: 2021-05-03 18:49:59 +0000
Newest: 2021-05-03 18:58:06 +0000

### Status report information ###

Generated at: 2021-05-19 15:11:48 +00:00
    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hello @thelapara,

    Thanks for sharing the SSR. Everything looks good here.

    I’m going to leave it open for a bit to see if anyone is able to chime in to help you out.

    I can also recommend the WooCommerce Developer Resources Portal for resources on developing for WooCommerce.

    You can also visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.`

    Thanks!

    Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    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 thelapara

    (@thelapara)

    This has not been resolved. I have not responded because I have not received a solution. If anyone has any insight into this it would be appreciated.

    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hey there ??

    This is not a WooCommerce issue rather it’s an issue related to the process of how the products are being imported, we’d recommend you hire a developer who can take a look at this, quote you for their services, and help you fix the problem on your site. We’d recommend getting in touch with a web developer or one of the customization experts listed at?https://woocommerce.com/customizations/.

    Please kindly note that this requires some custom coding – which goes beyond the scope of support we are able to provide in this forum.

    Cheers.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WooCommerce with inventory showing out of stock’ is closed to new replies.