order history help

there is just one problem with my order history. the products get sent to the order history once checkout is submitted. even when they cancel the order on payment the product goes into the history when they havnt paid for the item.

what payment gateway are you using?

Most likely you are using a Remote checkout like paypal Payments standard.

With a remote checkout system, the order info needs to be stored in the database before the user is sent to the gateway site to process the transaction.

you should have a status column in your order table that uses the default value of pending.

depending on the payment gateway you are using, you may need to login to your account to view the status of the order, then update it is your data base manually.

or with paypal standard, you can set up an IPN script to update the status automatically for you.

see the following page for more details:
ipn

Originally Said By: Jason Byrnes

  what payment gateway are you using?

Most likely you are using a Remote checkout like paypal Payments standard.

With a remote checkout system, the order info needs to be stored in the database before the user is sent to the gateway site to process the transaction.

you should have a status column in your order table that uses the default value of pending.

depending on the payment gateway you are using, you may need to login to your account to view the status of the order, then update it is your data base manually.

or with paypal standard, you can set up an IPN script to update the status automatically for you.

see the following page for more details:
ipn  

im using paypal payment standard. would i have to set up IPN even though my order history was created with databridge? cos all is work except that one little problem in my first post. is there no way to stop products going into the order history untill the payment is confirmed? without having to manually update or using IPN? or no...

You would need to use the IPN Script to update the order status.

this is a limitation to the way PayPAl standard works.

paypal standard is not a real time payment gateway. When the user is passed over to paypal to set up the payment, the transaction is placed in a queue, then the user is passed back to your site.

the transaction may be processed in moments, or it may take days for it to get through the queue. Once it does get through the queue and the status is known, paypal uses IPN to post the result to your site.

Originally Said By: Jason Byrnes

  You would need to use the IPN Script to update the order status.

this is a limitation to the way PayPAl standard works.

paypal standard is not a real time payment gateway. When the user is passed over to paypal to set up the payment, the transaction is placed in a queue, then the user is passed back to your site.

the transaction may be processed in moments, or it may take days for it to get through the queue. Once it does get through the queue and the status is known, paypal uses IPN to post the result to your site.  

ok so i am setting up IPN. from the guide i read all i can figure is that there will be an order history with pay pal. but will it solve my order history problem with my site? cos i have an order history for customer profiles.

the order information will still be stored.

like i said in my previous reply, you should add a column for order status, and set the default value to pending.

use the IPN Script to update the order status based on the status returned from paypal to mark the order as Successful or failed.

Originally Said By: Jason Byrnes

  the order information will still be stored.

like i said in my previous reply, you should add a column for order status, and set the default value to pending.

use the IPN Script to update the order status based on the status returned from paypal to mark the order as Successful or failed.  

will i need to do extra coding for this to work? i have created the order status column. so when i set up ipn will my order history work as it should? or does it require anything else.

yes, you will need to configure the IP page to update the order status when the IPN post is made.