Froogle Merchant Center merged into GoogleBase

Ok! I got a new one for ya!

I tried to do the froogle upload thing from admin..... and it said the prices were all '0' for all 745 products on the froogle text file. HOWEVER.....It looks like it changed ALL of the prices on my web site to '0' and I'm going to have to restore my database. :cry: :no: :cry: I am going to take the googlefroogle mod off my site first.

I hope google is happy now....

jeking:

I've searched and can't figure this out.
Nice search!!! 3 post up before your post!!!!!!!!

Having a bit of a problem with this module. (Or should I say my improper usage and implication of this finely desgned module)
At the Froogle Data Feeder when I "step 1" and create my product feed I receive this message:

Froogle Data Feeder started 2006/09/21 09:02:18 Feed file - D:/Inetpub/wwwroot/beadedlily/shop/feed/froogle.txt Froogle File Complete In 24.037645 Seconds 399 Records

When I "step 2" and upload my product feed I receive this message:

Froogle Data Feeder started 2006/09/21 08:39:59 Feed file - D:/Inetpub/wwwroot/beadedlily/shop/feed/froogle.txt Upload started... Connected to: uploads.google.com Login ok: Current Directory Is: /

And then it just sits - There is no more to it.

Step 1 indicates that a text file was created with 399 records. However it is not being created here:

D:/Inetpub/wwwroot/beadedlily/shop/feed/froogle.txt
If it was I could just upload via FTP.

What am I missing? There must be steps I'm not following. Whatever help or suggestions would be greatly appreciated.

Tim

Step 2: it should tell you if the upload was OK or not

Make sure that the feed directory its trying to write to has permissions to be written to.. other than that I can't think of anything.

Can you view the uploads file through the admin area?

getyourgameshere.com:

Step 2: it should tell you if the upload was OK or not

Make sure that the feed directory its trying to write to has permissions to be written to.. other than that I can't think of anything.

Can you view the uploads file through the admin area?

Thanks for your response -

Success of the upload is indicated only in-so-far as this:

Froogle Data Feeder started 2006/09/21 08:39:59 Feed file - D:/Inetpub/wwwroot/beadedlily/shop/feed/froogle.txt Upload started... Connected to: uploads.google.com Login ok: Current Directory Is: /

Two questions, if I may: First, in step one after I create my feed and get the positive response that 399 records were processed, shouldn't those records be indicated? If I had them I could upload directly via FTP. All I get is:

Froogle Data Feeder started 2006/09/21 09:02:18 Feed file - D:/Inetpub/wwwroot/beadedlily/shop/feed/froogle.txt Froogle File Complete In 24.037645 Seconds 399 Records
Which, when I log onto my Froogle account Froogle tells me is 0 records.

Two, concerning permissions (of which I know nothing): What would the correct sequence be? 777? Also, The machine I am on is not Unix, so I believe that the CHMOD command does not work. If that is so, I'd be in a real bind.

MeltDown:

Thanks for your response -

Success of the upload is indicated only in-so-far as this:

Two questions, if I may: First, in step one after I create my feed and get the positive response that 399 records were processed, shouldn't those records be indicated? If I had them I could upload directly via FTP. All I get is:

Which, when I log onto my Froogle account Froogle tells me is 0 records.

Two, concerning permissions (of which I know nothing): What would the correct sequence be? 777? Also, The machine I am on is not Unix, so I believe that the CHMOD command does not work. If that is so, I'd be in a real bind.

As far as permissions are concerned, mine is set to 755 and it works fine. 777 has a security risk involved with it.. basically leaves it open for anyone to touch it. The problem is sometimes you absolutely have to use 777, so htaccess protection is recommended in those cases

As far as the records go, you are getting the correct message (from what I can remember). Once its created, you should be able to visit the directory and find the froogle.txt file. In the admin area, right below the link to create the feed, there is a link to view it - create and view the file. If you can view it, great - you could upload this file on its own for the time being. If you can't view it.. theres a permission problem somewhere, so try out different permissions (777 should work no matter what, i would try 755 first). If you still can't get it to work.. I'm not sure what to do :(

getyourgameshere.com:

As far as permissions are concerned, mine is set to 755 and it works fine. If you can't view it.. theres a permission problem somewhere, so try out different permissions (777 should work no matter what, i would try 755 first). If you still can't get it to work.. I'm not sure what to do :(

Thanks for your response - More than likely, this is where my trouble is. When I change permissions to 755 (or 777) it reverts right back. I ran into this with another google module previously. (sitemap) I'm on a shared server that is not a unix so I'm unable to make the changes. Because of this I've been meaning to switch providers (to Camelot) for months now but haven't wanted to go through the change-over hassle. Looks like now it's a must. I do think it will alleviate a number of these issues.

Thanks again.

Tim

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set_function='' WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING'' at line 1

BlessIsaacola:

I got the same error but installing the SQL via phpAdmin worked just fine for me. Usually if the Install SQL Patch doesn't work from the Admin side I just go to phpAdmin to install the SQL and 9.9 of 10 times that solves my problem.

I am getting the above error when trying to install the update v1.2.6. I tried to install it through phpAdmin and still received the error. I am running ZC 1.2.5d. Any ideas?

rainy:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set_function='' WHERE configuration_key='GOOGLE_FROOGLE_SHIPPING'' at line 1

I am getting the above error when trying to install the update v1.2.6. I tried to install it through phpAdmin and still received the error. I am running ZC 1.2.5d. Any ideas?

1.2.x is not supported.. straight from the author ->http://www.zen-cart.com/forum/showpost.php?p=263217&postcount=143

i was having a little bit of a problem with this plugin and i was hoping someone might be able to help me. the first problem appears to be my product descriptions. for some reason when i create the 'froogle.txt' it always gets denied. after playing around for few hours i discovered that froogle does not like my product descriptions at all. would there be a way to limit the size of the description to say 100-200 characters?

my next issue is the images. i use image handler 2 and the wrong link to my images gets placed in the froogle.txt file. is there a method to make this feeder and image handler 2 play nice together? :laugh:

optikalsaint:

i was having a little bit of a problem with this plugin and i was hoping someone might be able to help me. the first problem appears to be my product descriptions. for some reason when i create the 'froogle.txt' it always gets denied. after playing around for few hours i discovered that froogle does not like my product descriptions at all. would there be a way to limit the size of the description to say 100-200 characters?

my next issue is the images. i use image handler 2 and the wrong link to my images gets placed in the froogle.txt file. is there a method to make this feeder and image handler 2 play nice together? :laugh:

I had the problem with IH2 as well. I just uploaded _LRG versions of the images and it was fixed.. it wasn't too big of a hassle since I don't have many products but I can see how that would affect others who have larger stores

optikalsaint,
I experienced the same problem with googlefroogle feeder & IH2.

You may want to use the froogle feeder contrib from the same developer site as IH2. The IH2 images are referenced correctly using this feeder.

There's only 1 or 2 basic utility functions different between the two contribs. I'll probably graft the best of both together for my puposes.

You can find it here http://breakmyzencart.com/froogle

Cheers,

Thanks for the info!

Thank you for this mod....I am running 1.2.2 on version 1.3.0.2 zencart and wondering if the below has been taken care of in recent releases of this mod -

Problem: Google says:

Change attribute format: Attribute values for the "category" are not as specific as other available, recommended attributes. For example, instead of including "category," we recommend that you include a "label" attribute.

Any insite appreciated.

athena:

Problem: Google says:

Change attribute format: Attribute values for the "category" are not as specific as other available, recommended attributes. For example, instead of including "category," we recommend that you include a "label" attribute.
Ok! Google Base Attributes:
review_type - The category of the item being reviewed.
label - A list of classifications the item may fall under. These attributes will be used to match your items to search queries. Each attribute value will be checked for policy compliance.
Change attribute "category" to attribute "label". Download and test.

Thanks, yes, I know I can do that but is there any plan to make this part of the mod? Also, wouldn't it be a good idea to have that column a list of metatag keywords to fit the froogle format?

Looks like GoogleBase is changing once again:

We're writing to all our top Froogle merchants to tell you about an
exciting development that will improve the search experience for our users

• and your potential customers. Namely, we'll soon be integrating product
  search functionality into Google.com itself.

Through our "Refine Your Search" feature, users will now be able to shop
for products directly from our main search page, Google.com - which means
that you'll be able to reach a much broader audience than you can reach
with Froogle alone. Here's an example of how we've implemented this
experience for the autos category:

http://www.google.com/images/base/vehicles_f02b.jpg

In order to participate in this initiative, however, you must resend us
your data feed with the new Google Base attributes (the old Froogle
attributes will no longer work). We encourage you to send us as many
attributes about your products as possible; the more information you send,
the better chance you'll have of matching a "refinement" query.

You can learn more about attributes and the new Google Base format here:

http://base.google.com/base/products.html

Quote: "We're writing to all our top Froogle merchants"

Gosh i didn't get an email, don't i feel special. :(

I think we need to figure out a better google froogle feed that will put in the new attributes that froogle is asking for with the proper naming and also insert your colors, sizes, etc. available.

I'll contribute money to that cause if anyone wants to sell me their contribution. looking for it to be compatible with 1.3.0.1 and 1.3.5

thanks,

Andy

I would contribute too!

athena:

Thanks, yes, I know I can do that but is there any plan to make this part of the mod?I already have made it!!! Reread:
a_berezin:

Download and test.
athena:

Also, wouldn't it be a good idea to have that column a list of metatag keywords to fit the froogle format?What do you mean?