How to get shipping promotion adjustment information in WC5.6.1?

[h***@gmail.com]

Hi all,
I want to tell customer if their typed in shipping coupon code is applied to the current order or not. But I can't get shipping fee adjustment after PromotionCodeManage and OrderCalculate url is run. Anyone know how to tell if a shipping coupon code is applied for current order or not? Thanks.

[geo]

info center has this information for your immediate reading pleasure

http://publib.boulder.ibm.com/infocenter/wchelp/v5r6m1/topic/com.ibm.commerce.developer.doc/refs/rgxref.htm

search that page for ORCPMAP (coupons applied to orders are listed in this
table) which as you will note from the above link is wrapped by the
com.ibm.commerce.couponredemption.objects.OrderCouponMapAccessBean

Post by h***@gmail.com
Hi all,
I want to tell customer if their typed in shipping coupon code is applied
to the current order or not. But I can't get shipping fee adjustment after
PromotionCodeManage and OrderCalculate url is run. Anyone know how to tell
if a shipping coupon code is applied for current order or not? Thanks.

[v***@yahoo.com]

The shipping adjustments are not persisted separately in any table in WC 5.6.1. The discounted shipping charge is calculated and stored in the shipping charge fields in ORDERS and ORDERITEMS tables.

[h***@gmail.com]

Thanks. Then I can't tell customer if their shipping coupon is applied or not. I can use javascript to compare the shipping fee before and after, but it's ugly. Any good idea? Thanks.

[geo]

I would be happy to test but any coupon applied to an order should be in
ORCPMAP, including coupons for shipping. If this were a shipping discount
that would be different, and I would agree with Vani.

Post by h***@gmail.com
Thanks. Then I can't tell customer if their shipping coupon is applied or
not. I can use javascript to compare the shipping fee before and after,
but it's ugly. Any good idea? Thanks.

[h***@gmail.com]

I took a look at ORCPMAP. But that table is always empty and it seems no entry is created even when order level and item level coupons are applied.