This occurs only when the purchase is made with paypal because for cash or cheque payment, after user click on the “Place Order” button, the transaction is captured on the Woocommerce – Order and the stock level is reduced. So when admin change the order status to “Cancelled”, the stock level is auto-restock, which is correct. But with paypal, user can click on “cancel” on the paypal payment page which causes “Cancelled” order and trigger Auto-restock. When user reach the payment payment page, the order is captured in Woocommerce-Order but the stock level is not reduced. If user click on “cancel” on the paypal payment page, the order is consider “Cancelled” so the stock level is increased, which is not correct.

Hi, any update on this? Thanks

Hi,

We do not have auto restock enable in WC because Woocommerce has NO auto-restock feature and we do not install any auto-restock plugin either. We are only using the “Auto re-stock tickets” in eventon ticket settings.

From what i see, the “Auto-restock tickets” feature in eventon ticket can only work with Cash payment or cheque payment. As for paypal payment because user can click on the “cancel” on the payment page, which woocommerce capture it as “Cancelled order” and so eventon ticket auto-restock the inventory.

At first we were so happy that there is auto-restock feature in eventon ticket because this is what lacking in Woocommerce. Woocommerce has NO auto-restock feature. But now it seems eventon ticket auto-restock is not working properly either.

Hope you can have a thorough test on this. Setup a paypal sandbox and do a test and you will see what i mean.

Thanks for your help.

Hi, thanks for your reply.

If user is paying via Paypal and the moment when Paypal payment open, Woocommerce immediately capture this transaction in Wooocommerc-Order with the order status as “Pending Payment” but stock is not reduced. So if user click on Cancel on the Paypal payment page, the order status change from “Pending Payment” to “Cancelled“.

I found below auto-restore code is working because it is trigger only when the order status change from “Processing” (stock is reduced)  to “Cancelled” (‘woocommerce_order_status_processing_to_cancelled’).

We prefer not to use third-party plugin or code because it is more difficult to manage multiple plugins. We really hope that Eventon auto-restock is working.

We also found this post which said when WooCommerce reduces the stock for an order a post meta value ‘_order_stock_reduced’ is set to remember the stock is reduced for this order. Should EventOn check if the stock has actually been reduced for the order and skip restoring stock if post meta value ‘_order_stock_reduced’ is not set?

https://wordpress.org/support/topic/only-restore-stock-when-inventory-for-order-is-reduced/ 

https://github.com/woocommerce/woocommerce/blob/753014da5a6df243928e4b7baebb035300ab70ff/includes/abstracts/abstract-wc-order.php#L2470

class Comfythemes_Woocommerce_Auto_Stock_Restore {

function __construct() {
add_action( ‘woocommerce_order_status_processing_to_cancelled’, array( $this, ‘restore_order_stock’ ), 10, 1 );
add_action( ‘woocommerce_order_status_completed_to_cancelled’, array( $this, ‘restore_order_stock’ ), 10, 1 );
add_action( ‘woocommerce_order_status_on-hold_to_cancelled’, array( $this, ‘restore_order_stock’ ), 10, 1 );
add_action( ‘woocommerce_order_status_processing_to_refunded’, array( $this, ‘restore_order_stock’ ), 10, 1 );
add_action( ‘woocommerce_order_status_completed_to_refunded’, array( $this, ‘restore_order_stock’ ), 10, 1 );
add_action( ‘woocommerce_order_status_on-hold_to_refunded’, array( $this, ‘restore_order_stock’ ), 10, 1 );
}
public function restore_order_stock( $order_id ) {
$order = new WC_Order( $order_id );

if ( ! get_option(‘woocommerce_manage_stock’) == ‘yes’ && ! sizeof( $order->get_items() ) > 0 ) {
return;
}
foreach ( $order->get_items() as $item ) {
if ( $item[‘product_id’] > 0 ) {

$_product = $order->get_product_from_item( $item );

if ( $_product && $_product->exists() && $_product->managing_stock() ) {

$old_stock = $_product->stock;
$qty = apply_filters( ‘woocommerce_order_item_quantity’, $item[‘qty’], $this, $item );
$new_quantity = $_product->increase_stock( $qty );
do_action( ‘woocommerce_auto_stock_restored’, $_product, $item );
$order->add_order_note( sprintf( __( ‘Item #%s stock incremented from %s to %s.’, ‘woocommerce’ ), $item[‘product_id’], $old_stock, $new_quantity) );
$order->send_stock_notifications( $_product, $new_quantity, $item[‘qty’] );
}
}
}
}
}
new Comfythemes_Woocommerce_Auto_Stock_Restore();

Hi, the function that i pasted doesn’t check for that _order_stock_reduced value. This function is working because it is triggered only when the order status change from “Processing” to “Cancelled” or from “Completed” to “Cancelled”.

I just assume that we could check for _order_stock_reduced.

Thanks for looking into this issue. However, we have one open ticket #14926 the stock inventory is not working for Repeating Event with “Manage capacity separate for each repeating event”. Hope you could looking into this issue too.