7 ms·

I once had a retail client wishing for an "in-store Google Maps" that would guide customers to the products they are looking for. "So if I'm looking for pasta,

I once had a retail client wishing for an "in-store Google Maps" that would guide customers to the products they are looking for. "So if I'm looking for pasta, the app should show me on what aisle to find it. That shouldn't be too difficult, should it?", he asked. I asked him how the location of products is stored now. "Is there a system, a database that keeps track of where in the store, on what shelves, product is stocked? Something the app could use so it knows where your pasta can be found?" He didn't understand the question. So I asked him how workers who stock the shelves know where to put what products. There must be a system that gives the workers that information, right? "Oh no", he said, "there is no system. They know through experience and gut-feeling."

MattGaiser 6y ago
Make an app that texts a contractor those questions and lets them drop a pin on a map. Then bill 250,000 a year for the contractor and call it software as a service.
- lmkg 6y ago
  As as art project, someone made a camera that, when you snap the shutter, prints out a text description instead of an image. Under the hood, the camera actually submitted the image to Mechanical Turk.
  - notyourday 6y ago
    That sounds like a super fundable MVP.
jiveturkey 6y ago
and what's wrong with that? the client is asking for an ML solution. or, more basic, a stock person still has to stock the shelves, so they can scan as they stock. or customers themselves can report inventory locations. just tell the customer a random (at first) location for pasta. when you sense they've gotten there, prompt them whether it was there or not. amortized over time, this is an immeasurable fraction of customers that would have to do the inventory work. i get it, you're trying to give an example of an impossible request, of which there are many, but this just isn't one of those.
- whateveracct 6y ago
  What you're describing would be a nonstarter in retail in my experience. They care too much about customer experience to amortize the cost of a bad experience. Typically, step 1 is capturing data via added company process about the thing you're gonna automate. A lot more boring than what you describe.
  - jiveturkey 6y ago
    no, that's exactly what i described. a paid existing employee collecting location data while stocking. i actually do think that customer-finding is a good approach, but it's up to the client to decide isn't it. the comment i'm replying to was about impossible requests by clueless clients, not about bad but possible implementations. even if the idea is in fact bad, which again i dispute, it's always good to give a client an alternative that stinks, so that the idea you want them to accept seems "obviously" good. i forget what this technique is called. EDIT: after an hour of searching, I believe it's called a "duck". based on the legend of Battle Chess, but of course the technique has existed long, long before Battle Chess.
- Klinky 6y ago
  That sounds incredibly customer hostile. "Let's send you to the wrong location and waste your time, oh and while you're there, do our job for us!"
- MattGaiser 6y ago
  >just tell the customer a random (at first) location for pasta. when you sense they've gotten there, prompt them whether it was there or not. Pissing off an enormous number of customers in the process. You will run out of customers at the store willing to use such a useless app before the thing learns where the pasta is. Your stock person idea makes sense if they keep the shelves stable, but "gut feeling" organizations tells me that things can shift around over time.
  - deleted 6y ago
    [deleted]
kohtatsu 6y ago
That'd be pretty fun to make assuming they could bankroll it.
barbecue_sauce 6y ago
Most modern supermarket chains are organized in such a way that location data should be available (or at least calculable). To assert that there is no "system" to a store's layout and that employees know through "experience and gut-feeling" means that this retailer was not conforming to industry norms or was just not a very large retailer. All supermarkets have some sort of product taxonomy, categories and subcategories, that influence the macro-placement of a product within the store. This discipline is known as "space planning", where large categories are placed within the foot print of a store's layout. Within the category placement, stores use "planograms", which are shelf-by-shelf layouts of which products go where, how many facings they have, how much footage is designated to the sub-category, etc. While its true that workers for the most part know the locations of items by experience, this experience is informed by their ever growing knowledge/intuition of this taxonomy. (Usually, products are organized by aisle in the backroom when the delivery comes in; workers are simply taking groups of products that have already been organized out to the floor). The planograms themselves are usually stored in a database, and this data could be cross-referenced with other common data sources (product, pricing, etc.) to determine store location.
- mark-r 6y ago
  You forgot about the manufacturers who pay for specific product placement. Sometimes the store workers will only have a vague idea because the supplier has been given full responsibility for shelf layout.
  - barbecue_sauce 6y ago
    This usually only applies to certain categories and depends on the pricing model of the supermarket (and the supplier/purchaser power dynamics that depend mostly on the size of the retailer). Soda, chips, crackers and cookies are the most prominent categories that have any significant amount of placement power, and that's mostly because the big players use a direct store delivery model that helps alleviate labor costs at the store level.
- PaulDavisThe1st 6y ago
  Apparently, you are not familiar with Trader Joes. Some (all?) of their stores regularly rearrange the entire store. My assumption has been that they are hoping for you to serendipitously discover new products/categories and purchase them. The produce section generally seems to remain fixed.
beckler 6y ago
I can tell you that most major retailers (target, walmart, etc) most definitely have a system. It not only specifies which aisle to put things on, but exactly which shelf, and how much space is allocated for that product. I can't remember what they're called, but they're required for every product sold in those stores. When I worked at Walmart in college, we were issued these plans weekly. Obviously this is probably not the case with smaller retailers.
Benjammer 6y ago
I don't know how long ago "once" is, or how big this client was, but every modern large grocery company is pretty data-driven, especially about where products are placed. Lots of places have robots crawling the aisles in real time updating stocking information and taking video/images of product presentation on the shelves. They are presented as "cleanup robots" and they put googly eyes on them and a name tag or whatever. I even once asked several employees about them, and they just shrugged and said "yeah it's the cleaning robot." But it's a column 6 ft high it's not a roomba. It has a clearly visible array of cameras on each side, and who knows what other sensors. Check out this image search, for "grocery data cleanup robot": https://www.google.com/search?q=grocery+data+cleanup+robot&rlz=1C1CHBF_enUS769US769&source=lnms&tbm=isch&sa=X&ved=2ahUKEwiI2-qE-obpAhWlT98KHYWlAnAQ_AUoAXoECDUQAw&biw=1920&bih=937 https://www.google.com/search?q=grocery+data+cleanup+robot&r...
- EsotericAlgo 6y ago
  This is true but generally only for grocery and a handful of the big box retailers. The merchandising information is typically well known along with product taxonomy, but the mapping of this relative information to a physical layout isn't always cleanly implemented or available. A typical scenario is sku 85111 is grouped in a product hierarchy (family > sub category > subdepartment > department or the retailer equivalent) and that sku is assigned to a planogram or set of planograms associated with a display fixture (which sometimes have a hierarchy of their own (e.g. peg > shelf > section > aisle) with mixed relative distancing. There's generally a departmental divide between who manages product and merchandising information. Many of these robots to my knowledge use the products or special tags as unique identifiers as opposed to an indoor-positioning system that ties back to an exact product location. So it's frequently easy to say that a product is in aisle 20 section 2 shelf 1 it's not easy to say from your current location go down 8 aisle and up half an aisle, look on your left.
deanCommie 6y ago
Your replies are a mixture of "This sounds false - large supermarkets would have this data" and "This is just an ML use case" and i think both miss the point. Work backwards from the customer need. If they truly need this system, and are willing to pay for it, then it sounds like what you need to build is: * A database for product taxonimies/locations * An internal tool to make it easy and quick for staff to go through and log the locations of products to build out the data model * The actual maps UI and display tech. The thing is, this might not even be that much work. It's all a factor of how many "categories" the store expects customers to be able to search for. If the granularity level is "pasta", you can probably get away with 100 entries, and 1 days of grunt work for a staff member to log the location in the store where "pasta" and "coffee" and "condiments" etc are. This story is not a good example of a difficult customer or a difficult technical problem.
robbrown451 6y ago
Seems like a perfectly good request. Stores have an incentive in providing this information, as they currently have to pay employees to provide this information directly to customers. When I was a retail employee (Kmart, in the 80s) it took a long time to learn this information, and it wasted a lot of my time. (as often as not, I had to ask someone else for the first few months) I wasted a 3-4 minutes of a Safeway employee's time in this way the last time I was there a few days ago (I couldn't find birthday candles). Theoretically, the solution you described would probably save a ton of money overall. I have no doubt it will exist in the not-so-distant future.
- anp 6y ago
  It’s wasteful if you assume it could be automated, but helping customers find things is just “service” most of the time.
  - robbrown451 6y ago
    Yes when using the word "waste" I am comparing it to being automated, which it most certainly can. Just as we might consider it a waste to have an elevator operator, when that task has been automated for nearly a century. At one time it was just accepted as a cost of running a tall building.
    - salawat 6y ago
      You're still missing the point. There is a point where the systemic rigidity enforced to make automation feasible is far more expensive than the value it actually produces by existing. I.e. In order to replace those store employees, you have to build all your buildings the same way, stock them in a certain way, hire maintainers to input tracking data, hire auditors to ensure customers aren't tampering with the store.... So on and so forth. It'd be a great way to protest though. Every customer goes out of their way to disorganize the store until they hire locals.
      - robbrown451 6y ago
baxtr 6y ago
So the best way to solve this is to have an in-store map to find workers of the store so you can ask them.
- thomk 6y ago
  Your comment is funny. Have an upvote.
Aeolun 6y ago
In that case the app can display the same helpful message: “Please follow your experience and gut feeling.”
titzer 6y ago
"Oh no", he said, "there is no system. They know through experience and gut-feeling." Let me guess, this person is under 30. Not to be that old angry, ageist person, but that combination of ignorance, arrogance and complete dismissal of the entire history of humans beforehand is pretty annoying at this point. Before software people managed pretty well!
flukus 6y ago
Aside from an interactive map being overkill, are you sure you weren't complicating things here too? It seems like you were expecting some sort of system integration, but the customer wanted to just email an excel spreadsheet when there were updates, if they'd even thought of that.
Viliam1234 6y ago
Maybe the workflow could be reversed. First let the workers put the product wherever they feel like; then get the information into the application. From user perspective, the easiest way would be to take a photo of the shelf using their smartphone. (Either the worker is required to take the photo after putting a product on the shelf, or you would have another worker periodically walking through the shop, making photos. I assume the products do not change their places often.) The picture would be analyzed, possibly additional questions asked. The image recognition could be helped by a database that would know which products are typically placed next to which ones. Okay, I assume the client's next question would be: "Why does it take 10 years and 10 million dollars?"

MattGaiser 6y ago

Make an app that texts a contractor those questions and lets them drop a pin on a map. Then bill 250,000 a year for the contractor and call it software as a service.

lmkg 6y ago
As as art project, someone made a camera that, when you snap the shutter, prints out a text description instead of an image. Under the hood, the camera actually submitted the image to Mechanical Turk.
- notyourday 6y ago
  That sounds like a super fundable MVP.

jiveturkey 6y ago

and what's wrong with that? the client is asking for an ML solution. or, more basic, a stock person still has to stock the shelves, so they can scan as they stock. or customers themselves can report inventory locations. just tell the customer a random (at first) location for pasta. when you sense they've gotten there, prompt them whether it was there or not. amortized over time, this is an immeasurable fraction of customers that would have to do the inventory work. i get it, you're trying to give an example of an impossible request, of which there are many, but this just isn't one of those.

whateveracct 6y ago
What you're describing would be a nonstarter in retail in my experience. They care too much about customer experience to amortize the cost of a bad experience. Typically, step 1 is capturing data via added company process about the thing you're gonna automate. A lot more boring than what you describe.
- jiveturkey 6y ago
  no, that's exactly what i described. a paid existing employee collecting location data while stocking. i actually do think that customer-finding is a good approach, but it's up to the client to decide isn't it. the comment i'm replying to was about impossible requests by clueless clients, not about bad but possible implementations. even if the idea is in fact bad, which again i dispute, it's always good to give a client an alternative that stinks, so that the idea you want them to accept seems "obviously" good. i forget what this technique is called. EDIT: after an hour of searching, I believe it's called a "duck". based on the legend of Battle Chess, but of course the technique has existed long, long before Battle Chess.
Klinky 6y ago
That sounds incredibly customer hostile. "Let's send you to the wrong location and waste your time, oh and while you're there, do our job for us!"
MattGaiser 6y ago
>just tell the customer a random (at first) location for pasta. when you sense they've gotten there, prompt them whether it was there or not. Pissing off an enormous number of customers in the process. You will run out of customers at the store willing to use such a useless app before the thing learns where the pasta is. Your stock person idea makes sense if they keep the shelves stable, but "gut feeling" organizations tells me that things can shift around over time.
- deleted 6y ago
  [deleted]

kohtatsu 6y ago

That'd be pretty fun to make assuming they could bankroll it.

barbecue_sauce 6y ago

Most modern supermarket chains are organized in such a way that location data should be available (or at least calculable). To assert that there is no "system" to a store's layout and that employees know through "experience and gut-feeling" means that this retailer was not conforming to industry norms or was just not a very large retailer. All supermarkets have some sort of product taxonomy, categories and subcategories, that influence the macro-placement of a product within the store. This discipline is known as "space planning", where large categories are placed within the foot print of a store's layout. Within the category placement, stores use "planograms", which are shelf-by-shelf layouts of which products go where, how many facings they have, how much footage is designated to the sub-category, etc. While its true that workers for the most part know the locations of items by experience, this experience is informed by their ever growing knowledge/intuition of this taxonomy. (Usually, products are organized by aisle in the backroom when the delivery comes in; workers are simply taking groups of products that have already been organized out to the floor). The planograms themselves are usually stored in a database, and this data could be cross-referenced with other common data sources (product, pricing, etc.) to determine store location.

mark-r 6y ago
You forgot about the manufacturers who pay for specific product placement. Sometimes the store workers will only have a vague idea because the supplier has been given full responsibility for shelf layout.
- barbecue_sauce 6y ago
  This usually only applies to certain categories and depends on the pricing model of the supermarket (and the supplier/purchaser power dynamics that depend mostly on the size of the retailer). Soda, chips, crackers and cookies are the most prominent categories that have any significant amount of placement power, and that's mostly because the big players use a direct store delivery model that helps alleviate labor costs at the store level.
PaulDavisThe1st 6y ago
Apparently, you are not familiar with Trader Joes. Some (all?) of their stores regularly rearrange the entire store. My assumption has been that they are hoping for you to serendipitously discover new products/categories and purchase them. The produce section generally seems to remain fixed.

beckler 6y ago

I can tell you that most major retailers (target, walmart, etc) most definitely have a system. It not only specifies which aisle to put things on, but exactly which shelf, and how much space is allocated for that product. I can't remember what they're called, but they're required for every product sold in those stores. When I worked at Walmart in college, we were issued these plans weekly. Obviously this is probably not the case with smaller retailers.

Benjammer 6y ago

I don't know how long ago "once" is, or how big this client was, but every modern large grocery company is pretty data-driven, especially about where products are placed. Lots of places have robots crawling the aisles in real time updating stocking information and taking video/images of product presentation on the shelves. They are presented as "cleanup robots" and they put googly eyes on them and a name tag or whatever. I even once asked several employees about them, and they just shrugged and said "yeah it's the cleaning robot." But it's a column 6 ft high it's not a roomba. It has a clearly visible array of cameras on each side, and who knows what other sensors. Check out this image search, for "grocery data cleanup robot": https://www.google.com/search?q=grocery+data+cleanup+robot&rlz=1C1CHBF_enUS769US769&source=lnms&tbm=isch&sa=X&ved=2ahUKEwiI2-qE-obpAhWlT98KHYWlAnAQ_AUoAXoECDUQAw&biw=1920&bih=937 https://www.google.com/search?q=grocery+data+cleanup+robot&r...

EsotericAlgo 6y ago
This is true but generally only for grocery and a handful of the big box retailers. The merchandising information is typically well known along with product taxonomy, but the mapping of this relative information to a physical layout isn't always cleanly implemented or available. A typical scenario is sku 85111 is grouped in a product hierarchy (family > sub category > subdepartment > department or the retailer equivalent) and that sku is assigned to a planogram or set of planograms associated with a display fixture (which sometimes have a hierarchy of their own (e.g. peg > shelf > section > aisle) with mixed relative distancing. There's generally a departmental divide between who manages product and merchandising information. Many of these robots to my knowledge use the products or special tags as unique identifiers as opposed to an indoor-positioning system that ties back to an exact product location. So it's frequently easy to say that a product is in aisle 20 section 2 shelf 1 it's not easy to say from your current location go down 8 aisle and up half an aisle, look on your left.

deanCommie 6y ago

Your replies are a mixture of "This sounds false - large supermarkets would have this data" and "This is just an ML use case" and i think both miss the point. Work backwards from the customer need. If they truly need this system, and are willing to pay for it, then it sounds like what you need to build is: * A database for product taxonimies/locations * An internal tool to make it easy and quick for staff to go through and log the locations of products to build out the data model * The actual maps UI and display tech. The thing is, this might not even be that much work. It's all a factor of how many "categories" the store expects customers to be able to search for. If the granularity level is "pasta", you can probably get away with 100 entries, and 1 days of grunt work for a staff member to log the location in the store where "pasta" and "coffee" and "condiments" etc are. This story is not a good example of a difficult customer or a difficult technical problem.

robbrown451 6y ago

Seems like a perfectly good request. Stores have an incentive in providing this information, as they currently have to pay employees to provide this information directly to customers. When I was a retail employee (Kmart, in the 80s) it took a long time to learn this information, and it wasted a lot of my time. (as often as not, I had to ask someone else for the first few months) I wasted a 3-4 minutes of a Safeway employee's time in this way the last time I was there a few days ago (I couldn't find birthday candles). Theoretically, the solution you described would probably save a ton of money overall. I have no doubt it will exist in the not-so-distant future.

anp 6y ago
It’s wasteful if you assume it could be automated, but helping customers find things is just “service” most of the time.
- robbrown451 6y ago
  Yes when using the word "waste" I am comparing it to being automated, which it most certainly can. Just as we might consider it a waste to have an elevator operator, when that task has been automated for nearly a century. At one time it was just accepted as a cost of running a tall building.
  - salawat 6y ago
    You're still missing the point. There is a point where the systemic rigidity enforced to make automation feasible is far more expensive than the value it actually produces by existing. I.e. In order to replace those store employees, you have to build all your buildings the same way, stock them in a certain way, hire maintainers to input tracking data, hire auditors to ensure customers aren't tampering with the store.... So on and so forth. It'd be a great way to protest though. Every customer goes out of their way to disorganize the store until they hire locals.
    - robbrown451 6y ago

baxtr 6y ago

So the best way to solve this is to have an in-store map to find workers of the store so you can ask them.

thomk 6y ago
Your comment is funny. Have an upvote.

Aeolun 6y ago

In that case the app can display the same helpful message: “Please follow your experience and gut feeling.”

titzer 6y ago

"Oh no", he said, "there is no system. They know through experience and gut-feeling." Let me guess, this person is under 30. Not to be that old angry, ageist person, but that combination of ignorance, arrogance and complete dismissal of the entire history of humans beforehand is pretty annoying at this point. Before software people managed pretty well!

flukus 6y ago

Aside from an interactive map being overkill, are you sure you weren't complicating things here too? It seems like you were expecting some sort of system integration, but the customer wanted to just email an excel spreadsheet when there were updates, if they'd even thought of that.

Viliam1234 6y ago

Maybe the workflow could be reversed. First let the workers put the product wherever they feel like; then get the information into the application. From user perspective, the easiest way would be to take a photo of the shelf using their smartphone. (Either the worker is required to take the photo after putting a product on the shelf, or you would have another worker periodically walking through the shop, making photos. I assume the products do not change their places often.) The picture would be analyzed, possibly additional questions asked. The image recognition could be helped by a database that would know which products are typically placed next to which ones. Okay, I assume the client's next question would be: "Why does it take 10 years and 10 million dollars?"