netwise Posted August 14, 2016 Report 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...
Michael Posted August 14, 2016 Report Posted August 14, 2016 Only by deleting everything and re-installing.
netwise Posted August 14, 2016 Author Report 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...
Michael Posted August 14, 2016 Report 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;
Paul Posted August 16, 2016 Report 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.
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now