Jump to content

Sql Query To Move Products To A Different Category By Product Name


Amparfum

Recommended Posts

Hi,

 

So I have this problem. For example, let's say I am trying to move products which have 'Giorgio Armani' in their title. 

I need a SQL query to work with the query below select only the products with this name and move them to additional category. I tried SELECT `pl.name` = 'Giorgio Armani' and so on, but it didn't work.

 

Also, I need to add products to another category, but also keep them in the same one, would this code work?

UPDATE `am_category_product` SET `id_category` = 57, 78 WHERE `id_category` = 57

Thank you very much for your help and time.

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