Hi,
how to empty all orders ?
Remove all entry from sales_order
1 Like
It is not sufficient to clear only the sales_order table, because it will leave orphaned orders information in other tables.
It would better to see how does the ibnab/magento2-delete-orders extension work:
c794b880/Controller/Adminhtml/Order/MassDelete.php#L30-L196
/**
* Cancel selected orders
*
* @param AbstractCollection $collection
* @return \Magento\Backend\Model\View\Result\Redirect
*/
protected function massAction(AbstractCollection $collection)
{
$countCancelOrder = 0;
$connection = $this->_resource->getConnection(\Magento\Framework\App\ResourceConnection::DEFAULT_CONNECTION);
$showTables = $connection->fetchCol('show tables');
//start get table name
// insert table prefix, if you use any, for example magento2_ ...
$tblPrefix = (string)$this->deploymentConfig->get(
ConfigOptionsListConstants::CONFIG_PATH_DB_PREFIX
);
$tblSalesOrder = $connection->getTableName($tblPrefix . 'sales_order');
$tblSalesCreditmemoComment = $connection->getTableName($tblPrefix . 'sales_creditmemo_comment');
$tblSalesCreditmemoItem = $connection->getTableName($tblPrefix . 'sales_creditmemo_item');
$tblSalesCreditmemo = $connection->getTableName($tblPrefix . 'sales_creditmemo');
$tblSalesCreditmemoGrid = $connection->getTableName($tblPrefix . 'sales_creditmemo_grid');
$tblSalesInvoiceComment = $connection->getTableName($tblPrefix . 'sales_invoice_comment');
$tblSalesInvoiceItem = $connection->getTableName($tblPrefix . 'sales_invoice_item');
$tblSalesInvoice = $connection->getTableName($tblPrefix . 'sales_invoice');
$tblSalesInvoiceGrid = $connection->getTableName($tblPrefix . 'sales_invoice_grid');
$tblQuoteAddressItem = $connection->getTableName($tblPrefix . 'quote_address_item');
$tblQuoteItemOption = $connection->getTableName($tblPrefix . 'quote_item_option');
$tblQuote = $connection->getTableName($tblPrefix . 'quote');
$tblQuoteAddress = $connection->getTableName($tblPrefix . 'quote_address');
$tblQuoteItem = $connection->getTableName($tblPrefix . 'quote_item');
$tblQuotePayment = $connection->getTableName($tblPrefix . 'quote_payment');
$tblQuoteShippingRate = $connection->getTableName($tblPrefix . 'quote_shipping_rate');
$tblQuoteIDMask = $connection->getTableName($tblPrefix . 'quote_id_mask');
$tblSalesShipmentComment = $connection->getTableName($tblPrefix . 'sales_shipment_comment');
$tblSalesShipmentItem = $connection->getTableName($tblPrefix . 'sales_shipment_item');
$tblSalesShipmentTrack = $connection->getTableName($tblPrefix . 'sales_shipment_track');
$tblSalesShipment = $connection->getTableName($tblPrefix . 'sales_shipment');
$tblSalesShipmentGrid = $connection->getTableName($tblPrefix . 'sales_shipment_grid');
$tblSalesOrderAddress = $connection->getTableName($tblPrefix . 'sales_order_address');
$tblSalesOrderItem = $connection->getTableName($tblPrefix . 'sales_order_item');
$tblSalesOrderPayment = $connection->getTableName($tblPrefix . 'sales_order_payment');
$tblSalesOrderStatusHistory = $connection->getTableName($tblPrefix . 'sales_order_status_history');
$tblSalesOrderGrid = $connection->getTableName($tblPrefix . 'sales_order_grid');
$tblLogQuote = $connection->getTableName($tblPrefix . 'log_quote');
$showTablesLog = $connection->fetchCol('SHOW TABLES LIKE ?', '%'.$tblLogQuote);
$tblSalesOrderTax = $connection->getTableName($tblPrefix . 'sales_order_tax');
foreach ($collection->getItems() as $order) {
$orderId = $order->getId();
if ($order->getIncrementId()) {
$incId = $order->getIncrementId();
if (in_array($tblSalesOrder, $showTables)) {
$result1 = $connection->fetchAll('SELECT quote_id FROM `'.$tblSalesOrder.'` WHERE entity_id='.$orderId);
$quoteId = (int) $result1[0]['quote_id'];
}
$connection->rawQuery('SET FOREIGN_KEY_CHECKS=1');
if (in_array($tblSalesCreditmemoComment, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesCreditmemoComment.'` WHERE parent_id IN (SELECT entity_id FROM `'.$tblSalesCreditmemo.'` WHERE order_id='.$orderId.')');
}
if (in_array('sales__creditmemo_item', $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesCreditmemoItem.'` WHERE parent_id IN (SELECT entity_id FROM `'.$tblSalesCreditmemo.'` WHERE order_id='.$orderId.')');
}
if (in_array($tblSalesCreditmemo, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesCreditmemo.'` WHERE order_id='.$orderId);
}
if (in_array($tblSalesCreditmemoGrid, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesCreditmemoGrid.'` WHERE order_id='.$orderId);
}
if (in_array($tblSalesInvoiceComment, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesInvoiceComment.'` WHERE parent_id IN (SELECT entity_id FROM `'.$tblSalesInvoice.'` WHERE order_id='.$orderId.')');
}
if (in_array($tblSalesInvoiceItem, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesInvoiceItem.'` WHERE parent_id IN (SELECT entity_id FROM `'.$tblSalesInvoice.'` WHERE order_id='.$orderId.')');
}
if (in_array($tblSalesInvoice, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesInvoice.'` WHERE order_id='.$orderId);
}
if (in_array($tblSalesInvoiceGrid, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesInvoiceGrid.'` WHERE order_id='.$orderId);
}
if ($quoteId) {
if (in_array($tblQuoteAddressItem, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuoteAddressItem.'` WHERE parent_item_id IN (SELECT address_id FROM `'.$tblQuoteAddress.'` WHERE quote_id='.$quoteId.')');
}
if (in_array($tblQuoteShippingRate, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuoteShippingRate.'` WHERE address_id IN (SELECT address_id FROM `'.$tblQuoteAddress.'` WHERE quote_id='.$quoteId.')');
}
if (in_array($tblQuoteIDMask, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuoteIDMask.'` where quote_id='.$quoteId);
}
if (in_array($tblQuoteItemOption, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuoteItemOption.'` WHERE item_id IN (SELECT item_id FROM `'.$tblQuoteItem.'` WHERE quote_id='.$quoteId.')');
}
if (in_array($tblQuote, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuote.'` WHERE entity_id='.$quoteId);
}
if (in_array($tblQuoteAddress, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuoteAddress.'` WHERE quote_id='.$quoteId);
}
if (in_array($tblQuoteItem, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuoteItem.'` WHERE quote_id='.$quoteId);
}
if (in_array('sales__quotePayment', $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblQuotePayment.'` WHERE quote_id='.$quoteId);
}
}
if (in_array($tblSalesShipmentComment, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesShipmentComment.'` WHERE parent_id IN (SELECT entity_id FROM `'.$tblSalesShipment.'` WHERE order_id='.$orderId.')');
}
if (in_array($tblSalesShipmentItem, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesShipmentItem.'` WHERE parent_id IN (SELECT entity_id FROM `'.$tblSalesShipment.'` WHERE order_id='.$orderId.')');
}
if (in_array($tblSalesShipmentTrack, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesShipmentTrack.'` WHERE order_id IN (SELECT entity_id FROM `'.$tblSalesShipment.'` WHERE parent_id='.$orderId.')');
}
if (in_array($tblSalesShipment, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesShipment.'` WHERE order_id='.$orderId);
}
if (in_array($tblSalesShipmentGrid, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesShipmentGrid.'` WHERE order_id='.$orderId);
}
if (in_array($tblSalesOrder, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrder.'` WHERE entity_id='.$orderId);
}
if (in_array($tblSalesOrderAddress, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrderAddress.'` WHERE parent_id='.$orderId);
}
if (in_array($tblSalesOrderItem, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrderItem.'` WHERE order_id='.$orderId);
}
if (in_array($tblSalesOrderPayment, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrderPayment.'` WHERE parent_id='.$orderId);
}
if (in_array($tblSalesOrderStatusHistory, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrderStatusHistory.'` WHERE parent_id='.$orderId);
}
if ($incId && in_array($tblSalesOrderGrid, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrderGrid.'` WHERE increment_id='.$incId);
}
if (in_array($tblSalesOrderTax, $showTables)) {
$connection->rawQuery('DELETE FROM `'.$tblSalesOrderTax.'` WHERE order_id='.$orderId);
}
if ($quoteId && $showTablesLog) {
$connection->rawQuery('DELETE FROM `'.$tblLogQuote.'` WHERE quote_id='.$quoteId);
}
$connection->rawQuery('SET FOREIGN_KEY_CHECKS=1');
}
$countCancelOrder++;
}
$countNonCancelOrder = $collection->count() - $countCancelOrder;
if ($countNonCancelOrder && $countCancelOrder) {
$this->messageManager->addError(__('%1 order(s) cannot be deleted.', $countNonCancelOrder));
} elseif ($countNonCancelOrder) {
$this->messageManager->addError(__('You cannot delete the order(s).'));
}
if ($countCancelOrder) {
$this->messageManager->addSuccess(__('We deleted %1 order(s).', $countCancelOrder));
}
$resultRedirect = $this->resultRedirectFactory->create();
$resultRedirect->setPath('sales/*/');
return $resultRedirect;
}
1 Like
So should i have to truncate all these tables or i have to install this extension, will it support 2.0.7 ?
I recommend to install the extension, it is easier.
Ask the extension author which Magento 2 versions the extension supports.
1 Like