Change prices to $0.00

[genesissystem]

Hello Guys

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

[genesissystem]

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

[afo]

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

[genesissystem]

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

[genesissystem]

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

[rajeev83]

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

[genesissystem]

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

[genesissystem]

please anyone can help ?

[afo]

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

[genesissystem]

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