Order Number – Can It Be Modified in Magento?

orders

We have a customer move their servers to a new host and we had one days' data which got missed in between, while we have synchronized products and customers, new orders had already been taken and now the customer wants to find out if it would be possible to modify the order number to follow the old sequence.

I am aware of the table(eav_entity_store) that contains the last order id and the increment values which can avoid issues happening in future with order numbers, however we are trying to modify order numbers from the past.

Is there a list of tables, that I can update to achieve this result. I know modifying database directly is a very bad idea, but the for the customer it is a major issue as the orders integrate with their accounting system and it cannot take duplicates.

Best Answer

Yes you can, the tables you would want to have a look at are as follows:

sales_flat_order,
sales_flat_order_item,

These two tables basically contain all the information regarding an order, from address, delivery method etc. to products & qtys ordered.

You can relate them to each other as follows: the entity_id field in sales_flat_order is the order_id field in sales_flat_order_item.

The column named increment_id in sales_flat_order is the order number which is visible in the front- and back-end.

Related Solutions

Magento – Same customer places duplicate order

I've seen something like this before where a shop was a bit slow on redirecting the customer from the checkout to the Payment portal.

The user clicked the submit button multiple times which caused several orders to be created. So there isn't really a technical issue here, more an user UI issue.

I would advice to first of all call the customer and ask him what happened and maybe display a clear loader or even hide the submit button after the user has clicked it in the checkout

Magento – Programmatically create new orders from multiple existing orders

Magento uses lots of singletons and assumes that certain actions are only executed once.

If you take a look at Mage_Adminhtml_Model_Sales_Order_Create, you will find this one:

public function __construct()
{
    $this->_session = Mage::getSingleton('adminhtml/session_quote');
}

You can reset singletons like this:

Mage::unregister('_singleton/adminhtml/session_quote');

If it still does not work, walk through the code, there might be other relevant singletons.

Best Answer

Related Solutions

Magento – Same customer places duplicate order

Magento – Programmatically create new orders from multiple existing orders

Related Topic