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

OK, help needed again, I can get all items downloaded using the Google Merchant Feed now in 5 files. The first two are 1500 each and are ok to use. The 3, 4, and 5th xml files downloaded have a problem. Each item, instead of all column entries being on one line, the first three column entries are lined up in a row but the rest drop one cell for each column. So those three .xml files have 14 lines for each item. They look like this:

1 heading heading heading heading heading heading heading and so on.....
2 item.......entry.......entry
3 .......................................decription
4 .....................................................url
5 ..................................................................image
6 ...............................................................................price
and so on...

(Without the dots, had to insert them on here to make it look like the file does, they don't exactly line up on here like they should.)

hopefully you can get the idea. Each item is this way, 14 total lines for each item instead of just one.
The column headings are ok but the entries for each product drop on cell for each column.

Anyone have any ideas why this is happening? I use Excel2003 and after I download each file and move it to my desktop I open Excel and use File/Open to open the xml file.

Thanks for any ideas anyone can give me,

Jim

Configuration->Google Merchant Center Feeder Configuration page
error: PHP Fatal error: Call to undefined function google_cfg_pull_down_country_list() in /home/obsbscom/cellphone-express.com/gli/configuration.php(217) : eval()'d code on line 1
search the plugin folder by xsearch, the string google_cfg_pull_down_country_list appeared in install.sql only.

su35:

Configuration->Google Merchant Center Feeder Configuration page
error: PHP Fatal error: Call to undefined function google_cfg_pull_down_country_list() in /home/obsbscom/cellphone-express.com/gli/configuration.php(217) : eval()'d code on line 1
search the plugin folder by xsearch, the string google_cfg_pull_down_country_list appeared in install.sql only.

Got solution on http://www.zen-cart.com/showthread.php?67850-Google-Base-Feeder-Support-Thread/page285

Hello all,

Disregard my last post, I found the problem that was causing it and got it fixed. Three product descriptions caused it.

I downloaded the first two xml files of 1500 products each but then had to reduce the next download down to 500 product in order for it to download all of them and then I couldn't download the rest at all.

Here is the error log I got this morning, can anyone tell me from it what I need to look at now. Thanks, Jim

[10-Jan-2014 08:47:13 America/Chicago] PHP Fatal error: 2008:MySQL client ran out of memory :: select pa.products_attributes_id
from zc_products_attributes pa
where pa.products_id = '7568' limit 1 in /home2/jstiles/public_html/includes/classes/db/mysql/query_factory.php on line 120
[10-Jan-2014 08:47:13 America/Chicago] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from zc_sessions
where sesskey = '7dc4cfb79a517cc3ae66d3b87cd64aad' in /home2/jstiles/public_html/includes/classes/db/mysql/query_factory.php on line 120

Not sure, but did you try to increase the memory limitation?
configuration=>google mer....=>Memory Limit

su35:

Not sure, but did you try to increase the memory limitation?
configuration=>google mer....=>Memory Limit

I tried that earlier but it didn't make any difference but I need to try it again now that I found and fixed some database errors. I also found the below statement in the googlefroogle.php file but not sure what or if I should make any changes here or not.

if ((int)GOOGLE_PRODUCTS_MAX_EXECUTION_TIME > 0) {
ini_set('max_execution_time', (int)GOOGLE_PRODUCTS_MAX_EXECUTION_TIME); // change to whatever time you need
set_time_limit((int)GOOGLE_PRODUCTS_MAX_EXECUTION_TIME); // change to whatever time you need
}
if ((int)GOOGLE_PRODUCTS_MEMORY_LIMIT > 0) ini_set('memory_limit', (int)GOOGLE_PRODUCTS_MEMORY_LIMIT . 'M'); // change to whatever you need

I don't think it is a good idea to modify the code directly. All the memory and time limitations could be set on configuration filed.

Also try, tools=>store manger=>Optimize Database

i now getting the following in error log

PHP Warning: preg_match() [<a href='function.preg-match'>function.preg-match</a>]: Compilation failed: missing ) at offset 30 in /home/public_html/includes/classes/google_base.php on line 42

Getting a simular error in logs as River city

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select count(*) as count
from categories
where parent_id = '154' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = 'a59debf412ff965efb1187c10bd2c51d' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

kitcorsa:

Getting a simular error in logs as River city

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select count(*) as count
from categories
where parent_id = '154' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

[17-Jan-2014 12:13:15 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = 'a59debf412ff965efb1187c10bd2c51d' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

Never got a remedy for it even from Numinix, did find out from them to check my host for timeout settings, even when they say "unlimited". That was and is a problem with my current host so looks like I'll have to live with it for now. I am switching from the free Google Merchant Feed plug in to the $35 Google Product Search feed module which from what I understand is a more stable module and more forgiving on .xml errors that Google doesn't use anyway. I was told that it would not help with the timeout issue as that is most probably caused by the host settings. I also found a few errors in my data that might have been causing some problems. I finally got several smaller downloads that I put all in one file and got it to upload to Google ok.

I have a VPS so i can alter my time out setting as I require so ill up my timeout and see what happens.

How ever when you making numberious files and then merging??? you can upload numberious files to google merchant centre you know... just need to give google the feed name. I currently export 5 xml files each with 500 product in and upload to google individually. All done via cron jobs on a night.

I do have an issue though with a product as the feed seem to fail on a product and halts but doesn't say when. Checked the product and can't see any issues with it....

kitcorsa:

I have a VPS so i can alter my time out setting as I require so ill up my timeout and see what happens.

How ever when you making numberious files and then merging??? you can upload numberious files to google merchant centre you know... just need to give google the feed name. I currently export 5 xml files each with 500 product in and upload to google individually. All done via cron jobs on a night.

I do have an issue though with a product as the feed seem to fail on a product and halts but doesn't say when. Checked the product and can't see any issues with it....

I prefer to do my uploads manually, don't know why, just do. Someone else had mentioned I could make several smaller uploads to Google just by giving them the file names. I may do that once I make sure I don't have any more data errors to overcome. If you know which product or group of products that are stopping your feed, go back and remove any html tags in the description or name field, I did that on some and they worked ok afterwards, apparently, there are some html tags that don't work well with Google I guess, no other explanation. Once I removed the tags and made the description for those items text only, they all worked.

Cant seem to generate a feed.
using zencart 1.5.1
Ultimate SEO Urls
switched on debug
go to admin tools gmcf and select products, 0, 1 cofirm and it just pops up the home page. and the xml file it writes doesnt have any products???

Any ideas?

I've just discovered why my website traffic has tanked. Logging into my Google Merchant account and checking my feed status, 0 of my 40,000 products are being listed due to "expiration date is in the past" error. I am using ZenCart version 1.5.1 and Google Merchant Center Feeder 1.13.0. My Expiration Date Base is set to "now", and Expiration Date Adjust is set to "29". However downloading my feed shows an expiration date of 12/8/2013. Something isn't working properly when the feed is created. Can anyone offer a suggestion?

OK, I MAY have solved the issue. I went to Configuration/Google Merchant Center Feeder Configuration and changed Expiration Date Base to "product" and clicked "update". Then changed it back to "now" and clicked "update". Also, I changed Expiration Date Adjust to "30" and clicked "update". I then went over to Tools/Google Merchant Center Feeder and clicked "Confirm" on all my feeds to create new XML files and manually uploaded to Google. No idea which of these had any affect, but Expiration Date is no longer a field in the XML file and Google isn't kicking out any errors. Time will tell if this was a true fix or just a bandaid...

Google have just suspended my account because the feed shows prices without tax! How can I force it show prices with tax.
Im in UK and using google uk.

Anyone currently using MagneticOne's Google Data Feed plugin? I've read a few good posts and a few bad ones. Not sure which way to go, Numinix's paid version (Google Shopping feed) looks good but MagneticOne's looks like it does a lot more but the split reviews have me concerned.

anyone got this running as a cron??

For somereason i am unable to get the cron jobs to work. Cron is turned on on my server etc as i have other crons working, but unable to get the feed or upload to run as a cron.

i have thefollowing process cron

curl -s '/home/public_html/googlefroogle.php?feed=fy_un_tp&limit=500&offset=&x=47&y=15&key=***********'

and a upload later the same night

curl -s "/home/public_html/googlefroogle.php?feed=fn_uy&upload_file=google_products_en_500.xml&key=***********"

tryed with ' and " never make a difference, tried the PHP and other cron actions but to no joy. No error being emailed to me as a problem.... but the feed in google not showing an updated file

any thoughts??

kitcorsa:

anyone got this running as a cron??

For somereason i am unable to get the cron jobs to work. Cron is turned on on my server etc as i have other crons working, but unable to get the feed or upload to run as a cron.

i have thefollowing process cron

curl -s '/home/public_html/googlefroogle.php?feed=fy_un_tp&limit=500&offset=&x=47&y=15&key=***********'

and a upload later the same night

curl -s "/home/public_html/googlefroogle.php?feed=fn_uy&upload_file=google_products_en_500.xml&key=***********"

tryed with ' and " never make a difference, tried the PHP and other cron actions but to no joy. No error being emailed to me as a problem.... but the feed in google not showing an updated file

any thoughts??

Typically there is more in front of the public_html directory in a cron but you could also use the actual url instead https://www.YOUR_DOMAIN.com/googlefroogle.php?feed=fn_uy&upload_file=google_products_en_500.xml&key=***********"

Can you navigate here using your web browser? have you tried wget versus curl -s ? How does the cron for your sitemap XML compare?

RiverCity:

Anyone currently using MagneticOne's Google Data Feed plugin? I've read a few good posts and a few bad ones. Not sure which way to go, Numinix's paid version (Google Shopping feed) looks good but MagneticOne's looks like it does a lot more but the split reviews have me concerned.
The SUPPORT THREAD for this module is NOT the right place to ask opinions about a COMPETING module.. IJS..