[adpboss]

Works like a dream, here is the code I had to make a couple more changes.

Updates based on ProductID.
CSV file columns are ProductID, Price, Quantity.

Working in V 3.4.9

<? 
/*****************************************************************************\ 
+-----------------------------------------------------------------------------+ 
| X-Cart                                                                      | 
| Copyright (c) 2001-2003 Ruslan R. Fazliev <rrf@rrf.ru>                      | 
| All rights reserved.                                                        | 
+-----------------------------------------------------------------------------+ 
| PLEASE READ  THE FULL TEXT OF SOFTWARE LICENSE AGREEMENT IN THE "COPYRIGHT" | 
| FILE PROVIDED WITH THIS DISTRIBUTION. THE AGREEMENT TEXT IS ALSO AVAILABLE  | 
| AT THE FOLLOWING URL: http://www.x-cart.com/license.php                     | 
|                                                                             | 
| THIS  AGREEMENT  EXPRESSES  THE  TERMS  AND CONDITIONS ON WHICH YOU MAY USE | 
| THIS SOFTWARE   PROGRAM   AND  ASSOCIATED  DOCUMENTATION   THAT  RUSLAN  R. | 
| FAZLIEV (hereinafter  referred to as "THE AUTHOR") IS FURNISHING  OR MAKING | 
| AVAILABLE TO YOU WITH  THIS  AGREEMENT  (COLLECTIVELY,  THE  "SOFTWARE").   | 
| PLEASE   REVIEW   THE  TERMS  AND   CONDITIONS  OF  THIS  LICENSE AGREEMENT | 
| CAREFULLY   BEFORE   INSTALLING   OR  USING  THE  SOFTWARE.  BY INSTALLING, | 
| COPYING   OR   OTHERWISE   USING   THE   SOFTWARE,  YOU  AND  YOUR  COMPANY | 
| (COLLECTIVELY,  "YOU")  ARE  ACCEPTING  AND AGREEING  TO  THE TERMS OF THIS | 
| LICENSE   AGREEMENT.   IF  YOU    ARE  NOT  WILLING   TO  BE  BOUND BY THIS | 
| AGREEMENT, DO  NOT INSTALL OR USE THE SOFTWARE.  VARIOUS   COPYRIGHTS   AND | 
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS | 
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE | 
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.| 
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      | 
|                                                                             | 
| The Initial Developer of the Original Code is Ruslan R. Fazliev             | 
| Portions created by Ruslan R. Fazliev are Copyright (C) 2001-2003           | 
| Ruslan R. Fazliev. All Rights Reserved.                                     | 
+-----------------------------------------------------------------------------+ 
\*****************************************************************************/ 

# 
# $Id: price_update.php,v 1 2003/09/10 ant Exp $ 
# 

@set_time_limit(1800); 

require "../smarty.php"; 
require "../config.php"; 
require "./auth.php"; 
require "../include/security.php"; 

if ($REQUEST_METHOD=="POST") { 

   $provider_condition=($single_mode?"":" AND $sql_tbl[products].provider='$login'"); 
    
   if($fp = @fopen($userfile,"r")) { 
      while ($columns = fgetcsv ($fp, 65536, $delimiter)) { 
         if ($columns[0]) { 
            if ($what == "p") { 
               $pid = func_query_first ("SELECT * FROM $sql_tbl[products] WHERE productid='$columns[0]' $provider_condition"); 

               $f = "SELECT count(*) FROM $sql_tbl[pricing] WHERE productid='$columns[0]' AND membership='$membership' AND quantity='$columns[2]'"; 
               echo $f."
"; 
               $tmp = array_pop(func_query_first($f)); 
               # $tmp = db_query ($f); 
               echo $tmp."
"; 
             
               if ($tmp != 0) 
               { 
               $f = "UPDATE $sql_tbl[pricing] SET price='$columns[1]' WHERE productid='$columns[0]' AND membership='$membership' AND quantity='$columns[2]'"; 
               echo $f."
"; 
               db_query ($f); 
               } 
               else 
               { 
               $f = "INSERT $sql_tbl[pricing] VALUES ('','$columns[0]','$columns[2]','$columns[1]','$membership')"; 
               echo $f."
"; 
               db_query ($f); 
               } 
            } 
         } 
      } 
      $smarty->assign("main", "price_updated"); 
   } else { 
      $smarty->assign("main", "error_inv_update"); 
   } 
} else { 
   $smarty->assign ("main", "price_update"); 
} 

require "../include/categories.php"; 

@include "../modules/gold_display.php"; 
$smarty->display("provider/home.tpl"); 
?> 

Thanks again Anton. Super MOD.