Coupon Code sometimes results in a negative credit balance

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Coupon Code sometimes results in a negative credit balance

Post by efficiondave » Wed Apr 17, 2013 10:41 am

We've had a Coupon Code in place for several years now and generally it works great. But sometimes, rather than decreasing the amount the user pays, we end up with a negative Credit Balance / Remaining Balance. Prior to this year, it only happened 4 times. But it's happening a lot more frequently since Feb. 1, 2013. Since then, out of 201 orders that used the coupon code, 38 have a Total Payments amount that is higher than the Total Charges resulting in a credit balance. So, it's only happening around 20% of the time.

I've tried to find a pattern in the orders with the problem vs. the order handled correctly and haven't had any luck yet.

Here's what the typical History and Notes page looks like for these orders:
2/4/2013 3:44:05 PM
system The order has been paid, a credit balance of -$5.00 remains.
2/4/2013 3:44:05 PM
system A payment capture for $57.00 has been received. No further captures possible.
2/4/2013 3:44:03 PM
system A payment authorization for $57.00 is being requested.
2/4/2013 3:43:48 PM
system The order has been submitted.

Has anyone else seen this? Any idea what might be causing it?

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: Coupon Code sometimes results in a negative credit balance

Post by efficiondave » Tue May 14, 2013 8:35 pm

This is still happening intermittently and I still haven't been able to find any pattern for when or why it occurs. Any ideas?

trozzi
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 104
Joined: Wed Oct 05, 2005 4:44 pm
Contact:

Re: Coupon Code sometimes results in a negative credit balance

Post by trozzi » Fri May 17, 2013 11:06 am

Are there multiple lines in the order when the credit balance exists?

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: Coupon Code sometimes results in a negative credit balance

Post by efficiondave » Fri May 17, 2013 1:24 pm

Not sure what you mean by "multiple lines in the order". Could you clarify?

trozzi
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 104
Joined: Wed Oct 05, 2005 4:44 pm
Contact:

Re: Coupon Code sometimes results in a negative credit balance

Post by trozzi » Fri May 17, 2013 2:07 pm

Are there multiple products in the basket when the coupon code is applied when you get the credit ?

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: Coupon Code sometimes results in a negative credit balance

Post by efficiondave » Fri May 17, 2013 2:15 pm

It happens for both single item orders and multiple item orders. I suppose I don't really know if the user added or removed items after setting the code. And that brings up the valid idea that perhaps the difference between it working correctly or not is, at what point the user enters the code. I'm going to test with those things in mind... Thanks!

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: Coupon Code sometimes results in a negative credit balance

Post by efficiondave » Fri May 17, 2013 2:31 pm

Found it! We've made substantial changes to the checkout workflow so I doubt this will affect others but here's the summary anyway...
We added a review page after the Payment page. Users can enter a PROMO code on either page. On the Review page, entering the Promo code would update the order total but would not affect the amount to be billed against the Credit Card.

Thanks to trozzi for the nudge in the right direction.

Post Reply