Products and affiliates

—

by

maiky15

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.

Posted in

Comments

2 responses to “Products and affiliates”

  1. maiky15 Avatar
    maiky15

    Thanks Antonio 🙂

    I’m going to try it right now.

    Cheers!

  2. antonio Avatar
    antonio

    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

Share