Model complex BOGO, bundle, and tiered discounting scenarios across your SKUs to prevent accidental negative profit margins
Customize Prompt Variables
Type your specific product details or store requirements into the fields below. Watch your customized prompt update automatically in the right pane.
You are an E-commerce Chief Financial Officer and Shopify Discount Strategy Specialist. Aggressive sales events can cause devastating margin erosion if COGS, fulfillment costs, merchant processing fees, and combined discounts are not modeled accurately.
### SKU FINANCIAL DATA:
1. SKU: ESPRESSO-PRO-01 | Retail Price: $299.00 | COGS: $115.00 | Pick/Pack & Shipping: $18.50 | Payment Processing: 2.9% + $0.30
2. SKU: COFFEE-BAG-1KG | Retail Price: $38.00 | COGS: $9.50 | Pick/Pack & Shipping: $5.50 | Payment Processing: 2.9% + $0.30
3. SKU: GRINDER-MANUAL | Retail Price: $65.00 | COGS: $18.00 | Pick/Pack & Shipping: $7.00 | Payment Processing: 2.9% + $0.30
### PROPOSED DISCOUNT & BUNDLE SCENARIOS:
Scenario A: 25% Off Sitewide with Free Shipping across all orders. Scenario B: Buy the Espresso Pro machine ($299), get the Manual Grinder ($65) for 50% off plus 1 Bag of Coffee ($38) FREE.
### YOUR ASSIGNMENT:
Perform a comprehensive Margin & Profitability Audit for each proposed discount scenario:
1. **Itemized Financial Contribution Margin Table**:
- For each SKU under normal retail pricing vs Scenario A vs Scenario B, calculate:
- Gross Revenue after discount
- Exact Payment Processing Fee (2.9% + $0.30 or provided rate)
- Total COGS + Fulfillment/Shipping cost
- Net Dollar Profit per order ($)
- Net Profit Margin (%)
2. **Margin Danger Zone & Break-Even Analysis**:
- Flag any SKU or bundle scenario where net profit margin drops below a healthy 20% threshold or turns negative.
- Calculate exact break-even volume needed to match normal baseline profit dollars if discounting by these percentages.
3. **CFO Optimization Recommendations**:
- Propose 2 modified, "margin-safe" alternative discount structures that still provide high customer perceived value (e.g., tiered dollar thresholds, gift-with-purchase rather than straight percentage discounts) while protecting at least a 28% net profit floor.How to Use This Prompt
- 1
Input your SKU unit economics (Retail price, COGS, average fulfillment cost) and proposed discount codes.
- 2
Run in Claude before activating any discount code in Shopify Admin.
- 3
In Claude Code, you can ask Claude to run this analysis on your exported Shopify product CSV.
Run directly inside Claude Code
If you have installed our Shopify AI Toolkit scopes, Claude can connect directly to your Shopify store via GraphQL. Paste this customized prompt into your terminal and let Claude read/write products, metafields, or theme files autonomously.
Want the full terminal setup & code guide for this prompt?
Check out our dedicated deep-dive in the AI for Shopify library. We walk through exact CLI commands, Liquid file modifications, and automation workflows.
Explore More AI Prompts
Discover related Claude workflows for Store Operations and beyond.
Customer Review & UGC Feedback Sentiment Synthesizer
Extract hidden product flaws, feature requests, and top praised benefits from raw batches of customer reviews
Stop reading hundreds of reviews manually. Paste a raw CSV or text batch of store reviews and let AI categorize exact sentiment trends, product improvement action items, and ad copywriting goldmines.
Helpdesk & AI Chatbot Knowledge Base Structuring Builder
Convert messy shipping and return policies into structured knowledge base rules for Gorgias, Zendesk, and AI chatbots
AI customer support agents and human agents need structured, unambiguous policy logic. This prompt converts raw store policies into exact decision trees and macro templates.
SEO Product Title & Meta Description Optimizer
Turn thin vendor copy into high-ranking, keyword-targeted product titles and descriptions tailored for Google & organic CTR
Ideal for dropshipping imports and new SKUs. Researches search intent, formats high-conversion H1 titles, and writes clean HTML body descriptions with scannable bullet points.
Want us to install these Claude workflows directly on your Shopify store?
We configure the Shopify AI Toolkit scopes, connect Claude Code sessions, build custom Liquid sections, and train AI assistants on your exact brand voice.