Google Base Feeder Support Thread [OLD]

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

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.

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.

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). :hug:

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.

One more thing about this version. He did change the documentation and the javascript doesn't seem to be working in Firefox so you can't see the full page text.

I just installed this newest version on one of my sites that had the older version on it. I had been fighting getting the products to exports - hundreds weren't. Now all but 2 are and google accepted all but 2 online. I have no clue what the difference is but the last version wouldn't accept & and wouldn't export any product with that. Many of these products are coffee creamers and had half & half in them. So they are all exporting now.

Boatersplanet:

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

Yes, you can use this sql statement:

UPDATE zen_products_description
SET zen_products_description.products_description = concat(zen_products_description.products_name,' ',zen_products_description.products_description)

Unfortunately, this will also add the product title and a space before the product description of products that *already *have a description. I couldn't figure out an sql statement that would ONLY add the product title to products with an empty description leaving all other descriptions intact, so I figured this would be a decent compromise. It will add the product title (and an invisible space at the end) to product descriptions that are empty, and will add the product title and a space before any existing product descriptions. The space is purely for cosmetic reasons, otherwise, it would run the two together in fields that already have a description.

MAKE SURE YOU BACK UP YOUR SQL DATABASE AND DOWNLOAD IT BEFORE YOU RUN THIS STATEMENT!

sigung:

Yes, you can use this sql statement:

UPDATE zen_products_description
SET zen_products_description.products_description = concat(zen_products_description.products_name,' ',zen_products_description.products_description)

Unfortunately, this will also add the product title and a space before the product description of products that *already *have a description. I couldn't figure out an sql statement that would ONLY add the product title to products with an empty description leaving all other descriptions intact, so I figured this would be a decent compromise. It will add the product title (and an invisible space at the end) to product descriptions that are empty, and will add the product title and a space before any existing product descriptions. The space is purely for cosmetic reasons, otherwise, it would run the two together in fields that already have a description.

MAKE SURE YOU BACK UP YOUR SQL DATABASE AND DOWNLOAD IT BEFORE YOU RUN THIS STATEMENT!

Sigung- I appreciate your help. However, i receive this error when trying to run that syntax...

#1146 - Table 'boater6_test.zen_products_description' doesn't exist

do you have a prefix on your tables? If not remove zen_ from the three spots where it exists or replace with your prefix

Boatersplanet:

Sigung- I appreciate your help. However, i receive this error when trying to run that syntax...

#1146 - Table 'boater6_test.zen_products_description' doesn't exist

I can't be sure,  because I have not looked at your sql database,  but I think it's unlikely that you have a table named:

boater6_test.zen_products_description

You will have to substitute your actual table names, so go into your phpmyadmin, look at your database names, and substitute your database names in place of the examples I gave you.

delia:

do you have a prefix on your tables? If not remove zen_ from the three spots where it exists or replace with your prefix

delia told you right. If you are not using a prefix then remove the zen_ from the sql statement.

Newest version just does not work for me. Re installed 1.9.1 and started fixing some product description that the feeder skipped. Not sure what it is in my descriptions that it did not like but all I had to do is edit the product with Fckeditor and re saved. Then it worked. Seems to clean up some stuff when saving again. On other products there were spell errors and after fixing the feed worked on these as well. So debug helped identifying the skipped items and fixing them. I guess no need for upgrading until we hear from Numinix.

mydanilo:

Newest version just does not work for me. Re installed 1.9.1 and started fixing some product description that the feeder skipped. Not sure what it is in my descriptions that it did not like but all I had to do is edit the product with Fckeditor and re saved. Then it worked. Seems to clean up some stuff when saving again. On other products there were spell errors and after fixing the feed worked on these as well. So debug helped identifying the skipped items and fixing them. I guess no need for upgrading until we hear from Numinix.

Yep, getting similar errors in the descriptions; and then have to go back and edit, it's somewhat of a pain.

I initially thought it was because of tables I have set up within the description(s), but that is not the case.

vanian777:

The following tips:
*Google Merchant Center Feeder v1.9.1 started 2011/06/18 05:40:44
Feed file - /home1/ambercra/public_html/oilpainting777/feed/googleabstract_oil_paintings_products_1000_1.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 0.877804 Seconds 18 of 18 Records*

**i have 2000+ productions ,but not the addon just export **18.:oops:

Turn on debug and look at the messages... Any indication what happens to the other products? I assume they are all PRODUCTS?

I just installed 1.9.1. I was previously using 1.7.1a successfully. Last night it created and uploaded a product feed using 1.7.1a, and I haven't done any zc code edits since.

When I create a feed under 1.9.1, it hangs here, output below. I have about 2000 products.

Google Merchant Center Feeder v%s started 2011/06/21 00:43:13
Feed file - /home/mysite/public_html/feed/mysite_products.xml
Processing: Feed - Yes, Upload - No

What could be causing this? A recent post in this thread mentioned "debug", but I don't see any such setting for this mod.

I tried selecting Documents, of which I have zero, as the feed type, and it completed immediately as expected:

Google Merchant Center Feeder v%s started 2011/06/21 00:55:03
Feed file - /home/mysite/public_html/feed/mysite_documents.xml
Processing: Feed - Yes, Upload - No
Google Merchant Center File Complete In 0.014773 Seconds 0 Records

zc 1.3.9hp1

mods installed:
Zen Cart 20 Ways Conversion Pack
MZMT Shipping
Simple Google Analytics
Email address Exporter
EasyPopulate
CH Category
Recover Cart Sales
Request for Quote
CEON URI Mapping
Search Log
Mailbeez
Short Description for Categories
Google Merchant Center

So following up on my last post, I figured out that I needed to run all the SQL patch files in order since 1.7.1. So I did that, putting in the correct configuration_group_id value in each. I turned on debug, but how do I get the debug output? The popup window when I try to create a feed is still hanging at the same point, and the products output file contains only this:

<?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0"> <channel> <title>My Store</title> <link>http://www.mysite.com</link> <description>My store description.</description>

Nevermind my previous posts. I missed a file. Seems to work just fine. Great work on this mod!

I'm totally confused on what mods this particular mod needs to operate correctly.

I have the latest version of Zen and had Numinix install the Google Feed. For some reason I thought this would also install the Product fields as well but even with UPC etc turned on in the configuration, I do not have any place to enter those in the product pages.

After reading the documentation here and on Numinix's site which requires you to register and then NEVER sends you a confirmation email so that you can post to his forum directly I'm beginning to wonder if I need the following other mods to make this one work?

Auction Site Attributes
Product Fields
Magic SEO

Can you point me in the right direction please. I cannot get a response out of Numinix.

You don't need another mod to make it work. He included settings in case you have those mods installed.

Would you be kind enough to tell me which mods I need in order to have UPC's in the product description and export? Any additional instructions/tips etc. would be appreciated.

Thanks!

Hi. I'm having issues with this.

I set it up fine a couple of weeks ago and it was all working well. Then we had some issues with PayPal and put the site into maintenance mode for a couple of days. Google sent me a message saying my site wasn't crawlable, which made sense. But since I've turned the site back on, I can't get Google to approve the feed. I have filled in their form a couple of times, but they just come back saying that googlebot can not access the links. I don't think I have any restrictions on this. Where would I check?

I have been playing with the settings and I did notice that the link wasn't using cPath. I've turned that on and it now appears to be the correct URL within the link tag. The only difference is the ampersand (&) definitions, which I assume Google is sensible enough to convert ?

So for example my feed says:

<link>http://intelligentworkshoptools.co.uk/index.php?main_page=product_info&cPath=36,37&products_id=88&currency=GBP</link>

But the actual URL is http://intelligentworkshoptools.co.uk/index.php?main_page=product_info**&cPath=36,37&products_id=88&**currency=GBP

Something else that is odd.

When I download the domain_products.xml through the admin panel it's a different file than when I download it via FTP. Yet the location is the same? I know this as the file sizes are different and also the content is different. In that it seems to be stripping out the cPath par of the URL in the <link>

V.Confused.