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

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

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

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.

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

nothing in the ZC logs or server error logs

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.

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

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

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

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.

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? :blink:
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

MikeGall2 have you tried the the addial products dielfs mod?? this is mad by Numinix who also makes this google feed mod?? https://www.numinix.com/downloads/zen-cart-modules/admin/numinix-product-fields-dl-800

Buildingblocks, I haven't tried via catogory, but if i build 500 products at a time then i can get my entire catalog done with no issues.

I currently have 5000 products (or there abouts) so creating 10 feeds on at a time is very time consuming... I could do by cron but rather do it by hand as i know its defo done then

do spot something wierd though in when i ask for 500 products i get the following

Google Merchant Center File Complete In 21.457712 Seconds 800 of 500 Records

800 of 500??

Hello,
I have Zencart 1.5.1 and have Google Merchant Feed v1.13 installed. I just tried to run it a few ago and got this message, not sure if I did something wrong or what. I went to the configuration for it and saw on the first item when I hit Edit, it had an option to update, would this 'update' button actually update my version of the Google Merchant Feed automatically or what?

Here is the message I'm getting right now, thanks for any help anyone can send my way.

Google Merchant Center Feeder v started 2013/12/16 23:48:15

Feed file - /xxxxxx/xxxxxxxx/public_html/feed/google/missyscollectibles_products_en_4000_1.xml

Processing: Feed - Yes, Upload - No

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

Ok, I've been told this is due to a time out in the script and that I would need to create my merchant feed in batches and then put them together into one file. I have 4801 products and was able to get the first file making the settings of max number of products = 2000 with a starting point of 0. I was able to download that xml file ok.

I then had 2801 products left so I refreshed the page and set the max number at 1400 with a starting point of 2001, a file was created but I haven't been able to open it, I get an error saying "xml parse error".

I then tried the last 1401 products by entering 1401 as the max products with a starting point of 3401 but wasn't able to create a file at all. I know I've got the products split into three managable numbers. My first starting point was 0 in order to get the first 2000 items, my second starting point was 2001 which would be the beginning number of the next 1400 items, the third starting point was 3401 which would have been the first line item on the third set.

Anyone have any ideas on this, I really need this goggle merchant feed to work as it is my main source of advertising and where most of my customers come from.

Thanks,
Jim

Sorry for posting my problem above, it didn't dawn on me that the problem had already been posted by someone else. I have one question maybe someone can answer. I'm trying to download my 4801 products with the Google feed in 4 feeds, the problem I'm having, I think, is the correct starting point for each feed I try to run, if I have 4 feeds of 1000 each wouldn't the starting points be in this order: 0, 1001, 2001, 3001.

Thanks,
Jim

with the newest version of the module it does assist with server load, which version are you using?

I've got version 1.13.0

im using Google Merchant Center Feeder v1.14.2 and still have the problem

I had the newest version installed the other day but haven't had a chance to check it yet as the following day my site went down, Hostgator says it's a possible security issue and is investigating so I'm dead in the water for now until they can clear the site and I can run a restore on it. All I get now is a blank page but I can still log into my admin and cpanel so I don't knwo what's going on with it.

Still have a little trouble trying to download the files needed. I have 4801 total products. I thought I'd try to get them 1500 at a time and then the final 301. I can get the first two files by using 1 as the starting point on the first one with total number of products 1500. On the second one I used 1501 as the starting point with 1500 as the max number. I tried to get the third download using 3001 as the starting point with 1500 as the max number but it doesn't download anything at all. What am I missing?

Thanks
Jim