Create Shipping Method for Vouchers

To create your own shipping method that only applies when one or more gift vouchers are ordered, the following steps are necessary:

1. Insert extended SQL query
   Go to Configuration → Basic settings → Frontend → Shipping costs module. Add the following text after the last character of the line Advanced SQL query:

   ,MIN(IFNULL(at.viison_coupon, 0)) AS allviisoncoupon

2. Edit all existing shipping types
   Next, all existing shipping types must be edited under Configuration → Shipping costs. To do this, add the following text in the Advanced configuration tab of the shipping type in the Terms field:

   !allviisoncoupon
   

3. Create new voucher shipping method
   Finally, create a shipping method that only applies when only one or more vouchers are ordered. In the Advanced configuration tab, enter the following text in the Terms field:
   

   allviisoncoupon