Daily Adobe Commerce refunds digest for finance

Every weekday at 9am, post a daily refunds digest to our finance team so they can see what drove refund dollars yesterday without opening Adobe Commerce.

Pull yesterday's Adobe Commerce credit memos using List Credit Memos, filtered by created_at with a from/to range that matches the store's business day (not UTC). If a business-day cutoff is not configured, default to the store's local midnight-to-midnight window from the store configuration. For each credit memo, fetch the parent order with Get Order (so you have the customer, order total, SKUs, and category info) and any refund notes with List Credit Memo Comments.

Then classify each refund into one of these reason buckets: damaged, wrong item, size, quality, chargeback, or other. Use the credit memo comments plus adjustment_positive / adjustment_negative fields and any free-text notes as the signal. If a comment is ambiguous, prefer the more specific bucket and only fall back to 'other' when nothing fits.

Group the results and compute: total refund dollars for the day, total number of credit memos, a breakdown by reason (count and dollars), the top refunded SKUs (by dollars), the top refunded categories (by dollars), and any single credit memo above a configurable outlier dollar threshold (default $250). Call outliers out at the top of the digest with the order number, customer, amount, and the classified reason.

Post the digest to a configurable finance Slack channel using Slack's Send a Message. Write it in plain English with a short headline (totals), an outlier section if any, a reason breakdown, top SKUs, and top categories. Keep it scannable, not a wall of numbers.

In parallel, append one row per credit memo to a configurable Google Sheets refunds ledger using Append Values. Each row should include: date, credit memo id, order number, customer email, refund amount, adjustment amount, classified reason, top SKU, top category, and a short excerpt from the comments. This is finance's running record, so keep the column order stable across runs.

If there were no credit memos yesterday, still post a one-line 'no refunds yesterday' message to Slack and skip the sheet append. If Adobe Commerce returns no comments for a credit memo, classify from the adjustment fields alone rather than skipping the record.

Configurable inputs: the finance Slack channel, the Google Sheet id and tab name, the outlier dollar threshold, the reason bucket list, and the business-day cutoff hour.