Index: openacs-4/packages/ecommerce/www/admin/orders/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/index.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/index.tcl	20 Apr 2001 20:51:14 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/index.tcl	29 Jan 2002 00:11:46 -0000	1.2
@@ -60,8 +60,8 @@
 from ec_refunds
 "
 
-set n_standard_to_ship [db_string unused "select count(*) from ec_orders_shippable where shipping_method='standard'"]
-set n_express_to_ship [db_string unused "select count(*) from ec_orders_shippable where shipping_method='express'"]
+set n_standard_to_ship [db_string standard_shipping "select count(*) from ec_orders_shippable where shipping_method='standard'"]
+set n_express_to_ship [db_string express_shipping "select count(*) from ec_orders_shippable where shipping_method='express'"]
 
 doc_body_append "
 <li><a href=\"by-order-state-and-time\">Orders</a> <font size=-1>($n_o_in_last_24_hours in last 24 hours; $n_o_in_last_7_days in last 7 days)</font>
@@ -86,6 +86,10 @@
 </form>
 
 <form method=post action=search>
+By Product SKU: <input type=text name=product_sku_query_string size=10>
+</form>
+
+<form method=post action=search>
 By Product Name: <input type=text name=product_name_query_string size=10>
 </form>