#Nik
keen helm
Hi @hearty dune Can you help me with my query? Or do you need more information?
hearty dune
Can you screenshot what you see and provide the Invoice Id here? in_xxx
keen helm
This is what I see when I'm trying to upgrade a subscription. Initially its 1 quantity purchased yesterday with 35% off coupon
hearty dune
Ah okie that's proration
You would want to understand how proration works, and find the option to turn it off if you don't want it
keen helm
Yes its a proration and I dont want to turn it off as I need to charge customers when they upgrades and not on the next invoice. I want to understand how and why amount due is more than what it should be even if its a proration.
hearty dune
Scroll down on the left you will see "Proration behavior". Turn it off to view the changes
I see. So in which item of the Proration you think it's unexpected?
The Remaning time or the Unused?
keen helm
As the original Plan cost is 499 and previously customer applied a coupon of 35%. If they wants to upgrade their subscription why do they have to pay more than 499 even if its a proration? No customer would like to pay more than the Plan cost
hearty dune
Do you know what is Remaining time ($977) and what is Unused (-$317)?
Remaining time = what your customer suppose to pay for quantity = 2, approx $499 x 2 (no coupon applied)
Unused = what your customer will get back for not using your service in quantity = 1, is $499 applied coupon = 317
So upgrading here will revoke the Coupon usage
keen helm
So, with that keeping in mind, I dont want to charge customer more than the original plan cost which is 499. Is there a way to fix this in Stripe?
hearty dune
I think you can try to apply to coupon again on the update request
keen helm
I tried with that. If I apply 35% discuount again then amount due is showing around $324 but I dont want to give another discount to customers. so, they should be charged purely based on the proration based on the the plan amount $499.
This is just a simple scenario I mentioned I have more scenarios with multiple plan purchase in single subscription but first I wanted to understand with the simple one if there is any way with Stripe to keep the upgrade amount as per proration based on the plan amount.
hearty dune
Not sure if I understand correctly, but what exactly do you want the Proration look like? Please list down the Remaining item and the Unused item you envision
keen helm
So, initially the plan amount is 499. then aon the 2nd day If customer wants to upgrade their quantity then it proration amount would be like 488.35.
See here in the remaining item If I divide 976.70/2 its 488.35. So, I would like to charge this amount
hearty dune
Then it will be 488.35 - 317.43 ?
That's changing from quantity 1 with coupon to quantity 1 without coupon
Doing the math here, when you make your customer having quantity 2 in the second day, you suppose to charge them 976 because that's the quantity = 2 amount, then subtract 317 because that's the amount they already paid
keen helm
I think you misunderstood it becasue I said "I would like to charge this amount" and then I posted the screenshot .The amount should be 488.35 as I mentioned above, as for 1 quantity customer already charged. now they only need to pay for the 2nd quantity. And as I said earlier customer shouldn't pay more than the plan amount so the proration amount as shown in invoice 976.70 - 317.43 wouldn't work as its more than original plan cost 499.
hearty dune
I totally get your point, but proration doesn't work like that. It calculates based on what is remaining and what is unused. To achieve what you are looking for, the closest solution is to also apply a same coupon to this upgrade, so it would be approx (499 + 499 * 65%) - 317
keen helm
If I do this 499 + 499 * 35% - 317 = 212. which is far from close.
Another solution I tried is applying a coupon of amount received from the first purchase discount which is 174.65. If you see after applying this coupon amount due is same as what should be charged for proration amount for 2nd quantity. but as I mentioned that I have other scenarios with multiple plan purchase its not working properly.
Let me explain to you in the next comment about the other scenario I have
hearty dune
No it's 499 + 499 * (100%-35%) -317 (approx)
yeah that screenshot looks better
I see, the caveat here is you can't apply the same -35%, on 1 quantity out of 2 quantities in the first line, correct?
finite snowBOT
keen helm
Other use case is as shown in the first screenshot (1.png) user purchased these plans inititally. 1 * 499, 1 * 1695 and 1 * 995 (in_1O8KpgHpCCuanh4q20hOzhyu). I applied discount of $522.90.
Now user wants to make Silver Plan 499 quantity to 2. See how it looks in 2nd screenshot (2.png)
amount due is showing $872.22 which way more than what actual amount should be. If I calculate proration ($872.22 / 2) it should be 436.11.
If I apply the coupon of same amount which customer got for the initital purchase then also in this. case its not showing proper amount due see screenshot 3.png. Its showing $415.48 which less then what it should be.
subtle glade
Hi @keen helm I'm taking over this thread
keen helm
Sure @subtle glade
subtle glade
It's a long thread, can you give me a summary and tell me what you want to achieve?
keen helm
I have an issue with subscription upgrades invoice amount.
When a customer purchased a Plan with discount and within first billing period if they try to upgrade.
Plese check this from this #1171282821231431720 message
Let me know if you understand the issue or I need to explain more
subtle glade
What do you expect vs what you got?
keen helm
I expect proration amount should be less than or at max equal to the actual plan amount and not more than that If you see this message I explained what I got and what I expected.
subtle glade
It really depends on how you update the subscription, do you have the ID of the request where you update subscription or preview the upcoming invoice?
keen helm
@subtle glade I have added all information here in this message #1171282821231431720 message
Attached 3 screenshots too
subtle glade
Can you share with me your merchant ID? you can find it from the Stripe Dashboard -> Settings ->Account Details.
I am asking because I need to see the request to know exactly what param you set in the request.
keen helm
Okay here it is acct_1Bda1BHpCCuanh4q
subtle glade
https://dashboard.stripe.com/test/logs/req_5qyIkW8GOCqJcT is this the request?
keen helm
It will not show as I just tried to preview here https://dashboard.stripe.com/test/customers/cus_OwDF46Gc1YcHEt?edit=sub_1O8KpgHpCCuanh4qVdt97f85
subtle glade
Ok, I found the preivew.
What made you think ($872.22 / 2) is the correct proration amount?
keen helm
For my case Customer should not be charged more than the actual plan amount. I get it how stripe managing it. but $872.22 / 2) is the correct amount I want to charge my customer. It doesn't make sense to charge 872.22 if customer wants to add additional quantity to existing 1 quantity. Why should customer pay for 2 quantites as he already paid for 1
subtle glade
Ok, I believe it's to do with the initial discount that you applied when creating the subscription. Discount + proration is complicated and I will need more time to look into it. ˜s
This is going to require a bit more investigation. Sorry to redirect you, but can you write in to https://support.stripe.com/contact/email with the information that you provided. We'll respond via email/ticket after looking into it further.