Change pricing in price groups

[rufusclc]

Hi -
I have products priced per quantity over a whole range of quantities; ie 50 = $80.00, 100 = $122.00; 200 - $148.00 etc etc etc
but all 172 products have the same pricing.
Is there a way to "bulk" change/increase all the pricing rather than change each products price one by one
EZ-pop does not download this pricing - which would make life very simple. Is there another program that does this?
with many thanx in anticipation
Rufusclc

[kobra]

I suspect that you are using the quantity discount feature????

[rufusclc]

Hi
thanx for your response
answer is yes
Rufus

[kobra]

Is the quantity discount setup/entered for all products and you are wanting to alter the pricing?

Or are you wanting to add the qty pricing to them all?

[rufusclc]

Using it only for this group of products not all the products on our site
Rufus

[kobra]

Using it only for this group of products not all the products on our site

OK, but are qty discounts already added to all products in this group?

[rufusclc]

Yes
thanx for yr patience
Rufus

[kobra]

OK,

If you have added the same qty discount to all of these products and these are the ONLY qty discounts in your cart...

DO NOT USE THIS if you have other items with qty discounts

First place shop down for maint then using phpmyadmin, make a proper backup
https://www.zen-cart.com/tutorials/i...hp?article=103

Then to check, use phpmyadmin and export only the products_discount_quantity table not compressed

Open this exported table in an editor and assuming that you have actually added them all identically, you will see something like this - -
Where the red highlighted value is discount_qty

(1, 8, 3, '10.0000'),

Now the number/levels of discounts for example if you have "5" levels you will need to run this sql 5 times adjusting for the discount_qty values you have and the desired price where highlighted

UPDATE products_discount_quantity SET discount_price = 10.0000 WHERE discount_qty = value;

It should look like this where the discount qty is 3 and the desired price is 10.0000

UPDATE products_discount_quantity SET discount_price = 10.0000 WHERE discount_qty = 3;

I suggest you run one and view the result before continuing

If all goes bad you have a backup

[rufusclc]

Great thanx a whole bunch
Rufus