netwise Posted August 14, 2016 Report Share Posted August 14, 2016 Is there a way to wipe everyting from my install with the exception of customers?? I want to wipe all transactions .. everything but customers... and honestly they can go too if necessary... Quote Link to comment Share on other sites More sharing options...
Michael Posted August 14, 2016 Report Share Posted August 14, 2016 Only by deleting everything and re-installing. Quote Link to comment Share on other sites More sharing options...
netwise Posted August 14, 2016 Author Report Share Posted August 14, 2016 3 minutes ago, Licensecart said: Only by deleting everything and re-installing. there MUST be a way to dump data.. its based on a sql database... Quote Link to comment Share on other sites More sharing options...
Michael Posted August 14, 2016 Report Share Posted August 14, 2016 6 minutes ago, netwise said: there MUST be a way to dump data.. its based on a sql database... You can get a csv report but that's it but that's not removing everything but the customers. Billing > Reports > Customize: Query: SELECT * FROM contacts Or get customers with their number Query: SELECT contacts.client_id, contacts.first_name, contacts.last_name, contacts.email, contacts.address1, contacts.city, contacts.zip, contacts.country, contact_numbers.number FROM contacts INNER JOIN contact_numbers ON contacts.client_id=contact_numbers.contact_id ORDER BY contacts.client_id; Quote Link to comment Share on other sites More sharing options...
Paul Posted August 16, 2016 Report Share Posted August 16, 2016 You would need to write a query to perform the action on MySQL directly, but you need to be careful to also remove any related records. We don't recommend it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.