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
Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2
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 14 October 2017 - 12:23 PM #6
Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2
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;