Delete particular Order from database

Posted: September 7, 2010 in Magento, Version 1.3.*

Hello everyone,

Below code will help to delete particular order using increment_id of that order.

select @order_id:=entity_id from sales_order_entity where increment_id='100000001';
delete from sales_order_entity where entity_id=@order_id or parent_id=@order_id;

I hope this will help u to particular delete order.
Ref: http://www.magentocommerce.com/boards/viewthread/1680/#t29687

Thanks,
Bijal Bhavsar 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s