Latest News: (loading..)
gottaloveit

Automatically send data feed to Froogle

3,578 posts in this topic

Google Base / Froogle Data Feeder v1.20

Released By: Calvin K

E-Mail: calvink@conceptualnetworking.com

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

 

Date: February 25, 2006

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, SEO links, 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 "quantity" 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.

 

Note: v1.10 was not publically released, but it's new SEO link feature is included in v1.20.

 

Feature: v1.20 updates the feed attribute requirements to Google's new February 2007 Requirements.

Edited by FlyingMonkey

Share this post


Link to post
Share on other sites

Hi,

 

I've installed the latest version of this great contribution. Everything was a success until I pointed my browser to http://www.********.com/feeds/my-outfile.txt. The problem is that my products URLs are not generated properly. I'm using the latest version of Ultimate SEO URLs "Ultimate SEO URLs - 2.1d with optional Admin settable Product and Category URLs" by Yesudo. But I noticed that my products links shown in the feeder file are as follows:

 

www.********.com/product_info.php?products_id=1

www.********.com/product_info.php?products_id=2

www.********.com/product_info.php?products_id=3

www.********.com/product_info.php?products_id=4

www.********.com/product_info.php?products_id=5

And os on.

 

Any idea how to fix this?

Would appreciate any help.

 

One more thing, I noticed that the brand column is blank. Am I missing something?

 

Thank You.

Share this post


Link to post
Share on other sites

Thanks for the update!! Works great!!!!

 

Just a question about 'product_type'. How do I get it to report the top level category?

 

For example:

 

I sell mostly outdoor sporting goods products. I list a category such as knives and then by brand/manufacturer. When I run googlefeeder.php the column for 'product_type' is 'Knives, Gerber'.

 

I know this is trival and I can edit the output file, but it would be nice to have it only report the 'top-level' category.

 

TIA

Share this post


Link to post
Share on other sites

plusecheck: please read the installation guide, I believe it's step 2 or 3. Good luck! Brand is based on the Manufacturer that is set for the product. If no manufacturer is set, then there will be no brand. =)

 

edukes: For product type, I currently have it set to include the entire category tree (which may not neccessary be correct). My logic was that the more information about the product we can provide Google, the better chance of their algorithms guessing it correctly. If Google complains, I will adjust it to just the product level category. To obtain the 'top-level' category you would have to trace from the current category level through every parent category. If it's just one category deep, then you could just call for the parent category.

 

once again, i don't have a store anymore. so let me know if you notice any bugs. i will be traveling again for a while, so i may not have access to the forums. =)

Edited by FlyingMonkey

Share this post


Link to post
Share on other sites

I have had problems the last few months with this script not uploading properly after connecting to google. I uncommented the following line and it works fine now. I'm not exactly certain why...perhaps google changed their ftp setting requirements.

 

//ftp_pasv ( $conn_id, true );

Share this post


Link to post
Share on other sites
I have had problems the last few months with this script not uploading properly after connecting to google. I uncommented the following line and it works fine now. I'm not exactly certain why...perhaps google changed their ftp setting requirements.

 

//ftp_pasv ( $conn_id, true );

 

no, it usually has to do with your hosting and what ftp capabilities it allows. =)

Share this post


Link to post
Share on other sites

Hi,

 

I get a totally blank page when trying to generate the feed.

 

$OutFile = "http://www.motorheadextraordinaire.com/feeds/motor_feed.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions-your-outfile.txt";

$destination_file = "motor_feed.txt"; //"CHANGEME-filename-to-upload-to-google.txt" ;

$source_file = $OutFile;

$catalogURL = 'http://www.motorheadextraordinaire.com/';

$imageURL = 'http://www.motorheadextraordinaire.com/images/';

$productURL = 'http://www.motorheadextraordinaire.com/product_info.php?products_id=';

 

The products url in the store looks like this:

http://www.motorheadextraordinaire.com/pro.../products_id/38

With each folder a different number.

 

What goes in here? Is this a google account that the store owner needs to setup?

 

$ftp_server = "uploads.google.com" ;

$ftp_user_name = "CHANGEME-googleFTP-username";

$ftp_user_pass = "CHANGEME-googleFTP-password";

Share this post


Link to post
Share on other sites
What goes in here? Is this a google account that the store owner needs to setup?

 

$ftp_server = "uploads.google.com" ;

$ftp_user_name = "CHANGEME-googleFTP-username";

$ftp_user_pass = "CHANGEME-googleFTP-password";

 

Yes, you must create a Google Account, that username and password will go there.

Share this post


Link to post
Share on other sites

sorry, double posted

Edited by jgarite

Share this post


Link to post
Share on other sites

I receieved the following error after installation. I haven't gone further than step 6 yet because it doesn't appear to be working properly. here is the error message:

 

Warning: fopen(http://www.sitename.com/catalog/feeds/froogle.txt) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /data/8/0/88/161/577324/user/589105/htdocs/catalog/admin/googlefeeder.php on line 321

 

Warning: fwrite(): supplied argument is not a valid stream resource in /data/8/0/88/161/577324/user/589105/htdocs/catalog/admin/googlefeeder.php on line 322

 

Warning: fclose(): supplied argument is not a valid stream resource in /data/8/0/88/161/577324/user/589105/htdocs/catalog/admin/googlefeeder.php on line 323

File completed: froogle.txt

 

Warning: chmod() [function.chmod]: No such file or directory in /data/8/0/88/161/577324/user/589105/htdocs/catalog/admin/googlefeeder.php on line 325

 

Script timer: 0.811788 seconds.

Share this post


Link to post
Share on other sites
I receieved the following error after installation. I haven't gone further than step 6 yet because it doesn't appear to be working properly. here is the error message:

 

Did you double check to ensure that your feeds folder is set to 777? Some host may not allow 777, try using 775 or 755.

Share this post


Link to post
Share on other sites

$OutFile = "http://www.motorheadextraordinaire.com/feeds/motor_feed.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions-your-outfile.txt";
$destination_file = "motor_feed.txt"; //"CHANGEME-filename-to-upload-to-google.txt";
$source_file = $OutFile;
$catalogURL = 'http://www.motorheadextraordinaire.com/';
$imageURL = 'http://www.motorheadextraordinaire.com/images/';
$productURL = 'http://www.motorheadextraordinaire.com/product_info.php?products_id=';

$ftp_server = "uploads.google.com";
$ftp_user_name = "xxxxxxxxx";
$ftp_user_pass = "xxxx";

 

Ok we got his account and it still doesn't work. I get a totally blank white page.

 

The products url in the store looks like this:

http://www.motorheadextraordinaire.com/pro.../products_id/38

With each folder a different number so I don't know what to do here.

 

Thanks!

Share this post


Link to post
Share on other sites

$OutFile = "http://www.motorheadextraordinaire.com/feeds/motor_feed.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions-your-outfile.txt";
$destination_file = "motor_feed.txt"; //"CHANGEME-filename-to-upload-to-google.txt";
$source_file = $OutFile;
$catalogURL = 'http://www.motorheadextraordinaire.com/';
$imageURL = 'http://www.motorheadextraordinaire.com/images/';
$productURL = 'http://www.motorheadextraordinaire.com/product_info.php?products_id=';

$ftp_server = "uploads.google.com";
$ftp_user_name = "xxxxxxxxx";
$ftp_user_pass = "xxxx";

 

Ok we got his account and it still doesn't work. I get a totally blank white page.

 

The products url in the store looks like this:

http://www.motorheadextraordinaire.com/pro.../products_id/38

With each folder a different number so I don't know what to do here.

 

Thanks!

Share this post


Link to post
Share on other sites
$OutFile = "http://www.motorheadextraordinaire.com/feeds/motor_feed.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions-your-outfile.txt";
$destination_file = "motor_feed.txt"; //"CHANGEME-filename-to-upload-to-google.txt";
$source_file = $OutFile;
$catalogURL = 'http://www.motorheadextraordinaire.com/';
$imageURL = 'http://www.motorheadextraordinaire.com/images/';
$productURL = 'http://www.motorheadextraordinaire.com/product_info.php?products_id=';

$ftp_server = "uploads.google.com";
$ftp_user_name = "xxxxxxxxx";
$ftp_user_pass = "xxxx";

 

Ok we got his account and it still doesn't work. I get a totally blank white page.

 

The products url in the store looks like this:

http://www.motorheadextraordinaire.com/pro.../products_id/38

With each folder a different number so I don't know what to do here.

 

Thanks!

Sorry, but that's where I ran into the same problem and than gave up and decided to just do it manually. Hope someone else can help you. :(

Share this post


Link to post
Share on other sites
echo $output;

 

If you don't get any output, remove line 309 and insert that same line of code into line: 320.

 

This way you'll at least see if the feeder does anything. At a minimum you should get the headers for the file"brand\tcondition\tlink\ttitle\tdescription\texpiration_date\tprice\timage_link\tproduct_type\tid"; If you do get output, then it may be an issue with you hosting. Are any advance configurations enabled?

 

-Calvin

Share this post


Link to post
Share on other sites

Hi

 

I'm looking to install this contribution, I have Ultimate SEO and Separate Pricing per Customer installed currently. Couple of quick questions before I give it a go.

1. Do I need to change anything for UK use (Froogle.co.uk rather than.com)?

2. Does Google Base / Froogle Data Feeder v1.20 work with Ultimate SEO or do I need to use Google Base / Froogle Data Feeder v1.03b for Ultimate SEO?

 

Many thanks in advance.

Katie.

Share this post


Link to post
Share on other sites

Hi

 

I'm looking to install this contribution, I have Ultimate SEO and Separate Pricing per Customer installed currently. Couple of quick questions before I give it a go.

1. Do I need to change anything for UK use (Froogle.co.uk rather than.com)?

2. Does Google Base / Froogle Data Feeder v1.20 work with Ultimate SEO or do I need to use Google Base / Froogle Data Feeder v1.03b for Ultimate SEO?

 

Many thanks in advance.

Katie.

Share this post


Link to post
Share on other sites

Calvin,

 

When I inserted that line at line 309 I got a very long list of all products...this is the last line:

2007-04-05 1,496.50 http://www.motorheadextraordinaire.com/images/Custom® Series Portable With 2 Doors, 2 Drawers ss.JPG test - not for sale 103 File completed: motor_feed.txt

 

Script timer: 22.994957 seconds.

 

www.motorheadextraordinaire.com/admin/googlefeeder.php

 

When I clicked on that motor_feed.txt link at the very bottom I get a blank page???

 

It is my server for hosting and I have no advanced options enabled. The text file is 777 along with the feeds folder.

 

I don't know where else to look. The feeds folder is under the catalog folder.

 

Now, when I read this part again:

$OutFile = "../feeds/your-outfile.txt"; //Replace "your-outfile" with the filename provided by Google

$destination_file = "your-outfile.txt"; //"your-outfile" is provided by Google and is the same as above without the directory information

 

It says provided by Google. I just made a text file and put it in the feeds folder:

$OutFile = "http://www.motorheadextraordinaire.com/feeds/motor_feed.txt";

$destination_file = "../feeds/motor_feed.txt";

$source_file = $OutFile;

Edited by Melinda Odom

Share this post


Link to post
Share on other sites

I know this may sound strange but why do I not see install instructions?

Share this post


Link to post
Share on other sites

hmm hi... dont know why in the readme it says...

$imageURL = 'CHANGEME-http://www.yourwebsite.com/yourimagesdirectory/';

 

if my admin folder is http://www.yourwebsite.com/catalog/admin/

I have to change this http wrapper to

 

$imageURL = '../images/';

../ means I go one folder back out of admin and into /images/

maybe someone has the same problem...

 

my configuration looks like this now:

 

$OutFile = "../feeds/froogle.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions-your-outfile.txt";
$destination_file = "froogle.txt";  //"CHANGEME-filename-to-upload-to-google.txt";
$source_file = $OutFile;
$catalogURL = '../';
$imageURL = '../images/';
$productURL = '../product_info.php?products_id=';
$already_sent = array();

 

its working with this configuration but the codes that are made include the wrong link....

Edited by MaNoLiA

Share this post


Link to post
Share on other sites

ok fixed the problem now... for

$productURL = '../product_info.php?products_id=';

use the full http:// address...

 

$productURL = 'http://www.yourwebsite.com/catalog/product_info.php?products_id=';

$imageURL = 'http://www.yourwebsite.com/catalog/images/';

 

I have a problem with the language... I have 3 languages... and there is a mix of english and spain :(

Edited by MaNoLiA

Share this post


Link to post
Share on other sites

Ok I added the language option for product title and description:

 

 

lines 119-140

WHERE products.products_id=products_description.products_id
AND products.products_id=products_to_categories.products_id
AND products_to_categories.categories_id=categories.categories_id
AND categories.categories_id=categories_description.categories_id
//add this:
AND products_description.language_id=2
// end
ORDER BY
products.products_id ASC
";


$catInfo = "
SELECT
//add this:
categories_description.language_id,
// end
categories.categories_id AS curCatID,
categories.parent_id AS parentCatID,
categories_description.categories_name AS catName
FROM
categories,
categories_description
WHERE categories.categories_id = categories_description.categories_id
//add this:
AND categories_description.language_id=2
// end
";

 

you should change this to a $language var that is editable by users in the next update? ;)

Share this post


Link to post
Share on other sites

grrrrr

still not working cause Strato disabled the ftp_connect function:

 

Call to undefined function: ftp_connect()

 

Someone got a solution for this?? :(

Share this post


Link to post
Share on other sites
Calvin,

 

When I inserted that line at line 309 I got a very long list of all products...this is the last line:

2007-04-05 1,496.50 http://www.motorheadextraordinaire.com/images/Custom® Series Portable With 2 Doors, 2 Drawers ss.JPG test - not for sale 103 File completed: motor_feed.txt

 

Script timer: 22.994957 seconds.

 

www.motorheadextraordinaire.com/admin/googlefeeder.php

 

When I clicked on that motor_feed.txt link at the very bottom I get a blank page???

 

It is my server for hosting and I have no advanced options enabled. The text file is 777 along with the feeds folder.

 

I don't know where else to look. The feeds folder is under the catalog folder.

 

Now, when I read this part again:

$OutFile = "../feeds/your-outfile.txt"; //Replace "your-outfile" with the filename provided by Google

$destination_file = "your-outfile.txt"; //"your-outfile" is provided by Google and is the same as above without the directory information

 

It says provided by Google. I just made a text file and put it in the feeds folder:

$OutFile = "http://www.motorheadextraordinaire.com/feeds/motor_feed.txt";

$destination_file = "../feeds/motor_feed.txt";

$source_file = $OutFile;

 

Check the feeds folder via your ftp for any files created and the date they were created.

Share this post


Link to post
Share on other sites

Calvin,

 

The only file in the feeds folder is the motor_feed.txt file which is blank.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now