Global price change?

Hello,

With all of the economic issues recently, the Australian dollars value has been bouncing up and down a fair bit, meaning that I'm having to constantly change the prices of products in my store (I get them overseas, paying in US dollars).

As opposed to manually editing the prices for dozens and dozens of products, is there some module (or SQL query) that I can use to increase/decrease the price of ALL items in the entire store?

Thanks for your help

If the price of all products were the same it would be easy to do via an SQL query, but if you need to increase/decrease all prices by a percentage using an SQL query that's out of my league I'm afraid.

For a straight forward update of a uniform price the SQL query would be:

UPDATE products SET products_price = '9.99';

where 9.99 was the new price.

Maybe someone else here can advise on how to do it using percentage calculations.

Vger

Actually, thinking about it, if you use more than one currency on your store and the Australian Dollar was not the default currency then you could do it by manually updating the exchange rate of the Australian Dollar relative to the Default Currency. That would apply to all products.

If the only currency is the Australian Dollar then I admit I haven't tried to see what would happen to product prices if the default currency was NOT set to 1.00, but to 0.95 or 1.05

Vger

Yeah, thanks anyway mate. A large number of my products are the same price, but a good 50% of the stock varies in price.

You mentioned increases by a percentage - is there a query that would allow an increase by a set dollar amount? e.g. increase all stock by, say $7.50, or something (it's okay if you don't know the query itself I'm just wondering if one exists)

Sorry, only just noticed the second post - appeared while I was replying to the other one.

To answer the question, yep, I use only the Australian dollar. I can see your point though - if the US currency was my default, then editing the exchange rate would be a great way for me to edit the prices. I only ship locally though, which is why AUD is the sole currency.

Nick Alynn:

Sorry, only just noticed the second post - appeared while I was replying to the other one.

To answer the question, yep, I use only the Australian dollar. I can see your point though - if the US currency was my default, then editing the exchange rate would be a great way for me to edit the prices. I only ship locally though, which is why AUD is the sole currency.

Hi,
Does that really matter though?
Couldn't you put the US dollar on the shop admin and make it the one that all other currencies refer to.
Then, when the US dollar goes up or down, the value of the other currencies should change.
If you are taking payments by Paypal or credit cards etc wouldn't they take whatever currency the customer pays in and change it to whatever you use?
This might seem a bit clumsy, but it seems to me if the US currency is causing your price changes, however inadvertently, if you relate your currency to the US dollar it might save you having to change all those prices.
Regards

Elston

http://www.artyfactsforcrafts.com
http://www.welshwiccashop.com

Vger:

Maybe someone else here can advise on how to do it using percentage calculations.

I ended up getting the answer from a mate of mine.

The query that did the job was:

UPDATE `zen_products` SET `products_price`=`products_price`+7.50

And if you wanted to increase the price by a fixed percentage, say 25%, all you needed to do was

UPDATE `zen_products` SET `products_price`=`products_price`*1.25

Couple things on updates to prices in the products table ...

1 be sure to note that zen_products table is really the products table so check your database table prefix before running the command ...

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:

UPDATE products SET products_price= products_price *1.25;

UPDATE products SET products_price= products_price +7.50;

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

Ajeh:

1 be sure to note that zen_products table is really the products table so check your database table prefix before running the command ...

I used Fantastico to install my Z/C, so my tables run under zen_name

I use quick updates (http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=101) to accomplish this... Nice thing for you is the added ability to change by percentage (like to cover currency fluctuations) for all products or just selected products.

~Melanie

I want to increase my prices by $1.50 for my whole cart. How would I do that. Thank you.

Backup your database ...

In the Tools ... Install SQL Patches ... run the command:

UPDATE products SET products_price= products_price +1.50;

Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

Ajeh:

Backup your database ...

In the Tools ... Install SQL Patches ... run the command:

UPDATE products SET products_price= products_price +1.50;

> 
> Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

I want to decrease my prices globally by 10% how would I do that?

John

Backup your database and then you can use:

UPDATE products SET products_price= products_price * .90;

You should then run in the Tools ... Store Manager ... the Update Products Price Sorter ...

i have some different products of mark (casio,seiko,citizen)
How can I change the price all casio items?

thanks all answers.

Are you trying to change all the prices for a specific manufacturers_id to be the same price everywhere?

I'm having a similar nightmare and came across this thread looking for a solution. On the wood building website in my sig almost every price is the result of size attributes, so from what I've read here a global price change isn't going to work for me. On top of that, not **every **product needs a price rise - there are two categories where I don't want to add 5% to every item.
At the moment I think the only option is to go and change every price manually, which with some products having a dozen or more size options is going to take me a couple of **days **to input :censored:. Surely there must be a better way than that?

In your case, because the products are Priced by Attributes it would be easier to write a script to manage this where you can say what Category you want updated and only update the Products in that Category that use the Attribute that you want to update the price on ...

Once written, you can then use that code anytime you need it ...

Ouch.. :blush:
Can you give me just a basic example for a pointer on that?