OpenCart Community

v1.2.5

Hi,

this is odd.

I have created two test orders through to completion (COD).
The order numbers are #1 & #4 - what happened to order numbers #2 & #3 ?

I went into PHPAdmin and there are 4 orders in the order table.
Orders #2 & #3 are for my test user, but both have order_status_id of 1 - which is 'Pending'.

Presumably these are orders that didn't get through to payment stage whilst I was testing - okay that's fine as they would count as 'Abandoned Carts' - BUT, they don't appear anywhere in Admin when you look at orders - even if you filter on Pending status!

Can someone please explain if this is correct and why is works this way so I can understand what's going on?

It's really going to confuse the store owner if they have 'missing order numbers' in Admin?

Thanks,
Mark

the store owner will not be looking at the db.

I think i explained this to you before.

orders need to be saved somewhere until they are completed.

Hi Daniel,

you're right, I think you did!
Did you also say that they get cleared down periodically? If so, how is that achieved?

I appreciate that store owners won't be looking at the db, but they would be looking at orders in Admin and seeing gaps in order number.

In terms of them being saved somewhere until completed, could they be saved with a status of 'incomplete' or similar? It's not then till they go past the payment stage that they become 'Pending' or whatever the default status is.
In that case, if Admin could see the incomplete orders with last modified date/time stamp, they could see what might be abandoned orders and get in touch with customers to follow-up?

What do you think?

Regards
Mark

look there is no other way of doing it. you need a order number on the checkout confirm page so it can be used in sending the information to the payment gateway. customers need to be able to check order ids in the payment gateway control panel to the order page in opencarts admin.

If there odd order id is missing its not a big issue. You might find it a issue if you are doing lots of testing and refreshing the page cuasing the order ids to skip quite a lot.

As for an abondond order page, well this might be a possibility.

On the next version I have added the ability for paypal uses to confirm the order once the confirm button is pressed or they can use paypal's callback. It depends how safe they feel that paypals callback is.