Product Stocks being Reset Randomly to 0

  • Resolved araxxon

    (@araxxon)


    4 months ago

    Hi,

    I am currently experiencing a problem, where every once in a while certain products’ stocks get reset to 0 at random times. I figured initially it was a synchronisation problem with my ERP, but the stock remains unchanged in my ERP software, therefore I installed WP Activity Log to track the movement of products in my site.

    Every false product movement is initiated by the UserAgent “WooCommerce API Client-PHP/3.0.0”.

    I am wondering what is causing this problem, and how I can fix it. Products that have their stocks reset to 0 by WooCommerce in such a manner are sometimes not noticed by staff, and can lead to the goods spoiling in storage as they could not be sold.

    Thanks in advance for any help or tips. Have a great day!

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hey there, @araxxon! Thanks for contacting us. I’m happy to help you.

    Do see any similarities between the products that this is happening to?
    Or any similarities between the times this happened?

    Which ERP are you using?

    Can you please share the Fatal error logs (if any) under WooCommerce > Status > Logs. Then you can use the selector to search for Fatal Errors.
    You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

    Looking forward to your reply.

    Have a wonderful day!

    Thread Starter araxxon

    (@araxxon)

    Hi,

    Thank you for your quick response.

    There is no similarities between the products and the phenomenon seems to be happening at completely random times. Sometimes the products follow the amount dictated by the ERP perfectly for weeks before resetting to 0, other times they don’t last longer than a couple of hours after having been manually reset. I even tried to carry out all WooCommerce related CronJobs individually (and together as well) to see if any of them were causing the issue, but that was not the case.

    I use an ERP system called Xentral, it has been working without issue so far for the past 3 years, and the REST-API integration between Xentral and WooCommerce has not been changed since then.

    I will just proceed to paste in my Fatal error log below:

    2024-06-19T17:44:44+00:00 Kritisch Uncaught Error: Call to a member function get_id() on bool in /var/www/vhosts/araxxon.de/httpdocs/wp-content/plugins/tier-pricing-table-premium/src/Addons/GlobalTieredPricing/GlobalPricingRule.php:655 CONTEXT: {“error”:{“type”:1,”file”:”\/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/Addons\/GlobalTieredPricing\/GlobalPricingRule.php”,”line”:655},”backtrace”:[“”,”#0 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/Addons\/GlobalTieredPricing\/GlobalPricingRule.php(597): TierPricingTable\\Addons\\GlobalTieredPricing\\GlobalPricingRule->_matchRequirements()”,”#1 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/Addons\/GlobalTieredPricing\/GlobalPricingRulesRepository.php(55): TierPricingTable\\Addons\\GlobalTieredPricing\\GlobalPricingRule->matchRequirements()”,”#2 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/Addons\/GlobalTieredPricing\/PricingService.php(43): TierPricingTable\\Addons\\GlobalTieredPricing\\GlobalPricingRulesRepository->getMatchedPricingRule()”,”#3 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/class-wp-hook.php(324): TierPricingTable\\Addons\\GlobalTieredPricing\\PricingService->addPricing()”,”#4 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/plugin.php(205): WP_Hook->apply_filters()”,”#5 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/PriceManager.php(431): apply_filters()”,”#6 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/Services\/RegularPricingService.php(78): TierPricingTable\\PriceManager::getPricingRule()”,”#7 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/tier-pricing-table-premium\/src\/Services\/RegularPricingService.php(176): TierPricingTable\\Services\\RegularPricingService->getPrice()”,”#8 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/class-wp-hook.php(324): TierPricingTable\\Services\\RegularPricingService->adjustRegularPrice()”,”#9 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/plugin.php(205): WP_Hook->apply_filters()”,”#10 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/woocommerce\/includes\/abstracts\/abstract-wc-data.php(884): apply_filters()”,”#11 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/woocommerce\/includes\/abstracts\/abstract-wc-product.php(280): WC_Data->get_prop()”,”#12 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/facebook-for-woocommerce\/includes\/Products.php(349): WC_Product->get_regular_price()”,”#13 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/facebook-for-woocommerce\/includes\/ProductSync\/ProductValidator.php(371): WooCommerce\\Facebook\\Products::get_product_price()”,”#14 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/facebook-for-woocommerce\/includes\/ProductSync\/ProductValidator.php(156): WooCommerce\\Facebook\\ProductSync\\ProductValidator->validate_product_price()”,”#15 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/facebook-for-woocommerce\/includes\/Products.php(207): WooCommerce\\Facebook\\ProductSync\\ProductValidator->validate_but_skip_status_check()”,”#16 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-content\/plugins\/facebook-for-woocommerce\/facebook-commerce.php(896): WooCommerce\\Facebook\\Products::published_product_should_be_synced()”,”#17 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/class-wp-hook.php(326): WC_Facebookcommerce_Integration->on_product_delete()”,”#18 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()”,”#19 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/plugin.php(517): WP_Hook->do_action()”,”#20 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/post.php(3512): do_action()”,”#21 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/functions.php(6807): wp_delete_post()”,”#22 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/class-wp-hook.php(324): wp_scheduled_delete()”,”#23 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()”,”#24 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-includes\/plugin.php(565): WP_Hook->do_action()”,”#25 \/var\/www\/vhosts\/araxxon.de\/httpdocs\/wp-cron.php(191): do_action_ref_array()”,”#26 {main}”,”thrown”]}

    I don’t know if any of this may be of use, but I’m hopeful we can find the issue.

    Once again I thank you for your time, and wish you a nice day!

    Hey, @araxxon!

    Thanks for the clarification!

    Have you checked with Xentral if everything is okay on their end?

    The error you shared is related to the plugin Tier Pricing Table Premium. Does this plugin affects your inventory too?

    Looking forward to your reply.

    Have a wonderful day!

    Hi there! I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or?open a new topic.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.