Enabling all products magento 2

[allen_groff]

Is there a command line string and or easy way to enable all products at once on magento 2? After import, all my products are disabled.

[Vimal Kumar]

Hi @allen_groff,

You can enable all products from product grid in admin.

Admin> catalog> products>
Select all from left checkboxes from top.
Then change Action dropdown> change status> enable.

I hope it will help you

[Manish Mittal]

Hello @allen_groff 

You can enable products from admin grid Mass action(select all) and change status As @Vimal Kumar shared in his post but if you still can not see products in front, might be products are out of stocks so run below mysql query:

UPDATE cataloginventory_stock_item c SET c.qty = 100 WHERE 1=1
UPDATE cataloginventory_stock_item c SET c.is_in_stock = 1 WHERE 1=1

After this just run Magento command:

php -dmemory_limit=-1 bin/magento indexer:reindex

[allen_groff]

I don't have the drop down option to select all. Not seeing it in the columns drop down options either. 

[Manish Mittal]

Which magento version are you using? You can try with database if it

[allen_groff]

Magento ver. 2.3.1

[Manish Mittal]

Hello @allen_groff 

See here for your reference:

[allen_groff]

Yes, I have that. But no select all option. When clicking that, it requires boxes to be selected. But I don't want to do 200 at a time singularly

[Manish Mittal]

Hello @allen_groff 

Run below query in database:

UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = (
    SELECT attribute_id FROM `eav_attribute` e WHERE e.`attribute_code` = 'status' AND e.frontend_label = "Enable Product"
)

[dekimi27698fae]

---

@Vimal Kumar wrote:

Hi @allen_groff,

You can enable all products from product grid in admin.

Admin> catalog> products>
Select all from left checkboxes from top.
Then change Action dropdown> change status> enable.

I hope it will help you

---

when i changing product status but issues occuring like below...

Something went wrong while updating the product(s) status.