Products price manager - edit multiple products at once?

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.

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

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.

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? :smartalec:

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? :smartalec:

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

so please let me know how to do it.

Thanks

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!

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

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!

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

Ajeh,

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

Thanks!

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

Ajeh,

OK so I've added all of the products and uploaded in to the database... BUT none of the discount quantity tables are showing on the products pages.

I think it has something to do with the "Discount Type" dropdown in the price manager. For products where I have manually selected "Actual Price", these are showing up. But the ones I uploaded into the database have the default "None" selected.

Do you have another magic SQL line that will turn "Actual Price" on for the newly added products?

Thanks again!!