Post by Aleks1201 » Sun Jun 21, 2020 2:29 am

How to start counting orders from 0?

New member

Posts

Joined
Sat Apr 11, 2020 10:05 pm

Post by uksitebuilder » Sun Jun 21, 2020 4:36 pm

Assuming you want to start fresh with your orders, delete all current orders

Then via PHPMyAdmin go in to the oc_order table, click on operations tab, set Auto Increment value to '0'

Whilst in there, make sure the following tables are empty also:

oc_order_history
oc_order_option
oc_order_product
oc_order_recurring
oc_order_recurring_transaction
oc_order_shipment
oc_order_total
oc_order_voucher

ImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by thekrotek » Sun Jun 21, 2020 5:18 pm

Aleks1201 wrote:
Sun Jun 21, 2020 2:29 am
How to start counting orders from 0?
You can't start from 0, you can only start with 1. And in addition to the tables listed above you will also have to change order_id in ALL tables, which have this parameter. Better use MySQL command to list all tables with order_id table then create new connections. But if you're not skilled with MySQL, you won't be able to complete this task.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: Baidu [Spider] and 18 guests