Geek Answers Handbook

Mass update of the "status" of a simple product via MySQL query

I only imported over 12 thousand products into my Magento catalog.

The problem is that the products came with the Status field undefined, and I need them to be displayed in Enabled manually if I want to use them in the front store. This will take several hours manually.

Do you know where this parameter is defined in the database? Did you know that the request will be automatic (I want ALL products to be included "Enabled").

+5
source share
2 answers
# First find the ID of the product status attribute in the EAV table:
SELECT * FROM eav_attribute where entity_type_id = 4 AND attribute_code = 'status'

# Then use that status attribute ID ($id) while querying the product entity table:
UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = $id
  • 1 - enabled
  • 2 - disabled
+16
source 

UPDATE Catalog SET Status='Enabled'

, , .

ALTER TABLE `Catalog` CHANGE `Status` `Status` ENUM('','Enabled','Disabled') NOT NULL DEFAULT 'Enabled'
-7

More articles:


All Articles