Google Base Feeder Support Thread [OLD]

[numinix]

Hi

I am using version 1.4.8 which SQL update should i use, i see their 3 different ones

Thank you

Use the SQL updates for the versions in between. So in this case 1.4.9b and the latest update located in the root directory.

How do I call on the weights of each products to be added to the txt file

You'll have to edit the product_query to include p.products_weight. Didn't you ask this question previously? I gave you a more detailed response previously. There is no advantage to adding this attribute to your Google Base feed.

[numinix]

btw, I made a minor change to the download file for 1.5.0 without releasing a patch.

To manually make the change to your file if you downloaded previous to this post, do the following:

in root/googlefroogle.php

replace line 140:

$content["guid"] = '<guid isPermaLink=false>' . $products->fields['products_id'] . '</guid>'; 

with:

$content["guid"] = '<guid isPermaLink="false">' . $products->fields['products_id'] . '</guid>'; 

[BlessIsaacola]

BlessIsaacola,

In the meantime, try changing the function that is used to filter the description. Scroll down to the area of the code that outputs the description stored in the SQL and replace zen_froogle_cleaner() with zen_froogle_sanita().

Let me know if that helps. I've decided that the next version will be in XML format to avoid problems with illegal characters in the description.

Numinix, do I have to uninstall upc/isbn mod in other to revert back to version 1.3.3 of this mod by Andrew? His version is the only one that works for me and generates all products. With your suggest update above I was able to generate more products with error but there are still more than 2,000 plus products with errors which is not good. The thing that baffles me is when using Andrew's version none of these errors are generated.

Thanks!

[onetrade]

I just installed google froogle. I had no idea what I was doing but it seems to work. The froogle.txt file generates successfully and when i open it using my ftp program the froogle.txt file is text written. but when i go to the directory using my browser it is blank.. http://www.pricepiggie.com/zencart/feed/froogle.txt Now here is my question: I uploaded the froogle.txt fiile manually into google base bulk and NOTHING. still no items listed at all and says processing but it seems dead! i did the upload to google base last night around midnight. any suggestions? I do not utilize the UPC and ISBN boxes within the products, but the boxes to input that information is there.
Any suggestions? Thanks in advance.

[onetrade]

I just received a message back finally from google base: Bulk upload failed. No items are live. There are too many formatting errors in your file.

Error: We didn't understand the header (first) row of your file. Please make sure that there is one attribute name for each column, and that you are using valid attribute names.

Bad Data
<?xml version="1.0" encoding="UTF-8" ?>

Line #1

[numinix]

Numinix, do I have to uninstall upc/isbn mod in other to revert back to version 1.3.3 of this mod by Andrew? His version is the only one that works for me and generates all products. With your suggest update above I was able to generate more products with error but there are still more than 2,000 plus products with errors which is not good. The thing that baffles me is when using Andrew's version none of these errors are generated.

Thanks!

The errors should be fixed in version 1.5.0.

[numinix]

I just received a message back finally from google base: Bulk upload failed. No items are live. There are too many formatting errors in your file.

Error: We didn't understand the header (first) row of your file. Please make sure that there is one attribute name for each column, and that you are using valid attribute names.

Bad Data
<?xml version="1.0" encoding="UTF-8" ?>

Line #1

The file needs to be named .xml not .txt

[numinix]

NOTE:

The GBF is replacing unidentified characters with \x## with ## representing all digits 00-99. I'll try to have this fixed later this evening. Any product that has a description that contains one of these character identities will not be processed by Google Base. All other products should still validate without a problem.

[motti]

Hi DAVID

I upgrade to 1.5.0 and I add the extra fix u post on Thread # 242, Installation was smooth, no errors and it all look good

When doing Step 2. my item look bit wrong Recess-It Square 14 x 14 Approx pre-finished dimension face = 13 1/4quot; x 13 1/4quot;, back = 12 3/4quot; x 12

It doesn’t use this symbol (“) this is in my description , not in title

I did not attempt to publish it yet, but I do need to , as I added more product

Thank you

[numinix]

NOTE:

The GBF is replacing unidentified characters with \x## with ## representing all digits 00-99. I'll try to have this fixed later this evening. Any product that has a description that contains one of these character identities will not be processed by Google Base. All other products should still validate without a problem.

This issue has been resolved.

Replace line 130 with:

$content["title"] = '<title>' . zen_froogle_cleaner($products->fields['products_name']) . '</title>'; 

Motti, not sure if you are talking to me or not, but I do not understand your question. All descriptions have to be in plain text and I wouldn't worry too much about how they are displayed since Google truncates them to only a couple of sentences depending on what the user searched for.