Can I start affiliate ids at 1000?

—

by

Joel

Is there any way I can start my affiliate ids at 1,000 instead of 1? I see in the tables it auto-increments starting at 1….is there a value that can be changed to start these at 1,000?

Thanks.

Posted in

Comments

One response to “Can I start affiliate ids at 1000?”

  1. antonio Avatar
    antonio

    Hi Joel,
    if you do not want to show small numbers, you can use “Affiliate ID encoding”, in Affiliates->Options.
    If you don’t want small numbers, but neither MD5 encode, you can alter primary key of wp_aff_affiliates database table, using mysql instruction “ALTER TABLE wp_aff_affiliates AUTO_INCREMENT = 1000”.
    Be careful with this, you can damage the database, always make backup before.
    cheers

Share