Author Topic: Reset Order ID  (Read 1514 times)

Offline mykidz

  • Newbie
  • *
  • Posts: 28
  • Karma: +3/-0
    • View Profile
Reset Order ID
« 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 :)

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4152
  • Karma: +251/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Reset Order ID
« Reply #1 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.
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

 

Powered by SMFPacks Social Login Mod