Google Base Feeder Support Thread [OLD]

[0101101011]

Or: you have linked items, in which case the xml will generate only the 'master category' files (at least this is what I believe after playing with it a bit).

Maybe someone could confirm that - Thanks,

I was not fully accurate in above statement:

Well, the .xml file is skipping the linked products, HOWEVER, the products skipped seem not to be based on the 'master category' (products table > master_categories field) - they seem to be rather random...

Do you think it could be more practical if the products listed in xml will be 'associated' with the master category instead of linked category? I guess it may not matter to some, but maybe it would be beneficial? Anyone any thoughts on this?

[numinix]

It is a timeout issue, he/she needs to create a php.ini file in addition to changing the max execution time in Zen Cart.

Seems like you will need a max-execution time of about 120s on your server if only 1/4 of your UNLINKED products are appearing in the feed file with a 30s max-execution time.

[tjthecat3]

when i try to generate an xml file, i just get a blank page almost instantly. the SQL installed correctly, and i have it configured properly. why is this happening?

[HeathenMagic]

Have you got wordpress module installed at all as I had the same thng happen.

[aPurpleMonkey.com]

Ditto on the wordpress module. Same thing happened to me. It's a piece of junk that screws up lotsa stuff.

[livesol]

Hi everybody :)

I'm having a bit of a problem setting up the feed.

The issue I believe I am having with the shop is that the location of the shop is at http://www.duckworthsuk.com/shop/ (when you visit http://www.duckworthsuk.com the index.php forwards you on to http://www.duckworthsuk.com/shop)

These are the settings you are after.

Store Address: http://www.duckworthsuk.com/shop (also tried http://www.duckworthsuk.com/)
Output Directory: feed/ (also tried /feed/)

The odd thing is that first of all it puts an extra "shop" in the URL, so it looks in http://www.duckworthsuk.com/shop/sho...orthsukcom.xml (or http://www.duckworthsuk.com/shop/sho...orthsukcom.xml when output directory is "feed/"). I have created a blank file in the above directory that will be overwritten. However, when I click on the "Click [HERE] to create / update your product feed.", the javascript window updates with the index page, and the feed file generated is invalid (it's actually HTML).

You can see it here: http://www.duckworthsuk.com/shop/sho...orthsukcom.xml

I am using SEO URL's 3.0.0-beta1 as well, could that be conflicting with it?

I have created a blank .xml called "duckworthsukcom.xml" in

[heimskr75]

I get the following error for any version I install even the latest 1.5.3.

Processing: Feed - Yes, Upload - No
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 'ORDER BY p.products_id DESC' at line 11
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id DESC]

My server is running mysql 4.1.22-standard. Being a newb to coding and all I have no clue how to fix this. Thanks

[lismith]

I don't have access to php.ini unless I install my own php. I think it would be easier to just create the file offline.

[numinix]

Hi everybody :)

I'm having a bit of a problem setting up the feed.

The issue I believe I am having with the shop is that the location of the shop is at http://www.duckworthsuk.com/shop/ (when you visit http://www.duckworthsuk.com the index.php forwards you on to http://www.duckworthsuk.com/shop)

These are the settings you are after.

Store Address: http://www.duckworthsuk.com/shop (also tried http://www.duckworthsuk.com/)
Output Directory: feed/ (also tried /feed/)

The odd thing is that first of all it puts an extra "shop" in the URL, so it looks in http://www.duckworthsuk.com/shop/sho...orthsukcom.xml (or http://www.duckworthsuk.com/shop/sho...orthsukcom.xml when output directory is "feed/"). I have created a blank file in the above directory that will be overwritten. However, when I click on the "Click [HERE] to create / update your product feed.", the javascript window updates with the index page, and the feed file generated is invalid (it's actually HTML).

You can see it here: http://www.duckworthsuk.com/shop/sho...orthsukcom.xml

I am using SEO URL's 3.0.0-beta1 as well, could that be conflicting with it?

I have created a blank .xml called "duckworthsukcom.xml" in

There shouldn't be a problem with SEO URLS or installing to a /shop/ folder. All paths are relative so you should be uploading googlefroogle.php to /shop/ and all other folders to there relative locations as well.

I get the following error for any version I install even the latest 1.5.3.

Processing: Feed - Yes, Upload - No
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 'ORDER BY p.products_id DESC' at line 11
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id DESC]

My server is running mysql 4.1.22-standard. Being a newb to coding and all I have no clue how to fix this. Thanks

You have the same MySQL version as I do, so I am not sure what the error is. Please completely uninstall the script by running the uninstall.sql. Then upload all of the 1.5.3 files overwriting any existing files and then reinstall the googlefroogle.sql file by copying and pasting. Let me know how it goes.

I don't have access to php.ini unless I install my own php. I think it would be easier to just create the file offline.

Yes, you can create a php.ini and place it in your store's root directory.

[tjthecat3]

Have you got wordpress module installed at all as I had the same thng happen.

oh really? jeez. glad to have an answer.

unfortunately the wordpress module is essential, so i guess i'll just do the xml file by hand!