Expand my Community achievements bar.

SOLVED

How to add offer codes to delivery form Java script code.

Avatar

Level 2

Dear Community Leaders:

 

I have some offer codes like those below; they are unique (exp: 100 targeted customers, 100 unique coupons). I want to add these offer codes to delivery through a Java script. Is it possible to add these codes to delivery? Can you please help me with this?

 

Sathyam_Chandan_0-1701893522509.png

 

 

 

Regards

Sathyam

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @Sathyam_Chandan 

 

You can assign these coupons to targeted customers via enrichment activity. No JavaScript is required.

 

I am assuming you have these coupons in a file. If that is the case then you can upload the file via file upload activity and keep the line number in both activities for linking.

 

Add this to query activity:

Manoj_Kumar__0-1701902532585.png

 

and in the data loading activity check the checkbox

Manoj_Kumar__1-1701902566822.png

 

Then use these columns to create 1:1 join via enrichment.

 


     Manoj
     Find me on LinkedIn

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

Hello @Sathyam_Chandan 

 

You can assign these coupons to targeted customers via enrichment activity. No JavaScript is required.

 

I am assuming you have these coupons in a file. If that is the case then you can upload the file via file upload activity and keep the line number in both activities for linking.

 

Add this to query activity:

Manoj_Kumar__0-1701902532585.png

 

and in the data loading activity check the checkbox

Manoj_Kumar__1-1701902566822.png

 

Then use these columns to create 1:1 join via enrichment.

 


     Manoj
     Find me on LinkedIn

Avatar

Community Advisor

Hi @Sathyam_Chandan ,

You can also utilize coupon management to solve this.

Refer coupon management document

Create a 'Individual' type coupon and import the coupon values in it using a import workflow and configure this coupon in delivery (configuration steps mentioned in above document).

Avatar

Level 2

HI @ParthaSarathy 

 

I have also tried through coupon management. but codes are not updated in the coupon values.

 

1) 

Sathyam_Chandan_0-1701980493923.png

 

2)

Sathyam_Chandan_1-1701980535638.png

 

3)

Sathyam_Chandan_2-1701980559373.png

 

4)

Sathyam_Chandan_3-1701980592350.png

 

5)

Sathyam_Chandan_4-1701980630009.png

 

6)

Sathyam_Chandan_5-1701980680990.png

 

7)

Sathyam_Chandan_6-1701980712789.png

 

Sathyam_Chandan_7-1701980733217.png

 

Regards

Satyam

 

 

Avatar

Level 2

Hi @_Manoj_Kumar_ ,

 

Can you please help with the workflow setup?

 

1. I have uploaded all the coupons to the file upload activity and selected line number

2. I have selected the target from the query activity and add RowNum() in the complementary information section.

 

But I am getting the below error.

 

Sathyam_Chandan_0-1701977804191.png

 

Sathyam_Chandan_2-1701978002101.png

 

Sathyam_Chandan_3-1701978029252.png

 

 

 

Sathyam_Chandan_1-1701977847652.png

 

Please help me how to setup workflow.

 

Regards

@Sathyam_Chandan 

 

Avatar

Community Advisor

Hello @Sathyam_Chandan 

 

Try replacing RowNum() with RowId() and it should work.


     Manoj
     Find me on LinkedIn

Avatar

Level 2

Hi @_Manoj_Kumar_ ,

 

Thank you for your help. It is working fine, but I am having some issues with enrichment.

 

Sathyam_Chandan_0-1702047126731.png

Reconciliation 

Sathyam_Chandan_1-1702047145820.png

 

Personalization field in the delivery.

Sathyam_Chandan_2-1702047178720.png

 

Regards

@Sathyam_Chandan