Index: openacs-4/packages/ecommerce/www/admin/products/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/index.adp,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/admin/products/index.adp	14 Aug 2008 09:57:36 -0000	1.3
+++ openacs-4/packages/ecommerce/www/admin/products/index.adp	18 Feb 2009 10:20:34 -0000	1.4
@@ -2,35 +2,41 @@
   <property name="doc(title)">@title;noquote@</property>
   <property name="context">@context;noquote@</property>
 <h2>@title@</h2>
+
+<if @repeat_sku_warn@ true>
+<p>Warning: More than one product has been assigned to the following skus.  Some bulk actions may not work as expected.</p>
+<p> @repeat_skus;noquote@</p>
+</if>
+
 <ul>
 
 <li>@n_products@ products 
 (<a href="list">All</a> | 
 <a href="by-category">By Category</a> |
 <a href="add">Add</a>)
+</li>
+<li>
 
-<p>
+<li><a href="recommendations">Recommendations</a></li>
+<li><a href="../cat/">Categorization</a></li>
+<li><a href="custom-fields">Custom Fields</a></li>
+<li><a href="upload-utilities">Bulk upload products</a></li>
 
-<li><a href="recommendations">Recommendations</a>
-<li><a href="../cat/">Categorization</a>
-<li><a href="custom-fields">Custom Fields</a>
-<li><a href="upload-utilities">Bulk upload products</a>
 
-<p>
 
 <form method=post action=search>
-<li>Search by Name: <input type=text name=product_name size=20>
-<input type=submit value="Search">
+<li>Search by Name: <input type=text name=product_name size=40>
+<input type=submit value="Search"></li>
 </form>
+<br>
 
-<p>
 
 <form method=post action=search>
-<li>Search by SKU: <input type=text name=sku size=3>
-<input type=submit value="Search">
+<li>Search by SKU: <input type=text name=sku size=90>
+<input type=submit value="Search"></li>
 </form>
+<br>
 
-<p>
 
-<li><a href="@audit_html;noquote@">Audit all Products</a>
+<li><a href="@audit_html;noquote@">Audit all Products</a></li>
 </ul>
Index: openacs-4/packages/ecommerce/www/admin/products/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/index.tcl,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/ecommerce/www/admin/products/index.tcl	14 Aug 2008 09:57:36 -0000	1.7
+++ openacs-4/packages/ecommerce/www/admin/products/index.tcl	18 Feb 2009 10:20:34 -0000	1.8
@@ -21,3 +21,10 @@
 
 db_1row products_select "select count(*) as n_products, round(avg(price),2) as avg_price from ec_products_displayable"
 
+set repeat_skus [db_list possible_sku_ref_issues "select sku from ec_products where active_p = 't'  group by sku having count(sku) > 1"]
+if { [llength $repeat_skus] > 0 } {
+    set repeat_sku_warn 1
+} else {
+    set repeat_sku_warn 0
+}
+