Google Base Feeder Support Thread [OLD]

[Boatersplanet]

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!

[delia]

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

[Boatersplanet]

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/mercha...?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

[fakeDecoy]

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.

[fakeDecoy]

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

[pagypsy]

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?

[delia]

There were a couple of minor bugs in the 1.9.1. I'll install the newest one and see.

[delia]

Installed on the site where I have problems and the problems aren't solved. I hesitate to install this anywhere else where I have a working solution. I would stick with 1.9.1 until he gets all the bugs worked out.

This is mod is undergoing major changes due to Google's changes and Jeff doesn't get paid for any of his work so it's hard to criticize the guy.

Since Google has moved their compliance date to September we do have some breathing room.

[willieWontGo]

Installed on the site where I have problems and the problems aren't solved. I hesitate to install this anywhere else where I have a working solution. I would stick with 1.9.1 until he gets all the bugs worked out.

This is mod is undergoing major changes due to Google's changes and Jeff doesn't get paid for any of his work so it's hard to criticize the guy.

Since Google has moved their compliance date to September we do have some breathing room.

Exactly. Hope Jeff doesn't take it the wrong way, we appreciate what he's doing (and all of the other developers who contribute freely).

[delia]

Okay, then, here's the skinny on 1.10.1

There were 2 sql files for 1.9.2 and then the one for 1.10.1 -

That does not upgrade your installation but creates a totally new set of config paramenters.

It changes the feed name - adding on the language abbreviation - domain_products_en.xml

You have to make that choice in the configuration setting or else the file name will be domain_products_.xml.

No matter what you will have to go change your feed file name at google.

I was not able to get the cron job to run just as mentioned before in this thread. I also commented out line 54:

if ($key != GOOGLE_PRODUCTS_KEY) exit('<p>Incorrect key supplied!</p>');

in order to get the file to run. I kept getting a key error no matter what key I used in the cron job.

It does default to the feed/google folder but you can change that back to the feed folder alone in the configuration.

So upgrade if you have time to make all the changes required. Otherwise you can get probably get by for a while using the 1.9.1 version.