Make order number start at chosen number

  • Posts: 87
  • Thank you received: 5
  • Hikashop Business
11 years 4 months ago #111760

I am quite sure that I've done this before, but I can't remember how to do it.
I want the orders in my new shop to continue numbering from where the old shop was stopped.
The old shop received 800 orders, so I want my new orders to start numbering from 801.
My order number date format is: KO-{id size="5"}-{date format="dmY"}
So the id should start numbering from 800 onwards. Is this something I need to edit in my DB?

Kind regards,
Chris

Please Log in or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 4 months ago #111767

I there,

Just execute this query in your database:

ALTER TABLE yourkey_hikashop_order AUTO_INCREMENT = 800

it should do the job :)

The following user(s) said Thank You: Foxworks

Please Log in or Create an account to join the conversation.

  • Posts: 87
  • Thank you received: 5
  • Hikashop Business
11 years 4 months ago #111773

Thanks!

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum