Google Base Feeder Support Thread [OLD]

Folks, if you aren't on 1.3.9h, you can have other problems - finish out your upgrades before installing any else!

Just wanted to let everyone know.. the new shipping requirements to the google base feed have been extended to september.

Just read on the google merchant blog On March 14, we let you know about a new set of data requirements for Product Search merchants. As part of these changes, we communicated that shipping and tax information would be required in your data feeds as of June 6.

However, based on feedback we’ve received from merchants, we are extending the deadline until September 1, allowing you more time to modify your data feeds. We are also permitting estimates for tax/shipping information. However, we recommend reviewing the submission options and submitting the most accurate information that you can, as this ensures the best experience for shoppers.

http://googlemerchantblog..com
So no need to go crazy this monday. Is there anything I need to do or watch for any fix for my feed by then? I am unclear as to weather shipping information as is in the feed will suffice.

My feed runs ok, but I get the following error:

1054 Unknown column 'p.products_upc' in 'field list'

Any ideas how to remedy this issue?

willieWontGo:

My feed runs ok, but I get the following error:

1054 Unknown column 'p.products_upc' in 'field list'

Any ideas how to remedy this issue?

You need to install either the numinix product fields or the other mod in the admin that creates the UPC/ISBN in your product table.

In the log run the Numinix Product fields will be your best bet and the link to the mod is here: http://www.numinix.com/zen-cart-modules/admin/numinix-product-fields

Please keep in mind that it's for 1.3.9g so you will have to compare the core files overriden to your current installation if it's newer than 1.3.9g (which should be 1.3.9h).

BlessIsaacola:

You need to install either the numinix product fields or the other mod in the admin that creates the UPC/ISBN in your product table.

In the log run the Numinix Product fields will be your best bet and the link to the mod is here: http://www.numinix.com/zen-cart-modules/admin/numinix-product-fields

Please keep in mind that it's for 1.3.9g so you will have to compare the core files overriden to your current installation if it's newer than 1.3.9g (which should be 1.3.9h).

Thank you for the suggestion!

I see the Numinix download contains new files as well as other files that will be modified. I understand that part of it.

However, there are also separate folders with 'optional fields'? One of them is titled "upc_isbn", do I need to add those as well?

Thank you very much for your help.

Darn, now I get the following error:

1054 Unknown column 'pd.products_description2' in 'field list'
in:
[SELECT p.products_weight, pd.products_description2 FROM zen_products p, zen_products_description pd WHERE p.products_id = 4 AND p.products_id = pd.products_id AND pd.language_id = '1' LIMIT 1]

What could I be missing?

Just discovered I did not install the "Second Description" folder and corresponding sql code.

OK, finally got this baby to work.

Checked the debug logs and found the errors: PHP Warning: htmlentities() [<a href='function.htmlentities'>function.htmlentities</a>]:......includes/classes/google_base.php on line 277........

Looked back in this thread, and followed the advice:

Inside includes/classes/google_base.php, I changed the code on Line 276, and then commented out Line 277.

Bada bing, bada boom, zero errors! :yes:

Uploaded to a Google Test Feed. Uploads fine, but I get a warning that the Weight descriptors are not included.

The only thing, now I have a Second Description field that I did not want, but installed it so I could get this to work.

All in all, it's a good day!

willieWontGo:

OK, finally got this baby to work.

Checked the debug logs and found the errors: PHP Warning: htmlentities() [<a href='function.htmlentities'>function.htmlentities</a>]:......includes/classes/google_base.php on line 277........

Looked back in this thread, and followed the advice:

Inside includes/classes/google_base.php, I changed the code on Line 276, and then commented out Line 277.

Bada bing, bada boom, zero errors! :yes:

Uploaded to a Google Test Feed. Uploads fine, but I get a warning that the Weight descriptors are not included.

The only thing, now I have a Second Description field that I did not want, but installed it so I could get this to work.

All in all, it's a good day!

It sounds like you're not following the instructions to the letter :) Did you install version 1.10.1 or which version did you install?

Also, the option folder is what gives you the added feature so you will need to install the ones that you will need to support exporting to Google. It sounds like you've figured that part out.

Also, as an FYI, the specific forum for this mod is more current on numinix website than this particular forum. The updates are often more current on there as well.

BlessIsaacola:

It sounds like you're not following the instructions to the letter :) Did you install version 1.10.1 or which version did you install?

Also, the option folder is what gives you the added feature so you will need to install the ones that you will need to support exporting to Google. It sounds like you've figured that part out.

Also, as an FYI, the specific forum for this mod is more current on numinix website than this particular forum. The updates are often more current on there as well.

1.9.1 Feeder (this is the latest available in the Add Ons section of the Zen Cart website, dated May 23, 2011). Since that is the latest displaying, I would not have thought there was a later/more current version.

1.2.0 Product Fields.

willieWontGo:

1.9.1 Feeder (this is the latest available in the Add Ons section of the Zen Cart website, dated May 23, 2011). Since that is the latest displaying, I would not have thought there was a later/more current version.

1.2.0 Product Fields.

That's exactly what I am trying to say that the information here is outdated because the mod developer have his own site that he keeps current: http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder and there's also a forum where the developer answer issues regarding this mod.

BlessIsaacola:

That's exactly what I am trying to say that the information here is outdated because the mod developer have his own site that he keeps current: http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder and there's also a forum where the developer answer issues regarding this mod.

Yeah, it's too late now, already installed it. :(

Do you know if I can easily update to the latest version Google Feeder (1.10.1), or do I have to uninstall and then start again?

Has anyone run into a message that says skipped due to user restrictions? Upgraded to the new 1.9.1 mod on one site and was having no problems there before. Have installed on several sites without problems except this one.

BlessIsaacola:

That's exactly what I am trying to say that the information here is outdated because the mod developer have his own site that he keeps current: http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder and there's also a forum where the developer answer issues regarding this mod.

He doesn't answer questions there either. We're all working kinda blindly here.

I have been playing with the froogle feed for a while and have had little success.

I have searched the thread and the forums for my answer, but have not found anything conclusive.

I am running 1.3.9h and I do NOT have Query Cache installed.

I have a store with about 80,000 products and I am trying to export but every time I run it, it stops at 2011 products. I have turned on debugging but I cannot find the location of the debug file...

Anyones help/advice on how to proceed would be greatly appreciated!

if you have turned on debugging, when you actually do a manual export in your admin, the popup screen shows the messages.

sigung:

You may be aware that recently Google checkout has come up with a new requirement for their data feeds. The feeds are required to include at least two of three unique product identifiers (see web page):

http://www.google.com/support/merchants/bin/answer.py?answer=160161

In my case, I decided the easiest thing to do to meet these requirements (since my wholesaler does not provide data like UPCs ISBNs, etc.) was to use a combination of a MPN, (which can be made up by the store owner), and a Brand Name.

I HAD been assigning brand names where appropriate, but I had NOT been entering model numbers, hence I was faced with adding a model number to 595 products, a pretty daunting task manually, so I decided to go the sql statement/query route and try to affect the change I needed in all 595 records (tables) at one time.

Originally, I tried to add an autoincrementing field and update that to the products_model field, but I could not find a statement that would update it sequentially, so I wound up with the number "1" in that field. I finally came up with this solution that took all of .033 seconds to accomplish my goal.

Keeping in mind that the products_id field is the auto incrementing one ( only ONE autoincrementing field is allowed in any table), as the shopping cart software assigns a new id to each product created, I decided to simply use the product_id as my new Manufacturers Part Number (MPN) to satisfy the new Google data feed requirements. SO, I ran this simple query:

UPDATE zen_products
SET zen_products.products_model = zen_products.products_id

THAT gave me a products_model field with the same values as the products_id field. Next I wanted to append a text prefix to that number so it would look "more official". To accomplish that, I used:

UPDATE zen_products
SET zen_products.products_model = concat(' MPN-',zen_products.products_id)

I hope you find this information useful.

I believe this is the reason why my feeds are incomplete.. :(

Is there a way to allocate other product fields such as UPC etc. to fulfill these requirements? I have thousands of products that have a model# and UPC, but no description. How could I allocate the product title to the description ONLY for products with no description???

Example HERE

I'm trying to modify the googlefroogle.php code to add this to all product links:

?utm_source=google&utm_medium=base&utm_campaign=products

I want to do this so that Analytics can filter Product Search traffic for me.

I examined the file, but the code was written with just a few vague comments, and the link url seems to be mentioned in several places in the code, so I'm not sure where to start... Maybe that's why the author abandoned the mod? Code without comments is a nightmare to try to figure out all over again.

Nevermind, figured it out. Line 55 added with other url parameters.

What is the difference between version 1.9.1 and the newest version 1.10.1? 1.9.1 is working for me right now. So if it's not broke, do I have to fix it?