Exporting Your Historical Sold Listings From MLS Paragon (British Columbia)
In British Columbia, all real estate website developers are not given direct access to your previous sold listing data for inclusion on your website. This means that we cannot automatically import your past sales, and that you'll have to follow the guide below to import your historical sales in one go. We understand that this process is not ideal, but this is the best possible solution we can offer without having access to the raw data. Please follow each step very carefully, as a small mistake may result in unusable files.
Steps for BC's MLS Paragon System
Log into http://bcres.paragonrels.com/ (BC Residential)
Click Search, then Inventory
Click the magnifying glass icon to the right of the " Status" field, and deselect everything EXCEPT "2 - Sold", which will automatically select both sub-options beneath it, then click Save.
Click "Search" at the top right corner.
You should now be looking at a list of all your past sold listings where you represented the seller (as the listing agent). Note: There's separate steps at the end of this guide to export solds where you represented the buyer.
Before we can export this list, we need to add a few additional fields to the search criteria. In order to get this process started, click on "⚙️Customize", at the top of the page, then click "Fields".
You should now see a new lightbox, which shows you all of the available fields that you can add to your search ("Available" on the left) and all of the fields that are currently being reflected in your search ("Selected" on the right). There are 16 fields that you want to include in your export data (see list below).
Scroll or search through the box on the left, find those items and select them with the checkmark directly to the left of each of them, then click "Add" after each selection. Once the 16 items listed below are in the "Selected" box are the right, click Save at the top right of the pop up window.
Tip: You may need to remove some preset fields by using the "Remove" function.
This animation shows how to both add and remove items from the Selected list:
The 16 fields you should select in the box on the right are:
- Picture Count
- Listing Pictures
- ML #
- Prop Type
- Type of Dwelling
- Approx. Year Built
- Public Remarks
- Floor Area - Grand Total
- List Price
- Sold Date
- Sold Price
- Total Baths
- Total Bedrooms
When all the fields are added the box on the right (and you've removed everything else) it should look like the image below:
Optional Step 7:
If you'd like to include the brokerage name (at the time of sale), then there's an additional step. It's not in the list of standard fields. When choosing the fields to include there is a dropdown called "group" (top center of the lightbox), which you can change to "office".
From there, you want to add these 3 fields to your export:
- list firm 1 code - office name
- list firm 2 code - office name
- list firm 3 code - office name
Your data is ready to be exported. Click the "Export" icon 📥 (it's directly to the left of the ⚙️ icon you clicked in step 5). From the resulting drop-down menu click "Export to CSV".
A small lightbox prompt will pop-up. Leave everything as it is, and click "Export" at the top right.
The file you just Exported should be titled Firm_Inventory.csv, and should be saved directly to your Downloads Folder, unless you specified a different folder on your computer.
Optional Step 11:
If you'd like to include sales where you represented the buyer (as the buyers agent) then you'll need to repeat the all steps above, but for Step 4 choose "Sold" from the "Selling / Listing" dropdown before you click "Search".
If you skipped step 11 above: then simply email the .CSV file you just downloaded to firstname.lastname@example.org and we will add them to your website.
If you completed step 11: then you should end up with two .CSV files. One for where you represented sellers (listing agent), and one for where you represented buyers (buyers agent). You'll need to rename the your files so that our team knows which is which. We recommend using this format:
Once you've renamed your files accordingly, please e-mail them to email@example.com and we will add them to your website.
Also please note that it can take up to 5 business days for us to import your sold listing data once we have been provided with the files in the correct format.
Please feel free to contact us if you have any questions on how to use this guide. Unfortunately we do not have permission to login to Paragon on your behalf, but we will do our best to help you!