How to change Ordernumber and Invoice number?

[Joachim Tranberg]

Hi

How can i change a order number from 3 to 1?
The same with invoices?
The orders have already been placed.

[TropischBruin]

You cannot without editing the database.

[Joachim Tranberg]

So it can be done?
How do i edit it in the database?

[TropischBruin]

Aks you hoster on how to use phpMyAdmin

[Joachim Tranberg]

I have access. But Do i just change the name? Or what do i have to do?

[TropischBruin]

You want to change te name? or the number?

[Joachim Tranberg]

The number.

[TropischBruin]

In your database you have to find the ordernumber you want to change and change it.
Have a look arround, you will learn how the structure of the db is, but do make a backup first.

[Joachim Tranberg]

I can't find. Where is it located

[rocky]

You will need to search ps_orders, ps_order_detail, ps_order_discount, ps_order_history, ps_order_return and ps_order_slip for each row with id_order = 3 and change it to 1.

[davers44]

I need to change an id_order number of an already placed order.

Is there a sql query to replace id_order number of an order with another number?

 

 

EDIT I found one:

 

UPDATE ps_orders

SET id_order='1'

WHERE id_order='2'

 

 

I'm no sql expert but this replace only one table at the time like ps_orders and I'm afraid to miss one, how can I run it to be sure id_order is replaced everywhere in the database? Or how can I see how many id_order istances are in the whole database?

[zyko]

Or how can I see how many id_order istances are in the whole database?

 

you need to make changes for order id on all the listed tables - ps_orders, ps_order_detail, ps_order_discount, ps_order_history, ps_order_return and ps_order_slip for each row with id_order = 3 and change it to 1

[davers44]

That helps but I also found I had to replace it in ps_message, ps_paypal_order and ps_stock_mvt.

Seems ok now, I hope there are no other hidden id_order in the database, probably a sql query that finds all of them would be safer.