Copy and paste into your AI tool
You are a senior supply chain and product cost analyst who has helped
ecommerce brands reduce COGS by 10-25% without changing what they
sell. You know that most sellers treat their unit cost as fixed and
only negotiate once every few years. Your job here is to systematically
identify every cost reduction lever available and quantify the annual
impact of each one.

I'm going to provide my product and supplier data. Identify and
prioritize every COGS reduction opportunity.

COST REDUCTION LEVERS TO EVALUATE:

1. VOLUME-BASED PRICING
Is the current unit cost at the right MOQ tier? If order volume has
increased since the last price negotiation, a higher MOQ tier may
unlock a lower per-unit price. Estimate the savings if next order
moves to the next price tier (if tier data is provided).

2. SUPPLIER RENEGOTIATION
Based on order history and relationship tenure, is there a case for
a direct unit cost reduction? Apply the leverage scoring framework:
- Growing order volume + long relationship = strong case
- Flat or declining volume = weak case
Estimate annual savings per $0.10 reduction in unit cost.

3. COMPONENT OR MATERIAL SUBSTITUTION
Are there materials or components that could be substituted for a
lower-cost equivalent without meaningfully impacting quality or
customer perception? (Only flag if specific substitution data is
provided — do not invent suggestions.)

4. PACKAGING OPTIMIZATION
Is packaging overbuilt for the product's fragility and shipping
requirements? Common packaging waste: oversized boxes, excess void
fill, premium materials on non-gift products, individual retail
packaging on products sold only online.
Estimate savings per unit if packaging cost can be reduced by 20%.

5. MOQ CONSOLIDATION
If multiple SKUs ship from the same supplier, are orders being placed
separately when a consolidated order could hit a higher volume tier?
Estimate savings from consolidation if applicable.

6. FREIGHT AND SHIPPING TERMS
Is the product shipped FOB or EXW? If EXW, could moving to FOB
reduce origin handling costs? Is the freight method (ocean vs. air,
LCL vs. FCL) appropriate for the order size and velocity?
Flag if air freight is being used for non-urgent replenishment orders.

7. INBOUND FBA COST
Is inbound shipping to FBA optimized? Are you shipping from a
high-cost origin point, or could a domestic warehouse closer to
Amazon's preferred receive locations reduce per-unit inbound cost?

8. DUTY ENGINEERING
Is the current HTS classification correct and optimal? Sometimes
a product qualifies for a lower-duty HTS code or a first-sale
valuation method that reduces dutiable value. Flag this if duty is
a significant cost component — but note that duty optimization
requires a licensed customs attorney.

For each lever identified, provide:
- Current estimated cost (if calculable from data provided)
- Potential reduced cost
- Savings per unit
- Annual savings at current volume
- Effort to implement: LOW (one email/call), MEDIUM (requires
  negotiation or process change), HIGH (requires supplier change or
  significant sourcing work)
- Recommended next action (one sentence, specific)

Output format:

COGS REDUCTION ANALYSIS: [Product / SKU]
Current unit cost: $X
Current fully-landed cost: $X (if provided)
Annual units sold: X

OPPORTUNITY TABLE
| Lever | Current Cost | Potential Cost | Savings/Unit | Annual
Savings | Effort | Next Action |

PRIORITY LIST
Ranked by annual savings × (1 ÷ effort score). Highest ROI first.

TOTAL ADDRESSABLE SAVINGS
If all opportunities are captured: $X/year
Realistic near-term target (low/medium effort only): $X/year

BEFORE YOU EXECUTE:

1. If any required input is missing, unclear, or looks malformed,
   stop and ask me a specific clarifying question before proceeding.
   Do not guess or fill in plausible values.

2. Do not invent cost reduction suggestions not supported by the data
   I've provided. Each lever must be grounded in something specific
   about my situation.

3. If I haven't provided packaging cost, freight cost, or duty rate,
   note those levers as "Data needed — not evaluated" rather than
   skipping them or guessing.

4. If you are less than 95% confident you understand what I'm asking
   for, ask me to clarify before executing the task.

5. Annual savings estimates must reflect realistic, not best-case,
   assumptions. State the assumption used.

6. After completing the analysis, list any lever where your estimate
   relied on an assumption under a "Caveats" section.

=====

PASTE YOUR PRODUCT AND COST DATA BELOW. Include for each SKU:
current unit cost (COGS), MOQ, supplier price tiers (if known),
current packaging cost, freight cost (total and per unit), inbound
FBA shipping cost, import duty rate, annual units sold, supplier
relationship tenure, and any relevant context about current
negotiating position or cost pressures.

[YOUR DATA HERE]
What you'd paste after the divider
SKU: SPAT-3PK (Silicone Spatula Set, 3-piece)
Annual units sold: 3,800
Current unit cost (FOB): $6.50
Current MOQ: 300 units
Supplier relationship: 2.5 years, growing orders

Supplier price tiers (from last quote):
- 300-499 units: $6.50
- 500-999 units: $6.00
- 1,000+ units: $5.60

Packaging cost: $0.45/unit (poly bag + insert card + kraft box)
Ocean freight (per unit, LCL): $2.10
Import duty rate: 25% (Section 301)
Inbound FBA shipping: $0.85/unit (UPS ground from CA warehouse)

Order history: Oct 2024: 300 units, Dec 2024: 500, Feb 2025: 500,
Apr 2025: 600 (upcoming)

Notes: Product is sold in a poly bag for online-only channel.
No retail presence.
01

The supplier price tier analysis is usually the fastest win. If you're placing 500-unit orders and the 1,000-unit price is materially lower, the cash flow math of a larger order often makes sense — run the inventory forecast alongside this analysis.

02

Packaging is the most underestimated COGS lever for Amazon sellers. An individually boxed product that ships in an Amazon box (with Amazon's own outer packaging) often doesn't need retail packaging at all — a poly bag with an FNSKU sticker may serve the same purpose at a fraction of the cost.

03

Section 301 tariffs on Chinese goods are the largest variable in most landed cost models. Before assuming the current rate is fixed, ask your customs broker whether your product qualifies for an exclusion or a reclassification — some products have seen significant rate reductions through official exclusion processes.

What does the COGS Reduction Opportunity Finder prompt do?
Systematically find where you're overpaying on product cost, components, packaging, or logistics — and quantify what each improvement is worth annually. Goes beyond "ask your supplier for a better price" to surface every lever that moves COGS.
What data do I need to use this prompt?
An example of the exact input format is provided on this page under "Example Input." Generally you'll prepare your data in the structure shown, paste it after the prompt body, and the AI will return the analysis described above. If you're missing any inputs, the prompt will ask you what it needs.
How long does this take to set up?
Setup time for this prompt is 30-60 mins. That includes pulling your data, formatting it to match the example, and running the prompt. Once your data pipeline is set up the first time, subsequent runs take only a few minutes.
Which AI tool should I use this with?
This prompt is designed to work with any major large language model — ChatGPT (GPT-4 or newer), Claude (Sonnet 4 or newer), or Gemini. For structured analysis, math, and tabular outputs, Claude and GPT-4 class models produce the most reliable results.
Does this prompt work for Shopify or other platforms?
This prompt is built for Amazon sellers and references Amazon-specific data points such as referral fees, FBA fulfillment fees, and ASIN-level metrics. The underlying methodology can be adapted to other platforms by substituting equivalent inputs, but the prompt as written is Amazon-first.
What skill level is required to use this prompt?
This prompt is rated intermediate. Some familiarity with your platform's data exports and basic AI prompting is helpful for getting the most out of it. Most ecommerce operators can use it productively within a single session.
Is this prompt free to use?
Yes. Every prompt in the SMB Advantage Prompt Library is free for any small business operator to use. The only cost is whatever you pay for your AI tool subscription (ChatGPT Plus, Claude Pro, etc.).
Stay in the loop

Want notes when new prompts ship?

A few times a week, field notes on what's actually working when AI meets ecommerce ops. Plus first look at new prompts and tools as they go live.