Jump to content

abuata

Members
  • Content count

    26
  • Joined

  • Last visited

Profile Information

  • Real Name
    carla abuata
  1. the froogle_feed_file.txt is generating the link for froogle feed as: http://www.lil-raskals.com/product_info ... cts_id=208 <---does not work The url for the product is: http://www.lil-raskals.com/catalog/prod ... cts_id/208 <---does work does this for every item. How do I change the path for this to point to the right location? ALSO.... when I run the feed in admin everything works, so it says, and it uploads to google base. when I goto my google/froogle account it never shows up. I had to manually take the .txt file that was generated and upload it through the froogle website. I did not think I should have to do this with this contrib. Does anyone else have this problem. Thanks
  2. Never mind, I figured it out.. "feeds" directory was "Feeds" fixed that, it works. BUT I have another problem... Ok, the froogle_feed_file.txt is generating the link for froogle feed as: http://www.lil-raskals.com/product_info ... cts_id=208 <---does not work The url for the product is: http://www.lil-raskals.com/catalog/prod ... cts_id/208 <---does work does this for every item. How do I change the path for this to point to the right location? ALSO.... when I run the feed in admin everything works, so it says, and it uploads to google base. when I goto my google/froogle account it never shows up. I had to manually take the .txt file that was generated and upload it through the froogle website. I did not think I should have to do this with this contrib. Does anyone else have this problem. Thanks
  3. Yes I did, I figured it out.... feeds folder was Feeds, I had it capitalized.
  4. here is what I get when I run the feed: Warning: fopen(/hsphere/local/home/abuata/lil-raskals.com/feeds/lil_raskals_com.txt): failed to open stream: No such file or directory in /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/froogle.php on line 305 Warning: fwrite(): supplied argument is not a valid stream resource in /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/froogle.php on line 306 Warning: fclose(): supplied argument is not a valid stream resource in /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/froogle.php on line 307 File completed: Warning: chmod(): No such file or directory in /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/froogle.php on line 309 Connected to uploads.google.com, for user abuata uploads.google.com: FTP upload has failed! Script timer: 4.282747 seconds. Here is a copy of file lil-raskals.com/catalog/admin/froogle.php : <php>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(">" => "> ", "?" => "", "." => "", "?" => "", "" => "", "\t" => "", " " => ""); 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: " . $destination_file . "<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>'; printf( "Script timer: <b>%f</b> seconds.", ($etimer-$stimer) ); echo '</p>'; // --------- ?> What the heck am I doing wrong????
  5. abuata

    Held Orders v2.0 MS2 ready

    Oh Ghee, found it, I had an extra one of these ?> at the end of the last line. Thanks
  6. abuata

    Held Orders v2.0 MS2 ready

    Hi, I get same message, but this fix did not fix. Is there any other fixes for this or could there be a conflict with another contribution? I installed on a test site and was fine, but it is a stock OSC. Thanks for some help anybody..............Please ?> Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/includes/filenames.php:62) in /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/includes/functions/sessions.php on line 67 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/includes/filenames.php:62) in /hsphere/local/home/abuata/lil-raskals.com/catalog/admin/includes/functions/sessions.php on line 67
  7. abuata

    Dropshipping

    Does anyone have a comment? Is there any dropshippers out there?
  8. abuata

    Dropshipping

    WOW guys, this is interesting. :'( You both bring up good points here. Fact is I just sell little simple wooden toys to "Mommies". Majority of my products I own in a facility. I just want to add products and broaden my selection by dropping from some elses warehouse. My problem is that I use Fedex live calculated shipping mod that has been great for me, but now that I'll be shipping from somewhere else that wont work for me. I thought there was a module or a way to mark these items to ship another way (from another zip code) with out having to undo every thing else I've put together. I looked at the multple vendor mod, but unsure that this is the answer. I suppose I could use the per item shipping and just change everything. Just didn't really want to do that. But Yes the problem is calculating the shipping. I would love for all the readers that do dropshipping to *please* join this post and give me ideas. I am new to OSC and learning all I can everyday. Thanks guys, Carla :thumbsup:
  9. abuata

    Dropshipping

    I need help on setting up dropshipping. My store currently has items that ship from my location, Georgia. I am adding items that will be dropshiped from California. I currently use the fedex shipping for my shipping. How would I set this up? Thanks
  10. Hi, I just installed this module. I am having a bit of a problem if someone could help please. I followed all steps closely, when I did step 2 Install database settings, Instead of getting a confirmation that is was sucessfull, I got a message about cookies were not enabled on browser, So I reset my browser to enable cookies and proceeded on to next steps and completed install and file modifications. Now my site has this message: 1146 - Table 'abuata_wholesale.cache' doesn't exist DELETE FROM cache WHERE cache_expires <= '2005-02-06 11:10:12' [TEP STOP] I don't know what I did wrong here this seemed to be a pretty easy module compared to some others I done. I was nervous at STEP 8 .htaccess part, but what I did was option 8 (1b) my .htaccess file is in /catalog/ folder. This part is very confusing to me. Please help for my site is down and I am new at OSC Thanks www.wholesalewoodentoys.com Carla
  11. Hi, I just installed this module. I am having a bit of a problem if someone could help please. I followed all steps closely, when I did step 2 Install database settings, Instead of getting a confirmation that is was sucessfull, I got a message about cookies were not enabled on browser, So I reset my browser to enable cookies and proceeded on to next steps and completed install and file modifications. Now my site has this message: 1146 - Table 'abuata_wholesale.cache' doesn't exist DELETE FROM cache WHERE cache_expires <= '2005-02-06 11:10:12' [TEP STOP] I don't know what I did wrong here this seemed to be a pretty easy module compared to some others I done. I was nervous at STEP 8 .htaccess part, but what I did was option 8 (1b) my .htaccess file is in /catalog/ folder. This part is very confusing to me. Please help for my site is down and I am new at OSC Thanks www.wholesalewoodentoys.com Carla
  12. abuata

    links manager v1.01

    Thanks for looking here is database.php file: <?php /* $Id: database.php,v 1.21 2003/06/09 21:21:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') { global $$link; if (USE_PCONNECT == 'true') { $$link = mysql_pconnect($server, $username, $password); } else { $$link = mysql_connect($server, $username, $password); } if ($$link) mysql_select_db($database); return $$link; } function tep_db_close($link = 'db_link') { global $$link; return mysql_close($$link); } function tep_db_error($query, $errno, $error) { die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>'); } function tep_db_query($query, $link = 'db_link') { global $$link; if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error()); if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { $result_error = mysql_error(); error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } return $result; } function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') { reset($data); if ($action == 'insert') { $query = 'insert into ' . $table . ' ('; while (list($columns, ) = each($data)) { $query .= $columns . ', '; } $query = substr($query, 0, -2) . ') values ('; reset($data); while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= 'now(), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { case 'now()': $query .= $columns . ' = now(), '; break; case 'null': $query .= $columns .= ' = null, '; break; default: $query .= $columns . ' = \'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ' where ' . $parameters; } return tep_db_query($query, $link); } function tep_db_fetch_array($db_query) { return mysql_fetch_array($db_query, MYSQL_ASSOC); } function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); } function tep_db_data_seek($db_query, $row_number) { return mysql_data_seek($db_query, $row_number); } function tep_db_insert_id() { return mysql_insert_id(); } function tep_db_free_result($db_query) { return mysql_free_result($db_query); } function tep_db_fetch_fields($db_query) { return mysql_fetch_field($db_query); } function tep_db_output($string) { return htmlspecialchars($string); } function tep_db_input($string) { return addslashes($string); } function tep_db_prepare_input($string) { if (is_string($string)) { return trim(tep_sanitize_string(stripslashes($string))); } elseif (is_array($string)) { reset($string); while (list($key, $value) = each($string)) { $string[$key] = tep_db_prepare_input($value); } return $string; } else { return $string; } } ?>
  13. abuata

    links manager v1.01

    Is there anyone there that can help me with this? I installed links manager version 1.01 and having problems. PLEEEEEEEEZE
×