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.
Posted 12 October 2017 - 03:17 PM #1
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.
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
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
Posted 13 October 2017 - 11:16 AM #4
remember also qty discounts can be exported imported via csv
4 14.1
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.
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
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.
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)