• This interface allows adding new gift vouchers in bulk quantity at a stretch. All you need to do is to download the ‘BulkVoucherUpload.xlsx’ from ‘Bulk Voucher Download’ interface, update voucher information and upload that file here.

How do I upload the gift vouchers in a bulk quantity?


To upload the gift vouchers in a bulk quantity, do the following:

  • Log in to the 'MartJack Control Panel' by using your User Name (Email Address) and Password.


 Bulk Gift Voucher

  • You will be navigated to the Dashboard page.


 Bulk Gift Voucher

  • Click the  Bulk Gift Voucher icon. The Marketing section will be displayed as shown in the figure.


 Bulk Gift Voucher

  • Click Bulk Gift Voucher. You will be navigated to the Bulk Voucher Upload page.


 Bulk Gift Voucher

  • To download the default format for the bulk gift voucher Excel, click the Click Here link. The BulkVoucherEmpty.xlsx file will be downloaded. Double-click the BulkVoucherEmpty.xlsx file, and it will be opened as mentioned below:


 Bulk Gift Voucher

  • Enter the respective voucher details in the Sheet1 as mentioned below:
    • Note: You can refer the Sheet2 for the field information.
    • Enter the campaign id in the Campain ID field.
  • How to get the 'Campain ID'?:


 Bulk Gift Voucher

  • Note: To get the campaign id of a gift voucher campaign, click the respective campaign title in the Gift Voucher Campaigns page. You will be navigated to the Add/Edit Gift Voucher Campaign page.


 Bulk Gift Voucher

  • The value of the cid mentioned in the URL of the Add/Edit Gift Voucher Campaign page will be the campaign id (Example: 72628 is the campaign id for the Biba_Test_Voucher campaign as shown in the figure)
  • Enter the respective code (as mentioned below) for the type of user in the User Type field.
    • Note:
      • R - Registered User
      • U - Unregistered User(i.e. Non-registered user)
      • G - User Group
  • Enter the user group id in the case the voucher is applied to a user group in the User Group ID field.
  • How to get the 'User Group ID'?:


 Bulk Gift Voucher

  • Note: To get the user group id of a user group, click the respective group name in the View User Groups page. You will be navigated to the User Profile page.


 Bulk Gift Voucher

  • The value of the GroupId mentioned in the URL of the User Profile page will be the user group id (Example: 9078 is the user group id for the Fav Gp user group as shown in the figure)
Enter the username in the case the voucher is applied to a registered user in the User Name field.
Enter the code of the gift voucher in the Voucher Code field.
  • Note: The length of the voucher code should be a minimum of 4 characters.
Enter the amount of the gift voucher in the Voucher Amount field.
Enter the maximum permissible number of times a user can use this voucher in the Number of uses per User field.
  • Note:
    • In the case of unlimited times of usage, enter '-1'
Enter the maximum permissible number of times a voucher can be used in the Number of uses per Voucher field.
  • Note:
    • This field is to be filled in the case of a non-registered user.
    • This option will help to cap the maximum number of uses of a voucher code. For example, a non-registered user may send the voucher code to his/her friends or the same user may use the voucher with different usernames, or you may create a single voucher and send the same to all non-registered users. Then if this capping is not there, it may cause huge losses due to the unlimited number of uses of the voucher.
    • In the case of unlimited times of usage, enter '-1'
Enter the date of the voucher in the DD/MM/YYYY format in the Voucher Date field.
Enter the date of activation for the voucher in the DD/MM/YYYY format in the Voucher Activation Date field.
  • Note: This field is to be filled when the Validity Type for the respective voucher campaign is selected as Periodic.
Enter the PIN for the voucher in the PIN field.
  • Note:
    • The PIN should be of at least a four-digit numeric or alphanumeric
    • The PIN will be working only when the Enable PIN authentication checkbox is selected in the Application Settings » Define Checkout Settings page.
      Please Refer: Enable Gift Voucher Payment And Its Pin Authentication
Enter the remarks for the voucher in the Remarks field.
Save the Excel.
Click Browse in the Bulk Voucher Upload page. In the case of the Chrome, an Open popup is displayed and in the case of the Mozilla, a File Upload popup is displayed.


 Bulk Gift Voucher

  • Select the updated BulkVoucherEmpty.xlsx file and click Open. The respective popup will be closed and the name of the selected file will be displayed in the Upload a file text box.


 Bulk Gift Voucher

  • Click Upload. The BulkVoucherEmpty.xlsx file will be uploaded and the upload status will be displayed under the Task History section in the run-time.


 Bulk Gift Voucher

  • In the case of any failures in the upload, you can find a  Bulk Gift Voucher icon under the Actions column. Click the  Bulk Gift Voucher icon, you will be navigated to the Error Logs Summary page.


 Bulk Gift Voucher

  • Rectify the errors and upload the file again.
  • You can also download the uploaded file by clicking the respective  Bulk Gift Voucher icon under the Actions column in the Task History section.
  • You can also delete an uploaded task history by clicking the respective  Bulk Gift Voucher icon under the Actions column in the Task History section.