So,. I found myself today trying to integrate the Google Merchant Center into a Magento Community edition store,. This used to be built in, and was a bit buggy,. but since it’s changed.
1) Install the Google Content API from Magento Connect,. (Admin->System->Connect)
2) Nothing happens
3) Go to admin and configure the API,. (Admin->System->Configuraiton->Google API)
4) Enter your check account number, username, passwords etc…
5) Now the fun begins (nothing happens)
6) Next we need to make sure you have a couple of item attributes that google is going to want.
7) Catalog->Attributes -> Manage Attributes
8) Make sure you have a MPN attribute and a Brand Attribute (if not add them)
9) Next we need to map the attributes you have to the ones google wants… (Catalog->Google-Content->Manage Attributes
10) You are going to create a custom mapping based on your config things like the MPN you added to google’s Manufacturer’s Part number field.
11) Save changes, and update cache and indexes
12) Add products to google (Catalog->Google Content->Manage Items
13) Select the products you want and hit “add to google”
14) if they are succesful next you will want to synchronize them to google.
** If you get an error like this “A required attribute is missing. Internal reason: Hard goods must have values for two out of the following attributes: gtin, brand, mpn. See ‘identifier_exists’ for product ‘product name – description’ (in ‘Default Store View’ store)”
You have a bad mapping, or an empty required field, .you can check the product they list, and see what is wrong with it, but if nothing seems wrong check your mapping and try again.
Eventually you will find the key that is wrong and be able to synchronize.
Tags: Magento Export Google Products, Magento Google Shopping (google base) integration, synchronize google and magento