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
- 3632 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
Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics
-
- Advanced Member
- Trial users
- Join Date: 17-Dec 16
- 51 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
- 5070 posts
Posted 13 October 2017 - 11:16 AM #4
remember also qty discounts can be exported imported via csv
4 14.1
-
- Advanced Member
- Trial users
- Join Date: 17-Dec 16
- 51 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.
-
- Senior Member
- Members
- Join Date: 29-Oct 12
- 200 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
- 12156 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
- 22818 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 1210 Multi-Vendor USD 1250 Multi-Vendor PLUS USD 3100 (2775)
CS-Cart Ultimate USD 4025 CS-Cart + YOUPI USD 1459 Multi-Vendor Ultimate USD 7500 (6000)
