-- 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;