Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
Your statistics don't say a thing about WalMart's loss prevention data inside their own stores. If you were privvy to that data, why certain products are locked up would be quite clear.
Let me write the basic query for you:
SELECT item_sku, count(*)
FROM loss_to_theft
WHERE loss_date BETWEEN 01-Jan-2019 AND sysdate
ORDER BY count(*) desc
I guarantee you a query that looks almost identical (minus the dimension data) to the one above powers a daily/weekly/monthly report that the Loss Prevention bosses at WalMart look at on a pretty routine basis. And they probably have a break even number where the cost to lock stuff up, the maintenance of the anti-theft systems, and the possible loss of customers from negative publicity is LESS THAN the cost of what is being stolen. And I bet that rule is baked into the same report and fires some color coding or other visual indicator trigger on the report.
How do I know? Because at my last 4 employers, I have created the database for loss prevention analytics and created the reporting systems for them. One of my easier tasks really, since LP is so straightforward with its rules.
And I bet you dimes to donuts that if you run that simple query above, the black beauty products are going to be at or very near the top of the result set.
Quote:
Originally Posted by Indentured Servant
Yeah it does. It is saying what people on this forum say all the time. Blacks are more criminal. Then they will show you statistics. However, I am not a thief. If I need black hair care products....why should I have to go find a manager with a key?
So just like white people today "never owned a slave" and therefore should not be burdened by the liabilities created from that, I have never stolen hair care products so why should I be burdened just because some blacks did?
Data says no such thing. In fact, according to HR guidelines which I work within when building stuff like Loss Prevention databases, the data is about the stores and the items, not the perpetrators of theft. Loss prevention data tells a tale by SKU and count, by store, state, region, etc. You don't need to know a thing about WHO does the stealing for good LP, you simply need to know WHAT is being stolen the most.
If any product is locked up that makes you go "huh, wonder why that is locked but Item X isn't?" then I guarantee a simple query like the one I wrote would answer it with only asking item and location data, and never ever knowing anything about perpetrators. In fact, I don't recall ever putting data about the people committing theft into a database, doing ETL of that data from anywhere that such data may exist or even being told such data is even collected. Stores don't care about that for LP...just what is stolen the most, and what is the break even on locking it up versus leaving it on the shelf.
The white population rip us off more than the black and the HIGH money white collar crimes- as PONZI and embezzlement, money laundering, leave that black hair grease a a nothing burger.
FBI statistics-- for some refuse to open the link as read real FACTS!
BURGLARY- WHITE 91,581 BLACK 39,617
LARCENY WHITE 448,193 BLACK 201,086
VEH THEFT WHITE 44,512 BLACK 22,305
EMBEZZLEMENT 6,923 ---- 3,955
Now do it again based on % of population. Whites outnumber blacks about 6 to 1 in this country. So if 39,617 blacks commit burglary it would take 237,702 whites committing burglary to be even in the same ball park percent of population wise. Hence racism and stereotyping.
Yeah it does. It is saying what people on this forum say all the time. Blacks are more criminal. Then they will show you statistics. However, I am not a thief. If I need black hair care products....why should I have to go find a manager with a key?
So just like white people today "never owned a slave" and therefore should not be burdened by the liabilities created from that, I have never stolen hair care products so why should I be burdened just because some blacks did?
For the same reason that I, a white person who is not a thief, have to go find a manager to unlock the lithium button batteries which are locked up in my majority-white neighborhood's Walgreen's store. I may not be a thief, but apparently there are enough other white people who are that the store has decided they need to inconvenience everybody in order to keep the shoplifting rate down for those particular items.
Shoplifters hurt us all. We either suffer the inconvenience of having items locked up, or pay much higher prices to offset the store's losses. It sucks, but I don't blame the stores for it. I blame the thieves (who come in all colors).
Your statistics don't say a thing about WalMart's loss prevention data inside their own stores. If you were privvy to that data, why certain products are locked up would be quite clear.
Let me write the basic query for you:
SELECT item_sku, count(*)
FROM loss_to_theft
WHERE loss_date BETWEEN 01-Jan-2019 AND sysdate
ORDER BY count(*) desc
I guarantee you a query that looks almost identical (minus the dimension data) to the one above powers a daily/weekly/monthly report that the Loss Prevention bosses at WalMart look at on a pretty routine basis. And they probably have a break even number where the cost to lock stuff up, the maintenance of the anti-theft systems, and the possible loss of customers from negative publicity is LESS THAN the cost of what is being stolen. And I bet that rule is baked into the same report and fires some color coding or other visual indicator trigger on the report.
How do I know? Because at my last 4 employers, I have created the database for loss prevention analytics and created the reporting systems for them. One of my easier tasks really, since LP is so straightforward with its rules.
And I bet you dimes to donuts that if you run that simple query above, the black beauty products are going to be at or very near the top of the result set.
Data says no such thing. In fact, according to HR guidelines which I work within when building stuff like Loss Prevention databases, the data is about the stores and the items, not the perpetrators of theft. Loss prevention data tells a tale by SKU and count, by store, state, region, etc. You don't need to know a thing about WHO does the stealing for good LP, you simply need to know WHAT is being stolen the most.
If any product is locked up that makes you go "huh, wonder why that is locked but Item X isn't?" then I guarantee a simple query like the one I wrote would answer it with only asking item and location data, and never ever knowing anything about perpetrators. In fact, I don't recall ever putting data about the people committing theft into a database, doing ETL of that data from anywhere that such data may exist or even being told such data is even collected. Stores don't care about that for LP...just what is stolen the most, and what is the break even on locking it up versus leaving it on the shelf.
SELECT product_code, item_sku, count(*) -- where product code is "B" blacks buy or "W" whites buy "B" both
FROM loss_to_theft
Group by product_code, item_skew
HAVING loss_date BETWEEN 01-Jan-2019 AND sysdate and count(*) > 0
ORDER BY count(*) desc
From conversations I've had with clerks at the store, locking up a number of beauty supplies has nothing to do with race. It has to do with the popularity of the product. Many of the products I use are now behind the locked case and I'm not Black. I'm okay with it if it will stop the shoplifting because when someone steals a store's products, my price goes up to compensate the loss. Lock everything up if will stop the thieving.
Not everything done in business matters has to do with race. It's all about the bottom line. Seems EVERYTHING today is a personal affront if it affects them.
Our local Walmart also locks up iPhone accessories, printer cartridges, TV antennas, perfume, cologne, and razors. They lock up things that have a high theft rate.
For the same reason that I, a white person who is not a thief, have to go find a manager to unlock the lithium button batteries which are locked up in my majority-white neighborhood's Walgreen's store. I may not be a thief, but apparently there are enough other white people who are that the store has decided they need to inconvenience everybody in order to keep the shoplifting rate down for those particular items.
Shoplifters hurt us all. We either suffer the inconvenience of having items locked up, or pay much higher prices to offset the store's losses. It sucks, but I don't blame the stores for it. I blame the thieves (who come in all colors).
Yeah...but I got a lock on the lithium batteries...PLUS a lock on hair care products, and you don't.
Yeah...but I got a lock on the lithium batteries...PLUS a lock on hair care products, and you don't.
And jewelry and perfume and most electronics.
It's not racist. It's theft prevention based on their own store data.
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.
Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.