I changed the file to .xml how long does it take usually to take effect? it says about an hour, been around 4..
Printable View
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
Includes all bug fixes since the previous release.
- bug fixes;
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.
I tried doing this but this is the error I got.Quote:
Originally Posted by numinix
I edited the file file googlefroogle.php in the main folder. pleasse help me get this fixed.Quote:
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 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:
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 ofPHP Code:$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
andPHP Code:$output["weight"] = "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:PHP Code:$output["weight"] = products->fields['products_weight'];
I would put this under line 146.PHP Code:$content["weight"] = '<g:weight>' . $products->fields['products_weight'] . '</g:weight>';
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!!!
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.Quote:
Originally Posted by onetrade
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