Payment DB status

Is it possible to query on the DB tables for the payment status?

Can’t seem to see where the “closed” for a payment is via SQL.

Is it in wp_aff_referrals, in the serialized “data” field?

Have a custom display for users and wanted to add a column if the referral has been been paid already.

One Response to Payment DB status

  1. George October 14, 2018 at 3:03 pm #

    Hi Seth,

    It’s the status column which will be marked as closed when you edit the referral and mark it as closed under Affiliates > Referrals or under Affiliates > Totals when you mass-close your recorded referrals.

    Kind regards,

We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
OK, hide this message.

Affiliates · Contact · Jobs · Terms & Conditions · Privacy Policy · Documentation · Downloads · Useful Plugins · My Account