Change product prices on products below $1

[Banshee000]

Hello,


I have products/samples that are listed for about .75 to .96 cents, yet my supplier is selling them for $2.95.

I was told by my inventory management co. that I can set up in zencart admin area all products that are below $1 to $2.95.

How would I do that? I looked in zencart admin catalog - Product price manager, but i couldn't figure it out because it is showing me all of the products. There's no way for me to pull the products that are below $1? Or is there? Does anyone know? Please help!


you could set the lowest price on your site or minimum price in your price setting tool to $2.95 and then all of these products less then a $1 would be $2.95 on your site.

[Ajeh]

Could you try again and explain in a different manner what it is that you are trying to do?

I am not following what you mean by:

I was told by my inventory management co. that I can set up in zencart admin area all products that are below $1 to $2.95.

What is it you want to do with:

There's no way for me to pull the products that are below $1?

And what do you mean by:

you could set the lowest price on your site or minimum price in your price setting tool to $2.95 and then all of these products less then a $1 would be $2.95 on your site.

[farmex]

Ran into exact same problem.
I'll try to explain it. Lets say that there are some amount of products with prices below $1.00($0.50, $0.90, etc.). It there a way to change all of those products' prices to $1.00?

Kinda old topic, but didn't want to create new one.

[gjh42]

There is no admin setting for this. You would have to run a SQL statement on your database to change these prices. You should not do this without expert advice on exactly what SQL to use, and after backing up your db.

[RodG]

Lets say that there are some amount of products with prices below $1.00($0.50, $0.90, etc.). It there a way to change all of those products' prices to $1.00?.

Run this command using a tool such as phpmyadmin

UPDATE `products` SET `products_price`= 1.00 WHERE `products_price` < 1.00;

The usual advice applies. Make a backup of your database/table before running this command.

Cheers
Rod