Here is another problem with Google Base API.
After you create create attribute for your google base account and map it with your catalog, then go to Manage items under Google Base. click on view available products, select some products, change action to “Add to Google Base” then click on submit after few minutes, if you don’t get any CAPTCHA another line 27 error, your products will be added to the top section of the page under the “Google Base Items” table. Repeat this until you add couple thousand products to your Google base account. Then go to base.google.com and log in to your account. With my experience I submited approx >4100 products in my Magento catalog. When I checked my Google Base account, there was only 2000 Products submited to Google base! I don’t know what happened to the rest of the products. So, I decided to synchronize my Magento with Google base. I returned to Magento Google base --> Manage items, and I clicked on Synchronize. This synch removed almost all products from my Google Base Item box in magento except for 25 items. When I checked my Google base account directly, there was no change in the number of products and it was still showing ~2000 items in Google base. Back to Magento again and I clicked on Synch for the second time. This time it removed all products from “Google Base Item” table, while there was no change in the original google base account. Adding new products to google base via Magento still adds the number of products in google base.
So, as you can see, this entire Google base API is a mess and it is not working properly.
I have the exact same problem! I only have 69 products, I added them all first time. When i clicked synchronize for the fun of it, it told me it had deleted all but 24 products! In googlebase website, all 69 were still listed. Again, I synched and it re-added all 24 products into googlebase so now i have 100+ products with some as duplicates. Of course in magento backend, it only says i have 24 products in base.
Another issue is, no image link is added and even when I mapped the price, it still doesnt carry over.
I’m having a problem when syncing where my products lose their URL to the product page. They end up going to some google page which has product information but no checkout options. Anyone have ideas why this might be
Here is an example: http://base.google.com/base/a/4486237/D5704563891691198441
Mine is doing the same when I go to edit items for the site that have already been uploaded to Google Base. And it wouldn’t allow me to edit them, so I set Google Base up so it wouldn’t be updated when I update products in the configuration. A workaround for now, but I needed to edit my products.
The Google Base integration is a joke. And I’m not just saying that because my original PHP script actually works. I synchronized the items, and it removed over 5000 products, just like OP said. It left me with 25 total. I’m going back to the gbase.php script, it didn’t cause all this grief.
I can confirm that gbase.php 90% works with Magento 1.2.1 and with Google Base’s current API. After generating the feed and manually uploading it to Google Base, 14 of my products were rejected for bad character encoding. I’m not sure just yet how to handle this, but it looks like a second pass might be needed to sanitize the text and enforce a different character encoding.
And just to clarify the directions, in case it’s not stated elsewhere, the ‘export’ dir should be in the root directory of your Magento store, not the root directory of the server, and it should have group and owner www-data.
I spoke too soon. It’s 95% working. I noticed that the product URLs all have gbase.php in them, e.g. instead of http://mythic.tv/index.php/antennas/iblast-hdtv-antenna.html I have http://mythic.tv/gbase.php/iblast-hdtv-antenna.html
I have no idea why all the other methods would return the right results, but getProductUrl() ends up returning the php URL plus the final part of the product URL. Is there some specific place I need to put the script?