Bandcamp
Direct Connection:
You can now set up a direct connection to Bandcamp, and your sales will be automatically imported into IC!
How to set it up:
- In IC, navigate to Account -> Account Settings
- Scroll down to the Direct Connections menu, click on the Bandcamp link in the box pictured below
- Head to your Bandcamp orders page, and click “Give a fulfillment partner access to this page” on the right. If you already have fulfillment partners, click “Manage” and then “invite a fulfillment partner”. Once there, invite IC using the email data@infinitecatalog.com
- Under Settings, enter your Bandcamp Subdomain. This is the first part of your catalog's Bandcamp URL - i.e. if your Bandcamp URL is milesdavis.bandcamp.com, your subdomain is milesdavis.
- Enter the Initial Order Start Date. Choose the earliest start date and time to use for orders included in the first import, with a maximum date of one year. If you haven't done any Bandcamp imports in IC, this should be when you want your accounting to begin. If you've previously done imports on your own, this should be right after the latest date range you used in your last import.
- Click Save!
If you need to add multiple Bandcamp accounts, you can easily do so by sending fulfillment invitations for each additional catalog to our data@infinitecatalog.com email address and clicking "Add another Account". Once you have completed the Settings for each additional subdomain, our Support team will be glad to set up the connections for your multiple Bandcamp accounts.
Once a member of our Support team has received your direct connection request and completed setup from our end, the Bandcamp Direct Connection will show ✓ Enabled and your Bandcamp data will begin to automatically import into your account at your set schedule!
You can connect artist or label accounts. If you need any help setting it up, just reach out to Support and they'll help you out.
If your artist account does not include the Orders tab at the top of the screen, please contact Bandcamp Support to enable fulfillment access.
Please note: if you are not accounting for physical sales from Bandcamp - once you have set up your Bandcamp API, the "Exclude physical transactions" option can be selected in your Bandcamp API importer Settings as detailed in the Importer Settings section below.
Otherwise, here's how to get the data:
- Log into Bandcamp
- Select "Tools" from the dropdown in the upper right corner
- In the Reports section select "raw data report"
- Make sure to include: payment details, items details, buyer details
- Select the desired date range and click "export raw data report"
When does the data become available? Bandcamp pays out royalties between 24-48 hours from the time a sale occurs unless monthly payouts are manually selected in your Label Profile - and as such, the raw data report is updated as sales are processed by Bandcamp.
Bandcamp "label" level accounts let you select a date range when exporting - however, "artist" level accounts don't have that option. For "artist" level accounts, you will need to select an export option from the Sales report dropdown list as shown below and manually remove rows that fall outside your desired date range. Once that is done, save the edited file as .CSV and use the "Bandcamp (Edited)" importer in IC.
Importing into IC
- In IC, navigate to Royalties -> Data Imports
- Select Bandcamp or Bandcamp (Edited) from importer drop down menu.
- For unedited Bandcamp files, use the Bandcamp importer. If for any reason your data needs to be edited or changed prior to importing, use the Bandcamp (Edited) option.
Please note: In order to create Bandcamp (Edited) data that can be imported into IC, you will first want to download the Bandcamp 'raw data report' following the instructions above, and then import it into your worksheet processor (File -> Import in Excel after opening a blank worksheet, and choose "Semicolon" delimiter once the data has been imported). Once you have edited your Bandcamp 'raw data report', you will want to Save As -> CSV UTF-8 in order to save the comma-delimited data our Bandcamp (Edited) importer is set to ingest. If you have any questions or concerns, please contact IC Support.
Importer Settings
Optional settings specific to our Bandcamp importers can be set in the corresponding importer's Importer Settings by navigating to Royalties -> Data Imports -> Importers (in the nav bar) -> [Bandcamp Importer] -> Settings (in the nav bar). Importer-specific settings can be set as follows:
- Disable 1% Fee
- This option disables the automatic deduction of the hidden 1% fee that PayPal charges you when Bandcamp transfers your remittance.
- Map UPCs to items
- When selected, this option will map UPC codes present in raw Bandcamp data to easier match to Releases within the system. For catalogs with existing Bandcamp imports, this may result in the creation of new Items and successive cleanup in the system.
- Include Shipping Totals
- When selected, shipping totals present in the shipping column of Bandcamp data will be brought into IC as their own transactions at import. This option can be helpful if shipping totals are to be set against fulfillment expenses when accounting Bandcamp royalties.
- Exclude physical transactions
- When selected, physical transactions will be excluded from imports and will not be accounted for within the system.
How we process the data
- Our importer maps the net amount column of Bandcamp data in order to calculate the total of each transaction. In doing so, IC automatically deducts the transaction and Bandcamp fees from each transaction; we *also* deduct a hidden 1% fee that PayPal charges you when Bandcamp transfers you the funds.
- Additional fees - like VAT / tax or shipping totals - are not mapped or brought into IC by default, as these totals are typically reconciled outside of royalty accounting. Shipping totals can be mapped by our importer by selecting the Include Shipping Totals option in Importer Settings as detailed above.