Commissions Not Working

  • Resolved benkurbis

    (@benkurbis)


    7 years, 4 months ago

    When orders are placed, no commissions are being given to the vendors. They receive an email saying a new order was placed, but the commission dollar amount says 0. Then when I login to the backend dashboard and click on Commissions, no commissions show up. I’ve triple checked all settings, disabled all plugins except woocommerce, and wc vendors, I’ve tried with Storefront theme and each time the test failed with commission given being 0 even though I have a default commission set at 75%. Tried it with setting a specific commission for the product, and that didn’t work either. WooCommerce Status page all clear – no red. I’m sure I must be missing smething so simple, but have tried figuring it out over the past few days with no luck. Any assistance would be greatly appreciated. Thank you so much!

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter benkurbis

    (@benkurbis)

    Error Log:

    [Tue Oct 31 18:35:50.758292 2017] [proxy_fcgi:error] [pid 10202:tid 140585981486848] [client 72.214.28.178:56483] AH01071: Got error ‘PHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SELECT COUNT(*)\n\t\t\t\t\tFROM wp_pv_commission\n\t\t\t\t\tWHERE vendor_id = ‘9’\n\t\t\t\t\tAND order_id = ‘490’\n\t\t\t\t\tAND status = ‘due’ made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WCV_Commission::log_commission_due, WCV_Vendors::count_due_by_vendor\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SELECT count(order_id) AS order_count \n\t\t\t\t \tFROM wp_pv_commission\n\t\t\t\t \tWHERE order_id = 490 \n\t\t\t\t \tAND vendor_id = 9 \n\t\t\t\t \tAND product_id = 486\n\t\t\t\t \tAND status = ‘paid’\n\t\t made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WCV_Commission::log_commission_due, WCV_Commission::insert_new_commission, WCV_Commission::check_commission_status\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_pv_commission made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WCV_Commission::log_commission_due, WCV_Commission::insert_new_commission\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_pv_commission made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WCV_Commission::log_commission_due, WCV_Commission::insert_new_commission\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SELECT total_due \n\t\t\t\tFROM wp_pv_commission\n\t\t\t\tWHERE vendor_id = 9 \n\t\t\t\tAND product_id = ‘486’ \n\t\t\t\tAND order_id = ‘490’ \n\t\t\t made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_pending_to_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Emails::send_transactional_email, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Email_Notify_Vendor->trigger, WC_Email->get_content, WC_Email_Notify_Vendor->get_content_html, wc_get_template, include(‘/plugins/wc-vendors/templates/emails/vendo…\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SELECT total_due \n\t\t\t\tFROM wp_pv_commission\n\t\t\t\tWHERE vendor_id = 9 \n\t\t\t\tAND product_id = ‘486’ \n\t\t\t\tAND order_id = ‘490’ \n\t\t\t made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_pending_to_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Emails::send_transactional_email, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Email_Notify_Vendor->trigger, WC_Email->get_content, WC_Email_Notify_Vendor->get_content_html, wc_get_template, include(‘/plugins/wc-vendors/templates/emails/vendo…\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SELECT total_due \n\t\t\t\tFROM wp_pv_commission\n\t\t\t\tWHERE vendor_id = 9 \n\t\t\t\tAND product_id = ‘486’ \n\t\t\t\tAND order_id = ‘490’ \n\t\t\t made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_pending_to_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Emails::send_transactional_email, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Email_Notify_Vendor->trigger, WC_Email->get_content, WC_Email_Notify_Vendor->get_content_html, wc_get_template, include(‘/plugins/wc-vendors/templates/emails/vendo…\nPHP message: WordPress database error Table ‘bitnami_wordpress.wp_pv_commission’ doesn’t exist for query SELECT total_due \n\t\t\t\tFROM wp_pv_commission\n\t\t\t\tWHERE vendor_id = 9 \n\t\t\t\tAND product_id = ‘486’ \n\t\t\t\tAND order_id = ‘490’ \n\t\t\t made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Meta_Boxes->save_meta_boxes, do_action(‘woocommerce_process_shop_order_meta’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Meta_Box_Order_Data::save, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_pending_to_completed’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Emails::send_transactional_email, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Email_Notify_Vendor->trigger, WC_Email->get_content, WC_Email_Notify_Vendor->get_content_html, wc_get_template, include(‘/plugins/wc-vendors/templates/emails/vendo…\n’, referer: https://deals.socalgolfer.org/wp-admin/post.php?post=490&action=edit

    Hello,
    According to the errors, it looks like the commissions table does not exist in your database, or some of it does not..
    wp_pv_commission

    Let me see if I can get someone else to take a look as well.
    Cheers,

    Confirmed– this indicates that your pv_commission table does not exist in your database.
    Cheers,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Commissions Not Working’ is closed to new replies.