Jump to content

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

Fractional Numbers - Discounts By Percentage Rate Topic   - - - - -

 

Posted 25 July 2019 - 03:30 PM #1

Hi there,

 

In cs-cart you can set a discount of  €22.20 for quantity discount.

This only works with absolute price.

 

if I want to set 33.33% discount by percentage, this does not work.

 

 

33 after the decimal point will be deleted after saving.

 

Does anyone have a solution?



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

Posted 26 July 2019 - 07:11 AM #2

Try in the phpMyAdmin change type of the percentage_discount column in the cscart_product_prices table from int(2) unsigned NOT NULL DEFAULT '0' to decimal(12,2) NOT NULL DEFAULT '0.00'

 

(!) Not tested


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    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 

Posted 29 July 2019 - 02:37 PM #3

Thanks for your help but unfortunately, this does not work:(



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

Posted 29 July 2019 - 07:57 PM #4

If you use CS-Cart (not Multi-Vendor) do the same action in the cscart_ult_product_prices table


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    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 

Posted 30 July 2019 - 01:06 PM #5

You're great, it works! :grin:



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

Posted 31 July 2019 - 05:30 AM #6

You are welcome!


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    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.