s2member-pro-coupon-codes Usage Reporting

[jvstudios]

Hello S2,

Please advise the best way to obtain s2member-pro-coupon-codes Usage Reporting.

Thanks,
Jay

[Jason Caldwell]

Thanks for your inquiry.

In the current release of s2Member Pro, there is no formal method of tracking Coupon usage. Until there is, what you can do is log into your Payment Gateway ( i.e. PayPal or Authorize.Net ) and search for transactions that include this word: COUPON ( always in uppercase ).

s2Member will always add the Coupon Code into the product description or Item Name field. It also includes the original price; before the Coupon was applied.

Screen shot inside a PayPal account:

SNAG-0016.jpg (14.98 KiB) Viewed 1082 times

[jvstudios]

Can you share where this infornation is stored within the database with me?

[Cristián Lávaque]

Can you share where this infornation is stored within the database with me?

It's not in the database, you'd have to go search it in your gateway logs, i.e. over at your PayPal or Authorize.Net account.

[jvstudios]

Hello,

I am really needing some sort of detail so that I can provide Coupon Code Usage Reporting.
Authorize.net does in fact contain the word "COUPON" in the Invoice Description Field along with the original price and sale price.but NO SPECIFIC COUPON CODE IS GIVEN, only the fact that one was used.

We are also needing some help with the text displayed both in the "Coupon Success Alert" box and the email that is sent. They both contain:
(For Example)
COUPON $99.92 off. ( Now: $0.03 / monthly ) ~ ORIGINALLY: $99.95 USD / One Time Charge - INTRODUCTORY OFFER! Ends soon! (Regular cost $149.95)

The product that this is for is for a lifetime membership and the new customers will flip when they see monthly recurring etc.

The shortcode follows:

[s2Member-Pro-AuthNet-Form level="2" ccaps="" desc="$99.95 USD / One Time Charge - INTRODUCTORY OFFER! Ends soon! (Regular cost $149.95)" cc="USD" custom="chambrayadvisors.com" ta="0" tp="0" tt="D" ra="99.95" rp="1" rt="M" rr="1" accept="visa,mastercard,amex,discover" coupon="" accept_coupons="1" default_country_code="US" captcha="0" /]

[Cristián Lávaque]

Ah, that'd be caused because of these in your shortcode

[s2Member-Pro-AuthNet-Form level="2" ccaps="" desc="$99.95 USD / One Time Charge - INTRODUCTORY OFFER! Ends soon! (Regular cost $149.95)" cc="USD" custom="chambrayadvisors.com" ta="0" tp="0" tt="D" ra="99.95" rp="1" rt="M" rr="1" accept="visa,mastercard,amex,discover" coupon="" accept_coupons="1" default_country_code="US" captcha="0" /]

It says there that it recurs every 1 month. WP Admin -> s2Member -> Auth.Net Pro-Forms -> Shortcode Attributes (Explained)

I hope that helps.

[jvstudios]

That will likely take care of the "monthly" text, sorry for the oversight.

Anything at all on the Specific Coupon Code use?

[Cristián Lávaque]

No problem.

About the coupon reports, I'll let Jason answer that one when he's back.

[Jason Caldwell]

A similar/related issue was resolved here.
I've attached a patch for this issue until the next version is publicly released.
You can grab it here along with the instructions:
viewtopic.php?f=4&p=14292#p14292

More extensive reporting for Coupon usage will come in a future release. Thanks for your patience.

[jvstudios]

Hello,
In reviewing the authorize.net data, we get COUPON CODE but NOT the code used. I have tried to swap the code for the company name as shown below:

Code: Select all

$_authnet["x_company"] = $post_vars["coupon"]; 

without success.

My client has to report on specific code usage as their marketing plan hinges on it.

Please advise us of a suitable patch, as well as, when S2 will suppport this internally.

Thanks.

[Jason Caldwell]

Thanks for the excellent question and feedback.

Until coupon code reporting is fully integrated, you might pipe the Coupon Code into the custom="" attribute of your Pro Form Shortcode. So your Shortcode might look something like this:

Code: Select all

[s2Member-Pro-AuthNet-Form ... custom="example.com|<?php echo $_POST["s2member_pro_authnet_checkout"]["coupon"]; ?>" ... /]

* This Shortcode is abbreviated for clarity.

Also see: Using Variables In A Shortcode
viewtopic.php?f=36&t=1604

By piping this data into the custom="" Attribute, you will have access to this data using the %%cv1%% Replacement Code, available for email templates with s2Member, and in Custom Return URLs, and also for all API Notifications and tracking.

[jvstudios]

Thanks Jason :>),
If you would please, provide an example of a Signup Notification URL structure, as well as, a simple script for the coresponding page, so that I can see the data somehow. I do intend on storing some of the information within MySQL.

[Cristián Lávaque]

Here's an example http://example.com/script.php?first_name=%%first_name%%&last_name=%%last_name%%

You can watch this video too http://www.s2member.com/api-tracking-no ... ons-video/

[jvstudios]

Hi Cristian,
I created a test page using this shortcode:

Code: Select all

[s2Member-Pro-AuthNet-Form level="2" ccaps="" desc="$99.95 USD / One Time Charge - INTRODUCTORY OFFER! Ends soon! (Regular cost $149.95)" cc="USD" custom="chambrayadvisors.com|<?php echo $_POST["s2member_pro_authnet_checkout"]["coupon_code"]; ?>" ta="0" tp="0" tt="D" ra="99.95" rp="1" rt="L" rr="0" accept="visa,mastercard,amex,discover" coupon="" accept_coupons="1" default_country_code="US" captcha="0" /]

I do have logging turned on.
I used a coupon code of AAA678

The log shows:

Code: Select all

User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.17) Gecko/20110420 Firefox/3.6.17 ( .NET CLR 3.5.30729; .NET4.0C)
-------- Input vars: ( Tue Jun 14, 2011 4:26:12 pm UTC ) --------
array (
  'x_type' => 'AUTH_CAPTURE',
  'x_method' => 'CC',
  'x_email' => 'xxxxxxxx@xxxxxx.com',
  'x_first_name' => 'jelly',
  'x_last_name' => 'belly',
  'x_customer_ip' => 'xx.xxx.xx.xx',
  'x_invoice_num' => 's2-1308068772',
  'x_description' => 'COUPON $99.94 off. ( Now: $0.01 ) ~ ORIGINALLY: $99.95 USD / One Time Charge - INTRODUCTORY OFFER! Ends soon! (Regular cost $149.95)',
  's2_invoice' => '2',
  's2_custom' => 'chambrayadvisors.com|',
  'x_tax' => '0.00',
  'x_amount' => '0.01',
  'x_card_num' => '************2610',
  'x_exp_date' => '2012-01',
  'x_card_code' => '318',
  'x_address' => 'PRIVATE',
  'x_city' => 'xxxxxxx',
  'x_state' => 'xxx',
  'x_country' => 'US',
  'x_zip' => '95821',
  'x_version' => '3.1',
  'x_login' => 'PRIVATE',
  'x_tran_key' => '375BmwYeLL3fn928',
  'x_delim_data' => 'true',
  'x_delim_char' => ',',
  'x_encap_char' => '"',
)

Is the pipe syntax spooged?
Thanks again for your help.

[jvstudios]

P.S. The PHP execution plugin has been installed for quite some time...

[Cristián Lávaque]

I think $_POST["s2member_pro_authnet_checkout"]["coupon_code"] may be empty, because you haven't applied the coupon code yet when you echo that. Jason, am I wrong?

[Jason Caldwell]

Actually, I think this was a goof on my part. The POST array element is ["coupon"], not ["coupon_code"], I updated the code sample above to reflect this important correction.

Code: Select all

<?php echo $_POST["s2member_pro_authnet_checkout"]["coupon"]; ?>

[Cristián Lávaque]

Ah, got ya. Thanks for fixing it.

[jvstudios]

Sweet :>), thanks, I'll be back...