Customer Form — We Manually Search for Your Key If You Lost Your Key During the Week You Ordered
The scripts in the two link groups below are Customer Apps for Dealing with Product Keys and Email Addresses, and Administrator Apps for Dealing with Customer Records.
In our ecommerce world, products are sold by many different methods. Amongst these are getting out demos in various ways and when people try them, some of them are very pleased and they buy what's called a key. This unlocks the full feature set of the product when they enter it. There is a need to give the product users limited access to perform a few functions such as changing their emails, retrieving their keys from our database when they misplace them, etc. There is also a need for administrative functions to manage customer records. One needs to sort them, edit them, delete them, add them, view them, search them, register to be an administrator, login as administrator, etc.
If an ecommerce company does not have any of the applications below, it is forced to perform them the 20th century ways—by hand. This means paying for people to answer phones, write emails, keep paper files of customers, etc. The 21st century way is to let software perform these tasks, let websites and videos explain the product features, and let ecommerce close the sale and send the product.
Feel free to use these free Customer Records Management scripts in your business. Note: we know they work well for us (they are well tested), but we assume no liability for how they work in your situation. Similarly, we added lots of security measures such as extensive input filtering, but we make no claims and assume no liability for how securely they work in your situation.
The best security measure to take when using the administrative part of a system like this (meaning the Administrator Apps for Dealing with Customer Records, not the Customer Apps for Dealing with Product Keys and Email Addresses in which category the script below resides) is do not have any links ANYWHERE that link to the URLs of any of the admin files on the server, so neither hackers nor Google finds them. Then use the admin CMS yourself but do not even let your momma use it. Don't even save the link to the admin login as a Favorite, just to be secure. Just stick the login username and password in Roboform and make them impossible to guess. Then use Roboform to logon. The script below, and the other Customer Apps, are included online and linked to as part of the product web pages that make life easier for everyone. Their security is mainly handled via extreme input filtering. The Admin Apps are hidden, unlinked to, and well protected with security measures, password hashes and salts, etc.
This script is called lost-their-key-before-Monday.html
Customer Apps for Dealing with Product Keys and Email Addresses
- Customer Email Address Change Form
- Customer Email Address Change Form PHP Script
- Customer Product Key Retrieval Request Form
- Customer Product Key Retrieval Request Form PHP Script
- Customer Form — We Manually Search for Your Key If You Lost Your Key During the Week You Ordered
- Customer Form — We Manually Search for Your Key If You Lost Your Key During the Week You Ordered PHP Script
- Customer Form — We Manually Search for Your Key
- Customer Form — We Manually Search for Your Key PHP Script
Administrator Apps for Dealing with Customer Records
- Customer Records Management PHP Script
- Sort Customer Records by Name PHP Script
- Sort Customer Records by Email PHP Script
- Add Customer Records PHP Script
- Delete Customer Records PHP Script
- Edit Customer Records PHP Script
- View Customer Records PHP Script
- Login to Customer Records Management PHP Script
- Logout of Customer Records Management PHP Script
- Register with Captcha to Administer Customer Records PHP Script
- Register with Captcha to Administer Customer Records PHP Captcha Script
- Check ID for Customer Records Management PHP Script
- Display Emails and Names (for spreadsheet use) PHP Script
The form action in Customer Form — We Manually Search for Your Key If You Lost Your Key During the Week You Ordered is the script: lost-their-key-before-Monday.php. That script processes the data which the user enters in the form on this page. Note that in order to get a product key emailed to them, the users must enter not only the email address, but also their other data. The PHP script will filter the data that gets entered. The "before Monday" stuff is because we enter into the MySQL db new user data like keys every Monday from accumulated orders over the week. You may do it daily if you wish. But if you do it less than weekly, users that use the various user forms about getting keys or changing email addresses will have problems and will create difficulties for the administrator.
If a user is not sure of the email address that was used when the product key was purchased, the user may try several emails, separated by commas. The user will see this when entering email addresses: MAKE SURE THE FIRST ONE IS YOUR CURRENT EMAIL ADDRESS. The first one will be used as the response email for sending a key.
In the script below, the user is prompted for a lot of data. The more he inputs, the better the chance the people searching the database for his record will strike paydirt.
The reason the key for the product will not be conveniently displayed on the screen, but instead emailed to the user's email address is safety. Just because someone knows the email address of a person who he knows owns the Product does not mean we wish to show a key to him onscreen. By emailing it to what we know is a legitimate email address of a legitimate customer, no harm is done if he gets his key again even though he did not request it.
This script is called lost-their-key-before-Monday.html
THE NAVIGATION SCRIPT HAS BEEN OMITTED, AS IT WAS SPECIFIC TO A SPECIFIC COMPANY AND NOT USEFUL TO THIS SCRIPT FOR GENERAL PURPOSES. IF YOU NEED TO LEARN ABOUT NAVIGATION SCRIPTS, SEARCH OUR SITE AND OTHERS.
<center><div style='margin:170px 0 0 170px'><h1><b>We Manually Search for Your Key if you lost your key during the week you ordered</b></h1></div></center>
<DIV style="position:absolute; top:270px; left:200px; width:750px;">
<P>I have been unable to find my product key.<BR>
Please re-send the key you sent.<BR>
Here is what I know:<BR><BR></P>
<form method="post" action="lost-their-key-before-Monday.php">
<TBODY>
<TR>
<TD align=middle colSpan=2><FONT color=red>*</FONT> Indicates Required fields.<BR><BR>
</TD></TR>
<tr><td align=middle colSpan=2>Do not use any accent characters or punctuation when entering your name [grave, accent, umlaut, tilde] or Mr. Ms. Sr. Jr. or other prefixes or suffixes.<BR></td></tr>
<TR><TD align=right><FONT color=red>*</FONT> <span style='color:red'>First Name</span>: </TD>
<TD><INPUT maxLength=30 name=First size=30><BR><BR></TD></TR>
<TR><TD align=right><FONT color=red>*</FONT> <span style='color:red'>Last Name</span>: </TD>
<TD><INPUT maxLength=30 name=Last size=30><BR><BR></TD></TR>
<tr><td align=middle colSpan=2>Business name. Don't include Inc or Ltd, etc.<BR></td></tr>
<TR><TD colspan=2>Business name: <INPUT maxLength=99 name=bizname size=99><BR><BR></TD></tr>
<TR><TD colspan=2><FONT color=red>*</FONT>What is your current <span style='color:red'>email address</span> and what email address did you use when you ordered? If you're not sure, you may enter more than one email address. Separate them with commas, please. MAKE SURE THE FIRST ONE IS YOUR CURRENT EMAIL ADDRESS.<BR></TD></tr>
<TR><TD colspan=2>Email: <INPUT maxLength=255 name=email size=99><BR><BR></TD></tr>
<TR><TD colspan=2>Phone number on your order: <INPUT maxLength=20 name=phone size=20><BR><BR></TD></tr>
<TR><TD colspan=2>Street: <INPUT maxLength=30 name=street size=30><BR><BR></TD></tr>
<TR><TD colspan=2>City: <INPUT maxLength=35 name=city size=35><BR><BR></TD></tr>
<tr><td colspan=2>State:<BR> <select name="state" size='4'>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AZ">Arizona</option>
<option value="AR">Arkansas</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DE">Delaware</option>
<option value="DC">District of Columbia</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="IA">Iowa</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="ME">Maine</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>
<option value="NV">Nevada</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NY">New York</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="RI">Rhode Island</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>
<option value="VA">Virginia</option>
<option value="WA">Washington</option>
<option value="WV">West Virginia</option>
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
</select><BR><BR></td></tr>
<TR><TD colspan=2>Zip code: <INPUT maxLength=5 name=zip size=5><BR><BR></TD></tr>
<TR><TD colspan=2>Order number: <INPUT maxLength=30 name=ordernumber size=30><BR><BR></TD></tr>
<TR><TD colspan=2><FONT color=red>*</FONT><span style='color:red'>Approximate date</span> I ordered the program (look at the date of your install directory and dates on your earliest product files for some hints)<BR></TD></tr>
<TR><TD colspan=2>Date: <INPUT maxLength=20 name=date size=20><BR><BR></TD></tr>
<TR><TD><BR><INPUT name="submit" type=submit value=" Submit Form "><BR><BR></TD>
<TD><BR><INPUT name="reset" type=reset value=" Reset and Start Over "><BR><BR></TD></TR></TBODY></TABLE></FORM>
</DIV>