Customer database software for retail shop?
Customer database software for retail shop?
Author
Discussion

extraT

Original Poster:

1,876 posts

181 months

Tuesday 1st January 2019
quotequote all
Hello all

Just wondering if someone can point me in the direction of a database/CRM? software.

Actually what I need is quiet basic: input customers name, email address and track monthly/ yearly spend.

In reality, it will be used to run a loyalty scheme and encourage people to sign up for a newsletter/email shot.

Eventually newsletters will be sent using mail chimp

Any suggestions I could like at?

Thank you

ET

Troubleatmill

10,210 posts

190 months

Australiam

277 posts

160 months

Wednesday 2nd January 2019
quotequote all

akirk

5,778 posts

145 months

Wednesday 2nd January 2019
quotequote all
If that is really all you need - could you not simply use an excel spreadsheet?
you can import from Excel to mailchimp etc. for newsletters

Jinx

12,023 posts

291 months

Wednesday 2nd January 2019
quotequote all
BenjiS said:
A single Salesforce Essentials Sales Cloud account would do the trick for minimal outlay but with massive scope to grow in both size and functionality and cost if you want
https://www.salesforce.com/uk/editions-pricing/sal...
FTFY

wink

Some other suggestions here https://blog.capterra.com/free-and-open-source-crm...

Bikerjon

2,211 posts

192 months

Wednesday 2nd January 2019
quotequote all
I don't have a product in mind but as it's a shop and you're looking to track monthly spend it sounds like something that might be better suited to a point of sale system rather than traditional CRM software.

Penelope Stopit

11,209 posts

140 months

Thursday 3rd January 2019
quotequote all
akirk said:
If that is really all you need - could you not simply use an excel spreadsheet?
you can import from Excel to mailchimp etc. for newsletters
This

Ynox

1,755 posts

210 months

Tuesday 8th January 2019
quotequote all
It may be worth using something a bit more advanced than just a spreadsheet, if nothing else for GDPR support.

akirk

5,778 posts

145 months

Tuesday 8th January 2019
quotequote all
Ynox said:
It may be worth using something a bit more advanced than just a spreadsheet, if nothing else for GDPR support.
??? smile

if all someone needs is a list of name / email / address / annualised spend - then there is probably little point in wasting huge amounts of time with complex systems when a spreadsheet will do the job...

not quite sure how GDPR affects that - if you need to record GDPR permission - simply add a column!

Ynox

1,755 posts

210 months

Wednesday 9th January 2019
quotequote all
I was more thinking of it allowing for a nice integration with Mailchimp if someone opts out from receiving emails etc.

Yep, completely overkill, but it's one area where maybe something slightly more complex than a spreadsheet may be the way to go.

Sixpackpert

5,370 posts

245 months

Wednesday 9th January 2019
quotequote all
akirk said:
not quite sure how GDPR affects that - if you need to record GDPR permission - simply add a column!
It's a bit more involved than that...

akirk

5,778 posts

145 months

Wednesday 9th January 2019
quotequote all
Ynox said:
I was more thinking of it allowing for a nice integration with Mailchimp if someone opts out from receiving emails etc.

Yep, completely overkill, but it's one area where maybe something slightly more complex than a spreadsheet may be the way to go.
True - but I would be tempted to use MailChimp for that aspect - it is pretty good at managing opt outs etc.
I think that sometimes people are persuaded into far more complex solutions than are needed - which can have a time and cash cost for a business

Bikerjon

2,211 posts

192 months

Wednesday 9th January 2019
quotequote all
I'm all for keeping things simple, but is manually updating a spreadsheet in a retail environment a realistic option?

Sixpackpert

5,370 posts

245 months

Wednesday 9th January 2019
quotequote all
Bikerjon said:
I'm all for keeping things simple, but is manually updating a spreadsheet in a retail environment a realistic option?
Is the spreadsheet password protected? Where is it stored? Is the computer/server that it is on encrypted? Who has access to it? What processes do you have in place for a data breach? What processes do you have if someone wants access to the data held on them? GDPR is not just about your customers, it is also about how you store your employees data, something many people do not understand.

A spreadsheet would probably be okay as long as you can show that the data on it is safe from theft or abuse. If you were investigated just saying that the computer is password protected would not fly.

Edited by Sixpackpert on Wednesday 9th January 20:27