Google Base Feeder Support Thread [OLD]

motti:

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.

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>';

numinix:

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!

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.

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

Line #1

BlessIsaacola:

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.

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

The file needs to be named .xml not .txt

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.

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.

I changed the file to .xml how long does it take usually to take effect? it says about an hour, been around 4..

You should upload it manually the first time once you've registered the file name with Google Base. How long it takes varies.

v1.5.1 GOOGLE BASE FEEDER

1. bug fixes;Includes all bug fixes since the previous release.

Note:

If any of your products are not activated, please post the error message from Google Base. This is usually due to an illegal character found in your descriptions or titles which can be quickly and easily removed by updating the zen_xml_sanitizer function.

yup got an error message this morning: We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error

Bad Line: #14

I have the inch symbol ( " ) which turned into a square in the output file, so i did a find and replace all to a ( " ) and then uploaded the file and still got the error. Should I use your new upgrade to the newer version? i am using 1.5.0?

1.5.1 affects the title output. If this is appearing in your titles, then yes you need to upgrade to 1.5.1.

numinix:

You would need to edit the SQL query to also pull the products_weight and then write a line to output the products_weight under the appropriate heading.

I'm not sure what the breadcrumbs are as I've never used them.

I tried doing this but this is the error I got.

1066 Not unique table/alias: 's'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_weight, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) LEFT JOIN TABLE_PRODUCTS_WEIGHT s ON (s.products_weight = p.products_weight) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

I edited the file file googlefroogle.php in the main folder. pleasse help me get this fixed.

I have added the file as an attachment if some wants to see what I did. I am not a php or mysql programmer so I pieced it together .

thank you

I'm going to help you out and do it for you this one time as you seem very determined. Now you'll have a better understanding of the script as well!

replace line 85 with:

$products_query = "SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight

You'll notice all I did was add the products_weight, found in TABLE PRODUCTS denoted with the (p.). Now you just need to create the outputs of

$output["weight"] = "weight";

and

$output["weight"] = products->fields['products_weight'];

They will need to be placed in the same order on both the titles and the column outputs. I recommend you add this to v1.5.1 instead and have it output the weight in XML format by just copying any of the other lines and using the appropriate google base attribute name such as <g:weight> (not sure if that is correct, you'll have to check in base.google.com). If so, all you'll need to add is this:

 
$content["weight"] = '<g:weight>' . $products->fields['products_weight'] . '</g:weight>';

I would put this under line 146.

Side Note:

I am no longer going to support versions previous to the XML version 1.5.0. I have changed to this format for a reason due to future issues with google base. Older versions such as 1.3.3 are very outdated and do not include most of the required attributes unless you have heavily edited this version as woodymon did. In which case, it is no longer version 1.3.3 but some variant that he created himself. The UPC/ISBN is required and will eventually be used by Google to automatically include information about the product by using the stored attributes for that UPC/ISBN.

All illegal characters should now be removed and all of your products should validate and be accepted. Once again, if this is not the case, please post here and I will try to remedy the issue.

1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!

onetrade:

1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!

Yes, good point. Version 1.5.1 works perfectly for myself as well and I believe it should also solve the issues that blessisaacola was facing as well.

Btw, doesn't it create the file google_base.xml automatically? I've now added it for future releases anyways, but I believe it shouldn't be an issue.

numinix,

I just upgraded to version 1.5.1, it seemed to create the xml file correctly exept I am receiving this error from google.

Outcome: Bulk upload failed. No items are live. There are too many formatting errors in your file. - help
Number of items processed: 1
Number of items succeeded: 0
Number of active items: 0
Uploaded at: Aug 7, 2007 5:26am PDT
Processed at: Aug 7, 2007 5:26am PDT

Errors:
Error Bad data Line #52
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help

You can view my file at:
http://hotnbottled.com/feed/froogle.xml

P.S. I had to manually add the file feed/froogle.xml as it is not included with my version of the download.

If you need to take a look at my admin, please PM me and I will get back to you.

Thanks,
Matt