[SOLVED] how to raise prices?

[Martin_S]

I want to change prices for all product in my shop, but I want to raise them, not lower them. How to do that?? Lets say I need 6% price increase and there are over 300 products in the catalog. I have PS 1.2.5.0.

thanks

[Martin_S]

No solution for this?

[rocky]

It is not possible in the Back Office. The only way is to run an SQL query like this:

UPDATE `ps_product` SET `price` = `price` + (`price` * 0.06)

This code will increase the price of all products by 6%. Change ps_ to your database prefix. Remember to back up the ps_product table before executing the query in case anything goes wrong.

[Martin_S]

It is not possible in the Back Office. The only way is to run an SQL query like this:

UPDATE `ps_product` SET `price` = `price` + (`price` * 0.06)

This code will increase the price of all products by 6%. Change ps_ to your database prefix. Remember to back up the ps_product table before executing the query in case anything goes wrong.

Isnt it possible with Sales & Discounts module??

anyway thanks

[rocky]

I don't think any of the modules that come with PrestaShop let you increase all prices at once. I'm not aware of any "Sales & Discounts module". Do you have a link to this module?

[Martin_S]

I don't think any of the modules that come with PrestaShop let you increase all prices at once. I'm not aware of any "Sales & Discounts module". Do you have a link to this module?

I mean this one:
http://www.prestashop.com/forums/viewthread/43988/#195007

there is a way to set discounts for all products.. not sure if I can set a price increase though..

[UKclearancecentre]

Incase you want to change it back to the original values here the code to do that also

UPDATE `ps_product` SET `price` = `price` - (`price` * 0.06) 

[Mikael Bellina]

Hi,

There is this module if you want : http://www.prestastore.com/bulk-update/168-quick-bulk-update-augmentation-prix.html

Best regards Mikaël

[vince123]

thanks for #7

[UKclearancecentre]

I realised my code to change it back after increasing it is not correct as it reduces the final price by 6% so the prices will end up wrong

Eg you increase a product costing 100 original by 6% the new price would be 106

But using the code i gave it would deduct 6% of 106 off the price which would give you an price of 99.37 instead of the 100 you started with.

Im sure there is a way to work this out but my sql skills arent up to the task im afraid.

[Martin_S]

Hi,

There is this module if you want : http://www.prestastore.com/bulk-update/168-quick-bulk-update-augmentation-prix.html

Best regards Mikaël

Does it allow me to restore the original prices as they were before?

Also, if I change the prices will that affect the price of currently placed orders??

[rocky]

My math skills aren't as good as they used to be, but I think this SQL query will undo the percentage increase. Make a backup of your ps_product table, then try running the following query to undo the 6% increase:

UPDATE `ps_product` SET `price` = `price` / 1.06

[Martin_S]

My math skills aren't as good as they used to be, but I think this SQL query will undo the percentage increase. Make a backup of your ps_product table, then try running the following query to undo the 6% increase:

UPDATE `ps_product` SET `price` = `price` / 1.06

yeah, this will work and same for the increase:

UPDATE `ps_product` SET `price` = `price` * 1.06

[Martin_S]

It is not possible in the Back Office. The only way is to run an SQL query like this:

UPDATE `ps_product` SET `price` = `price` + (`price` * 0.06)

This code will increase the price of all products by 6%. Change ps_ to your database prefix. Remember to back up the ps_product table before executing the query in case anything goes wrong.

Can you please tell me if this also changes the product prices in the active orders that were aleady places but not processed yet?

[rocky]

From looking at the database, it would appear that those prices won't change. Once an order is placed, the product prices and order total are hardcoded in the ps_order_detail table instead of read from the ps_product table.

[Martin_S]

From looking at the database, it would appear that those prices won't change. Once an order is placed, the product prices and order total are hardcoded in the ps_order_detail table instead of read from the ps_product table.

Thanks, I will try that.

[Martin_S]

From looking at the database, it would appear that those prices won't change. Once an order is placed, the product prices and order total are hardcoded in the ps_order_detail table instead of read from the ps_product table.

One more question.. If I delete a product that has been ordered by a customer from my catalog, will that product stay in his order so I can process it? According to this reply, it should be so, but I am not sure about the product pictures.


thank you

[rocky]

I haven't tried it, but looking at the ps_order_detail table, it seems the product name, price, quantity discount, EAN13, reference, supplier reference, weight, tax name, tax rate, ecotax, download hash, download number and download deadline become hardcoded with the order. All other product information is linked by ID, so images and other information will be lost when deleting the product.

[SonnyBoyII]

Can I rise prices by reimporting CSV all products with new prices? ( import just product_id, name, price )

[rocky]

Yes, that should work.

[leeburridge]

Thanks - this thread just saved me hours and hours of work

[avantec]

If you have attributes on your products, with different prices, you should also change the prices in `ps_product_attribute`

 

 

UPDATE `ps_product_attribute` SET `price` = `price` + (`price` * 0.06)

[wael_hossam]

Hello

I used this update query and I see the price changed inside the phpMyAdmin and also increased inside the Prestashop SQL Manager in the admin interface.

However strange enough I see the price did not change in the Product catalog and not changed on the front end page.

Is there any explanation for that?