Ideas are for sharing

How To Successfully Set Up Magento Google Base Feed

Step 1: Magento Google Base Feed Account Configuration

Firstly, the Google Merchant Centre account has to be linked to the Magento store.

  1. In Magento, go to System >> Configuration >> Google API >> Google Base.
  2. Enter details of the account you wish to use to publish your products feed on. Select the default target country of your feed and select Yes in ‘Update Google Base Item when Product is updated’.

Step 2: Adding Required ‘condition’ Attribute To Magento

  1. Go to Catalogue >> Attributes >> Manage Attributes and click Add New Attribute.
  2. Populate all fields with following values:
  3. Then click on Manage Label / Options in top left.
  4. Type ‘condition’ in Admin and ‘Condition’ in all store views.
  5. Then click Add Option, type ‘new’ in all fields and add position ‘1’ and select ‘Is Default’.
  6. Click on Add Option again and type ‘used’ in all fields and add position ‘2’.
  7. Confirm by clicking Save Attribute.
  8. Go to Catalogue >> Manage Attribute Sets and select the attribute set you want to add the new ‘condition’ attribute to.
  9. Find the ‘condition’ attribute in the Unassigned Attributes section, drag & drop it to ‘General’ in the Groups section.
  10. Confirm by clicking Save Attribute Set.
  11. In order to populate the new ‘condition’ attribute, go to Catalogue >> Manage Products, select products you want to update, select Update attributes from the Actions drop down and confirm by clicking SUBMIT.
  12. On the next screen, find Condition, change it to new and confirm Save.

There’s also a video guide for setting this up available at: http://www.youtube.com/watch?v=t_M3knNCB20

Step 3: Magento Google Base Feed Attribute Mapping Configuration

The list of required and recommended attributes for products can be found here:

First we need to map Magento product attributes to required/optional Google Merchant Centre attributes. To do that go to Catalogue >> Google Base >> Manage Attributes and click on Add Attribute Mapping.

  1. Select Target Country, Attribute Set and Item Type (usually Products) for your feed and click on Add New Attribute.
  2. Add as many Google Base attributes as you want and map them across to Magento product URLs on the left, e.g. Magento ‘SKU’ to Google Base ‘id’.
  3. PLEASE NOTE THAT MAGENTO MAY POPULATE SOME OF REQUIRED GOOGLE BASE ATTRIBUTES WITH “DEAFAULT/BUILT-IN” MAPPING ATTRIBUTES, meaning you may not need to map all required attributes as Magento will automatically assign them a correct value, e.g. ‘description’ gets assigned values of product description, ‘image_url’ gets assigned a value of image URL automatically, etc.
  4. Finish by pressing Save Mapping.

Step 4: Publishing Magento Google Base Feed

This is where we finally send products to Google Base / Google Merchant Centre.

  1. Go to Catalogue >> Google Base >> Manage Items and choose the Store View you want to publish products from.
  2. Click on View Available Products
  3. Select all products you want to publish
  4. Select Add To Google Base from the Actions drop down menu
  5. Confirm by clicking Submit
  6. You may be asked to fill in the captcha authentication.

If everything goes well you’ll see the notification that your products were successfully added to Google Base.

Magento Google Base Feed Errors & Troubleshooting

If you encounter the ‘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’ error you will need to log in to Google Base account directly and verify account ownership.

If you encounter the ‘Expected response code 200, got 400, Field Type: Duplicate Description’ error then your attribute mapping is wrong. Try editing the mapping or deleting mapping which causes the problem. It may be the case that you tried to map attributes which Magento maps automatically therefore you don’t need to do it.

The official ‘Google Base Integration in Magento’ video can be found here: http://www.magentocommerce.com/blog/comments/video-google-base-integration-in-magento/

You can read more about Pod1’s SEO Services London and general ecommerce web design offered by Pod1.

If you still haven’t got enough of this Magento SEO frenzy then take a look my new post about Magento SEO Tips – Website Launch Checklist -The ultimate list of SEO checks & SEO tips for Magento website launch.

Step 1: Magento Google Base Feed Account Configuration Firstly, the Google Merchant Centre account has to be linked to the Magento store. In Magento, go to System >> Configuration >> Google API >> Google Base. Enter details of the account you wish to use to publish your products feed on. Select the default target country [...]

Share this article:

48 Comments

  1. Hi,

    Maybe you could explain why you would use Google Base too?

    Regards,

    Dennis

  2. Dennis – otherwise known as Google Shopping.

  3. Thank you very, very much. This was one of the clearest and most useful Magento tutorials I have encountered after 2 months of wrestling to get my store working with Magento. It’s a bear! And just to help the next person… the only two attributes I needed to map were SKU > id and condition > condition. Magento automatically mapped the rest.

  4. @Chris
    Thanks for your kind words and your tips about 2 required attributes.

    Although it looks like Varien didn’t put developing this Magento module on top of their priority list, it can still work pretty well… with a bit of luck and know-how :)

    What I’d be keen to see in future versions of this module is the ability to specify the pattern for Base attributes generation, e.g. assign to the Base title the value of combined Magento attributes/variables, e.g. ‘%productName% %colour% %category% %size% – %soreName%’. It’s not easy to do that without hacking the core and compromising the PCI compliance so would be nice if Varien just did that.

  5. When a product is clicked using google base, it has the following appended to the end of the URL: ?___store=default

    Original URL: http://www.example.com/fake-product.html
    Google Base redirect URL: http://www.example.com/fake-product.html?___store=default

    It is my thought that “?___store=default” is a redundant URL and as such is considered duplicate content by google, resulting in a lower ranking.

    Is there a way to have “?___store=default” removed from the end of the “.html” when redirected to the store from google base?

  6. Great article. Thanks. Do you have or know where we can find a list of the attributes that Magento populates by default? I’ve been struggling to get this working for a while. Every time I think I have if fixed, I get a different error in my data feed.

  7. Hi,
    Thanks for the tutorial. It is very clear and helpful.
    I am setting up a Magento store in India and google base allows me to set up India as the target country.

    However in the Magento setup, the only choices are US, Germany and UK as the options. The problem with this is that price which is set in Indian rupees will need to get converted before uploading.

    Is there any place I can change that in the code.

    Google base allows me to set India as a option.

  8. @Jack No, I’m afraid I don’t have a definite list of the attributes that Magento populates by default. It’s all a bit trial and error approach with this Magento Google Base feed module, bust as Chris mentioned above, ” the only two attributes I needed to map were SKU > id and condition > condition. Magento automatically mapped the rest”.

  9. Hi Artur, great article, very clear and easy to understand for dummies like me. unfortunately, i’m still getting this error: Expected response code 200, got 403. Type: request. Reason: MCA can’t insert an entry, and can’t seem to figure out what it means or what i’m doing wrong. any ideas?

  10. Hi Artur,

    Thanks for putting this together and trying to help everyone out. I am pretty sure I am doing everything correct but when I go to submit even one product I get “Namespace error”. No other details. Have you come across this?

    Thanks,

    Jeremy

  11. @Jeremy Sorry, haven’t come across this one, but if you find out it would be great if you could drop a line.
    Artur

  12. You’re the best! Was racking my brain to get this going… finally did it for me. Thanks a ton.

  13. Hi All

    Please remember that Magento can also map the Google Base id attribute internally – meaning you may only want to map the condition attribute manually ant that’s all.

    I found it particularly useful when you want to publish one product to 2+ different target country feeds. Otherwise Magento will not show once published product if you want to send it to a different feed as you’ve already used up the SKU.

    Artur

  14. Getting a

    “Expected response code 200, got 400. Type: data. Field: app:draft. Reason: Disapproved items cannot be published”

    Been trying to fix for a week now any help or thoughts?

  15. I have over 7k items. Using your method I was able to send some but sadly only 199. When I click view available it sees all 7k+. What should I check into?

    Many thanks,
    Dave

  16. One new issue. After messing around and not getting further with the attribute mapping I put it back how it was and now get this error when I attempt to submit:

    Expected response code 200, got 400 There is a problem with the character encoding of this attribute.

  17. Hi,

    I’m trying to add products from one of my stores in Magento (we have a multi site setup) to a multi account Google Base setup but I’m getting the following error -

    Expected response code 200, got 403. Type: request. Reason: MCA can’t insert an entry..

    I’ve read some articles about this error but no solution. Any help much appreciated.

  18. I have had no problem with the connection between Magento and Googlebase (Merchant Center) BUT I really wanted to use the same export file to populate shoptab in Facebook but I simply can’t find the actual file. I suppose it is a scv file although have read it might be a .txt whchever it is really is where is it?

    Many thanks,

    Iain

  19. Great guide. Worked perfectly.

  20. I keep getting the following error:

    Expected response code 200, got 400. Type: data. Field: item. Reason: Internal error. Validation failed.

    However, I have not changed any user / pass settings so am unsure why this error has started to appear.

    Anyone have any ideas on this?

    Mike

  21. It only put up 199 products for me. That isn’t going to work for my store with over 17k items!

  22. Larry, this might be due to Magento’s default upload timeout period. I can’t give you technical details but we used to have a similar issue. Ask your BE developers if they can increase that period – might help.

  23. Hi Frnds,

    In Magento for froogle base which type of product i can upload configurable or simple product? I am using magento latest version 1.5

    Please help me because i am confuse which type of product i have to upload.

    Thanks

  24. hello,

    can somebody tell me how I can edit the country manually in the code files? I want to use google base in the netherlands. However, I am not able to select the netherlands in the magento backend (only US, UK and Germany).

    thank you!

  25. I’d like to know that as well. Or at least can someone tell me when we can use this in the Netherlands?

  26. *bump*
    I also get the following error and cannot find a solution anywhere. (Although success can be gotten by creating a separate Google account, that creates other (unrelated) issues so that isn’t a solution for us.)

    Expected response code 200, got 403. Type: request. Reason: MCA can’t insert an entry

  27. Hi

    i am getting error
    Expected response code 200, got 400. Type: data. Field: title. Reason: This attribute has too many values.

    However i cannot alter the titles for my products not sure how to fix this been trying for a while now

  28. I just placed all my products in Google Base but I’m having a few problems now:

    - Google places an extra suffix at the default url: ?___store=default
    - All my price in Magento are shown incl VAT but are filled in as ex VAT in the backend. Google uses the ex VAT prices for showing in Google Base.
    - Magento automatically exports a few standard fields to Google eg: price, description, stock…..how can I manually choose these fields?

    Thanks,

  29. Please do you know how can add Italy in countries option?

  30. I have made everything, as is written in this theme. However at connection of products in Google Base:
    …..
    4. Select Add To Google Base from the Actions drop down menu
    5. Confirm by clicking Submit

    Such inscription has appeared:

    Warning: include(Zend/Gdata/Gbase/Extension/ItemEntry.php) [function.include]: failed to open stream:
    No such file or directory in /var/www/vhosts/amberexpert.com/httpdocs/lib/Varien/Autoload.php on line 93

    What to do and how to correct ? Help somebody.., please.

  31. Hello. First of all I wanted to say how great your instructions are. Very simple to follow. I am wondering if you know why I am still getting the following error even though my URL has been verified and claimed?

    “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.”

    Thanks,
    Mike

  32. I can answer my own question. I figured out the problem. So if anyone else is having this problem this is what I did to fix it:

    In the Catalog > Google Base > Manage Attributes I selected the attribute I created while following the steps from you. Under the attributes mapping I had “Attribute” set to “Conditions” and the “Google Base Attribute” was set to “Custom Attribute, No Mapping”. I changed the custom attribute, no mapping to “Conditions” as well, and saved it. When back into the Catalog > Google Base > Manage Items and transferred the items no problem.
    Well that’s not a 100% true. We have 1022 products in the store and for some reason on 989 items got sent.

  33. Hello!

    Can someone please help!!!

    I have been trying to set the above up for couple of days now but each time I go to :

    Catalogue >> Google Base >> Manage Attributes and click on Add Attribute Mapping. – And I get this message “Read timed out after 10 seconds”

    Thanks

  34. Perfect, thanks. Do you use any Magento themes? We used one that significantly helped to speed up page page download times. It took a long time to get perfect and work to our needs but now it’s rock solid. Saved thousands on server charges by having it in a cloud. Thanks, Ric.

  35. Thanks for the share, brilliant advice, does anyone know where or how I can apply the same for eBay?

    Thanks, Luke

  36. Hi, I am hoping someone can help me out here, the problem that I am having is that when I try to open the “Add Attribute Mapping”, it won’t open, it just refreshes the page. Any help, suggestions, are greatly appreciated!

  37. We use gomage extension to generate feeds.
    It’s careful design makes it both easy to use and very flexible.
    I recommend the extension to anybody who wants to export their products as feeds – whether it is for Google Base/Merchant, Bing Shopping, Yahoo, etc.

    Hope this helps

  38. Hi, someone processed this for me before and I’m about to list our items in googlebase again but only 2 products are showing when I click “View Available Products” on Googlebase manage items even if I have 14,000+++ items in Magento.

  39. Google Base, we don’t have that option is our backend?

    i go to google api but that option not avaialble, why?

    using Magento ver. 1.6.0.0 is that why?

  40. Hi,

    I follow all the step, but it was error while i was generating from my products.

    My magento version 1.7
    Hum I am not sure about attribute to match with google.
    i just create condition.

    can someone tell me which attribute that i need.

    thanks

  41. Magento is well known and getting used many companies, it just simply helps eCommerce stores to grow online by its amazing magento extension development and modules.

*