as I said in a previous post, my affiliates want to see the pending orders too, not only the completed.
To get this done, I’m checking the
wp_postmeta table and search for orders which have
This works fine when someone uses an affiliate link to place an order.
But I noticed when someone doesn’t use an affiliate link and instead uses a coupon code (associated with an affiliate), there is no
_wpam_id in the
So I have to implement it by myself to check if an coupon code applied to an order is associated with an affiliate.id.
My Problem is now, I can see the association between coupon<->affiliate in the admin backend, but I can’t find the SQL table where this information is stored.
Can you help me out?
OK, I just had the idea to make an SQL dump of the whole database and search for the coupon code.
If someone else is interested in this, it’s stored in the
wp_options table. You have to look at
Seems to be in a strange format. What is this? It’s no json or something I know. How to parse this?
EDIT: it seems AFFMGR_WOO_COUPONS_ASSOC::get_instance() is doing what I’m looking for 😉
You must be logged in to reply to this topic.