Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Qty_Discounts Sql Table Rate Topic   - - - - -

 
  • alemburda
  • Member
  • Trial users
  • Join Date: 17-Dec 16
  • 38 posts

Posted 12 October 2017 - 03:17 PM #1

UHUARc.jpg

 

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.



 
  • oleg.gorshkov
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 2,315 posts

Posted 12 October 2017 - 04:22 PM #2

UHUARc.jpg

 

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
Testing by QA and personal manager for free.

 
  • alemburda
  • Member
  • Trial users
  • Join Date: 17-Dec 16
  • 38 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  :-) 



 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4,117 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


 
  • alemburda
  • Member
  • Trial users
  • Join Date: 17-Dec 16
  • 38 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.



 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4,117 posts

Posted 14 October 2017 - 12:23 PM #6

http://forum.cs-cart...tity-discounts/


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • victorb
  • Advanced Member
  • Members
  • Join Date: 29-Oct 12
  • 139 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



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10,066 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.


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 15,781 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

Certified CS-Cart RU Developer | Сертифицированный разработчик на CS-Cart Русская Версия