set initial order id

[rusty-bearing]

Hi, we're moving our small club shop to Phoca and I want to set the initial order number to 1186 so that it follows on from previous invoice numbers in the old component, can that be done in settings or if not which table contains the next available invoice number please?

thanks
Mike

[Jan]

Hi, there is no option to set number of order as this is auto increment number in database. The ID column is in table: #__phocacart_orders.

Jan

[rusty-bearing]

Finally got round to dealing with this. Either in PHPmyAdmin or Workbench - firstly I truncated the table to reset the auto increment to 1 then set it to the required number with
ALTER TABLE your_table_name AUTO_INCREMENT = 1000;

Job done!

[Benno]

Ok.

Kind regards,
Benno