Elxis CMS Forum

Extensions => Components => Topic started by: sophocles on October 24, 2012, 15:29:47

Title: E-shop how to erase orders count
Post by: sophocles on October 24, 2012, 15:29:47

Hi,

I've been making some test orders in order to check the functionality of the e-shop.
Now that i want to go online, i want the counter to start from order 1 (E-1).
Although i erase the orders within the e-shop back end,  the counter keeps counting from the last order.

Where in the eshop database tables can i find the counter and erase it?

Thanks in advance

Title: Re: E-shop how to erase orders count
Post by: datahell on October 24, 2012, 18:43:31

You must change the orders table's (elx_eshop_orders) primary key (orderid) auto increment value to 1.
First make sure there are no orders in IOS eshop.
Go to your database manager (phpmyadmin) and execute the following SQL command:

Code: [Select]

ALTER TABLE elx_eshop_orders AUTO_INCREMENT = 1;
If you use a different tables prefix than "elx_" change elx_ with your own tables prefix in the above command.

Title: Re: E-shop how to erase orders count
Post by: sophocles on October 25, 2012, 07:52:31

Precise as always.
Thank you datahell