Order subtracts stock 2 times
-
Good Morning,
For a few weeks now, when orders are made through REDSYS or Paypal, the stock is discounted 2 times and ends in negative. The emails also arrive duplicated as if they had been bought twice.
Any ideas?
Thanks in advance.
The page I need help with: [log in to see the link]
-
Hi there,
We’ve seen issues like that with PayPal when both IPN and PDT were enabled, causing PayPal to notify the site twice that the transaction completed, resulting in emails and stock reduction being duplicated.
Please check to make sure you only have one or the other active in the gateway:
https://docs.woocommerce.com/document/paypal-standard/#section-31If you are still having trouble, 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, you can paste it here in your reply. Please note that since this is a public forum, you may want to remove any sensitive information that you don’t want shared publicly.
Good morning,
The error is not so Paypal but in general when payments are made through payment gateways, although the payments are made correctly, perhaps they have nothing to do with it.
I attach text of the order notes where there is twice stock remaining:
Order Notes
Awaiting REDSYS payment The order status changed from Awaiting payment to Processing.December 9, 2020 at 12:15 PM Delete note
The order status changed from Pending Payment to Processing.
December 9, 2020 at 12:15 PM Delete note
Reduced inventory levels: The nan casteller (40 pieces) (# 21778) 1 → -2
December 9, 2020 at 12:15 PM Delete note
Reduced Inventory Levels: The Nan Casteller (40 pieces) (# 21778) 4 → 1
December 9, 2020 at 12:15 PM Delete note
Now I attach the health of the site:
Site health status
The site health check shows critical information about your WordPress settings and the items that require your attention.1 critical error
You have topics waiting to be updated.
Security
4 recommended improvementsWordPress update available (5.6)
performanceYou should remove inactive plugins
Security
Plugins extend the functionality of your site with things like contact forms, e-commerce, and many others. This means that they have deep access to your site and therefore it is vital to keep them updated.Your site has 2 plugins waiting to be updated.
Your site has 1 inactive plugin. Inactive plugins are tempting targets for attackers. If you are not going to use a plugin, we recommend that you remove it.
Manage your plugins
Update your plugins
Manage inactive plugins
Your site is running an old version of PHP (7.3.23)
performanceOne or more recommended modules are missing
performanceThanks and regards.
Hi there,
Thank you, however that is a bit different from the report I was looking for. You can find the WooCommerce System Status Report under WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it here in your reply.
From the order notes, we can see that it is triggering the order status change to
Processingtwice — once fromPending payment(which is a built-in WooCommerce order status), and once fromAwaiting payment(which is not built-into WooCommerce). You can see the default WooCommerce statuses here:
https://docs.woocommerce.com/document/managing-orders/#section-1That double triggering of the order status would most likely explain the duplicate stock reduction and order emails.
Hi,
I am enclosing the report you have given me.
`
### WordPress Environment ###WordPress address (URL): –
Site address (URL): –
WC Version: 4.8.0
REST API Version: ? 4.8.0
WC Blocks Version: ? 3.8.1
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.7.3
Log Directory Writable: ?
WP Version: ? 5.5.3 – Hi ha disponible una versió més nova de WordPress (5.6)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: ca_ES
External object cache: –### Server Environment ###
Server Info: Apatxe
PHP Version: 7.3.23
PHP Post Max Size: 120 MB
PHP Time Limit: 30
PHP Max Input Vars: 3000
cURL Version: 7.72.0
OpenSSL / 1.1.1hSUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.26-MariaDB
Max Upload Size: 120 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?### Database ###
WC Database Version: 4.8.0
WC Database Prefix: 90IUqaM0u_
Total Database Size: 170.48MB
Database Data Size: 113.53MB
Database Index Size: 56.95MB
90IUqaM0u_woocommerce_sessions: Data: 6.02MB + Index: 0.16MB + Engine InnoDB
90IUqaM0u_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
90IUqaM0u_woocommerce_order_items: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
90IUqaM0u_woocommerce_order_itemmeta: Data: 1.52MB + Index: 1.97MB + Engine InnoDB
90IUqaM0u_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
90IUqaM0u_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_actionscheduler_actions: Data: 1.48MB + Index: 0.41MB + Engine MyISAM
90IUqaM0u_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_actionscheduler_logs: Data: 1.33MB + Index: 0.48MB + Engine MyISAM
90IUqaM0u_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_aiowps_failed_logins: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_aiowps_login_activity: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_aiowps_login_lockdown: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_comments: Data: 1.52MB + Index: 0.58MB + Engine InnoDB
90IUqaM0u_ewwwio_images: Data: 0.97MB + Index: 0.50MB + Engine MyISAM
90IUqaM0u_ewwwio_queue: Data: 0.32MB + Index: 0.19MB + Engine MyISAM
90IUqaM0u_fusion_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_fusion_form_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_fusion_form_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_fusion_form_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_newsletter: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_newsletter_emails: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_newsletter_sent: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_newsletter_stats: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_options: Data: 17.14MB + Index: 1.48MB + Engine InnoDB
90IUqaM0u_postmeta: Data: 46.58MB + Index: 39.14MB + Engine InnoDB
90IUqaM0u_posts: Data: 17.42MB + Index: 3.64MB + Engine InnoDB
90IUqaM0u_revslider_css: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_revslider_slides: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_shopmagic_automation_outcome: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_shopmagic_automation_outcome_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_shopmagic_guest: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_shopmagic_guest_meta: Data: 0.23MB + Index: 0.14MB + Engine MyISAM
90IUqaM0u_shopmagic_log_data: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
90IUqaM0u_shopmagic_optin_email: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_stock_log: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
90IUqaM0u_termmeta: Data: 1.52MB + Index: 0.58MB + Engine InnoDB
90IUqaM0u_terms: Data: 1.52MB + Index: 0.61MB + Engine InnoDB
90IUqaM0u_term_relationships: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
90IUqaM0u_term_taxonomy: Data: 1.52MB + Index: 0.61MB + Engine InnoDB
90IUqaM0u_usermeta: Data: 1.52MB + Index: 1.98MB + Engine InnoDB
90IUqaM0u_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
90IUqaM0u_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_wc_order_product_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_wc_product_meta_lookup: Data: 0.52MB + Index: 1.02MB + Engine InnoDB
90IUqaM0u_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
90IUqaM0u_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
90IUqaM0u_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
90IUqaM0u_yoast_indexable: Data: 4.85MB + Index: 0.79MB + Engine MyISAM
90IUqaM0u_yoast_indexable_hierarchy: Data: 0.07MB + Index: 0.16MB + Engine MyISAM
90IUqaM0u_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
90IUqaM0u_yoast_primary_term: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
90IUqaM0u_yoast_seo_links: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
90IUqaM0u_yoast_seo_meta: Data: 0.36MB + Index: 0.00MB + Engine InnoDB### Post Type Counts ###
attachment: 3977
custom_order_status: 1
customize_changeset: 1
fusion_element: 3
fusion_template: 3
mc4wp-form: 2
nav_menu_item: 122
oembed_cache: 56
page: 46
polylang_mo: 2
post: 39
product: 2379
product_variation: 1707
revision: 1733
shop_coupon: 42
shop_order: 743
shop_order_refund: 8
shopmagic_automation: 1
slide: 51
ticket-meta-fieldset: 9
tribe_events: 211
tribe_organizer: 42
tribe_venue: 14
tribe_wooticket: 436
wc_voucher: 12
wc_voucher_template: 18### Security ###
Secure connection (HTTPS): ?
Hide errors from visitors: ?### Active Plugins (38) ###
Polylang Pro: by Frédéric Demarle – 2.4.1
My Modal: by BARA develops –
Akismet Anti-Spam: by Automattic – 4.1.7
All In One WP Security: by Tips and Tricks HQ
Peter Petreski
Ruhul
Ivy – 4.4.5Better Font Awesome: by Mickey Kay – 1.7.4
Contact Form 7: by Takayuki Miyoshi – 5.3.1
Custom Order Status for WooCommerce: by Tyche Softwares – 2.0.1
Event Tickets Plus: by Modern Tribe
Inc. – 5.1.0.2Event Tickets: by Modern Tribe
Inc. – 5.0.3.1Facebook for WooCommerce: by Facebook – 2.2.0
Avada Builder: by ThemeFusion – 3.1.2
Avada Core: by ThemeFusion – 5.1.2
Jetpack by WordPress.com: by Automattic – 9.2
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.1
Non-Purchasable WooCommerce Products: by Guy Primavera – 1.3 – Installed version not tested with active version of WooCommerce 4.0
Polylang for WooCommerce: by Frédéric Demarle – 1.0.4 – Installed version not tested with active version of WooCommerce 4.0
Redsys WooCommerce: by Redsys – 3.0.1 – Installed version not tested with active version of WooCommerce 4.0
Slider Revolution: by ThemePunch – 5.4.7.1
Scalable Vector Graphics (SVG): by Sterling Hamilton – 3.4
Search Exclude: by Roman Pronskiy – 1.2.6
ShopMagic for WooCommerce: by WP Desk – 2.18.0
Shortcode in Menus: by Gagan Deep Singh – 3.5
Smart WooCommerce Search: by YummyWP – 2.0.2
Category Order and Taxonomy Terms Order: by Nsp-Code – 1.5.7.3
Events Shortcodes and Templates Addon: by Cool Plugins – 1.6.1
The Events Calendar: by Modern Tribe
Inc. – 5.3.0GDPR Cookie Consent Banner: by termly – 2.3.15
UpdraftPlus – Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.41User Switching: by John Blackbourn & contributors – 1.5.6
Widgets in Menu for WordPress: by saurabhshukla
yapapaya – 1.0.0Hyyan WooCommerce Polylang Integration: by Hyyan Abo Fakher – 1.4.3 – Installed version not tested with active version of WooCommerce 4.0
Woo Stickers by Webline: by Weblineindia – 1.1.5
Woocommerce Checkout Terms Conditions Popup: by WC Marketplace – 1.2.0
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.25
WooCommerce PDF Product Vouchers: by SkyVerge – 3.3.0 – Installed version not tested with active version of WooCommerce 4.0
WooCommerce Stock Manager: by StoreApps – 2.5.3
WooCommerce: by Automattic – 4.8.0
WP Mail SMTP: by WPForms – 2.5.1### Inactive Plugins (1) ###
Yoast SEO: by Team Yoast – 15.4
### Dropin Plugins (1) ###
maintenance.php: maintenance.php
### Must Use Plugins (1) ###
p3-profiler.php: by –
### Settings ###
API Enabled: ?
Force SSL: –
Currency: EUR (€)
Currency Position: right
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: simple (simple)
grouped (grouped)
variable (variable)
external (external)Taxonomies: Product Visibility: exclude-from-search (exclude-from-search)
exclude-from-catalog (exclude-from-catalog)
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: #28827 – –
Cart: #19604 – –
Checkout: #20227 – –
My account: #20312 – –
Terms and conditions: #20283 – –
### Theme ###Name: Avada Child
Version: 1.0.0
Author URL: https://theme-fusion.com
Child Theme: ?
Parent Theme Name: Avada
Parent Theme Version: 7.1.2
Parent Theme Author URL: https://themeforest.net/user/ThemeFusion
WooCommerce Support: ?### Templates ###
Overrides: Avada/woocommerce/cart/cart.php
Avada/woocommerce/checkout/form-pay.php
Avada/woocommerce/checkout/review-order.php
Avada/woocommerce/checkout/thankyou.php
Avada/woocommerce/loop/loop-start.php
Avada/woocommerce/single-product/add-to-cart/variable.php
Avada/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada/woocommerce/single-product/tabs/description.php### WC Pages Translations ###
Shop base: ?
Cart: ?
Checkout: ?
My account: ?### Action Scheduler ###
Complet: 633
Oldest: 2020-11-16 09:48:52 +0100
Newest: 2020-12-10 09:35:07 +0100Fracassat: 3,439
Oldest: 2020-12-04 12:36:41 +0100
Newest: 2020-12-10 09:58:55 +0100En progrés: 1
Oldest: –
Newest: –`
Thank you.
Hello again,
I have noticed that in two orders that have been made yesterday and today there has been no problem, one with Paypal and the other with Redsys.
Only the stock has been subtracted once and without problems.
It only happens sometimes and we don’t know why the problem occurs.
Could it be that the buyer backs up in the browser at checkout?
Thank you!
Hi there,
The customer not completing payment, and instead backing up in the browser during Checkout, should result in the order staying as
Payment pendingand eventually being cancelled (not the problem you are seeing).With the problem only happening randomly, that certainly makes it more difficult to troubleshoot.
I see that you are using this plugin —
Custom Order Status for WooCommerce: by Tyche Softwares. Since that second/duplicate Order status transition is using a custom status, it’s certainly possible it could be related.I’d recommend deactivating that for a few days and checking to see if you see any other orders with that issue.
Hi,
The plugin to customize the status is used only for when we notify that the package has been sent. But I suppose that the general configuration of the plugin causes the REDSYS payment method to alter the stock and the order.
We will try to deactivate it for a few days to see if that way we can solve the problem.
Thanks a lot!
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.
Best!
- The topic ‘Order subtracts stock 2 times’ is closed to new replies.
