Author Topic: Reset Order ID  (Read 4246 times)

Offline mykidz

  • Newbie
  • *
  • Posts: 32
  • Karma: +4/-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: 4358
  • Karma: +298/-10
    • 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.
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

 

Powered by SMFPacks Social Login Mod