Sign In
How do I get the numbers in there? In which table are the figures in sql?
I will transfer the old data to the system in the new cs-cart version.
|
|
1
Qty_Discounts Sql Table
Rate Topic
-
- CS-Cart Expert
- Authorized Reseller
-
- Join Date: 06-Dec 13
- 2793 posts
Posted 12 October 2017 - 04:22 PM #2
How do I get the numbers in there? In which table are the figures in sql?
I will transfer the old data to the system in the new cs-cart version.
Hello!
These are cscart_product_prices and cscart_ult_product_prices tables.
Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE
Mega SEO Package - All you need for your SEO
-
- Member
- Trial users
- Join Date: 17-Dec 16
- 43 posts
Posted 13 October 2017 - 06:54 AM #3
Hello!
These are cscart_product_prices and cscart_ult_product_prices tables.
cscart_product_prices ok thank you 
-
- Never Re
- Members
- Join Date: 23-Feb 10
- 4289 posts
Posted 13 October 2017 - 11:16 AM #4
remember also qty discounts can be exported imported via csv
Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2
-
- Member
- Trial users
- Join Date: 17-Dec 16
- 43 posts
Posted 14 October 2017 - 06:41 AM #5
How can I clear the figures in this section. because there was a slip in the numbers. There are 2500 products.
-
- Never Re
- Members
- Join Date: 23-Feb 10
- 4289 posts
Posted 14 October 2017 - 12:23 PM #6
Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2
-
- Senior Member
- Members
- Join Date: 29-Oct 12
- 161 posts
Posted 17 November 2017 - 03:39 PM #7
How can I clear the figures in this section. because there was a slip in the numbers. There are 2500 products.
do you succeed ? solution from the other topic doesn't work for me .
Quantity discount are still there
ver 4.6.2
-
- CS Cart Expert
- Authorized Reseller
-
- Join Date: 08-Nov 08
- 10607 posts
Posted 17 November 2017 - 08:40 PM #8
do you succeed ? solution from the other topic doesn't work for me .
Quantity discount are still there
ver 4.6.2
It should if you ran the queries on both tables listed in the article. cscart_product_prices and cscart_ult_product_prices
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.
-
- CS-Cart Expert
- Authorized Reseller
-
- Join Date: 27-Jan 14
- 17405 posts
Posted 20 November 2017 - 06:28 AM #9
Use
DELETE FROM cscart_product_prices WHERE lower_limit > 1; DELETE FROM cscart_utl_product_prices WHERE lower_limit > 1;
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 руб.
