Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
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