Change prices to $0.00

Hello Guys

I need to Change prices to $0.00 using my sql
can you help me with mysql syntax ?
thanks

please help...............!

Why would you want to change all the prices to zero?

the customer just want to be able to accept order and process internally
the only way I see you can add product to shopping cart if I put $0.00

thanks for you help

please help...............!

Hi
i do not take any responsibility but try this on your dummy database
UPDATE products SET products_price = products_price * 0.00;

Thanks but dont work......................please anyone can help ?

please anyone can help ?

I'm not sure I would buy from a store when I didn't know how much the item was going to cost me. Take a look at this payment module add on http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_48&products_id=99

It might do the trick for you. I haven't used it, but search the forum for more info on it and comments from users.

AFO thanks very nice ADDONS but dont work with my proyect

my customer dont want to show price, but also want to receved order, so I was thinking to put everything in $0.00

please anyone can help ?

I found my own answer.......

to change price to all products do this
UPDATE products SET products_price = '0.00';

to increase 25% to all products do this
UPDATE products SET products_price= products_price *1.25;

to add $7.50 to all products do this
UPDATE products SET products_price= products_price +7.50;

The better place to run this would be in the Tools ... Install SQL Patches ... and do so without the prefix as this will adjust the UPDATE correctly for your prefixes if you run those as, note semi-colon on the end or each line:

after changing prices, you should run from the Tools ... Store Manager ... the Update Price Sorter ...

Caution: if you use specials, these specials are not adjusted so be sure to consider the results of price changes ...

WARNING: Before doing any changes like this a Backup is always a good idea ...

this post help me a lot.............thanks to Ajeh Oba-san

http://www.zen-cart.com/forum/showthread.php?t=110093&highlight=change+price

You are most welcome and thanks for detailing things again on how to do this correctly with the cautions on what to look for as well as the updates on the store manager ... :smile: