Incorrect stock change while order processing
-
Hello,
Already few times encounter similar issue: stock decreased incorrectly while order processing.
Last example:Initial stock = 10 1. Order placed (8 pcs) 15 April 2022 at 00:19 Stock levels reduced: [product name] (ET-010) 10→2 2. Automatically wwitched to "On hold" 15 April 2022 at 00:19 Awaiting check payment Order status changed from Pending payment to On hold. 3. Order checked by manager and switched to "Pending payment". No other orders for this product or manual stock changes at the same time. 15 April 2022 at 10:52 Order status changed from On hold to Pending payment. Order details manually sent to customer. 4. Incorrect stock adjustment! Should be: 2→10 15 April 2022 at 10:52 Stock levels increased: [product name] (ET-010) -16→-8 5. Payment made via PayPal. Stock reduced correctly, but due previous incorrect value current stock is wrong 15 April 2022 at 15:37 IPN payment completed Stock levels reduced: [product name] (ET-010) -8→-16 Order status changed from Pending payment to Processing.
If duplicate happened somewhere (decreased 2 times by 8), it would be 10→2→-6
But here it become “-8”
Product allowed for backorders, but in this case stock is enough, backorder should not happen…
-
Hi,
To check much better into the issue please provide the following information:
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”.Error Log: Share a copy of any fatal error log found under
WooCommerce > System Status > Logs
(if any).Thanks.
Hi!
Here are system report:### WordPress Environment ### WordPress address (URL): https://www.intomyshop.net/en Site address (URL): https://www.intomyshop.net/en WC Version: 6.4.0 REST API Version: ? 6.4.0 WC Blocks Version: ? 7.2.1 Action Scheduler Version: ? 3.4.0 WC Admin Version: ? 3.3.2 Log Directory Writable: ? WP Version: 5.9.3 WP Multisite: – WP Memory Limit: 800 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache/2 PHP Version: 7.2.18 PHP Post Max Size: 300 MB PHP Time Limit: 600 PHP Max Input Vars: 10000 cURL Version: 7.29.0 NSS/3.36 SUHOSIN Installed: – MySQL Version: 5.5.5-10.1.40-MariaDB Max Upload Size: 300 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.4.0 WC Database Prefix: wp_ Total Database Size: 85.24MB Database Data Size: 71.03MB Database Index Size: 14.21MB wp_woocommerce_sessions: Data: 28.21MB + Index: 0.86MB + Engine MyISAM wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_items: Data: 0.11MB + Index: 0.07MB + Engine MyISAM wp_woocommerce_order_itemmeta: Data: 0.62MB + Index: 0.59MB + Engine MyISAM wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 0.14MB + Index: 0.08MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 0.11MB + Index: 0.07MB + Engine MyISAM wp_atum_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_atum_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_atum_product_data: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_commentmeta: Data: 0.03MB + Index: 0.02MB + Engine MyISAM wp_comments: Data: 0.93MB + Index: 0.46MB + Engine MyISAM wp_ebay_accounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_auctions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_categories: Data: 1.10MB + Index: 1.11MB + Engine MyISAM wp_ebay_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_log: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_ebay_messages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_payment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_profiles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_shipping: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_ebay_sites: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_ebay_store_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ebay_transactions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_fvm_cache: Data: 0.90MB + Index: 0.01MB + Engine MyISAM wp_fvm_logs: Data: 0.30MB + Index: 0.02MB + Engine MyISAM wp_layerslider: Data: 0.26MB + Index: 0.00MB + Engine MyISAM wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_nf3_chunks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_field_meta: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wp_nf3_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_nf3_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_object_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf3_upgrades: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wp_nf_objectmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_nf_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ninja_forms_fav_fields: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_ninja_forms_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_options: Data: 4.36MB + Index: 0.29MB + Engine MyISAM wp_pmxe_exports: Data: 0.07MB + Index: 0.00MB + Engine MyISAM wp_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM wp_pmxe_posts: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_postmeta: Data: 7.69MB + Index: 2.00MB + Engine MyISAM wp_posts: Data: 3.31MB + Index: 0.33MB + Engine MyISAM wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_shiptimize: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_shiptimize_marketplace_order: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_taxonomymeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_termmeta: Data: 0.06MB + Index: 0.04MB + Engine MyISAM wp_terms: Data: 0.05MB + Index: 0.09MB + Engine MyISAM wp_term_relationships: Data: 0.05MB + Index: 0.10MB + Engine MyISAM wp_term_taxonomy: Data: 0.04MB + Index: 0.03MB + Engine MyISAM wp_trav_accommodation_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_trav_accommodation_vacancies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_trav_currencies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_trav_reviews: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_usermeta: Data: 0.32MB + Index: 0.19MB + Engine MyISAM wp_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wp_wcpdf_invoice_number: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_inventory_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_product_lookup: Data: 0.07MB + Index: 0.08MB + Engine MyISAM wp_wc_order_stats: Data: 0.05MB + Index: 0.04MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wdr_order_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wdr_order_item_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wdr_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfconfig: Data: 4.33MB + Index: 0.02MB + Engine MyISAM wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wffilemods: Data: 3.43MB + Index: 0.67MB + Engine MyISAM wp_wfhits: Data: 0.35MB + Index: 0.03MB + Engine MyISAM wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfissues: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wp_wfknownfilelist: Data: 1.91MB + Index: 0.20MB + Engine MyISAM wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wflocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_wflogins: Data: 0.22MB + Index: 0.05MB + Engine MyISAM wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfnotifications: Data: 0.13MB + Index: 0.02MB + Engine MyISAM wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfpklist_template_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfstatus: Data: 4.43MB + Index: 0.79MB + Engine MyISAM wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woobe_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woobe_history_bulk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woo_shippment_provider: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM wp_wt_iew_action_history: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_cron: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_ftp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yith_wcwl: Data: 2.19MB + Index: 1.13MB + Engine MyISAM wp_yith_wcwl_lists: Data: 3.28MB + Index: 4.36MB + Engine MyISAM wp_yoast_indexable: Data: 1.03MB + Index: 0.16MB + Engine MyISAM wp_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yoast_seo_links: Data: 0.05MB + Index: 0.02MB + Engine MyISAM wp_yoast_seo_meta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM ### Post Type Counts ### amn_mi-lite: 1 attachment: 1364 atum_supplier: 1 custom_css: 2 customize_changeset: 2 jetpack_migration: 2 nav_menu_item: 49 nf_sub: 3 oembed_cache: 18 omise_charge_items: 4 page: 23 post: 72 product: 135 revision: 421 schema: 2 shop_order: 598 shop_order_refund: 1 sidebar: 1 wplc_quick_response: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (49) ### MooMee Shipping Label, Tracking and Order Items into QR-code for WooCommerce Admin: by MooMee – 1.2.1 MooMee Request track callback from Thailand Post: by MooMee – 1.0.1 MooMee Thailand Post online rates for WooCommerce Admin: by MooMee – 1.1.0 Schema - All In One Schema Rich Snippets: by Brainstorm Force – 1.6.4 Open Currency Converter: by David Artiss – 1.4.5 ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.14 Ban Hammer: by Mika Epstein – 2.8 Block List Updater: by pluginkollektiv – 1.0.0 Classic Editor: by WordPress Contributors – 1.6.2 Code Snippets: by Code Snippets Pro – 2.14.3 Comment Link Remove: by QuantumCloud – 2.2.2 Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.2.3 Exchange Rates Widget: by CurrencyRate.today – 1.4.0 Fast Velocity Minify: by Raul Peixoto – 3.2.6 Instant Articles for WP: by Automattic Dekode Facebook – 4.2.1 WordPress File Monitor: by nicolly – 1.0.9 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.0 Google Language Translator: by Translate AI Multilingual Solutions – 6.0.14 Site Kit by Google: by Google – 1.72.0 Inventory History: by Yashar Hosseinpour – 0.1.2 MooMee E-mail to Line: by MooMee – 1.0.3 Loco Translate: by Tim Whitlock – 2.6.1 Ninja Forms: by Saturday Drive – 3.6.9 Omise Payment Gateway: by Omise and contributors – 4.19 RaCar Clear Cart for WooCommerce: by Rafa Carvalhido – 1.2.1 Schema: by Hesham – 1.7.9.4 Shortcodes Ultimate: by Vladimir Anokhin – 5.12.0 Simple Local Avatars: by Jake Goldman 10up – 2.2.0 Tawk.to Live Chat: by Tawkto – 0.7.1 Telefication: by Foad Tahmasebi – 1.8.1 Gateway for Wise on WooCommerce: by alx359 – 2.1.2 WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.3.20 Advanced Shipment Tracking for WooCommerce: by zorem – 3.3.2 BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 1.1.1 Woo Discount Rules: by Flycart – 2.4.0 WPC Fly Cart for WooCommerce: by WPClever – 4.2.8 WooCommerce Colors: by WooThemes – 1.0.7 WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.14.4 WooCommerce: by Automattic – 6.4.0 (update to version 6.4.1 is available) Wordfence Security: by Wordfence – 7.5.9 WP Crontrol: by John Blackbourn & crontributors – 1.12.1 WP Mail SMTP: by WPForms – 3.3.0 SEOPress: by SEOPress – 5.6 WooCommerce Stock Synchronization: by Pronamic – 2.5.0 WPDT Payment (Free): by Wisan Namwongsa – 1.2 WPFront Notification Bar: by Syam Mohan – 3.2.0 YITH WooCommerce Ajax Search: by YITH – 1.18.0 YITH WooCommerce Compare: by YITH – 2.13.0 YITH WooCommerce Wishlist: by YITH – 3.8.0 ### Inactive Plugins (1) ### MooMee Debug output to Log: by MooMee – 0.0.1 ### Settings ### API Enabled: ? Force SSL: ? Currency: THB (?) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 0 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) woosb (woosb) 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: #4 - / Cart: #5 - /cart/ Checkout: #6 - /checkout/ My account: #7 - /account/ Terms and conditions: #1449 - /return-policy/ ### Theme ### Name: ColorMag MooMee Version: 1.4.6 Author URL: https://okdentang.com/moomee/ Child Theme: ? Parent Theme Name: ColorMag Parent Theme Version: 2.1.1 Parent Theme Author URL: https://themegrill.com WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Complete: 399 Oldest: 2022-03-27 11:14:16 +0700 Newest: 2022-04-16 18:43:08 +0700 Pending: 5 Oldest: 2022-04-17 07:38:35 +0700 Newest: 2022-04-21 16:03:32 +0700 ### Status report information ### Generated at: 2022-04-16 20:54:19 +07:00
Logs have last entry on 23 March, so not connected with current issue (happened on 15 April)
Hello,
Thanks for sending the system status report.
PHP Version: 7.2.18
When checking it, I can confirm the site is using an outdated version of PHP (We strongly recommend version 7.4 or higher).
To update it please check this documentation:
https://woocommerce.com/document/update-php-wordpress/Once it is updated please be sure to switch your theme temporarily to Storefront, disable all plugins except WooCommerce, and repeat the action that is causing the problem i.e. you can create a test order. If the issue disappears it means there was a conflict with the theme or plugins, and you can reactivate them one by one until the cause of the issue is found.
You can find a more detailed explanation on how to do a conflict test here.`
Note: We recommend the plugin WP Staging for quickly spinning up a new test site, just in case you would not like to touch the production site for the testing.
Let us know how it goes.
We haven’t heard back from you in a while (I think you have been able to find a solution), so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.
Thanks.
- The topic ‘Incorrect stock change while order processing’ is closed to new replies.