Google Base Feeder Support Thread [OLD]

ugh nevermind..they need to update the file for your product on this website..was using the wrong version!

No, it's up to the author to upload updates. My files are now only available from my website. Subscribe to the RSS as indicated in my signature for update notifications.

Hi everybody

Any idea what the following error means ?

Google Base Feeder v.1.6.5 09.11.2007 11:22:59 started 2007/12/03 19:50:55
Feed file - /[...]/feed/rcnut_products.xml
Processing: Feed - Yes, Upload - No
Fatal error: Call to undefined function zen_price_check() in /[...]/googlefroogle.php on line 140

WORKAROUND

I found a workaround for this issue. This works only because I have less than 200 items, it is still time consuming. I was updated some items and continued to check the google feeder just in case something I did made a difference. I noticed that when I created new items they would be added to the feed. I updated a product availability date and BAM the old item got recognized by the feed script. So, I went through each item and updated it's availability date, I also found some mis-matched master category ID's.

This issue is resolved.

aknatn:

Hello, I am in need of some guidance, let me try to explain.

First, I have researched the problem on the forums and elsewhere to the best of my ability and can't find anything that helps solve it, hopefully someone can shed some light.

I have installed zen cart 1.3.7, mods; Google Base Feeder (latest version as of this date), Simple Google Analytics (installed after GBF) and Image Handler 2.

Everything appears to be installed correctly, no errors and no errors in the server error log. But when I run the product feed update it runs perfect but returns 0 records. There are 150 products in the database.

For troubleshooting I created a new product (test) and ran the update again, this product does get processed, but none of the others.

All of my other products were manually imported from OSC. I am reasonably proficient with phpMyAdmin, MySQL and PHP and everything else works fine with the imported products.

I compared the tables for the new (test) product that does work with the products that don't and can't find any differences. I checked the googleFroogle.php code and can't seem to find where the problem is. For some reason the script does not see the osCommerce imported items.

Please help, Google Base has been a great revenue stream for my client any advice or ideas are welcome.

Fatal error: Call to undefined function zen_price_check() in /var/www/vhosts/sysfix.co.uk/subdomains/dropshipping/httpdocs/googlefroogle.php on line 140

I am having this problem too.

Using v 1.3.7
With Chemo ultimate URLS
Have around 7000 products

Removed old SQL info from froogle feeder
Installed new google base files and SQL
but receive the error message.

I have a shop that has been developed using Zen Cart and I cannot get the froogle feed to update the very latest pricing even though prices on the shop are displayed correctly.

In the first posting on this thread numinix wrote:

"Run a cron job for currency updates a few minutes before the google froogle feeder. This will ensure that your prices posted on Google are the same as your website if your default currency is not USD. As a Canadian seller, this was a personal issue for me."

Can you please explain how I would do this, working in GBPounds?

Sorry if this is simple stuff, but I am a complete novice.
TIA

I have the base feeder installed on my site and it was working properly until I changed my product inventory around. Usually I am able to view the feed normally through the browser and when I upload it to froogle everything works fine. Now I am unable to view it using a browser. IE 7 tells me that there is an error in the feed and froogle tells me that they were not able to read some of the file and only 35 or my 2000 and so products are imported. I am not really sure what I causing the issue. All of the products are of the same product type and the only thing different is the categories in which they are listed.

This is a link to my feed:

http://www.lotzofgifts.com/feed/google_base.xml

Any suggestions as to what might be causing the problem would be helpful

Thanks

Hello Numinix,

I loaded your latest version ebay v1.0 and I still get the wierd errors and my site is no longer viewable. I really need to get this working and figure out what is causing this to happen.

I uploaded a image of what happens to my site when i load the mysql file.

Here are the errors i get.

Warning: Variable passed to each() is not an array or object in /home/batte9/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/batte9/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/batte9/public_html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/batte9/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/batte9/public_html/includes/init_includes/init_templates.php on line 78

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_PRODUCTS_NEW' at line 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by pd.products_name limit -0, MAX_DISPLAY_PRODUCTS_NEW]

I hope this sheds some light on the subject. If you want I can give you more information upon request.

Thank you

Just a side note: I can load all the files okay but when I upload the sql is when everything goes haywire.

aknatn:

WORKAROUND

I found a workaround for this issue. This works only because I have less than 200 items, it is still time consuming. I was updated some items and continued to check the google feeder just in case something I did made a difference. I noticed that when I created new items they would be added to the feed. I updated a product availability date and BAM the old item got recognized by the feed script. So, I went through each item and updated it's availability date, I also found some mis-matched master category ID's.

This issue is resolved.

:clap: Thank you! Your workaround fixed my problem!

batteryman:

Hello Numinix,

I loaded your latest version ebay v1.0 and I still get the wierd errors and my site is no longer viewable. I really need to get this working and figure out what is causing this to happen.

I uploaded a image of what happens to my site when i load the mysql file.

Here are the errors i get.

I hope this sheds some light on the subject. If you want I can give you more information upon request.

Thank you

Just a side note: I can load all the files okay but when I upload the sql is when everything goes haywire.

I really have no clue. Firstly, it's not happening to anyone else. Secondly, the Google Base Feeder is working for you and they are basically the same. Send me an email and maybe we can sort this out privately since it seems to be an isolated issue.

Btw, this is the Google Base Feeder thread, not the eBay Exporter thread :p

numinix

Any idea on this error ? :( .. seems a few of us are getting it

Google Base Feeder v.1.6.5 09.11.2007 11:22:59 started 2007/12/03 19:50:55
Feed file - /[...]/feed/rcnut_products.xml
Processing: Feed - Yes, Upload - No
Fatal error: Call to undefined function zen_price_check() in /[...]/googlefroogle.php on line 140

on line 140 we get this

if ($price > 0 && zen_price_check($price) == true) {

delete the zen_price_check, I don't even know what that is or how it got there...!? It is undefined on my site as well.

is this ok ? (worked liek it, just making sure)

if ($price > 0 ) {

or do I need == true

as well ?

Yes, that's correct. 1.6.7 is that bug fixed.

batteryman,

someone posted a link to this thread in the eBay Exporter thread: http://www.zen-cart.com/forum/showthread.php?p=378357#post378357

It may relate to your issue and is a bug that hs been solved in the core code in 1.3.8.

Let me know if that changes anything.

Further to post 666

Am I correct in thinking that each time I run the froogle generator, the froogle.txt file is overwritten
I get the following shown

Google-Froogle Data Feeder started 2007/12/06 10:19:33
Feed file - /www/hosts/*******/mainzone.co.uk/feed/froogle.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 9.942317 Seconds 4242 Records

But when I view the results and save the file I can see that the contents do not reflect the latest pricing information on the website.

My feed folder holds 3 files
froogle.csv 2bytes
index.html 111bytes
froogle.txt 3438541bytes

This problem has only recently occurred and previous 5 months worked correctly.
Any assistance gratefully accepted.

I'm not offering support for versions previous to the latest version.

numinix:

I'm not offering support for versions previous to the latest version.

Numinix,

Is the google base feeder compatible with 1.3.8?

I am in the process of rebuilding my site because something in my 1.3.7 database was not compatible when it upgraded. I had google base feeder with 1.3.7

I haven't tested it but it won't hurt to try. I don't think they have made any changes to how products are stored in the database...

Hello All,

I just installed the latest Google Base Feeder v1.6.7 on Zen Cart 1.3.7. Everything works great. I have Magic SEO URLs installed on my Zen Cart so I also downloaded(purchased) the Magic SEO addon for Google Base Feeder. My problem is after installing; my link urls are still the standard zen urls not the magic seo format. The readme.txt mentioned something about changing/adding code to header_php.php but doesn't list any code. I'm I missing something? Any help would be greatly appreciated. Thanks