http://helpnotes.vpcart.com

The pin number enhancement will do the following:

1. At the end of an order, a pin number is looked up for
each product purchase and e-mailed to the customer.
Each product can have their own set of pin numbers.

2. Pin Numbers are included in the merchant confirmation

3. When Pin numbers reach a low level, a warning is sent
to the merchant

4. When Pin Numbers reach a critical level another warning
is sent to the merchant

5. Validates that payment is made according to your
specification before pin numbers are sent

- shoppinformat.asp
- shoppinnumbers.asp
- admin\shopa_pinadmin.asp
- admin\shopa_pincodes.asp
- admin\shopa_pinorder.asp
- admin\shopa_pinreport.asp
- admin\shoppinformat.asp
- admin]help\shoph_pincodes.asp
- admin]help\shoph_pinorder.asp
- templates\default\tmp_pincustomer.txt
- templates\default\tmp_pinorderfail.txt
- templates\default\tmp_pinproduct.txt

* If you DO NOT made any changes to the above files, please ignore below section.

***********************************************************************************

If you HAVE made significant changes to your above files,
then please use winmerge to compare your codes.

To do this, please follow these steps.

1. Download a program called WinMerge (http://winmerge.sourceforge.net/), which will allow you to compare your files with those in the patch.

2. Unzip the patch files to a folder on your computer

4. Download the files included in the patch from your live site into another folder on your computer.

5. Run WinMerge and compare the contents of 2 folders.

6. Save the patched files.

7. Back up the files to be patched on the server.

8. Upload the patched files to your server

9. Test your site to ensure there have been no problems.

***********************************************************************************

2. Upload all the files into your shopping cart folder.

3. The Pin Number enhancement requires the VP-ASP Option Package.

4. New Shop Configuration

xpinnumber=Yes Turns on Pin Number Handling
xpinnumberlowlimit Set limit for Low Pin Number Merchant message
xpinproductmatch=CatalogId The default field to match in products table

Used to generate Pin Number confirmation email
xpinproductTemplate tmp_pinproduct.txt 'contains format for customer details
xpincustomerTemplate tmp_pincustomer.txt 'contains format for Pin Number display in email

-The two files are merged to create a single confirmation email.

Pin numbers will only be sent if a valid payment has been made.
In the Shop Configuration you need to set:
xendofordervalidpayments to include the valid payment type for a pin number
to be sent in the email.

NONE

NONE

NONE

2016.02.01 - Enhancement: Must always commit transaction if execute sql execute
2017.04.27 - Better handling on creating new records on huge tables
2018.04.26 - Compatible with v9