We have a Joomla website that we want to run several competitions on.
The Easy Bit:
I need a webpage at the front end to collect the customers information and add it to a sql database (hosted online ie mysqladmin).
The Messy Bit:
The database needs to know when an individual attempts to add themselves to the draw a second time and block it.
Although due to the law in our country, we need the customer to tick a box so we can send them promotional information so if they don't tick the box the first time and do the second, we want the system to correct that.
We will have several draws throughout the year and we have several store locations. Sometimes the draws will be nationwide and sometimes they will be store specific. We need an option to add customers to several locations should they wish to receive information from more than one store but we do not want to duplicate the customer listing. We don't want a login type system so the email addresses will be the primary key.
Customers can join as many draws as they like but they can only enter each on once.
In the CRM area of Joomla we need a tool that can be used by non IT Marketing Staff to choose a store and either send them all a bcc email with a promotion or compile a list of phone numbers in excel and/or CSV format so the promotion can be bulk SMSed to the customers. The SMS bulk provider we are looking at is [url removed, login to view] and if it can be added to the CRM it would be a bonus but, is likely to be the deciding factor as to which freelancer we go with.
8 freelancers are bidding on average €250 for this job
Hi, Consider its done! I would love to get this opportunity of working with you. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Thanks
6 Years in Joomla- 225 completed Projects - 140 Satisfied Client - 86 countries - 5 Star ratings on Freelancer/Elance. Still going strong, please check your Inbox for my message - Regards, Derick Rethans