Coupons Admin Page Needs Column that shows Assigned Price Group

[dreamingdigital]

The coupon admin page needs a column that shows the assigned price group for that coupon. I have no idea why that's not there.
I guess I have to custom program a page or feed or something that will get me this info. Wouldn't it be nice to just have that there?
Am I missing something obvious?

[Brennan]

That already exists today. If you select a coupon, there is a Price Groups button which will show you all the assigned price groups.

Screen Shot 2021-01-12 at 10.09.39 AM.png

[dreamingdigital]

Brennan in the meantime I'm trying to build my own export, it'll have to be JSON API, can you please help with the process and API calls here?

Option A. PriceGroupList_Load_Query()
Get list of all price groups that are coupon type but does not get me a list of coupons
This doesn't work for what I want.

Option B. CouponList_Load_Query()
Now Loop through data for each coupon.
For each coupon now
CouponPriceGroupList_Load_Query() filter by assigned:true
This gets the price groups assinged to this coupon.

So Option B look right?

[dreamingdigital]

RE: current UI >
1. I totally missed it because it was burried in the ... menu.
2. We have clients with hundreds of coupons. The amount of point and click on the current UI to pull that off is not feasible.

[Brennan]

Got it. Today the price group assignments for coupons are only displayed on a per price group basis. We don't have a comprehensive report where you can view all coupons and their price group assignments. Using the JSON API to get this data and display it in a single report is a great option. Your option B is the best way to do this.

[dreamingdigital]

Thanks Brennan. I'll program something using Option B. I'm happy I found the correct JSON API functions to call and in what order.