FlyingMonkey Posted July 27, 2004 Share Posted July 27, 2004 Thanks for the quick reply. I will anxiously await the attribute pricing fix. :) As far as descriptions go, every page says exactly what the item is. The only thing I sell is tapestry products. And how they can get some of the categories I've seen is absolutely beyond me. Maybe a dart board. lol Why are so many people worried about category depth when Froogle won't even use the categories to start with? Just curious... Thanks, Laurie Some people have stores with thousands of products with hundreds of categories. The category strings for some of these are amazing. The more category information than can be given to Froogle, the easier it is for them to categorize. Also, I believe some of them got error e-mails from Froogle because it didn't include the full category trees. One of my client sells niche products and only has a category depth of one. At times their products are shown as medical supplies on Froogle and they're selling glass art. Quote Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
neverfight Posted July 28, 2004 Share Posted July 28, 2004 LOL They ARE using a dart board. :rolleyes: Maybe the category depth is part of the problem then as mine are only 1 deep. Thank you for the insight! Laurie Quote Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 28, 2004 Share Posted July 28, 2004 LOL They ARE using a dart board. :rolleyes: Maybe the category depth is part of the problem then as mine are only 1 deep. Thank you for the insight! Laurie Thanks for the Donation Laurie! It was very much appreciated. Quote Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
neverfight Posted July 28, 2004 Share Posted July 28, 2004 Calvin, You are most welcome. I am trying to work my way around to all of the people who've developed what I'm using. Slowly, but surely. :) Maybe if more osC users did, we'd have an even better system. Free is cool, but giving back is better. :D Thank you again for all of your efforts. Laurie "Man is a magnet, and every line and dot and detail of his experiences come by his own attraction." - Elizabeth Towne Quote Link to comment Share on other sites More sharing options...
Guest Posted July 28, 2004 Share Posted July 28, 2004 yeah but what about the guys who dont write contributions but support them, . . . lol . . Quote Link to comment Share on other sites More sharing options...
Guest Posted July 29, 2004 Share Posted July 29, 2004 (edited) Hi I just installed the contribution on my server. I finally got everyt hing to work and it says it is uploading to google but at the end i get this error: <br> <b>Parse error</b>: parse error in <b>/home/healthy/htdocs/admin/froogle.php</b> on line <b>156</b><br> one of these lines seem to be the prob, but i did not change anything other than removing the */ /*. They are at the line the error was reported //close the FTP stream ftp_close($conn_id); Any help is appriciated. Edited July 29, 2004 by dsm1217 Quote Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 29, 2004 Share Posted July 29, 2004 (edited) You probably removed something that should've been there, just try setting it up again from scratch if you can't find the problem or ask for more help. Edited July 29, 2004 by FlyingMonkey Quote Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2004 Share Posted July 30, 2004 (edited) thats what i though the first itme so i started over, the only things i removed were the comments that were around ftp part. Here is the code, maybe someone will notice somthing I am missing: <?php $OutFile = "/home/healthy/htdocs/admin/temp/froogle/hlpfroogle.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt"; $destination_file = "hlpfroogle.txt"; //"CHANGEME-filename-to-upload-to-froogle.txt" ; $source_file = $OutFile; $imageURL = 'http://www.healthylifepharmacy.com/images'; $productURL = 'http://www.healthylifepharmacy.com/product_info.php?products_id='; $already_sent = array(); $home = "localhost" ; $user="removed"; $pass="removed"; $base="shop"; $ftp_server = "hedwig.google.com" ; $ftp_user_name = "removed"; $ftp_user_pass = "removed"; if (!($link=mysql_connect($home,$user,$pass))) { echo "Error when connecting itself to the data base"; exit(); } if (!mysql_select_db( $base , $link )) { echo "Error the data base does not exist"; exit(); } $sql = " select concat( '" . $productURL . "' ,products.products_id) AS product_url, products_model , products_weight , manufacturers.manufacturers_name , products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, FORMAT(products.products_price,2) AS price, CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url, concat_ws( ' > ' , catdescparent.categories_name , catdesccurrent.categories_name ) AS category FROM categories , products, products_description, categories_description as catdesccurrent, products_to_categories left join categories_description as catdescparent on ( catdescparent.categories_id = categories.parent_id ) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) 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 catdesccurrent.categories_id = categories.categories_id AND products.products_status != 0 ORDER BY products.products_id ASC "; //Check for any applicable specials for the corresponding products_id $sql2 = " SELECT specials.products_id AS idS, FORMAT(specials.specials_new_products_price,2) AS priceS FROM specials, products WHERE specials.products_id=products.products_id AND specials.status != 0 AND products.products_status != 0 ORDER BY specials.products_id ASC "; $_strip_search = array( "![\t ]+$|^[\t ]+!m", // remove leading/trailing space chars '%[\r\n]+%m'); // remove CRs and newlines $_strip_replace = array( '', ''); $output = "product_url \t name \t description \t price \t image_url \t category\n"; $result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) ); //Specials Checker $result2=mysql_query( $sql2 )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql2 = " . htmlentities($sql2) ); $row2 = mysql_fetch_object( $result2 ); $i = 0; while( $row = mysql_fetch_object( $result ) ) { if( $i == 1 ) //first time init { $already_sent[$row->name] = 1; } $i++; if ($already_sent[$row->name] == 1) continue; // if we've sent this one, skip the rest of the while loop // reset the products price to our special price if there is one for this product if( $row2->idS == $row->id ){ $row->price = $row2->priceS; $previdS = $row2->idS; while ( $row2->idS == $previdS ) { $row2 = mysql_fetch_object( $result2 ); //advance row in special's table } } $output .= $row->product_url . "\t" . preg_replace($_strip_search, $strip_replace, strip_tags( str_replace(">", "> ", $row->name) ) ) . "\t" . preg_replace($_strip_search, $strip_replace, strip_tags( str_replace(">", "> ", $row->name) ) ) . "\t" . $row->price . "\t" . $row->image_url . "\t" . $row->category . "\n"; $already_sent[$row->name] = 1; } if ( file_exists( $OutFile ) ) unlink( $OutFile ); $fp = fopen( $OutFile , "w" ); $fout = fwrite( $fp , $output ); fclose( $fp ); //Start FTP to Froogle // set up basic connection $conn_id = ftp_connect($ftp_server); // login with username and password $login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass); // check connection if ((!$conn_id) || (!$login_result)) { echo "FTP connection has failed!<BR>"; echo "Attempted to connect to $ftp_server for user $ftp_user_name<BR>"; exit; } else { echo "Connected to $ftp_server, for user $ftp_user_name<BR>"; } // upload the file $upload = ftp_put($conn_id, $destination_file, $source_file, FTP_BINARY); // check upload status if (!$upload) { echo "FTP upload has <b>FAILED!</b> source: $source_file dest: $destination_file<BR>"; } else { echo "Uploaded $source_file to $ftp_server as $destination_file<BR>"; } //close the FTP stream ftp_close($conn_id); //End FTP to Froogle ?> NOTE the removed password are correct on my rserver. Help is appriciated. Thanks all Edited July 30, 2004 by dsm1217 Quote Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2004 Share Posted July 30, 2004 one thing we need to know, is when you execute the program manually, is your froogle txt file being created? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2004 Share Posted July 30, 2004 sorry, yes it is being created and placed where it should be. it also appears to be correct in formatting Quote Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 30, 2004 Share Posted July 30, 2004 sorry, yes it is being created and placed where it should be. it also appears to be correct in formatting heh? then what's wrong? if your still getting the parsing error, try deleting the generated file in that directory. then rerunning it and see if the file still exist. if the file is not there, then just copy and paste your settings into a fresh froogle.php and uncomment the ftp code. Quote Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2004 Share Posted July 30, 2004 (edited) well it would not upload to froogle was the problem at the time. i am getting a different error now for some reason. I have not changed anything in the script. Here is what it says now: Output from command /usr/bin/php -q /home/healthy/htdocs/admin/froogle.php .. <br> <b>Warning</b>: Unable to find ftpbuf 0 in <b>/home/healthy/htdocs/admin/froogle.php</b> on line <b>135</b><br> FTP connection has failed!<BR>Attempted to connect to hedwig.google.com for user healthylifepharmacy<BR> sorry forgot to add that the froogle.txt file is still getting built, the problems arise in the ftp portion of the task Edited July 30, 2004 by dsm1217 Quote Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2004 Share Posted July 30, 2004 you need to double check to make sure which you are running, whether it be cgi or an apache module, as to how the command will work. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2004 Share Posted July 30, 2004 it is the apache method Quote Link to comment Share on other sites More sharing options...
FlyingMonkey Posted July 30, 2004 Share Posted July 30, 2004 Froogle Data Feeder Version 1.4 is ready for beta testing. Please PM me if you are interested. It includes the Advance Data Feed Format from Froogle. Quote Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
djs Posted July 30, 2004 Share Posted July 30, 2004 dsm1217 One thing to check is if your froogle feed is being written to a password protected directory (i.e., somewhere under admin/), then when you are uploading the file, it may not have permissions to read the file. You initial problem was likely just a read permissions problem. I don't know what your problem is now, but if you get back to where you were, try writing the file to an open directory and see if it works. You can add a function to delete the file after the upload if you are concerned about it. Dan Quote Dan Stevens Link to comment Share on other sites More sharing options...
Guest Posted July 31, 2004 Share Posted July 31, 2004 are you automating the apache load or doing it manually? u may have to use the command similar to the cron job command for uploading Quote Link to comment Share on other sites More sharing options...
211655 Posted August 1, 2004 Share Posted August 1, 2004 i can never have this to work for some reason. i have iis 6 no crons. and i dont mind to submit manully. Quote 211655 SEO Optimization Export Orders into CSV file Link to comment Share on other sites More sharing options...
Guest Posted August 1, 2004 Share Posted August 1, 2004 make sure you can write the data file to the directory pointed to, it does work pretty good. i havent played with it on iis6, do you have iis6 working all the way now? there were a few problems a long time ago with it. Quote Link to comment Share on other sites More sharing options...
CatDadRick Posted August 2, 2004 Share Posted August 2, 2004 211655, Windows servers (and workstations) have AT. It works similar to cron. I haven't use it for some time but it is capable of running allmost any job at any time on just about any schedule you might want. Do a google on "at commands" and you should be able to find all you need to get it going. Good Luck. CatDadRick Quote Link to comment Share on other sites More sharing options...
Guest Posted August 2, 2004 Share Posted August 2, 2004 from the dos prompt, you can type in: at /? Quote Link to comment Share on other sites More sharing options...
FlyingMonkey Posted August 3, 2004 Share Posted August 3, 2004 (edited) anyone else want to give 1.4 beta a whirl? seems to be running fine. Edited August 3, 2004 by FlyingMonkey Quote Most likely your question has been answered, please do a search first. Link to comment Share on other sites More sharing options...
211655 Posted August 3, 2004 Share Posted August 3, 2004 does this contribution converts html product description to a text? i have html tables and info as product desc. how would it work? Quote 211655 SEO Optimization Export Orders into CSV file Link to comment Share on other sites More sharing options...
Guest Posted August 3, 2004 Share Posted August 3, 2004 your best bet would be to run the program and then look at the file it creates. it pulls info out of the database and creates the data. Quote Link to comment Share on other sites More sharing options...
cgchris99 Posted August 4, 2004 Share Posted August 4, 2004 I don't want to hijack this thread but if anyone would like to offer any advice on froogle positioning, I would love to hear it. My OSC store is always last on the 'default' froogle list. But I am #1 on google. The thread is here. http://www.oscommerce.com/forums/index.php?showtopic=105251 thanks for any help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.