I know the title sounds complex, let me explain.
Let's say I have a pair of Ray Ban sunglasses I am selling for $100 that earn 5% commission. I then offer a promotion to a local big business for 30% off if they use a coupon I give them. By time I have shipping costs, commission and the discount there is no profit. So in this rare case, is it possible to sell an item that normally would have 5% commission but have a way so when I scan a 30% off coupon, it removes the commission, or at least negates it?
Perhaps if I make a Product that offers 30% OFF can I do something like make the commission on that 30% OFF Product (negative) -5% to negate the 5% commission of the actual product being sold? Any ideas on how to achieve what I am looking to do? Thanks
**EDIT** Just tried giving the coupon a negative 5% commission, but that does not remove the commission. It appears a negative commission is impossible. Any way you can think of to do what I am trying to do. Out of the thousands of transaction, hunting down the 30% off sales, then hunting down which employee did what and then removing the commission during Payroll would take A LOT of time, too much to make it worth the headache. Looking for an automatic system during ring-up to negate it back to zero% commission.