Storing PIN codes in the database

If you select the 'Database' (Figure 9) option, PIN codes are stored in the database and retrieved from there when the status of a relevant order is converted into 'Processed' or 'Completed' and an e-mail message with the PIN code is sent to a customer. In order to be utilized, the PIN code must be 'Enabled' and 'Available for sale'. Once the PIN code is used, its utilization status is changed to 'Sold'.

To keep track of the amount of available PIN codes in the database, specify the critical amount of PIN codes in the 'Notify the store administrator when amount of available PIN codes in the database reaches the following minimum' field and click on the 'Update' button to save this parameter. Whenever the amount of available PIN codes drops below the critical amount, an e-mail notification is sent to the store administrator.

You can input PIN codes either by typing them in manually or using the 'Import PIN codes' functionality (see the 'Importing PIN codes' section of this manual for more details on the second option). To create a new PIN code, under the 'Add new PIN code' subtitle type in the PIN code, specify its status and click on the 'Add' button to save the new PIN code to the database.

Figure 9: Manual entry of product PIN codes

You can review the list of PIN codes in the database in the 'Available PIN codes' sub-section (Figure 10). The list shows the PIN codes, their statuses and assisting information. You have full control over the statuses of the PIN codes. Place checkmarks against the PIN codes you want to modify and then click on:

Figure 10: Managing available PIN codes