We have started a customer loyalty programme, and currently have about 3500 people signed up, with more joining every day. At the moment, customers are signing up on our website (we use [login to view URL] for the signup and data capturing) we then manually allocate them a membership number and email them.
As they make purchases they accumulate loyalty points which they can spend later with us.
I want to streamline the system. We need a database that works as follows:
- Users sign up on our website or in person. We capture their information manually into a database front end or import a batch from a CSV file
- We should be able to search the database at any time, across a number of fields (usual type fields - name, address, phone, membership number etc)
- We should be able to add in loyalty points for each member - again either one by one or manually uploading a CSV file
- As they spend their points we should be able to adjust their current points balance. The database should keep a record of each credit/debit transaction
- We should be able to generate reports from the database, selecting which fields we want included in the report
- We should be able to export all or part of the database into a CSV file
Some of us use Macs which means we can't use Microsoft Access. We do have a shared hard drive on our network on which a database can "live" (its a windows server).
We don't store any sensitive information like credit card details or passwords, so we don't need major security. And the database can be hosted online if that's easier.
We need a simple, elegant solution here please!