Mounika Reddy Mounika Reddy - 5 months ago 72
PHP Question

How to Change the Order Increment ID and Prefix in Magento?

How to change the order increment ID and prefix in Magento? I was successfully run the SQL queries but I did not get the results into my frontend magento.

I am trying the query here local host/phpmyadmin in magnto (eav_entity_store)..so how can I change my order prefix number?

Answer

now i used this query for order increment

UPDATE eav_entity_store
INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id
SET eav_entity_store.increment_last_id='0000000000'
WHERE eav_entity_type.entity_type_code='order' AND eav_entity_store.store_id = '1';
UPDATE eav_entity_store
INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id
SET eav_entity_store.increment_prefix='ORD'
WHERE eav_entity_type.entity_type_code='order' AND eav_entity_store.store_id = '1';
Comments