Redeem rate for Freestanding Coupons in Oracle ATG commerce

Question

Any clue on how can I keep a track regarding how many Freestanding Coupons were used in Oracle ATG? I know that for bulk vouchers we have the Redemption Rate, but for the simple vouchers there's no such thing. For example I created 500 vouchers with the code XXXXX and I want to see how many were used during the checkout.

Cheers

I'm using Business Control Center 10.1.2 ATGPlatform/10.1.2 – Bisbal Nov 24 '15 at 13:25 — Bisbal, Nov 24 '15 at 13:25

bated · Answer 1 · 2015-12-03T16:52:32.467

One way to do this would be to use the dyn/admin to query the number of uses for the given voucher code:

Open the ClaimableRepository in dyn/admin http://your-host-name:your-port/dyn/admin/nucleus/atg/commerce/claimable/ClaimableRepository/

In the text area below Run XML Operation Tags on the Repository enter the following: <print-item item-descriptor="PromotionClaimable" id="my-promotion-id" /> and hit the 'enter' button. This will print something like this:

------ Printing item with id: my-promotion-id
<add-item item-descriptor="DeployablePromotionClaimable" id="my-promotion-id">
  <set-property name="expirationDate"><![CDATA[11/26/2015 23:59:00]]></set-property>
  <set-property name="displayName"><![CDATA[10% discount on my items]></set-property>
  <!-- rdonly  derived   <set-property name="derivedDisplayName"><![CDATA[10% discount on my items]]></set-property>  -->
  <set-property name="uses"><![CDATA[4]]></set-property>
  <!-- export is false   <set-property name="version"><![CDATA[13]]></set-property>  -->
  <set-property name="lastModified"><![CDATA[10/28/2015 16:18:09]]></set-property>
  <set-property name="status"><![CDATA[claimed]]></set-property>
  <set-property name="startDate"><![CDATA[8/13/2015 00:00:00]]></set-property>
  <!-- rdonly  derived   <set-property name="hasPromotions"><![CDATA[true]]></set-property>  -->
  <set-property name="promotions"><![CDATA[promo100001]]></set-property>
  <set-property name="type"><![CDATA[DeployablePromotionClaimable]]></set-property>
</add-item>

The line <set-property name="uses"><![CDATA[4]]></set-property> tells you how many times that voucher/coupon has been used, which in this case is 4.

UPDATE:

The above method does not work as it returns the total number of coupons available when the promotion is setup. This means the quickest way to get this information would be to query the completed orders which use the coupon.

great, thanks a lot bated! I'll give it a try and keep you posted — Bisbal, Dec 08 '15 at 08:26

Redeem rate for Freestanding Coupons in Oracle ATG commerce

1 Answers1