Coupons Admin Page Needs Column that shows Assigned Price Group

[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.

[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]

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.

[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?

[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]

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?