AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: mykidz on March 26, 2016, 03:04:04 AM

Title: Reset Order ID
Post by: mykidz on March 26, 2016, 03:04:04 AM

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

Title: Re: Reset Order ID
Post by: abantecart on March 27, 2016, 04:51:08 PM

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.