Just thought I'd share this... but we were looking for a way to edit coupons (mass edit) to require a minimum for the coupons to be used (we have over 100 coupons active in our store)... so we logged into to phpMyAdmin (our database) and pasted the following code in the SQL field (obviously make sure to change the tablename and tablefield to match your db):
Code:
UPDATE tablename SET tablefield = replace(tablefield, "findstring", "replacestring");
In our case the code basically searches the xcart_discount_coupons table for a value of 0.00 in the minimum field and replaces it with 72.50 (our minimum order value for any coupons to be applied) so our code looked as such:
Code:
UPDATE xcart_discount_coupons SET minimum= replace(minimum, "0.00", "72.50");
PLEASE MAKE SURE TO BACKUP YOUR DB before making any changes!
Hope this helps!