Post by daymobrew » Tue Apr 24, 2012 5:22 am

When my client looks at the Latest 10 Orders list in the admin Dashboard the Order IDs are not sequential.
She is very concerned that some orders could be missing.

Why are the numbers not sequential? Is it due to incomplete or aborted orders?

New member

Posts

Joined
Wed Dec 22, 2010 7:36 am

Post by Avvici » Tue Apr 24, 2012 6:25 am

That is an impossibility. The order_id field is auto incrementing and a field that is shared by "all" customers. Knowing this, some customers may generate an order that will jump ahead of another person and vice verse.
In short, the orderID keeps generating in increments of +1 so if a customer makes an order on March 3rd 2012 with order ID 90, and then another order on April 4th 2012 their order id WILL NOT BE 91. Unless, that is, your store is suffering and you have had no orders in a month:)

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by Tcalp » Tue Apr 24, 2012 6:26 am

it is due to incomplete / aborted orders, an order is generated once you reach the confirm section of the checkout process. On the admin panel you can select 'Missing Orders' from the status to view those orders, this is done like this to prevent the system from loosing orders.

Increase Page Speed (#1 rated commercial extension on OpenCart Marketplace)
15in1 Essential Extensions Value Pack Premium Customer Testimonials Reward Points Extended Admin Security Lockdown Suite

Image
irc.freenode.net #opencart


User avatar
Active Member

Posts

Joined
Wed Jul 06, 2011 1:49 pm

Post by daymobrew » Tue Apr 24, 2012 2:51 pm

Tcalp wrote:it is due to incomplete / aborted orders, an order is generated once you reach the confirm section of the checkout process. On the admin panel you can select 'Missing Orders' from the status to view those orders, this is done like this to prevent the system from loosing orders.
Perfect, thank you.

New member

Posts

Joined
Wed Dec 22, 2010 7:36 am
Who is online

Users browsing this forum: Baidu [Spider] and 11 guests