The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.
|
 |
|
Dev Shed Forums
> Programming Languages
> PHP Development
|
Managing Credits In Different Currencies
Discuss Managing Credits In Different Currencies in the PHP Development forum on Dev Shed. Managing Credits In Different Currencies PHP Development forum discussing coding practices, tips on PHP, and other PHP-related topics. PHP is an open source scripting language that has taken the web development industry by storm.
|
|
 |
|
|
|
|

Dev Shed Forums Sponsor:
|
|
|

October 16th, 2012, 10:52 AM
|
|
Contributing User
|
|
Join Date: Sep 2011
Posts: 189
Time spent in forums: 15 h 55 m 34 sec
Reputation Power: 2
|
|
|
Managing Credits In Different Currencies
Hi, my site allows users (buyers) to buy e-learning courses for other users (receivers).
The courses are different prices and are in a mix of different currencies such as USD, EUR, AUD and users pay for them with paypal.
If the receiver does not start the course within 28 days the the buyer gets a refund back but paypal does not like issuing all of these refunds, so i am thinking of changing my system to a credit system instead of a refund.
For example, if the buyer buys a $10 course and it is not started, the buyers site account is credited $10.
My worry is, how can i manage the currency conversion etc. As the site takes the initial payment of $10, then credits the buyers site account with $10, but what if the buyer then wants to buy a €7 course for another user and that gets refunded and so on and so on... how can i manage the currencies and credits as exchange rates need to be managed but a user is only paying with credits the second time around... thanks in advance for your help.
|

October 16th, 2012, 10:59 AM
|
 |
Confused badger
|
|
Join Date: Mar 2009
Location: West Yorkshire
|
|
|
Take payment when they take the course (not when they sign up for it), that way, there's no credit system to worry about.
__________________
The number for UK Emergencies is changing, the new number is 0118 999 881 999 119 7253
"For if leisure and security were enjoyed by all alike, the great mass of human beings who are normally stupefied by poverty would become literate and would learn to think for themselves; and when once they had done this, they would sooner or later realise that the privileged minority had no function and they would sweep it away"
- George Orwell, 1984
|

October 16th, 2012, 11:02 AM
|
|
Contributing User
|
|
Join Date: Sep 2011
Posts: 189
Time spent in forums: 15 h 55 m 34 sec
Reputation Power: 2
|
|
|
Thanks for your reply, however authorised payments won't work as they need to be taken from the account within 28 days and my timeframe goes to 60 days
|

October 16th, 2012, 11:53 AM
|
 |
Sarcky
|
|
Join Date: Oct 2006
Location: Pennsylvania, USA
|
|
|
Stop giving the refunds, make the purchases never expire. That way, again, it's not credit-based.
You're basically saying "they buy a product, and if they don't use it within 28 days, I want them to get a coupon to use it whenever they want."
Just let the courses never expire.
__________________
HEY! YOU! Read the New User Guide and Forum Rules
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin
"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002
Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.
|

October 16th, 2012, 02:15 PM
|
|
Contributing User
|
|
Join Date: Sep 2011
Posts: 189
Time spent in forums: 15 h 55 m 34 sec
Reputation Power: 2
|
|
|
Sorry, the idea of the site is that if the course i not started within 28 days, the buyer gets their money back
|

October 16th, 2012, 02:26 PM
|
 |
Sarcky
|
|
Join Date: Oct 2006
Location: Pennsylvania, USA
|
|
|
Then do that. You can't give someone their money back after 28 days and also not give them their money back. This is not a code question, it's a logic question.
If I'm selling tickets to enter a park, and the tickets expire after 4 weeks, how can I convert those tickets into vouchers for tickets which never expire while still refunding people's money?
The answer to that is "those things are mutually exclusive, also, don't bother with vouchers, just make the tickets not expire."
Edit: You need to decide what will happen. Either a refund, a voucher, or simply never expiring the gift.
Refund: Do the refund, done. This is not what you want, it seems.
Voucher: Give them a voucher in "points" if you want, and give your classes a price in "points" as well as real currency. Or just give them a voucher in their original currency and pull from a currency conversion service when they try to redeem a voucher. Or only let them redeem in their original currency, so you avoid the conversion problem.
Not expiring: Not sure why this just isn't the solution. They buy something, they can use it forever. If you cancel the thing they bought before they use it, give a refund. They'll be far more rare.
Last edited by ManiacDan : October 16th, 2012 at 02:32 PM.
|

October 16th, 2012, 02:31 PM
|
 |
Still alive
|
|
Join Date: Mar 2007
Location: Washington, USA
|
|
|
The money is for an individual course, right? Not like a pool of money that gets spent on whatever?
When the buyer purchases the course, the receiver gets to use the course. Record a relationship between this "gets to use" and "purchases the course" but don't make one rely on the other. So then you can refund the purchase but the receiver still gets the course.
Or are we just not understanding what you're asking about?
|

October 16th, 2012, 03:11 PM
|
|
Contributing User
|
|
Join Date: Sep 2011
Posts: 189
Time spent in forums: 15 h 55 m 34 sec
Reputation Power: 2
|
|
|
thanks for the replies guys, however the idea of the site is that the buyer gets their money back, so i need to have it like this (this cannot be changed as it is one of the key ideas of the site (there is a bit more to it)
refunds: there will be a high rate of refunds per courses and paypal HATE this
credits: i think the best way to handle this is to have a different credit wallet for each of the 4 currencies that the site supports
|

October 16th, 2012, 03:23 PM
|
 |
Still alive
|
|
Join Date: Mar 2007
Location: Washington, USA
|
|
Quote: | Originally Posted by oo7ml refunds: there will be a high rate of refunds per courses and paypal HATE this |
What the heck kind of product are you selling where you'll be issuing so many refunds? How does this make any kind of business sense?
Last edited by requinix : October 16th, 2012 at 03:25 PM.
|

October 16th, 2012, 03:28 PM
|
 |
Sarcky
|
|
Join Date: Oct 2006
Location: Pennsylvania, USA
|
|
|
Yeah I'm not sure how giving people their money back is a key feature of your business.
Maybe stop using paypal? Or start mailing them checks?
|

October 16th, 2012, 04:52 PM
|
|
|
|
There will be a high rate of refunds and you don't want to issue many refunds? Have you thought this through?
Why have multiple currencies in the first place? Sure show them that $10.00 is about £6.20 but charge them $10.00. Then you can refund them $10.00 or put $10.00 in their credit account.
|

October 16th, 2012, 06:21 PM
|
 |
Lost in code
|
|
|
|
As you've probably figured out, what you're asking doesn't have a straight forward solution.
Financial companies don't like processing refunds for the simple reason that they end up eating the processing costs of both the original payment and the refund (neither of which are free for them). The margins for a payment processor are not big, so if you end up generating too many refunds relative to the number of non-refund payments they will take a loss on your account and just drop you because it makes no financial sense to keep you as a customer if you're losing them money.
Currency conversion is also a difficult topic given that exchange rates are literally constantly changing. You want to avoid as much currency conversion as you possibly can.
Quote: | As the site takes the initial payment of $10, then credits the buyers site account with $10, but what if the buyer then wants to buy a €7 course for another user. |
So my question is: why would a buyer buy one course in dollars and another course in euros? Do you have some courses that are priced only in euros and others that are priced only in dollars?
Buyers generally do not frequently change currencies. (As a US citizen,) if I have a choice between paying in euros and paying in dollars, why would I choose to pay in euros?
Assuming you offer all of your courses in all currencies, have the buyer choose a currency when they sign up and don't allow them to change it. Everything they buy will be in that currency, all of their credits will be in that currency. That keeps it simple: No refunds, no currency conversion.
|
Developer Shed Advertisers and Affiliates
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate This Thread |
Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|