News:

AbanteCart v1.4.2 is released.

Main Menu

Reset Order ID

Started by mykidz, March 26, 2016, 03:04:04 AM

Previous topic - Next topic

mykidz

Hi! Can anybody assist me on how to reset the order ID back to zero please...TQ :)

abantecart

I assume you need to start orders from 0 and delete all other orders. You can drop the order tables and recreate again.

https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database.sql
Check:
DROP TABLE IF EXISTS `ac_orders`;
and
CREATE TABLE `ac_orders` (

This way auto order_id increment will stat from 0.
You need to do the same for other order related tables.

Forum Rules Code of conduct
AbanteCart.com 2010 -