I'm looking for a custom design to easily list, manage, and distribute pins (like prepaid phone cards) in database. On the backend, I need the following:
1. To be able to easily upload (add/remove/update) Pin #'s into the system- in bulk and individually. The pin numbers that I will be working with will be 12-digit pins.
2. Need to track pin #'s sold and then mark them as sold so that they are not re-sold.
3. Pin # stored in a Triple-DES encrypted table & counted with real-time inventory control. And with the ability to send e-mails to the admin when pin categories reach certain adjustable levels of inventory.
4. The ability to manually set purchase maximums.
5. 2-way pin delivery triggered by a successfully processed Pay-Pay payment. With pin(s) being returned to the screen instantly w/ payment approval in invoice form and w/ pin(s) being sent to customer's e-mail address that they enter manually during checkout.
6. Want customer to be able to log back in to see their previous purchases.
7. Need to be able to run reports such as quantity of each type of pin sold from (date) to (date), or the amount of $$ taken in between (date) and (date), etc...
As for the front end, I need two parts -- One for consumers and another for dealers.
Consumers:
1. Customer login
2. Choose plan (customer can only buy 1 plan at a time. they can also purchase a cash pin at that time as well)
3. Check-out -- Pay Pal
4. Upon payment approval, pin is extracted from database & sent to screen & e-mail.
5. Customer pushes "next" button at bottom of page which opens up a "load pin" page (already have scripts)...
Dealers:
1. Need to be able to set up different pricing teirs that are triggered by their assigned login info. I want to be able to manually assign the passwords for the individual dealers.
2. Dealers can order multiple pins at one time.
3. After approval of c.c. transaction, pins will be sent to a) e-mail address entered upon checkout and b) to the screen in invoice form w/ print option.
I would like to see a similar demo before you start (I need proof that you can really handle this project). Ease of use is very important. I'm hoping for a quick turn around on this project. Security is a top priority! Specific postings only please.