Search
 
SCRIPT & CODE EXAMPLE
 

PHP

magento 2 remove order

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

TRUNCATE TABLE `sales_creditmemo`;
TRUNCATE TABLE `sales_creditmemo_comment`;
TRUNCATE TABLE `sales_creditmemo_grid`;
TRUNCATE TABLE `sales_creditmemo_item`;
TRUNCATE TABLE `sales_invoice`;
TRUNCATE TABLE `sales_invoiced_aggregated`;
TRUNCATE TABLE `sales_invoiced_aggregated_order`;
TRUNCATE TABLE `sales_invoice_comment`;
TRUNCATE TABLE `sales_invoice_grid`;
TRUNCATE TABLE `sales_invoice_item`;
TRUNCATE TABLE `sales_order`;
TRUNCATE TABLE `sales_order_address`;
TRUNCATE TABLE `sales_order_aggregated_created`;
TRUNCATE TABLE `sales_order_aggregated_updated`;
TRUNCATE TABLE `sales_order_grid`;
TRUNCATE TABLE `sales_order_item`;
TRUNCATE TABLE `sales_order_payment`;
TRUNCATE TABLE `sales_order_status_history`;
TRUNCATE TABLE `sales_order_tax`;
TRUNCATE TABLE `sales_order_tax_item`;
TRUNCATE TABLE `sales_payment_transaction`;
TRUNCATE TABLE `sales_refunded_aggregated`;
TRUNCATE TABLE `sales_refunded_aggregated_order`;
TRUNCATE TABLE `sales_shipment`;
TRUNCATE TABLE `sales_shipment_comment`;
TRUNCATE TABLE `sales_shipment_grid`;
TRUNCATE TABLE `sales_shipment_item`;
TRUNCATE TABLE `sales_shipment_track`;
TRUNCATE TABLE `sales_shipping_aggregated`;
TRUNCATE TABLE `sales_shipping_aggregated_order`;

SET FOREIGN_KEY_CHECKS=1;
Comment

PREVIOUS NEXT
Code Example
Php :: change native password in phpmyadmin 
Php :: @admin @endadmin 
Php :: carbon now set timezone 
Php :: toast in laravel 
Php :: laravel collection isNotEmpty 
Php :: How to check if a session is expired or never was set in php 
Php :: canany else 
Php :: laravel override eloquent all function 
Php :: bulk update data in db query in laravel 8 
Php :: Laravel Deploy in production 
Php :: readable date in php 
Php :: Sending HTML Code Through JSON 
Php :: create a table using query 
Php :: laravel redis sentinel 
Php :: create migration command in laravel 
Php :: laravel collection shift 
Php :: envoyer des donnees js a php 
Php :: dynamic function name php 
Php :: foreach loop in php stack overflow 
Php :: livewire calendar for laravel 9 
Php :: tenary php 
Php :: laravel php what does compact 
Php :: shortcode wordpress form 
Php :: meta_value wordpress 
Php :: laravel make:action 
Php :: Laravel 7 pagination with search filter 
Php :: magento check which user has added a product 
Php :: comment installer laravel avec docker 
Php :: php arrays 
Php :: php is datetime 
ADD CONTENT
Topic
Content
Source link
Name
4+9 =