All of our affiliate add ons use the same affiliate_id DB column in the orders table to track things.

[ideadude]

Describe the bug
All of our affiliate add ons use the same affiliate_id DB column in the orders table to track things.

And so if you have more than one of these add ons running at the same time, the reports will double count orders for each affiliate system.

For example, on our site we used AffiliateWP for affiliates, but also used the lightweight affiliate tracking plugin to track some random landing pages set up for special occasions. If the affiliate ID 27 was already being used for the other affiliate app, there would already be orders tracked for a newly created affiliate with ID 27.

The work around now is to make sure that you affiliate IDs don't overlap. You can do something to make sure one or the other affiliate apps starts their IDs at 10000 or something to avoid the overlap.

We could append an affiliate app slug to the affiliate_id column in the DB. And update all code to use that. We'd have to update the affiliate plugins. We would have to update existing orders. Most of the affiliate plugins also log a note. So we can double check the note before adjusting the affiliate_id column.