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

**PeterBKK** · 13 Jul 2006, 02:05 PM

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

**Ajeh** · 13 Jul 2006, 02:10 PM

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 ...

**PeterBKK** · 13 Jul 2006, 07:30 PM

eehe...Thanks... But were??? In MySQL or...

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....

**Ajeh** · 13 Jul 2006, 07:47 PM

These are fields in the products table ...

In your case, the zen_products table ...

**PeterBKK** · 13 Jul 2006, 08:14 PM

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

**PeterBKK** · 13 Jul 2006, 09:25 PM

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

**PeterBKK** · 14 Jul 2006, 01:28 PM

Originally Posted by 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

**Ajeh** · 14 Jul 2006, 02:06 PM

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 ...

**PeterBKK** · 14 Jul 2006, 02:33 PM

Originally Posted by 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

So there are no "easy" way to do it then

?

Peter

**Ajeh** · 16 Jul 2006, 05:17 AM

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 ...