Google Base Feeder Support Thread [OLD]

kashyyyk:

I'm using v1.3.9h and just upgraded to google feed 1.10.1

In the configuration, when I update all my info I'm having a problem with Shipping Country, when I click on it, the Title Value Action headers fill the whole page, the area where I would edit is gone. All the other entries are fine.

I just checked my debug and I'm getting
[14-Jul-2011 02:16:54] PHP Fatal error: Call to undefined function google_cfg_pull_down_country_list() in /configuration.php(179) : eval()'d code on line 1

Dan

You can fix this by editing your admin/includes/functions/extrafunctions/googlefroogle.php

Add this:

if (!function_exists('google_cfg_pull_down_country_list')){
	function google_cfg_pull_down_country_list($countries_id, $key = '') {
		global $db;
		$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
		$countries = $db->execute("select countries_id, countries_iso_code_3 from " . TABLE_COUNTRIES);
		$countries_array = array();
		while (!$countries->EOF) {
			$countries_array[] = array('id' => $countries->fields['countries_id'],
				'text' => $countries->fields['countries_iso_code_3']);
			$countries->MoveNext();
		}
		return zen_draw_pull_down_menu($name, $countries_array, $countries_id);
	}
} 

Which this mode was capable of auto mapping ISO-8859-1 to UTF-8! And also listing all product that were simply skipped. Would make finding issues with the cleaner easier.

Hello,

I'm using ZC1.3.9h and this contribution to upload feeds to froogle. I've installed the UPC mod from Numinix and in the Admin-Categories/Products there are fields to enter UPC code. The problem I guess is that I have over 14000 products and I'm wondering if there is a faster way to upload all the UPC (for example Easy Populate) into the database? Has someone else encountered this problem and figured out a solution? Please advise. Any help will be appreciated.

Thanks:unsure:

kman55:

Hello,

I'm using ZC1.3.9h and this contribution to upload feeds to froogle. I've installed the UPC mod from Numinix and in the Admin-Categories/Products there are fields to enter UPC code. The problem I guess is that I have over 14000 products and I'm wondering if there is a faster way to upload all the UPC (for example Easy Populate) into the database? Has someone else encountered this problem and figured out a solution? Please advise. Any help will be appreciated.

Thanks:unsure:

Kman,

You can use my custom version of EasyPopulate to do this:

https://github.com/chaddro/EasyPopulate-4.0

It will install along site of other versions of EP without requiring you to uninstall them. You must use OpenOffice to edit/export your CSV file. (Excel does funky things with end-of-lines.) Send me a note if you need any help. Be sure to backup your store/databases before using or test on a copy of your site! Does a lot more than EP, with a lot less bugs :p ... still in Beta so test carefully!

-cj

P.S. Before I forget, be sure to set your products_upc column as TEXT! This way you won't loose leading '0' zeros on some UPC's.

And, NO, I haven't added products_ISBN, but it could be done easily.

My googlebase feeds (both version 1.8.2) have been working fine for ages on 2 zencart 1.3.9h websites.

Both feeds seem to have expired so I uploaded the files to googlebase and am getting a "Missing required attribute: id" error message on both files and no products are getting uploaded to googlebase.

Thinking id was a field that google now requires and noticing that there is now a version 1.9.1 of Google Base Feeder. I upgraded to version 1.9.1 on one of the zencarts. Now I am only getting 25% of my data accepted as it is saying that description length is 0 and then it is still rejecting these records with "Missing required attribute: id"
when loaded to googlebase.

just looking at the new feed requirements there is a google_product_category and a product_type now required by google.

These seem to take a breadcrumbe feed from your category list, but google seems to hint at the product_category needs to fall into their classification

http://www.google.com/support/merchants/bin/answer.py?answer=160081

can anyone clarify how strict google are going to be and how to get this tag into the feed as I don't think this is covered by this module. I can see that the product _type is generated.

Google also talk about sales prices and specials as having its own attribute tag for their feed, but I am not sure which is put into the feed or if specials are put into a separate feed.

Sorry couple of more tweaks I think will be needed. Firstly for clothes the colour, size and material is being asked for. Could this be pulled from stock by attribute data in some way. Also quantity has been retired (to use googles words) but availability is now needed with only 4 possible options.

Is anyone working on these or got any thoughts on how to get them into the xml feed correctly?

I am wondering the same thing as I am in apparel. I will need these attributes for the new requirements. Is Numinix planning an upgrade to include these in the product fields mod or is this something that can be altered in the current edition?

chadderuski:

You can fix this by editing your admin/includes/functions/extrafunctions/googlefroogle.php

Add this:

if (!function_exists('google_cfg_pull_down_country_list')){
function google_cfg_pull_down_country_list($countries_id, $key = '') {
global $db;
$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
$countries = $db->execute("select countries_id, countries_iso_code_3 from " . TABLE_COUNTRIES);
$countries_array = array();
while (!$countries->EOF) {
$countries_array[] = array('id' => $countries->fields['countries_id'],

'text' => $countries->fields['countries_iso_code_3']);
$countries->MoveNext();
}
return zen_draw_pull_down_menu($name, $countries_array, $countries_id);
}
}

>  
> Which this mode was capable of auto mapping ISO-8859-1 to UTF-8! And also listing all product that were simply skipped. Would make finding issues with the cleaner easier.


Mine had this, this is what is there -

if (!function_exists('google_cfg_pull_down_currencies')){
function google_cfg_pull_down_currencies($currencies_id, $key = '') {
global $db;
$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
$currencies = $db->execute("select code from " . TABLE_CURRENCIES);
$currencies_array = array();
while (!$currencies->EOF) {
$currencies_array[] = array('id' => $currencies->fields['code'],
'text' => $currencies->fields['code']);
$currencies->MoveNext();
}
return zen_draw_pull_down_menu($name, $currencies_array, $currencies_id);
}
}

if (!function_exists('google_cfg_pull_down_country_iso3_list')){
function google_cfg_pull_down_country_iso3_list($countries_id, $key = '') {
global $db;
$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
$countries = $db->execute("select countries_id, countries_iso_code_3 from " . TABLE_COUNTRIES);
$countries_array = array();
while (!$countries->EOF) {
$countries_array[] = array('id' => $countries->fields['countries_id'],
'text' => $countries->fields['countries_iso_code_3']);
$countries->MoveNext();
}
return zen_draw_pull_down_menu($name, $countries_array, $countries_id);
}
}

if (!function_exists('google_cfg_pull_down_languages_list')){
function google_cfg_pull_down_languages_list($languages_id, $key = '') {
global $db;
$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
$languages = $db->execute("select code, name, languages_id from " . TABLE_LANGUAGES);
$languages_array = array();
while (!$languages->EOF) {
$languages_array[] = array('id' => $languages->fields['languages_id'],
'text' => $languages->fields['name']);
$languages->MoveNext();
}
return zen_draw_pull_down_menu($name, $languages_array, $languages_id);
}
}

I had over 1400 items and the next day 3 items after upgrading to 1.10.1

Dan

Is there any way to check to see why my UPC codes are not coming up in the xml feed. I have it installed and set to True in configuration.

:oops: I know i am missing something here. Finally got this app and Numinix Product fields installed and working. Now with all the changes to what Google is going to require in September I'm wondering if this was in vain.

If a product is priced by attributes and you cannot add a UPC to each product attribute, are the products going to be Google compliant? An example of this would be a flavor of cat food that comes in a 5 oz size and a 3 oz size. Each one has a different UPC. I have each of those as a product attribute and also the same items as cases priced through attributes.

http://www.wholesomehound.com/index.php?main_page=product_info&cPath=2_155&products_id=1387

Will I indeed be forced to set all four of these attributes up as individual products to be Google compliant with a separate UPC since the only place you can enter a UPC is in the Product page?

Is there something I missed?:huh:

Just wanted to bring this back up. Same issue. Can the numinix contribution be manually edited to take care of these things? Will need to add color and other options for Google. Any input / instructions would be appreciated.

Sorry couple of more tweaks I think will be needed. Firstly for clothes the colour, size and material is being asked for. Could this be pulled from stock by attribute data in some way. Also quantity has been retired (to use googles words) but availability is now needed with only 4 possible options.

Is anyone working on these or got any thoughts on how to get them into the xml feed correctly?

toyseller:

"Missing required attribute: id"
when loaded to googlebase.

This is simple. Go to configuration > Google Base Configuration > Show Offer ID > Set to 'ID'

I'm hoping someone could help me with my Froogle feed...

I have had everything work fine up until recently... I HAD about 78,000 products and the feed worked fine. I could see any/all errors in the debug window. However, I have since added more products and my total is now over 130,000. The debug window is blank, and when finished the url at the top of the window reads "limit=&offset" which led me to believe that it was timing out. The feed stops anywhere between 40-60k products now.

I originally uninstalled and reinstalled the merchant center addon. No luck. I then edited googlefroogle.php accordingly and set timeouts= 0. Still no luck... The debug window still reads blank, seems to timeout, and I am no longer getting all of my products.

Does anyone have any suggestions? I have searched the thread and can find nothing conclusive.. :blink:

Boatersplanet:

I'm hoping someone could help me with my Froogle feed...

I have had everything work fine up until recently... I HAD about 78,000 products and the feed worked fine. I could see any/all errors in the debug window. However, I have since added more products and my total is now over 130,000. The debug window is blank, and when finished the url at the top of the window reads "limit=&offset" which led me to believe that it was timing out. The feed stops anywhere between 40-60k products now.

I originally uninstalled and reinstalled the merchant center addon. No luck. I then edited googlefroogle.php accordingly and set timeouts= 0. Still no luck... The debug window still reads blank, seems to timeout, and I am no longer getting all of my products.

Does anyone have any suggestions? I have searched the thread and can find nothing conclusive.. :blink:

Do you have this in your store root's googlefroogle.php?

  /* configuration */
  ini_set('max_execution_time', 900); // change to whatever time you need
  ini_set('mysql.connect_timeout', 300); // change to whatever time you need
  ini_set('memory_limit','128M'); // change to whatever you need
  set_time_limit(900); // change to whatever time you need
  $keepAlive = 100;  // perform a keep alive every x number of products
  /* end configuration */

kidsstuff:

Do you have this in your store root's googlefroogle.php?

/* configuration /
ini_set('max_execution_time', 900); // change to whatever time you need
ini_set('mysql.connect_timeout', 300); // change to whatever time you need
ini_set('memory_limit','128M'); // change to whatever you need
set_time_limit(900); // change to whatever time you need
$keepAlive = 100; // perform a keep alive every x number of products
/ end configuration */

The file is located in the root directory. I modified it, so it now reads:

/* configuration /
ini_set('max_execution_time', 0); // change to whatever time you need
ini_set('mysql.connect_timeout', 0); // change to whatever time you need
ini_set('memory_limit','128M'); // change to whatever you need
set_time_limit(0); // change to whatever time you need
$keepAlive = 100; // perform a keep alive every x number of products
/ end configuration */

Updated from v1.7.4 uploaded/overwrite all files. done! Using Zen 1.3.9h
When I try to install sql patch 1.9.0 it get this error:

"1062 Duplicate entry 'GOOGLE_BASE_KEY' for key 2
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Security Key', 'GOOGLE_BASE_KEY', @security_key, 'Enter a random string of numbers and characters to ensure only the admin accesses the file', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Included Manufacturers', 'GOOGLE_BASE_POS_MANUFACTURERS', '', 'Enter manufacturer ids separated by commas
(i.e. 1,2,3)
Leave blank to allow all categories', @configuration_group_id, 31, NOW(), NULL, NULL), (NULL, 'Excluded Manufacturers', 'GOOGLE_BASE_NEG_MANUFACTURERS', '', 'Enter manufacturer ids separated by commas
(i.e. 1,2,3)
Leave blank to deactivate', @configuration_group_id, 31, NOW(), NULL, NULL), (NULL, 'Display Tax', 'GOOGLE_BASE_TAX_DISPLAY', 'false', 'Display tax per product? (US only)', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Tax Country', 'GOOGLE_BASE_TAX_COUNTRY', 'US', 'The country an item is taxed in', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Tax Region', 'GOOGLE_BASE_TAX_REGION', 'CA', 'The geographic region that a tax rate applies to, e.g., in the US, the two-letter state abbreviation, ZIP code, or ZIP code range using * wildcard (examples: CA, 946*)', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Tax Rate', 'GOOGLE_BASE_TAX_RATE', '5.00', 'Enter the percentage as a decimal number (without "%" symbol)', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Tax on Shipping', 'GOOGLE_BASE_TAX_SHIPPING', 'n', 'Boolean value for whether you charge tax on shipping, y for yes or n for no - the default value is n', @configuration_group_id, 22, NOW(), NULL, 'zen_cfg_select_option(array('y', 'n'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

Any help advice would be greatly appreciated. Thank you

read this post http://www.zen-cart.com/forum/showpost.php?p=1044802&postcount=2816

Thank you, got it.

Boatersplanet:

I'm hoping someone could help me with my Froogle feed...

I have had everything work fine up until recently... I HAD about 78,000 products and the feed worked fine. I could see any/all errors in the debug window. However, I have since added more products and my total is now over 130,000. The debug window is blank, and when finished the url at the top of the window reads "limit=&offset" which led me to believe that it was timing out. The feed stops anywhere between 40-60k products now.

I originally uninstalled and reinstalled the merchant center addon. No luck. I then edited googlefroogle.php accordingly and set timeouts= 0. Still no luck... The debug window still reads blank, seems to timeout, and I am no longer getting all of my products.

Does anyone have any suggestions? I have searched the thread and can find nothing conclusive.. :blink:

Any ideas....? I used to be able to export about 70,000 products. Now when I try to export even 20,000 products the debug window is blank, and it seems to timeout. Please Help!

Boatersplanet:

Any ideas....? I used to be able to export about 70,000 products. Now when I try to export even 20,000 products the debug window is blank, and it seems to timeout. Please Help!

I had the same problem with the new versions also timing out, so I rolled back to 1.8.3 the stable version until someone comes up with a solution.