Is there a way to manually set an affiliate ID number either for an existing account or a newly created one?
Manually Setting Affiliate ID number
Posted in Affiliates by Username
Navigation
What’s new?
- WooCommerce Product Search – Building a Shop Page with Blocks
- WooCommerce Product Search – Building with Blocks
- How to install Redis on Debian or Ubuntu
- How to install Memcached on Debian or Ubuntu
- WooCommerce Product Search Filters and Divi Product Pages
- Small Tools Big
- How Contributors can protect their posts with Groups for WordPress
- WordPress and WooCommerce Compatibility Requirements – June 2023
- Customer Members Club with Discount Privileges
- How to create a time-limited Membership Product
- WooCommerce Product Search and Custom Taxonomies
- WordPress Database Collation Troubles
- The unsettling Truth about the Global Unset
- 1-Click Memberships with Groups for WordPress
- Free Lunch Optimizations
News
Follow us! We post news and tutorials related to our tools, WordPress and WooCommerce on these platforms:
We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
It might yes.
If so far 100 affiliates have registered, the next affiliate will get id 101 for example, so if you use a “future” affiliate id, then you will probably have issues.
After getting a backup, add a new affiliate and keep a note of the two last added affiliates( second-to-last and last). Then edit the last id and give a bigger value. If it’s 100, make it 200. Afterwards make a test registration and check the new id. If the id is 201, you can “play” with the previous ids, aka the between second-to-last and last, but it’s still risky.
The best option would be to redistribute affiliate ids IMO, at least this what I would do. It is safer and risk-free.
Hope I helped.
Cheers,
George
We have mistakenly distributed user id numbers instead of affiliate id numbers and would like to change some of the affiliate id’s to match those distributed. If I change the affiliate id’s in the database table will this effect the issuing of new affiliate id’s going forward?
Hi Kathryn,
I would strongly recommend you not to modify affiliate ids as this operation could cause issues with the normal operation of the plugin. Why would you like to modify affiliate ids? The reason I’m asking is to find out if there is another way to implement your idea and avoid future inconsistencies.
The easiest way to do so would be through the database, you can modify affiliate ids directly. But of course after proceeding with this operation( which again is not recommended ), you should get a full backup of your site files and database. Each time you modify a record, you should also make sure that there are no duplicates, aka two different affiliates should not have the same id.
Kind regards,
George