Google Base Feeder Support Thread [OLD]

If your database has a prefix, then the table names will look something like "zen_configuration", where "zen_" is the prefix. If they don't have a prefix, the names will just be like "configuration".

As for your other question, I'm not entirely sure what you're asking? The files in the mod are already in the correct file structure, so you just upload the whole mod the way it is to your Zen-Cart site. You don't need to move any files to different directories.

Do you access your admin at https://www.yoursite.com/admin, or a different link?

Yes, it uses a prefix. Because if I use phpAdmin from mycpanel to look at my database, all of the fields have zen_ before them.

I also used it to look into the configuration and non of the stuff that should have been inserted into it was.

I don't go thru mysite/admin -> she renamed it for me.

As for the file structure, I'm reading the directions to google base feeder, and it says to upload files to store directory. Well, there are folders, do I put the folders there too or the stuff in the folders into similar folders. I also read that when making changes, never to change the original files, that you make copies and then it goes into another folder (am I making any sense).

Linda

I also went through all of the folders and she put then all in the correct place (I get it now, since new files, don't need to replace/rename anything)

I got it!:clap:

When I tried to run the SQL, it gave me an error about a NULL key already being there. So I did a query search on that field and found one with a null. I deleted it and then ran the query again and IT WORKED!

Now to figure out the rest. I am curious as to why you asked about the prefix, in case this might help me in other areas.

Thank you again
Linda

When I upload to google I get the following in my xml file:

18quot;x12quot; when it should be 18"x12"
I also get & in the descriptions when it should be &

ryanb4614:

When I upload to google I get the following in my xml file:

18quot;x12quot; when it should be 18"x12"
I also get & in the descriptions when it should be &

This has already been talked about many times in this thread. Please read at least some of the thread to find the answer, or do a search within the thread.

As of April 23rd I have suddenly ran into problems with my data feed.
On April 22nd my feed worked as usual... inserting all products.
Starting with the April 23rd upload google processes the feed on 800+ products as '0 of 1 items inserted'.
I added no new products between this time... so this leads me to believe that google made changes to the way it reads the feeds.
Has anyone else ran into this issue?
Any resolution?

I get this message from google...
Our system encountered an error when processing your data feed.
Line Nr. Column Nr.
15 78

Line 15 looks like this...

"<link>http://www.experimedia.net/index.php?main_page=product_music_info&products_id=706</link>"

Like I said no problems on the 22nd then suddenly having issues on the 23rd when there were no changes to my system, feed, or new products.

jbible:

As of April 23rd I have suddenly ran into problems with my data feed.
On April 22nd my feed worked as usual... inserting all products.
Starting with the April 23rd upload google processes the feed on 800+ products as '0 of 1 items inserted'.
I added no new products between this time... so this leads me to believe that google made changes to the way it reads the feeds.
Has anyone else ran into this issue?
Any resolution?

I get this message from google...
Our system encountered an error when processing your data feed.
Line Nr. Column Nr.
15 78

Line 15 looks like this...

"<link>http://www.experimedia.net/index.php?main_page=product_music_info&products_id=706</link>"

Like I said no problems on the 22nd then suddenly having issues on the 23rd when there were no changes to my system, feed, or new products.

I have the same problem on three zen sites on two servers. Google is rejecting the feeds with an error that the format does not match. I guess Google changed the required fields.

I haven't had any recent problems with feeds rejecting, but I have run into issues that might be related. Google is said to be tightening down on the characters they'll process in a feed. The worst issues I've seen is when I've cut and pasted text from a Word processor or other formatted source rather than typing it direct, or passing it through a text editor.

You might pull up the item in question (the one that was being processed when the error occurred) and look for dashes, quotes and any other punctuation. I'm had problems with both of those.

Another possibility would be a communications timeout. If the feed wasn't fully uploaded, that would create issues.

I finally got the thing installed but when I try and configure the feed it gets a blank page when going to:

googlefroogle.php?feed=fy_un_tp

Is there a simple answer to this?

Also it says in the instructions to register the xml file in the bulk upload, I don't see that anywhere either.

geolab:

I finally got the thing installed but when I try and configure the feed it gets a blank page when going to:

googlefroogle.php?feed=fy_un_tp

Is there a simple answer to this?

Also it says in the instructions to register the xml file in the bulk upload, I don't see that anywhere either.

Geolab,

I assume you ran the SQL patch as instructed. Did you change the permissions of the "feed" directory to 777? If you don't have command line support for the chmod command, most servers offer a graphical interface like CPanel that will let you do this.

When they're talking about registering the feed, they mean you have to create a Google Base or Merchant Center account (on Google) and configure that with the name of your upload file, obtain the FTP credentials, etc.

Hope that helps. Good luck!

This is a wonderful mod. I couldn't live without it.

Yes, I followed the instructions and have changed the CHMOD through the Host CP.

I am a newbie but I just got this to work two weeks ago so maybe this will help.

If you look in feed directory, you will see the name of the file you need to register. Mine is:

domain_products.xml

I can't remember if that is hardcoded or if I chose itl. You take this name and register it with google merchant.

https://www.google.com/merchants/bulkuploads

You will create a new feed here with this name. Hope it helps.

My feed directory has index.html in it, no xml file. Does anyone know what had gone wrong?

geolab:

My feed directory has index.html in it, no xml file. Does anyone know what had gone wrong?

My guess would be you haven't changed the permissions on your "feed" folder yet. It must be set to 777. If you don't have command line support for the chmod command, most servers offer a graphical interface like CPanel that will let you do this.

You can also use these tools to check what it's set to. Sometimes it doesn't "take" when you do this in CPanel.

Recently my feed has been getting disapproved no matter what. I have not had any problems up until the last couple weeks. I am still on Zen 1.3.8a and just re-downloaded Google Feeder from the downloads. All it fixed was making it upload to Google. Feed is still disapproved. They don't give me any reasons, or show that there are any errors.

jbible:

As of April 23rd I have suddenly ran into problems with my data feed.
On April 22nd my feed worked as usual... inserting all products.
Starting with the April 23rd upload google processes the feed on 800+ products as '0 of 1 items inserted'.
I added no new products between this time... so this leads me to believe that google made changes to the way it reads the feeds.
Has anyone else ran into this issue?
Any resolution?

I get this message from google...
Our system encountered an error when processing your data feed.
Line Nr. Column Nr.
15 78

Line 15 looks like this...

"<link>http://www.experimedia.net/index.php?main_page=product_music_info&products_id=706</link>"

Like I said no problems on the 22nd then suddenly having issues on the 23rd when there were no changes to my system, feed, or new products.

I have a similar error

I edited it and added "www." to the domain and manually re-submitted. Now Google tells me it liked the file (no errors) but no product was inserted.

GGGGGGGRRRRRRRRRRR What do I do now?

Yeah google obviously changed something a few weeks ago and is rejecting feeds for some reason. Hope to get this resolved soon as I have watched my sales decrease quite a bit since it started rejecting the feeds.

I'm getting the same error.... it says the error is in line 14 column 87.

This is the line in question.....

I've counted it out on mine as well as others who have posted the same error messages and the error always points to the equal sign in the 'product_id' section(in my case it's product_id=596).

If I remove that product listing from the file and run it again, I get the same error on the next product, again, pointing to the equal sign in the 'product_id' field.

I believe the real issue is in the & symbol.... Has google changed something to not like the & symbol in files? I'm not an expert at this but this is what it seems like.

Any thoughts?

nehoward64:

I'm getting the same error.... it says the error is in line 14 column 87.

This is the line in question.....

<link>http://www.howardsfpi.com/hfpistore/index.php?main_page=product_info&products_id=596</link>

I've counted it out on mine as well as others who have posted the same error messages and the error always points to the equal sign in the 'product_id' section(in my case it's product_id=596).

If I remove that product listing from the file and run it again, I get the same error on the next product, again, pointing to the equal sign in the 'product_id' field.

I believe the real issue is in the & symbol.... Has google changed something to not like the & symbol in files? I'm not an expert at this but this is what it seems like.

Any thoughts?

OK wise ones.... :smile: My suspicions were correct. After several hours of pouring through code books I haven't dealt with in about 15 years, and reading through several hundred messages in this forum, I have discovered that the '&' is the problem in the <link> line of the file. After changing all occurrences of it to '&' with notepad++ and manually uploading it, google liked my file and listed all of the products.

The question is, does anyone know how to either make the base feeder do this automatically when the file is generated, OR, some automatic way of doing this so the base feeder will FTP the file without me having to manually change all the ampersands and manually uploading the file? Although I used to write communications software for UNIX 20 years ago, I'm a bit out of touch and haven't dug into the code(or had the time to) to figure this out.

Any input would be appreciated!

Thanks in advance(only because I know some smart person probably already has the answer :D )