Google Base Feeder Support Thread [OLD]

[onetrade]

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

[numinix]

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

[numinix]

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.

[onetrade]

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?

[numinix]

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

[batteryman]

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

[numinix]

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.

[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!!!

[numinix]

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.

[mbheald]

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