Adding Magento products to Google Base

32 Comments 13th JAN 2010 | Posted by Toni Anicic in Magento

Adding Magento products to Google Base

Magento made adding products to Google Base (Google Product Search) a pretty simple process that can be done using Magento’s admin interface. This guide will tell you how to do it and how to fix known issues.

First of all, I wanna show you this really nice screencast I found on Vimeo that guides you through the process of adding your Magento products to Google Base, however you will probably have some issues after you follow the screencast since it doesn’t really tell you everything there is to know.

Step by step guide to importing Magento products into Google Base:

Step 1: Create a Google Base (merchant) account. This is the first thing you need to do since you’ll need to enter account access data in the next step.

Step 2: Log-In to your Magento admin panel and go to System > Configuration > Google API > Google Base and enter your Google Base account data, Save Config.

Step 3: Go to Catalog > Google Base > Manage Attributes and synchronize the applicable Magento’s attributes with Google Base attributes.

Step 4: Go to Catalog > Google Base > Manage Items. View Available Products button will show you items in your store that can be added to the Google Base.

That’s it, pretty simple, right?

Known issues:

Expected response code 200, got 400. Type: data. Field: condition. Reason: The item is missing a required attribute.

Google Base requires an attribute that describes the item’s condition. This is the solution for this problem:

Step 1: Go to Catalog > Attributes > Manage Attributes. Create a new attribute called “Condition” with dropdown values “New” and “Used” available.

Step 2: Go to Catalog > Attributes > Manage Attribute Sets and drag the attribute “Condition” from the right column to the appropriate place in the left column. Make sure you have dragged it into the attribute set you’re using with Google Base if you have more then one attribute set defined.

Step 3: Go to Catalog > Google Base > Manage Attributes and synchronize Magento’s “Condition” attribute with Google Base’s “condition” attribute.

Step 4: Edit products you wish to include in Google Base and give them appropriate Condition attribute value (New or Used).

Expected response code 200, got 400. Type: data. Field: description. Reason: There is a problem with the character encoding of this attribute.

This error is shown when you have characters in your product description that are not supported by Google Base. This (or similar) error is also shown when you’re using code in your product description.

Removing the code or some strange characters from your product’s description should fix this problem.

A similar error will also appear if you left your description blank. You will need to add some description to every product you wish to add to the Google Base to fix the issue.

Unable to read response, or response is empty

We’re still trying to find a solution for this one. It might be a problem on Google base’s side.

Resubmitting products to Google base

Products in Google base expire in 30 days. In order to resubmit your products to Google base, you’ll need to synchronize the products from Magento’s Google base interface so that Magento would know that products are no longer available at Google base (expired).

Then you can submit your products once again by following simple steps described at the beginning of this article.

If you like what you read, please share it.

  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Yahoo! Bookmarks
  • Reddit
  • Technorati
  • Twitter
  • StumbleUpon
  • LinkedIn
  • Netvibes
  • FriendFeed
  • NewsVine
  • Sphinn
  • Tumblr

There are 32 comments (Add Yours +)

  • Have you figured out how to set Magento’s Google Base integration so that it doesn’t expire every month? That’s my biggest pet peeve with the way it’s setup. It’s extremely time consuming to go through and re-add everything every month. On one of our sites I have a custom script setup to process the items to Google Base, but I have to remember to activate it every so often to update my listings so that’s not ideal either.

  • Toni Anicic Says

    @Sherrie Rohde

    I’ll have to think about that one. I’ll probably post an update to this post if we find a good solution.

  • Neil Bradley Says

    I haven’t been able to find this out either way, but if you are using Configurable Products – do you have to submit the Configurable and Simple Products or just the Configurable Products?

    At the moment I am just submitting all products as it is difficult to quickly submit just the Configurable Products.

  • @Sherrie Rohde, @Toni Anicic
    Would it be possible to setup a cron job to manage automatic updates of Google Base?

  • I don’t think it sends a price when you submit Grouped or Configurable products. Have you successfully used this for Grouped/Config items?

  • Toni Anicic Says

    @eCommerceCircle – I didn’t have chance to use it with Grouped/Config items so I can’t tell but I guess there would be some issues.

    @Robert Reynolds – I’m not sure if the time period (30 days) would be restarted if we simply rebuilt products without changing anything while having the “Update Google Base item when product is updated” dropdown set to “Yes” in System > Configuration > Google API > Google Base

    If it does, it would be a pretty nice solution.

  • I con’t get it to work! Why it’s so complicated?

  • In Step 2 of the first error, I don’t see anything to “drag”. How do I do this? I am using Magento version 1.3.2.4. Thanks.

  • I followed all of the steps for the first known issue but continue to receive the error when I try to add my products in Google Base > Manage Items. What could I be doing wrong? To start, I have only added condition and price as attributes. Do I have to add more?

  • Toni Anicic Says

    David,

    Could you copy the text error gives you so we can see what is wrong?

  • Expected response code 200, got 400. Type: data. Field: condition. Reason: The item is missing a required attribute.

  • Toni Anicic Says

    David, make sure:

    1. You created the attribute “Condition”
    2. You made it’s value “New” or “Used”
    3. You assigned the value (New or Used) to the items you’re trying to add
    4. You mapped the condition attribute to the condition attribute in Google Base

  • Toni Anicic Says

    @David,

    I’ve seen your e-mail, you probably missed this step:

    “Step 2: Go to Catalog > Attributes > Manage Attribute Sets and drag the attribute “Condition” from the right column to the appropriate place in the left column. Make sure you have dragged it into the attribute set you’re using with Google Base if you have more then one attribute set defined.”

  • The connection to google shopping works fine. Now the first products have run out of the period.

    I wonder how to restart the export process to google again. Until I do not delete the products completely from the google merchant center the products are not available in the magento backend for a new export.

    WHY? And what is the easiest and fastest process to restart products that do not have any changes in their conditions?

    Thanks for all your help

    informixx

  • Great!

    I just followed your guide and did a test product and finally managed to get it up on GoogleBase!

    Is there a way of making the default option “YES” as it doesn’t seem to do that in my store?

  • Toni Anicic Says

    @Scalesmart:

    i think we did it this way: Set the field as required, and the default value to New. Then go and rebuild the catalog.

  • Hi Toni

    I tried that to no avail. For some reason i have to go in and set each product up as the default is blank, Neither Used or New is selected.

  • Everything seems to be fine except that when I go to “3. You assigned the value (New or Used) to the items you’re trying to add” I do not see a field for Condition in the products I am trying to add. Do I have to add a new attribute again for each product? Is there a way to add new as the default for my entire store?

  • Toni Anicic Says

    @David,

    You most likely don’t see it because you skipped the Step 2:

    Step 2: Go to Catalog > Attributes > Manage Attribute Sets and drag the attribute “Condition” from the right column to the appropriate place in the left column. Make sure you have dragged it into the attribute set you’re using with Google Base if you have more then one attribute set defined.

  • I have already set this to the attribute set I would like to sync with Google Base/Merchant Center.

  • Toni Anicic Says

    Are you sure your products are using that attribute set? Because if they are, there is no reason why the new condition value wouldn’t appear in these products.

  • Where can I check this?

  • Toni Anicic Says

    @David:

    If you go to Catalog > Manage Products, you will see a row that defines which attribute set is each of the products using.

    It is most likely your products are using default attribute set. If so, make sure you’ve dragged the condition attribute into the default attribute set.

  • Thank you all for your help.

  • Paulius Nosokas Says

    Lovely Video quality from Magento you can’t even see anything.

  • Finally, the attribute appears. Now, is there a way to add the condition-new to all of my products in my shopping cart? I want to add 900 items to Google Base.

  • Toni Anicic Says

    @David: Try setting the field as required and default value to “New” and then go and rebuild the catalog.

  • How do you rebuild the catalog after editing the attribute?

  • Have you figured out a way to get the special price to map to the price attribute when submitting to Google Base? I’ve tried mapping ‘Special Price’ and ‘Minimal Price’ to ‘Price’ however none of those work.

  • Toni Anicic Says

    @David: Try system > Cash management > Rebuild Catalog Index

    @Kris: Didn’t try it, don’t know.

  • I set the field as required and default value to “New” but all products still do not show as New. Does it make a difference if this setting is Global, website, etc?

  • Toni Anicic Says

    @David, I’m not sure, but I think that’s the way we did it.

    The other way around would be to find where the condition attribute is in the database and make an SQL query that will set all product values to New.

Leave a Comment

Magento Design and Development | Magento SEO | iPhone Application Development Web Application Development with ZEND | WordPress Ecommerce | WordPress development
Sitemap

Inchoo - webappsolutions | 2009