Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to Change Order Starting Number in Magento

Is there any way to change Order Starting Number in Magento without changing order numbers that are already there? I just want to set 170000xxxx for all new orders.

Thanks

like image 210
FlourishDNA Avatar asked Feb 23 '12 19:02

FlourishDNA


People also ask

How do I change my order status in Magento?

To change order status in Magento 2: Go to Catalog > Products and check all Products which statuses you want to change. Choose Change Status option іn Actions dropdown, and accordingly, the Order Status you want selected orders to have.

What is increment ID in Magento 2?

order_id is the internal Magento order ID. order increment ID is the ID which you communicate to your customer.


1 Answers

Look in eav_entity_store and find increment_last_id. Update this number, making sure that entity_type_id is correct for orders.

Find the entity_type_id for orders

SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'order';

like image 155
Zachary Schuessler Avatar answered Oct 08 '22 12:10

Zachary Schuessler