General order process

[okpoubelle]

Hello everyone,

 

(excuse my not-perfect english)

I have a really basic question (could sound silly, maybe...) about order workflow (with credit card payment)

 

When a user make an order, he's redirected to the bank interface, enters and validate his credit card number, and then he's redirected back to the shop, and the order's status is automatically set to "Pending".

So the shop owner has 2 interfaces :

- the bank interface on which he can see the payment status (ok, rejected, and various other status)

- OSc interface

 

My question is : is there any relation between payment status on bank side, and OSc order status on OSc side ?

I mean: The shop owner will have first check on his bank's interface if payment is ok, and then, for each order, go in OSc to process to the shipping ?

 

Thank you for your understanding and forgiveness ;)

Cheers

[knifeman]

Payment modules work differently depending upon which one you use. Some modules never take the customer away from your site, only the data is transferred.

 

That being said, I don't know of any that are so linked that updating a payment in the bank interface will change any data on the oscommerce side. So yes, you need to log in to both interfaces to process orders.

 

Tim

[okpoubelle]

Thanks for the answer Tim

 

 

Indeed, our payment module takes the visitor away from the site.

 

Our site is quite small so logging into both interface is not a big deal.

But I can't imagine dealing with hundreds of orders!

How do big site do...?

[knifeman]

Thanks for the answer Tim

 

 

Indeed, our payment module takes the visitor away from the site.

 

Our site is quite small so logging into both interface is not a big deal.

But I can't imagine dealing with hundreds of orders!

How do big site do...?

Our payment gateway send us 2 e-mails. One is the AVS code results and the other is basically a receipt. Highly unlikely anyone would be able to spoof both of them. So we process and pack all our orders. Before actually shipping them, we log in and capture the funds for all the orders that have been packed.

 

Also, since we are setup for authorize only, if there is an out of stock issue, then we do not need to create a refund. We just capture the appropriate amount.

 

Tim

[okpoubelle]

Well, actually, our payment module has some useful options:

Depending on bank response (the different cases are: success , autorisation deny, other deny, cancelled, error, default)(probably bad translations, but you get the point), we can choose a page on which the user is redirected.

In all cases, by default the selected page is checkout_process.php.

 

I can't find where this payment status is stored in OSc, though...

[knifeman]

 

I can't find where this payment status is stored in OSc, though...

The order is set to pending and that is it. If you have a pending order, then presumably you have received a payment. (not paypal though)

Updating the payment status at you bank website will not alter any statuses on your oscommerce site.

 

I send an update to the customer and mark the order processing. Once payment is captured, I send the last update with tracking info and mark it shipped.

 

Tim

[okpoubelle]

Yes Tim, yinally, things are more simple than I a thought...

Well, at least I guess.

 

From the shop side, only 2 payment status are needed : either the payment is ok and order is recorded, or the payment failed for some rease (client bank side, and he has to see why, not the vendor), and the order is not recorded.

 

Or am I missing some point ?

[knifeman]

Yes Tim, yinally, things are more simple than I a thought...

Well, at least I guess.

 

From the shop side, only 2 payment status are needed : either the payment is ok and order is recorded, or the payment failed for some rease (client bank side, and he has to see why, not the vendor), and the order is not recorded.

 

Or am I missing some point ?

With my module ( and I assume most others) if the payment fails, then no order is recorded and no notice is shown on the store side. I only receive AVS code e-mails if the payment is approved.

 

I can log in to my gateway website and pull up records of declined payments, but not on the store side.

There are add ons like supertracker and recover cart sales that will show copious amounts of info from shoppers and bailed carts, but I don't know of any that show failed payment attempts. The Who's online add on will show the failed payment, but only if you are viewing it at the time they are failing.

 

Tim

[okpoubelle]

Same for my module, except that an error message is returned and displayed on website.

 

But the more i think about it, the more I see that the vendor doesn't give a damn of failed bank response from client's side.

Either the vendor gets his money and proceeds to shipping, or no money is received and no order is recorded.