Mass edit of coupons

I imported a database of pre-arranged discount coupons.

Now, the client would like to have those coupons limited to one individual category of products.

Is there an easy way to mass edit each of these coupons?

There are about 8,000...

Discount Coupons have Restrictions for Categories and Products ...

Set the Restriction for what Category you want to allow Discount on ... this is done by picking the Catagory from the dropdown and setting to Allow in the other dropdown and click Add ...

Depending on some combinations of Restrictions ... you many need to add the Top Category to Deny ... then add the remaining restrictions ...

Always test a Discount Coupon before releasing it for use ...

Once you see the settings for 1 coupon setup properly for this, looking in the tables:
coupons
coupon_restrict

You can update the fields ...

Example: 10% OFF all products for DVD ... ACTION Category only ... where categories_id = 10

coupons table:

coupon_id  	 coupon_type  	 coupon_code  	 coupon_amount  	 coupon_minimum_order  	 coupon_start_date  	 coupon_expire_date  	 uses_per_coupon  	 uses_per_user  	 restrict_to_products  	 restrict_to_categories  	 restrict_to_customers  	 coupon_active  	 date_created  	 date_modified  	 coupon_zone_restriction
1 	P 	DVD10OFFACTION 	10.0000 	0.0000 	2006-10-20 00:00:00 	2007-10-20 00:00:00 	0 	0 	  	  	NULL 	Y 	2006-10-20 13:17:58 	2006-10-20 13:17:58 	0

coupon_restrictions table:

restrict_id  	 coupon_id  	 product_id  	 category_id  	 coupon_restrict
1 	1 	0 	10 	N

Thanks...do you know an easy way of updating each coupon all at once?

I know that I can back up the database and edit it in excel/access...then reload, but I'm afraid I'd have problems.

Is there a way to use phpmyadmin to update mass records all at once?

If all coupons are for 1 categories_id then you need to build a restriction for each coupon for that specific categories_id ...

This can be done either with an import or via phpMyAdmin but I'd need to see what it is you really have set up so far with the 8000 coupons ...

Be sure before attempting anything that you have good backups of your database ...