# Bulk Update Personal Coupon Codes

**GoAffPro** provides you with the option to bulk update the personal coupons of affiliates. 

To bulk update, the personal coupons of affiliates, go to the **Coupons** tab in the GoAffPro admin panel. 

<figure><img src="https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2F8qYi90yERHxlKpO3uuj3%2Fimage.png?alt=media&#x26;token=6d281c43-2538-4f77-8448-c8864c466395" alt=""><figcaption><p>Coupons</p></figcaption></figure>

Here, go to the Personal Coupons section.

![Personal Coupons](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2FspDctyXeuJAG44WC4zkx%2Fimage.png?alt=media\&token=d634c132-12e1-4be5-8df0-1f8a947b4544)

Now, click on **Create for existing affiliates**.

![Click on Create for existing affiliates](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2F0MO9Id4LH2XZsX1A6HZm%2FScreenshot%202022-06-14%20021234.png?alt=media\&token=15480cd0-358f-4d1c-8552-14baf40d34b3)

After this, click on **Try the new bulk editor**.

![Click on Try the new bulk editor](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2FmoYxLwAmhl4qK37QxBX3%2Fimage.png?alt=media\&token=46247eb2-e48c-4415-9e63-60237312613f)

This will open up the Bulk refresh coupon code section.

![Bulk refresh coupon code](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2F4Cz7EH0Z8LtG4NjXLamC%2Fimage.png?alt=media\&token=6869e086-ac78-4264-ba29-787d9c7d63d2)

Here, click on **Download** to download the spreadsheet file of affiliates with their personal coupon codes.

![Click on Download](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2FX7GgPWCfDWXZcAXxvhDq%2Fimage.png?alt=media\&token=1e6729c2-41e7-4293-850e-75fb13eef804)

Now, update the personal coupon codes of affiliates in the spreadsheet.&#x20;

![Personal coupon code spreadsheet](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2Fajhz6WmK6CvuN7IZMasp%2FScreenshot%202022-06-14%20021834.png?alt=media\&token=42068548-690c-453c-a078-3e82024442c3)

After this, upload the updated spreadsheet.

![Upload the spreadsheet](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2F2qWatY2UCH1eypGekUeh%2Fimage.png?alt=media\&token=c17d02dc-4969-4be7-bd40-b1fcb7981d6a)

Finally, click on **Submit**.

![Click on Submit](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2F9aL9tUK3eUDGhLXhzQuC%2Fimage.png?alt=media\&token=d9edfdfe-bfe1-4fa2-a1f5-9af089f54f69)

The personal coupons of affiliates will now get updated.

![](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LdPzLtyP46oY7cyXnkw%2Fuploads%2Fak75vs13IQn5ry1opaE0%2Fimage.png?alt=media\&token=8becf662-9517-4e6d-a634-5e84d476f2e6)

{% embed url="<https://www.youtube.com/watch?v=tlriYEdKlyY>" %}
Bulk Update Personal Coupon Codes
{% endembed %}