Stock Goes to Negative Value After Sale with Items Still Available

Hi @kyle9296 !

This looks very much like a conflict! Do you have a staging site available?

If not please reach out to SiteGround and ask them for one (hosts usually provide those for free)! Once you have that please switch your theme to a default one and see if the issue persists, if it does disable all the plugins except WooCommerce and check again!

If the issue is not present, start enabling each plugin and placing an order after each activation until the culprit is revealed!

You can find a more detailed explanation on how to do a conflict test here.

Note: Conflicts are usually logged so please head to WooCommerce > Status > Logs and check whether there are any error logs there! Something like a critical error should have some clues.

Thank you!

Ok, thanks. I’m working on it.

I tried a SiteGround staging site but my site is too big. Any suggestions on what to turn off in an attempt to solve it on a live site?

Hello @kyle9296!

Thanks for the follow-up message!

I tried a SiteGround staging site but my site is too big.

If your host’s offer is limited, we recommend WP Staging for quickly spinning up a new test site.

Any suggestions on what to turn off in an attempt to solve it on a live site?

What we can do to narrow the field is check for any fatal errors related to any product installed on your site. Please check for any fatal errors under your page WooCommerce → Status → Logs and share with us any recent Fatal Errors listed there.

Also, to give us some insight, could you please share a copy of your site’s System Status? 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.

We will be waiting for your response!

This is the last fatal error in the log.

2022-06-12T00:11:19+00:00 CRITICAL Allowed memory size of 805306368 bytes exhausted (tried to allocate 268435464 bytes) in /home/customer/www/phdtackle.com/public_html/wp-content/object-cache.php on line 255

System report as requested.

### WordPress Environment ###

WordPress address (URL): https://phdtackle.com
Site address (URL): https://phdtackle.com
WC Version: 6.6.0
REST API Version: ? 6.6.0
WC Blocks Version: ? 7.6.0
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.30
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1n-fips

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

### Database ###

WC Database Version: 6.6.0
WC Database Prefix: hub_
Total Database Size: 65.07MB
Database Data Size: 46.56MB
Database Index Size: 18.51MB
hub_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_order_itemmeta: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
hub_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_actionscheduler_actions: Data: 8.52MB + Index: 5.00MB + Engine InnoDB
hub_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_actionscheduler_logs: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
hub_aioseo_cache: Data: 1.25MB + Index: 0.03MB + Engine InnoDB
hub_aioseo_notifications: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
hub_aioseo_posts: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
hub_atum_export_templates: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
hub_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_atum_product_data: Data: 0.28MB + Index: 0.19MB + Engine InnoDB
hub_bwt_failed_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_bwt_passed_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_comments: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
hub_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
hub_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
hub_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
hub_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
hub_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_gpf_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_hfcm_pro_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_hfcm_pro_snippet_tag_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_hfcm_pro_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_log: Data: 0.44MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletters: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_scheduled_tasks: Data: 0.28MB + Index: 0.20MB + Engine InnoDB
hub_mailpoet_scheduled_task_subscribers: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
hub_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
hub_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_options: Data: 6.48MB + Index: 0.30MB + Engine InnoDB
hub_postmeta: Data: 8.52MB + Index: 5.03MB + Engine InnoDB
hub_posts: Data: 2.52MB + Index: 0.63MB + Engine InnoDB
hub_sgs_log_events: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
hub_sgs_log_visitors: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
hub_termmeta: Data: 0.31MB + Index: 0.25MB + Engine InnoDB
hub_terms: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
hub_term_relationships: Data: 0.16MB + Index: 0.09MB + Engine InnoDB
hub_term_taxonomy: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
hub_usermeta: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
hub_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
hub_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
hub_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
hub_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_product_meta_lookup: Data: 0.28MB + Index: 0.42MB + Engine InnoDB
hub_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_wpmailsmtp_emails_log: Data: 4.52MB + Index: 0.03MB + Engine InnoDB
hub_wpmailsmtp_email_tracking_events: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_wpmailsmtp_email_tracking_links: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
hub_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
hub_xoo_wl_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_xoo_wl_list_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
hub_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
hub_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 1260
atum_supplier: 8
cwginstocknotifier: 1
elementor_library: 9
elementor_snippet: 1
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
mailpoet_page: 1
nav_menu_item: 131
page: 21
post: 1
postman_sent_mail: 11
product: 296
product_variation: 1880
product-feed: 8
revision: 93
shop_coupon: 3
shop_order: 18
wc_conditional_fee: 1
wp_global_styles: 4
wpcf7_contact_form: 1
wpforms: 1

### Security ###

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

### Active Plugins (27) ###

Header Footer Code Manager Pro: by 99robots – 1.0.7
All in One SEO: by All in One SEO Team – 4.2.1.1
ATUM Export PRO: by Stock Management Labs? – 1.4.8
ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.18.1
Product Feed Manager for WooCommerce PRO: by RexTheme – 6.2.0
Product Feed Manager for WooCommerce: by RexTheme – 7.2.8
Bing Webmaster Url Submission: by Bing Webmaster – 1.0.13
Contact Form 7: by Takayuki Miyoshi – 5.6
EAN for WooCommerce: by WPFactory – 4.1.2
eCommerce Extra Plugin: by Ceylon Themes – 5.3
Elementor Pro: by Elementor.com – 3.7.2
Elementor: by Elementor.com – 3.6.6
Flexible Shipping: by WP Desk – 4.11.9
Site Kit by Google: by Google – 1.75.0
Jetpack: by Automattic – 11.0
MailPoet 3 (New): by MailPoet – 3.90.1
Microsoft Advertising Universal Event Tracking (UET): by Microsoft Corporation – 1.0.3
SiteGround Optimizer: by SiteGround – 7.1.3
SiteGround Security: by SiteGround – 1.2.9
WooCommerce Extra Fees Plugin: by theDotstore – 3.8.3
WooCommerce Cart All in One Premium: by VillaTheme – 1.0.7
WooCommerce PayPal Payments: by WooCommerce – 1.8.1
WooCommerce Shipping & Tax: by WooCommerce – 1.26.0
WooCommerce – ShipStation Integration: by WooCommerce – 4.1.48
WooCommerce: by Automattic – 6.6.0
WP Mail SMTP Pro: by WPForms – 3.4.0
YITH WooCommerce Wishlist: by YITH – 3.10.0

### Inactive Plugins (2) ###

Waitlist woocommerce( Back in stock notifier ): by – 2.5.2
WP-Sweep: by Lester ‘GaMerZ’ Chan – 1.1.5

### 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: ?
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #5956 – /shop-all/
Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: #1779 – /check-out/
My account: #1590 – /my-account/
Terms and conditions: #1531 – /terms-conditions/

### Theme ###

Name: My Storefront
Version: 1.0.1
Author URL: https://ceylonthemes.com
Child Theme: ?
Parent Theme Name: eCommerce Plus
Parent Theme Version: 1.4.2
Parent Theme Author URL: https://ceylonthemes.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: ecommerce-plus/woocommerce/content-product.php

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: US
WooCommerce currency supported: ?
PayPal card processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: ?
Vault enabled: ?
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-06-21 17:34:54 -05:00
Options: ?
Notes: 28
Onboarding: completed

### Action Scheduler ###

Canceled: 5
Oldest: 2022-06-06 23:26:00 +0000
Newest: 2022-06-07 21:28:01 +0000

Complete: 18,401
Oldest: 2022-05-21 19:41:00 +0000
Newest: 2022-06-21 08:38:20 +0000

Pending: 10
Oldest: 2022-06-21 08:43:20 +0000
Newest: 2022-06-27 21:31:37 +0000

### Status report information ###

Generated at: 2022-06-21 03:40:32 -05:00
`

I have it narrowed down to something in the SiteGround Optimizer plug-in…

Hi @kyle9296

I have it narrowed down to something in the SiteGround Optimizer plug-in…

Thanks for letting us know!

That’s quite odd, the best will be to reach out to SiteGround support to know if there’s a way to configure the settings so that it does not conflict with the WooCommerce stock/inventory.

I have also found a guide on the configuration here: https://www.siteground.com/tutorials/wordpress/sg-optimizer/

Hope this helps!