PrestaShop Forums: Google Shopping or Froogle Feed or Google Base uploads - PrestaShop Forums

Jump to content


Welcome to the PrestaShop Forum! We hope you'll share your comments and suggestions with us. We ask that you please post in English to the main sections of the PrestaShop Forum. If you want to write in another language, please post in the corresponding PrestaShop Community section below.

Please note that PrestaShop Community sections are largely self-moderated. PrestaShop team members may or may not participate in non-English sections. To improve the chances of receiving feedback to your question or comment, please post it in English to the main sections of our Forum.

NYC

Vous parlez français ? par ici !


Google Shopping or Froogle Feed or Google Base uploads


Google Shopping or Froogle Feed or Google Base uploads

#1 eric

    PrestaShop Newbie

  • 08 Feb 2008
  • Members
  • Pip
  • 6 posts

Posted 08 February 2008 - 06:59 AM

Many have probably heard of this before, but I think Prestashop needs a google base feed.

http://base.google.c...wer=59537&hl=en

This is free service from google and helps get every product listed in google shopping.  At least that has been my experiance.

This feed can sometimes be found under Froogle Feed in other projects.  I have built many OSC sites and used the Froogle Mod.  We would be missing a huge oportunity is this feed wasn't available some time.  I just wanted to call it out to get it on the radar.

Keep up the great work guys.  Presta is great! :)

#2 benjjj6

    PrestaShop Newbie

  • 14 Jul 2008
  • Members
  • Pip
  • 18 posts

Posted 15 July 2008 - 06:10 PM

Hi Eric

I just wanted to show my support for a Froogle/Google Base Feed. I was about to start a new thread until I saw your message which sums up everything I wanted to say!

I too use a Froogle Contribution with my OsCommerce store and know that the majority of my sales come from Froogle.


This would be a great feature for PrestaShop that all users could benefit from.

#3 jhnstcks

    PrestaShop Fanatic

  • 16 Jul 2008
  • Moderators
  • 1748 posts
  • Location:UK

Posted 16 July 2008 - 05:04 AM

I also use this in oscommerce and would love to see it implemented in prestashop.
Don't forget to click the like button on posts if you think it has been helpful.

E-commerce hosting from Scotserve, fast, reliable and affordable.
E-commerce forum - reviews of dropship suppliers, wholesalers, expert advice on shopping cart software and plenty more....

#4 superhero495

    PrestaShop Apprentice

  • 28 Apr 2008
  • Members
  • PipPip
  • 142 posts

Posted 16 July 2008 - 06:27 AM

Hi guys,
something like this exists for czech search engine zbozi.cz. There are probably only few changes needed to use it with froogle.
http://www.prestasho...iewthread/1159/

#5 Stu583

    PrestaShop Apprentice

  • 10 May 2008
  • Members
  • PipPip
  • 204 posts
  • Location:North Yorkshire, UK

Posted 16 July 2008 - 04:28 PM

+1 :)

#6 Log Cabin Cutlery

    PrestaShop Newbie

  • 18 Jul 2008
  • Members
  • Pip
  • 5 posts
  • Location:Little Rock, Arkansas U S A

Posted 20 July 2008 - 01:32 PM

I too would like to see google base implemented. Alot of my sales have come from this as well.

See ya

#7 Paul C

    PrestaShop Fanatic

  • 02 Aug 2008
  • Members
  • PipPipPipPip
  • 1003 posts
  • Location:Dundee, Scotland, United Kingdom

Posted 02 August 2008 - 10:58 PM

I have a version that's very much BETA. If you want to try it out on your store then PM me the details and I'll send it on to you.
Forgot to mention: An example output is at http://prestashop.ec..._googlebase.xml
Free Prestashop modules and developer resources

Latest Prestashop Developer articles:
* 1.4 Plugins Revisited – Part 1
* 1.4 Plugins Revisited – Part 2

Latest News:
Prestashop Module and Theme Developers can now Advertise on eCartService.net

#8 Bleep

    PrestaShop Apprentice

  • 28 Jul 2008
  • Members
  • PipPip
  • 151 posts

Posted 05 August 2008 - 03:12 PM

I too would love this!
I saw a psychologist when I was younger and she accused me of being a drinker. "How outrageous!" I proclaimed. "I'm not a drinker, I'm a drunk, there's a big difference." Dismayed with my lack of maturity and seriousness and unwilling to accept defeat, she quoted the following: "50% of all automobile accidents are caused by drunk drivers." Unimpressed with this statistic, I flatly retorted, "Apparently, the sober ones aren’t doing that well either.” End of therapy.

#9 Paul C

    PrestaShop Fanatic

  • 02 Aug 2008
  • Members
  • PipPipPipPip
  • 1003 posts
  • Location:Dundee, Scotland, United Kingdom

Posted 05 August 2008 - 04:13 PM

You can download the (BETA) google feed module from my site now.

http://www.ecartserv...-to-googlebase/

Enjoy!

Paul

Free Prestashop modules and developer resources

Latest Prestashop Developer articles:
* 1.4 Plugins Revisited – Part 1
* 1.4 Plugins Revisited – Part 2

Latest News:
Prestashop Module and Theme Developers can now Advertise on eCartService.net

#10 Bleep

    PrestaShop Apprentice

  • 28 Jul 2008
  • Members
  • PipPip
  • 151 posts

Posted 07 August 2008 - 03:58 PM

I was just wondering how the feed handles attributes. Does it create a new product per attribute group? This is really what I need since one of my products has lots of different variations. Thanks.

From 1217949234:

You can download the (BETA) google feed module from my site now.

http://www.ecartserv...-to-googlebase/

Enjoy!

Paul

I saw a psychologist when I was younger and she accused me of being a drinker. "How outrageous!" I proclaimed. "I'm not a drinker, I'm a drunk, there's a big difference." Dismayed with my lack of maturity and seriousness and unwilling to accept defeat, she quoted the following: "50% of all automobile accidents are caused by drunk drivers." Unimpressed with this statistic, I flatly retorted, "Apparently, the sober ones aren’t doing that well either.” End of therapy.

#11 Paul C

    PrestaShop Fanatic

  • 02 Aug 2008
  • Members
  • PipPipPipPip
  • 1003 posts
  • Location:Dundee, Scotland, United Kingdom

Posted 07 August 2008 - 04:21 PM

Rory,

This one doesn't; currently it lists basic products, that's all. Additional fields are fairly simple to add to the feed though; as long as the data is in the database and matches what google expect (this no different to the google base feeds for osCommerce, ZenCart etc.). Maybe when there's a little more PrestaShop documentation.....

Google supports product attributes as far as searching for a product, but doesn't support "choices" that I'm aware of. You need to add such things to your description.

I'm happy to make changes to it if there's something that should be in the that isn't.

Paul
Free Prestashop modules and developer resources

Latest Prestashop Developer articles:
* 1.4 Plugins Revisited – Part 1
* 1.4 Plugins Revisited – Part 2

Latest News:
Prestashop Module and Theme Developers can now Advertise on eCartService.net

#12 ken

    PrestaShop Apprentice

  • 17 Jul 2008
  • Members
  • PipPip
  • 36 posts

Posted 07 August 2008 - 07:19 PM

Hi Paul

I just wanted to say Thank You.

It seems to be working great and I have just submitted my feed to Google Base

I changed to

I also added

$expire_date = date('Y-m-d', strtotime("+30 days"));

$this->_addToFeed("$expire_daten");


and

$this->_addToFeed("".$Product['manufacturer_name']."n");



I would also like to add the category (and preferably the subcategory). Do you know how to do this?

Regards.

Ken.

#13 Paul C

    PrestaShop Fanatic

  • 02 Aug 2008
  • Members
  • PipPipPipPip
  • 1003 posts
  • Location:Dundee, Scotland, United Kingdom

Posted 07 August 2008 - 07:32 PM

Ken,

Cheers, and thanks for the code updates (typos and enhancements!). I'll add it to the download for others to enjoy. Will be v0.2.

I'll look into the categories/sub categories. I threw this together in an hour while in a chat room with a user that needed something quick, so as you've discovered it was hardly production strength! It'll be great if it helps you out.

The user in question was still trying to get his images uploaded so I don't think he's got around to testing it yet :lol:

I went back and checked and the example files on the google base site specify not in them so I'm not sure which would be technically correct; maybe both? According to the docs for Product is required....I'll add both.


Paul
Free Prestashop modules and developer resources

Latest Prestashop Developer articles:
* 1.4 Plugins Revisited – Part 1
* 1.4 Plugins Revisited – Part 2

Latest News:
Prestashop Module and Theme Developers can now Advertise on eCartService.net

#14 Bleep

    PrestaShop Apprentice

  • 28 Jul 2008
  • Members
  • PipPip
  • 151 posts

Posted 07 August 2008 - 08:12 PM

Thanks for responding. Okay, maybe I'm confused here (which wouldn't be uncommon!) but I'm not looking for the attribute dropdown menu to be on google base, but for the attributes on our stores to generate a product. For example, I have a sock that has two attribute drop down menus, one for size(adult medium, adult large) and one for color (white, blue) each with their own choices as I just mentioned. I guess what I am asking is can the feed generate one product (white, adult medium) and another product (blue, adult large) and etc. etc. for the two remaining options as specified when I assigned them in the attribute section. So in this case, even though I have one product page, I really have four products to sell, so it would be nice to list four products on google. Does this make sense?

BTW, thank you for writing a mod like this, and I wish I could contribute more but my php and database skills aren't quite there yet, but I'm learning. :)


From 1218122491:

Rory,

This one doesn't; currently it lists basic products, that's all. Additional fields are fairly simple to add to the feed though; as long as the data is in the database and matches what google expect (this no different to the google base feeds for osCommerce, ZenCart etc.). Maybe when there's a little more PrestaShop documentation.....

Google supports product attributes as far as searching for a product, but doesn't support "choices" that I'm aware of. You need to add such things to your description.

I'm happy to make changes to it if there's something that should be in the that isn't.

Paul

I saw a psychologist when I was younger and she accused me of being a drinker. "How outrageous!" I proclaimed. "I'm not a drinker, I'm a drunk, there's a big difference." Dismayed with my lack of maturity and seriousness and unwilling to accept defeat, she quoted the following: "50% of all automobile accidents are caused by drunk drivers." Unimpressed with this statistic, I flatly retorted, "Apparently, the sober ones aren’t doing that well either.” End of therapy.

#15 Paul C

    PrestaShop Fanatic

  • 02 Aug 2008
  • Members
  • PipPipPipPip
  • 1003 posts
  • Location:Dundee, Scotland, United Kingdom

Posted 07 August 2008 - 08:44 PM

Rory,

I'm with you... my intention is to add attribute support, and in order for google to list them they'll have to be unique products as per your post. This requires quite a bit of manipulation of the data to achieve though, and we're talking version 1 not 0.2 :)

The editorial guidelines specify one product per page for landing pages, but I'm pretty sure the above would be acceptable.

The idea of this currently is to get the basic (mandatory) information in there, and develop from there.

Attributes are pretty essential if you're going to get your products found easily on google base (unless the items you sell are fairly niche). I would suggest that if you're going to use attributes on your site AND want to use google base, then you should be looking at the ones that are pre-defined.

The ful list of "standard" attributes is here: http://base.google.c...wer=78170&hl=en

This module is geared towards Products only, of course.

Paul
Free Prestashop modules and developer resources

Latest Prestashop Developer articles:
* 1.4 Plugins Revisited – Part 1
* 1.4 Plugins Revisited – Part 2

Latest News:
Prestashop Module and Theme Developers can now Advertise on eCartService.net

#16 Bleep

    PrestaShop Apprentice

  • 28 Jul 2008
  • Members
  • PipPip
  • 151 posts

Posted 07 August 2008 - 10:16 PM

Thanks again. I understand. Are these feeds similar to the ones for other shopping comparrsion sites? Just curious. And I am going to look into these feeds and see if I can't contribute in some way. LOL. I'm still learning this stuff, so it is a bit overwhelming! However, I will try my best.
Great job so far!

From 1218138245:

Rory,

I'm with you... my intention is to add attribute support, and in order for google to list them they'll have to be unique products as per your post. This requires quite a bit of manipulation of the data to achieve though, and we're talking version 1 not 0.2 :)

The editorial guidelines specify one product per page for landing pages, but I'm pretty sure the above would be acceptable.

The idea of this currently is to get the basic (mandatory) information in there, and develop from there.

Attributes are pretty essential if you're going to get your products found easily on google base (unless the items you sell are fairly niche). I would suggest that if you're going to use attributes on your site AND want to use google base, then you should be looking at the ones that are pre-defined.

The ful list of "standard" attributes is here: http://base.google.c...wer=78170&hl=en

This module is geared towards Products only, of course.

Paul

I saw a psychologist when I was younger and she accused me of being a drinker. "How outrageous!" I proclaimed. "I'm not a drinker, I'm a drunk, there's a big difference." Dismayed with my lack of maturity and seriousness and unwilling to accept defeat, she quoted the following: "50% of all automobile accidents are caused by drunk drivers." Unimpressed with this statistic, I flatly retorted, "Apparently, the sober ones aren’t doing that well either.” End of therapy.

#17 ken

    PrestaShop Apprentice

  • 17 Jul 2008
  • Members
  • PipPip
  • 36 posts

Posted 08 August 2008 - 12:40 AM

The feed has been accepted and is now Published and searchable :-)

Google has made three recommendations

We recommend including this attribute. isbn
We recommend including this attribute. ean
We recommend including this attribute. Brand

Quote

I threw this together in an hour


Well I am very impressed. It took me longer than that to add the expiry date. :-S

Ken.

#18 Bleep

    PrestaShop Apprentice

  • 28 Jul 2008
  • Members
  • PipPip
  • 151 posts

Posted 21 August 2008 - 01:04 AM

Great mod! I installed it and everything works perfect. The only suggestion I have is for a possible future release: allow the index and category pages to have feeds as well. This only creases the likelyhood that someone will click to a prestashop site.
Thanks for posting!
- Rory
I saw a psychologist when I was younger and she accused me of being a drinker. "How outrageous!" I proclaimed. "I'm not a drinker, I'm a drunk, there's a big difference." Dismayed with my lack of maturity and seriousness and unwilling to accept defeat, she quoted the following: "50% of all automobile accidents are caused by drunk drivers." Unimpressed with this statistic, I flatly retorted, "Apparently, the sober ones aren’t doing that well either.” End of therapy.

#19 ken

    PrestaShop Apprentice

  • 17 Jul 2008
  • Members
  • PipPip
  • 36 posts

Posted 10 September 2008 - 03:56 PM

Hi Paul

I notice that this code is adding inactive items to the feed. Can this be corrected?

Thanks

Ken.

#20 Paul C

    PrestaShop Fanatic

  • 02 Aug 2008
  • Members
  • PipPipPipPip
  • 1003 posts
  • Location:Dundee, Scotland, United Kingdom

Posted 10 September 2008 - 04:00 PM

Ooh, I didn't think it did, but it's been a while since I looked. I'll check it out.

Update: I've uploaded a tweaked version of the Google Base Module now version 0.3 which should only display active products.

Paul
Free Prestashop modules and developer resources

Latest Prestashop Developer articles:
* 1.4 Plugins Revisited – Part 1
* 1.4 Plugins Revisited – Part 2

Latest News:
Prestashop Module and Theme Developers can now Advertise on eCartService.net





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users