[RESOLVED] Shopping Basket, suggestions processing orders.

[ade234uk]

Building a shopping cart. One thing I can't get my head around is processing orders.

In the example the user has their items in the basket and decides to make payment.
This is where I cannot work out the best way forward it.

Do you:

1) Add the final order details to the orders table just before the user pays, and once successful payment has been made through the payment processor provide a callback and set the status of the order to paid in your database

or

2) Do you add the order details to the orders table only after after Payment has been made and has been succesful.

Hope the above makes some sense. I am just interested on how you accomplished this, if you built your own shopping cart.

[Weedpacket]

It would depend on whether a record in the orders table is supposed to mean "an order has been placed" or "an order has been placed and payment has been confirmed". That depends on what you designed it to mean, and whether you can tell if an order has been confirmed or not, or whether one has been placed or not.

[ade234uk]

I understand what you mean now.

How I can see it working is that once a user confirms the order just before making payment, the contents of the basket gets moved to the orders table. At this point the order status is Unpaid.

Once payment is made and I can get some sort of callback from PayPal and other Payment Processor the order status is updated to Paid.

If a user quits the basket after confirming the order, because the status of the item is Unpaid the link to different Payment Processors will be displayed.

[cretaceous]

Option 'a' is what I do - that way you can track if there are errors in transfer to/from your payment gateway.
Also in some payment gateways you can only transfer the total payable and an order number - so it's essential to store the order detail in your own db first.