Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    7
    Plugin Contributions
    0

    Default Delete only orders

    Hi folks,

    I run a ski club and my orders are actually weekly ski trips. I would like to just delete all of last season's orders. If there has been information on this before, please direct me there.

    My idea is to go into the database and empty the tables pertaining to "orders" and then reset the auto increment numbers back to 1.

    Are there other files that I would need to empty as well or would this work?

    Thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    60,240
    Blog Entries
    4
    Plugin Contributions
    139

    Default Re: Delete only orders

    How many orders are you talking about?
    Is deleting them one-by-one a suitable solution ... by using the Delete button in your Admin? That is the safest and most efficient way.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.



  3. #3
    Join Date
    Dec 2011
    Posts
    7
    Plugin Contributions
    0

    Default Re: Delete only orders

    The orders total table has over 6,000. The orders table is over 2,000.

  4. #4
    Join Date
    Jan 2004
    Posts
    60,240
    Blog Entries
    4
    Plugin Contributions
    139

    Default Re: Delete only orders

    There are SEVERAL tables involved in storing order data.
    When you do a delete using the admin controls, it properly deletes related records from all affected tables. Hence the suggestion to use that method.

    If you intend to do a mass delete using some other method, MAKE SURE YOU KNOW WHAT YOU ARE DOING and start with good reliable backups.
    Related reading for advanced use only: http://www.zen-cart.com/wiki/index.p...#Order_History
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.



 

 

Similar Threads

  1. Disable "DELETE" - Make certain admin users not able to delete orders
    By vetpro in forum Managing Customers and Orders
    Replies: 0
    Last Post: 12 Nov 2011, 02:01 PM
  2. Set all Processing orders to Delivered? Or delete all orders?
    By Brian1234 in forum Managing Customers and Orders
    Replies: 11
    Last Post: 29 Jun 2011, 10:04 PM
  3. Can I set up the store to take orders from US orders only?
    By CueTable in forum Managing Customers and Orders
    Replies: 3
    Last Post: 28 May 2009, 07:03 AM
  4. Customer orders - Delete
    By jmknash in forum General Questions
    Replies: 2
    Last Post: 8 May 2008, 05:16 PM
  5. Delete or reset Pending Orders?
    By atomage in forum General Questions
    Replies: 1
    Last Post: 29 Nov 2006, 02:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •