AyaSoftware

Magento Google Base Feed Account Configuration:
Step 0: First of all , you have to create a Google Merchant Account.

Step 1: Go to System->Configuration->Google API-> Google Base and enter your info as follow:

Select Yes if you want to Update Google Base Item when Product is Updated.

Step 2: Now go to Catalog->Google Base->Manage Attributes and enter your details as follow:

You don't have to create the mapping, Magento will send all required fields to Google Base.

Step 3: To finish, Go to Catalog->Google Base->Manage Items

Click on the button View available products , apply your filter if you want to select only configurable products. Select your items, open the actions drop down menu, select add to Google Base and then click on submit.

- Done.

What to do If you get these errors:

“Expected response code 200, got 400. Type: data. Field: item. Reason: Please verify and claim your website’s URL, until you do so you cannot upload any product listings

Solution:

Check in Google Base Settings -> General

Website URL : should be http://www.ayasoftware.com without (/ at the end)

Error: Your item list is missing product type values. Please submit product type values for all items.
Create a new attribute called product_type with the following properties:

Scope: Global
Catalog Input Type for Store Owner: Text Field

and add it to your attribute set(s).

run this php file:

<?php

require_once 'app/Mage.php';
umask ( 0 );

ini_set ( "display_errors", 1 );
$currentStore = Mage::app ()->getStore ()->getId ();
Mage::app ()->setCurrentStore ( Mage_Core_Model_App::ADMIN_STORE_ID );

$products = Mage::getModel ( 'catalog/product' )->getCollection ();
//$products->addAttributeToFilter('status', false);//enabled
//$products->addAttributeToFilter('visibility', 4);//catalog, search
$products->addAttributeToFilter ( 'type_id', array ('eq' => 'configurable' ) );

//$products->addAttributeToFilter ( 'sku', array ('eq' => array ('RH10' ) ) );
$products->addAttributeToSelect ( '*' );
$prodIds = $products->getAllIds ();


foreach ( $prodIds as $productId ) {
	$category_label = "";
	$product = Mage::getModel ( 'catalog/product' );
	$product->load ( $productId );
	
	//get the product categories
	foreach ( $product->getCategoryIds () as $_categoryId ) {
		$category = Mage::getModel ( 'catalog/category' )->load ( $_categoryId );
		$category_label .= $category->getName ();
	}
	$productType = "Clothing & Accessories > Clothing > " . $category_label; // just an example
	$product->setProductType ( $productType );
	
	try {
		$product->save ();
	} catch ( Exception $ex ) {
		echo $ex . getMessage ();
	}

}
Mage::app ()->setCurrentStore ( $currentStore );
?>

Tired of getting your products listed on Google Base? try our script.
Features:

• Automated feed submissions using FTP and cron jobs
• Send products to Google Base directly from your browser www.xxxx.com/google.php