Automatically send data feed to Froogle

[anishas]

Hello Calvin K....

I used your new version of the Google base / froogle data feeder.... but it still gives me the same error :'( that I was encountering earlier in my site..... I have myself tried to sort out this error for long now.... and I thought your contribution could be God sent for me....

 

Here is what I see :

 

File completed: ergodirect.txt

Connected to uploads.google.com, for user ergodirect

 

Warning: ftp_put(): php_connect_nonb() failed: No route to host (65) in /home/*sitename*/public_html/admin/googlefeeder.php on line 329

 

Warning: ftp_put(): Entering Passive Mode (72,14,200,3,14,126) in /home/*sitename*/public_html/admin/googlefeeder.php on line 329

uploads.google.com: FTP upload has failed!

 

Script timer: 5.273258 seconds.

 

:( Can you please help me....

 

Any help would be appreciated.

Best Regards,

Anisha

[Guest]

Hello Calvin K....

I used your new version of the Google base / froogle data feeder.... but it still gives me the same error :'( that I was encountering earlier in my site..... I have myself tried to sort out this error for long now.... and I thought your contribution could be God sent for me....

 

Here is what I see :

 

File completed: ergodirect.txt

Connected to uploads.google.com, for user ergodirect

 

Warning: ftp_put(): php_connect_nonb() failed: No route to host (65) in /home/*sitename*/public_html/admin/googlefeeder.php on line 329

 

Warning: ftp_put(): Entering Passive Mode (72,14,200,3,14,126) in /home/*sitename*/public_html/admin/googlefeeder.php on line 329

uploads.google.com: FTP upload has failed!

 

Script timer: 5.273258 seconds.

 

:( Can you please help me....

 

Any help would be appreciated.

Best Regards,

Anisha

 

I used to have the same problem. Mine was caused by a firewall preventing access to the server.

[Guest]

I am getting the same message since the switch to the new google configuration.

 

The first one is trying to upload the file to Google Base. The second one is without uploading it is much shorter so the issue is with the transfer process.

 

I am on a shared host so I don't have access to the php.ini file to make adjustments for the time out.

 

Any help would be greatly appreciated.

 

Thanks

Matt

 

 

File Upload Turned On

File completed: bbhaversack.txt

 

Connected to uploads.google.com, for user mikuleza0320

 

Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Connection timed out (110) in /home/*username*/public_html/admin/googlefeeder.php on line 329

 

Warning: ftp_put() [function.ftp-put]: Entering Passive Mode (72,14,200,3,31,114) in /home/*username*/public_html/admin/googlefeeder.php on line 329

uploads.google.com: FTP upload has failed!

 

Script timer: 49.627324 seconds.

 

Without File Upload On

 

File completed: bbhaversack.txt

 

Script timer: 0.534386 seconds.

Edited September 6, 2006 by matsinet

[Guest]

I am getting the same message since the switch to the new google configuration.

 

The first one is trying to upload the file to Google Base. The second one is without uploading it is much shorter so the issue is with the transfer process.

 

I am on a shared host so I don't have access to the php.ini file to make adjustments for the time out.

 

Any help would be greatly appreciated.

 

Thanks

Matt

File Upload Turned On

File completed: bbhaversack.txt

 

Connected to uploads.google.com, for user mikuleza0320

 

Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Connection timed out (110) in /home/*username*/public_html/admin/googlefeeder.php on line 329

 

Warning: ftp_put() [function.ftp-put]: Entering Passive Mode (72,14,200,3,31,114) in /home/*username*/public_html/admin/googlefeeder.php on line 329

uploads.google.com: FTP upload has failed!

 

Script timer: 49.627324 seconds.

 

Without File Upload On

 

File completed: bbhaversack.txt

 

Script timer: 0.534386 seconds.

 

iPowerWeb fixed it for me. They normally dont do anything for anything.

Call your host, ask if there is a firewall, tell them to allow outgoing connections on port 21 to you.

[anishas]

Thank you so much for the response.... our site is also hosted on ipowerweb... so maybe the firewall issue applies to me as well..

I will get in touch with them and see if this can be resolved.

Thanks again for the help.

Best Regards,

Anisha.

[ollyno1uk2]

Hi there

 

I am trying to use this contribution. I have filled in all the blanks but when I point my browser to the googlefeeder.php I get the following error

 

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

Please contact the server administrator, [email protected] 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.

 

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

 

Has anyone had this before and managed to sort it?

 

Thanks

[Guest]

Warning: unlink(/home/httpd/vhosts/.com/httpdocs/catalog/admin/feeds/filename.txt): Permission denied in /home/httpd/vhosts/.com/httpdocs/catalog/admin/googlefeeder.php on line 175

 

Warning: fopen(/home/httpd/vhosts/.com/httpdocs/catalog/admin/feeds/filename.txt): failed to open stream: Permission denied in /home/httpd/vhosts/.com/httpdocs/catalog/admin/googlefeeder.php on line 286

 

Warning: fwrite(): supplied argument is not a valid stream resource in /home/httpd/vhosts/.com/httpdocs/catalog/admin/googlefeeder.php on line 287

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/httpd/vhosts/.com/httpdocs/catalog/admin/googlefeeder.php on line 288

File completed: filename.txt

 

Warning: chmod(): Operation not permitted in /home/httpd/vhosts/.com/httpdocs/catalog/admin/googlefeeder.php on line 290

 

Script timer: 0.118185 seconds.

 

I created ~/feeds/ and chmod 777 it, and I also created /catalog/admin/feeds/ and did the same

anyone have a CLUE what im doing wrong here?

[Guest]

ok I fixed all this, I get now,

 

File completed: jon_*.txt

Connected to uploads.google.com, for user _____

Uploaded jon_*.txt to uploads.google.com as jon_*.txt

 

Script timer: 12.339967 seconds.

 

 

So its working, however when I check the google base, I am seeing this.... as an error..

 

Status File name Type Expires Uploaded Processed Items Errors

Failure - help - details jon.txt Products Oct 12, 2006 6:52pm PDT Sep 12, 2006 6:52pm PDT Sep 12, 2006 6:52pm PDT 0 112

 

----

which details say

----

 

2 Shipping field was incorrectly specified - help 7

 

 

where "7" was the shipping I added into the googlefeeds.php file

 

I read the Help issue it says to do

 

$lowestShipping = "US:Ground:7";

instead of

$lowestShipping = "7"; (i had originally)

 

So when I re-execute the .php, it STILL just shows 7, any idea how to fix this????

[Guest]

Just downloaded Google Base / Froogle Data Feeder v1.01.

 

In the manual it reads:

 

1) From the downloaded package:

Edit and Change /admin/froogle.php

 

However, there is no froogle.php file. I assume the file you mean to refer to is googlefeeder.php.

[Guest]

After setting everything up Google Base / Froogle Data Feeder v1.01 (editing googlefeeder.php instead of froogle.php) I kept getting the following error:

 

Fatal error: Call to undefined function: tep_href_link() in /home/mysite/public_html/catalogue/admin/feeders.php on line 10

 

I checked all files and changes I made to them but found nothing. Error was due to something in feeders.php which I didn't change.

 

In the end I downloaded Froogle Data Feeder v1.63 , took the feeders.php from that package and changed the text "Froogle" to "Google" in the file. Uploaded it and it works like a charm.

 

This is a great release and a very important contribution, and FlyingMonkey deserves lots of credit for sharing this with us.

However this new contribution feels very rushed and apperently hasn't been properly tested on a new virgin installation of OSCommerce.

[Guest]

After setting everything up Google Base / Froogle Data Feeder v1.01 (editing googlefeeder.php instead of froogle.php) I kept getting the following error:

 

Fatal error: Call to undefined function: tep_href_link() in /home/mysite/public_html/catalogue/admin/feeders.php on line 10

 

I checked all files and changes I made to them but found nothing. Error was due to something in feeders.php which I didn't change.

 

In the end I downloaded Froogle Data Feeder v1.63 , took the feeders.php from that package and changed the text "Froogle" to "Google" in the file. Uploaded it and it works like a charm.

 

This is a great release and a very important contribution, and FlyingMonkey deserves lots of credit for sharing this with us.

However this new contribution feels very rushed and apperently hasn't been properly tested on a new virgin installation of OSCommerce.

It was trying to call the tep_href_link() function from catalog/includes/functions/general.php

[FlyingMonkey]

Google Base / Froogle Data Feeder v1.02a

Released By: Calvin K

------------------------

 

Date: September 14, 2006

 

Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "instock" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items. The Google Data Feeder is based on my stable Froogle Data Feeder.

 

 

Forum Thread: http://www.oscommerce.com/forums/index.php?sho...088&st=1633 (aka FlyingMonkey on the forums)

 

Author: [email protected]

 

Added: Readme updated, and missing files uploaded / replaced.

 

Thanks everyone for their input, especially tfittsy.

Edited September 14, 2006 by FlyingMonkey

[FlyingMonkey]

Note: The update only applies to the optional interface.

[daz_75]

Hi, just installed this contrib with no problems, one thing i have noticed though is that even if i have the advanced option turned off it still adds the out of stock items to the text file.

Any ideas?

 

Cheers

 

Daz

[daz_75]

Also, is there anyway for it to list the proper URL on google rather than just product_info.php?products_id=1 one?

 

Thanks

 

Daz

[Guest]

Anyone know how I set googlefeeder.php for a UK feed? At the moment froogle defaults to US with out finding a ISO code for the UK in the feed.

 

I could probably edit the txt file each time but Id be really great if I could get it set in googlefeeder.php so I can set the cron job and forget about it.

[Guest]

Sorry, despite google help files directing me to having a UK ISO code in my bulk upload file I think the problem may be solved by registering the file at google base UK, doh! The base help files are a bit misleading.

[daz_75]

Sorry, despite google help files directing me to having a UK ISO code in my bulk upload file I think the problem may be solved by registering the file at google base UK, doh! The base help files are a bit misleading.

 

:lol: I did the same thing

[FlyingMonkey]

Hi, just installed this contrib with no problems, one thing i have noticed though is that even if i have the advanced option turned off it still adds the out of stock items to the text file.

Any ideas?

 

Cheers

 

Daz

 

Also, is there anyway for it to list the proper URL on google rather than just product_info.php?products_id=1 one?

 

good questions.

 

The exclusion of "out of stock" items is based on the product status (not the quantity), since some stores don't monitor their product quantity. If my memory is correct, in stores that do monitor quantity (with backorders off) products are automatically disabled if the quantity reaches zero. The idea behind my logic was that if a user can purchase it from the store, it should be in the feed.

 

To answer your second question, that is the proper URL and is based on the links provided by a base installation of osC. If you are referring to SEO links (added by a contribution or SEF option), the feeder does not currently support these. There are several SEO contributions making it difficult to suport all. I have done it on a custom basis; but just not at the contribution level yet.

[daz_75]

good questions.

 

The exclusion of "out of stock" items is based on the product status (not the quantity), since some stores don't monitor their product quantity. If my memory is correct, in stores that do monitor quantity (with backorders off) products are automatically disabled if the quantity reaches zero. The idea behind my logic was that if a user can purchase it from the store, it should be in the feed.

 

To answer your second question, that is the proper URL and is based on the links provided by a base installation of osC. If you are referring to SEO links (added by a contribution or SEF option), the feeder does not currently support these. There are several SEO contributions making it difficult to suport all. I have done it on a custom basis; but just not at the contribution level yet.

 

Thanks for the reply, im using Ultimate SEO URL's, seems to be the most popular

[OS_Tim]

So if I understand:

 

http://www.oscommerce.com/community/contributions,4513

 

Google Base / Froogle Data Feeder v1.03 DOES NOT work with Ultimate SEO?

 

What about going back to:

 

http://www.oscommerce.com/community/contributions,3876

 

Froogle Data Feeder v1.62d - DOES offer support for Ultimate SEO

 

Will this work??

[daz_75]

So if I understand:

 

http://www.oscommerce.com/community/contributions,4513

 

Google Base / Froogle Data Feeder v1.03 DOES NOT work with Ultimate SEO?

 

What about going back to:

 

http://www.oscommerce.com/community/contributions,3876

 

Froogle Data Feeder v1.62d - DOES offer support for Ultimate SEO

 

Will this work??

 

i dont the think the froogle side of things works anymore it's google base, would be nice to get the incorporated into this release tho

[DavidR]

So if I understand:

 

http://www.oscommerce.com/community/contributions,4513

 

Google Base / Froogle Data Feeder v1.03 DOES NOT work with Ultimate SEO?

 

What about going back to:

 

http://www.oscommerce.com/community/contributions,3876

 

Froogle Data Feeder v1.62d - DOES offer support for Ultimate SEO

 

Will this work??

I had the same thought since I use Ultimate SEO as well. v1.62d seems to work fine for creating the correct SEO URLs but when I submitted the feed to Google Base I received the response:

 

1. Wrong prices (sale prices are not being listed, only regular price)

2. Unsupported attribute (category is not a supported attribute)

 

I'm in the process of hunting for a solution in the code, but perhaps this has been done already when this version was in use? I really do need the SEO URL capability for this client, so if anyone knows how to fix this I'm all ears. If I come up with any answers, I will post. Thanks!

[FlyingMonkey]

i've done this numerous times... in a more suitable fashion to support various SEO formats. I just haven't had the time to code it into the contribution. when i get a break from these 11hr days, i'll make some time to release an updated version.

[DavidR]

i've done this numerous times... in a more suitable fashion to support various SEO formats. I just haven't had the time to code it into the contribution. when i get a break from these 11hr days, i'll make some time to release an updated version.

Well I haven't figured out the category issue yet, but I did notice that the correct sale price is only listed in the export file if the sale expire date is set. I haven't found anything in the code yet that would make sense of this or help me fix it. Has this been addressed before?

 

Also, Google didn't mention it but I noticed that "expected" items are also listed in the file before the date they are expected. I'm surprised they didn't catch it, as I know they require that all items listed be available for sale.

 

I can sympathize with the 11 hour days!!! I realize I am trying to work with an older, patched up version but I'm against a deadline with this feature so this is what I have to work with :'( If you have any suggestions, I will be happy to try to track them down. Thanks.