Magento how to remove order
First of all, removing live orders is not recommended. But if you are sure you want to remove orders (test orders?) then you can do so by custom script below. Get the order increment id(s) of the order you wish to delete from Magento. Remember, once order is deleted you can’t get any related information of that order.
Create a test PHP file in your Magento project root with below code:
require 'app/Mage.php'; | |
Mage::app('admin')->setUseSessionInUrl(false); | |
$orderIncrementIDs = array('100000001','100000002'); //your order increment ids to delete, beware! | |
$rmvd = array(); | |
foreach($orderIncrementIDs as $ordID){ | |
try{ | |
Mage::getModel('sales/order')->loadByIncrementId($ordID)->delete(); | |
$rmvd[] = $ordID; | |
} catch(Exception $e){ | |
echo 'Error: '.$e->getMessage().'<br />'; | |
} | |
} | |
echo "Following Orders Removed!<br />" . implode(", ",$rmvd); |
and run the file to delete the order(s).
Continue reading »
Mysql delete duplicate records leaving one
Mysql delete duplicate records leaving one row. Consider that there are many duplicate records in the table and you want to remove it. Now, we can select it by applying GROUP BY but the question is how to delete all the duplicate records (of field some_id below) EXCEPT one that should be there. So, lets say I have following table with duplicate data as shown:
Tablename: test
unique_id | some_id | |
-------------------- | |
1 | 1 | |
2 | 1 | |
3 | 2 | |
4 | 2 | |
5 | 1 |
Welcome to my Blog
Certifications
Honor
Recognition
Contributions
Categories
- Apache (2)
- ChatGPT (1)
- Domain name (2)
- eCommerce (2)
- htaccess (1)
- Humor (3)
- Instagram API (1)
- jQuery (4)
- JSON (1)
- Linux (10)
- Magento (142)
- Magento admin (58)
- Magento Certification (5)
- Magento error (13)
- Magento frontend (68)
- Magento Imagine (2)
- Magento Interview (5)
- Magento Master (2)
- Magento2 (10)
- Mobile (1)
- MySQL (7)
- OpenAI (1)
- OroCRM (2)
- Performance (2)
- PHP (8)
- Prototype JS (3)
- Security (4)
- Wordpress (3)
- XML (2)