Post by MysticKnight » Sat May 16, 2020 4:30 am

So far, each order that has been coming in has incremented one at a time. In other words, after order #22, it would go to #23 and then #24, etc.

Today however, it jumped from order #29 to order #37.

Any ideas why that would happen?

Bill Elgin
Custom Website Design
www.billelgin.com


New member

Posts

Joined
Sat Jan 04, 2020 9:43 am


Post by thekrotek » Sat May 16, 2020 5:07 am

This is absolutely normal.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by MysticKnight » Sat May 16, 2020 6:33 am

First, thank you for replying and I’m also glad to hear it’s normal, sort of.

Why is it normal?

The database is set up to auto increment the order numbers one at a time.

Bill Elgin
Custom Website Design
www.billelgin.com


New member

Posts

Joined
Sat Jan 04, 2020 9:43 am


Post by straightlight » Sat May 16, 2020 7:40 am

Without order ID incrementing, your orders would override one-another. The idea of auto-incrementing the primary key values is to avoid conflict of orders. However, there are extensions on the Marketplace that also provides the possibility to use different order information than the IDs.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by MysticKnight » Sat May 16, 2020 7:47 am

Please read my messages closer.

I’m not trying to control the order...

It skipped #30 thru #36.

Why would it do that?

Bill Elgin
Custom Website Design
www.billelgin.com


New member

Posts

Joined
Sat Jan 04, 2020 9:43 am


Post by straightlight » Sat May 16, 2020 7:52 am

MysticKnight wrote:
Sat May 16, 2020 7:47 am
Please read my messages closer.

I’m not trying to control the order...

It skipped #30 thru #36.

Why would it do that?
The table creation on your database might involve auto-incrementing setting to a user-defined value rather than requesting the database server to do it for you. While this process might still be automated, the incrementing range of values might differ as opposed to the automated settings which is why you might notice higher ranges than simply noticing the incrementing value of 1 from each rows.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by MysticKnight » Sat May 16, 2020 8:23 am

I have the default OpenCart installed and I have not touched the auto increment settings.

From #1 to #28, it incremented ONE AT A TIME.

Why did it suddenly skip 7 spaces?

Bill Elgin
Custom Website Design
www.billelgin.com


New member

Posts

Joined
Sat Jan 04, 2020 9:43 am


Post by samaraki » Sat May 16, 2020 9:43 am

I have actually read your comment, unlike the others, so I will actually answer you.

It's because of missing orders / failed orders.
Sale 1 = order number 1.
But say 15 people added items to their basket and got partway through the checkout, and then didn't complete it.
it will jump your order number up.
So Sale 2 would be order number 17.

And just some extra info, if someone from one of those missing order actually did end up ordering without going back and forth from the basket and checkout, then sale three could actually be a lower order number than order 17, as it would be one of those missing order numbers, although if they went back to the basket and then back to the checkout it would be order 18 or higher.

When you goto your sales page in opencart, on the drop-down menu to filter, select "missing orders" and then filter that, and then you'll see all of the missing orders.

I hope that helps.

Active Member

Posts

Joined
Fri Jul 26, 2013 2:36 pm

Post by MysticKnight » Sat May 16, 2020 10:02 am

samaraki wrote:
Sat May 16, 2020 9:43 am
I have actually read your comment, unlike the others, so I will actually answer you.

I hope that helps.
You don’t know how much that helps samaraki.

I thought I was going crazy or something because I thought it was such a simple question.

Your explanation makes complete sense and thank you again for actually reading my message and taking the time to provide a considerate and accurate reply.

Bill Elgin
Custom Website Design
www.billelgin.com


New member

Posts

Joined
Sat Jan 04, 2020 9:43 am

Who is online

Users browsing this forum: Bing [Bot], Semrush [Bot] and 435 guests