Google Base Feeder Support Thread [OLD]

Kunal:

i don't know if this is addressed to me, but my issue isn't with feeding the data to google. It's with creating the xml file of all my products. i don't know if this mod can handle a large number of products or not, it seems to just stop at 5-6k, with no error messages. It just stops.

Do you have a dedicated IP address on your server? If you do what is your setting for admin/configuration/google_base/Product Type set at ( top, bottom, or full). If it is set to top try setting it to full and try creating your feed again.

i don't have a dedicated ip on my server, i'm not using the auto feed feature of this mod. I just want it to generate an xml file of all my products. i've tried all 3 top/bottom/full. But no change, the process still stops before completing. i called my hosting company and they ran checks on the mysql databases, and they said all the connections were fine..

i feel this mod is losing connection to my database, it's not timing out, or giving me any errors, it just stops..

Kunal:

i don't have a dedicated ip on my server, i'm not using the auto feed feature of this mod. I just want it to generate an xml file of all my products. i've tried all 3 top/bottom/full. But no change, the process still stops before completing. i called my hosting company and they ran checks on the mysql databases, and they said all the connections were fine..

i feel this mod is losing connection to my database, it's not timing out, or giving me any errors, it just stops..

Do you have the word press module installed, if so then it will case conflict with the Google base module.

nope, i have the sitemap xml module, but that seems to be working fine. i have many other modules too, but i think if it were a conflict, then it wouldn't process any products at all. but it processes about 25% of the products then just stops..

Kunal:

i don't have a dedicated ip on my server, i'm not using the auto feed feature of this mod. I just want it to generate an xml file of all my products. i've tried all 3 top/bottom/full. But no change, the process still stops before completing. i called my hosting company and they ran checks on the mysql databases, and they said all the connections were fine..

i feel this mod is losing connection to my database, it's not timing out, or giving me any errors, it just stops..

One more question. What is your setting for admin/configuration.google_base/Image Handler. If you have that on make sure that the switch for using image handler is set to false as this can take a lot of resources. Just trying to help. What is your store address so I can take a look.

i tried that too, and thanks i do appreciate the help. it's just buggin me that i can't figure out what's causing it to just stop..

Kunal:

i tried that too, and thanks i do appreciate the help. it's just buggin me that i can't figure out what's causing it to just stop..

Does it say how many product it wrote to the xml file when it times out.

that's the weird thing, it process a different amount every time i run it. the file size fluctuates between 8-10mb, and different every time.

i don't think it's timing out, i don't know if it's like hitting a certain product and it's unable to process it? or just losing connection to mysql ..

Kunal:

that's the weird thing, it process a different amount every time i run it. the file size fluctuates between 8-10mb, and different every time.

i don't think it's timing out, i don't know if it's like hitting a certain product and it's unable to process it? or just losing connection to mysql ..

Question=Is there a limit of number of products that your script will output to google?
Answer=There is no limit. Make sure all of your products meet the requirements to be listed on Google Base. The feeder will not include products which do not meet the minimum requirements.

I don't think the feed is writing all the products to the xml. I have 11000 and google base it is saying that it only processed ~3000.

Question= If google base didn't include some of them would the process number be 11,000 and the inserted number would be ~3000
Answer= yes, that is what I said. The feed skips products that do not meet the requirements.

Oh ok i see what your saying. the feed doesn't write it to the xml file if it is not vaild. Ill look into why the products are not vaild.

I got this off Numinix.com . So what he is saying if your products don't meet requirements they want process.

Also Query Cache 1.6 conflicts with this module also.

that's true, i think i read over that too. i purposely made a group of products have less than 15 characters in their description (15 is min for google) and ran the debug to test it out. It gave me the error messages as 'failed' and continued to move down the list.

this test shows that even if they didn't qualify for google, it would just skip over it, but it still just stops after awhile..

i don't have query cache installed

Kunal:

that's true, i think i read over that too. i purposely made a group of products have less than 15 characters in their description (15 is min for google) and ran the debug to test it out. It gave me the error messages as 'failed' and continued to move down the list.

this test shows that even if they didn't qualify for google, it would just skip over it, but it still just stops after awhile..

i don't have query cache installed

Did you make and php.ini file and put in the root of your server (not store root)> max_execution_time = 300

max_input_time = 90
memory_limit = 32M

yup i've got that in place as well.. do you know of another feed generator that might work?

Kunal:

yup i've got that in place as well.. do you know of another feed generator that might work?

No I don't, not right now. Something on your side is not quite right for it not to be able to handle all your products. To be honest I just don't know with out looking at it myself, and then I can't guarantee anything.

okay, i re-installed the mod and it still stops after awhile, but running the debug tells me there's a problem here

GOOGLE_FROOGLE_OUTPUT_BUFFER_MAXSIZE

that text is found here:

includes/classes/google_base.php

i can't seem to find where to adjust this output buffer size?

Kunal:

okay, i re-installed the mod and it still stops after awhile, but running the debug tells me there's a problem here

GOOGLE_FROOGLE_OUTPUT_BUFFER_MAXSIZE

that text is found here:

includes/classes/google_base.php

i can't seem to find where to adjust this output buffer size?

Download this file and upload it to your /includes/classes and see if it will work for you. I had to change out the google_base_xml_sanitizer. The file is from Google base 1.7.3A but I use the google_base_xml_sanitizer from 1.7.0a. Back up that file before you replace it.

I finally got it to work!

I went to my cPanel > PHP Config and generated the single php.ini

in that file i adjusted the variables for the buffer, input time, execution time, memory limit etc..

i also added that file, thank you countrycharm. now the mod actually says "Google Base File Complete.."

thank you for all your help tackling this problem, it was really hacking at me, and i'm glad we worked it out :-)

Kunal:

I finally got it to work!

I went to my cPanel > PHP Config and generated the single php.ini

in that file i adjusted the variables for the buffer, input time, execution time, memory limit etc..

i also added that file, thank you countrycharm. now the mod actually says "Google Base File Complete.."

thank you for all your help tackling this problem, it was really hacking at me, and i'm glad we worked it out :-)

You are very welcome. I glad you finally got it working. The file I gave you also solve other problems with Google Base. If you need help again we are here to help:smile:

The last 3 weeks I have tried to create and upload a new feed to Google Base and the upload fails every time. It's worked perfect up until recently. Was there an update to the mod or Google Base? What else would cause this? :shocking:

We have a tax problem with Google Base generated file, we export the file and checked is using MS Excel.

In the last column (tax), only certain products has tax, in addition we have Illinois tax setup in our admin. This applies to all prodducts, but in Google base generated file, almost 60% of theproducts doesn't have their tax, it is just blank.

Anyone can give us a hint?

Thanks!

ok i have seen tons of ppl talking about the connection issue with google base. But i have yet to see a solution?

not that it matters because I just scheduled google to fetch my feed, but this module cannot connect to google?

everything creates fine, but connection to google fails? So, if I scheduled google base to fetch this file itself then does it really mater if this wont connect on its own?