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 Product-Key-Retrieval-Request-Form.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 Product Key Retrieval Request Form is the script: Product-Key-Retrieval-Request.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 last name. The PHP script will ensure that this minimum amount of data gets entered. If it does not, or if the data is faulty, the user will get a message and no key retrieval will occur.

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. This will work for 99+% of customers, but not customers who have more than one email listed in their email field in their MySQL table record. These users will need to contact us with the Customer Form — We Manually Search for Your Key form. The reason for this is that when customers get additional emails listed for them, due to such things as updates that they purchase using a new email address, it fixes things so that Product-Key-Retrieval-Request.php will not function. This isn't much of an issue since it relates only to users who use a new email AND decide to update their product with an upgrade. And if they want the Product-Key-Retrieval-Request.php script to function for the key retrieval, they can simply use the Customer Email Address Change Form form first and then the Product-Key-Retrieval-Request.php WILL work right.

In the script below, the user is prompted for his last name (or the last word in his business name, not counting Inc. or Ltd. or similar words). Then, he is prompted again, this time for his email address: "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."

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 Product-Key-Retrieval-Request-Form.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-top:170px'><h1><b>Product Key Retrieval Request</b></h1></div></center>

<DIV style="position:absolute; top:220px; left:200px; width:750px;">
<P>Thank you for your purchase of Product.<BR><BR>

If you have lost your key for any reason, you may issue a request on this page and an email will be sent to you with your key information.<BR><BR>

The data in our database are updated once each week by Monday morning. If you have just purchased (and lost your key), you will need to <a HREF="lost-their-key-before-Monday.html">contact us</a> or wait until next Monday.

Please enter the following information:</P>

<form method="post" action="Product-Key-Retrieval-Request.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>Last Name = surname, or last word of your business name. Don't include Inc or Ltd, etc. 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'>Last Name</span>: </TD>
<TD><INPUT maxLength=50 name=Last size=30><BR><BR></TD></TR>
<TR>
<TD colspan=2><FONT color=red>*</FONT>What <span style='color:red'>email address</span> did you use when you ordered? If you're not sure, you may enter more than one email address. Separate them with commas, please.<BR> </TD></tr>
<TR>
<TD colspan=2>Email: <INPUT maxLength=255 name=email size=100></TD></tr>
<TR>
<TD><BR><INPUT name="" type=submit value=" Submit Form "><BR><BR></TD>
<TD><BR><INPUT name="" type=reset value=" Reset and Start Over "><BR><BR></TD></TR></TBODY></TABLE></FORM>
</DIV>