how to RESET order_id in DB

Hi,

I know this probably been asked, but I can not find the resolution anywhere. I am trying to figure it out how to fix order_IDs in DB. Why are some fictitious orders created in DB and why don't they start with 0? Can you please provide me with resolution, how to fix that, so I won&t be having those empty spaces in between order ID numbers and so the next order will start with 1? Thank you.

Please find attached a screenshot.

To fix something it has to be broken. Nothing is broken here, so nothing to fix. Topic can be closed.

Well for me this is not normal, if you make a fresh clean install of 3.0.3.6. and waiting your clients to make some order, and than you find out you have all this in your DB for unknown reason? If everything would be ok, than the order_id would start with 1, and another order with 2. And now I have empty spaces with order Id's and two testing orders..

so the thing does not goes as smooth as I want, pure, flawless. For me this is broken value. And I want to know why this happened and how to fix it to not happen again.

So we are not here to debate, but to find resolutions. If this is not the matter, than this place should not be called forum.

Sorry, but there's nothing to fix here. Topic can be closed.

thekrotek wrote: ↑

Thu Jan 21, 2021 5:52 pm

Sorry, but there's nothing to fix here. Topic can be closed.

When you start a store you make some tests.
Orders and sh*t to see if everything is ok.
After that when you open the store you want orders to start from 1 so you will need to change AUTO_INCREMENT to 1 for order_id from oc_order table.

@ideep13
You can filter in admin for Missing orders...

Thank you xxVirusxx for your continuous help. It is impossible to tick the box - Adjust privileges. The box is grey. Should I proceed with not ticking the box and just change auto_increment to 1? What about data below ? See picture.

On table options....

And you can delete that test orders.

It is not possible to tick the box.
I tried to set privileges, access denied.

thekrotek wrote: ↑

Thu Jan 21, 2021 5:52 pm

Sorry, but there's nothing to fix here. Topic can be closed.

@thekrotek is perfectly correct, this is just how OpenCart works.

If you have a specific reason for this, please explain, otherwise I will lock the topic.

xxvirusxx wrote: ↑

Thu Jan 21, 2021 6:01 pm

you will need to change AUTO_INCREMENT

@paulfeakins

Title correct should be how to reset....
What is hard to understand? He made some test orders or are missing orders. He want to open the store for customers....and when first customer make an order, ID for that order to be 1.

from when do we need to explain ourselves? I think this should be reported to the opencart directly. Forum is runned by bunch of sensitive guys, who wants to have control over their users. Unbelievable.

it is not working. error received. you can not move the table to the same one

ideep13 wrote: ↑

Thu Jan 21, 2021 7:43 pm

you can not move the table to the same one

To move what?
Run that command and if doesn't work...contact hosting provider...
Last draw... time break for water

ideep13 wrote: ↑

Thu Jan 21, 2021 7:43 pm

from when do we need to explain ourselves? I think this should be reported to the opencart directly. Forum is runned by bunch of sensitive guys, who wants to have control over their users. Unbelievable.
it is not working. error received. you can not move the table to the same one

I imagine you are getting close to getting NO help at all here :-)

ideep13 wrote: ↑

Thu Jan 21, 2021 7:43 pm

from when do we need to explain ourselves?

You want help but you don't want to explain the reason for your problem?

ideep13 wrote: ↑

Thu Jan 21, 2021 7:43 pm

I think this should be reported to the opencart directly. Forum is runned by bunch of sensitive guys, who wants to have control over their users. Unbelievable.

We're trying to help you with our experience, for free, and you want to criticise us? Continue like this and you will be banned.

ideep13 wrote: ↑

Thu Jan 21, 2021 7:43 pm

it is not working. error received. you can not move the table to the same one

Again you're speaking gibberish.

mikeinterserv wrote: ↑

Thu Jan 21, 2021 10:18 pm

I imagine you are getting close to getting NO help at all here :-)

Correct.

xxvirusxx wrote: ↑

Thu Jan 21, 2021 7:33 pm

Title correct should be how to reset....
What is hard to understand?

You're right it's easier to understand now the title has been edited to might slightly more sense.