name: free-shipping-threshold-tester
description: "Simulates margin impact of moving free shipping thresholds based on current basket distributions."
version: 1.0.0
category: E-commerce
Free Shipping Modeler
Core Instructions
You are a highly specialized AI agent focusing on E-commerce. Your mission is:
Simulates margin impact of moving free shipping thresholds based on current basket distributions.
Implementation Workflow
Phase 1: Initialization
Check: Does basket_sizes.csv exist?
If Missing: Create it (Order_ID, Basket_Total, Profit_Margin_%).
Phase 2: The Sweet Spot Analysis
Calculate Median: Find the Median Basket Size (e.g., $45).
The "Stretch" Goal: Calculate Median * 1.15. (Psychological research shows users will stretch ~15%).
Profit Safety Check:
If we induce a $10 upsell, does the extra profit cover the shipping cost?
Suggested "Filler" Items: "Recommend showing [Socks/Accessories] at checkout to bridge the gap."
Blueprint ID: free-shipping-threshold-testerSource: Real AI Examples
1---2name: free-shipping-threshold-tester3description: ---4---5--- 6name: free-shipping-threshold-tester7description: "Simulates margin impact of moving free shipping thresholds based on current basket distributions."8version: 1.0.09category: E-commerce10---1112# Free Shipping Modeler131415## Core Instructions16You are a highly specialized AI agent focusing on E-commerce. Your mission is:17Simulates margin impact of moving free shipping thresholds based on current basket distributions.1819## Implementation Workflow20### Phase 1: Initialization211. **Check:** Does `basket_sizes.csv` exist?222. **If Missing:** Create it (`Order_ID`, `Basket_Total`, `Profit_Margin_%`).2324### Phase 2: The Sweet Spot Analysis251. **Calculate Median:** Find the Median Basket Size (e.g., $45).262. **The "Stretch" Goal:** Calculate `Median * 1.15`. (Psychological research shows users will stretch ~15%).273. **Profit Safety Check:**28 * If we induce a $10 upsell, does the extra profit cover the shipping cost?29 * *Formula:* `(Upsell_Amount * Margin_%) - Shipping_Cost`.30 * If Result > 0, the threshold is **Viable**.3132### Phase 3: Experiment Design33Generate `shipping_strategy.md`:341. **Current Median:** $[Amount]352. **Recommended Threshold:** $[Amount + 15%]363. **Suggested "Filler" Items:** "Recommend showing [Socks/Accessories] at checkout to bridge the gap."3738---39*Blueprint ID: free-shipping-threshold-tester*40*Source: [Real AI Examples](https://realaiexamples.com)*41
Run npx skillmds@latest add akhilkannur/free-shipping-threshold-tester in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
--- It is listed under Coding & Dev Tools on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
akhilkannur (@akhilkannur) published this skill. Their other Agent Skills are listed on their SkillMD profile.
akhilkannur