Re-Stock after “Pending” order is Cancelled
-
Hello,
I’m having an issue with Stock Management. The stock reduction is correct when the order is under pending status (waiting for credit card confirmation most of the times), but the items are no re-stocked if this pending order is set to Canceled, whether it is setted automatically by the inventory timeout or manually from the admin panel.
However, when order status are On Hold or Processing, if the order is Cancelled, the re-stock is working.
Any ideas what could be causing this issue? Or some function to force re-stock from Pending to Cancelled Orders?
Thanks!
Julieta
-
Hi @gomstudio
There are a few ways to emulate the “Pending Payment” status without using a credit card payment plugin. One way is to use the Cash on Delivery or Direct Bank Transfer payment methods that come by default with WooCommerce. These methods do not process the payment immediately, and thus the order status is set to ‘Pending Payment’ until you manually change it to Processing or Completed, which can be done from the order details page in the WooCommerce > Orders menu.
As for testing on our end, we use a staging site (a clone of the live site) where we can safely perform tests without affecting the live site. We also use various payment gateways that come with WooCommerce and third-party ones to test different scenarios.
Additionally, can you check the “Hold stock (minutes)” setting? If it’s set too high, this might be causing the delay in restocking. You can reduce this value to make the restocking process quicker.
Furthermore, I also suggest you increase WP Memory Limit from 256 MB to 512 MB, PHP Post Max Size from 128 MB to 2 GB, PHP Time Limit from 30 to 1200, and PHP Max Input Vars from 1000 to 6144.
I hope this helps! If you have any other questions or if there’s anything else you need assistance with, please feel free to ask.
Hello @shameemreza thanks for your reply.
I’ve tried the options you recommended, but I can’t emulate the “Pending” status. When I choose Bank Transfer or Cash on Delivery, the order goes ON HOLD status (not pending payment). At this point, the order is fully processed showing the summary on the site, and I get a new order email, as well as the customer.
While in orders staying on pending payment (only generated while using some payment plugin) the emails are not sent, and also stock is not restablished when they are cancelled.
Pending status to Cancelled -> not restoring stock (whether manual or automatically)
On Hold / Processing / Completed to Cancelled -> working fineAlso:
– Hold stock (minutes) is set to 5 (this is working just fine, it cancels the order but not restoring stock, same as cancelling manualy)
– Switched to StoreFront ThemeI attach some screenshots:
It only happens with Pending Payment status, other status after being cancelled are working fine (with or without the gateway payment plugin installed)
This screenshoots are from a clean installation.Any other ideas what might be going on? Do you have screenshots replicating the issue not happening?
` ### WordPress Environment ### WordPress address (URL): https://sd-3360821-h00102.ferozo.net Site address (URL): https://sd-3360821-h00102.ferozo.net WC Version: 8.0.1 REST API Version: ? 8.0.1 WC Blocks Version: ? 10.6.5 Action Scheduler Version: ? 3.6.1 Log Directory Writable: ? WP Version: 6.3 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: es_ES External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.33 PHP Post Max Size: 128 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.45.0 OpenSSL/1.0.1e SUHOSIN Installed: – MySQL Version: 5.7.36 Max Upload Size: 128 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 8.0.1 WC Database Prefix: wp_ Tama?o total de la base de datos: 4.65MB Tama?o de los datos de la base de datos: 2.97MB Tama?o del índice de la base de datos: 1.68MB wp_woocommerce_sessions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_woocommerce_order_items: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_woocommerce_order_itemmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_actionscheduler_actions: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB wp_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_actionscheduler_logs: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_commentmeta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM wp_comments: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM wp_ev_claves: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_icl_strings: Datos: 0.15MB + índice: 0.11MB + Motor MyISAM wp_icl_string_translations: Datos: 0.23MB + índice: 0.08MB + Motor MyISAM wp_links: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM wp_litespeed_url: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_litespeed_url_file: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB wp_options: Datos: 1.64MB + índice: 0.06MB + Motor MyISAM wp_postmeta: Datos: 0.02MB + índice: 0.02MB + Motor MyISAM wp_posts: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM wp_termmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_terms: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM wp_term_relationships: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM wp_term_taxonomy: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM wp_usermeta: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM wp_users: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM wp_wc_admin_notes: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB wp_wc_admin_note_actions: Datos: 0.05MB + índice: 0.02MB + Motor InnoDB wp_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_wc_customer_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_wc_orders: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB wp_wc_orders_meta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_wc_order_addresses: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_wc_order_operational_data: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_wc_order_product_lookup: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_wc_order_stats: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB wp_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_wc_product_attributes_lookup: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_wc_product_meta_lookup: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB wp_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB ### Post Type Counts ### attachment: 1 page: 6 post: 3 product: 1 shop_order: 6 wp_template: 2 ### Security ### Secure connection (HTTPS): ? Tu tienda no está usando HTTPS. Aprende más sobre HTTPS y los certificados SSL. Hide errors from visitors: ? ### Active Plugins (3) ### Health Check & Troubleshooting: por La comunidad de www.remarpro.com – 1.7.0 Getnet Argentina para Woocommerce: por Getnet Argentina – 0.0.8 WooCommerce: por Automattic – 8.0.1 (la actualización a la versión 8.0.2 está disponible) ### Inactive Plugins (5) ### Disable XML-RPC: por Philip Erb – 1.0.1 LiteSpeed Cache: por LiteSpeed Technologies – 5.5 Sucuri Security - Auditing, Malware Scanner and Hardening: por Sucuri Inc. – 1.8.39 Woo Payment Discounts: por WPCodelibrary – 1.3.0 WPVulnerability: por Javier Casares – 2.0.2 ### Must Use Plugins (1) ### Health Check Troubleshooting Mode: por – 1.9.1 ### Settings ### API Enabled: – Force SSL: – Currency: ARS ($) 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: ? HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – ### WC Pages ### Base de la tienda: #5 - /tienda/ Carrito: #6 - /carrito/ Finalizar compra: #7 - /finalizar-compra/ Mi cuenta: #8 - /mi-cuenta/ Términos y condiciones: ? Página sin definir ### Theme ### Name: Storefront Version: 4.5.2 Author URL: https://woocommerce.com/ Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo WooCommerce Support: ? ### Templates ### Overrides: – ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour 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 woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience product-variation-management settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-08-22 21:09:11 +00:00 Options: ? Notes: 73 Onboarding: skipped ### Action Scheduler ### Completo: 21 Oldest: 2023-08-11 21:09:13 +0000 Newest: 2023-08-22 14:03:16 +0000 Fallida: 1 Oldest: 2023-08-11 21:10:14 +0000 Newest: 2023-08-11 21:10:14 +0000 Pendiente: 1 Oldest: 2023-08-22 17:16:45 +0000 Newest: 2023-08-22 17:16:45 +0000 ### Status report information ### Generated at: 2023-08-22 14:15:40 +00:00 `Hello @gomstudio,
I still have the doubt if this “issue” is the expected functionality of WooCommerce (or a bug), meaning if an order stays at “pending” and doesn’t changes status to On Hold, Processing or Completed it doesn’t increase stock by default when it is Cancelled.
From what I’ve checked, the Pending payment status doesn’t reduce the stock in the first place. Meaning if you have a COD order that you switch from on-hold to Pending Payments, the stock will be increased.
Link to image: https://d.pr/i/nu8RcnAs you can see above, I switched from on-hold → pending payment, and the stock was re-added.
I then switched from pending payment → cancelled (nothing happened as expected), then from cancelled → processing and the stock was reduced again as expected.
Link to image: https://d.pr/i/Gsvl7UI suspect that this issue is related to the payment gateway. By default, WooCommerce doesn’t allow initiating a pending payment order (except for an admin order), so I recommend you test this with an invalid test card provided by your payment service.
For example, with Stripe (ensure you’re in test mode): https://stripe.com/docs/testing#declined-payments
Using our official Stripe plugin, you can simulate a declined transaction with one of these cards. WooCommerce will still create the order regardless, enabling customers to try to pay again via the ‘my account → orders’ page.
I’m not sure if your payment gateway will do the same. You can contact the developer for further information on how to purposely decline a transaction.
This test should help determine whether the problem lies with WooCommerce or the payment gateway.
Let us know how it goes!
Hi @geoauction,
This issue is likely due to the inventory management settings in WooCommerce. When a product is added to the cart, and the user proceeds to checkout, WooCommerce automatically reduces the stock quantity for that product. This is to prevent overselling. However, if the payment fails or is cancelled, the stock quantity should ideally be restored.
To resolve this, you might need to check your WooCommerce settings. Go to WooCommerce > Settings > Products > Inventory. You can set the “Hold Stock (minutes)” option to a suitable value here. This is the duration for which an unpaid product will stay reserved. If the payment isn’t made within this duration, the order will be cancelled, and the product will be returned to stock.
Additionally, check your auction plugin settings to see if there’s any option to control when the stock count is reduced. You may need to set this to occur after payment is successfully received, rather than when the auction is won.
I also suggest reaching out to the support team of your auction plugin. They might have more insights on how their plugin interacts with WooCommerce.
Please try this and let us know if it helps. Looking forward to hearing from you soon.
- The topic ‘Re-Stock after “Pending” order is Cancelled’ is closed to new replies.
