Google Base Feeder Support Thread [OLD]

anyone?

v10.1
I found that accented characters were being corrupted on my hosting (linux, php 5.2) server and not on any test (windows PHP5.3) machines.

To fix this
in google_base.php in the infamous (to me anyway) google_base_sanita function

find```php
if (phpversion() >= 5.3) {
$str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');
} else {
$str = htmlentities($str);
}
return $str;

```php
      if (phpversion() >= 5.3) {
        $str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');//ENT_IGNORE silently deletes an invalid character
      } else {
        $str = htmlentities($str, ENT_QUOTES, 'UTF-8');//Not having ENT_IGNORE returns an empty string if containing an invalid character
      }
      return $str;

torvista:

v10.1
I found that accented characters were being corrupted on my hosting (linux, php 5.2) server and not on any test (windows PHP5.3) machines.

To fix this
in google_base.php in the infamous (to me anyway) google_base_sanita function

find```php
if (phpversion() >= 5.3) {
$str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');
} else {
$str = htmlentities($str);
}
return $str;

> 
> ```php
      if (phpversion() >= 5.3) {
        $str = htmlentities($str, ENT_QUOTES | ENT_IGNORE, 'UTF-8');//ENT_IGNORE silently deletes an invalid character
      } else {
        $str = htmlentities($str, ENT_QUOTES, 'UTF-8');//Not having ENT_IGNORE returns an empty string if containing an invalid character
      }
      return $str;

Is that a fix for general ampersands commas signs etc or just accents. I have just entered a couple of hundred products and its not reading the descriptions of any. Example below:

EDIT Now that I have pasted it here I see all the ##, those are spaces in the originals, is that the problem? how can I fix it without edting all the products

LED’s work on a set colour wave length, so if a white bulb is placed in a green
lens it will usually result in a blue-ish light. Therefore it’s important that a direct
colour replacement LED light bulb, ie. green for green, red for red, and white
for white is used.##<div>Shock resistant##</div><div>Produce only a small amount of heat when in use.##</div><div>Use only a fraction of the power used by the standard navigation light bulb##</div><div>Direct BAY15D replacement, can be used in most types of navigation lights.
Offset bayonet fitting with both positive and negative connections through base.##</div><div>Because of this, they will only work one way, so, if after fitting them they do not light, simply change over the + and - terminals in the light fitting.
Fitting the bulb with the terminals the wrong way round will not damage the LED
light bulb.</div><div><br /></div><div><u><b>Buy all 3 colours for only £29.00</b></u></div><div> </div><div>20 LED direct replacement navigation light bulb.##

Altered it now, got rid of the spaces (###) and divs got rid of the / and it still comes back with 0 description

LED’s work on a set colour wave length, so if a white bulb is placed in a green
lens it will usually result in a blue-ish light. Therefore it’s important that a direct colour replacement LED light bulb, ie. green for green, red for red, and white for white is used.<br />Shock resistant<br />Produce only a small amount of heat when in use.<br />Use only a fraction of the power used by the standard navigation light bulb<br />Direct BAY15D replacement, can be used in most types of navigation lights.
Offset bayonet fitting with both positive and negative connections through base.<br />Because of this, they will only work one way, so, if after fitting them they do not light, simply change over the + and - terminals in the light fitting.
Fitting the bulb with the terminals the wrong way round will not damage the LED
light bulb.<br /><br /><u><b>Buy all 3 colours for only £29.00</b></u><br /><br />20 LED direct replacement navigation light bulb.<br />Life expectancy 80,000 - 100,000 hours<br />Power Draw 1.5 Watts<br />Light output 60 Lm - 20 Watts approx<br />Fitting BAY15D<br />Voltage Rating 12 or 24 volts DC<br /><br />Dimensions:<br />Height 55-60mm<br />Diameter<br />Bulb 25mm<br />Base 15mm<br /><br />Light Colours:<br />White<br />Red<br />Green

Well after a couple of hours playing with this, I really dont understand it at all. The word lens caused it to fail, that is until I deleted it and typed it in then it passed. Pasted a few more words in and it failed again. What is so difficult with this??

I would like to get this contribution back on my site. I had not upgraded from google base 1.3.7a apparently, never used it for a long time.

I have Zen 1.3.9h, went back and found the sql unistall for 1.3.7a beings all the updates seem to not go back that far. I backed up,
copied the uninstall into admin and ran, but google still shows in my admin for the settings.

Based on what I am reading, I think I should install 1.3.91 for now until some changes are updated, is that sound ok?
Then does anyone think that my new store can just take the new files ( I never merged the php over) and copy up just the new SQL? Or how would I update SQL?

Or is that pesky admin setting that still show up mean I may mess up my DB?:unsure:

Justwade:

Or is that pesky admin setting that still show up mean I may mess up my DB?:unsure:

If you are talking about the settings under configuration, the install sql will probably not run completely. The only way to completely rid yourself of that is to go into the database itself.

Using phpmyadmin or similar interface, first, look at your configuration groups table and find the one for the feeder. Note the group id for it.

Then go to the configuration table. Do a search for that group id and then delete what shows up. You can also then delete that group id in the groups table.

Suggestion though: also do a search in the config table for a group id of 0. If you have results, check to see if any of those look like they are for the feeder. If so , delete them. If you have others, they also may need deleting. Having a group id of 0 means those settings don't show up in the admin and are usually from botched installs. I have had to do this for the google feeder install before.

delia:

If you are talking about the settings under configuration, the install sql will probably not run completely. The only way to completely rid yourself of that is to go into the database itself.

Using phpmyadmin or similar interface, first, look at your configuration groups table and find the one for the feeder. Note the group id for it.

Then go to the configuration table. Do a search for that group id and then delete what shows up. You can also then delete that group id in the groups table.

Suggestion though: also do a search in the config table for a group id of 0. If you have results, check to see if any of those look like they are for the feeder. If so , delete them. If you have others, they also may need deleting. Having a group id of 0 means those settings don't show up in the admin and are usually from botched installs. I have had to do this for the google feeder install before.

Actually there is a way to get rid of all the configurations by running these 3 SQL scripts in admin/tools/install_sql+patches.

Run these first

DELETE FROM configuration WHERE configuration_key LIKE 'GOOGLE_BASE%'; 
DELETE FROM configuration WHERE configuration_key LIKE 'GOOGLE_FROOGLE%';

Then

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

Then install whatever version of google base you are trying to install.

Dang - much easier! Thanks. I get heavily involved in fixing carts so tent to go further than the average bear might!

v 1.9.1

I have this running as a cron job:

http://www.mysite.com/googlefroogle.php?feed=fy_uy_tp&key=MYKEY

I receive this line in an email on execution of the cron job:

<p>Incorrect key supplied!</p>

I checked and double checked the key value in admin against the key parameter value in the cron job, and it's the same. I then changed the value on both to a new key, and I still get the error.

Hi
if you use any other feed language otherr than english the output file is not created or updated and the popup window is balnk.

Any help would be really appreciated

I have a problem with max products.

I have 24000 products, so set the max products to 30000 but it wont do more than just over 10000.

here is the example

Google Merchant Center File Complete In 63.748202 Seconds 10057 of 21786 Records

why only 10057???

fakeDecoy:

v 1.9.1

I have this running as a cron job:

http://www.mysite.com/googlefroogle.php?feed=fy_uy_tp&key=MYKEY

I receive this line in an email on execution of the cron job:

I checked and double checked the key value in admin against the key parameter value in the cron job, and it's the same. I then changed the value on both to a new key, and I still get the error.

The only way I have been able to get the cron job to run is to comment out the key line:

if ($key != GOOGLE_PRODUCTS_KEY) exit('<p>Incorrect key supplied!</p>');

in googlefroogle.php in the root directory.

caios:

I have a problem with max products.

I have 24000 products, so set the max products to 30000 but it wont do more than just over 10000.

here is the example

Google Merchant Center File Complete In 63.748202 Seconds 10057 of 21786 Records

why only 10057???

Lots of answers to that. It's not about the max numbers but about your products. Turn on debugging in the configuration will tell you something such as 0 quantities or other reasons your products aren't exporting.

I'm assuming you are using the most recent version? 1.10.1

Mcgill - that's probably your problem with the language.

"Mcgill - that's probably your problem with the language. "
Yeah but isn't the program supposed to be multi language?

There was a language bug before. If you don't have the most recent one installed, that could be your problem.

Heres a clue .. If I strip this out of googlefroogle,php it works but the text is wrong in the popup

require(zen_get_file_directory(DIR_WS_LANGUAGES . strtolower(GOOGLE_FROOGLE_LANGUAGE) .'/', 'googlefroogle.php', 'false'));

anybody see whats wrong with it?

I have the latest of everything its a complete new install

Theres nothing wrong with the code. The solution is so easy I'm too embarrassed to write it:blush:

Hi guys I've uploaded my file 3 times and keep getting this error message from google
Invalid attribute: shipping (16 errors)
The value that you provided for the attribute is invalid.
Examples:
Item Nr. Item ID Line No.
1 1 21
3 3 55
8 8 138
9 9 155
10 10 172

Invalid attribute: price (16 errors)
The value that you provided for the attribute is invalid.
Examples:
Item Nr. Item ID Line No.
4 4 66
11 11 183
12 12 199
14 16 232
15 17 249

I've checked and my products are priced
and I offer free shippng on everything
so what the :censored: do google want

delia:

Lots of answers to that. It's not about the max numbers but about your products. Turn on debugging in the configuration will tell you something such as 0 quantities or other reasons your products aren't exporting.

I'm assuming you are using the most recent version? 1.10.1

Mcgill - that's probably your problem with the language.

Thanks, the problem was that Im an idiot............

It doesnt export items which are out of stock, obvious I suppose!