Vendor Module Premier Membership Transaction Failures

At the beginning of each month, the authorized user for the Authorize.net account (currently Wes Coulter) will run the Transaction Status Report for the prior month. The Transaction Status Report can be located by navigating to Recurring Billing (left navigation pane) >> View Transaction Status Report (in "Search & Results" section) >> Select the prior month from the "Month of:" dropdown >> Select the number under "Transactions Processed" >> View All. Because Authorize.net does not have an export feature, the results will need to be sorted by the Transaction Status column, then all "General Error", "Declined", and other failed status items highlighted and copied and pasted into the VM Authorize.net Failed Transactions Google Doc. The following actions will be taken to clean the data:

Compare the prior month's list to the current list and remove any duplicates
Query the Vendor Module Database using the Auth SubscriptionID to locate the Statuses of the Brokers and their PaymentMethods
Remove any rows where the Auth Subscription Status is "Canceled", Broker Status is "Basic", and VM PaymentMethod Status is "Canceled"
Remove any rows where the Broker has renewed their membership and the new payment attempt was successful

Support will be given the final list on or before the 5th of the month, and will take the following actions:

Locate each Broker's contact information and enter it into the appropriate columns of the Google Doc (this will be provided in the Google Doc, along with last login and upgrade date(s) via a query at a later time)
Within the first week, contact each Broker via email using the "Initial Contact" section below to notify them that their payment attempt failed, and they will be downgraded if we do not hear back from them. Enter the date of contact in the "First Attempt" column
Within the second week, send a follow up email to each Broker that has not replied using the "Follow Up Contact" section below. Enter the date of contact in the "Second Attempt" column.
Within the third week, contact any Brokers via phone that have not responded to either email.

Any Brokers that do not respond, or request to be downgraded will be downgraded no later than the 5th business day of the month following the initial contact attempt.

Initial Contact

Subject: Vendor Module Premier Account - Declined Credit Card Transactions

Body:

Dear {Broker Name},

We received a notification from the Vendor Module system advising that last month's Premier Membership payment attempt was declined by your credit card, ending in {CC Last 4}.

Your Premier Membership is currently active, and you have had access to the additional benefits of the membership without payment of the monthly or annual membership fee.

IF you would like to remain a Premier Member on the Vendor Module, please log in and update your credit card information using the attached instructions by the end of this month. No backdated charges will be applied to your credit card for any missed payment(s).

If the credit card update is not completed by the end of this month we will proceed with the cancellation and downgrade your account to the free Basic Membership.

Attached:

· Credit Card Update Instructions for Monthly and Annual Premier Memberships in the Vendor Module

https://www.vendormodule.com/Login.aspx?ReturnUrl=%2fDefault.aspx

Please contact us if you need any further assistance.

Thank you for being a Premier Member of the Vendor Module, your business is greatly appreciated.

Regards,

Vendor Module Merchant Support

merchantinquiries@quandis.com

Follow Up Contact

Subject: Vendor Module Premier Account - Declined Credit Card Transactions (Second Notice)