Check or Reset Coupon Usage


How do I reset or check the usage of a one-use coupon?


In the "Smith_StoreOrders" table there is a field titled "CouponID" where the coupon that is entered by the user is saved after successful checkout. The cart keeps track of coupon usage by aggregating the total number times the coupon id is found in the Smith_StoreOrders table.

To check the current number of times a coupon has been used you can issue the following sql stmt from SSMS:

Select count(*) from smith_storeorders where couponid = '1234'

Where '1234' is your coupon id you want to check.

To reset coupon usage you will need to delete the CouponID in the Smith_StoreOrders table

Add Feedback