Edit existing code to match up a primary key in two tables

I have an AlstraSoft Daily Deal (PHP) software website. I need to be able to send a file(s) to merchants so that they can upload the file(s) containing passwords from deal vouchers that have been purchased. There appears to be a link missing somewhere between the voucher code numbers (sixteen digit numbers preceded by "#"), and the passwords (six capital letters) and numbers (8) on my site's vouchers. The problem is, for example, that merchants want to download a file(s) containing some sort of passwords indicating that a customer has purchased a deal. We were able to send a file(s) to indicate the (sixteen digit) voucher codes, but we can not find any preknown file(s) for the passwords and the numbers on the vouchers (which are the only items which show up to customers). We need to be able to supply the merchants with files containing the passwords and/or numbers which the customers will see on their vouchers so that they can input the password and/or numbers shown on their vouchers on the merchants' site to prove that they have made a purchase so that they can receive the merchants' goods or services. After this is accomplished, use the excel spreadsheet to compose 4 files of 500 each, titled Monday Night Cruise GA at $12 ea., Monday Night Cruise for Two GA at $19, Tuesday Night Cruise GA at $15 and Tuesday Night Cruise for Two at $25.