Change the starting point of the Ticket Number

[Tim]

We have a client that would like the ticket numbers to start at 500000 and increment up from there as tickets are sold (POS compatibility issue). I have searched everywhere but cannot seem to find any information on how or where to do this. I found a plugin that can change the WooCommerce order number, but the ticket numbers are not affected by it.

[Tim]

After doing some more digging, came across a MySQL query that was able to accomplish what we were after. In case anyone else could use this application, this is the query that we ran that enabled us to start the ticket numbers that are assigned to each ticket incrementing up from 500000:

ALTER TABLE wp_posts AUTO_INCREMENT = 500000;

[Brian]

I am glad to see you were able to figure it out.

I am going to go ahead and close this ticket. If you have a similar issue or another in the future, please do not hesitate to create a new ticket.

Thanks!

[Author]

Posts