When the user buy a product, I want to save a series of data in custom tables in database. This data will be the product id, custom fields I have, and some other data.
My idea is that this should be done when the payment of the product has been made correctly, that is to say, at the time of payment.
I wanted you to give me advice, I have created a way but I don't know if it is the right one or if you would recommend any other way.
I've edited the thankyou page, and I have inserted this code:
$order = new WC_Order ($order->get_id ();
$check_payment = $order->payment_complete ();
if ($check_payment) {
global $wpdb;
wpdb->insert (/* CODE DATABASE*/);
}
当用户购买产品时，我想在数据库中的自定义表中保存一系列数据。 这些数据将是产品ID，我拥有的自定义字段以及其他一些数据。
我的想法是，这应该在产品付款正确时完成，即 说，在付款时。
我希望你给我建议，我已经创造了一种方法，但我不知道它是否是正确的，或者你是否会建议 任何其他方式。
我编辑了谢谢你的页面，我已经插入了这段代码：
$ order = new WC_Order（ $ order-＆gt; get_id（）;
$ check_payment = $ order-＆gt; payment_complete（）;
if（$ check_payment）{
global $ wpdb;
wpdb-＆gt; insert（/ * CODE DATABASE * /）;
}
As woocommerce Order-received (thankyou) page can be reloaded, it's not really the good way.
The correct hook to be used that you can find inside WC_Order payment_complete() method is woocommerce_payment_complete. So your code should be for most payment gateways:
微信扫一扫add_action('woocommerce_payment_complete', 'action_payment_complete', 30, 1 );
function action_payment_complete( $order_id ){
global $wpdb;
// Get an instance of the WC_Order object (if needed)
$order = wc_get_order( $order_id );
// Your database actions code
wpdb->insert (/* CODE DATABASE*/);
}
Code goes in function.php file of the active child theme (or active theme).
For payment methods (CHEQUE HERE) as 'cheque', 'bacs' and 'cod' that needs to be "completed" by shop manager, you will use instead:
add_action( 'woocommerce_order_status_completed', 'action_order_status_completed', 20, 2 );
function action_payment_complete( $order_id, $order ){
// The specific payment methods to be target
$payment_methods = array('bacs','cheque','cod');
// Only for specific payment methods
if( ! in_array( $order->get_payment_method(), $payment_methods ) return;
global $wpdb;
// Your database actions code
wpdb->insert (/* CODE DATABASE*/);
}
So when order status will change to completed for this specific payment methods, this hook will be triggered…
You can also use instead
woocommerce_order_status_processingif you target Processing order status orwoocommerce_order_status_on-holdif you target On Hold order status
Code goes in function.php file of the active child theme (or active theme).
This should works.