Google Base Feeder Support Thread [OLD]

Mickmo68:

If you're using the latest version, comment out the line below from includes/classes/google_base.php

It worked for me. Not sure what the repercussions are yet though.

anyone know what this line does and if/why it's needed?

// $str = htmlentities(html_entity_decode($str), ENT_QUOTES, 'UTF-8');
//

Thank you very much.  this worked for me as well.:clap:

Couple of glitches and hoping someone here can help.

I have a total of 395 active products of 401 total per my Admin.

With attributes added for size, color etc, the total number would be 540 if each was processed individually.

When I create my feed it says that 394 of 400 processed successfully. So I think I only really have one bad record as all other active products are processing.

When I go to open or view my feed I get an rss window asking me to subscribe. Once I do that I can view the feed.

The feed itself contains 776 products (that's about 236 extra?)

If I allow Google to fetch the feed it returns an error saying the feed is in HTML format. However if I manually upload it, it processes 187 or 188 records.

I only have one xml coding error on one product but where the heck did the other 200 or so go and how can I make the fetched file not upload as html so that I can set up a cron job to create the feed each day?

Thanks!

when searching for my products on google shopping the items titles are not displayed instead,(after searching my items) I believe meta tag titles. I have this set to off in admin>config>google merchant...
Is this the way it is supposed to display or how can I fix this?
Thank you

Ver. 1.10.1
I converted my store to UTF8 using Dr. Byte's tool (available in the Software add-ons).

I notice that there seems to be an issue where parenthesis in the products name will cause that item to be skipped without a debug message.
This is easy to fix, but it would help if the debug output ONLY display skipped and problem items.

Was there a post on how to fix <br> <ul> and <li> not converting to a white space?

thanks,
cj

Also seems to HATE commas in the products name!

1.10.1

Okay, while ferreting out several issues concerning the above...

I pulled the code from 1.9.1 to deal with the <li> and <br> issues.

It also seems that the product_name has to be unique:

$products_query = "SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, ...

Since this is done at the query level, any duplicated product_name will be skipped WITHOUT any kind of warning. Perhaps this was somewhere in the documentation and I missed it. So my above comments about commas and parenthesis are probably wrong.

I can understand why products_model should be unique, but why products_name?

feedback?
-cj

has anyone used the magneticone google base feed module? (http://www.magneticone.com/store/Zen.Cart.Modules/Zen.Cart.Google.Base.Data.Feed) wondering if it will work better than the current issues with this one.

Has anyone heard about updates to the Google Base Feeder to meet the requirements of the upcoming mandates from Google?

Great, thanks Delia.. my apologies, I wasnt aware the changes had already been implemented as I only got the email from google the other week

Thanks for your help! :)

thomaswhiteeagle:

has anyone used the magneticone google base feed module? (http://www.magneticone.com/store/Zen.Cart.Modules/Zen.Cart.Google.Base.Data.Feed) wondering if it will work better than the current issues with this one.

It does not work and they tell you to use this mod. Isn't that happy?

chadderuski:

1.10.1

Okay, while ferreting out several issues concerning the above...

I pulled the code from 1.9.1 to deal with the <li> and <br> issues.

It also seems that the product_name has to be unique:

$products_query = "SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, ...

> 
> Since this is done at the query level, any duplicated product_name will be skipped WITHOUT any kind of warning. Perhaps this was somewhere in the documentation and I missed it. So my above comments about commas and parenthesis are probably wrong.
> 
> I can understand why products_model should be unique, but why products_name?
> 
> feedback?
> -cj

That's dang good question as the cart I'm having problems with at the moment has duplicated product names.    Looking at the google information- it does recommend you put the specific information about your products in the title. For instance, if you have 2 teddy bears and one is yellow and one is red, the product name should be red teddy bear and yellow teddy bear and not just teddy bear. 

It does not say that duplicates will be rejected but I suspect they might be and that's why the mod is done that way.

I'm going to test that theory  and see how far I get though it may not be the problem in the cart that I am now working on.

That was not my problem on that cart but the answer remains, the author of the mod is under the impression that the product names should be unique. He may be right but I haven't found proof of that yet.

yorkshiregc:

Ive turned on Debug and get the following error message:

"Skipped due to user restrictions"

This is due to either an old version of the mod or a mix of incorrect files. If this happens to you, upload the latest version of the mod carefully - folder by folder if you need to.

delia:

That was not my problem on that cart but the answer remains, the author of the mod is under the impression that the product names should be unique. He may be right but I haven't found proof of that yet.

Hi Delia!

Actually, I had been using the 1.8.? version for quite some time at. 3200 products, with with no complaints on v_products_name, but that may be because I was using v_products_model as the key (which I believe must be unique).

I was having problems with UPC codes with 1.8, so I figured I'd just MAKE 1.10.1 work. Wasn't hard to do once I stopped complaining (sigh) and dug into the code. I think the change to unique products_name is tripping people up a lot.

ALSO, and this seems to be very important, to use 1.10.1 you MUST convert your cart to UTF8. This is not hard to do. Dr. Byte has a tool for doing the conversions. Once I did the conversion, and made all my products_name unique, I was able to get 100% of my products to export to the xml file and feed accepted by google.

I hope this info is helpful to you and others.

-cj

On google shop, we show up as taxable for every state when I change it "Your location: New Orleans, LA 70119 - Change".

Though on our Google account I have it set up properly as

"You will specify sales tax by state:
Michigan, US 6% "

Any clue as to why we show up that way - is it in the configuration? Should it be MI only?
Tax Region > tax applicable regions

1.3.9h

Went to create a feed today and noticed the Google Base feeder mod was missing all the options it had last month. Than it only created 2 products, instead of the 1200 each month.

If anyone knows how to get this working, I have not the time to play around with it. Please send me a PM with quote .

I updated my store to the most current version hoping to fix the issue that my UPC codes are not showing up in the Google products feed.

Now I am still have this problem and now I have a new problem as I got the following message when updating my feed.

Google Merchant Center Feeder v1.9.1 started 2011/08/03 11:47:53
Feed file - C:/inetpub/wwwroot/naturesorganic/httpdocs/feed/google/domain_products.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 58.266780 Seconds 645 of 944 Records

you can see for some reason it isn't loading all of my products, any help would be appreciated.

I already use this mod and it works great, will it still be compliant to Google's upcoming changes?

http://base-forum-announcements.##########################/2011/07/weve-made-changes-to-google-product.html

Hi,
I am using this app just fine on 1.3.9h....

I had one smll problem though which I have now resolved.

I use 1and1 hosting and the cron jobs can be setup in a GUI... It gives you fields to enter times and the command...

Anyway, I setup the job but it never run...

I spoke to my friend who knows unix miles better than me and he said to me... if you are gonna run a curl job on cron, you need to enclose the full http//xxxx-blah-blah in single quotes...

So I tried that..... And it works properly now....

looks like this now...

0 23 * * * curl -s 'http://www.my-domain.co.uk/googlefroogle.php?feed=fy_uy_tp&key=somekeyxxyy'

bryan7707:

I updated my store to the most current version hoping to fix the issue that my UPC codes are not showing up in the Google products feed.

Now I am still have this problem and now I have a new problem as I got the following message when updating my feed.

Google Merchant Center Feeder v1.9.1 started 2011/08/03 11:47:53
Feed file - C:/inetpub/wwwroot/naturesorganic/httpdocs/feed/google/domain_products.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 58.266780 Seconds 645 of 944 Records

you can see for some reason it isn't loading all of my products, any help would be appreciated.

if it was anything like mine at first, go look at product 646 and see if it fails there because there are chrachters like the ampersand in description of image name...

It was hittng a product and not just leaving it out, it was stopping the whole sequential load.

I had maybe 8 images that had ampersand in name, changed them one by one and then got all my products to load...