Inventory Forecast

v1.0.0

Project inventory needs based on historical order velocity, seasonality, and planned promotions so you reorder before stockouts hurt rankings.

0· 204·0 current·0 all-time
byLeroyCreates@leooooooow

Install

OpenClaw Prompt Flow

Install with OpenClaw

Best for remote or guided setup. Copy the exact prompt, then paste it into OpenClaw for leooooooow/inventory-forecast.

Previewing Install & Setup.
Prompt PreviewInstall & Setup
Install the skill "Inventory Forecast" (leooooooow/inventory-forecast) from ClawHub.
Skill page: https://clawhub.ai/leooooooow/inventory-forecast
Keep the work scoped to this skill only.
After install, inspect the skill metadata and help me finish setup.
Use only the metadata you can verify from ClawHub; do not invent missing requirements.
Ask before making any broader environment changes.

Command Line

CLI Commands

Use the direct CLI path if you want to install manually and keep every step visible.

OpenClaw CLI

Bare skill slug

openclaw skills install inventory-forecast

ClawHub CLI

Package manager switcher

npx clawhub@latest install inventory-forecast
Security Scan
VirusTotalVirusTotal
Pending
View report →
OpenClawOpenClaw
Benign
high confidence
Purpose & Capability
Name/description ask for inventory forecasting and the skill only requires historical sales, current inventory, lead times and optional promotions — all appropriate and proportional to the stated goal.
Instruction Scope
SKILL.md instructs the agent to produce forecasts from user-supplied data; it explicitly states it does not connect to live systems and does not ask the agent to read unrelated files, environment variables, or external endpoints.
Install Mechanism
No install spec and no code files are present (instruction-only), so nothing is downloaded or written to disk — lowest-risk install profile.
Credentials
No environment variables, credentials, or config paths are requested; required inputs are data the user provides directly (CSV/spreadsheet/raw numbers), which is proportionate.
Persistence & Privilege
always is false and the skill is user-invocable; it does not request permanent presence or cross-skill/system configuration changes.
Assessment
This skill is instruction-only and internally consistent: it will ask you to paste or upload historical sales, current stock, lead times and planned promotions and will return forecasts and reorder recommendations. Before using it, avoid pasting sensitive personal or customer-identifiable data into free-text fields (use anonymized or aggregate data where possible). If you need live integration with your ERP/WMS, expect to use a different skill or connector — this one requires manual data input. If you plan to let an agent invoke skills autonomously and are concerned about automatic actions, review your agent's autonomy settings (this skill does not itself request persistent credentials or system access). Finally, test with sample or non-production data to verify the outputs and assumptions before acting on purchase orders.

Like a lobster shell, security has layers — review code before you run it.

latestvk97dmx0yp997v274majdvcrg8183vx5x
204downloads
0stars
1versions
Updated 1mo ago
v1.0.0
MIT-0

Inventory Forecast

Running out of stock is one of the most costly mistakes in ecommerce — it tanks your search rankings, hands sales to competitors, and can take weeks to recover from. This skill projects your inventory needs by analyzing historical order velocity, seasonal demand patterns, supplier lead times, and upcoming promotional events so you can place reorders with confidence before stockouts damage your momentum.

Use when

  • You notice a fast-moving SKU is dropping below safety stock levels and need to calculate exactly when to place the next purchase order to avoid a gap in availability
  • You are planning a major promotional event like a TikTok Shop Flash Sale, Shopee 9.9 campaign, or Amazon Prime Day and need to estimate how much extra inventory to pre-position based on expected demand lift
  • Your supplier has long lead times of 30 to 90 days and you need to build a rolling reorder calendar that accounts for production, shipping, and customs clearance delays
  • You want to compare sell-through rates across multiple SKUs or product categories to identify which items need urgent restocking versus which ones are overstocked and tying up cash
  • You are expanding to a new warehouse or fulfillment center and need to decide initial stock allocation quantities based on regional demand forecasts

What this skill does

This skill takes your historical sales data, current inventory levels, supplier lead times, and any planned promotions or seasonal events as inputs, then builds a forward-looking demand projection for each SKU or product group. It applies velocity-based forecasting adjusted for weekly and monthly seasonality curves, calculates safety stock buffers based on demand variability and lead time uncertainty, and generates specific reorder dates with recommended quantities. The output helps you maintain optimal stock levels without over-ordering, which is especially critical for cash-constrained sellers managing dozens or hundreds of SKUs across multiple channels.

Inputs required

  • Historical sales data (required): Daily or weekly unit sales for each SKU over the past 3 to 12 months. Provide as a CSV, spreadsheet export, or paste raw numbers. Example: "SKU-A sold 142 units in January, 198 in February, 310 in March."
  • Current inventory levels (required): How many units of each SKU you currently have on hand and in transit. Example: "SKU-A: 450 on hand, 200 in transit arriving April 5."
  • Supplier lead time (required): The number of days from placing a purchase order to receiving goods at your warehouse. Example: "45 days from order to delivery for our Shenzhen supplier."
  • Planned promotions or events (optional): Any upcoming campaigns, flash sales, influencer pushes, or seasonal peaks that could spike demand. Including these dramatically improves forecast accuracy. Example: "Running a 30% off flash sale on May 5, expecting 3x normal daily volume."
  • Target days of supply (optional): How many days of inventory buffer you want to maintain. Defaults to 30 days if not specified. Helps calibrate reorder aggressiveness to your risk tolerance and cash position.

Output format

The output is structured in four sections. First, a Demand Forecast Table showing projected daily and weekly unit sales for each SKU over the next 30, 60, and 90 days with seasonality adjustments applied. Second, a Reorder Schedule listing the specific date each SKU should be reordered, the recommended order quantity, and the expected arrival date based on lead time. Third, a Risk Assessment highlighting SKUs at high risk of stockout within the next 14 days, SKUs that are overstocked by more than 60 days of supply, and the estimated revenue impact of potential stockouts. Fourth, a Cash Flow Impact summary estimating the total purchase order cost for the forecast period so you can plan working capital needs alongside inventory decisions.

Scope

  • Designed for: ecommerce operators, inventory planners, and supply chain managers running DTC or marketplace businesses
  • Platform context: platform-agnostic — works for TikTok Shop, Amazon FBA, Shopee, Lazada, Shopify, and multi-channel sellers
  • Language: English

Limitations

  • Does not connect to live inventory management systems or ERPs; you must provide current stock data manually or via export
  • Forecasts are based on historical patterns and stated assumptions — unexpected viral moments, supply chain disruptions, or competitor actions may cause actual demand to deviate significantly
  • Does not account for supplier-side constraints like minimum order quantities or tiered pricing unless you specify them in the inputs

Comments

Loading comments...