Gumroad to Itch.io Export, Minimal
antijingoist |
PRO |
03/23/24 12:16:43 AM UTC (Edited) |
0 ⭐ |
8916 👁️ |
Never ⏰ |
[sql, gumroad, itchio]
-- 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;
Comments
0 B
|👍
/👎
0 B
|👍
/👎