Google Base Feeder Support Thread [OLD]

buildingblocks:

well as far as touching any modifications: the googlebase mod file names all begin with google so the mod files shouldn't touch any modifications of the cart itself.

Of course look at all the file names and use your own judgement.

Regarding the sql updates. If ever there is an uninstall sql, that is what I always go with. I uninstall and then install the newest sql.

The googlebase mod versions on my pc all have an uninstall file so check the files for the version you are using to see if you have an uninstall.sql.

And again use your own best judgement and always make a backup of your database and your store before you do anything.

well I have an issue with that...I dont have the orginal version of the mod i installed anymore. It was lost in a earlier pc issue.

I know this version has an uninstall, does anyone know if this would uninstall prior versions as well?

andreitero:

Has anyone else got an email from Goggle about the changes made to include the shipping charges?

"An alternate way to submit shipping information is to include item-level values for the new shipping attribute in your data feed.
These values will override any account-level default values that you have set for that item.
More information on formatting the revised SHIPPING attribute, please visit http://www.google.com/support/merchants/bin/answer.py?answer=160085&hl=en_GB#shipping"

no i havent, but it seems google doesnt always send out everything to everyone. Ive seen ppl say they get all kinds of things and i have never seen them.

As far as shipping charges, that would be a hard item to include for most companies. Myself, I only use UPS and only offer ground, but for a company that offers multiple forms of shipping and different options I dont see how they could do any form of default values for shipping.

I guess that is until Google has ppl create user profiles with "their" favorite form of shipping. lol

I just had the following email from Froogle:

*Hello,

Thank you for participating in Google Product Search. We are reaching out to you to inform you of updates to the Tax & Shipping settings tab located under "Settings" in your Google Merchant Center account. On this tab you will be able to set shipping values for your items on Google Product Search. We will soon be displaying this information on Google Product Search to provide buyers with important price information. This email provides an overview of the submission process in order to help you provide this data.

==================================================

HOW TO SET SHIPPING VALUES IN YOUR GOOGLE MERCHANT CENTER ACCOUNT

You have two options to set SHIPPING for your products:

1. Specify a flat shipping rate (or free shipping).
2. Define custom tables if the shipping rate you charge varies by price, weight, or number of items. Note: If you define a table based on the number of items, for now, we will use the rate in the first row only.
   If you use the weight-based table option, please be sure to include the SHIPPING_WEIGHT attribute. More information on formatting the SHIPPING_WEIGHT attribute can be found here: http://www.google.com/support/merchants/bin/answer.py?answer=160085&hl=en#shipping%20weight

==================================================

HOW TO SET SHIPPING VALUES VIA DATA FEEDS OR GOOGLE BASE API

An alternate way to submit shipping information is to include item-level values for the new shipping attribute in your data feed.
These values will override any account-level default values that you have set for that item.
More information on formatting the revised SHIPPING attribute, please visit http://www.google.com/support/merchants/bin/answer.py?answer=160085&hl=en_GB#shipping

For more information on shipping, please visit our Help Center at
http://www.google.com/support/merchants/bin/answer.py?hl=en&answer=160162

Sincerely,

The Google Product Search Team
*

Does this mean there needs to be some coding changed in the core files of this mod in order to output shipping tables to the xml data feed?

hmm, well luckily for myself we only use one option. I set the default shipping method to that and have not had to change it.

Have you already set that option in the merchant center to what you already use?

if so, you wouldnt have to worry about code as its already entered on their end. that may be the easiest way to handle the question anyway. Im just not sure what would change if you entered more than one. I know it asks for a default, it will probably just display that no matter what you enter there...

fusionsp:

well I have an issue with that...I dont have the orginal version of the mod i installed anymore. It was lost in a earlier pc issue.

I know this version has an uninstall, does anyone know if this would uninstall prior versions as well?

looks like you can still 1.7.1a here

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=473

just look in the list to find your version

buildingblocks:

looks like you can still 1.7.1a here

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=473

just look in the list to find your version

:huh:

yes thats the version I have. Im not sure I understand what you mean by look in the list for my version. I backed up my files and I think Im going to attempt a plain update since my version is a few behind.

assuming i understand code, i would think that if i followed the update directions and uploaded all new files and overwrote old...and then applied the most current .sql update it should correct all in between updates that i have missed.

since the new files and new sql patch will have all files associated with it. and any un needed lines will be forgotten...?

hello, I successfully got my host to add this cron job to my site. Right now it is uploading the feed every day (do you think this is too often?)

The problem I see now is that I have a list of googlefroogle.php?feed=fy_uy_tp.## files in my root directory. It seems that every time it uploads it is creating a new file. Does anyone know how to avoid this?

iscatech:

hello, I successfully got my host to add this cron job to my site. Right now it is uploading the feed every day (do you think this is too often?)

The problem I see now is that I have a list of googlefroogle.php?feed=fy_uy_tp.## files in my root directory. It seems that every time it uploads it is creating a new file. Does anyone know how to avoid this?

well, I see that you have your host to do this job. I have google fetching it for me on their scheduling area. I found this easier as I had issues attempting to have my host do it.

And..I have mine updating every day as well. My wife will go through and update our website products every few day swith on hands, active products, etc. I found it easier to just do it every day instead of having to do it every single time we update so it minimizes the 404 errors.

I also just have a cron job setting up my google feed to run and create the feed daily. then its made sure its accurate. Then when google fetch the file, their just pulling that file.

It sounds llike your host is renaming the file every time. and not to overwrite the file. So....changing it to do it like i have may correct your issues.

fusionsp:

well, I see that you have your host to do this job. I have google fetching it for me on their scheduling area. I found this easier as I had issues attempting to have my host do it.

And..I have mine updating every day as well. My wife will go through and update our website products every few day swith on hands, active products, etc. I found it easier to just do it every day instead of having to do it every single time we update so it minimizes the 404 errors.

I also just have a cron job setting up my google feed to run and create the feed daily. then its made sure its accurate. Then when google fetch the file, their just pulling that file.

It sounds llike your host is renaming the file every time. and not to overwrite the file. So....changing it to do it like i have may correct your issues.

fusion - thanks for the reply. I had already set up Google to retrieve my data feed through the Google Merchant Center, but it didn't seem to be working, so that's why I went this route. Maybe I should figure out how to make that work and cancel the cron job setup through the host.

The URL I had listed was: "http://www.iscatech.com/googlefroogle.php?feed=fy_un_tp" is that right?

iscatech:

The URL I had listed was: "http://www.iscatech.com/googlefroogle.php?feed=fy_un_tp" is that right?

well i guess it depends...is that the URL you had listed for google to fetch your products or was it for your host?

you have to also add a command for your host. Remember in the directions..

To run it as a cron job (i.e. at 5:00am), put something in your crontab like the
following:

0 5 * * * GET http://your_http_catalog/googlefroogle.php?feed=fy_uy_tp
or
0 5 * * * wget http://your_http_catalog/googlefroogle.php?feed=fy_uy_td
or
0 5 * * * curl -s http://your_http_catalog/googlefroogle.php?feed=fy_uy_tn

You have to add the GET or something similar to tell your host what to do with the job.

If you were trying to have google do it then thats also wrong with google you just direct it to the file location. Do not include anything else.

ie; http://www.fusionspiritualemporium.com/feed/YOUR FEED NAME_products.xml

Hope this helps.

Now Im having a new issue. I finally was able to have the time to update my module and now its not creating any records?

Google Base File Complete In 2.742825 Seconds 0 Records

I uploaded and overwrote the files, installed the current patch, and set all the configurations back. It was working fine before, ONLY reason I messed with it is to include the UPC/ISBN data.

Is there something in the files I also need to set now?

alright, I figured out my first issue..lol, I dont have qty on my site and I missed that setting. But now its skipping a few products due to the desc field less than 15 char and it has a product ID of which one it skipped. So, is there a way to search by product ID and figure out which ones have the issue??

OK nevermind. I remembered I needed to download my database file to look through it. It would be really nice if Zencart had that option built in to search by the product it that it assigns and not just by model. Seems like a lot of modules and other things use that ID number and its odd that you cant look it up by that..oh well

Every time I run the Google Base Feeder, I get an error log in my cache folder that says "PHP Warning: ereg_replace(): REG_EBRACK in ../includes/classes/google_base.php on line 214."

Why am I getting this error?

Here is line 214 in google_base.php

      $products_image_base = ereg_replace($products_image_extention, '', $products_image);

I'm using Zencart v1.3.9g

smoke133:

Every time I run the Google Base Feeder, I get an error log in my cache folder that says "PHP Warning: ereg_replace(): REG_EBRACK in ../includes/classes/google_base.php on line 214."

Why am I getting this error?

Here is line 214 in google_base.php

  $products_image_base = ereg_replace($products_image_extention, '', $products_image);

replace the line with..

$products_image_base = str_replace($products_image_extension, '', $products_image);

Getting the following error:
[14-Oct-2010 03:22:12] PHP Warning: chmod(): Operation not permitted in /hsphere/local/home/CUSTOM/CUSTOMSITE.com/googlefroogle.php on line 103
[14-Oct-2010 03:22:18] PHP Warning: chmod(): Operation not permitted in /hsphere/local/home/CUSTOM/CUSTOMSITE.com/googlefroogle.php on line 386

Prior to upgrade I wasn't seeing these error logs.

-lindasdd

davewest:

replace the line with..

$products_image_base = str_replace($products_image_extension, '', $products_image);

Is it better to have it that way then compared to this way?
```php
$products_image_base = preg_replace('/'.$products_image_extension . '$/', '', $products_image);

This how the module image handler 2 has it. If so, should I change it to that for the image handler 2?

What ever works..... or... does it!

str_replace is just a simple search replace, where as preg_replace, does more complex search and replace... or for better info.... check out http://us2.php.net/manual/en/function.str-replace.php

Keep it simple.... makes for faster code...

Thank you for your help. I'm no longer getting the error message. :clap:

ZC v1.3.8a
New to GBF and it's working fine for me but I have one question about the ftp upload.
When I log into uploads.google.com with my ftp client, shouldn't I see the domain_products.xml file that was created by and successfully uploaded using GBF?

Since I didn't see it, after a couple of ftp upload attempts and no product data showing, I decided to manually upload it via Merchant Center.

jabbawest:

ZC v1.3.8a
New to GBF and it's working fine for me but I have one question about the ftp upload.
When I log into uploads.google.com with my ftp client, shouldn't I see the domain_products.xml file that was created by and successfully uploaded using GBF?

Since I didn't see it, after a couple of ftp upload attempts and no product data showing, I decided to manually upload it via Merchant Center.

It is better to manually upload it via Merchant Center or You can let Google automatically get it for you. You can set it up from the Merchant Center for Google to retrieve it.