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.
Can I start affiliate ids at 1000?
Posted in Affiliates Pro
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