How to add the discount qty box to ALL products???

How to add the discount qty box to ALL products??? Is there a way to it then manually??

The discount quanties are stored in the table:
products_discount_quantity

Then, in the products table you need to update the 2 fields for:
products_discount_type
products_discount_type_from

If you setup a Product with the proper Discount Quanties ... you will be able to see what these settings are ...

eehe...Thanks... But were??? In MySQL or...:wacko: i found a Tabell: zen_products_discount_quantity... but not products_discount_type or
products_discount_type_from...

I want to have same discount on all my products.

0-59pcs = 5%
60-119pcs = 7%
120-599pcs=10%
600-1199pcs=15%

Peter....

These are fields in the products table ...

In your case, the zen_products table ...

I think i have foud it but it was named different. But i have found allt the number and also exported it to excel.....

I have created the excel file but i got some kind of FAIL when importing the file...

Ajeh:

The discount quanties are stored in the table:
products_discount_quantity

Then, in the products table you need to update the 2 fields for:
products_discount_type
products_discount_type_from

If you setup a Product with the proper Discount Quanties ... you will be able to see what these settings are ...

Ok, i found them:

products_discount_type tinyint(1) NOT NULL default '0',
products_discount_type_from tinyint(1) NOT NULL default '0',

What to do with them????

And i also found a table with my values in it:
discount_id
products_id
discount_qty
discount_price

To add all data to thouse fields will take as long as to do it in ZC. Is there any fast way to do it???

//Peter

You could write a php file to collect all of the product_id and then build the products_discount_quantity with that for the values ...

Then update the two fields in the products table to the correct settings ...

Ajeh:

You could write a php file to collect all of the product_id and then build the products_discount_quantity with that for the values ...

Then update the two fields in the products table to the correct settings ...

Pbh, pph, php.. i can hardly spell to it :no:

So there are no "easy" way to do it then :( ?

Peter:cry:

Just by writting a program for this ...

If you are unable to write one to do this for you ... you may contact me via PM for a customized job to do this ...

I was told by Langer that Easy Populate Advance would solve this and many other issues i have... He said it is only days left until he releases it.... but how many??? 3 or 33 :unsure: