[Joe Schwartz]

minorgod,

Thanks so much. You were right on the money that the SQL values were not properly defined. I went into config.php and added:

	"product_options" => "xcart_product_options_ex",
	"product_options_js" => "xcart_product_options_js",

to the SQL Table aliases (there is also "xcart_product_options_lng" which I have not figured out yet how it works with "xcart_product_options_ex").

I noticed that in the SQL table for xcart_product_options_ex there was no productid field and that now it was called optionid. As such I edited your mod in products.php to reflect this:

  $query="SELECT * from $sql_tbl[product_options] WHERE "; 
   foreach($products as $key=>$value){ 
         $query.="optionid='$value[productid]' "; 
         if($i < $productcount-1){ 
            $query.="OR "; 
         } 
         $i++; 
   } 

This removed the SQL errors, however the products.tpl does not display the product options. In fact, the product pages display as if no changes have been made. Obviously I am missing something (not surprising as I feel I am in over my head with this mod). Any suggestions on where to look next would be most appreciated.

Joe