If a coupon is used on an order, and an admin removes the coupon from the order by editing the order items, the coupon is still recorded as used in the ac_OrderCoupons table. Therefore, the usage count reflects the order from which the coupon was removed. The ac_OrderItems row is removed correctly, but the ac_OrderCoupons row is left behind.
Has anyone else ran into this? Has this been reported? I cannot find a similar thread.
At the least, it seems that these ac_OrderCoupons rows should be deleted when the corresponding ac_orderitems row is deleted.
Thanks,
Brian
Coupon Usage Bug?
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Coupon Usage Bug?
I have not seen it but I haven't deleted a coupon from an order. It would seem to me that the entry in the order coupon table should be deleted also.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx