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

[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.

[WWRepair]

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

[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.

[athena]

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?

[athena]

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.

[DivaVocals]

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.

[athena]

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.

[DivaVocals]

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

[Design75]

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.

[DivaVocals]

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