Page 1 of 3
Fraud Checking, based on Rules made by YOU
Posted: Wed Jul 09, 2025 1:11 pm
by burt
I have made an admin interface that allows shopowner to set up "Rules" for creating a "Fraud Score" which will alert shopowner to things he/she needs to know about.
Admin Page
watchdog_admin.png
Editing/Adding Rules
watchdog_admin_2.png
And then on the Orders Page
watchdog_admin_orders.png
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Wed Jul 09, 2025 1:14 pm
by burt
What other sorts of Rules could be set in place ?
Any ideas/feedback would be golden.
Note that most Rules are flexible from shopowner to shopowner, so for example;
Large Order for one shopowner might mean > 1000
For another it might mean > 100
and so on.
Some rules are inflexible (eg address mismatch) - if your buyers address mismatches...well that's a problem for all shopowners equally.
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Thu Jul 10, 2025 10:18 am
by burt
Some more testing this morning lead to a bottleneck in the code, where the shopowner would have had to actually change code. I don't like that. So, the system has been refactored for "no code".
qwevbn.png
The two interesting bits in this particular page
1. The new Column showing the "Watchdog" score
2. The bit at the bottom of the right hand column showing how the "Watchdog" score was computed
Watchdog score;
170
Made up of;
High Risk Billing Country
50
Throwaway Email
45
Mismatched Address
75
Also notice the different coloured Watchdog scores. That's a nice indicator.
Obviously this system is
NOT designed to
prevent fraud, it is designed to make you, shopowner, aware of discrepancies that you might like to checkout before processing the order.
This whole system is done with NO CORE CODE CHANGES.
That's the beauty of Phoenix shining through.
I will put this into the July Code Drops - later on in the month after it's been tested a bit more.
I'm all ears for any other "Rules" anyone can think of.
Let's make this system the best it can be.
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Thu Jul 10, 2025 4:29 pm
by Omar_one
maybe some "Rules" for black list customers
eg. some customer order by phone and they never pay the invoice (Some phone orders result in unpaid invoices).
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Fri Jul 11, 2025 9:44 am
by burt
Perhaps a "Time" Rule might be of use to some shopowners.
EG, any orders that come in between 2am and 4am?
Perhaps a "First Order by this Customer" Rule ?
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Sat Jul 12, 2025 1:12 pm
by burt
We now have a "
First Time Customer" rule, see the two latest orders here;
1st.png
Order ID 21 has a Watchdog score of 15 (which is what I set for a "first time customer").
Order ID 22 has a Watchdog of 0 (as this is the second order of the Customer).
Obviously this customer triggered no other rules.
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Mon Jul 14, 2025 11:31 am
by burt
We now have an
Order Time module which might be useful for some shopowners?
Rule Set Up
rule1.png
Shown Rule
rule2.png
Best of all, it's coded in such a way that these Rules can run as many times as is needed;
(eg)
Order Time: 11:00 - 14:00 - score 20
Order Time: 23:00 - 23:45 - score 30
and so on
Or you could have (eg)
"really dodgy countries" - score 100
"ok but be aware countries" - score 50
and so on
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Mon Jul 14, 2025 3:21 pm
by burt
Omar_one wrote: ↑Thu Jul 10, 2025 4:29 pm
maybe some "Rules" for black list customers
eg. some customer order by phone and they never pay the invoice (Some phone orders result in unpaid invoices).
When someone orders by phone, what is the process that you take to actually create an order (ie, so that the order is in adin/orders.php and you can view an invoice etc as normal).
I'm -guessing- that you are on the phone with "Mr XYZ", you log in as him ... performing a checkout, choosing some sort of "pay in the future" payment module (a bit like cash on delivery, or check). Then you end up waiting for payment which sometimes never arrive. Which leaves you;
1. having wasted time on a phone call Mr XYZ
2. not knowing if this order is going to be paid
3. more than likely wasting time chasing for payment
Is that how it works?
Let's say that happens one time.
And then Mr XYZ does the same again <--- is this what you want to stop?
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Mon Jul 14, 2025 7:13 pm
by Omar_one
burt wrote: ↑Mon Jul 14, 2025 3:21 pm
Let's say that happens one time.
And then Mr XYZ does the same again <--- is this what you want to stop?
Yes. this idea more rules.
Order Handling in Our Shop:
1- Occasionally, customers place orders over the phone.( we create an order in the admin side) In some cases, we dispatch these orders before receiving payment.
2- To manage this risk, we’ve added a new column to the customers table( or orders table not sure right now ) to flag such cases. If a customer has previously failed to pay for an order, they are marked as "Not Trusted". This status also appears on the orders page.
3-If the same customer attempts to order by phone again, we can quickly identify them. Since collecting payment from them is likely to be difficult, we no longer ship orders to such customers unless payment is made in advance.
Re: Fraud Checking, based on Rules made by individual shopowners
Posted: Tue Jul 15, 2025 8:14 am
by burt
Omar_one wrote: ↑Mon Jul 14, 2025 7:13 pm
Order Handling in Our Shop:
1- Occasionally, customers place orders over the phone.( we create an order in the admin side)
The simplest way for you would be to use javascript to popup a "this customer doesn't pay" message when you select the customer in whatever process/addon you have for making an order in admin side.
This watchdog won't work in this case.