[SOLVED] Increase all prices by 15%

[Seremela]

Hiya,

 

Was wondering if someone knew how to increase the prices for every single product in 1.5? I can't seem to find an option for it and i don't want to go over thousands of products hehe

 

I would guess it's possible with SQL but not sure how to do that.

 

Any help is appreciated.

 

thanks

[phrasespot]

Take a DB backup and make sure you can restore your DB from that backup.

Deal with PREFIX_product table changing PREFIX to whatever prefix your DB is using:

 

UPDATE `PREFIX_product` SET `price`=`price` * 1.15

 

Deal with PREFIX_product_shop table

 

UPDATE `PREFIX_product_shop` SET `price`=`price` * 1.15

 

This does not take int account product attribute prices, unit price ratios, specific prices you may have for any products etc. E.g. you may need to update PREFIX_attribute table. Exact modifications will depend on your shop setup. Seek professional help if in doubt.

 

Edit: True. Salver, thanks. Corrected.

Edited September 24, 2012 by phrasespot (see edit history)

[EK-Si POS]

For attribute table, increase 15%:

 

UPDATE `ps_product_attribute` SET `price`=`price`*1.15

 

(I tried [ sql ] bbcode )

Edited September 24, 2012 by salvar (see edit history)

[Seremela]

Thanks guys works perfectly

[benjamin utterback]

Thank you for the solution phrasespot and salvar. I will mark this thread as SOLVED. Thank you for the community support!

[phrasespot]

@Benjamin

 

But why my previous post is deleted? Kosbik is obviously an advertising shill since all posts are identical in every thread posted so far; advertising a premium module. Forum rules clearly states that no advertising of premium modules in any forum other than paid modules forum.

 

In order to keep the forums clean with a good atmosphere, advertising is now permitted only in [paid modules forum]. .... Users who only post on the forums to solicit business will be banned

 

Kosbik clearly fits into this category, i.e. posts on the forums only to solicit business. If you disagree state the reason instead of deleting a factual post.

[benjamin utterback]

Hello phrasespot, I have not deleted any post from you, nor can I see any post deleted. I did notice the Kosbik post, there is some debate over these type of posts. Although it is relevant to the post, based on the content of Kosbik's previous posts, it is obvious that he is only here to advertise. I certainly agree with you. After some discussion, we have decided to remove it from view, and issue a warning.

[phrasespot]

Hello phrasespot, I have not deleted any post from you, nor can I see any post deleted.

 

OK, since it was deleted shortly before you replied to this thread I assumed it was you. Sorry for jumping to wrong conclusion. However it was deleted, obviously, by someone else who did not like what I said. His/her motives should be scrutinized.

 

I did notice the Kosbik post, there is some debate over these type of posts. Although it is relevant to the post, ...

 

I am not sure what is to debate. If a module, free or paid, is solving an otherwise unsolvable problem, by all means suggest it as a solution; some problems only have solutions in the form of modules. Or if the question is 'is there a module that will do X' fine again.

However, in this case the answer sought is given. The problem of the OP is solved and stated as such by the OP. End of the thread. Even then suggesting an alternative free solution may be relevant but if you are posting to say, 'Hey I used this module ..." veiled as feedback from a genuine module user, then it is misleading, advertising and has no place. Otherwise forum rules are a mockery.

 

based on the content of Kosbik's previous posts, it is obvious that he is only here to advertise.

No doubt.

 

After some discussion, we have decided to remove it from view, and issue a warning.

Good riddance. There are a number of module names that keep popping up in such manner, mentioned in handful posts of a newly registered user before that user disappears and a replacement appears. Forums are a better place without such shady practices.

[benjamin utterback]

Update: The member was banned. We will work together to get rid of these members who only come to advertise or send external link traffic. thanks phrasespot.

[Razu]

Simply Run Sql query

 

UPDATE `ps_product` SET `price`=`price`* 1.15

 

And it's done

[Amparfum]

Thank you guys, this works nicely. 

Could you please tell me how to decrease the price with this?

Lets say I increased the price * 1.10

Now I want to decrease it to the amount before increase. 

 

Do I do it the same, just instead of * 1.10 I write / 1.10 ?

I know, that I can decrease prices in BO, but there is percentage decrease - If a price was 10$, then after increase 11$, so if I make -10% it wouldn't be 10$ again.