A couple of days ago, I was doing the weekly shopping as usual at the near shopping mall. I noticed that there is change in the places of some products that I used to buy. I wondered if this change can lead to better or bad results!
From my experience, I can say that its little bit frustrating not to find a product at place that you expect to find. But What about other customers? Do they have the same bad experience? Also, Does this products physical change had a positive effect from mall perspective?! I have to confess that after this change, I started to buy new things I never bought before!
So, I started to think how can we figure out the influence of products position changes in a scientific way or data driven method! I want this method to answer the following questions.
Does the position of product at shopping mall influence the sales of that product? In other words, does changing the product position (i.e. shelving unit, shelf order) influence how many customers seeing the product, interacting with it or buying it?
The Solution Concept:
1- Let’s assume that you have unique number for every shelf unit, and order number for every shelf as shows in the following picture:
2- Then, you should store product position at the shopping mall database. Here is how you may store the product position data (i.e. shelving unit, shelf order) at shopping mall DataBase.
For example: the first row shows that the product that has a SKU number 1250 072 has been sold 85 times, made A$498 revenue and this product exists (Address) at shelf unit number 33 at the second shelf order.
Now, you have the product physical place (Address) connected to the product purchase data. So, you can analyze this data to see if there is a pattern about both variables (product sales and product physical place at the mall).
Finally, here are some results you can get from the the above data set:
1- Does the product physical change has a good or bad effect? You can measure the results of the places change.
2- Discover which shopping mall places perform better regard less the product name.
3- Compare product sales performance based on two different physical places to see which is performing better.
Do you think physical place has an effect on product sales performance? Do you have any related experience with shopping at malls? Was it positive or negative?