Shipping Cost Analysis

Calculate real shipping costs and compare them with what customers pay.

IntermediateAPI 2025-01

Command

bash

shopify-admin-skills:shipping-cost-analysis store=your-store.myshopify.com

### name Shipping Cost Analysis — Charged to Customers vs. Delivery Method ### oneLiner Compares shipping revenue collected from customers against recorded shipping costs by carrier and method — shows exactly where you're subsidizing delivery. ### whenToUse - Before changing free shipping thresholds — to know the real per-order cost of each method. - When one shipping method appears to drive more orders but margin is negative. - After a free shipping campaign, to calculate the total subsidy cost. ### howToRun ``` Run skill: shopify-admin-shipping-cost-analysis Store: yourstore.myshopify.com days_back: 30 ``` ### whatYouGet CSV file `shipping_cost_YYYY-MM-DD.csv` with columns: `order_name`, `shipping_method`, `carrier`, `charged_amount`, `original_price`, `discount_applied`, `currency`. The `discount_applied` column shows the per-order shipping subsidy. A summary table groups results by method with order count, total charged, and average per order. Free shipping orders appear with `charged_amount: 0` — the actual carrier cost is your subsidy for those orders. ### polishContext ### safetyNote