If your website have much number of products you can not update for all of your products using Update Attribute function of magento.
This article will explain for you how to update the approval attribute of product to approved in bulk from ssh.
First create this file: PATH_TO_MAGENTO_ROOT_FOLDER/shell/process_products.php
<?php require_once '../app/Mage.php'; Mage::app(); $products = Mage::getModel('catalog/product')->getCollection();; $count = 1; foreach($products as $product){ echo "$count/$size - Product ".$product->getSku()." is Updating ...\n"; $product->setData('approval', 2)->getResource()->saveAttribute($product, 'approval'); $count++; }
Now access to SSH and run this command: php PATH_TO_MAGENTO_ROOT_FOLDER/shell/process_products.php
After the script is run you will see the process.