Expand my Community achievements bar.

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