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
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
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
Who is online
Users browsing this forum: mattltm and 322 guests