How to reset life sales=0 in Magento dashboard?How to exclude certain orders from the dashboard chart?Bundle products search/reset filter redirects to dashboardHow to add custom data in admin dashboard?Role based hide lifetime sales from dashboardMagento dashboard not updatingReset Stats on Admin Dashboard(Magento 2) How to halt salesHow To Reset Test Orders And Dashboard Statistics in Magento 2Magento 2 How Sales Graph Work on DashboardHow to rename order shipments name in customer dashboard frontend?
Front derailleur hard to move due to gear cable angle
Can I use my laptop, which says 100-240V, in the USA?
"Right on the tip of my tongue" meaning?
How to cope with regret and shame about not fully utilizing opportunities during PhD?
What is Plautus’s pun about frustum and frustrum?
When a land becomes a creature, is it untapped?
Why do Thanos's punches not kill Captain America or at least cause some mortal injuries?
Was this character’s old age look CGI or make-up?
Does the 500 feet falling cap apply per fall, or per turn?
Exclude loop* snap devices from lsblk output?
Proof that the inverse image of a single element is a discrete space
What are the components of a legend (in the sense of a tale, not a figure legend)?
Why is “Ich wusste, dass aus dir mal was wird” grammitally correct?
As programers say: Strive to be lazy
Why does getw return -1 when trying to read a character?
What is the best way for a skeleton to impersonate human without using magic?
How does noise-cancellation work in Mac laptops?
Is there a spell to protect inanimate objects?
How do I tell my supervisor that he is choosing poor replacements for me while I am on maternity leave?
Is taking modulus on both sides of an equation valid?
Was this a power play by Daenerys?
How to make a language evolve quickly?
Speculative Biology of a Haplodiploid Humanoid Species
What does i386 mean on macOS Mojave?
How to reset life sales=0 in Magento dashboard?
How to exclude certain orders from the dashboard chart?Bundle products search/reset filter redirects to dashboardHow to add custom data in admin dashboard?Role based hide lifetime sales from dashboardMagento dashboard not updatingReset Stats on Admin Dashboard(Magento 2) How to halt salesHow To Reset Test Orders And Dashboard Statistics in Magento 2Magento 2 How Sales Graph Work on DashboardHow to rename order shipments name in customer dashboard frontend?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
2
I have run below-listed queries:
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;
TRUNCATE TABLE `reporting_orders`;
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`;
TRUNCATE TABLE `tax_order_aggregated_created`;
TRUNCATE TABLE `tax_order_aggregated_updated`;
ALTER TABLE `sales_order` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS = 1;
The system doesn't allow me to truncate.
TRUNCATE TABLE `Mp_sales_creditmemo`;
TRUNCATE TABLE `Mp_sales_invoice`;
TRUNCATE TABLE `Mp_sales_order`;
TRUNCATE TABLE `Mp_sales_order_address`;
TRUNCATE TABLE `Mp_sales_order_item`;
TRUNCATE TABLE `Mp_sales_order_payment`;
TRUNCATE TABLE `Mp_sales_order_tax`;
TRUNCATE TABLE `Mp_sales_shipment`;
TRUNCATE TABLE `Mp_quote`;
TRUNCATE TABLE `Mp_quote_address`;
TRUNCATE TABLE `Mp_quote_item`;
Still, I can't reset the life time sales of Magento 2 dashboard
magento2 magento-2.1 sales dashboard
edited May 8 at 10:21
Muhammad Wasif
346
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
add a comment |
2
I have run below-listed queries:
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;
TRUNCATE TABLE `reporting_orders`;
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`;
TRUNCATE TABLE `tax_order_aggregated_created`;
TRUNCATE TABLE `tax_order_aggregated_updated`;
ALTER TABLE `sales_order` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS = 1;
The system doesn't allow me to truncate.
TRUNCATE TABLE `Mp_sales_creditmemo`;
TRUNCATE TABLE `Mp_sales_invoice`;
TRUNCATE TABLE `Mp_sales_order`;
TRUNCATE TABLE `Mp_sales_order_address`;
TRUNCATE TABLE `Mp_sales_order_item`;
TRUNCATE TABLE `Mp_sales_order_payment`;
TRUNCATE TABLE `Mp_sales_order_tax`;
TRUNCATE TABLE `Mp_sales_shipment`;
TRUNCATE TABLE `Mp_quote`;
TRUNCATE TABLE `Mp_quote_address`;
TRUNCATE TABLE `Mp_quote_item`;
Still, I can't reset the life time sales of Magento 2 dashboard
magento2 magento-2.1 sales dashboard
edited May 8 at 10:21
Muhammad Wasif
346
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
add a comment |
2
2
2
I have run below-listed queries:
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;
TRUNCATE TABLE `reporting_orders`;
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`;
TRUNCATE TABLE `tax_order_aggregated_created`;
TRUNCATE TABLE `tax_order_aggregated_updated`;
ALTER TABLE `sales_order` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS = 1;
The system doesn't allow me to truncate.
TRUNCATE TABLE `Mp_sales_creditmemo`;
TRUNCATE TABLE `Mp_sales_invoice`;
TRUNCATE TABLE `Mp_sales_order`;
TRUNCATE TABLE `Mp_sales_order_address`;
TRUNCATE TABLE `Mp_sales_order_item`;
TRUNCATE TABLE `Mp_sales_order_payment`;
TRUNCATE TABLE `Mp_sales_order_tax`;
TRUNCATE TABLE `Mp_sales_shipment`;
TRUNCATE TABLE `Mp_quote`;
TRUNCATE TABLE `Mp_quote_address`;
TRUNCATE TABLE `Mp_quote_item`;
Still, I can't reset the life time sales of Magento 2 dashboard
magento2 magento-2.1 sales dashboard
edited May 8 at 10:21
Muhammad Wasif
346
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
I have run below-listed queries:
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;
TRUNCATE TABLE `reporting_orders`;
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`;
TRUNCATE TABLE `tax_order_aggregated_created`;
TRUNCATE TABLE `tax_order_aggregated_updated`;
ALTER TABLE `sales_order` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS = 1;
The system doesn't allow me to truncate.
TRUNCATE TABLE `Mp_sales_creditmemo`;
TRUNCATE TABLE `Mp_sales_invoice`;
TRUNCATE TABLE `Mp_sales_order`;
TRUNCATE TABLE `Mp_sales_order_address`;
TRUNCATE TABLE `Mp_sales_order_item`;
TRUNCATE TABLE `Mp_sales_order_payment`;
TRUNCATE TABLE `Mp_sales_order_tax`;
TRUNCATE TABLE `Mp_sales_shipment`;
TRUNCATE TABLE `Mp_quote`;
TRUNCATE TABLE `Mp_quote_address`;
TRUNCATE TABLE `Mp_quote_item`;
Still, I can't reset the life time sales of Magento 2 dashboard
magento2 magento-2.1 sales dashboard
magento2 magento-2.1 sales dashboard
edited May 8 at 10:21
Muhammad Wasif
346
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
edited May 8 at 10:21
Muhammad Wasif
346
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
edited May 8 at 10:21
Muhammad Wasif
346
edited May 8 at 10:21
Muhammad Wasif
346
edited May 8 at 10:21
Muhammad Wasif
346
346
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
asked May 8 at 9:09
Shyam AcharyaShyam Acharya
164
164
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f273800%2fhow-to-reset-life-sales-0-in-magento-dashboard%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f273800%2fhow-to-reset-life-sales-0-in-magento-dashboard%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
