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.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Forum Rules Code of conduct
AbanteCart.com 2010 -