Expand my Community achievements bar.

How to identify hits for Out of Stock

Avatar

Level 1

Hi Team,

 

I am trying to understand the out of stock % for products in our ecommerce website. We have 2 shipping methods available (BOPS & S2H) on every product detail page and as per the store selected by the customer, on the PDP page, product availability will be shown. 

 

Existing way of calculating OOS%:

We look at those hits where product view exists and if either of the shipping methods are unavailable, then we consider that hit as a OOS hit. Then we divide this with over all product view hits to calculate the OOS%.

Venky5080_0-1719559659658.png

 

What we want to achieve?

 

1. A customer wants the products to be delivered by BOPS

2. The customer visits the product detail page

3. Product is available for BOPS & not available for S2H

4. As per current calculation, this hit will be considered as a OOS hit as the product is not available for S2H

5. The customer adds the product to cart as it is available for BOPS

6. So this hit should not be considered as a OOS hit

 

we have an evar for each of the shipping methods availability on the product view hit. Can you please tell me what is the best way to achieve this.

2 Replies

Avatar

Community Advisor

HI @Venky5080 

hope that I understood your question correctly.

 

Since as long as your are using the logical OR statement in your segment, as soon as one occurs, it is evaluates to true an OOS if encountered.

So, basically what you want to achieve is rather two different segments, one for each condition.

 

But since you are having the pieces of information captured separately, you would technically not even need segments and do filtering directly in your dashboard.

I would still go for segments, since this keeps things clean, and you can create a proper description for it.

 

Hope that helps

 

 

Cheers from Switzerland!


Avatar

Level 1

Hi @bjoern__koth , Thanks for this answer. I have a follow up question.

 

What if I want to create a segment that lets me count only

1. those product views where either one of the 2 shipping methods show unavailability &

2. the user has not done any action like "Add to Cart".

 

Can you please help me create a segment or a solution to identify the number of such product views?