Combining ProductIDs and Banners for commissions

[RussJohnson]

I'm trying to figure out the following:

A site I'm working on has (at least) two differenct products. I would like to offer, for example, two different banners to our affiliates: one would result in a fixed-rate commission (different for each product on the site) and the other a percentage plus recurring sales.

So far I don't see how the "Force choosing commission by product ID" method could work with this, because the commission would depend both on the productID as well as the originating banner.

My question is whether I'm missing something that would make this easy, and if not, if it would be even plausible to implement.

Thanks in advance!

[mark]

Hi,

one would result in a fixed-rate commission (different for each product on the site)

you have to create special product category for each product with different fixed-rate commission.
Using "Force choosing commission by product ID" you can then force commission from correct category to be applied.

the other a percentage plus recurring sales
you will create one more product category with percentage +recurring commission, and add some banners there.
All products that dont have special product categories specifiet above will fall into this category.

hope it helped,

mark

[RussJohnson]

I believe I understand, although treating a given product either as one type of commision or as another depending on the banner.

One option I'm exploring is the "Special affiliate commision categories". The only drawback is that a given affiliate can only use the fixed or percentage commission scheme for a given product, and this is controlled by the Merchant, not the affiliate. Nevertheless, this may be sufficient for our purposes.

As a side note, I did stumble on a small bug when messing around with various combinations. When a product category is deleted, if there were any "Special categories" tied to it, they where not marked as deleted. That is, the deleted column in pa_campaigncategories was not set to 1. Made for some confusing results, as when sales were sometimes registered to product categories that no longer existed.

In any case, I very much like your software (indentation, comments, what a treate!), and I do appreciate your prompt responses. Thanks!

Erf, sorry to be a pain, but I ran accross another campain-deletion related glich.

The following on line 297 of the scripts/SaleRegistrator.class.php file:
$sql = "select * from pa_campaigns where products like'%"._q_noendtags($ProductID)."%'";


should really skip over "deleted" campaigns:
$sql = "select * from pa_campaigns where deleted = 0 and products like'%"._q_noendtags($ProductID)."%'";


Ciau for now

[RussJohnson]

Erp, that last one was by me, Russ Johnson

Erf, sorry to be a pain, but I ran accross another campain-deletion related glich.

The following on line 297 of the scripts/SaleRegistrator.class.php file:
$sql = "select * from pa_campaigns where products like'%"._q_noendtags($ProductID)."%'";


should really skip over "deleted" campaigns:
$sql = "select * from pa_campaigns where deleted = 0 and products like'%"._q_noendtags($ProductID)."%'";


Ciau for now

[mark]

yes, you are right, thanks for help.

regards,

mark