Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 General help me questions
 Where is affcommissionrate calculated?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lori Titus
VP-CART New User

144 Posts

Posted - April 14 2014 :  15:06:42  Show Profile  Visit Lori Titus's Homepage  Reply with Quote
At the moment, affcommission is a percentage of the order total (minus shipping). I would like it to be calculated on the order subtotal (ie, before coupons are applied). Where would I go about making this change?

The Internet''s #1 supplier of honey and beeswax.

carfin
VP-CART Expert

United Kingdom
948 Posts

Posted - April 17 2014 :  11:57:43  Show Profile  Reply with Quote
Hi Lori,

sounds like your rate is set up as a percentage of the total in xaffcommissionrate. I think you would have to set the rate by product and not order.
You can do this by removing data in xaffcommissionrate and setting xaffcommissionproduct to Yes and a field from the products records for xaffcommissionproductfield. You can then use a sql statement to set all the prices in that product field to whatever the affiliates percentage is.

Regards,

Carrol
www.deanston-electrical.co.uk

Edited by - carfin on April 17 2014 11:58:05
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00