Froogle Merchant Center merged into GoogleBase

[jeking]

I did this by going into mySQL and adding another field. You can select the product type from the admin but you're still limited to one product type for your entire feed. You can't select by product or category. If you need to do that, you'll have to edit your feed file after it's generated.

[Rupert]

Got it,
thanks, in the configuration table.
You can add as many to the array as you like, but as you say, only one per feed :)
Manually editing mine.
Just not up to programming it myself.

[Woodymon]

Got it,
thanks, in the configuration table.
You can add as many to the array as you like, but as you say, only one per feed :)
Manually editing mine. Just not up to programming it myself.

If you want individual control over each product type entry for each product this is something that cannot be programmed into the mod. The programming has to occur in Zen Cart core as there is no standard product field in Zen Cart which supports different "product type" for each and every product

However the Zen Cart top-level category could be mapped to the feed product_type field. But then you would need to be certain your Zen Cart category names are exactly what you want in the feed product_type.And it gets tricky when you have many different levels of subcategories.

Or you can 'cheat' and employ the Short Description mod and use that filed as your "product_type and then in the mod itself update the code to read the short description data and that to the feed product_type.

Hoping future Zen Cart updates will support greater product_type flexibility, allowing shop-owners the ability to easily create their own custom product fields via the admin GUI.

Woody

[birdoasis]

WOW!

If you haven't loaded this mod, you're missing out in sales. My file was accepted yesterday and I've now had 6 sales from google base.

WOOT!

[CJ Internet Sales]

I need help loading this mod.

After loading it, and installing the SQL patch I see the configuration but not the Google Froogle Feeder in admin/tools.

I have unzipped the mod into the root of my store.

What am I doing wrong that I can't see the Google Froogle Feeder?

[Woodymon]

I need help loading this mod.
After loading it, and installing the SQL patch I see the configuration but not the Google Froogle Feeder in admin/tools. I have unzipped the mod into the root of my store. What am I doing wrong that I can't see the Google Froogle Feeder?

Do you happen to have the Admin Profiles mod installed? If yes, then see the readme for that mod.

If not, run the uninstall.sql sql patch for the GoogleFroogle mod, then run the googlefroogle.sql patch. If you observe any errors record them and post here (obfuscating any private info including your admin directory name, etc).

Woody

[CJ Internet Sales]

First, thank you very much for responding. I understand how important this tool is to the success of E-commerce sites. I have used a similar tool with a high-dollar cart to generate huge amount of traffic and sales with the sites I manage at my day job.

I do not have the Admin Profiles mod installed.

I ran the uninstall.sql patch. The return showed 4 statements processed in the green bar at the top of the page. No errors noted.

I then ran the googlefroogle.sql patch again. The return showed 8 statements processed in the green bar at the top of the page. No errors noted.

I then checked, no Google Froogle Feeder showing in admin/tools.

I then ran the uninstall.sql patch again.

I again downloaded from Zen Cart the mod and unzipped it into the root directory of my cart. I uploaded from my local drive to make sure the files were in the root directory of my store.

Still, I see the configuration portion but not the Google Froogle Feeder link in admin/tools.

I am questioning if I have the files downloaded into the correct directory. When I say root I mean the googlefroogle files were unzipped into http://www.mystore.com/ The way I am using Zen Cart is for my entite site. Therefore, the admin files are located at http://www.mystore.com/admin/ and the include directory is at http://www.mystore.com/includes/.

Do I have the files unzipped to the correct spot?

Any other suggestions as to how to fix the problem?

[Woodymon]

I do not have the Admin Profiles mod installed.

OK. For mod menu items to display when Admin Profiles is installed, a couple more steps are required. SO just checking.

Still, I see the configuration portion but not the Google Froogle Feeder link in admin/tools.

This is possibly due to a problem with Zen Cart Tools > Install SQL Patches not applying the correct table prefix. Many people have similar issues with many different mods, especially when "uploading" the patch code.

I am questioning if I have the files downloaded into the correct directory.

1. Avoid announcing real "admin" directory names in public. Best to change the "admin" directory name to something else as is explained in Zen Cart security docs.

2. It looks fine what you are doing in regards to directory structure.
googlefroogle.php mod file will go directly into your 'webroot' (which in your instance is the same as your 'shoproot'). Then the other mod files into three subdirectories off of your webroot.

3. Try patching with uninstall.sql again. Then open the googlefroogle.sql in a text editor and copy and then paste into Install SQL Patches, but do NOT upload. See if that makes a difference.

If not, then patch with uninstall.sql again. Then use phpmyadmin to patch. First make note of your shop DB table prefix, and edit the googlecheckout.sql with your table prefix.

By default, during installation, the prefix is set to "zen_", but some shopowners (like me) change the prefix at installation (or do away with the prefix).

There is a recent explanation how to edit mod SQL patch to deal with the table prefix issue in the "Tabbed Products Lite" mod thread (no need to edit each and every SQL statement with the table prefix).

Woody

[NamSingh]

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

[CJ Internet Sales]

2. It looks fine what you are doing in regards to directory structure.
googlefroogle.php mod file will go directly into your 'webroot' (which in your instance is the same as your 'shoproot'). Then the other mod files into three subdirectories off of your webroot.

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?