Magento Schedule Export Google Base products with Cron

Schedule the script bellow every day with cron in your system like
01 00 * * * php -f /srv/www/htdocs/Magento/exportGoogleBase.php

define('SAVE_FEED_LOCATION','/srv/www/htdocs/Magento/var/export/google_base_feed.txt'); //you can set a new folder and file if you want, don't forget to chmod the folder to 777

function cleanString($text) {
	// 1) convert á ô => a o
	$text = preg_replace("/[áàâãªä]/u","a",$text);
	$text = preg_replace("/[ÁÀÂÃÄ]/u","A",$text);
	$text = preg_replace("/[ÍÌÎÏ]/u","I",$text);
	$text = preg_replace("/[íìîï]/u","i",$text);
	$text = preg_replace("/[éèêë]/u","e",$text);
	$text = preg_replace("/[ÉÈÊË]/u","E",$text);
	$text = preg_replace("/[óòôõºö]/u","o",$text);
	$text = preg_replace("/[ÓÒÔÕÖ]/u","O",$text);
	$text = preg_replace("/[úùûü]/u","u",$text);
	$text = preg_replace("/[ÚÙÛÜ]/u","U",$text);
	$text = preg_replace("/[’‘‹›‚]/u","'",$text);
	$text = preg_replace("/[“”«»„]/u",'"',$text);
	$text = str_replace("–","-",$text);
	$text = str_replace(" "," ",$text);
	$text = str_replace("ç","c",$text);
	$text = str_replace("Ç","C",$text);
	$text = str_replace("ñ","n",$text);
	$text = str_replace("Ñ","N",$text);

	//2) Translation CP1252. – => -
	$trans = get_html_translation_table(HTML_ENTITIES);
	$trans[chr(130)] = '‚';    // Single Low-9 Quotation Mark
	$trans[chr(131)] = 'ƒ';    // Latin Small Letter F With Hook
	$trans[chr(132)] = '„';    // Double Low-9 Quotation Mark
	$trans[chr(133)] = '…';    // Horizontal Ellipsis
	$trans[chr(134)] = '†';    // Dagger
	$trans[chr(135)] = '‡';    // Double Dagger
	$trans[chr(136)] = 'ˆ';    // Modifier Letter Circumflex Accent
	$trans[chr(137)] = '‰';    // Per Mille Sign
	$trans[chr(138)] = 'Š';    // Latin Capital Letter S With Caron
	$trans[chr(139)] = '‹';    // Single Left-Pointing Angle Quotation Mark
	$trans[chr(140)] = 'Œ';    // Latin Capital Ligature OE
	$trans[chr(145)] = '‘';    // Left Single Quotation Mark
	$trans[chr(146)] = '’';    // Right Single Quotation Mark
	$trans[chr(147)] = '“';    // Left Double Quotation Mark
	$trans[chr(148)] = '”';    // Right Double Quotation Mark
	$trans[chr(149)] = '•';    // Bullet
	$trans[chr(150)] = '–';    // En Dash
	$trans[chr(151)] = '—';    // Em Dash
	$trans[chr(152)] = '˜';    // Small Tilde
	$trans[chr(153)] = '™';    // Trade Mark Sign
	$trans[chr(154)] = 'š';    // Latin Small Letter S With Caron
	$trans[chr(155)] = '›';    // Single Right-Pointing Angle Quotation Mark
	$trans[chr(156)] = 'œ';    // Latin Small Ligature OE
	$trans[chr(159)] = 'Ÿ';    // Latin Capital Letter Y With Diaeresis
	$trans['euro'] = '€';    // euro currency symbol
	ksort($trans); 

	foreach ($trans as $k => $v) {
		$text = str_replace($v, $k, $text);
	}

	// 3) remove <p>, <br/> ...
	$text = strip_tags($text); 

	// 4) &amp; => & &quot; => '
	$text = html_entity_decode($text);

	// 5) remove Windows-1252 symbols like "TradeMark", "Euro"...
	$text = preg_replace('/[^(\x20-\x7F)]*/','', $text); 

	return ($text);
} 

// make sure we don't time out
set_time_limit(0);

require_once '/srv/www/htdocs/Magento/app/Mage.php';
Mage::app('default');

try{
	$handle = fopen(SAVE_FEED_LOCATION, 'w');

	$heading = array('id','title','description','link','image_link','price','condition','c:product_code');
	$feed_line=implode("\t", $heading)."\r\n";
	fwrite($handle, $feed_line);

	$products = Mage::getModel('catalog/product')->getCollection();
	$products->addAttributeToFilter('status', 1);//enabled
	$products->addAttributeToFilter('visibility', 4);//catalog, search
	$products->addAttributeToSelect('*');
	$prodIds=$products->getAllIds();

	$i = 0;
	foreach($prodIds as $productId) {
		$product = Mage::getModel('catalog/product');
		$product->load($productId);
			$i++;
			$product_data = array();
			$product_data['id']=$product->getId();
			$product_data['title']=$product->getName();
			$product_data['description']=$product->getDescription();
			$product_data['link']=$product->getProductUrl();
			$product_data['image_link']=Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA).'catalog/product'.$product->getImage();
			if($product->getSpecialPrice())
			$product_data['price']=round($product->getSpecialPrice(),2);
			else
			$product_data['price']=round($product->getPrice(),2);
			$product_data['condition']='new';
			$product_data['c:product_code']=$product->getSku();

			//sanitize data
			foreach($product_data as $k=>$val){
				$bad=array('"',"\r\n","\n","\r","\t");
				$good=array(""," "," "," ","");
				$val = str_replace($bad,$good,$val);
				$val = cleanString($val); // convert á ô ... => a o
				$product_data[$k] = $val;
			}

			$feed_line = implode("\t", $product_data)."\r\n";
			fwrite($handle, $feed_line);
			fflush($handle);

			unset($product);
	}
	fclose($handle);
}
catch(Exception $e){
	die($e->getMessage());
}

Then set up your Google Base merchant account like the pic bellow

Tags: cron job, export, google base