When moving to Magento, some people might want to change the default order number 000000001 to some other number – either fooling the customer into thinking this is a very popular shop, or when migrating from another web shop to Magento. Here’s how to change that order number. if updating a store that already has sales to a new increment id: UPDATE eav_entity_store SET increment_last_id = 012345678, increment_prefix = 0 WHERE entity_type_id = 5; If updating a clean store with no sales: INSERT INTO eav_entity_store SET increment_last_id = 012345678, increment_prefix = 0, entity_type_id = 5;

Cleanly Delete all Orders, Sales & Customer Data in Magento After finishing the site and It’s ready to publish it,  you will need to delete all test orders, dashboard stats and search terms. How can we do it??? First: Backup the database and the files. Either via phpmyadmin in c Panel or MySQL via SSH… Read more »