Voucher Code Use Case | Community
Skip to main content
vipinm26716250
vipinm26716250
Level 2
October 12, 2017
Solved

Voucher Code Use Case

  • October 12, 2017
  • 5 replies
  • 4029 views

Hi all ,

I have a use case in my organization where i have a .csv file with one column "voucherCode" having 50000 codes .

Now i want to send one voucher code to one user in an email template along with other HTML content .

1. One Voucher can be used once .

2. There is no recipient - voucher mapping .

3. Any voucher can go to any qualified user .

Please guide me .

Feel free to ask questions .

Regards,

Vipin

+919015631285

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by vipinm26716250

    Hi All ,

    I am able to solve this use case ,

    I have added one voucherid in the Query activity that is used to fetch vouchers from voucher table . Secondly i have added one new column with same name voucherid (usingRowId () function) in enrichment activity and finally took an intersection of two transitions with same voucher id column .

    Regards,

    Vipin

    5 replies

    florentlb
    florentlb
    Level 10
    October 18, 2017

    Hi Vipin,

    Interesting use case! Do you plan on doing this one time only or could the same or remaining codes be reused later?

    Will you do some specific targeting as well or can any recipient of the database get a code?

    What prevents you from using the same code 50000 times? Or from generating a unique code for all recipients from Campaign? (For example a base code like "OCTOBER17" concatenated with a unique ID).

    Let me know more about your use case,

    Florent

      florentlb
      florentlb
      Level 10
      October 31, 2017

      Hi Vipin,

      Were you able to find a way to do it? Otherwise please let me know the details asked just above and I'll try to find if there is a way.

      Florent

      vipinm26716250
      vipinm26716250Author
      Level 2
      November 5, 2017

      Thanks Florent .

      Apologies for the delayed response .

      1. We are planning to use this for one time only and remaining will be given back to client as unused marked .

      2. We will definitely filter recipients on some filters like people purchasing some items will get this voucher .

      3. Voucher code will be provided by client so that it can be used while booking on the website . This is something will be given to us in a flat file .

      Please find above some of the answers to your question .

      Basically we have a workflow running that send email to some set of people after proper segmentation . Now , client wants to include one user one voucher code from a flat file (To be provided by client) .

      Regards,

      Vipin

      florentlb
      florentlb
      Level 10
      November 30, 2017

      Hi Vipin,

      The difficulty here is that it seems there is no way to reconcile the voucher codes to specific recipients. My best guess would be to load the voucher file and to use some JavaScript to populate a custom field of the nms:recipients table for the recipients that you have targeted. But I'm no expert in JS so I'm not sure I can help you with this specific step.

      Florent

      vipinm26716250
      vipinm26716250AuthorAccepted solution
      Level 2
      December 19, 2017

      Hi All ,

      I am able to solve this use case ,

      I have added one voucherid in the Query activity that is used to fetch vouchers from voucher table . Secondly i have added one new column with same name voucherid (usingRowId () function) in enrichment activity and finally took an intersection of two transitions with same voucher id column .

      Regards,

      Vipin

        Terms & ConditionsAccessibility statement

        Loading footer...