Page 1 of 1
How to start counting order from 0
Posted: Sun Jun 21, 2020 2:29 am
by Aleks1201
How to start counting orders from 0?
Re: How to start counting order from 0
Posted: Sun Jun 21, 2020 4:36 pm
by uksitebuilder
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
Re: How to start counting order from 0
Posted: Sun Jun 21, 2020 5:18 pm
by thekrotek
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.