Exporting products to Googlebase

  • StumbleUpon
  • Twitter
  • Digg
  • del.icio.us
  • Technorati
  • MySpace
  • Facebook
  • Google Bookmarks
  • MisterWong
  • Reddit
  • RSS

Getting noticed in Google Product Search

There has been huge demand for a module to allow upload of the products in Prestashop installations to Google Base. In an attempt to satisfy this, until such time as I can have a look at implementing it using the Google Base API, I threw together some code that will hopefully work. Only minimal testing has been performed, so I recommend that you use with caution.

Special thanks to Icarus for debugging the latest versions, and for the new feature suggestions for the 0.6.x series and beyond….

Changes

Version 0.6.3

  • File IO modified again to reduce risk of timeouts
  • Added g:weight attribute when weight is non-zero for product
  • Added g:product_type attribute based on product categories
  • Changed description input to textarea
  • Added config entry for output filename on server
  • Added advanced settings to allow a feed to be generated for another site
  • Added compatibility with 1.2beta (provisional)
  • Improved error checking for permissions issues

Version 0.5

  • File IO reduced
  • Custom entry for Feed Description

Known Issues

  • In version 1.2 the price is output to 6 decimal places instead of 2
  • Need to be able to select between short (current) and long description field from database

Downloads

Updated version (15 September 2008):
Googlebase v0.4

Updated version (13 July 2009):
Googlebase v0.5

Updated version (16 July 2009):
Googlebase v0.6.3 (for v1.1 and v1.2)

Maintenance Release (06 January 2010):

- Minor modification to feed writing to attempt to fix blank screen errors in some stores.

Googlebase v0.6.3.1 (for v1.1 and v1.2)

You may also like:

  1. Yet another Google Base update 0.6.3 Get noticed in Google Product Search It’s been a busy...
  2. Fixed version of the gsitemap module There seems to have been a lot of problems with...
  3. Updated Google Base Module to v0.5 Google Base Module Update I’ve just recently updated the original...
  4. Moving Boxes Home Featured jQuery module I thought it was about time for yet more free...
  5. PS_Cumulus a WP-Cumulus port to Prestashop I was looking to write a cool module to use...

Tags: , , , , ,

82 Responses to “Exporting products to Googlebase”

  • jon says:

    Admin, do you have a quick temporary fix for either the double url in the earlier base modules, or the blank screen in 0.6.3. I would of thought the double url problem is an easier problem to fix, any code edits?? need this mod desperetly.

  • jon says:

    ok thanks, that will be really appreciated.

  • admin says:

    0.6.3.1 Uploaded and a link provided in the post. Would appreciate some testing as without debugging this on a server that’s experiencing the problem it is hard to be 100% sure of the problem. I suspect that the more aggressive file IO changes introduced in 0.6.3 were causing it to break.

  • jon says:

    Hi admin, unfortuantly still not working for me! on a new site 0.6.3.1 didnt work at all, tried 063 and turned off canonical url module and worked but only on about 9 out of 25 products. And noticed there are no pictures.

  • jon says:

    Also google are disapproving the feed every time.

  • I have posted a couple of posts on the prestashop forum as i think the proble with the “double url” comes from the htaccess fie when you enable seo links. I have the double url problem on another module (send – question) the back button in that does the same double url as the google base module.

    I will post info if i get a answer back.

    • admin says:

      It would be good if that’s the case, but I suspect it’s a bit of dodgy code in the Prestashop core. The url rewriting isn’t done well in my opinion, and what url it actually produces for a “page” depends on multiple factors. I’m going to have another delve into it and see if there’s any way of forcing it to product a consistent result.

  • It may be in the core i have tried everything i can think of including the new release you did 0.6.3.1 but still the same blank screen, i had a close look at the double url and its not duplicating the url exact on the seccond url it is miss the semi colon “:” after the http not sure if this will help – but i just seen a Tesco advert on tv so every little helps!

    http://xnitrorc.co.ukhttp//xnitrorc.co.uk/14-rc-pirate-ship.html

  • Thanks for the update to v0.6.3.1 – works great for me and fixes prices being displayed ex VAT – Google require inclusive prices.

  • barks meow says:

    admin, I’ve tried 0.6.3 and 0.6.3.1. I keep getting hack attempt error when trying to generate the feed file. Do you know what might be causing this error?

    • admin says:

      I suspect it has something to do with currencies. Currently it “guesses” the currency using the admin account’s cookie settings. This is the next area that needs improvement, since some people may wish to generate feeds for more than one country/currency supported.

      For now you can check that the store/admin default currency and language are a match for something Google expects (US, UK or DE).

  • barks meow says:

    Checked everything. Same error.

Leave a Reply