Indie game storeFree gamesFun gamesHorror games
Game developmentAssetsComics
SalesBundles
Jobs
Tags
0

Migrating Sales Data from Gumroad

A topic by Abbie Gonzalez created 70 days ago Views: 136
Viewing posts 1 to 1

Spent the week moving all my stuff from Gumroad, and thought this would be helpful to anyone else doing the same thing and save them some time.

You can export your Gumroad data as a CSV by selecting the top right icon from this page: https://app.gumroad.com/customers

An image showing the menu that appears when you select the download icon on the Gumroad Customers page

Select all data and select download.

The menu may disappear when you click Download: I was with them for 12 years so the menu just disappears when I click download. There indication of any success, just wait a bit. You’ll get an email from Gumroad after a bit with a link to download your data. It took mine maybe an 30 minutes to show up.

I imported it into a SQL lite database, and after some experimenting, used the below query to generate a minimal CSV that could be imported back into Itch.io. This only pulls in customers that were not refunded, did not initiate a chargeback, and opted into receiving emails from you. (https://itch.io/docs/creators/kickstarter). Side note: The only reason I knew it was an option was because it popped up in a tooltip on my dashboard - that was helpful!

The Amount field is formatted, because it seems the Kickstarter wants a currency formatted amount and Gumroad exports amounts as a decimal number (1.5 vs $1.50 or 1.50).

SELECT
    `Purchase Email` AS "Email",
    FORMAT("$%.2f", `Sale Price ($)`) AS "Amount"
FROM
    GumroadSalesRaw  -- Or whatever the 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;

For a quick list of what your products are from your Gumroad export, you can run a query like:

SELECT
  `Item Name`
FROM
  `Gumroad Sales Data Raw` -- name of the table you imported your Gumroad CSV into
GROUP BY
  `Item Name`

Hopefully this saves you time from having to figure out what data you want, and what fields to use.

Side note: don’t delete your Gumroad account right away! Just unpublish your products instead. Gumroad will keep any remaining unpaid funds if you delete your account.