There are situations where you may want to import orders into Shopify from an outside application.
Some real world examples are:
After a successful Kickstarter campaign, you’ll need a way to fulfill digital albums you’ve sold
Attach your digital album to tickets for your upcoming tour
As long as there is an SKU field in your data that matches a release created in your Single Music dashboard, Single will will deliver that digital album to fans.
This isn’t a feature built into Single; the instructions below leverage the use of a third-party app, which may incur its own costs. While we chose one specific app for this example, there are many order import apps available in the Shopify app store. We can’t guarantee that all imports will be successful, however when formatted correctly we’ve achieved a 100% success rate in our import tests.
Important Note: In order for bundles which include physical or digital music and tickets to be reported, you must first fill out this application and be approved before the sales take place.
As long as you follow Nielsen’s rules - these sales count towards the official Billboard charts. In order to retroactively deliver digital music, you need to export orders from the service, then import them as orders into Shopify. Here are step by step instructions:
2.) Export customer data from the source as an excel file. Just make sure your exported data includes: Name, Email, Total Paid and Quantity. Follow these links for specific instructions about exporting from Kickstarter, Eventbrite, and Ticketfly.
3.) Edit the exported report in Excel or Google Sheets by adding a column for SKU. Enter the SKU from step 1.
4.) Export the data from Excel or Sheets as a .csv
5.) In your Shopify admin, install the EZ Importer App
6.) Create a custom data mapping. First check boxes of name, customer email, line items.price, line items.quantity, line items.sku. Next, edit the header name for each data mapping field you selected. You can change them to Name, Email, Total Paid, Quantity and SKU. Lastly, check boxes for “Shopify will generate order name during import” and “Link product by SKU”
7.) In EZ Import, go to Imports and select “Import Orders”. Choose the data mapping that you just created and drag your .csv file
8.) Orders will instantly be uploaded to Shopify and digital albums immediately delivered
Important Note - Importing orders tied to a digital release in Single will deliver the album to every customer on your imported list. As Single’s digital delivery is usage based, this means you will be charged 15 cents / track delivered. The “usage” will be everyone, all at once, so you will be charged accordingly!
Questions? The Single Music team would love to chat