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