Forum Replies Created
The other possible option would be to put all the transaction IDs in the notes’ field in the mass payment CSV file (separated by a space, i.e. 123 784 23). The supplier can then reconcile the payments for individual orders very easily for any given affiliate payment.
This would just require a few lines of code.
Does this sound feasible?
Happy to code this myself, just need guidance on where to put it in the code and potentially the table relationships, depending on what data is used by your existing code.
Thanks guys, for bearing with me:)
Thanks guys for your responses.
Wzp, just to clarify, it’s not me who needs to know who has been paid, but for my supplier affiliate to be able to reconcile the payment they have just received (which could be for 10s of orders with different customers).
For example, over a month, 15 customers purchase different products which are fulfilled by one supplier, 1 order is under dispute. At the end of the month, the supplier gets paid. They then need to manually reconcile the orders with the one bulk payment.
I appreciate that this is using the affiliate system above and beyond what it was designed for, but I am happy to code my own add-on (which I will make available to anyone else using the affiliate system), which links in with your affiliate system.
Ideally for supplier affiliates I would like the email that notifies them that they have been paid, to also include the related transaction IDs.
Is there a hook for when the mass payment file is generated or the affiliate is marked as paid?
Also, can you possibly let me know how the back end tables for affiliates relate to each other?
The other option is for me to use the action hook when an order is paid successfully, and pay the supplier, email them and mark their affiliate payment as paid.
I have done some more investigation and from what i can tell, each order in which an affiliate gets atttributed for a sale, is recorded in an affiliate table.
Is there any action hooks for when an affiliate is marked as paid? As I could write some code which would interrogate those tables and retrieve the detail of each payment, including amount and transaction ID, this would go a long way towards providing suitable detail for the supplier affiliate to reconcile their accounts.
The only slight issue I can see is with regards to postage, if this is a seperate item in the order, then it will not appear in the affiliates’ table as such. One way around this would be to include postage in the item cost.
Any thoughts?November 30, 2022 at 1:56 am in reply to: Is it possible to do selective cookie affiliates on a per product basis #84754
Thats great. Cant believe i missed that field when i was reviewing the product settings. doh