What the Margin analysis and marketplace-aware repricing recommendations prompt does

Act as an e-commerce commercial analyst specialising in unit economics, marketplace fees and controlled repricing.

The prompt will, at minimum:

  • Reconcile sales, refunds, discounts, fees, taxes, shipping and cost-of-goods fields before calculating product profitability
  • Define gross margin, contribution margin and net contribution explicitly; never mix tax-inclusive and tax-exclusive values
  • Calculate SKU and channel economics with transparent formulas, period and currency assumptions
  • Compare competitor prices only when product equivalence, pack size, shipping, tax and availability are reasonably matched
  • Identify margin leakage from promotions, returns, fulfilment, platform fees, ad spend and low-volume operational costs

Who it is for

Gökhan Güzel's e-commerce prompt for Claude users: marketers, founders, agencies and consultants who need an auditable, evidence-based deliverable instead of generic advice.

What you get

  • Executive summary and data-quality exceptions
  • Definitions and formula register
  • SKU/channel profitability table
  • Competitor comparability table
  • Repricing rules and approval matrix

Variables

PlaceholderPurpose
{{analysis_period}}Supply the exact value, definition, URL or attached file relevant to analysis period; write UNKNOWN when unavailable
{{brand_name}}Supply the exact value, definition, URL or attached file relevant to brand name; write UNKNOWN when unavailable
{{competitor_price_data}}Supply the exact value, definition, URL or attached file relevant to competitor price data; write UNKNOWN when unavailable
{{cost_report}}Supply the exact value, definition, URL or attached file relevant to cost report; write UNKNOWN when unavailable
{{currency}}Supply the exact value, definition, URL or attached file relevant to currency; write UNKNOWN when unavailable
{{margin_floor}}Supply the exact value, definition, URL or attached file relevant to margin floor; write UNKNOWN when unavailable
{{marketplace_fee_table}}Supply the exact value, definition, URL or attached file relevant to marketplace fee table; write UNKNOWN when unavailable
{{pricing_constraints}}Supply the exact value, definition, URL or attached file relevant to pricing constraints; write UNKNOWN when unavailable
{{sales_report}}Supply the exact value, definition, URL or attached file relevant to sales report; write UNKNOWN when unavailable
{{shipping_return_costs}}Supply the exact value, definition, URL or attached file relevant to shipping return costs; write UNKNOWN when unavailable
{{target_markets}}Target markets; UNKNOWN if unavailable
{{tax_vat_rules}}Supply the exact value, definition, URL or attached file relevant to tax vat rules; write UNKNOWN when unavailable

How to use

Copy the prompt with the button above, replace every {{placeholder}} with your verified data, and paste it as the first message in a new Claude conversation. The prompt runs a short question gate first; answer it, then the deliverable is produced.

Run Margin analysis and marketplace-aware repricing recommendations in Claude

Open a new Claude chat, paste the filled-in Margin analysis and marketplace-aware repricing recommendations prompt and answer the short question gate. Claude then returns the executive decision, the evidence ledger and the task-specific tables in one reply.

Source

Original file in the multilingual prompt library on GitHub: