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.
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,
George