Delete Quantity Discounts

General General Questions
1

Im trying to remove all qty discounts. I created a file in notepad and named it RemoveQTY.sql and did as per the bellow but it doesn't work. Any ideas?\

Thank you for the request.


In order to remove all quantity discounts, please create the discounts.sql file in the var/backups directory of your CS-Cart installation with the following content:
DELETE FROM cscart_product_prices WHERE lower_limit > 1

After that please back up your database on the Administration > Backup/Restore page in the CS-Cart admin panel and restore the discounts.sql file by clicking the gear button and selecting the Restore option on the Administration > Backup/Restore page in the CS-Cart admin panel.

RemoveQTY.sql

2

I needed to name it "discounts.sql" then it worked

3

Great, thanks for info

4

We also need to delete all our product quantity discounts for everything. The above doesn't work. (script runs but does nothing)..

How can we do this.. Can it be done directly with in the database..

5

We also need to delete all our product quantity discounts for everything. The above doesn't work. (script runs but does nothing)..

How can we do this.. Can it be done directly with in the database..

Never mind just did it within the database itself..

6

We also need to delete all our product quantity discounts for everything. The above doesn't work. (script runs but does nothing)..

How can we do this.. Can it be done directly with in the database..

Check your TABLE_PREFIX setting (in the config.local.php file). If it is not 'cscart_', you should modify the script to

DELETE FROM [YOUR_TABLE_PREFIX]product_prices WHERE lower_limit > 1
7

If the CS-Cart is used, not Multi-Vendor, please run the following query also:

DELETE FROM [YOUR_TABLE_PREFIX]ult_product_prices WHERE lower_limit > 1