Need recommendations on e-commerce solution.

Posted on 2011-04-20
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.
Question by:saabStory
    LVL 10

    Expert Comment

    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.

    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.
    LVL 22

    Accepted Solution

    You can use cyberSource as payment service provider. It has various options for authenticating and charging the customer.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    The aim of this article is to help you solve the error "Cannot insert the value NULL into column 'ShortDescription', table 'albert_store.dbo.Nop_Product'; column does not allow nulls. UPDATE fails." problem and allow you to continue updating your No…
    Read about how to choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now