Jump to content
gottaloveit

Automatically send data feed to Froogle

Recommended Posts

Great! Where can we find it? I don't seem to see it in the usual contribution places....

 

Thanks,

Susan

 

 

They've seem to have deleted it.... cause i have a link to my website that's been there since the original release. i'll have to update it later on and reupload. i'm already late for class, so it may be a few days before i can get around cause i'm going straight to la for the weekend after class.

Edited by FlyingMonkey

Most likely your question has been answered, please do a search first.

Share this post


Link to post
Share on other sites
Happy July 4th everyone

 

ok well I can answer the SEO url difficulties kinda....

 

what has worked for me and has given froogle the correct URL

 

is

 

putting in your feed file under the product url config line

 

http://www.your-site-name.com/catalog/prod...hp?products_id=

then the froogle feed contrib will add a product number after the =

whenever it generates the .txt file.... lol i dont know if anyone posted this... i have looked over all 59 pages of this post and have not seen any posts regarding that... so here it is...

 

if anyone has any questions or it dosent work for you for some reason let me know... it has worked for me although..

 

Anyone ever come up with an answer to the error

 

Warning: getimagesize(): Read error! in /customers/adweb322361/ftp/www.mrdeliveryman.com/public_html/catalog/admin/includes/classes/feed.php on line 185

thanks

indi

 

I am trying to figure out what you mean by "putting in your feed file under the product url config line"

 

I believe your talking about editing the froogle.php so the first part of the code looks like this:

 

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

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

$OutFile = "../feeds/frooglefeed.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt";

$destination_file = "frooglefeed.txt"; //"CHANGEME-filename-to-upload-to-froogle.txt" ;

$source_file = $OutFile;

$already_sent = array();

 

 

Is this correct? I still get the "stock" osCommerce URL's in my .txt file.

Share this post


Link to post
Share on other sites
Good to know.  I never got around to posting yesterday that the errors you describe were on your server's end...but I'm happy the issue is resolved. :)

Actually, I am having the same problem again. :( My site went down again and when it came back up, the problems started all over. Here once again is the error that I receive:

 

File completed: xxxx.txt

Connected to hedwig.google.com, for user xxxx

 

Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110) in /home/xxxx/public_html/admin/froogle.php on line 343

 

Warning: ftp_put(): Entering Passive Mode (216,239,45,39,79,227) in /home/xxxx/public_html/admin/froogle.php on line 343

hedwig.google.com: FTP upload has failed!

 

Script timer: 46.170156 seconds.

 

Can anyone think of a reason why the FTP upload has failed? Is this really an issue with my server? If so, what could it be? I had them increase the PHP timeout settings but that didn't seem to help. I should also mention that the one time I did get this to work, the script timer only reported 2 seconds. So it's not that the file is loaded with too many products or anything, there's only about 800. Any help would be greatly appreciated.

 

Thanks,

Paul

Share this post


Link to post
Share on other sites

I have a strange problem, I have been using this contrib know for several months without any problems, but suddenly some desriptions are in dutch and also the category names are partly, yes you read it correct partly, in dutch.

 

so for example the category name is now like this on the text file:

Gold Jewelry> Armbanden, instead of : Gold Jewelry> Bracelets

 

Can somebody, please help me to figure this out

Share this post


Link to post
Share on other sites

I got froogle data feed to work on one of my stores but I am having problems with a different one.. and I didn't know how to search for the answer.

 

I have a store where the database name are like

 

peacem_categories instead of categories

peacem_products instead of products

etc.....

 

and I don't understand enoght of the calling the databate table to change it in the froogle.php

 

 

 

 

$sql = "

SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,

products_model AS prodModel, products_weight,

manufacturers.manufacturers_name AS mfgName,

manufacturers.manufacturers_id,

products.products_id AS id,

products_description.products_name AS name,

products_description.products_description AS description,

products.products_quantity AS quantity,

products.products_status AS prodStatus,

FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,

CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url,

products_to_categories.categories_id AS prodCatID,

categories.parent_id AS catParentID,

categories_description.categories_name AS catName

FROM categories,

categories_description,

products,

products_description,

products_to_categories

 

left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id )

left join specials on ( specials.products_id =

 

products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) )

 

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

ORDER BY

products.products_id ASC

";

 

$catInfo = "

SELECT

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

 

Thank you very much

noppie


Peace is possible.. Please don't give up.

 

"War is --the old betraying the young"

Share this post


Link to post
Share on other sites

Is there a way of automatically stripping the 'tab' characters from the product descriptions? Occasionally when loading a new product from the manufacturer's description these characters cause the line to be rejected for obvious reasons by Froogle.

Share this post


Link to post
Share on other sites
I got froogle data feed to work on one of my stores but I am having problems with a different one.. and I didn't know how to search for the answer.

 

I have a store where the database name are like

 

peacem_categories instead of categories

peacem_products instead of products

etc.....

 

and I don't understand enoght of the calling the databate table to change it in the froogle.php

 

Thank you very much

noppie

 

 

peacem_categories = categories

 

Call it by calling categories

 

peacem_ is just a prefix.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites
cts instead of products

etc.....

 

and I don't understand enoght of the calling the databate table to change it in the froogle.php

 

Thank you very much

noppie

*

 

 

 

 

peacem_categories = categories

 

Call it by calling categories

 

peacem_ is just a prefix.

 

I understand this the categories froogle is trying to call is not categories but peacem_categories. where do I change it.

: SQL error Table 'rainbow_peace.categories' doesn't exist| catInfo = SELECT 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

 

I get the error about.. that is why I am asking

 

Thank you

noppie


Peace is possible.. Please don't give up.

 

"War is --the old betraying the young"

Share this post


Link to post
Share on other sites

I have a MOD that send me e-mails whenever there is an error on my site or someone tries to hack into the site, like try to get into the Admin.

 

For months now, I have been getting this e-mail when Google visits my site and sometimes MSNBot for various product pages and so on...

 

-------------------------------------------
Site: http://www.popthetop.com
Error Code: 404 - File or Page Not Found
Occurred: 08/28/2005 7:55:44
Requested URL: http://www.popthetop.com/catalog/product_info.php%3Fcurrency%3DUSD&products_id%3D324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA
User IP Address: 66.249.65.66
User Agent: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
Referer: 
-------------------------------------------

 

As you can see, Google is trying to load pages that the links have converted = signs and question marks.

 

%3F is supposed to be ?

%3D is supposed to be =

 

If I turn

http://www.popthetop.com/catalog/product_info.php%3Fcurrency%3DUSD&products_id%3D324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA

into this

http://www.popthetop.com/catalog/product_info.php?currency=USD&products_id=324&fr=AM0D2pquQxgKeI9frlt5U5R8v6OCmDEu09vJmtrY-N41AAAAAAAAAAA

The links work.

 

Is there any way to fix this so that the correct pages get loaded? Is there any way to convert %3F to ? and %3D to = when a page loads?


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

Hello,

 

I have a shop in Germany with the only currency EURO. As I found out in this forum to be able to use Froogle for the USA I have to have EURO AND US-Dollar offered in the currency box, so USA customers can see prices in US-Dollar. Additionally I have to be able to send my products to the USA. The "Google feeder" contri would convert Euros to US-Dollars. Now my questions:

 

. Does "Google feeder" take the exchange rate from "Currencies" in Admin?

. I think there is a contri available for calculating the exchange rate with a cron job in Admin, right?

. Would it be possible to show customers also Dollar prices, by klicking the Dollar currency box, but they HAVE TO pay in Euros? I ask this because I would not like to get paid in Dollars because when I put Dollars onto my Euro account I'd have to pay exchange fees.

. Is "Google feeder" with the tax and currency conversion functions and handling correctly prices above 999 (there was once a bug) also available for my Oscommerce version which is from January 2003?

 

A lot of questions, but I am still in hope that there is someone who can help me.

 

Thanks in advance for your answer.

 

Albert

Share this post


Link to post
Share on other sites

Whats about the third question? Probably its not allowed that customers see Dollar-prices but they HAVE TO pay in Euros.

 

Albert

Share this post


Link to post
Share on other sites

<?php
//  Start TIMER
//  -----------
$stimer = explode( ' ', microtime() );
$stimer = $stimer[1] + $stimer[0];
//  -----------


$OutFile = "../feeds/xxxxx.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt";
$destination_file = "peace.txt";  //"CHANGEME-filename-to-upload-to-froogle.txt";
$source_file = $OutFile;
$imageURL = 'http://rainbowstop.com/peacem/images/';
$productURL = 'http://rainbowstop.com/peacem/product_info.php?products_id=';
$already_sent = array();

$home = "localhost";
$user="xxxxxx";
$pass="xxx";
$base="rxxxxx";

$ftp_server = "hedwig.google.com";
$ftp_user_name = "xxxxxxx";
$ftp_user_pass = "xxxxxxxxxxl";
$ftp_directory = ""; // leave blank for froogle

$taxRate = 0; //default = 0 (e.g. for 17.5% tax use "$taxRate = 17.5;")
$taxCalc = ($taxRate/100) + 1;  //Do not edit
$convertCur = false; //default = false
$curType = "USD"; // Converts Currency to any defined currency (eg. USD, EUR, GBP)
if($convertCur)
{
$productURL = "http://rainbowstop.com/peacem/product_info.php?currency=" . $curType . "&products_id=";  //where CURTYPE is your currency type (eg. USD, EUR, GBP)
}

//START Advance Optional Values

//(0=False 1=True) (optional_sec must be enabled to use any options)
$optional_sec = 0;
$instock = 0;
$shipping = 0;
$lowestShipping = "4.95";  //this is not binary.
$brand = 0;
$upc = 0;   //Not supported by default osC
$manufacturer_id = 0;  //Not supported by default osC
$product_type = 0;
$currency = 0;
$default_currency = "USD";  //this is not binary.
$feed_language = 0;
$default_feed_language = "en";  //this is not binary.
$ship_to = 0;
$default_ship_to = "ALL"; //this is not binary, not supported by default osC for individual products.
$ship_from = 0;
$default_ship_from = "USD"; //this is not binary, not supported by default osC for individual products.

//END of Advance Optional Values

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 AS prodModel, products_weight,
manufacturers.manufacturers_name AS mfgName,
manufacturers.manufacturers_id,
products.products_id AS id,
products_description.products_name AS name,
products_description.products_description AS description,
products.products_quantity AS quantity,
products.products_status AS prodStatus,
FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,
CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url,
products_to_categories.categories_id AS prodCatID,
categories.parent_id AS catParentID,
categories_description.categories_name AS catName
FROM peacem_categories,
categories_description,
peacem_products,
products_description,
products_to_categories

left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id )
left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) )

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
ORDER BY
products.products_id ASC
";


$catInfo = "
SELECT
categories.categories_id AS curCatID,
categories.parent_id AS parentCatID,
categories_description.categories_name AS catName
FROM
peacem_categories,
peacem_categories_description
WHERE categories.categories_id = categories_description.categories_id
";

function findCat($curID, $catTempPar, $catTempDes, $catIndex)
{
if( (isset($catTempPar[$curID])) && ($catTempPar[$curID] != 0) )
{
 if(isset($catIndex[$catTempPar[$curID]]))
 {
	 $temp=$catIndex[$catTempPar[$curID]];
 }
 else
 {
	 $catIndex = findCat($catTempPar[$curID], $catTempPar, $catTempDes, $catIndex);
	 $temp = $catIndex[$catTempPar[$curID]];
 }
}
if( (isset($catTempPar[$curID])) && (isset($catTempDes[$curID])) && ($catTempPar[$curID] == 0) )
{
 $catIndex[$curID] = $catTempDes[$curID];
}
else
{
 $catIndex[$curID] = $temp . " > " . $catTempDes[$curID];
}
return $catIndex;

}

$catIndex = array();
$catTempDes = array();
$catTempPar = array();
$processCat = mysql_query( $catInfo )or die( $FunctionName . ": SQL error " . mysql_error() . "| catInfo = " . htmlentities($catInfo) );
while ( $catRow = mysql_fetch_object( $processCat ) )
{
$catKey = $catRow->curCatID;
$catName = $catRow->catName;
$catParID = $catRow->parentCatID;
if($catName != "")
{
 $catTempDes[$catKey]=$catName;
 $catTempPar[$catKey]=$catParID;
}
}

foreach($catTempDes as $curID=>$des)  //don't need the $des
{
$catIndex = findCat($curID, $catTempPar, $catTempDes, $catIndex);
}

$_strip_search = array(
"![\t ]+$|^[\t ]+!m", // remove leading/trailing space chars
'%[\r\n]+%m'); // remove CRs and newlines
$_strip_replace = array(
'',
'');
$_cleaner_array = array(">" => "> ", "®" => "", "?" => "", "™" => "", "(tm)" => "");

if ( file_exists( $OutFile ) )
unlink( $OutFile );

$output = "product_url \t name \t description \t price \t image_url \t category \t offer_id";

//create optional section
if($optional_sec == 1)
{
if($instock == 1)
 $output .= "\t instock ";
if($shipping == 1)
 $output .= "\t shipping ";
if($brand == 1)
 $output .= "\t brand ";
if($upc == 1)
 $output .= "\t upc ";
if($manufacturer_id == 1)
 $output .= "\t manufacturer_id ";
if($product_type == 1)
 $output .= "\t product_type ";
if($currency == 1)
 $output .= "\t currency ";
if($feed_language == 1)
 $output .= "\t language ";
if($ship_to == 1)
 $output .= "\t ship_to ";
if($ship_from == 1)
 $output .= "\t ship_from ";
}
$output .= "\n";


$result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) );

//Currency Information
if($convertCur)
{
$sql3 = "
SELECT
currencies.value AS curUSD
FROM
currencies
WHERE currencies.code = '$curType'
";

$result3=mysql_query( $sql3 )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql3 = " . htmlentities($sql3) );
$row3 = mysql_fetch_object( $result3 );
}

$loop_counter = 0;

while( $row = mysql_fetch_object( $result ) )
{
if (isset($already_sent[$row->id])) continue; // if we've sent this one, skip the rest of the while loop

if( $row->prodStatus == 1 || ($optional_sec == 1 && $instock == 1) )
{

 if($convertCur)
 {
	 $row->price = ereg_replace("[^.0-9]", "", $row->price);
	 $row->price = $row->price *  $row3->curUSD;
	 $row->price = number_format($row->price, 2, '.', ',');
 }

 $output .= $row->product_url . "\t" .
 preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" .
 preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" .
 $row->price . "\t" .
 $row->image_url . "\t" .
 $catIndex[$row->prodCatID] . "\t" .
 $row->id;

//optional values section
if($optional_sec == 1)
{
 if($instock == 1)
 {
	 if($row->prodStatus == 1)
	 {
   $prodStatusOut = "Y";
	 }
	 else
	 {
   $prodStatusOut = "N";
	 }
	 $output .= " \t " . $prodStatusOut;
 }
 if($shipping == 1)
	 $output .= " \t " . $lowestShipping;
 if($brand == 1)
	 $output .= " \t " . $row->mfgName;
 if($upc == 1)
	 $output .= " \t " . "Not Supported";
 if($manufacturer_id == 1)
	 $output .= " \t " . "Not Supported";
 if($product_type == 1)
 {
	 $catNameTemp = strtolower($catName);
	 if($catNameTemp == "books")
   $productTypeOut = "book";
	 else if($catNameTemp == "music")
   $productTypeOut = "music";
	 else if($catNameTemp == "videos")
   $productTypeOut = "video";
	 else
   $productTypeOut = "other";

	 $output .= " \t " . $productTypeOut;
 }
 if($currency == 1)
	 $output .= " \t " . $default_currency;
 if($feed_language == 1)
	 $output .= " \t " . $default_feed_language;
 if($ship_to == 1)
	 $output .= " \t " . $default_ship_to;
 if($ship_from == 1)
	 $output .= " \t " . $default_ship_from;
}
$output .= " \n";
}
$already_sent[$row->id] = 1;


$loop_counter++;
if ($loop_counter>750) {
$fp = fopen( $OutFile , "a" );
$fout = fwrite( $fp , $output );
fclose( $fp );
$loop_counter = 0;
$output = "";
}
}

$fp = fopen( $OutFile , "a" );
$fout = fwrite( $fp , $output );
fclose( $fp );
echo "File completed: <a href=\"" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a><br>\n";
chmod($OutFile, 0777);


//Start FTP to Froogle

function ftp_file( $ftpservername, $ftpusername, $ftppassword, $ftpsourcefile, $ftpdirectory, $ftpdestinationfile )
{
// set up basic connection
$conn_id = ftp_connect($ftpservername);
if ( $conn_id == false )
{
echo "FTP open connection failed to $ftpservername <BR>\n";
return false;
}

// login with username and password
$login_result = ftp_login($conn_id, $ftpusername, $ftppassword);

// check connection
if ((!$conn_id) || (!$login_result)) {
echo "FTP connection has failed!<BR>\n";
echo "Attempted to connect to " . $ftpservername . " for user " . $ftpusername . "<BR>\n";
return false;
} else {
echo "Connected to " . $ftpservername . ", for user " . $ftpusername . "<BR>\n";
}

if ( strlen( $ftpdirectory ) > 0 )
{
if (ftp_chdir($conn_id, $ftpdirectory )) {
echo "Current directory is now: " . ftp_pwd($conn_id) . "<BR>\n";
} else {
echo "Couldn't change directory on $ftpservername<BR>\n";
return false;
}
}

ftp_pasv ( $conn_id, true );
// upload the file
$upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII );

// check upload status
if (!$upload) {
echo "$ftpservername: FTP upload has failed!<BR>\n";
return false;
} else {
echo "Uploaded " . $ftpsourcefile . " to " . $ftpservername . " as " . $ftpdestinationfile . "<BR>\n";
}

// close the FTP stream
ftp_close($conn_id);

return true;
}

ftp_file( $ftp_server, $ftp_user_name, $ftp_user_pass, $source_file, $ftp_directory, $destination_file);

//End FTP to Froogle


//  End TIMER
//  ---------
$etimer = explode( ' ', microtime() );
$etimer = $etimer[1] + $etimer[0];
echo '<p style="margin:auto; text-align:center">';
printf( "Script timer: <b>%f</b> seconds.", ($etimer-$stimer) );
echo '</p>';
//  ---------

?>

 

the above is my froogle file.. and I know it seems i posted twice or more. but i really need help.. and I think I am getting somewhere but can't seem to go farther.

 

all my table have prefixes for this store.

and the prefix for this one is peacem

and I get this error when I run the froogle in admin

 

: SQL error Unknown table 'categories' in field list| catInfo = SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM peacem_categories, peacem_categories_description WHERE categories.categories_id = categories_description.categories_id

 

please please help

I want to go to washington DC and need to sell some items so I can go.

thank you in advance.

noppie


Peace is possible.. Please don't give up.

 

"War is --the old betraying the young"

Share this post


Link to post
Share on other sites
Hello,

 

I have a shop in Germany with the only currency EURO. As I found out in this forum to be able to use Froogle for the USA I have to have EURO AND US-Dollar offered in the currency box, so USA customers can see prices in US-Dollar. Additionally I have to be able to send my products to the USA. The "Google feeder" contri would convert Euros to US-Dollars. Now my questions:

 

. Does "Google feeder" take the exchange rate from "Currencies" in Admin?

. I think there is a contri available for calculating the exchange rate with a cron job in Admin, right?

. Would it be possible to show customers also Dollar prices, by klicking the Dollar currency box, but they HAVE TO pay in Euros? I ask this because I would not like to get paid in Dollars because when I put Dollars onto my Euro account I'd have to pay exchange fees.

. Is "Google feeder" with the tax and currency conversion functions and handling correctly prices above 999 (there was once a bug) also available for my Oscommerce version which is from January 2003?

 

A lot of questions, but I am still in hope that there is someone who can help me.

 

Thanks in advance for your answer.

 

Albert

 

No answer at least to my fourth question?

 

Albert

Share this post


Link to post
Share on other sites

Would anyone know why only 1% of the time my data feed (set up through a cron job) will successfully send the file to froogle, while 99% of the time I receive a message saying "FTP upload has failed!"? Any ideas what would cause it to work and then not work, or how it can be resolved?

 

Thanks,

Paul

Edited by Paulie

Share this post


Link to post
Share on other sites

Hi I am attempting to install this contribution, I have sucessfully instaled several, and yet I am about to ask a very basic newbie question. Try not to fall off your chairs laughing. in the feed script very first Line it reads

$OutFile = "<route to your unix directory>/sweetdeal4u_biz.txt"

What do you mean by rout to unix directory? I have a rout to perl, I have a rout to send mail, I have a rout to many things, and yet I do not know what a route to unix is... I am feeling very stupid at this time, so please be gentle.

 

Thank you,

Figster :'(

Share this post


Link to post
Share on other sites
Hi I am attempting to install this contribution, I have sucessfully instaled several, and yet I am about to ask a very basic newbie question. Try not to fall off your chairs laughing. in the feed script very first Line it reads

$OutFile = "<route to your unix directory>/sweetdeal4u_biz.txt"

What do you mean by rout to unix directory? I have a rout to perl, I have a rout to send mail, I have a rout to many things, and yet I do not know what a route to unix is... I am feeling very stupid at this time, so please be gentle.

 

Thank you,

Figster  :'(

 

Would the path look like this?

home/sweetd73/public_html/catalog/feeds/sweetdeal4u_biz.txt

 

Thanks for your help in advance.

Share this post


Link to post
Share on other sites
Would the path look like this?

home/sweetd73/public_html/catalog/feeds/sweetdeal4u_biz.txt

 

Thanks for your help in advance.

Yes, that's correct. You'll want to start with a / though

 

By the way, I didn't laugh. Only giggled.

Just kidding.

Edited by chynathedragon

Stress is a luxury afforded to those of us that need it least.

Where lipstick is concerned, the important thing is not color, but to accept God's final word on where your lips end. --Jerry Seinfeld

If you pick up a starving dog, and make him prosperous, he will not bite you. This is the principal difference between a man and a dog. --Mark Twain

Share this post


Link to post
Share on other sites

I'm installing this script on an osc store for a client. Install went fine, except now when running the froogle.php file, it says the file is completed, but when I click on the link, I get a 403 Forbidden error. I've checked permissions on the server in the cPanel, as well as disabled hotlink protection, but still having this problem.

 

Additionally, when I manually download the outfile.txt, it is blank.

 

(By the way, I have this script installed on 3 other servers with no issues.)

 

Url to outfile is:

Froogle Outfile

 

/me calls..."CCCCCCalvinnnnnnn" :D

Edited by chynathedragon

Stress is a luxury afforded to those of us that need it least.

Where lipstick is concerned, the important thing is not color, but to accept God's final word on where your lips end. --Jerry Seinfeld

If you pick up a starving dog, and make him prosperous, he will not bite you. This is the principal difference between a man and a dog. --Mark Twain

Share this post


Link to post
Share on other sites
Yes, that's correct.  You'll want to start with a / though

 

By the way, I didn't laugh.  Only giggled.

Just kidding.

 

Ok, thank you... now I know what it is. A wise man once said there are no stupid questions... Only stupid people....

 

:rolleyes:

Share this post


Link to post
Share on other sites

Hello, thanks for the contribution. I think that I am very, very close to getting it working. I have followed the instructions and uploaded froogle.php, created a data feed, uploaded the feed to froogle. However...

I have 630 products, and the feed created 610 of them correctly. (Froogle page says its a bad data feed because of 20 errors) 20 of the products, for some reason, are missing the product name and product description.

 

Since it was only 20 products I figured brute force and ignorance can solve the problem, just delete the bad 20 and re-enter them. I tried this with 2 products, but the datafeed is not updating for the new products. I tried fixing the bad products, deleting and re-entering the bad products, then just enterting a totally new test product not associated at all with any of the bad products. The data feed does not reflect any changes, or new products. I can delete products, but not change existing products or add ones.

 

I am not sure what to try, since it works (worked) for 610 of 630 products I am doing something correct, but possibly missing something. Any help would be appreciated. I can post any code anyone wants to look at, I triple checked it, so I think it is correct. I am one small step above a newbie, just a cut and paster in regards to code, so I can screw up code a whole lot easier than I can fix it. I have modified the OS Commerce, the only contribution that I can think of that would affect this is that I have small product images in the 'regular' images folder in OSCommerce, and I put larger images into a folder called large. It is not really a contribution, it is a line or two of code added so some file (I can't remember which file.)

 

Any help would be greatly appreciated.

Share this post


Link to post
Share on other sites
Ok, thank you... now I know what it is.  A wise man once said there are no stupid questions... Only stupid people....

 

:rolleyes:

 

Usually those people drive slow in the passing lane...

 

Actually, I think the quote goes, There are no stupid questions except the ones never asked.

Edited by chynathedragon

Stress is a luxury afforded to those of us that need it least.

Where lipstick is concerned, the important thing is not color, but to accept God's final word on where your lips end. --Jerry Seinfeld

If you pick up a starving dog, and make him prosperous, he will not bite you. This is the principal difference between a man and a dog. --Mark Twain

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

×