Google Base Feeder Support Thread [OLD]

[tolefairy]

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...............

[tolefairy]

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!

[numinix]

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...

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

[numinix]

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.

[bumba000]

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

[numinix]

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.

[tcustomgolf]

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.

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...

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

[numinix]

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...