Google Base Feeder Support Thread [OLD]

I have just been looking to install this myself, and to answer the previous poster, simply extract the folders overwriting your folders, all that will happen is the files in this installation will be created in their own folders.

However there is a problem the documentation states
Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql by copying and pasting (do not upload);

however there is NO googlefroogle.sql in the archive!!!!!

Just a series of sql updates of which there is no mention in the documentation either :(

Nor does it tell you in the documentation where to place the googlefroogle.php file!

Pauls:

However there is a problem the documentation states
Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql by copying and pasting (do not upload);

however there is NO googlefroogle.sql in the archive!!!!!

Just a series of sql updates of which there is no mention in the documentation either :(

Nor does it tell you in the documentation where to place the googlefroogle.php file!
in the version prier to 1.8 it was googlefroogle.sql, in his latest version its install.sql

If your referring to the googlefroogle.php outside the folders, admin, includes, then it should go to the root of your site.

davewest:

in the version prier to 1.8 it was googlefroogle.sql, in his latest version its install.sql

Why not update the documentation.html file to say "install.sql" instead of googlefroogle.sql. I always try to RTFM and follow it precisely :smile:

I've got a problem with shipping.

If I set it to use table rate it works fine, but unfortunately this is set up with the postage costs for European shipping while I want it to list GB shipping.

I have zones set up with the shipping for GB but if I select zones in the google base feeder it sets all delivery costs to 0?

Mule:

I've got a problem with shipping.

If I set it to use table rate it works fine, but unfortunately this is set up with the postage costs for European shipping while I want it to list GB shipping.

I have zones set up with the shipping for GB but if I select zones in the google base feeder it sets all delivery costs to 0?

Nevermind, I figured it out, I needed to set Table Zone ID to 1

Hi,
Google gives an error for the last week, i'm thinking they have changed their expiratin date format for the UK.

I get error "Expiration date is in the past" our date shows as 2010-11-07

Anyone know how i can change the format to read 2010-07-11

kamelion0927:

Alright - I've hit a wall. I've searched through this thread as well as the direct online thread (http ://www.numinix.com/forum/viewtopic.php?t=6) and can't find bumpkis. Someone did ask this question before but never followed up.

I know this is a long shot but what the :censored:.

I've got Tabbed Products Pro installed on my website which causes the description on my Google Products to display in an extremely funky manner.

I've noticed that Google is picking up more than 80 characters so I was hoping that someone would be able to help me limit the characters downloaded to the description portion of the XML file or even (better yet) think of a more efficient way around my issue (besides changing the description in the file before it's uploaded of course).

Thanks in advance!

I'm having a similar problem (searched this thread, but didn't see a solution) and now Google has started kicking out all of my products which have a 'Size Chart' tab because the descriptions are too long and contain HTML.

I know I could remove it and create a popup window or a separate page for all my size charts instead, but I really think it's much more buyer friendly if they can see ALL of the information in one window without having to navigate elsewhere.

Is there a way to limit the number of characters the feed pulls from the description?

Thanks!

Has there been an update to include the shipping fee?

anyone?

Ok, maybe I am just being blind, stupid, or both but when I try to run this I do not see any instructions and all I get at the top of the page is:

Google Merchant Center Feeder
Feed Type: Products
SQL Query Limit ##########___
SQL Query Offset ##########__

I have tried to play around with the SQL Query things by placing random numbers in it or leaving it blank.

All this mod does so far when I click the confirm button is open a new window that stays blank and that is it, doesnt create anything.

WeFoundEm:

Ok, maybe I am just being blind, stupid, or both but when I try to run this I do not see any instructions and all I get at the top of the page is:

Google Merchant Center Feeder
Feed Type: Products
SQL Query Limit ##########___
SQL Query Offset ##########__

I have tried to play around with the SQL Query things by placing random numbers in it or leaving it blank.

All this mod does so far when I click the confirm button is open a new window that stays blank and that is it, doesnt create anything.

I have the same issue, can anyone help?

I just re-installed it and it worked fine, I must of glitched something somewhere the first time thru.

oh yeah and you do NOT need to put anything into the two blanks, just hit confirm

Quote:
Originally Posted by WeFoundEm
Ok, maybe I am just being blind, stupid, or both but when I try to run this I do not see any instructions and all I get at the top of the page is:

Google Merchant Center Feeder
Feed Type: Products
SQL Query Limit ##########___
SQL Query Offset ##########__

I have tried to play around with the SQL Query things by placing random numbers in it or leaving it blank.

All this mod does so far when I click the confirm button is open a new window that stays blank and that is it, doesnt create anything.

I have the same issue, can anyone help?

I'm having the same issue. Installed twice and still unable to generate the feed.

HELP!!!!!

NSABaits:

I'm having the same issue. Installed twice and still unable to generate the feed.

HELP!!!!!
Make sure in /web-site-root/includes/.htacess that line 26 has the xsl|XSL included. If that does not work go to admin/configurations/google_base_feeder/configuration and turn on the debug to see what that tells you.

on line 26 you will find:
<FilesMatch ".*.(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF)$">

Change the line to:
<FilesMatch ".*.(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF|xsl|XSL)$">

Ok TAG mismatch for me was the length of my title, my title end CDATA ">" was not there or not fully there and caused the code to error... so shorten whatever ">" is missing and it should work...
might mean alot of changing unless someone can change the max length????:clap:

Recently google started limiting number of characters for product descriptions:

http://www.google.com/support/forum/p/base/thread?tid=256dc6ea3b147064&hl=en

I started getting these messages few weeks ago about some of my products and they were not getting listed:

"Error: Offer too big - Error
Your feed contains offers which are too big. These offers will be dropped."

I searched the forums and could not find a solution, so tried digging into it myself. I'm not sure what google's limit is, but I trimmed the description to 500 characters and it seemed to have worked. Here's what I did:

file googlefroogle.php (in the root directory):

added code to line #191 (version 1.8.2):

new code:
```php
if (strlen($products_description) > 500 ) {
$products_description = substr($products_description, 0, 500);
}
$products_description = $google_base->google_base_xml_sanitizer($products_description, true);

**old code: **

          ```php
    $products_description = $google_base->google_base_xml_sanitizer($products_description, true);

countrycharm:

Make sure in /web-site-root/includes/.htacess that line 26 has the xsl|XSL included. If that does not work go to admin/configurations/google_base_feeder/configuration and turn on the debug to see what that tells you.

on line 26 you will find:
<FilesMatch ".*.(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF)$">

Change the line to:
<FilesMatch ".*.(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF|xsl|XSL)$">

I had a similar issue with the blank page issue and tried this but to no avail. Has anyone figured out how to fix this?

Hi there

We have google base feeder working on our site, but I am currently adding products using the music product type. Our existing products are all the of the 'general' type. When I generate the feed however, any music products are not included... From what I can find on the forums, it seems like you can only have one product type in the feed - is this correct? Or have I missed something else?

This is really important for us, as we need to utilise the music products to give extra functionality to our products (wallpaper). Is there any way of having all products included in the feed?

Category using music product types: http://www.davieswallpapers.com/designer-wallpaper/index.php?main_page=index&cPath=1_7_12_649

Category using general product types: http://www.davieswallpapers.com/designer-wallpaper/index.php?main_page=index&cPath=160_164

We are using Zen version: 1.3.8a

Any help would be greatly appreciated.

Sara

sajiepaj:

Hi there

We have google base feeder working on our site, but I am currently adding products using the music product type. Our existing products are all the of the 'general' type. When I generate the feed however, any music products are not included... From what I can find on the forums, it seems like you can only have one product type in the feed - is this correct? Or have I missed something else?

This is really important for us, as we need to utilise the music products to give extra functionality to our products (wallpaper). Is there any way of having all products included in the feed?

Category using music product types: http://www.davieswallpapers.com/designer-wallpaper/index.php?main_page=index&cPath=1_7_12_649

Category using general product types: http://www.davieswallpapers.com/designer-wallpaper/index.php?main_page=index&cPath=160_164

We are using Zen version: 1.3.8a

Any help would be greatly appreciated.

Sara
Ok I think I've sorted this out - was looking for something far more complicated than was actually there!! I've now done a feed with all the products included:-)

Thanks anyway.