Jump to content

SQL mass update prices - solved


Recommended Posts

Hi. Are you able to help me with SQL query?

In table ps_product_shop, I have on row1 id_shop = 1 and ond row2 id_shop=2

I need to update my prices for the different shops.

Take "price" from id_shop=1, divide it 25.5 (CZK / EUR) and set it to price for id_shop=2

I was several years before Oracle db administrator, but I am out of ths bussiness now... :)

Thank you. Komanche

Edited by Golemtech
solved (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...