Page 1 of 1
set initial order id
Posted: 19 Nov 2023, 18:32
by 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
Re: set initial order id
Posted: 22 Nov 2023, 18:16
by 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
Re: set initial order id
Posted: 18 Dec 2023, 14:55
by 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!
Re: set initial order id
Posted: 18 Dec 2023, 16:36
by Benno
Ok.
Kind regards,
Benno