How can I publish Multiple products at once ?

Question

I have about 4000 products in catalog, and want to publish all of them, so they can be sold on the public site, I want to avoid going to each individual product and clicking on Publish button, is there a way to mass publish products?

Lale Stefkova (lsf) · Accepted Answer

Starting with v14, you can now mass publish/upublish products.
Website module> products>view as list>Is published
(make sure the tag for is published is selected)'

michel Guénard · Answer

Export to a csv file (find this option under the More options button), that you will modify on the column published; the reimport the modified csv file.

Abdullah · Answer

Try creating a mass action for it and then check them all in the list view and invoke the method

hamid purhasani · Answer

UPDATE public.product_template
SET is_published = True

Higor Vaz · Answer

I had to unninstall/reinstall Ecommerce/Website apps for this turned bugged after an Odoo update, the layout was not loaded with message:
# Uncaught ReferenceError: odoo is not defined
And others assets loading error.
After that all (> 1500) products went the field Published on Website updated to Unpublished.

Aftab Naveed · Answer

That can be an option, but I was wondering if there would be an option in Product Grid, just like Delete or Export,  thanks for your suggestion, however I figured it out by updating product_template table using a query  Field name is "website_publish"

This question has been flagged

Enjoying the discussion? Don't just read, join in!