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

gxjenkins:

Well for anyone interested!
I recently moved my store version 1.50 from Godaddy to Hostgator.

As soon as I had checked to make sure everything had moved over I installed Google Merchant Feeder version 1.13

First thing I noticed was that it did create a feed file. but it was empty. I checked the permissions and changed the googlefroogle.php in the root and in the Admin folder to 755 and now it populating the created file.

At Godaddy I could only create a file with no more than 500 items or it would time out. Now at Hostgator I couldn’t even create a file with that many items.

Starting with just 100 items I’ve found that I can only create a file with no more than 275 items because the MAX TIME OUT in the PHP.INI file is set to 30 seconds and can’t be increased.

Don’t bother trying to get help from the NUMINIX site I think they’ve had an internal meltdown. Earlier this year I paid them to update the “ebay exporter” module to work with version 1.50 and everything worked out well. But, after that I contacted them to update another module and nothing happened. I contacted Support and asked for an update and they didn’t even know they had been paid to do a job. Then they tried to tell me the module had been updated and delivered, but they were talking about the “ebay exporter”. I canceled the job and ask for a refund which they issued. Now on the site there is tons of spam.

Gary

I found a solution to my problems with this mod by not using it. It's working for alot of people but since the upgrade to 1.50 it has been one problem after another. The mod worked great for along time, and now it doesn't work for me. It was time to move on.

I solved my problem by using a paid product if interested check out this post:
http://www.zen-cart.com/showthread.php?203740-Need-Help-With-MYSQL-DB&p=1173433#post1173433

Sometime Free Cost Too Much. Good luck.

Thanks,

ZC 1.50
Not sure if this is the right place to ask, but here goes.

Installed this add-on and from what I can see it appears to be working properly.
the problem I'm running into has to do with the xml file (I think). Not all of my products are being accepted/loaded and I'm getting the following error messages;

XML tag mismatch
Your data feed contains a pair of opening/closing XML tags that don't match.

Invalid RSS/Atom document format
Your XML data feed isn't in one of our supported formats. Please be sure your root element has been declared correctly.

Honestly....I'm totally lost.

turn on sanitize feed in your settings and see if that doesn't help.

Now for my problem, I have a young lady who has upgraded to 1.5.1 and has not been able to output a feed since. It works until it gets to product 3891 and then does this:

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

I've tried resetting the timeout with no change. Set the max products and success at only 1000 products:

Google Merchant Center File Complete In 27.964173 Seconds 999 of 1000 Records which takes it to product id 3361. I've never run into this before - I used to be the one who answered the questions on this! Anybody got ideas? Must be a server limitation I assume but not sure how to overcome it or what to look for.

So I have Google Merchant Center Feeder set up for 1.51. The "basic" product feed works and is hooked into our AdWords account. However, my shop sells clothing and the new "Google Shopping" wants/requires the variants for what we're selling - size, color combinations etc.

My feed does not automatically create these variants and I don't see a place to turn them on. So I took a peak at /googlefroogle.php in the main directory to see what is happening.

Question:
Do I need to have the module "Stock By Attributes" installed to make the the Feeder export all the relevant variants?

And if not, how to I get the Feeder to export this data.

Thanks.

Anyone?

Hey guys,

I have upgraded to Zencart version 1.5.1 and after loading everything the Configuration menu has nothing on it;
Admin/Config/MerchantCentre.

The page loads up and the tool works from the Tools menu, but without the configurations page loading I cannot get it to work properly.
Is there a easy way to fix the page loader? or hard code?

Can anyone help me, I upgraded to ver 1.5.1 and tried to install the mod, but when I run the install SQL thru PHPmyadmin I get this error message,

SQL query: Documentation

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Debug', 'GOOGLE_PRODUCTS_DEBUG', 'false', 'Turn on simple debug?', @googlemerchantcenterfeederid, 0, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Google Merchant Center FTP Username', 'GOOGLE_PRODUCTS_USERNAME', 'ftp_username', 'Enter your Google Merchant Center FTP username', @googlemerchantcenterfeederid, 1, NOW(), NULL, NULL), (NULL, 'Google Merchant Center FTP Password', 'GOOGLE_PRODUCTS_PASSWORD', 'ftp_password', 'Enter your Google Merchant Center FTP password', @googlemerchantcenterfeederid, 2, NOW(), NULL, NULL), (NULL, 'Google Merchant Center Server', 'GOOGLE_PRODUCTS_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: hedwig.google.com', @googlemerchantcenterfeederid, 3, NOW(), NULL, NULL), (NULL, 'Google Merc[...]

MySQL said: Documentation
#1062 - Duplicate entry 'GOOGLE_PRODUCTS_DEBUG' for key 'unq_config_key_zen'

Ay ideas to correct this?

Mal Bradford:

cjmarley. Did you ever sort this? I have the same problem but the solution posed by mattys didn't resolve it for me. I wonder if we have the same issue?
I am getting the same response. It opens my home page and does not generate a feed. It was working yesterday and did not do anything, but change computers.

Are there any plans to exclude a list of products by product id from being put into the feed?

Since Google Merchant Center is now a paid service through Adwords, with only a limited number o free clicks, it's now important to monitor and remove poor performing products from the feed.

Hello, I am using Zen 1.5.0 and when I enable the UPC/ISBN/EAN in the configuration to TRUE and try to "confirm" I get this error: (

Google Merchant Center Feeder v started 2013/02/18 16:42:36
Feed file - /home8/wwrepair/public_html/parts/feed/google/wwrepair_products_en.xml
Processing: Feed - Yes, Upload - No
WARNING: An Error occurred, please refresh the page and try again

If I change the UPC/ISBN/EAN back to false, it will upload only some of my products. I do use the UPC field but not ISBN (Numinix Product Fields Module). The last upload had 3017 and after trying to get the UPC to work it only uploads 1645 (again I have to disable the UPC filed in admin or I get an error). Any help is greatly appreciated. Thank you!

I checked my debug log and this is what is says:
[18-Feb-2013 17:12:59] PHP Warning: fopen(/home8/wwrepair/public_html/parts/module_version/google_merchant_center_feeder.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 81
[18-Feb-2013 17:12:59] PHP Warning: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /home8/wwrepair/public_html/parts/module_version/google_merchant_center_feeder.txt in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 82
[18-Feb-2013 17:12:59] PHP Warning: fread(): supplied argument is not a valid stream resource in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 82
[18-Feb-2013 17:12:59] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 83
[18-Feb-2013 17:12:59] PHP Fatal error: 1054:Unknown column 'p.products_ean' in 'field list' :: SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_upc, p.products_isbn, p.products_ean
FROM znc_products p
LEFT JOIN znc_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN znc_products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN znc_product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = 1
AND (
p.products_image IS NOT NULL
OR p.products_image != ''
OR p.products_image != 'no_picture.gif'
)
GROUP BY pd.products_name
ORDER BY p.products_id ASC; in /home8/wwrepair/public_html/parts/includes/classes/db/mysql/query_factory.php on line 101

Never mind, I figured it out.

Resqjock:

Can anyone help me, I upgraded to ver 1.5.1 and tried to install the mod, but when I run the install SQL thru PHPmyadmin I get this error message,

SQL query: Documentation

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Debug', 'GOOGLE_PRODUCTS_DEBUG', 'false', 'Turn on simple debug?', @googlemerchantcenterfeederid, 0, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Google Merchant Center FTP Username', 'GOOGLE_PRODUCTS_USERNAME', 'ftp_username', 'Enter your Google Merchant Center FTP username', @googlemerchantcenterfeederid, 1, NOW(), NULL, NULL), (NULL, 'Google Merchant Center FTP Password', 'GOOGLE_PRODUCTS_PASSWORD', 'ftp_password', 'Enter your Google Merchant Center FTP password', @googlemerchantcenterfeederid, 2, NOW(), NULL, NULL), (NULL, 'Google Merchant Center Server', 'GOOGLE_PRODUCTS_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: hedwig.google.com', @googlemerchantcenterfeederid, 3, NOW(), NULL, NULL), (NULL, 'Google Merc[...]

MySQL said: Documentation
#1062 - Duplicate entry 'GOOGLE_PRODUCTS_DEBUG' for key 'unq_config_key_zen'

Ay ideas to correct this?

I figured it out

fakeDecoy:

Are there any plans to exclude a list of products by product id from being put into the feed?

Since Google Merchant Center is now a paid service through Adwords, with only a limited number o free clicks, it's now important to monitor and remove poor performing products from the feed.

I'm guessing no replies means that's a no? Just making sure before I try to go coding it myself.

this all seems to be working except that google will only import 139 products out of my feeds. My feed has over 1,000 products. Is anyone else having that issue?

problem solved...those darn special characters......items stopped loading when they started showing up in the list.....all loaded...boy, that was easy! Love this mod. We've been using an ancient version all these years in order to eliminate certain categories item by item, editing in excel. The option to by pass by category id is wonderful. At first I did not notice the extra menu options under Admin > Configuration....what a wonderful mod.

fakeDecoy:

I'm guessing no replies means that's a no? Just making sure before I try to go coding it myself.
No replies means no one answered tis all.. perhaps because they don't know or noone has had time to answer...

to answer your question I believe this mod already lets you include/exclude products.

fakeDecoy:

I'm guessing no replies means that's a no? Just making sure before I try to go coding it myself.

At first i missed the options under Admin > Configuration and there you can exclude by Manufacturer and by Category ID. Perhaps you are referring to where I don't see either where you can exclude by Product ID but I would move those products into a category that you can exclude. Excluding by individual Product id could prove to be a maintenance nightmare....which is probably why the mod developer did not go there.

fakeDecoy:

I'm guessing no replies means that's a no? Just making sure before I try to go coding it myself.Also if your question was addressed to the author of this module, he doesn't post here in this forum anymore nor does he update his free modules in the downloads here.. He MIGHT answer this question on his own forum, but last time I looked at his forums there was LOTS of spam and questions largely go unanswered there as well.. (paid support however is alive and well I can tell you from firsthand experience) I uploaded this module to the Zen Cart free downloads so that people were not confused about the differences between the 1.3.9 vs the 1.5 versions..

DivaVocals:

Also if your question was addressed to the author of this module, he doesn't post here in this forum anymore nor does he update his free modules in the downloads here.. He MIGHT answer this question on his own forum, but last time I looked at his forums there was LOTS of spam and questions largely go unanswered there as well.. (paid support however is alive and well I can tell you from firsthand experience) I uploaded this module to the Zen Cart free downloads so that people were not confused about the differences between the 1.3.9 vs the 1.5 versions..

The author has closed his forums permanently, which doesn't really mather because he didn't answer any questions for free anyway.

Design75:

The author has closed his forums permanently, which doesn't really mather because he didn't answer any questions for free anyway.
I imagine that eventually the free modules offered will follow suit.. Seems that the site has been moving towards a model of more premium modules/support offerings..