Google Base Feeder Support Thread [OLD]

help:

First my apologies to all because I don't understand anything with the setup it was done for me originally and all I know how to do is list items for the most part. So if I came across the answer to my question I didn't realize it in the week I have been searching for it because I don't understand the tech language or html etc at all. So apolozies for probably repeating something and needing to have help.

I thought I would not have a problem with the google changes because for example in my description of books I always include the ISBN # and for other things all info is in the description as well. However when I logged into my google base stuff I have things like books showing up they will be a problem.

The person that did my site for me has gone MIA with even a disconnected phone number so I can't get ahold of her.

I spoke to a few friends I know that have zen cart and each have said something different.

1. That the isbn and all new info needed cannot be put in the description it needs it's own box area

2. How to do the Manufactorer Name was explained to me so I can no add that to items. However I was told for books it cannot be used because it's titled Manufactorer Name and not Book Title or Author etc

3. Pertaining to above I was shown the space for the Manufactorer number. Again was told this can only be used for the MPN only that I can't put the ISBN or UPC or any other number in that area cause it's not titled the proper thing such as ISBN.

I was also told the opposite of what I have typed above. So my question I guess is can the ISBN or UPC go into the box labeled Manufactuerer number or is there something that needs to be done I don't know about or how to do to make those boxes appear? :frusty:

Thanks and apologies again

To get the "box" for the ISBN you will need to install the product fields mod:

http://www.numinix.com/zen-cart-modules/admin/numinix-product-fields

it's free to download. If you can't install, you can pay Numinex to do it. I'm not sure on what to do about your other question as I am waiting on a reply on something myself but I do know the ISBN field is in the product field mod. I have installed it and it's there. Good luck

Thank you Smurfy, all kinds of issues going on for some reason no links to numinix is working, it says it can't be found or that I'm not logged on the internet, obviously i am I am here and can get everywhere else lol.
I wouldn't even know where to download whatever it is and place it. If it gets downloaded into the Cpanel I have no idea about that at all the only thing that was given to me was my log in information for it. Since I know nothing at all about that I was advised to stay out of it.
As soon as I can figure out why the website won't open for me then maybe I can at least do a download somewhere lol
Hopefully it's obvious what download I need.
Thanks again

I get same error message:

1062 Duplicate entry 'GOOGLE_BASE_KEY' for key 'unq_config_key_zen'

My previous stable version no longer worked - 0 products accepted so had to upgrade.

Is there an easy way to create a XML data feed, or datafile for Google Merchant/Google Shopping? For some reason I am lost when it comes to this process.

I don't want to add 900+ products manually to an excel spreadsheet.

AshleyNG2:

Thanks for taking a look at it, let me know how you get along!
Cheers!!

Also, do you think its because I haven't installed the Numinix Product Fields which is why its throwing up that numinix_categories_check error?

1.9.0 version of Google Base Feeder is having all kinds of problems. I have installed and played around with it but I am unable to get all product included in the feed. The feed file is timing out before it finishes. I have no idea what is causing this at the present time. I have went back to version 1.8.3 for right now. Sorry I was not able to help you on this.

The error you were getting is because of the googlefroogle.php file not being updated in the root of your server when you updated from a earlier version.

PHP Fatal error: Call to undefined method google_base::numinix_categories_check() in ../public_html/googlefroogle.php on line 166

I was told by a programmer at Numinex that a new version that is supposed to help clear up some of the problems is going to come out next week.

Does Base feeder Not work with Salemaker?
I started a salemaker Campaign and the original prices are still showing in the feed.

I know someone said there is a new version coming out soon, but I managed to squash a couple of bigger bugs so I figured if people who are still trying to use 1.9.0 want them, I would share them.

First in googlefroogle.php in the root directory, around line 150 I changed the GROUP BY.

$products_query = "SELECT distinct(p.products_id), p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, pa.options_values_price" . $additional_attributes . "
                             FROM " . TABLE_PRODUCTS . " p
                               LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                               LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                               LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)"
                             . $additional_tables . 
                             "WHERE p.products_status = 1
                                AND p.products_type <> 3
                                AND p.product_is_call <> 1
                               AND p.product_is_free <> 1
                               AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
                             GROUP BY pd.products_name
                             ORDER BY p.products_id ASC" . $limit . $offset . ";";

to

$products_query = "SELECT distinct(p.products_id), p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, pa.options_values_price" . $additional_attributes . "
                             FROM " . TABLE_PRODUCTS . " p
                               LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                               LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                               LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)"
                             . $additional_tables . 
                             "WHERE p.products_status = 1
                                AND p.products_type <> 3
                                AND p.product_is_call <> 1
                               AND p.product_is_free <> 1
                               AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
                             GROUP BY p.products_id
                             ORDER BY p.products_id ASC" . $limit . $offset . ";";

This made most of my items start appearing in the xml (still not quite all of them though).

Then, to make the upload work I had to go into the googlefroogle.php file in the admin folder and around line 196 I had to wrap the GOOGLE_BASE_KEY in an echo statement.

<a href="#" onclick="window.open('<?php echo HTTP_SERVER . DIR_WS_CATALOG . FILENAME_GOOGLEFROOGLE; ?>.php?feed=fn_uy&upload_file=<?php echo $file; ?>&key=' . GOOGLE_BASE_KEY, 'googlefrooglefeed', 'resizable=1, statusbar=5, width=600, height=400, top=0, left=50, scrollbars=yes');">Upload</a>

to

<a href="#" onclick="window.open('<?php echo HTTP_SERVER . DIR_WS_CATALOG . FILENAME_GOOGLEFROOGLE; ?>.php?feed=fn_uy&upload_file=<?php echo $file; ?>&key=<?php echo GOOGLE_BASE_KEY; ?>', 'googlefrooglefeed', 'resizable=1, statusbar=5, width=600, height=400, top=0, left=50, scrollbars=yes');">Upload</a>

As for the SQL Error, I just ignored it and ran the rest of the file without that statement. I haven't had a problem with that.

Does anyone know how to make Ceon Advanced Shipper Config shipping work with the new changes Google is putting into place on having shipping and tax calculated?

The config for Google Merchant offers:

zones table rate
flat rate
per item
per weight unit
table rate
zones
percategory
free shipping
free rules shipping
none

I have "none" chosen. Default would be UPS Ground through the Ceon Advanced Shipper Config (this is how I want Google to calculate shipping). I have logged into the google merchant center online and updated our shipping to reflect UPS Ground but if you look up a product via google, our products do not have shipping showing up with them (and competitors do). Any ideas on how to make this work? I have the UPC and Brand Name area taken care of but this Shipping and Tax thing has me stumped

My web designer just updated my site to 1.3.9h. I asked her to re-install the modules I had before. One of them is the googlebase feeder.

She downloaded the lastest and told me it was installed. It appears to be but it isn't working as before.

I can create a feed but I can't upload it. I've looked through the install package to see if I see anything she missed but I don't. I also read threads for a few hours and can't find the exact problem.

When I create the feed, it shows me that is is getting all of my products and creates a the specified file:

/shop/feed/goodle/domain_products.xml

This is the same feed filename that I used before and I double checked my google to make sure that feed was defined.

When I run the update I get:
404: File not found

But I notice the header is looking for the file:

/shop//undefined

Where the word "undefined" is, shouldn't there be an actual file name? Also, the directory after shop is my admin directory where I logon, is that correct?

I did check and I have the file "googlefroogle.php" in the main /shop/ directory.

Does anyone have any ideas?

Thank you

Linda

has any one tried
Zen Cart Bing Data Feed buy magneticone

kevinmc3:

Ver 1.3.9c

will the current Google Feed files also work with submitting to BING data feed ?

gandalf88:

I know someone said there is a new version coming out soon, but I managed to squash a couple of bigger bugs so I figured if people who are still trying to use 1.9.0 want them, I would share them.

First in googlefroogle.php in the root directory, around line 150 I changed the GROUP BY.

$products_query = "SELECT distinct(p.products_id), p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, pa.options_values_price" . $additional_attributes . "
FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)"
. $additional_tables .
"WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
GROUP BY pd.products_name
ORDER BY p.products_id ASC" . $limit . $offset . ";";

> 
> to
> 
> ```php
$products_query = "SELECT distinct(p.products_id), p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, pa.options_values_price" . $additional_attributes . "
                             FROM " . TABLE_PRODUCTS . " p
                               LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                               LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                               LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)"
                             . $additional_tables . 
                             "WHERE p.products_status = 1
                                AND p.products_type <> 3
                                AND p.product_is_call <> 1
                               AND p.product_is_free <> 1
                               AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
                             GROUP BY p.products_id
                             ORDER BY p.products_id ASC" . $limit . $offset . ";";

This made most of my items start appearing in the xml (still not quite all of them though).

Then, to make the upload work I had to go into the googlefroogle.php file in the admin folder and around line 196 I had to wrap the GOOGLE_BASE_KEY in an echo statement.

<a href="#" onclick="window.open('<?php echo HTTP_SERVER . DIR_WS_CATALOG . FILENAME_GOOGLEFROOGLE; ?>.php?feed=fn_uy&upload_file=<?php echo $file; ?>&key=' . GOOGLE_BASE_KEY, 'googlefrooglefeed', 'resizable=1, statusbar=5, width=600, height=400, top=0, left=50, scrollbars=yes');">Upload</a>

> 
> to
> 
> ```php
<a href="#" onclick="window.open('<?php echo HTTP_SERVER . DIR_WS_CATALOG . FILENAME_GOOGLEFROOGLE; ?>.php?feed=fn_uy&upload_file=<?php echo $file; ?>&key=<?php echo GOOGLE_BASE_KEY; ?>', 'googlefrooglefeed', 'resizable=1, statusbar=5, width=600, height=400, top=0, left=50, scrollbars=yes');">Upload</a>

As for the SQL Error, I just ignored it and ran the rest of the file without that statement. I haven't had a problem with that.
iv got same problem as you, but when i put your info into the files
it seemed to not work at all
reverted back to orig files....

Hi,
in v1.91,
I was finding
a) some items descriptions were becoming 0 characters and so being omitted from the feed file and
b) debug errors in the cache:
PHP Warning: htmlentities() [<a href='function.htmlentities'>function.htmlentities</a>]: Invalid multibyte sequence in argument in D:\My Documents....\tienda\includes\classes\google_base.php on line 276

I found that it was symbols like the TM trademark and copyright that were crashing the google_base_sanita function.

So, in google_base.php
around line 277 look for

$str = html_entity_decode($str);
```and change it to

```php
$str = html_entity_decode($str, ENT_QUOTES, 'UTF-8');

Otherwise I find this version to work ok.

Hi just wondering how i would go about getting google to recognise my model numbers as UPC barcodes. currently have 317 warnings. strange thing is 2 items are absolutly fine. other than that i have only ever had 1 item show as "item to big error" module works great just google changing the rules.

hello guys,

My problem is that when I set up "Español" language on the Google Merchant Feeder Configuration and run up feeder tool I get a blank page. I had uploaded languages files to Spanish dir (includes and admin ones) but it does not work for me.

If I let default language configuration (English), I can run the tool but all products description in English are empty, so obviously no one product is saved to file.

Google Merchant Center Feeder v1.9.0 started 2011/05/06 17:01:16
Feed file - /home/tucachim/www/feed/google/domain_products.xml
Processing: Feed - Yes, Upload - No
id: 4, price: 10.9, description length: 0 - skipped, price below zero, description length less than 15 chars, or title less than 3 chars - failed

Google Merchant Center File Complete In 0.009620 Seconds 0 Records

Anyone knows how can I fix it?

Thanks!

First, my google base feed has been working flawlessly since I installed it almost two years ago. Thank you to the developers of this mod! Now, my issue, a minor but annoying one related to the new Google requirements. The shipping part is my problem right now, I'll worry about the product identifiers later.

I use calculated shipping on my site, both USPS and UPS. In order to fulfill the Google requirement for shipping to appear, I set it up in the merchant center as calculated since there is no option for calculated under select shipping method, (which I have set to none), in the Google Base Feeder Configuration.

Here is the issue: Much of what I sell is lightweight and can ship First Class Mail. There is no option for First Class in the Google merchant center shipping setup, so I had to select Priority Mail as the default, This means that the shipping costs showing in product search are way too high for many of my items that could ship First Class, and way off for heavy items that could ship UPS Ground.

Is there a mod available that adds calculated shipping as an option in the shipping method section for the feeder configuration?

OK I am back at this again - I have gotten all the other tweekings done to this upgrade but am have One H of a time getting the google froggle on this site - I have it on my primary site and it works great but the secondary site is not doing so well -

Also I have no Idea why it is listing Discover because I dont have discover listed as a card to accept.

this is what I get in the feed and of course Google will not accept it.

http://www.stitchnframeonline.com/windflowergrove/images/medium/incense_med.jpg

<g: payment_accepted>Discover</g: payment_accepted>

Ideas anyone - the feed is installed onto windflower grove folder.

My host provider limited my database bandwidth, therefore I need to set up a local server to generate the feed and then upload the XML file to the server.

I was wondering if the module can work locally and generate the XML file with the right path, or it has to be manually fixed, before uploading to the server ...

Now the file only generates 24k products from over 50k, so unless this is a module limitation ... I will try this approach.

First, make sure you are using the latest version 1.91.

My problem is that when I set up "Español" language on the Google Merchant Feeder Configuration and run up feeder tool I get a blank page. I had uploaded languages files to Spanish dir (includes and admin ones) but it does not work for me.No it wont work.
The code is written to use the language name as the directory,which is obviously not reliable.
The easiest fix is to change your language name to Spanish (case does not matter).

Or you can change the code:

1. admin/includes/functions/extra_functions/googlefroogle.php

change:

$languages = $db->execute("select code, name from " . TABLE_LANGUAGES);
$languages_array = array();
while (!$languages->EOF) {
$languages_array[] = array('id' => $languages->fields['name'],
'text' => $languages->fields['name']);
$languages->MoveNext();to
$languages = $db->execute("select code, name, directory from " . TABLE_LANGUAGES);
$languages_array = array();
while (!$languages->EOF) {
$languages_array[] = array('id' => $languages->fields['directory'],
'text' => $languages->fields['directory']);
$languages->MoveNext();2) catalog/google_froogle.php
change
$languages = $db->execute("select code, languages_id from " . TABLE_LANGUAGES . " where name='" . $language . "' limit 1");to
$languages = $db->execute("select code, languages_id from " . TABLE_LANGUAGES . " where directory='" . $language . "' limit 1");I have submitted this and and other suggestions to Numinix, don't know whether they will incorporate them.

In any case if you are not getting any products in your feed in english, you have another problem. and you should fix that first before playing around with the code - switch on the debug option in the feed config for more info when generating the feed and look in your cache directory for debug info if something is crashing the feed generation.

torvista:

Hi,
in v1.91,
I was finding
a) some items descriptions were becoming 0 characters and so being omitted from the feed file and
b) debug errors in the cache:
PHP Warning: htmlentities() [<a href='function.htmlentities'>function.htmlentities</a>]: Invalid multibyte sequence in argument in D:\My Documents....\tienda\includes\classes\google_base.php on line 276

I found that it was symbols like the TM trademark and copyright that were crashing the google_base_sanita function.

So, in google_base.php
around line 277 look for

$str = html_entity_decode($str);

> 
> ```php
$str = html_entity_decode($str, ENT_QUOTES, 'UTF-8');
```Otherwise I find this version to work ok.

This almost works. It corrects the  items and descriptions that were becoming 0 characters and so being omitted from the feed file, but the feed file still doesn't finish before it times out. Working on this.