Google Base Feeder Support Thread [OLD]

Hi

I put it in my words (simple ones) from what i know it publish your product on google, ( mine their ) and also update your product on Auto, after you set it up

Realy cool mod , a must to have one
Good Luck

In regard to your Flash banner, I have no idea , try the search , it dose have lots of info

I messed up the folder heirarchy in v1.4.5, I'm going to test on a clean installation of Zen Cart now and fix the folders. I'll release 1.4.6 in the next little while.

I installed 1.4.5 and all went well. Ran SQL and no errors, but when I try to generate the feed file I'm getting the following error:
1054 Unknown column 'p.products_upc' in 'field list'

Should I run the Uninstall SQL? That step wasn't in the Readme file.

Ohh God

I feel much better knowing i was not annoying for nothing:smile:

P,S what should i do whan i get the 1.4.6 , should i delete the 1.4.5 or overide it?

Thank you Numinix

They are should just be an overwrite unless other mods use those files as well.

v1.4.6 GOOGLE BASE FEEDER

1. Fixed folder heirarchy;
2. Added missing ";" in SQL;
3. Fixed issue regarding viewing feed file folder;

numinix:

Replace admin->includes->modules->product->collect_info.php with the one in v1.4.5.

I've already tried that and it's not worked. I think an error exists in admin>includes>modules>update_product.php.

Version 1.4.6 (installed today) has not solved the problem. :(

Any other ideas?

I have worked around this issue by commenting out the following lines (43-48) in admin>includes>modules>update_product.php.

'products_weight_type' => $products_weight_type,
'products_dim_type' => $products_dim_type,
'products_length' => (float)zen_db_prepare_input($_POST['products_length']),
'products_width' => (float)zen_db_prepare_input($_POST['products_width']),
'products_height' => (float)zen_db_prepare_input($_POST['products_height']),
'products_ready_to_ship' => (int)zen_db_prepare_input($_POST['products_ready_to_ship']),

It worked for me! :)

Hi

Yeaaaaaa it is working

I now will try to do the update on my live store

Thank you

Alex Clarke:

I have worked around this issue by commenting out the following lines (43-48) in admin>includes>modules>update_product.php.

'products_weight_type' => $products_weight_type,
'products_dim_type' => $products_dim_type,
'products_length' => (float)zen_db_prepare_input($_POST['products_length']),
'products_width' => (float)zen_db_prepare_input($_POST['products_width']),
'products_height' => (float)zen_db_prepare_input($_POST['products_height']),
'products_ready_to_ship' => (int)zen_db_prepare_input($_POST['products_ready_to_ship']),

>  
> It worked for me! :)
 
You are correct.  This is more Canada Post code that I missed.  I'm issuing 1.4.7 now to cover this mistake.  You won't need to download it but everyone who doesn't use Canada Post should.

v1.4.7 GOOGLE BASE FEEDER

1. bug fix;Canada Post module now completely removed. All unstable versions of the GBF have been removed from my website leaving only stable versions for download.

I applied the 1.4.7 update, and I get this when I try to update an existing product:
1054 Unknown column 'products_weight_type' in 'field list'
It is creating a Feed File.

I was getting that error after the 1.4.5 update, but the suggestion above stopped the error and I was able to update the products, but it would not create a Feed File. Well it created one, but it had nothing in it.

It appears this has not been fixed in the 1.4.7 release.

You'll have to re-apply my 'quick fix' as found here...

http://www.zen-cart.com/forum/showpost.php?p=404297&postcount=128

I completely removed that block of code which pertains to the Canada Post Shipping module from update_product.php

I just tested on a clean installation and it works. If the update_product.php file contains the lines that Alex has brought to our attention, simply delete them.

Alex, hopefully you can assist some of these other users to install and use this mod as I'm very busy writing a new mod.

Downloading UPC/ISBN Module 1.1 will fix the issue. I'll update the GBF yet again :p

v1.4.8 GOOGLE BASE FEEDER

Bug Fix

Hi
This is on my 1.4.2 live store, I keep getting this error, I contact my server as I been advice here, but the say it is nothing to do with the server
/bin/sh: http://www.tiledepot.us/store/googlefroogle.php?feed=yes: No
such file or directory
I did not upgrade to the newer version, as I see it keep changing every day
Is that important think I should take care , or I can live with it, is that mean I only to manually upload every time I have change? Is so I am ok with it
Thank you

1.4.8 nailed it. All is good now.

I actually applied the SQL script even though I guess I was technically updateing from 1.4.6 (which never worked for me).

Thanks!

-Mike

numinix:

I just tested on a clean installation and it works. If the update_product.php file contains the lines that Alex has brought to our attention, simply delete them.

Alex, hopefully you can assist some of these other users to install and use this mod as I'm very busy writing a new mod.

Sure, I can help people. However, the 1.4.8 upgrade should solve all problems. Thanks for this! :)