Executing the below SQL query (Remember to backup first! This will help you to keep your data safe if anything go wrong anywhere. We won’t be responsible for any error or data loss by executing the code given below) should clear test orders in Magento Read More>

If you want execute a SQL query in your Magento database in your program, you can write it by using the following code Read More>

If you want to change the SKU of large number of products with new one, you can do it by Magento Dataflow product import. Add a column named ‘your-new-sku’ and fill the values with that column in your product import CSV in addition to ”your-old-sku” and other required columns for data import. Add the following code in proper place (saveRow() function) in your corresponding Model Class file (app\code\core\Mage\Catalog\Model\Convert\Adapter\Product.php). Read More>