Mass change affiliate commission rates

[midnightdonkey]

Hi there,

I’ve changed my commission rate recently, but notice all affiliates who signed up before the change are still set to the old commission rate.

Is there an easy way to mass change all affiliates to have the same rate? Or do I have to go through manually?

Thanks!

Tom

[Peter]

Its not a good idea to change the commission of an existing affiliate (people get upset when you do that because they signed for whatever the rate was at that time). This is why when you change the commission rate it only affects the new affiliates (the existing ones still continue to get whatever they were getting before).

If you must change the commission rate on a per affiliate user basis then you can do this easily via phpMyAdmin by editing the data in the table called “wp_affiliates_tbl”.

Please see this tutorial for some handy tricks on how to bulk edit data in the DB using phpMyAdmin:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[Author]

Posts