Functionality

The tool analyzes inventory changes and user Browse history to send timely availability alerts. This allows you to build campaigns that recapture the interest of shoppers who were previously unable to buy.

• Identifies Restocked Products: Scans for products that have had a significant increase in stock within the last 24 hours.
• Ensures Availability: Filters recommendations to only include items that are currently in stock and available for purchase.
• Targets Interested Shoppers: Finds users who have viewed these specific products in the past but have not yet completed an order.
• Prioritizes Recommendations: Recommends products by prioritizing items with the largest stock increase and highest popularity to maximize engagement.

How it Works

1. Identify Recent Product Viewers: The system looks for users who have viewed products within the specified Activity Window (e.g., the last 30 days).
2. Calculate Stock Change: It compares the current stock level in the inventory with a snapshot from 24 hours prior to identify products that were previously out of stock or have been restocked.
3. Apply Filters: The tool filters the list to include products that are now currently available and meet the Min Stock Level. This can be configured to trigger on any stock increase (e.g., from 0 to 1).
4. Exclude Converted Users: To avoid sending irrelevant notifications, it filters out any users who have already purchased the product within the defined Activity Window.
5. Rank and Recommend: For each eligible user, the system ranks the matching products by the magnitude of the stock change and a popularity score, then delivers the top N recommendations.

Visualizing the Process

Configurable Parameters & Terminology

These parameters allow you to customize the recommendation logic to fit your campaign strategy:

• Activity Window: The number of past days to consider when evaluating a user's product views and purchase history.
• Number of Recommendations: The maximum number of products to recommend to a single user.
• Min Stock Level: The minimum stock level an item must have to be considered available for recommendation.

Outputs & Data Points

The system generates these key outputs to populate your campaigns:

• userid: The identifier for the user who viewed the product.
• product_id: The unique identification code for the product.
• sku_id: The SKU identifier for the product.
• variant_id: The variant identifier for the product.
• item_name: The name of the recommended product.
• product_description: A description of the product.
• product_url: The URL linking to the product page.
• product_image: The URL for the product's image.
• release_date: The release date of the product.
• previous_Stock: The product's stock level before the increase.
• current_Stock: The new, current stock level of the product.
• stock_change_percentage: The calculated percentage of the stock increase.
• popularity_score: The popularity score of the product.
• rating: The rating score of the product.

Data Integration Requirements

For seamless operation, the tool integrates with the following data sources:

• PRODUCT VIEW events (Mandatory): Used to identify which products a user has shown interest in. Key fields include userid, url, and product_id.
• Online Order events (Mandatory): Used to exclude users who have already purchased the product. Key fields include userid and product_id.
• Inventory (Mandatory): Contains product metadata, pricing, and stock levels. Key fields include price, stock, product_id, sku_id, variant_id, isavailable, release_date, product_image, product_description, and product_url.