dtg7662 2018-01-31 17:17
浏览 269
已采纳

在WooCommerce中为付费订单添加自定义数据库表中的数据

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*/);
} 
  • 写回答

1条回答 默认 最新

  • douan9541 2018-01-31 18:06
    关注

    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_processing if you target Processing order status or woocommerce_order_status_on-hold if you target On Hold order status

    Code goes in function.php file of the active child theme (or active theme).

    This should works.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 12864只亮屏 不显示汉字
  • ¥20 三极管1000倍放大电路
  • ¥15 vscode报错如何解决
  • ¥15 前端vue CryptoJS Aes CBC加密后端java解密
  • ¥15 python随机森林对两个excel表格读取,shap报错
  • ¥15 基于STM32心率血氧监测(OLED显示)相关代码运行成功后烧录成功OLED显示屏不显示的原因是什么
  • ¥100 X轴为分离变量(因子变量),如何控制X轴每个分类变量的长度。
  • ¥30 求给定范围的全体素数p的(p-2)/p的连乘积值
  • ¥15 VFP如何使用阿里TTS实现文字转语音?
  • ¥100 需要跳转番茄畅听app的adb命令