Google Base feeds

♥stubbsy · April 14, 2010

Hi there,

Love the contribution, had this working for quite some time until I installed the latest update of SEO urls (or what was the latest FWR's update earlier this year http://addons.oscommerce.com/info/2823) and i didn't realise for quite a while but it has broken this contribution, the output file is just blank.

Here is the output of my file now

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type></HEAD>
<BODY></BODY></HTML>

Has anyone else had the same problem and maybe come across a solution?

Thanks

Dave

♥geoffreywalton · April 14, 2010

I'm using ultimate seo urls and header tags

define('SEO_ENABLED','true'); if I set it to true googlebase.php gives this error:
Fatal error: Call to undefined function tep_not_null() in /home/n8tdbsl6/public_html/includes/classes/seo.class.php on line 1106
When i set it to false i get for every product I get something like this:

I've manually updated it to google base and received an email:

any idea how to have it fixed?

I would say you have commas in your descriptions and google is thinking those are the field separators.

Check what you have set in google_base.php and change the settings in google from auto detect to what you are actually using.

As for the seo, see my previous posts. I suspect someone has made changes to reflect their requirements and uploaded that in one of their updates, but I could be wrong (and often am)

G

abcooke · April 16, 2010

hi just installed the update and set the configuration correctly. but when i try to view the TXT file i get:

"

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@countybatteryservices.co.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

"

http://www.countybatteryservices.co.uk/froogle.txt

Any body got any ideas why it is crashing the server?

♥geoffreywalton · April 19, 2010

What does it say in the server log?

G

abcooke · April 20, 2010

What does it say in the server log?

G

countybatteryservices.co.uk: [19/Apr/2010:15:49:06 +0100] 86.11.201.214 - - "GET /froogle.txt HTTP/1.1" 500 557 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.1.249.1045 Safari/532.5"

♥geoffreywalton · April 20, 2010

Do you redirect /froogle.txt to google_base.php?

abcooke · April 21, 2010

Do you redirect /froogle.txt to google_base.php?

Yes /froogle.txt is written by .htaccess:

RewriteBase /

RewriteRule froogle.txt googlebase.php

alymirza · June 6, 2010

hello...i installed this contribution..

set up google base...then schedule for data feed...

now the thing is that till now there has been no change in status, its still "none" so i want to know that how can we see that installation went well..

kotaro · June 16, 2010

Thank you for the contribution, it's great!

I do have a small problem.

The feed works great with USD but doesn't work with GBP currency.

How can I fix it?

Thank you

-=LRK=- · June 22, 2010

I was really excited when I saw a simple, one file install. Oh well, nothing is easy.

I am getting the error:

Fatal error: Call to undefined function tep_href_link() in ..\googlebase.php on line 343

Which is refering to line:

$output .= tep_href_link($productURL,$productParam . $row->id) . $Separator;

bowen · July 6, 2010

Hi,

Thanks for the contrib, but i am having a few little issues...

I have installed as instructed and have added the rewrite to the htaccess file bit i get file cannot be found when i try to access it directly?

this is what my error log says:

petsandpals.co.uk [Tue Jul 06 14:26:13 2010] [error] [client ***.***.***.***] File does not exist: /home/sites/petsandpals.co.uk/public_html/base.txt

I have this at the end of my htaccess file:

#############################
# Begin Google Base File Rewrite Code

RewriteRule base.txt googlebase.php

# End Google Base File Rewrite Code

#############################

and the googlebase.php is in my root directory. i have setup the googlebase feed a few days ago with google and its still says status none and last upload none??

please help and so i can get my products listed.

Many thanks - Mark

July 7, 2010

i am also having problem like bowen who posted his question yesterday - my haccess file is in the root directory and i have the following:

RewriteBase /

#############################

# Begin Google Base File Rewrite Code

RewriteRule gamaitFeed.txt googlebase.php

# End Google Base File Rewrite Code

#############################

so as you see i addedd the line RewriteBase / because it wasnt there initially.

when i go to www.gamait.co.uk/gamaitFeed i get that the page can not be found

how can i access the text file so if i want to do manual uplaod i can do it?

please tell me what could go worong?

bowen · July 7, 2010

As i couldnt get this working despite my efforts i have now resorted to 'the feed machine solution v5.3'

its a little more involved in setup that this single file install, but at least it works and my products are not listed in google products. you can also config for other feeds as well.

July 7, 2010

As i couldnt get this working despite my efforts i have now resorted to 'the feed machine solution v5.3'

its a little more involved in setup that this single file install, but at least it works and my products are not listed in google products. you can also config for other feeds as well.

do you mean that your products are listed in google products or NOT listed - if it is not listed then why do i bother to do the addon of 'the feed machine solution v5.3'

kotaro · July 7, 2010

i am also having problem like bowen who posted his question yesterday - my haccess file is in the root directory and i have the following:

RewriteBase /

#############################

# Begin Google Base File Rewrite Code

RewriteRule gamaitFeed.txt googlebase.php

# End Google Base File Rewrite Code

#############################

so as you see i addedd the line RewriteBase / because it wasnt there initially.

when i go to www.gamait.co.uk/gamaitFeed i get that the page can not be found

how can i access the text file so if i want to do manual uplaod i can do it?

please tell me what could go worong?

Instead of going to http://www.gamait.co.uk/gamaitFeed

go to http://www.gamait.co.uk/gamaitFeed.txt

bowen · July 7, 2010

do you mean that your products are listed in google products or NOT listed - if it is not listed then why do i bother to do the addon of 'the feed machine solution v5.3'

Sorry...hit the wrong key and didnt check it..trying to type too quick :huh:

Should be my products are NOW listed in google products instead of not ;)

sorry for the confusion.

July 7, 2010

Instead of going to http://www.gamait.co.uk/gamaitFeed

go to http://www.gamait.co.uk/gamaitFeed.txt

yes thanks i got the link , but please one question is can i do manual upload because i can not find the gamaitFeed.txt file in my root directory - where can i find the gamaitFeed.txt file?

also in this addon it seem that no mention of the FTP login details for google marchent center ftp upload for the data feed

July 7, 2010

Sorry...hit the wrong key and didnt check it..trying to type too quick :huh:

Should be my products are NOW listed in google products instead of not ;)

sorry for the confusion.

thanks for your replay BUT i have a problem in google base it tell me that my products are entred

but in google merchent center it tell me that my feed is disapproved - I cant understand why - please help me with this issue

kotaro · July 7, 2010

yes thanks i got the link , but please one question is can i do manual upload because i can not find the gamaitFeed.txt file in my root directory - where can i find the gamaitFeed.txt file?

also in this addon it seem that no mention of the FTP login details for google marchent center ftp upload for the data feed

I do not think you will find that file in your root directory because it is built when you go to that page by your googlebase.php file.

If you want to upload the file manually, go to that URL in Firefox, copy the whole text, paste it into TextPad or notepad or whatever, and save it. Then go to your Google Merchant Center, click Data Feeds on the left and click manual upload and find that file you just saved.

Good luck

Retro King · September 18, 2010

Ive tried a manual update to see if the feed is correct but this is what im getting

Feed status summary for gbase_feed.txt

No items inserted - Processed on 18-Sep-2010 20:44 BST

Detected encoding: UTF-16LE

Detected delimiter: Pipe (|)

Detected file format: Text

Feed-Level Messages

Error: Missing header row - Error

Please make sure that the first line of your feed includes our predefined attributes

I am lifting the code from the googlebase.php file once I have pointed my browser to it, the data settings are pipe in both googlebase and in the php file, Ive also tried both quoted fields as Yes and No

heres a sample of the first few lines:

♥mdtaylorlrim · September 19, 2010

heres a sample of the first few lines:

link|title|description|expiration_date|price|image_link|genre|id|weight|manufacturer|mpn|payment_accepted|product_type|currency|location|tax|quantity|brand|condition|age_range|made_in

I only see the header line. Is there a <CR> at the end of the line and the first item starts on the next line?

♥geoffreywalton · September 19, 2010

Funnily enough I just set one of these up today as a tab delimited file and it worked fine.

Here are the headers and first line if you want to check the mandatory fields are there.

link title description expiration_date price image_link genre id weight manufacturer mpn payment_accepted product_type currency location tax quantity brand condition age_range made_in 
http://www.xxxx.com/100d-remote-control-searchlight-p-1.html ACR RCL-100D 12V Remote Control Searchlight Product No. 1930.3 (12V)/ 1931.3 (24V) Remote Controlled Searchlight 200,000 candela Internal, elevation mechanism, provides pitch control of spotlight beam; protects elevation mechanism from weather Includes a fingertip remote control Point Pad; up to three remote Point Pad units may be installed on system; surface/flush mount options included Rugged triple-primed and sealed, marine grade aluminum housing Wiring harness 15 ft (4.57 m) length Salt water-resistant construction with nylon and phenolic washers, aluminized stainless steel screws with insulating lubricant Application: Sport yachts, mega-yachts, sport fish and commercial vessels Size: 8.0 x 9.0 x 8.0 in (20.3 x 22.9 x 20.3 cm) Weight: 7.2 lbs (3.2 kg) Material: Rugged triple-primed and sealed, marine grade aluminum housing Color: White Operation: Remote controlled Accessories: Universal Remote Control Point Pad for remote control with install kit - P/N 9283.3 55W/12V Halogen lamp - P/N 6001 55W/24V Halogen lamp - P/N 6003 12V searchlight only - P/N 1925 24V searchlight only - P/N 1926 Beam Angle: 5° vertical, 7° horizontal Elevation Angle: 9° up, 17° down Rotation: 360° Rotation Speed: Fast 28° per second, Slow 18° per second Elevation Speed: 2°-7° per second - (12VDC) 5°-8° per second - (24VDC) Lamp: High intensity 55W Halogen Limited Warranty: 1 year Carton Dimensions: 13.0 x 21.0 x 10.0 in (33.0 x 53.0 x 25.4 cm) Units per Carton: 1 Carton Weight: 14.0 lbs (6.3 kg) 2010-10-19 908.84 http://www.xxxxx.com/images/10001.gif Electrical , Spot & Flood Lights 1 14.00 Gms. ACR Electronics ACR Paypal,Visa,MasterCard,WireTransfer Spot & Flood Lights USD yyyyyyy,zz zzzzzz,USA ::0:n 1 ACR Electronics New 20-90 USA

HTH

G

♥mdtaylorlrim · September 19, 2010

All of mine so far have been tab delimited as well. Funny thing, about a month an a half ago one feed quite working after 9 months or so of working just fine. Never did fix it. Had to delete it and start over with a different name.

Retro King · October 17, 2010

Cheers for the replies, sorry for the slow response, wife was havin a baby few days after I posted the above, only gettin back to it now! Will post up the rest of my feed tomorrow, tried a couple of tweaks but still no joy

Retro King · October 25, 2010

Heres the first line along with the product, thats taking it directly off the googlebase.php file

link|title|description|expiration_date|price|image_link|genre|id|weight|manufacturer|mpn|payment_accepted|product_type|currency|location|tax|quantity|brand|condition|age_range|made_in http://modelshopbelfast.co.uk/product_info.php?products_id=2439|Silverfox IR Steam Generating Van Kit only|Silverfox Steam Generating Van Kit only. The image shown represents the finished kit|2010-11-24|43.50|http://modelshopbelfast.co.uk/images/ie_gsv_later.jpg|Railways, Irish and Local|2439|0.00 Gms.|Silverfox||Paypal,Visa,MasterCard,WireTransfer|Irish and Local|GBP|modelshopbelfast.com, 38 Queen Street Belfast, Northern Ireland, BT1 6EF|::0:n|1|Silverfox|New|5-90|UK

looking at the source code I get this:

http://modelshopbelfast.co.uk/product_info.php?products_id=2439|Silverfox IR Steam Generating Van Kit only|Silverfox Steam Generating Van Kit only. The image shown represents the finished kit|2010-11-24|43.50|http://modelshopbelfast.co.uk/images/ie_gsv_later.jpg|Railways, Irish and Local|2439|0.00 Gms.|Silverfox||Paypal,Visa,MasterCard,WireTransfer|Irish and Local|GBP|modelshopbelfast.com, 38 Queen Street Belfast, Northern Ireland, BT1 6EF|::0:n|1|Silverfox|New|5-90|UK

It is breaking it down into seperate lines ok but there are only 2352 lines in the source code (meaning its only picking up 2522 products) when ive well over 10,000 products

any ideas?

Google Base feeds

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

geoffreywalton

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation