From time to time before it comes, that an Order is not changed as desired and as. a delivered contract status “Processing” stuck. This can then be adjusted manually in the database of the status (however, there are modules, something like that then permit from the backend).
Important changes in DB is as always: Better to have to think about it more than once too little. While it can be almost anything undone, you just have to know where. Therefore, documenting all steps in uncertainty. This manual is generic and may differ depending on the system may have its own.
- PHP MyAdmin starten
- That database open
- Search by part number and select either all tables (Search for) or the following:
- sales_flat_order (at “state” and “status” change) and click OK
- sales_flat_order_grid (at “status” change) and click OK
These are the different statuses:
- Status “reset” is “holded”
- Status “Pending” is “pending”
- Status “completely” is “complete”
- “Status “closed” is “closed”
- Status “processing” is “processing”
As I said,, This is a guide, which in our system (Standard) is valid. It can of course be, that called for different values of the adapted systems.
Used in Magento versions 1.4.1.0
P.S. Status “canceled” for “canceled” not to forget
This should take into account, that the Order (Column: status) internal ordering of the state (Column: state) depends.
In System > Order Status & Status, there is a table on this.
What does the dealer in the state of the shop is set depending on the state.