After try time how to reset order number to 1?

[ruimacdonald]

The time for essays is finished and the shop is working 100%.

 

Now, before it goes live, I should like to reset the number of the Orders to 1, how can I do that?

 

No Invoices are created / sent by the shop.

 

Regards

 

Rui Macdonald

[bellini13]

you would likely need to purge all the order related tables.

[Scnd]

Not all order related tables!

Just these:

TRUNCATE `ps_orders`;
TRUNCATE `ps_order_carrier`;
TRUNCATE `ps_order_cart_rule`;
TRUNCATE `ps_order_detail`;
TRUNCATE `ps_order_detail_tax`;
TRUNCATE `ps_order_history`;
TRUNCATE `ps_order_invoice`;
TRUNCATE `ps_order_invoice_payment`;
TRUNCATE `ps_order_invoice_tax`;
TRUNCATE `ps_order_payment`;
TRUNCATE `ps_order_return`;
TRUNCATE `ps_order_return_detail`;
TRUNCATE `ps_order_slip`;
TRUNCATE `ps_order_slip_detail`;

 

And you might want to manually take care of these tables too:

ps_customer_thread
ps_stock_mvt
ps_message

[vekia]

exactly you must truncate order tables, it is easy you can do it via some database managers like phpmyadmin or other.

if our suggestions will work for you - please let us know