We help IT Professionals succeed at work.

Need recommendations on e-commerce solution.

saabStory
saabStory asked
on
442 Views
Last Modified: 2012-05-11
I need some help with an e-commerce problem we're having on our site and need recommendations for a solution.  Right now, we're using PayPal for everything (event registrations, online donations, etc) but it has the disadvantage that we have to commit our orders to a database before knowing if the person has actually paid.  While we manually reconcile all orders against our PayPal reports, this still doesn't prevent a person registering for a luncheon event and not following through with a payment.  Ultimately such things are caught but we want to move to a solution where we know that every order and registration has been paid.

So, in an ideal world, we're looking for a solution that:
1. We can integrate seamlessly into our current website.
2. Takes the order for whatever product and processes it from cart to final confirmation without leaving (or appearing to leave) our website.
3. Provides reporting capabilities to various groups about their events.
4. Has a low up front cost with a low per transaction cost (we're a non-profit)
5. Must work in an Microsoft shop.  I might be able to get away with MySQL but MSSQL is an easier sell for my bosses.
6. Is preferably PHP based.

MS compatibility is a must and end-to-end processing on our site is a close second.  Many thanks in advance.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
You can a column with payment state to your database, where it is set to "pending" or "waiting approval" when customer places order, and when paypal payment is received then set payment state to "payed" or something like that!

Now if paypal confirmation is reaching you automatically you can embed the approval with your database, or alternatively you can ask your customer to submit confirmation number to your form when he is done with paypal.

Example:
Dear customer please note that you r leaving our site now to pay with paypal, please remember to copy your payment approval number(or whatever they call it on paypal) because we will need it to carry on with your purchase ..meantime status of your payment is now on "waiting approval"

Maybe this is not the smartest thing but I think it's applicable.
Top Expert 2010
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.