Advertisement
antijingoist

Gumroad to Itch.io Export, Minimal

Mar 22nd, 2024 (edited)
978
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.62 KB | Source Code | 0 0
  1. -- Use this to export your Gumroad sales data to a minimal import on Itch.io.
  2. -- Go to your project on your Itch.io Dashboard, select Distribute, and select Kickstarter Import
  3. -- More details on importing here: https://itch.io/docs/creators/kickstarter
  4.  
  5. SELECT
  6.     `Purchase Email` AS "Email",
  7.     FORMAT("$%.2f", `Sale Price ($)`) AS "Amount"
  8. FROM
  9.     GumroadSalesRaw  -- Name of the table you imported your Gumroad CSV into
  10. WHERE
  11. --  `Item Name` IS "Item Name" -- filter by item name if you have more than one product
  12.     `Do not contact?` IS 0
  13.     AND `Buyer Email` IS NOT NULL
  14.     AND `Fully Refunded?` IS 0
  15.     AND `Disputed?` IS 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement