Get a weekly Payhip sales summary with refunds and coupons

1. Open Analytics in the Payhip dashboard and read the Daily Views, Daily Sales and Sales Breakdown graphs for the week, all in UTC.
2. Read the conversion rate on the same Analytics page: views, started checkout and completed checkout, free downloads included.
3. Go to Customers, click Filter Orders and set the order status to refunded or partially refunded with the week as the order date.
4. For coupon results, click Export on the Customers page and open the CSV: the Coupon Code column shows which orders used a code, while Marketing > Coupons only shows a use count per code.
5. Copy the numbers into a spreadsheet and compare them with last week's row by hand, every Monday.

Summarize last week in Payhip against the week before: sales, views, best sellers, refunds and which coupon codes were used.

1. 01

   Pin the week in UTC

   Payhip reports analytics in UTC, so the agent sets Monday 00:00 to Sunday 23:59 UTC and says so when your local week starts earlier or later. It reads get_sales_stats for that week and again for the week before.

2. 02

   Compare, then point at the outliers

   The report leads with the change in sales and views against the previous week, names the best-selling product, and lists days that had views but no sales, which usually point to a broken link or a paused promotion.

3. 03

   Count refunds on their own

   list_orders with the refunded and partially_refunded statuses covers the same dates. The filter works on order date, so the agent says when a refund belongs to an order bought in an earlier week rather than mixing it into this one.

4. 04

   Tie sales to coupon codes

   Completed orders are grouped by coupon_code, so each code gets an order count and revenue, not just the use counter Payhip shows. list_coupons adds the remaining uses and expiry, and codes close to their limit or expiring within 7 days are flagged.

5. 05

   Report, change nothing

   The run is read only. At the start of a month it adds last month's fees, VAT and affiliate commission from get_sales_report, once Payhip has closed that month.

Week 5 to 11 Oct 2026 (UTC): sales $120.00, up from $84.00 the week before.
Views 890 (previous week 760). Best day: Sunday 11 Oct, $48.00 from 203 views.
Best seller: Notion Budget Template, $72.00. Freelancer Contract Pack, $48.00.
Refunds: 1 order (ord_Q81pLs, $24.00), bought this week.
Coupons: LAUNCH25 on 3 orders, 47 uses left, expires 1 Nov.
Days with views and no sales: 6, 9 and 10 Oct.

• Payhip's Analytics page reports Daily Views, Daily Sales and Sales Breakdown in UTC, and views made while you are logged in to Payhip are not counted.
• Payhip's conversion rate counts a free download with a valid email as a completed checkout, so free products raise it.
• Refunds are issued in Stripe or PayPal, not in Payhip, and then show up in Payhip's analytics and monthly sales report.
• Payhip's monthly Sales Report under Customers > Sales Report is a PDF with EU and UK VAT, Stripe and PayPal fees, Payhip fees, custom taxes and affiliate commission, none of which the weekly graphs show.

Every tool here only reads, so it can run weekly from n8n, Make, Zapier or cron without waiting for your OK.

Sources: Payhip Help: Sales and Views · Payhip Help: Conversion Rate · Payhip Help: Sales Report · Payhip Help: How Do I Refund a Transaction?

curl https://cotlet.dev/api/v1/payhip/get_sales_stats \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"from":"2026-10-05","to":"2026-10-11"}'

{
  "daily_views": [
    {
      "date": "2026-10-05",
      "views": 142
    },
    {
      "date": "2026-10-06",
      "views": 98
    },
    {
      "date": "2026-10-07",
      "views": 176
    },
    {
      "date": "2026-10-08",
      "views": 120
    },
    {
      "date": "2026-10-09",
      "views": 87
    },
    {
      "date": "2026-10-10",
      "views": 64
    },
    {
      "date": "2026-10-11",
      "views": 203
    }
  ],
  "daily_sales": [
    {
      "date": "2026-10-05",
      "amount": "24.00"
    },
    {
      "date": "2026-10-06",
      "amount": "0.00"
    },
    {
      "date": "2026-10-07",
      "amount": "36.00"
    },
    {
      "date": "2026-10-08",
      "amount": "12.00"
    },
    {
      "date": "2026-10-09",
      "amount": "0.00"
    },
    {
      "date": "2026-10-10",
      "amount": "0.00"
    },
    {
      "date": "2026-10-11",
      "amount": "48.00"
    }
  ],
  "sales_by_product": [
    {
      "product_id": "RGsF",
      "name": "Notion Budget Template",
      "amount": "72.00"
    },
    {
      "product_id": "mVT0",
      "name": "Freelancer Contract Pack",
      "amount": "48.00"
    }
  ]
}

MCP: add https://cotlet.dev/mcp/v1 with the same key; the tool is payhip_get_sales_stats. Example data.

• Fix Payhip download limit errors and resend download links
• Payhip API and MCP server: every tool
• All use cases