Froogle Merchant Center merged into GoogleBase

[birdoasis]

I wonder if removing the shipping field will work. I keep getting errors that my shipping has errors and I have it setup just like they say to.

I'll have to try that.

Thanks!!!

JP

[birdoasis]

Yep, removing the shipping field worked, but I did have a problem.

Using notepad ++ I took out the shipping header then I copied the contents of the shipping field and did a find and replace with nothing in the replace field.

The only problem was that I forgot to include the field separator in the find and replace.

So after I uploaded it and saw the error that I had more fields than headers, I had to go back in and do a find for two separators, I just clicked on view, show all items, and then copied the two separators where shipping used to be. Then I did a find with those two separators and replaced with one.

Now it worked and I got my 206 products waiting to be searchable.

hod damn!!!

[numinix]

More issues with Google Base Feeder

[FONT=Consolas]Issues:[/FONT]
[FONT=Consolas][/FONT]
[FONT=Consolas]1. Wrong prices[/FONT]
[FONT=Consolas]2. Include additional required attributes[/FONT]
[FONT=Consolas][/FONT]
[FONT=Consolas]Solution:[/FONT]
[FONT=Consolas][/FONT]
[FONT=Consolas]1. My Zen Cart's default currency is Canadian dollars and Google Base only supports USD. The discrepency in prices occurs when my zen cart runs a cron job to update the currency exchange rates. I'm hoping rearranging my cron jobs so that the exchange rates are updated before all feeds are submitted will combat this issue.[/FONT]
[FONT=Consolas][/FONT]
[FONT=Consolas]2. Has anyone else had this problem?[/FONT]

[Woodymon]

I think that this may be my problem. You mention putting the other files in 3 subdirectories off of the root. I did not see this in the instructions.

What files go into what 3 subdirectories?

Just like the mod is packaged ;-)

Webroot (e.g. /public_html/)
|
|-> googlefroogle.php <- upload file
|-> /includes/ <- upload files to /includes
|-> /admin/ <- upload files to /admin
|-> /feed/ <-upload dir & set perms


But this has nothing to do with the admin menu problem. That is an SQL issue.

Woody

[Woodymon]

I simply removed the product_type field and Google UK has no complaints. My products are being found and indexed very easily.

Here is the list of Product Types Google will accept.

http://www.google.co.uk/base/uk/product_types.html

Here is corresponding U.S. list:

http://www.google.com/base/product_types.html

Note that the heading states:

Here are "some" "examples" of product types that can be submitted to Google Base.

Meaning that this is just a subset of product_types accepted and is not a definitive list.

Note "other" is not included on the list. But I have not had any issues with "other" in the product_type field (as others have reported).

Also I have edited my feed file before uploading and included custom product_types not on listed the URL's above, and Google accepted my feed.

I observe Google gives much better results when you do apply a specific relevant Product_Type for each product.

Woody

[CJ Internet Sales]

I truly appreciate your patience. I usually am not this dense.

Following Woody's instructions I can now see the Google Froogle Feeder link in admin/tools.

I confirmed that the feed directory is in the root and has full permissions.

When I click the Google Froogle Feeder link a new window opens but nothing is displayed. They URL in the address bar is http://mystore.com/googlefroogle.php?feed=yes&upload=no. I manually close the window.

I check the feed directory and the original 2 files are all that are there but not the upload file.

I have set the parameters in the configuration file to match my Google Base Account. I also created a specific text file name for the feed output.

Any ideas on how to proceed?

[Woodymon]

I confirmed that the feed directory is in the root and has full permissions.

When I click the Google Froogle Feeder link a new window opens but nothing is displayed. They URL in the address bar is http://mystore.com/googlefroogle.php?feed=yes&upload=no. I manually close the window.

I check the feed directory and the original 2 files are all that are there but not the upload file.

Any ideas on how to proceed?

1. What are the permissions on the feed file in the feed directory (not the perms on the directory itself)?

The Google Froogle page should appear in Zen Cart no matter the perms on fhe feed directory or file. Only when you attempt to generate the feed should permissions matter. And the GoogleFroogle mod will alert you to permissions issue.

2. I think you still have a SQL table prefix issue and even though you were able to get the google froogle menu item to appear in the Tools menu, the remaining entries in the SQL were not correctly written to the DB (where they need to go).

Look in the installer SQL file and check which entries were suppose to be inserted into which specific tables in your database. Then check to see if those entries were written to the correct DB table.

You may need to edit the SQL with proper prefix on each table entry in the SQL.
Best to run the uninstaller SQL again before proceeding with any SQL editing/patching.

After editing the SQL I recommend patching your DB via phpmyadmin.

Woody

[alray10]

Here is corresponding U.S. list:

http://www.google.com/base/product_types.html

Note that the heading states:

Here are "some" "examples" of product types that can be submitted to Google Base.

Meaning that this is just a subset of product_types accepted and is not a definitive list.

Note "other" is not included on the list. But I have not had any issues with "other" in the product_type field (as others have reported).

Also I have edited my feed file before uploading and included custom product_types not on listed the URL's above, and Google accepted my feed.

I observe Google gives much better results when you do apply a specific relevant Product_Type for each product.

Woody

I am no coder so I don't know how or if this could be done.
But I came up with a idea at the moment this mod puts your stores Categories under "labels" on your feed, if this could coded to put it under "product_types" we only have to change our categories to the names of porduct types that googlebase excepts.

[numinix]

I am no coder so I don't know how or if this could be done.
But I came up with a idea at the moment this mod puts your stores Categories under "labels" on your feed, if this could coded to put it under "product_types" we only have to change our categories to the names of porduct types that googlebase excepts.

$output["label"] = "product_type";
// $output["product_type"] = "product_type";

Rename all cateogories (excluding sub-categories) to the Google product type.

Do you think that would work? It prints the labels/categories in the output file as the product_type.

[alray10]

$output["label"] = "product_type";
// $output["product_type"] = "product_type";

Rename all cateogories (excluding sub-categories) to the Google product type.

Do you think that would work? It prints the labels/categories in the output file as the product_type.

That worked great Thanks.
Anyone else that did uses it remember to change
$output["label"] = "label";
To
// $output["label"] = "label";
To get rid of the label in the feed.

One more thing is there a way that I can get it so it only shows the top categores in the field i.e "Fragrance" and not "Fragrance, Men's Fragrance" or "Fragrance, Women's Fragrance"

If this could be done it would mean Froogle feeder is working again for me and I hope this helps others to.
I removed the Sub- categores manually and googlebase excepted it no problem.