Products price manager - edit multiple products at once?

[wipasnapa]

Hi, could anyone help me with a Products Price Manager question. I have a number of products set up using the PPM for volume discounts. I would like to edit a SUBSET of these products and change the price/discounts.

Is there a way to do that quickly, or do I have to go through and edit each individual product?

Thanks in advance.

[wipasnapa]

Can anyone please help me with this query... I've searched the forums but cannot find the answer.

Hi, could anyone help me with a Products Price Manager question. I have a number of products set up using the PPM for volume discounts. I would like to edit a SUBSET of these products and change the price/discounts.

Is there a way to do that quickly, or do I have to go through and edit each individual product?

Thanks in advance.

[Ajeh]

While nothing is built into Zen Cart for this at this time, you can use an export/import method for this ...

If you export the records for a Product that is already setup, say products_id = 17 ... export the records for products_id 17 from the products_discount_quantity and change the 17 to the next products_id number, example products_id 23, that you want to use ...

Then, edit the products table and set the values for:
products_discount_type
products_discount_type_from

that you see set for products_id 17 and change for your products_id 23 ...

This will let you build these faster ...

You could even write a mini piece of code to manage this for you ...

Have you got your coder's hat on?

[gueston]

While nothing is built into Zen Cart for this at this time, you can use an export/import method for this ...

If you export the records for a Product that is already setup, say products_id = 17 ... export the records for products_id 17 from the products_discount_quantity and change the 17 to the next products_id number, example products_id 23, that you want to use ...

Then, edit the products table and set the values for:
products_discount_type
products_discount_type_from

that you see set for products_id 17 and change for your products_id 23 ...

This will let you build these faster ...

You could even write a mini piece of code to manage this for you ...

Have you got your coder's hat on?

Hello,i have same need .
need my other handbags have same discount as this product: http://www.gueston.com/coach-handbag...bag-001-p-2991

so please let me know how to do it.

Thanks

[jackie.taferner]

Ajeh,

This is useful if you do the quantity pricing by Zen Cart's Product ID number. But I have a list based on my model numbers. How do I know which product is which so I can apply the discounts to the appropriate Model numbers?

Thanks!

[Ajeh]

If you entered the Product Model (products_model) on the Product when adding/editing then you can look up the Product by doing a search for it ...

On the Product Price Manager, there is also a search box, you can enter the model ... then click on the $ for the Product with the correct model number ...

[jackie.taferner]

Ajeh,

I've been hoping to avoid the Price Manager or looking items up by hand; I have hundreds of products, each with different quantity price breaks. A database import solution would be much simpler & faster.

Is there a database lookup that could provide me with a list of all the product IDs and their Model # counterparts?

Thanks!

[Ajeh]

From phpMyAdmin, you could use:

SELECT products_id, products_model from products;

To find an specific Product Model, you could use:

SELECT products_id, products_model from products WHERE products_model = 'some model here';

Or, you could just browse the whole products table to be able to see all of the fields ...

[jackie.taferner]

Ajeh,

SWEET! Just what I was looking for You're a lifesaver.

Thanks!

[Ajeh]

You are most welcome, thanks for the update that this worked for you ...