How can I reset to zero the dashboard stats without deleting orders.

truncate table sales_flat_order;

truncate table sales_order_tax; truncate table downloadable_link_purchased;

delete from eav_entity_store WHERE entity_type_id in ( select entity_type_id FROM eav_entity_type WHERE entity_type_code in ('order', 'invoice', 'creditmemo', 'shipment') );

enter image description here Thank you, Elvis

  • please refer the below mention site. gist.github.com/mystix/5360885. In this very useful for reset Magento admin Dashboard data(like Last 5 Search Terms, Top 5 Search Terms) – Sankar_k Dec 9 '16 at 7:45
  • Thank you @Sankar_k How can I reset Lifetime Sales and Average Orders without deleting orders? – Elvis Dec 13 '16 at 19:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.