Google Base Feeder Support Thread [OLD]

[numinix]

I just installed and run Google Base Feeder. Some of my products did not get written to the XML file.

I compared the data of the ones that worked and ones that did not and found that as soon as I enter a value into PRODUCTS table PRODUCTS_PRICE_SORTER the product gets written to the file and the value from PRODUCTS_PRICE_SORTER goes into <grice>12345.00</grice> tag.

The reason I do not have anything in PRODUCTS_PRICE_SORTER is because i am using product price attributes where product's price is structured as follows:

Product 1: 30
60
90

Product's attribute price is stored on PRODUCTS_ATTRIBUTES table. Is there a way to get the feeder program to recognize the attributes and read the correct table?

The script is getting a little more complicated in 1.6.1 but under the case "products" section, you can add to extract the product attributes from TABLE_PRODUCTS_ATTRIBUTES and then if that exists, replace $price with the attributes price.

However, if you have three products with everything the same but the price, Google will need a unique ID for each one which won't be product id, model, etc... I would set one as the default price and then it's option will be +0.00 and the other options +30 +60 that won't appear in the feed but will still be noticed as most people would never click on the two more expensive items as all other things are equal. Is this making sense?

Samsung 19" LCD MONITOR

OPTIONS:

BLACK -> +0
SILVER -> +30
METALLIC BLUE -> +60

You'd then need to feed the option name as a separate attribute, change the price, and then somehow come up with a unique id that can be derived from the database for each separate product.

[numinix]

Do you use this script: http://www.zen-cart.com/index.php?ma...roducts_id=310

Does it assign a product_id to each attribute? If that were the case we could simply extract the attribute price and either add it to or replace the product price.

[bumba000]

Okay, 1.6.1 worked great for me at stompaudio.com
Im working on another site for a friend and have never had any luck there with the feeder. any version.
I see the config for 1.6.1 in admin config now but nothing under tools.
have uninstalled and reinstalled 3 times now. even tried deleting the files before uploading new ones and overwriting. still no luck.

What is wrong when feeder doesnt show up under the admin-tools?

Thanks,
John

[gothstone]

Do you have admin profiles installed? Have you checked your permissions there?

[bumba000]

Not sure what admin profiles are. Just made a new profile under tools and admin settings tho. Says nothing about restrictions or access to anything tho.

[bumba000]

Not quite sure whats going on here but user tracking isnt showing up either.
.sql executes fine. all files are in place. no config with UT tho.

wonder if im just doing something wrong and im not catching my mistake.

John

[tj1]

A couple of questions:

- Is it necessary to have the feed folder chmodded to 777 ? I currently have it to 755 and it seems to work just fine.

- I just noticed there's v1.61 already, I currently have v1.60. It says there was a bug fix, however I've done a full comparison of both releases using WinMerge and the only different files appear to be the README files. Were there really any bug fixes?

Thanks.

[numinix]

A couple of questions:

- Is it necessary to have the feed folder chmodded to 777 ? I currently have it to 755 and it seems to work just fine.

- I just noticed there's v1.61 already, I currently have v1.60. It says there was a bug fix, however I've done a full comparison of both releases using WinMerge and the only different files appear to be the README files. Were there really any bug fixes?

Thanks.

yes there were a bunch but they aren't very significant and will only appear if you

1) don't have ASA installed (or the UPC/ISBN mods)
2) are using a non-english site as was brought to my attention much earlier on in the thread.

I'll have to take a look and make sure I included the correct file sometime tonight.

[tj1]

Yes, please do check as I really did complete comparison of both releases (1.60 and 1.61) using WinMerge and the only difference is in the README file, not a single difference in any other files.

And about having the feed folder, I guess it's not necessary to have chmodded to 777, correct? I have set to 755 and it works just fine.


Another issue I'm having. The file is being generated and uploads just fine, but Google gives the following error:
============
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: Sep 21, 2007 8:34pm PDT
Processed at: Sep 21, 2007 8:31pm PDT

Errors:
Error Bad data Line #4
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
=============

I'm using v1.61. I opened the file and what I have for line four is the following:
<title>S&A</title>

Do you what could be causing the error? is it the & ampersand?

[numinix]

Yes, please do check as I really did complete comparison of both releases (1.60 and 1.61) using WinMerge and the only difference is in the README file, not a single difference in any other files.

And about having the feed folder, I guess it's not necessary to have chmodded to 777, correct? I have set to 755 and it works just fine.


Another issue I'm having. The file is being generated and uploads just fine, but Google gives the following error:
============
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: Sep 21, 2007 8:34pm PDT
Processed at: Sep 21, 2007 8:31pm PDT

Errors:
Error Bad data Line #4
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
=============

I'm using v1.61. I opened the file and what I have for line four is the following:
<title>S&A</title>

Do you what could be causing the error? is it the & ampersand?

That is the only special character in the title. That is a bug and will be dealt with. Your other items should process though...

I just check the googlefroogle.php file in the root of the .zip and it contains the bug fixes not present in 1.6.0. At the very least you would have found a discrepancy in the version numbers.

To fix the bug, try adding this to ln 503 at the end of the zen_xml_sanitizer function:

        $str = htmlspecialchars($str); 

That should convert all special characters to their html entities.

Please post back if that solves your issue! I will then release a patch for the Windows Live Product Search Feeder and the Google Base Feeder which both are in XML.