Why would I need to do this?

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

If there is an SKU field in your imported data that matches the SKU of your digital album, each order will be delivered the digital album.

Finding the Right App

Importing orders isn’t a feature built into Single; the instructions below leverage the use of a third-party app, which does 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.

Nielsen Rules

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.

Step by step instructions:

1.) Assign your digital album an SKU in Shopify.

Shopify Admin -> Products -> Select the product -> Scroll down to variants



2.) Turn off order notifications in the Shopify admin.

If you don't, you will receive an email notification for every imported order and your inbox will explode.

Shopify admin -> Settings -> Notifications -> Scroll down to "Staff order notifications" -> under "Recipients" hit "Disable"



3.) 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.

4.) Edit the exported report in Excel or Google Sheets by adding a column for SKU.

Enter the SKU from step 1.

Warning: Column headers are case-sensitive. Please make sure that the names of columns are identical in steps 4 & 7



5.) Export the data from Excel or Sheets as a .csv

6.) In your Shopify admin, install the EZ Importer App

7.) Create a new "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”

8.) In EZ Import, go to Imports and select “Import Orders”.

Choose the data mapping that you just created and drag your .csv file

9.) Orders will instantly be uploaded to Shopify and digital albums immediately delivered

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.
Was this article helpful?
Cancel
Thank you!