Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

Mass change affiliate commission rates

by

Tips and Tricks HQ Support Portal › Forums › WP Affiliate Platform › WP Affiliate General Questions › Mass change affiliate commission rates

  • This topic has 1 reply, 2 voices, and was last updated 12 years, 10 months ago by Peter.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • June 26, 2012 at 6:03 pm #6676
    midnightdonkey
    Member

    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

    June 27, 2012 at 12:47 am #46494
    Peter
    Member

    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
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ