System wipe

[netwise]

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]

Only by deleting everything and re-installing.

[netwise]

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]

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]

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.