Jump to content
ruimacdonald

After try time how to reset order number to 1?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More