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