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

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

Thread Tools

Search Thread

Display

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

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

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

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

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

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

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

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

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

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

Similar Threads

how do i change the qty box to add to this cart button?

Editing All product QTY Discount Box at once

How do I add 'Units available' to the qty number on the products listing page?

How to change text in Qty. Discount Box?

How to keep the Qty Discount box from appearing?

Posting Permissions