Author Topic: deleting orders and restarting everything  (Read 10613 times)

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
deleting orders and restarting everything
« on: May 16, 2014, 09:37:22 AM »
Hello,
Is it possible to delete old the demo orders which i made for testing purposes so i can start from the beggining?

Thanks

Offline eCommerce Core

  • Administrator
  • Hero Member
  • *****
  • Posts: 1602
  • Karma: +93/-1
    • View Profile
Re: deleting orders and restarting everything
« Reply #1 on: May 16, 2014, 04:30:03 PM »
 You do not have delete icon on the orders grid? :-\
“If you’re in the luckiest one per cent of humanity, you owe it to the rest of humanity to think about the other 99 per cent.”
― Warren Buffett

Offline denagpam

  • Full Member
  • ***
  • Posts: 103
  • Karma: +7/-9
    • View Profile
Re: deleting orders and restarting everything
« Reply #2 on: May 17, 2014, 09:19:34 AM »
Just go to your Admin Dashboard > Sales > Orders
there you can delete your demo order you made before

and you can delete your customers lists by going to your Admin Dashboard > Sales > Customers

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: deleting orders and restarting everything
« Reply #3 on: May 19, 2014, 07:45:07 AM »
what about product purchased reports and pages viewed? how to delete them

Offline denagpam

  • Full Member
  • ***
  • Posts: 103
  • Karma: +7/-9
    • View Profile
Re: deleting orders and restarting everything
« Reply #4 on: May 19, 2014, 10:13:36 AM »
when you delete all orders and customers the purchased product list will automatically be deleted

and for product viewed you can only reset it to zero for all products
« Last Edit: May 19, 2014, 10:15:21 AM by denagpam »

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: deleting orders and restarting everything
« Reply #5 on: May 20, 2014, 03:54:35 PM »
yes this is true but my order counter is not reseted. How to return order number to 1 ?

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1798
  • Karma: +520/-7
    • View Profile
Re: deleting orders and restarting everything
« Reply #6 on: May 20, 2014, 10:29:05 PM »
your invoice number can be set (reset)  in the System > Settings > Checkout   field is Invoice Start No.

That should do it.


Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: deleting orders and restarting everything
« Reply #7 on: May 21, 2014, 04:51:31 AM »
what about order ID. how to restart orde ID ?
please check picture

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1798
  • Karma: +520/-7
    • View Profile
Re: deleting orders and restarting everything
« Reply #8 on: May 21, 2014, 08:59:20 AM »
I believe the order ID you have in your image  is the SAME as the Order Invoice number  (they have just used different terms on different places.   Try changed the the Order Invoice Number and give it a try.



Offline denagpam

  • Full Member
  • ***
  • Posts: 103
  • Karma: +7/-9
    • View Profile
Re: deleting orders and restarting everything
« Reply #9 on: May 21, 2014, 10:41:19 AM »
now can you see what is under the action tab ?

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: deleting orders and restarting everything
« Reply #10 on: May 21, 2014, 11:37:05 AM »
i dont know what you mean?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5777
  • Karma: +274/-2
    • View Profile
Re: deleting orders and restarting everything
« Reply #11 on: May 22, 2014, 05:22:35 AM »
Order ID and Invoice ID are different. Order ID is unique id used in MySql database

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: deleting orders and restarting everything
« Reply #12 on: May 22, 2014, 05:31:33 AM »
i just want to restart order ID to start from 1 again. is it possible and how?

thanks

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5777
  • Karma: +274/-2
    • View Profile
Re: deleting orders and restarting everything
« Reply #13 on: May 22, 2014, 05:36:33 AM »
i just want to restart order ID to start from 1 again. is it possible and how?

thanks

Without cart reinstall you need to work with your database. try this solution

 

Powered by SMFPacks Social Login Mod