Index: openacs-4/packages/ecommerce/www/admin/orders/fulfillment-items-needed.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/fulfillment-items-needed.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/fulfillment-items-needed.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/fulfillment-items-needed.xql	29 Jan 2002 00:11:46 -0000	1.2
@@ -4,12 +4,12 @@
 <fullquery name="items_needed_select">      
       <querytext>
       
-    select p.product_id, p.product_name,
+    select p.product_id, p.product_name, p.sku, 
            i.color_choice, i.size_choice, i.style_choice,
            count(*) as quantity
       from ec_products p, ec_items_shippable i
      where p.product_id=i.product_id
-  group by p.product_id, p.product_name,
+  group by p.product_id, p.product_name, p.sku, 
            i.color_choice, i.size_choice, i.style_choice
   order by quantity desc