Column 1: a list of words or phrases in English or Chinese; there could be spaces or accented characters áéíóú in these
Column 2: a number indicating the dollar value or percent of discount
Column 3: $ or % depending on whether the discount is to be based on amount or percentage
Column 4: expiration date for the voucher code
Insert appropriate entries into the Prestashop database tables (I believe this requires insertions into more than 1 table) to create coupons/vouchers. Database schema for version 1.6 is available here: http://doc.prestashop.com/display/PS16/Fundamentals+of+PrestaShop+Development#FundamentalsofPrestaShopDevelopment-Databaseschema
The data from Column 1 will be the code the customer should input to receive the discount.
So for data:
Jane Doe, 50, %
a customer could input "Jane Doe" as the coupon code and receive a 50% discount on the order.
Many of these codes are generated using customer first names, so it is very possible that the same discount code may be on two different lists of vouchers to be generated, so can we make it so the insert command does not fail if there is a duplicate (i.e., code field should not be unique).