Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

How to import bulk coupon codes (flat file .csv) into Coupon Code which is created in the Coupon folder.

Avatar

Level 2

Hi Friends,

 

Coupons management 

 

I have created one coupon which I want to target individuals and map it, in the email delivery. I am able to enter code values manually but I am unable to download bulk coupon values into coupons. I read the documentation but I did not get the solution. Please help me if any one know about this.

 

Sathyam_Chandan_0-1700295613599.png

 

Sathyam_Chandan_1-1700295669265.png

 

Yellow highlighted coupon values entered manually but I want bulk download in this.

I tried below method but 

 

Sathyam_Chandan_2-1700295882468.png

 

Sathyam_Chandan_3-1700295972801.png

 

Sathyam_Chandan_4-1700296035067.png

 

Sathyam_Chandan_5-1700296071351.png

Sathyam_Chandan_6-1700296120142.png

 

Sathyam_Chandan_7-1700296168276.png

 

But there is updated in the below coupon

 

Sathyam_Chandan_8-1700296293211.png

 

please tell if there is any other solution.

 

Thank you.

Sathyam

 

 

 

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Sathyam_Chandan ,

Go to the coupon where you want to insert the coupon value, and copy its primary key value

ParthaSarathy_4-1700491200952.png

In import Job, In 'Field mapping', add coupon code and add a new > and paste the primary key of Coupon which you copied in previous step.

ParthaSarathy_0-1700490685553.png

And map the destination path with @coupon-id

ParthaSarathy_1-1700490756963.png

 

In Reconciliation wizard, select 'Coupon Code' and check 'Belongs to Reconciliation key 1'

ParthaSarathy_3-1700491053189.png

Now start it in next step.

Once done, refresh your console, you can able to see the values in coupon tab

ParthaSarathy_5-1700491343256.png

View solution in original post

4 Replies

Avatar

Community Advisor

Hello @Sathyam_Chandan,

 

You have to also populate 'coupon-id' field with the id in the nms:coupon schema.

 

Br,

Amine

Avatar

Level 2

Thank you for your response @Amine_Abedour ,

 

but I need more,

 

as per your suggestion, i have populated id in the coupon schema

Sathyam_Chandan_1-1700489009510.png

 

and imported successful in the Generic imports

 

Sathyam_Chandan_2-1700489122288.png

 

 

but how to map these coupons into coupon values in the coupon folder. 

 

Sathyam_Chandan_3-1700489326878.png

 

coupon values should be here to populate in the coupons section in the delivery.

 

Thank you.

Sathyam.

 

Avatar

Correct answer by
Community Advisor

Hi @Sathyam_Chandan ,

Go to the coupon where you want to insert the coupon value, and copy its primary key value

ParthaSarathy_4-1700491200952.png

In import Job, In 'Field mapping', add coupon code and add a new > and paste the primary key of Coupon which you copied in previous step.

ParthaSarathy_0-1700490685553.png

And map the destination path with @coupon-id

ParthaSarathy_1-1700490756963.png

 

In Reconciliation wizard, select 'Coupon Code' and check 'Belongs to Reconciliation key 1'

ParthaSarathy_3-1700491053189.png

Now start it in next step.

Once done, refresh your console, you can able to see the values in coupon tab

ParthaSarathy_5-1700491343256.png