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

[kitcorsa]

I have recently upgraded to 1.5.1 from 1.3.9 and installed the latest 1.14.1 version without any visual issues.
Configured the plugin to match my 1.3.9 setting etc and ran the function but it fails to create the feed file.
Switch debug on and i get about hal way though my product list and get the following error
id: 2581, price: 1328.06, description length: 352 - including - success
id: 2582, price: 184.99, description length: 1288 - including
WARNING: An Error occurred, please refresh the page and try again.WARNING: An Error occurred, please refresh the page and try again.


how do i solve this??

[kitcorsa]

plug in working fine if i do 500 products at a time... but that 6 takes ages!!
old plugin on 1.3.9 used to do the whole site in one go no problem

[kitcorsa]

since upgrading plugin fails!

id: 2532, price: 54.99, description length: 530 - including - success
WARNING: An Error occurred, please refresh the page and try again.WARNING: An Error occurred, please refresh the page and try again.

debug log is pointless as the error doesn't help at all.

Have upped my memory on my VPS and etc etc etc and no difference.

[kitcorsa]

I have done a complete uninstall and a complete reinstall and still no joy.

nothing in the ZC logs or server error logs

[kitcorsa]

also noted that the install instructions are FAQ are incorrect, as it says about editing the php file... but sure this isn't needed anymore as this version has the memory and time etc in the config options.

[kitcorsa]

checked my debug file again and have this error

[09-Dec-2013 13:31:22 Europe/London] PHP Warning: include(/home/xxxxxx/public_html/xxxxxx/includes/languages/english/npf_definitions/.svn) [<a href='function.include'>function.include</a>]: failed to open stream: Inappropriate ioctl for device in /home/xxxxxx/public_html/xxxxxx/includes/languages/english/extra_definitions/npf_defines.php on line 34
[09-Dec-2013 13:31:22 Europe/London] PHP Warning: include(/home/xxxxxx/public_html/xxxxxx/includes/languages/english/npf_definitions/.svn) [<a href='function.include'>function.include</a>]: failed to open stream: Inappropriate ioctl for device in /home/xxxxxx/public_html/xxxxxx/includes/languages/english/extra_definitions/npf_defines.php on line 34
[09-Dec-2013 13:31:22 Europe/London] PHP Warning: include() [<a href='function.include'>function.include</a>]: Failed opening 'includes/languages/english/npf_definitions/.svn' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxxxx/public_html/xxxxxx/includes/languages/english/extra_definitions/npf_defines.php on line 34


which appears to be with the additional products info plugin the UPC and barcode numbers etc.... corrected to the resion i get the
WARNING: An Error occurred, please refresh the page and try again.


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

set the UPC to false in the config and still get the error!!

as said mod working if i set a lower limit, ie 500 products at a time, but i need all products in one file as the feed is also used for other apps

[bislewl]

Something is wrong with you npf configuration/setup, please resolve this (other thread) and then this should be resolved

[kitcorsa]

resolved the npf errors above but still getting

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

nothing in the error logs!!

[buildingblocks]

Have you tried narrowing it down to which category it stops generating at? Generate a feed one category at a time. Even though you don't get an error log for it, I wonder if you have any special characters in one or more descriptions which is choking it.

[MikeGall2]

Firstly, apologies if this is the wrong support thread, I'm not sure which version of the plugin our website's using and not sure how to find out.
We just want to add an EAN to our product feed, should be simple, right?
We tried setting the EAN/UPC value in the feed config to true and tried putting the EAN in the UPC field on our product listings, and we got an error when trying to upload the feed. The error is as follows:

Processing: Feed - Yes, Upload - No

1054 Unknown column 'p.products_ean' in 'field list'
in:
[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_condition, p.adwords_labels, p.excluded_destinations, p.products_weight, p.products_upc, p.products_isbn, p.products_ean FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN 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 GROUP BY pd.products_name ORDER BY p.products_id ASC;]

Ideally we'd like to just add a new field into our product listings to input the EAN, but not sure what edit we'd have to make to the plugin code to make it recognize that field as the EAN and give that info to Google.

Any help at all would be greatly appreciated. The site is ravsappliances.com, running on Zencart version 1.3.8a