Covering a 60-day refund policy

[Josiah]

Hello everyone!

The product I'm selling has a 60-day refund policy, so I'm not going to pay affiliates until their sales have cleared that period.

Now, how could I do this in Post Affiliate Pro?

On the day I'm going to pay everyone, would I search for transactions that are older than 60 days, then approve them? Then once I pay all my affiliates, I presume they will not be paid next time I search for transactions older than 60 days?

One other thing: when I issue a refund, could my script that removes that member from my DB remove it from the affiliate DB?

Thank you so much!

[mark]

Hello,

it can work as you described.
You'll leave sales in 'waiting for approval' state, then approve them after 60 days.
They'll appear in 'Pay affiliates' list only after approval.
When you make payment to the affiliates and mark payment as paid (from v. 1.4, in previous versions it was automatic), they will of course not be displayed again next time in the payments to be paid.
But you will still see the old transactions in the Transactions list.


One other thing: when I issue a refund, could my script that removes that member from my DB remove it from the affiliate DB?


yes, it can be made with little programming. It will be quite simple script.

regards,

mark

[Josiah]

What database tables would I have to query in order to remove the transaction in case of a refund? Can I search by PayPal transaction number? Would it be possible for you to give me a sample query code? Thank you very much!

[Josiah]

Actually, what I would like even more is to "decline" transactions that are refunded. That way the affiliate can still see that he is actually referring people.

How could my script set a transaction to "declined"? Thanks!

[mark]

Hi,

transactions are stored in table pa_transactions. To set transaction to declined, you should update its 'status' to value 3.
Status values:
1 - waiting for approval
2 - approved
3 - declined

Constants like these are defined in /settings/global_const.php.

You can search for the right transaction by orderid, affiliateid.

regards,

mark