Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Calculating Commission After Discounts Are Applied Rate Topic   - - - - -


Posted 12 December 2015 - 02:00 AM #1

Note that this has nothing to do with affiliates, so please don't refer me to something affiliate related just to get commission functionality... unless it is the only or best way to get it.  I really don't want affiliate features mucking up or confusing the admin interface.


I want to calculate commission based on sales after discounts have been applied.  Here is my problem.


I did a few test orders with both cart and catalog based promotions.  I thought I could simply take subtotal - discount from cscart_orders and get the net amount to calculate the commission from.  Works in some cases but not all.  When I use a promotion where I used a coupon code giving 50% off a specific product, the subtotal already has the 50% marked off, but discount still reflects the 50%, so if I do subtotal - discount, I am doubling up on the discount.  :-(


Am I missing something simple?  Is there a way to calculate the net amount, post discount, without knowing all of cs-cart's discount rules and processing something like extra in cscart_order_details?



  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3476 posts

Posted 14 December 2015 - 09:06 AM #2

Unfortunately, code modification is required. You do should modify a code after all promotions are applied in the fn_calculate_cart_content function

Simtech Development | sales@simtechdev.com | www.simtechdev.com

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics

  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20910 posts

Posted 14 December 2015 - 03:32 PM #3

I agree with colleague. Custom modification is required here. Feel free to contact us if you are interested

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

  • Flow
  • Super Duper and Amazingly Sexy Senior
  • Members
  • Join Date: 13-Oct 10
  • 2351 posts

Posted 14 December 2015 - 08:08 PM #4

Could this have something to do with the everlasting problem described here, and ignored by cs-cart? 



When life hands you lemons, bring on the Tequila baby!

  • Vivek Gupta
  • Senior Member
  • Members
  • Join Date: 09-Jul 15
  • 247 posts

Posted 19 December 2015 - 01:19 PM #5

For manage rewards point , you need to go for code modification . please contact here  .

Vivek Gupta