Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

**This is the NEW thread for the latest version of Numinix Google Merchant Center Feeder for Zen Cart v1.5.x.

**
This add-on can be found in the downloads section here: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=2091
**

Please DO NOT post questions regarding the ****v1.3.x versions of this add-on in this support thread. **Questions regarding the v1.3.x versions of this add-on should be directed to this support thread:http://www.zen-cart.com/forum/showthread.php?t=187534

If you post questions about the v1.3.x versions of this add-on you will be (gently or not so gently) redirected to the correct support thread.
I'm not providing any support.. Just being a good net citizen..

I installed the mod, the country option does not work, and i am unable to generate a feeds, sometimes it just hangs forever, and other times it just shows a internal server error.

Thanks

I'm frustrated, I can't seem even to install this addon.

I followed instructions on readme file(changing UTF-8 characters and stuff). But I don't understand few steps like:

"CHMOD feed and sub-directories 777 or sufficient write permissions" What do I need to do here?

Also "Go to Admin->Configuration->Google Merchant Center Configuration and setup all parameters"

I don't have Google Merchant Centre tab in my configuration list.. I placed all the files and installed sql patch... but I can't see any Merchant Center configuration..

While this mod is very good, I found long ago it did not cope with other languages (read charsets) well and so began to modify it to produce an accepted feed for Spain (spanish, euros).
(I also needed it to deal with my widespread use of boilerplate text.)

Next was getting it to produce another feed for the UK (english, pounds) which required adding certain fields (in the code and the database) that Google complained about.

This mod is not a be-all and end-all for all feeds as Google applies country-specific criteria which may vary and change.

My point is...be prepared to hack into the code to produce the feed as Google wants. It may work ok for USA but need tweaks for other countries/feeds.

So no one knows what to do if I done all the steps, but I can't see "Go to Admin->Configuration->Google Merchant Center Configuration and setup all parameters" Merchant Centre Configuration?

AivarasTR:

"CHMOD feed and sub-directories 777 or sufficient write permissions" What do I need to do here?This is straightforward unless you don't understand what CHMOD means. The instruction tells you to change the permissions of these folders.
http://www.google.com/search?q=CHMOD&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

AivarasTR:

Also "Go to Admin->Configuration->Google Merchant Center Configuration and setup all parameters"

I don't have Google Merchant Centre tab in my configuration list.. I placed all the files and installed sql patch... but I can't see any Merchant Center configuration..How did you install the SQL patch, the menu not appearing says that either all the files needed for the admin menu were not uploaded or the SQL did not install correctly to register the menu.

Hello I see Admin->Configuration->Google Merchant Center Configuration but there is only a table header Title Value Action with no buttons or line items.

I have digital/cd products and google feeder wants shipping, tax, brand, mpn and google product category. I would set this by hand but don't know what the actual attributes are.

I believe some people cannot see menu items because they might have old 1.3 files mixed with 1.5.

DivaVocals:

This is straightforward unless you don't understand what CHMOD means. The instruction tells you to change the permissions of these folders.
http://www.google.com/search?q=CHMOD&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

How did you install the SQL patch, the menu not appearing says that either all the files needed for the admin menu were not uploaded or the SQL did not install correctly to register the menu.

Yeah I've got the first one, it was straightforward.

But still menu is not appearing. As I said I'm 100% sure I uploaded all the files and installed SQL trough tools-> install SQL patches, I used install.sql file. I've got message that 10 "smth" was successfully installed after hitting upload.

Any other options I can try? Oh and I've never used any Google merchant patches before..

I installed the newest version on ZC 1.5.0 and went through the whole configuration and everything, then when I go to Tools > Google Merchant Center Feeder and choose "Products" and leave the other two fields blank and hit "confirm" I get a popup window that says

Google Merchant Center Feeder v started 2012/04/20 00:03:17

Feed file - /home5/jugglerd/public_html/feed/google/opalessenceshop_products_en.xml

Processing: Feed - Yes, Upload - No

WARNING: An Error occurred, please refresh the page and try again.

I tried entering "1" as the starting point, I tried using 1000 as the max products... I don't know what is misconfigured to make it not work. I turned on debugging but I don't see any debugging info anywhere. My error logs don't show anything, either. Any ideas? I did the CHMOD of the feed and feed/google directories... I uploaded all the files, I did the install.sql patch...

mindcraft:

Hello I see Admin->Configuration->Google Merchant Center Configuration but there is only a table header Title Value Action with no buttons or line items.

I have digital/cd products and google feeder wants shipping, tax, brand, mpn and google product category. I would set this by hand but don't know what the actual attributes are.

I believe some people cannot see menu items because they might have old 1.3 files mixed with 1.5.
Same problem here, I see the header but no configration options.

I installed it on a 1.5 which wasn't an update from 1.3, so normally I shouldn't have mixed files.
Got an sql error when I did the sql patch so maybe got something to do with that:
12 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

Has anyone figured out how to modify the template to hide display-only attributes?

still struggling to hide the display only attributes from the product pages. I got these instructions from a post in numinix thread

This file needs to be edited:

/public_html/YOUR_CATALOG/
includes/modules/YOUR_TEMPLATE/attributes.php

each query that selects data from the table TABLE_PRODUCTS_ATTRIBUTES needs to have the following condition

AND patrib.attributes_display_only = 0

Note, that on one of the queries, the table TABLE_PRODUCTS_ATTRIBUTES is referenced as pa so the condition would be

AND pa.attributes_display_only = 0

i have tried the above -
from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . AND patrib.attributes_display_only = 0 " patrib

but once all TABLE_PRODUCTS_OPTIONS have been amended as above ,, all that seems to happen is the whole product page is hidden..
Anyone got any ideas too hide just the display only attributes... thanks

This MOD V1.5 should just be taken out of the plugin menu. This version DOES NOT WORK with V1.5 unless some tweaking is done. If you do a search for the error you get, you will see instructions from another zenner who has solved the problem. You will need essentially to remove some files, modify the SQL patch. With all these changes it is obvious that the current V1.5 is not ready for what it claims to be. So please remove it until it is fixed.

WebKat:

I installed the newest version on ZC 1.5.0 and went through the whole configuration and everything, then when I go to Tools > Google Merchant Center Feeder and choose "Products" and leave the other two fields blank and hit "confirm" I get a popup window that says

I tried entering "1" as the starting point, I tried using 1000 as the max products... I don't know what is misconfigured to make it not work. I turned on debugging but I don't see any debugging info anywhere. My error logs don't show anything, either. Any ideas? I did the CHMOD of the feed and feed/google directories... I uploaded all the files, I did the install.sql patch...

Decostyle:

This MOD V1.5 should just be taken out of the plugin menu. This version DOES NOT WORK with V1.5 unless some tweaking is done. If you do a search for the error you get, you will see instructions from another zenner who has solved the problem. You will need essentially to remove some files, modify the SQL patch. With all these changes it is obvious that the current V1.5 is not ready for what it claims to be. So please remove it until it is fixed.

I'm not finding the post you're talking about via a Google search of this site or a general Google search... can you show me the post and I can see if I think it's worth my time to make the changes? Thanks!

(duplicate post)

Decostyle:

This MOD V1.5 should just be taken out of the plugin menu. This version DOES NOT WORK with V1.5 unless some tweaking is done.There are LOTS of add-ons that do not work.. Wouldn't a BETTER solution be to post the fixes?? or better yet since you seem to be familiar with the fix, you could fix the add-on and re-submit it..

Decostyle:

If you do a search for the error you get, you will see instructions from another zenner who has solved the problem. You will need essentially to remove some files, modify the SQL patch. With all these changes it is obvious that the current V1.5 is not ready for what it claims to be. So please remove it until it is fixed.What error?? Which posts?? if there are posted fixes for this add-on why not share them with the community??

Sorry about that out burst fellow zenners. It was just frustrating last night spending hours trying to fix the module and make it work on v 1.5.

So here it is. The link below to the fix is for v12.5 for 1.5 but I actually used v13.0 for 1.5 and had various errors in it, and the fix below solved it.

http://www.zen-cart.com/showthread.php?187534-The-NEW-Google-Merchant-Thread-Version-1-12-0/page32&highlight=google+feeder+sql+patch

Pay special attention to the fact that a file had to be deleted and another file updated, then SQL patches had to be made on myphp admin. It won't work on the SQL install on admin.

So after all that, I got it working. It now produces an XML file from the link but does not output the file into the folder specified. Hey, at least it is working for now.

I just wish it was not posted as v1.5 ready when clearly it is not.

Thanks!

Decostyle:

I just wish it was not posted as v1.5 ready when clearly it is not.It's posted as v1.5 ready because the author believed it WAS v1.5 ready..

I'm going to take a stab at this in a few minutes. You say it doesn't output the file into the folder specified--where does it put the file? (just to save myself frustration looking for it!)

Thank you for taking the time to put together this patch!

Decostyle:

Sorry about that out burst fellow zenners. It was just frustrating last night spending hours trying to fix the module and make it work on v 1.5.

So here it is. The link below to the fix is for v12.5 for 1.5 but I actually used v13.0 for 1.5 and had various errors in it, and the fix below solved it.

http://www.zen-cart.com/showthread.php?187534-The-NEW-Google-Merchant-Thread-Version-1-12-0/page32&highlight=google+feeder+sql+patch

Pay special attention to the fact that a file had to be deleted and another file updated, then SQL patches had to be made on myphp admin. It won't work on the SQL install on admin.

So after all that, I got it working. It now produces an XML file from the link but does not output the file into the folder specified. Hey, at least it is working for now.

I just wish it was not posted as v1.5 ready when clearly it is not.

Thanks!

I didn't put the patch together, but I did find the solution written in one of the forum notes.

I really don't know where the output file goes, it certainly does not show up in the output folder feed/google but when you click on the link once the file is generated, you can download the xml file.

Did you get it to work? I had to try the sql patch 2x before it kicked in. Not sure why. Maybe the patch itself is buggy but right now it works.