Gumroad to Itch.io Export, Minimal

-- Use this to export your Gumroad sales data to a minimal import on Itch.io.
-- Go to your project on your Itch.io Dashboard, select Distribute, and select Kickstarter Import
-- More details on importing here: https://itch.io/docs/creators/kickstarter

SELECT
    `Purchase Email` AS "Email",
    FORMAT("$%.2f", `Sale Price ($)`) AS "Amount"
FROM
    GumroadSalesRaw  -- Name of the table you imported your Gumroad CSV into
WHERE
--  `Item Name` IS "Item Name" -- filter by item name if you have more than one product
    `Do not contact?` IS 0
    AND `Buyer Email` IS NOT NULL
    AND `Fully Refunded?` IS 0
    AND `Disputed?` IS 0;