Hi,
I’m trying to implement a new feature in the affiliates private area. I would like to create a form where each affiliate could choose in an input select one of the products that he sells, and a new price for it. That form would send an email to the website admin, who would authorize the change or not (manually). The problem is that I’m not able to find the affiliates-products relationship in the db in order to list the products that one affiliate is selling. Could you help me?
Thanks in advance.
Thanks Antonio 🙂
I’m going to try it right now.
Cheers!
Hi,
this relationship is stored in database as an option (in #_options “affiliates_products”). But I recommend you using the api. In your case, this can help you:
$myProducts = Affiliates_Products_WooCommerce::get_products(array("filters"=>array("affiliate_id"=>$affiliate_id)));
cheers