We are using CS-Cart version 4.10.3 and we need a solution that allows exporting the SQL database into a CSV file allowing it to be modified in MS Access or similar software. Ones the data has been modified in MS Access for example we want to then import it back into the SQL DB allowing the changes to transfer on the server.
We need a solution that would allow export of all available information but depending on what we are attempting to achieve with the data we may only need certain parts so an ability to filter or exclude data sets depending on the purpose of the data.
For example: allocation of users groups to customer accounts based on their purchased products (order history).
I would have to assume this is a common problem and wonder if anyone has a existing solution for this available?