Google Base Feeder Support Thread [OLD]

[mydanilo]

Got to
Google Froogle Configuration -
Expiration Date Adjust -- 30
Expiration Date Base -- now

Upload every 2-3 weeks manually or with a cron job and forget about it.

[kburner]

I have zen-cart 1.3.8. I have google froogle loaded and file go to google. Each time I get an email for errors from google. Looks like not including all products either. I have almost 3,000 and only loading around 989. Here are some of errors. Looks like my attributes are also showing as errors.

Errors:
Error Bad data Line #
We recommend including this attribute. weight

We recommend including this attribute. upc

We recommend including this attribute. isbn

We recommend including this attribute. image link

This expiration date is too far in the future. help expiration date:2010-02-23
11462
There is a problem with the character encoding of this attribute. help description:All the elegance of the Reina Valera revisión 1960 combined with the poetic beauty of the King James.

Features:
Words of Christ in red
Presentation page
Harmony of the life of Christ
1792 pages
Binding:
  Imitation Leather


Indexed:
  N


I have been looking thru this large thread. I have not been able to find answer. Please let me know if located elsewhere.

Thanks, Kim

[lankeeyankee]

  Imitation Leather
Indexed:
  N

Those are illegal characters that the googlefroogle.php file has turned into the A type characters. Open your xml file in a text editor and copy the character and then paste it into the editor's search function so you can replace with the correct character.

This is a bug in this contribution's script. I have the same problem and it takes extra steps to find all of the invalid characters.

I have tried to resolve this before, it lies in the sanitizer function in the googlefroogle.php file. Hopefully Numinix will get this resolved. If I fix it I will post the new file here.

[lankeeyankee]

To follow on my last post, the googlefroogle file is stripping all quotes from my products and we have many products with quotes. Not only that, but if there is an

"

in there the the sanitizer will strip the & leaving only quot;.

I have brought this bug up before but haven't received any fix for it. Does anyone know what needs to be changed in the sanitizer function? It's mostly regular expressions and I don't know enough about them yet to make the correct changes. I will spend some time learning what the code is doing so I can change it if no one else knows what the change.

What it needs to do is change the " to

"

and leave the existing

"

untouched.

Anyone???

[kburner]

Those are illegal characters that the googlefroogle.php file has turned into the A type characters. Open your xml file in a text editor and copy the character and then paste it into the editor's search function so you can replace with the correct character.

This is a bug in this contribution's script. I have the same problem and it takes extra steps to find all of the invalid characters.

I have tried to resolve this before, it lies in the sanitizer function in the googlefroogle.php file. Hopefully Numinix will get this resolved. If I fix it I will post the new file here.

Thank you for your response. When I did a search when in admin in the developer's tools. It shows in:

admin/image handler.php
Line #438 : <option value="GBP">£ (GBP)</option>

Line #441 : <option value="JPY">Â¥ (JPY)</option>

includes/classes/support/phpmailer.lang-ja.php
Line #13 : $PHPMAILER_LANG["execute"] = '¼Â¹Ô¤Ç¤##¤Þ¤»¤ó¤Ç¤·¤¿: ';

Line #20 : $PHPMAILER_LANG["connect_host"] = 'SMTP¥¨¥é¡¼: SMTP¥Û¥¹¥È¤ËÀܳ¤Ç¤##¤Þ¤»¤ó¤Ç¤·¤¿¡£';

includes/classes/support/phpmailer.lang-ru.php
Line #19 : $PHPMAILER_LANG["file_access"] = 'Â äîñòóïå ê ñëåäóþùåìó ôàéëó áûëî îòêàçàíî: ';


Or are you referring to the google file - /feed/froogle_documents.xml?
What about the other questions like upc and ibsn? Those are model number. How do I add them to file?

Thanks, Kim

[juno]

This is a really great contribution. I don't think I've seen anything yet with Numinix on it that hasn't been helpful.

Of course, I wouldn't be posting if I wasn't having a problem. Would there be a reason for product_type not to be displayed? I've tried changing it from "Full" to "Top" and even "Bottom" but nothing shows in the feed:

<item>
<title><![CDATA[Dr. Maggie's Classroom Phonics Kit]]></title>
<g:brand><![CDATA[Cheapcher.com]]></g:brand>
<g:condition>new</g:condition>
<g:expiration_date>2010-03-29</g:expiration_date>
<g:id>10795</g:id>
<g:image_link>http://www.cheapcher.com/images/large/productimages/CTP/CTP-2926_LRG.jpg</g:image_link>
<link>http://www.cheapcher.com/language-arts-phonics-c-481_1526/dr-maggie-s-classroom-phonics-kit-p-10795/currency/USD</link>
<g:price>339.41</g:price>
<g:mpn>CTP-2926</g:mpn>
<g:currency>USD</g:currency>
<description><![CDATA[Designed for small group instruction, this kit includes six each of the 24 phonics readers (144 books in all), a resource guide, and 24 chant charts (17&quot; x 22&quot;) with word cards on the back.  These charts feature fun rhymes and chants that introduce each story's key vocabulary and are perfect for giving students a head start into each phonics reader.  Includes a durable storage box. Grades K-3]]></description>
</item>

[fakeDecoy]

I just installed the latest version of this on 1.3.8a. The admin->configuration->google base configuration menu is there, and I set all the options, but the admin->tools->google base feeder menu doesn't exist. The closest there is is admin->tools->google froogle feeder, which I think was a previous version of this tool from way back in the day when they called it Froogle. This is copied text from that page. I assume this isn't it?

I ran the uninstaller for the old version, but it didn't totally get rid of it. Does it have one of the same records in the database that the installer of the new version isn't overwriting? What should I do?

Froogle Data Feeder

OVERVIEW:

This module automatically generates product feed for your Zen-Cart store and upload it to Merchant Center ftp.

INSTRUCTIONS:

STEP 1: Click [HERE] to create / update your product feed.

NOTE: You may view your product feed file before proceeding to step 2.

STEP 2: Click [HERE] to upload product feed to Google Froogle Merchants.

NOTE: You may view Froogle Merchants FTP content.

Tips: To have this update and automatically upload product feed to Google Froogle Merchants, you will need to set up a Cron job via your host's control panel.
To run it as a cron job (at 5:0am like you wanted), put something in your crontab like the following:

0 5 * * * GET http://www.adamantbarbell.com/google...yes&upload=yes
or
0 5 * * * wget http://www.adamantbarbell.com/google...yes&upload=yes

[TechnologyDirect]

Hello all, I have an interesting issue. I've installed Zen Cart version 1.3.8a. I've added several templates, and using apple_zen one. I've installed a few add-on mods (Ceon_uri_mapping_seo_3-0-2, easy_populate_csv_1-2-5-5, ebay_exporter_1-02a, editor_tinymce_plugin_2-1, google_analytics_by_andrew, google_base_feeder, google_sitemap-1-3-19, image_handler_for vx_2, google_checkout_module, msrp_display_1-1, Products_profitmargin_calculations, column_divider_pro_cdp_v0-4, tabbed_products_pro_v1-05). I've had all of these working except the last one I was doing which is google_base_feeder. I have installed it, when I go to tools-google-base-feeder I get the menu to create the files. When I click the "Here" button to create the file It opens a new window, but in the window is my store. Now when I go to google sitemap, it does the same thing, it opens a window with my store in it. I've re-installed the mod several times. I've even setup a new store with only 1 test product and several of these mods, but it works. Now on the new store I've not put Tabbed Products pro on it yet, but has anybody else had this issue? Any ideas why my store would be opening instead? Any help would be appreciated.

[mydanilo]

Hello all, I have an interesting issue. I've installed Zen Cart version 1.3.8a. I've added several templates, and using apple_zen one. I've installed a few add-on mods (Ceon_uri_mapping_seo_3-0-2, easy_populate_csv_1-2-5-5, ebay_exporter_1-02a, editor_tinymce_plugin_2-1, google_analytics_by_andrew, google_base_feeder, google_sitemap-1-3-19, image_handler_for vx_2, google_checkout_module, msrp_display_1-1, Products_profitmargin_calculations, column_divider_pro_cdp_v0-4, tabbed_products_pro_v1-05). I've had all of these working except the last one I was doing which is google_base_feeder. I have installed it, when I go to tools-google-base-feeder I get the menu to create the files. When I click the "Here" button to create the file It opens a new window, but in the window is my store. Now when I go to google sitemap, it does the same thing, it opens a window with my store in it. I've re-installed the mod several times. I've even setup a new store with only 1 test product and several of these mods, but it works. Now on the new store I've not put Tabbed Products pro on it yet, but has anybody else had this issue? Any ideas why my store would be opening instead? Any help would be appreciated.

You mentioned that you installed several templates, but did you install all these mods into the current one your using? I am talking about the template override folders. apple_zen if you use it. If your other mods are not installed in this apple_zen override folder structure, they will not work. Maybe this is your issue?

[TechnologyDirect]

Yes, I put them all in the apple zen folder. I have just put the Tabbed Products Pro in my test account and it still works. The browser window that opens even has the filename right and the right folder, just no file gets created, just the store showing in the new window.