ok...did what you said......and then installed 1.5.3 patch again

where b4 I had two Google Base Feeder Configuration in admin>configuration, now I have none. No configuration at all for Google Base Feeder Configuration.

I ran the script anyway to see what would happen and this is what I got:

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/09/20 00:24:30
Feed file - /home2/shabecom/public_html/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.products_id DESC' at line 11
in:
[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, 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 FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id DESC]

TIA for all your help...............:smile:

update:

while waiting for more answers I re-uploaded all the files for the 1.5.3 version.

Maybe I missed a file the first go round because it works now. I have the right config file now.

I apologize if this is what was causing the problem, but since we did several "fixes" I don't know which one worked.

HOWEVER..........as beautiful as it is and as impressed as I am, there are no images showing when I view before uploading. Am I supposed to be seeing images on the "view before upload" page?

If so, I don't.

What can I do to fix this?

again, TIA, u r a very patient and helpful person!

The XML will not show the images in your browser. You'll need to view it with an XML editor to see the attributes. You would need to write an XSL or CSS file for the XML feed which you can't do or your feed will not validate with Google Base.

I plan to eventually write an RSS generator...

Thanks again so much. I just did a "page source" view and could see that the image link is indeed there.

I went ahead and uploaded to google and everything uploaded. But I didn't set the expiration date correctly in the config, I guess because it shows as expiring today.

So I created a new upload, with a different file name after setting in the config to 31 days. Made a new file and uploaded that. Is that what I should have done?

Am waiting to see if the new file will show the correct expiration date.

I'm almost there and this is such a good mod. It's refreshing to have an author that continues to assist newbs like me.

many thanks!

tolefairy:

Thanks again so much. I just did a "page source" view and could see that the image link is indeed there.

I went ahead and uploaded to google and everything uploaded. But I didn't set the expiration date correctly in the config, I guess because it shows as expiring today.

So I created a new upload, with a different file name after setting in the config to 31 days. Made a new file and uploaded that. Is that what I should have done?

Am waiting to see if the new file will show the correct expiration date.

I'm almost there and this is such a good mod. It's refreshing to have an author that continues to assist newbs like me.

many thanks!

The script is set to expire the feed after 365 days, so it would be the same day/month, but 2008 as someone else in this feed also mistakenly missed. Anyways, the expiry is not important because you should be uploading your new feed EVERY time there is a change in your products. Google Base will actually reject feeds if there are discrepancies between your site and the feed details. Setting a cron job to run at the same pace as your changes, daily, weekly, etc. will avoid this.

Hi,
I have just updated to 1.5.3.
Says my feed.txt was created but there is nothing in the feed/ dir.
also when I choose to upload it says login is incorrect. Login is right tho.

to update I replaced all .php files and ran the 1.5.3 update patch.
all seems to be successful other than it doesnt work.

any ideas?

         Thank you,
                           John

Please upgrade to 1.6.1, available on my website.

Your username and password for your FTP are different than for you Google account. This is one of the most common questions asked and it is stated right in the readme.txt file. I'll upload 1.5.3a (less bugs than 1.5.3) to the downloads section today, but I am now hosting all of my updates on my site only and therefore is the only place to get 1.6.1.

Numinix, sorry to re-post, but didn't get an answer to the below from my post back a page here: #402. Just wondering what could be a corrective measure.

tcustomgolf:

Hmm...just installed 1.61 (an upgrade from 1.53) and all seems to work but get this repeating stuff in the admin? Just copied the zip files up to my host, no SQL changes...

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 <g:price>12345.00</g:price> 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?

tcustomgolf:

Hmm...just installed 1.61 (an upgrade from 1.53) and all seems to work but get this repeating stuff in the admin? Just copied the zip files up to my host, no SQL changes...

Each line is the new product type, I'll make it look nicer but if you read carefuly you'll notice the differences...

ericny:

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 <g:price>12345.00</g:price> 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.

Do you use this script: http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_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.

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

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

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.

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

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.

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.

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.

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:

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

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?

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.