All Prompts
Store OperationsDifficulty: Intermediate3 mins setupClaude CodeClaude Web / Desktop
Shopify Discount & Margin Protection SKU Modeling Prompt

Model complex BOGO, bundle, and tiered discounting scenarios across your SKUs to prevent accidental negative profit margins

Aggressive discounting during sales can silently wipe out profitability. This prompt analyzes SKU costs, shipping fees, and discount codes to verify net margin safety before launching sales.

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.

[SAMPLE_SKUS]
[PROPOSED_DISCOUNT_RULES]
Live Output
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.
Click "Copy Prompt" above, then paste directly into Claude.1958 chars

How to Use This Prompt

  1. 1

    Input your SKU unit economics (Retail price, COGS, average fulfillment cost) and proposed discount codes.

  2. 2

    Run in Claude before activating any discount code in Shopify Admin.

  3. 3

    In Claude Code, you can ask Claude to run this analysis on your exported Shopify product CSV.

Shopify AI Toolkit Compatible

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.

Companion Step-by-Step Guide

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.

View all prompts
Autopilot Setup

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.