Something went wrong. Try again later

rorie

Hello!

7888 1502 54 39385
Forum Posts Wiki Points Following Followers

The Incredible Tale of the PCI DSS SAQ

People often ask me what I do around here, and it's a valid question, since so much of what I do is not publicly visible. Needless to say, there's a lot of weird stuff that Giant Bomb has going on in the background that other sites in the CBSi family don't have to deal with, largely because many of them don't feature subscription services, nor do they have storefronts through which they sell merchandise. So I figured I'd start writing the occasional blog about what keeps me busy on a day to day basis.

No Caption Provided

Lately it's been monitoring our store. You may have used the store in the past to get a t-shirt or poster or something, and if you did, then thanks! We don’t make a huge amount of money from the store, since we generally try to offer merchandise of a decent level of quality without making the prices too crazy, which means our costs are pretty close to the list price of most of the items we offer. We make some money on each order, but no one’s taking baths in Cristal or anything.

Normally, that’s all fine and good, except when we start getting people trying to make fraudulent orders, as has been happening with increasing frequency of late. Our store is run through Shopify, which automatically takes a look at each order and pops up various flags based on suspicious activity, such as billing address not matching where the credit card’s registered and CVVs not matching.

EDIT: To be clear, none of the below should be taken as an indicator that Giant Bomb has any kind of security issue with its store. We don't even have access to your credit card numbers; everything we do is through third-party vendors that keep all that stuff locked up good and tight. People are using credit card numbers they've stolen elsewhere; felt like a good idea to make that clear.

Those are both pretty good indicators that someone’s using a stolen credit card to place an order, especially the mismatched CVV. The CVV’s the little three-digit code on the back of the card that you’re usually asked to enter when placing an order online; the Payment Card Industry Data Security Standard prevents it from being stored, so when credit card records are breached, hackers usually just get the card number but have to make a guess at the CVV. It’s pretty rare that anyone using a valid card won’t know or be able to access their CVV, since it’s right there on the back of the card, so mismatched CVVs are usually an excellent indicator that an order is fraudulent.

No Caption Provided

(As an aside, I’m also the guy who has to report on our PCI compliance, which involves wonderful things like payment data flow diagrams and something called a PCI DSS SAQ. It’s pretty thrilling stuff.)

Anyhow, there are enough steps in our ordering chain that sometimes a fraudulent order will slip through, which will generally lead to a chargeback later on down the line. Since we keep records of where we ship, we can supply those to Paypal to prove that an order was shipped and signed for, which usually result in Paypal contesting the chargeback with the credit card company, after which I have no idea what happens. I presume that credit card companies simply eat a certain number of fraudulent charges as part of the cost of doing business.

Recently, though, there’s been a bit of an uptick in fraudulent orders to the store, mostly being placed from Venezuela with shipping addresses in southern Florida. From what I can tell, it looks like there’s some kind of well-organized credit card scamming gang that rip off tons of credit card numbers and convert them into physical goods before the numbers are shut down. That might sound paranoid, but googling some of the shipping addresses have led to things like Yelp listings for the businesses there, which in turn lead to plenty of reports of other merchants reporting the addresses being associated with stolen CC numbers. I guess someone in Venezuela or Miami really likes Giant Bomb, because they’ve been ordering plenty of merchandise over the past few months. Or they just use it to smuggle cocaine, or something. Edit: Someone on Twitter suggested that they might just be trying to place small orders to see which credit card numbers were still active before using them for large purchases elsewhere, which makes sense.

So, I’ve been trying to keep track of all the orders that are coming in and have been manually cancelling anything that looks suspicious. That hasn’t stopped the orders from coming in, of course, even though I make sure to send emails back indicating that the orders were cancelled because they’re suspected to be fraudulent. Not that anyone’s reading them; I’m pretty sure the email addresses are as fake as the orders themselves.

No Caption Provided

What’s interesting is that the orders from southern Florida have mostly subsided (with a few exceptions) in favor of orders from places like Lithuania, Tunisia, Albania, and other exotic locales. It’s interesting to see the purchasing habits of people who’re playing with other people’s money. One order was for a single t-shirt and a hoodie, but still managed to be $236 thanks to a mammoth $181 shipping charge. (If you’re ordering from eastern Europe, you might want to opt for something cheaper than overnight shipping.) What’s curious is that a lot of these new orders are passing the CVV checks. Presumably this means that these orders are being placed from credit cards that were actually physically stolen, or perhaps issued by legitimate vendors based on fraudulent applications.

I’ve been refreshing the orders page pretty regularly lately, examining all of the orders coming in, and cancelling all the fraudulent ones; at this point I'm pretty sure that I've pissed someone off, because the frequency has increased to the point where over half of all orders coming in are fraudulent, with over $1200 in fraudulent orders in the last couple of days alone. I’m not going to go into the criteria I use to detect suspicious orders, but suffice to say that the “is this order legitimate” game is pretty fun sometimes, especially since I rarely play actual games at work nowadays. Undoubtedly there’ll be a legitimate order that I accidentally cancel at some point, so if you wind up getting an order cancelled mysteriously, let me know and I’ll look into it. I'm looking into some Shopify apps that add a second level of protection against fraudulent orders in the meantime.

And that’s one of the things that I've been up to. So there!

84 Comments

84 Comments

Avatar image for subrandom
subrandom

145

Forum Posts

102

Wiki Points

0

Followers

Reviews: 0

User Lists: 8

Edited By subrandom

Rad. Also a bummer you don't write more forward facing stuff that often, you can still string some words together pretty damn well. Anyway, i find it super interesting to hear about jobs people have that are a little less common no matter how "flashy" or not they may be. Keep it up.

Avatar image for deactivated-61356eb4a76c8
deactivated-61356eb4a76c8

1021

Forum Posts

679

Wiki Points

0

Followers

Reviews: 0

User Lists: 9

Just here for the puppies.

Avatar image for ilikepopcans
ilikepopcans

979

Forum Posts

3100

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Edited By ilikepopcans

Huh, interesting stuff Rorie. Would not expect you to do something like that, figure that would be someone else job. Around how many orders are going in on a average day, if I may ask?

Avatar image for patvb
PatVB

365

Forum Posts

130

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Wow, I wouldn't have figured GB would see that level of fraud. Good looking out, Rorie!

PS: excellent image choices!

Avatar image for wrighteous86
wrighteous86

4036

Forum Posts

3673

Wiki Points

0

Followers

Reviews: 5

User Lists: 1

Who needs Papers, Please? when you can just play Is This Order Legitimate?

Avatar image for matoyak
Matoyak

485

Forum Posts

6

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Actually pretty interesting stuff (Even if PCI DSS SAQ is an acronym I wouldn't want to meet in a dark alley). Always cool to learn about actual day-to-day workings of places like Giant Bomb. Thanks for sharing. :)

Avatar image for roninhack
roninhack

44

Forum Posts

3

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Wielding the ban hammer well, sir. Thanks for fighting the good fight.

Avatar image for deactivated-5f00787182625
deactivated-5f00787182625

3325

Forum Posts

604

Wiki Points

0

Followers

Reviews: 3

User Lists: 0

No Caption Provided

It's really cool having you here Rorie, nice to know what you've been up to.

Avatar image for thunderslash
ThunderSlash

2606

Forum Posts

630

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

These people are super ingenious when it comes to credit card laundering. There was a story a while back that detailed how they were buying Team Fortress 2 crate keys with the stolen cards and reselling the keys for Paypal money.

Avatar image for tbecker38
tbecker38

16

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Speaking of fraudulent activity, the real Matt Rorie would never write a thousand words without referencing puppies.

Avatar image for chop
Chop

2013

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 1

Really cool read. I love hearing about back end stuff like this.

Avatar image for drdarkstryfe
DrDarkStryfe

2563

Forum Posts

1672

Wiki Points

0

Followers

Reviews: 1

User Lists: 2

Credit card fraud is on a huge uptick. We deal with a good three to four attempts a week anymore at my place of employment. It is starting to get a little out of hand.

Avatar image for eccentrix
eccentrix

3250

Forum Posts

12459

Wiki Points

0

Followers

Reviews: 4

User Lists: 15

This is all super interesting. Thanks, Rorie!

Avatar image for ssully
SSully

5753

Forum Posts

315

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

So that is why my 300+ dollar order for a shirt and hoodie never came. Damn you Rorie!

Avatar image for benjo_t
benjo_t

322

Forum Posts

2814

Wiki Points

0

Followers

Reviews: 1

User Lists: 3

This was an interesting read, I look forward to more.

Avatar image for jabronie
Jabronie

32

Forum Posts

11

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

You don't understand, I need that hoodie immediately!!!

Avatar image for mento
Mento

4972

Forum Posts

552189

Wiki Points

0

Followers

Reviews: 39

User Lists: 212

Mento  Moderator

It's kind of a shame GB has one of their best writers doing administrative work like this, but at least we get some cool stories of what life is like in the online t-shirt store trenches. Keep up the good work, Rorie.

Avatar image for deactivated-6050ef4074a17
deactivated-6050ef4074a17

3686

Forum Posts

15

Wiki Points

0

Followers

Reviews: 1

User Lists: 0

This is really crazy behind-the-scenes stuff. I feel a little bad for enjoying hearing about it when I know it causes you such a headache!

Avatar image for magzine
MAGZine

441

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

nothing more interesting than pci dss.

Avatar image for beepmachine
beepmachine

631

Forum Posts

280

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

@rorie sounds like your own personal version of Papers Please. Thanks for all you do to further the cause of Glorious Giant Bomb!

Avatar image for oneandonlybige
OneAndOnlyBigE

477

Forum Posts

9

Wiki Points

0

Followers

Reviews: 0

User Lists: 1

As someone who works for a financial technology services company, I'm well versed in PCI compliance. Fun stuff.

Avatar image for bkbroiler
bkbroiler

1739

Forum Posts

438

Wiki Points

0

Followers

Reviews: 0

User Lists: 11

So these fraudulent orders are from people who really, actually want Giant Bomb merch? Or are they somehow making money off the stuff they buy? Both realities seem absolutely nuts.

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

So these fraudulent orders are from people who really, actually want Giant Bomb merch? Or are they somehow making money off the stuff they buy? Both realities seem absolutely nuts.

Someone on Twitter pointed out that these are likely just test purchases where people are trying out card numbers to see which ones work before using them for huge purchases elsewhere, or reselling them. Sounds plausible.

Avatar image for ben_h
Ben_H

4836

Forum Posts

1628

Wiki Points

0

Followers

Reviews: 1

User Lists: 5

You didn't accidentally cancel my order for a sweater so it's all good for me. My order is on the way right now.

Avatar image for turtlefish
TurtleFish

415

Forum Posts

210

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

My condolences - PCI and dealing with online shopping issues (from the service providers side) is always a pain.

Avatar image for tireyo
Tireyo

6710

Forum Posts

11286

Wiki Points

0

Followers

Reviews: 27

User Lists: 17

Avatar image for csl316
csl316

17005

Forum Posts

765

Wiki Points

0

Followers

Reviews: 0

User Lists: 10

The PCI compliance system has 12 steps, which is 1.. 2...... 3 puppies worth!

Which is the grade I would give that web page's design.

Avatar image for little_socrates
Little_Socrates

5847

Forum Posts

1570

Wiki Points

0

Followers

Reviews: 16

User Lists: 23

Avatar image for mormonwarrior
MormonWarrior

2945

Forum Posts

577

Wiki Points

0

Followers

Reviews: 15

User Lists: 21

Cool article. That's nuts how much fraud/attempted fraud goes on every day, and in such random places as the Giant Bomb store. Thanks for all your efforts!

And, my puppies: (Sophie, left, and Teddy, right)

No Caption Provided

Avatar image for bonechompski
BoneChompski

421

Forum Posts

2

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Edited By BoneChompski

I think there are online vendors who are compromised and they never report the theft of their data out of fear of losing business. I've had two credit cards used for fraudulent purchases at different times, one of which was caught immediately and the other which the CC company made me eat of all outcomes. Either that or there are insider thefts at online retailers and meatspace retailers as well. Pretty easy to photograph both sides of a credit card quickly if you have access to one at your place of employment.

Avatar image for tournamentofhate
TournamentOfHate

880

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: -1

This just worries me that somebody higher up is going to be like "Why are we paying you to go over orders that don't even make us money even if they're legit?" Then we lose the chance to buy GB merchandise(it just seems like the anti-management talk has been getting more frequent lately, and I don't want them forcing their hand into what GB does, and really I just hate to see how much it bothers you guys).

Avatar image for forteexe21
forteexe21

2073

Forum Posts

5

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Are the address always different? Cause i imagine itll be easy to block if its from a single address. Anyway, that sounds really bad and hope you find an easier way to filter those than manually checking each one.

Avatar image for overnumerousness
Overnumerousness

9

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Super Fascinating! Seriously Rorie, as someone who runs app support as well, this was an awesome read.

Avatar image for the_laughing_man
The_Laughing_Man

13807

Forum Posts

7460

Wiki Points

0

Followers

Reviews: 1

User Lists: 0

Give us the fake delivery addresses and we can mess these guys up!

Avatar image for noizy
noizy

999

Forum Posts

66

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Yea. Getting credit card numbers is easy. Getting the CVV is harder.

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

@subrandom: Thanks. Yeah, I've been trying to write more. I have a bunch of half-written blog posts from my unemployed days that could probably be repurposed.

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

@ilikepopcans: Depends on the day. Usually no more than five-ten. It's not a high-volume operation, but then we haven't added any new merchandise in the last few months.

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

@mento: I find pretty much everything I do to be pretty interesting, and at any rate someone's gotta do it! Better me than Vinny or Jeff having to worry about this stuff.

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

Edited By rorie

@mormonwarrior: Cute! Do you always keep one shaved to help tell them apart?

Avatar image for toxeia
Toxeia

792

Forum Posts

2

Wiki Points

0

Followers

Reviews: 0

User Lists: 1

What I'm gathering from this is that Giant Bomb merch ships with free cocaine. I better order me some hoodies.

Avatar image for mento
Mento

4972

Forum Posts

552189

Wiki Points

0

Followers

Reviews: 39

User Lists: 212

Mento  Moderator

@rorie: Well, it was more of a "shame this has to be the way of things seeing as Giant Bomb's resources being stretched thin enough already" statement than a "shame the guys in charge are idiots and won't hire Rorie to write puppy reviews" one. It sounds like challenging work, at least. How similar is it to your producing work with Obsidian? (That is if you're allowed to talk about what you got up to.)

Avatar image for bisonhero
BisonHero

12794

Forum Posts

625

Wiki Points

0

Followers

Reviews: 1

User Lists: 2

Edited By BisonHero

Haha, this read was more interesting than I expected it to be. Sure you're not sharing too much, Rorie? The compromised/hacked staff account issue from a few months ago comes to mind; why does CBSi's cyber crime unit/legal team/whatever handle that guy, but not these fraudulent orders?

Avatar image for ravenlight
Ravenlight

8057

Forum Posts

12306

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Please blog about what you're up to more often! This was a super interesting read!

Avatar image for yoldo1
yoldo1

4

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

That was an interesting read! Please post more.

Avatar image for mormonwarrior
MormonWarrior

2945

Forum Posts

577

Wiki Points

0

Followers

Reviews: 15

User Lists: 21

Edited By MormonWarrior

@rorie: No need. Sophie is my sister's dog and is always suuuuuper skinny. Teddy's getting old and sort of fat and is quite a bit bigger (relatively speaking) even though the photo doesn't show that well. He's a very special dog to us. We have a couple of dachshunds too, both sisters.

Avatar image for rickyyo
rickyyo

290

Forum Posts

74

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

@rorie: Hey Rorie you mentioned Venezuela in this article. My mother is Venezuelan and is currently living there. Right now there is a lot of political turmoil, stealing, and murder. I'll ask her what the procedure for that kind of stuff is and why someone over there might do it. It seems like you nailed the right answer which is to verify whether the card they stole is legit. It just seems weird they would target the Giant Bomb store.

Avatar image for the_nubster
The_Nubster

5058

Forum Posts

21

Wiki Points

0

Followers

Reviews: 3

User Lists: 1

This is super interesting to read. Looking forward to more of it in the future! I always love me some inner baseball (that's a phrase, right?) from the places that I spend time at.

Avatar image for rorie
rorie

7888

Forum Posts

1502

Wiki Points

0

Followers

Reviews: 4

User Lists: 3

@rickyyo said:

@rorie: Hey Rorie you mentioned Venezuela in this article. My mother is Venezuelan and is currently living there. Right now there is a lot of political turmoil, stealing, and murder. I'll ask her what the procedure for that kind of stuff is and why someone over there might do it. It seems like you nailed the right answer which is to verify whether the card they stole is legit. It just seems weird they would target the Giant Bomb store.

I was reading something on this, and apparently some of the places in south Florida are used by people overseas who want to order stuff from the States but don't want to pay large shipping fees. So apparently some of these places consist of actual buyers who'll get a bunch of merchandise, ship all of it at once, and then reship it to the individual buyers back in the other country to cut down on costs. No idea if it's true or not!