Comments on: How to Bulk Enable Products when Google Checkout is Disabled in Magento

By: Christian

Christian — Sat, 11 Feb 2012 18:05:56 +0000

opps, i left our table name in there. you need to replace itmanx_magento with your own table name or remove it all together (including the dot)

By: Christian

Christian — Sat, 11 Feb 2012 18:03:19 +0000

Direct SQL

UPDATE catalog_product_entity_int SET `value`=1 WHERE attribute_id=(SELECT attribute_id FROM eav_attribute WHERE attribute_code LIKE ‘enable_googlecheckout’); #114

SELECT * FROM `itmanx_magento`.`catalog_product_entity_int`
LEFT JOIN eav_attribute USING (attribute_id)
WHERE attribute_code LIKE ‘enable_googlecheckout’

By: Moiz Ahmed

Moiz Ahmed — Mon, 11 Jul 2011 08:41:00 +0000

Can you please update the script for 1.4.1 ?
Thanks!

By: Mike

Mike — Sat, 23 Apr 2011 13:15:42 +0000

Hi, Big thanks, BIG

Can we set the var to tax to enable all to one tax class or disable or enable for all products ?

By: Eric Rodgers

Eric Rodgers — Mon, 24 Jan 2011 20:13:09 +0000

Does anyone know how to do this with magento 1.4? I tried using johns script, but the browser just kept processing and never ended up doing anything.

By: Ashley

Ashley — Fri, 26 Mar 2010 05:49:37 +0000

That is odd… what version of Magento are you on?

By: Brian Fritton

Brian Fritton — Fri, 26 Mar 2010 05:30:43 +0000

This is odd: I’m getting an Abstract error.

Warning: Invalid argument supplied for foreach() in /app/code/core/Mage/Eav/Model/Entity/Abstract.php on line 970

By: John Kinsella

John Kinsella — Thu, 28 Jan 2010 07:46:51 +0000

Guys – thanks for the help on this one…just updated a client from 1.1.8 to 1.3.2.4 and suddenly saw all the Google checkout buttons greyed. :/

Anyways, had to tweak Ashley’s script slightly, what worked follows:

set_time_limit(0);
require_once ‘app/Mage.php’;
Mage::app(‘default’);

try{
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
$products = Mage::getModel(‘catalog/product’)->getCollection();
$prodIds=$products->getAllIds();

$product = Mage::getModel(‘catalog/product’);
$count = 0;

foreach($prodIds as $productId) {
$product->load($productId);
$product->setEnableGooglecheckout(true);
$product->save();
$count++;
}
echo “Update complete. “. $count.” records saved.”;
}
catch(Exception $e){
die($e->getMessage());
}

By: Matt

Matt — Mon, 22 Jun 2009 03:14:09 +0000

I found I had to change the script to this for it to work with the most recent version of magento (1.3.2.1)

setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$products = Mage::getModel(‘catalog/product’)->getCollection();
$prodIds=$products->getAllIds();

$product = Mage::getModel(‘catalog/product’);

$count = 0;
foreach($prodIds as $productId) {

$product->load($productId);
$product->setEnableGooglecheckout(true);
$product->save();
$count++;
}
echo “Update complete. “. $count.” records saved.”;
?>