Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default Removing all customers and orders inf from DB

    Hi, I've just recently set up a new website. To avoid work I imported the database from one of my other websites as the new one is selling many of the same products. However in doing so I also brought across all the customer and order information. My question is whats the best way of deleting these customers and their associated orders from the database?

    So far as I can see their is no facility in admin to remove multiple customers or orders so I'm presuming I'll have to do it directly from the DB however I'm not entirely sure what the table structure is to ensure I remove ALL the relevant data from ALL the relevant tables.

    Thanks
    Tony

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Removing all customers and orders inf from DB

    I'm not entirely sure what the table structure is to ensure I remove ALL the relevant data from ALL the relevant tables.
    I then suggest that you do not mess with it
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default Re: Removing all customers and orders inf from DB

    Thanks for the above. But in the meantime if somebody more capable could maybe offer some advice on the structure of the DB or even let me know where the relevant documentation is kept which details the relationships i.e. primary keys then I'll see if I can manage to remove the data without messing it up.

    thanks

  4. #4
    Join Date
    Mar 2010
    Posts
    77
    Plugin Contributions
    0

    Default Re: Removing all customers and orders inf from DB

    Done, db cleaned down

  5. #5
    Join Date
    Apr 2006
    Posts
    413
    Plugin Contributions
    0

    Default Re: Removing all customers and orders inf from DB

    Anyone else wanting to do this for the above reasons can follow this thread (do a db backup first): http://www.zen-cart.com/forum/showthread.php?t=140440 or do it in phpmyadmin.

 

 

Similar Threads

  1. v150 Remove ALL customers and ALL orders before a certain date and reset counter history.
    By hawkwynd in forum Managing Customers and Orders
    Replies: 4
    Last Post: 10 Dec 2013, 03:22 AM
  2. How to remove all customers and previous orders from database?
    By josee225 in forum Managing Customers and Orders
    Replies: 1
    Last Post: 14 Apr 2011, 11:48 PM
  3. Replies: 3
    Last Post: 11 Apr 2011, 05:24 PM
  4. Extract products, orders, and customers from database
    By canemasters in forum General Questions
    Replies: 2
    Last Post: 24 Jan 2008, 06:41 AM
  5. Removing a customer's email from ALL CUSTOMERS
    By davemehta in forum General Questions
    Replies: 3
    Last Post: 7 Nov 2006, 08:37 PM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR