August 20, 2014 at 12:47 pm #11342
I am testing the integration for Woocommerce and WP Affiliate Platform.
We have been able to integrate the commission base for each product.
The affiliate able to see the commission they earn after the Woocommerce transaction marked as complete.
The admin using the wordpress dashboard – woocommerce orders list are able to see all the transaction.
How do the site administrator able to list the woocommerce orders including the commissions ?
Is there a way for a site administrator to reject commissions for certain order, but still processing the order ?
ThanksAugust 20, 2014 at 11:56 pm #65049
You can go to the sales admin interface of the affiliate plugin and delete the commission (the ones you want to reject).
I am not 100% sure why you would reject a commission though. Affiliate commission is only given when the customer is referred by an affiliate.August 21, 2014 at 2:45 am #65050
Thank you for your answer.
We might need to delete the commission if the customer order using their own affiliate id.
Regarding my first question, is there a way we browse the woocommerce orders list, and show if any transactions are done through affiliate ?August 21, 2014 at 6:58 am #65051
You can use the Order ID to match the commission. Each commission has a “Transaction ID” column which will match the order ID.
We don’t have an option that will show it in the order’s list. It is a good idea and I will look into it some more.August 21, 2014 at 2:33 pm #65052
Is there any possibility that we can manually browse the woocommerce order list including the wp affiliate commission using phpmyadmin ?
I use this query through phpmyadmin to browse the woocommerce orders :
SELECT * FROM
wp_postsWHERE post_type = ‘shop_order’August 22, 2014 at 12:19 am #65053
I am not entirely sure what you are asking for but you could use the following SQL query to see all the commissions from PHPMyAdmin:
SELECT * FROM wp_affiliates_sales_tblAugust 22, 2014 at 1:27 am #65054
I have try this :
SELECT * FROM wp_affiliates_sales_tbl
And it successfully browse the commission on ‘complete’ woocommerce order.
Which table keep the list of the pending/process orders ? Where do wpaffiliate keep the $referer data (before the transaction set to complete in woocommerce) ?
- You must be logged in to reply to this topic.