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?

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.

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?

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

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

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/shop/feed/duckworthsukcom.xml (or http://www.duckworthsuk.com/shop/shopfeed/duckworthsukcom.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/shop/feed/duckworthsukcom.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

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

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. :unsure:

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/shop/feed/duckworthsukcom.xml (or http://www.duckworthsuk.com/shop/shopfeed/duckworthsukcom.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/shop/feed/duckworthsukcom.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.

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

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.

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. :unsure:

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

HeathenMagic:

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!

tjthecat3:

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!

You can try the fix posted earlier in the thread. I'm not sure how it affects wordpress though...

Quick question ( is there such a thing??lol!)

I created a feed file today. The expiration date looks like this:

<g:expiration_date>2008-09-07</g:expiration_date>

Does this mean it will expire today??

Also what does this option in the admin mean?

"Expiration Date Adjust"

just found the googlebase details for each field in the file and it shows that this is the expiration for this item.

How do I set it to be a date in the future?????????????

Where in the admin do I do this??

Thanks

marvin:

Quick question ( is there such a thing??lol!)

I created a feed file today. The expiration date looks like this:

<g:expiration_date>2008-09-07</g:expiration_date>

Does this mean it will expire today??

Also what does this option in the admin mean?

"Expiration Date Adjust"

marvin:

just found the googlebase details for each field in the file and it shows that this is the expiration for this item.

How do I set it to be a date in the future?????????????

Where in the admin do I do this??

Thanks

:lamo:

Why don't you read your first post a little more carefully. Or give me a nobel prize for time travel :)

Configuration is done from the admin->configuration->google base feeder configuration.

Hi am i a new user to Zen Cart we only decided in the last couple day to move shopping carts from oscmax to Zen Cart we are in the middle of installing mods for Zen and we are having trouble with MSN Live & Froogle Feeder I have installed both mods ok run both mods to test and only get two products in xml files this applies to both mods I have increased variable settings in PHP.ini to

max_execution_time = 300max_input_time = 90memory_limit = 64M

but still only exports two products I have checked log files on linux based system and have no error entries for mods I am assuming that i must have dirty data in database causing the error export of products?

Many Thanks

Webie

Were these TWO products added after the migration?

I have no experience with migrating from OSC to ZC and can't tell you the difference. HOWEVER, a script called Zen Magic by MagicOne is used for storing and updating products into Zen Cart in a similar manner as OSC and I know that these products are NOT extractable by any of my mods. What you may want to try doing is exporting all of your products out of your database and then use excel to put them into Easy Populate file specifications and update your site using Easy Populate. The products should then become extractable from the database by these mods.

Perhaps DrByte, Ajeh or one of the other developers with first hand experience with OSC could tell us the difference in how products are stored in the database.

Hi Zen Flower,

All product are already in the Zen Cart Database in the correct format as required we use windows based program to import all products which is much faster than easy populate I have not used that mod for product for couple of years now. any other ideas as I have now errors logged very strange ?.

Many Thanks
webie

Sorry, not Zen Magic. It's called Zen Manager and it is a Windows-based program that does not store products in the database as Zen Cart does normally. If you continue to use this program, you will need to follow my previous instructions or try using MagicOne's commercial script (at a price) for feeding your products to Google.

numinix:

:lamo:

Why don't you read your first post a little more carefully. Or give me a nobel prize for time travel :)

Configuration is done from the admin->configuration->google base feeder configuration.
Yes, Numinix "2008", sometimes the obvious is not so obvious to tired eyes.
At the same time facetious comments do not answer the questions I asked.
I already found the answers to my questions in that post. i would have rather given you a Nobel prize for helping me out with my problem.

Now, let's start fresh.

Can ANYONE tell me what are the CORRECT permissions for images folder so Google base can access it. Ive read through a number of posts but still dont know the answer. Most of the discussion concern using other contribution.

I uploaded my files to Google Base and everything works EXCEPT no images, just placeholders. Google tech said he gets an 403 error for my images.

marvin:

Yes, Numinix "2008", sometimes the obvious is not so obvious to tired eyes.
At the same time facetious comments do not answer the questions I asked.
I already found the answers to my questions in that post. i would have rather given you a Nobel prize for helping me out with my problem.

Now, let's start fresh.

Can ANYONE tell me what are the CORRECT permissions for images folder so Google base can access it. Ive read through a number of posts but still dont know the answer. Most of the discussion concern using other contribution.

I uploaded my files to Google Base and everything works EXCEPT no images, just placeholders. Google tech said he gets an 403 error for my images.

Read carefully again and you will notice I answered your question as well in that short post...