[solved] quick way to set status

[lisz55]

is there a quick way to change multiple product status to avaliable?

Edited August 23, 2013 by lisz55 (see edit history)

[kristianmu]

The quickest way is through database,

 

Update ps_product set state=1 where XXX

[lisz55]

Update ps_product set state=1 where XXX

this comend doesn't work, I assume that I have to insert somthing instead of xxx? And you are certain that state is correct name as far as I can see there are no record named state, but I'm no expert in sql

[kristianmu]

Sorry I assume that you have SQL knoledge, and the fiels is acvtive... I posted too fast... Sorry.

 

 

If you want to update all products:

update ps_product set active = 1

 

If you want only some id's:

update ps_product set active = 1 where id_product in (1,2,3,....) 

 

If you whant only products form one category (products of a default category):

update ps_product set active = 1 where id_category_default = idnumber of the category

 

And finally if you want producs form any category:

update ps_product set active = 1 where id_product in (Select distinct(id_product) from ps_category_product where id_category = number of the category)

 

 

Hope it helps!

[nadie]

Sorry I assume that you have SQL knoledge, and the fiels is acvtive... I posted too fast... Sorry.

 

 

If you want to update all products:

update ps_product set active = 1

 

If you want only some id's:

update ps_product set active = 1 where id_product in (1,2,3,....)

 

If you whant only products form one category (products of a default category):

update ps_product set active = 1 where id_category_default = idnumber of the category

 

And finally if you want producs form any category:

update ps_product set active = 1 where id_product in (Select distinct(id_product) from ps_category_product where id_category = number of the category)

 

 

Hope it helps!

 

Hi,

 

Prestashop 1.5

 

ps_product and ps_product_shop

 

Sorry for my English.

[kristianmu]

Victor don't be shy to writing english! haha!

[lisz55]

Ok thanks, I've change it in ps_product and ps_product_shop and it works.

[nadie]

Ok thanks, I've change it in ps_product and ps_product_shop and it works.

 

Perfect !

 

Please, add the word "solved" in the title of the topic.

 

Sorry for my English.

[lisz55]

done, I have a question is it possible to change this:

update ps_product set active = 1

that it changed status for all products exept products that have id 4, 5, 24, 134?

[kristianmu]

done, I have a question is it possible to change this:

update ps_product set active = 1

that it changed status for all products exept products that have id 4, 5, 24, 134?

Try with: 

update ps_product set active = 1 where id_product not in (4, 5, 24, 134)

 

But if there are 4 products only  it's faster to do it manially 

 

P.S: Sorry for the delay.