Jump to content

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

Wholesale Add-On, How To Deal With Quantity Discounts ? Rate Topic   - - - - -

 
  • billly
  • Newbie
  • Trial users
  • Join Date: 20-Jan 16
  • 5 posts

Posted 16 January 2017 - 09:58 AM #1

Dear readers,

 

I have purchased and already started using a wholesale add-on.

Currently on a shop that I work for, there are more than 2000 active,

quantity discount values.

 

Is there a way that I could delete the quantity discounts
without having to visit each product one by one ?

 

Best Regards

Bill



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

Posted 16 January 2017 - 02:23 PM #2


Run the following query in the phpMyAdmin

DELETE FROM cscart_product_prices WHERE usergroup_id > 0; 
 
Make a backup just in case

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 руб.


 
  • billly
  • Newbie
  • Trial users
  • Join Date: 20-Jan 16
  • 5 posts

Posted 18 January 2017 - 07:38 AM #3

Haven't had the change to implement it, since our highly trained monkeys managed to remote each and every one manually in less than an hour. Although, I would like to thank you very much for the reply.

 

Bill



 
  • markhedley
  • Advanced Member
  • Trial users
  • Join Date: 19-Nov 16
  • 129 posts

Posted 18 January 2017 - 12:10 PM #4

Haven't had the change to implement it, since our highly trained monkeys managed to remote each and every one manually in less than an hour. Although, I would like to thank you very much for the reply.

 

Bill

Not so highly trained if they did it manually :-) hehe



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

Posted 18 January 2017 - 02:15 PM #5

Haven't had the change to implement it, since our highly trained monkeys managed to remote each and every one manually in less than an hour. Although, I would like to thank you very much for the reply.

 

Bill

 

:) 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 руб.