basic order tracking

basic order tracking ecommerce

[bono]

Hey, I was wondering how most people do basic order tracking?

cart -> checkout -> secure tranaction -> order accepted

was wondering at what point people put the details in the database. I could just not do that bit at all.. but it would be nice...

[Rugles]

Hey Bono.... I thought you would be too busy on tour to spend time building a site.

I would write to a database when something is added to the cart, and when the check out process is complete.

Hope that helps and say hi to The Edge for me.

[CanadianChris]

We dump the session, post, and get data on the checkout pages. That gets everything that our system knows about the current user.

[sun818]

Oh, I thought you were talking about package tracking...

[bono]

at the moment im storing the data within the session and not adding it to a database ( didnt want to be constantly quering a database..) but that seems to have back fired as I now I want to add the customer details and their order together with a transaction ID at the same time as going to my secure payment provider (dont really want to add an are you sure page just to add there details to teh database).. guessing that when the payment is successful i update the database via the returned transactionID saying payment successful..

is there a way i can do an insert at the same time as directing the customer to the secure payment handler..?

[bono]

can anyone shed light on this?

[Habtom]

"Oh, I thought you were talking about package tracking... "

The same here

[bono]

right, im a little bit further along the line (using php mysql)..

ive got to the stage where im deciding where im getting users to enter their shipment details.

shop>>>basket>>>checkout>>>>secure card payment>>>callback

Im thinking of doing it on the checkout page. The problem im hitting is that i want to enter this into the database before i get to secure card payment page. this page is obviously located on our secure transaction handlers server so i cant run php code to enter it into the database.. I was wondering wether there was some way of getting into my database while the user is still on the checkout page?