How do I create a file to report my mail order sales?

How do I create a file to report my mail order sales?

To report mail order sales to MRC, you’ll need to begin by creating a sales file. For your convenience, we have created an excel macro that will make this process easier.  Please scroll to bottom and download the attached zip file relevant to the country you reside. (US for United States, CA for Canada) You can utilize the excel template to create your sales files.


 If you still wish to manually create, please follow the formatting instructions listed below: 

First, download and open the program Notepad ++.


Here is our example sales file:

 

File Header (First line only):

924030aaaaaYYMMDD

 

The ‘92’ indicates that this is the header line, and contains the header information.

The ‘4030’ is the standard chain for all of our IMO providers.

The ‘aaaaa’ is for your account number.

The YYMMDD is the date of the sales contained in the file.

 

Sales reporting lines:

M3060253720598198321S

 

The ‘M3’ indicates this is a sales line. Every IMO sales line starts with “M3”.

Next is the 13-digit barcode (EAN) for the product sold. (If your UPC is less than 13 digits, add zero's to the beginning of the UPC to make it 13 digits)

Next is the zipcode of the customer. We only want 5 digits, DO NOT add extensions.

The last letter should be “S” for Sale or “R” for return.


File Footer (Last line only):

94    13 13


The ‘94’ indicates the end of the file.

Next is six-digit line indicator, here showing that there are 13 sales lines in the file.

Next is a six-digit sales quantity, indicating 13 sales. If there are returns, that number will go here instead of the sales total.






    • Related Articles

    • I'm an Independent Record store, how do I create a file to report my sales?

      To report your Independent Record store sales, you’ll need to begin by creating a sales file. For your convenience, we have created an excel macro that will make this process easier.  Please scroll to bottom and download the attached zip file. You ...
    • How can I address corrections to my sales reporting to Luminate?

      If there are changes needed to be made to a sales file(s) due to missing or incorrect sales activity, we ask that you please regenerate and resubmit via FTP the affected sales feeds under their original file name(s) with the corrected data. Below are ...
    • What are the sales reporting deadlines?

      TYPE OF SALES REPORTING DEADLINE WHAT TO REPORT Daily IMO (Internet mail order) Daily 1:00pm EST All music sales shipped the preceding day Weekly IMO (Internet mail order) Every Tuesday by 1:00pm EST All music sales shipped Tuesday through Monday the ...
    • How can I become a sales reporter?

      To become a new sales reporter, you need to provide the following information to the following emails: Music.MerchantServices@mrcentertainment.com  mjohnson@mrcentertaiment.com: Company Name Company Address City, State, Zip Contact Name Contact email ...
    • How do I Report My Venue Sales from Shows?

      Please use this link to Support FAQ - https://support.mrc-data.com/portal/en/kb/articles/how-do-i-report-my-venue-sales-from-shows-18-11-2020