WP Affiliate Platform – Woocommerce order list

[netsuccess]

Hi There,

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 ?

Thanks

[admin]

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.

[netsuccess]

Hi Admin,

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 ?

[admin]

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.

[netsuccess]

Hi Admin,

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_posts WHERE post_type = ‘shop_order’

[admin]

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_tbl

[netsuccess]

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) ?

[Author]

Posts