Exporting Your Historical Sold Listings From MLS Paragon (British Columbia)
In British Columbia, real estate website developers are specifically not given access to sold listing data which means that we cannot automatically import your sold listings. By following the guide below, we are able to import all of your historical sold listings in one go. 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 will result in unusable files.
Here are the steps required to export your sold listings from the BC MLS Paragon system, and to send them to us for your website:
Step 1: Log into http://bcres.paragonrels.com/ (BC Residential)
Step 2: Click Search, then Inventory
Step 3: 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.
Step 4: The fifth customizable option from the top is "Selling / Listing", and there is a drop-down menu next to it. By default the drop-down option should say "Listed", but we want to change that. Change the option to "Listed or Sold", then click "Search" at the top right corner.
Step 5: You should now be looking at a list of all your sold listings. 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 the ⚙️ or Gear icon, at the top of the page, then click Fields.
Step 6: 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 should look like the image below:
If you'd like to include the brokerage name (at the time of sale) in your sold exports, 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 2 code - office name
Step 7: 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".
Step 8: A small lightbox prompt will pop-up. Leave everything as it is, and click "Export" at the top right.
Step 9: 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. Please e-mail the .CSV file you just downloaded to email@example.com and we will add them to your website.
**NOTE** If the files you have downloaded are more than 10MB in size, please use this free service to send us large files: http://realtyninja.wetransfer.com
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.