Why would I need to do this?

All of our reporting happens automatically. This means that you can't just send us a list of orders to be sent to SoundScan. You have to import the orders into Shopify.

2 Types of Order Imports

Orders of physical records sold either in person or through another service can be imported into your Shopify store to be reported by Single.

Other order lists can be imported to bulk deliver digital albums. In order to retroactively deliver digital music, you need to export orders from the service (with SKU field matching your digital product), then import them as orders into Shopify.

Some real world examples of bulk delivering digital music...

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

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 for Ticket Bundles

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.

Step by step instructions:

1.) Assign your album (digital or physical) 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

Digital albums immediately delivered

or

Physical album sales scheduled to be reported the next day

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!