Last active
March 23, 2024 00:16
-
-
Save antijingoist/dd5f4d24e03c76ec2a56cabcc0416941 to your computer and use it in GitHub Desktop.
Convert your Gumroad data into a format that Itch.io can import
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment