Exporting Your historical Sold Listings From VREB & VIREB (ViVa)

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. 

Steps for Matrix System  (ViVa)

Victoria Real Estate Board and Vancouver Island Real Estate Board

Step 1: 

• Log into https://matrix.vancouverislandmls.com
  

Step 2: 

Create a Custom Export Filter.

• Click your Name from the top right and choose Settings.

• On the Settings page, we need to click Custom Exports

• On the next page (Manage Custom Exports), click "Add Export" from the right side of the box. 

On the next page you will see a list of Available Fields on the left, and an empty box on the right. Before you do anything, name your Export "Historical Solds" or "Historical solds for Realtyninja". Any name will do.

You need to add 17 of the items on the left to the box on the right. You do so by typing in each of these 17 items in the "Search:" box under the left list of "Available Fields." When the item you're looking for shows up, click it to select it, then click the "Add->" button in between both boxes. This will add your selected item to the list on the right (Export Fields.) You need to do this 17 times and add each of these items from the list on the left to the list on the right. 

The 17 items you need to move over are listed underneath the following animation:

1. Area
2. Baths
3. Beds
4. CoList Office Name
5. Date Listed
6. Date Sold
7. List Office Name
8. MLS® No
9. Property Sub Type
10. Property Type
11. Price List
12. Price Sold
13. Public Remarks
14. Street Address
15. Sub Area
16. SqFt Total
17. Year Built (Est)

Once done, click Save, then Done. Your Custom Export filter will be used in the later steps.

Step 3:

Generate your Solds

• From the top menu, click Search then Residential.

• Check Sold only. You can filter the date here if needed or leave it blank to extract all your lifetime solds properties.

Step 4: 

On the same page, scroll down and find Additional Fields section.

Click Add/Remove beside Additional Fields.
Search the following fields and add it to the Selected Fields to the right then click back.

1. List Agent Full Name
2. Buyer Agent Full Name

OPTIONAL:

1. CoList Agent Full Name
2. CoList Agent 2 Full Name
3. CoBuyer Agent Fullname
4. CoBuyer Agent 2 Full Name

There might be a lot of existing fields already here. You can remove them or just add the ones we require. Please see the example screenshot.

Step 5:

Once done, click  Back to the search page.

• Select Residential to highlight and filter the results.
• Then type your Listing Agent Full Name in the box. (e.g. Emily Smith)
• Click Results to view the Solds.

Step 6:

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.

Check the top left to select them all and click Export.

• Select the export file format we created earlier in this screenshot we have "Historical Solds for Realtyninja"
  

Step 7:

• The file you just Exported should be titled Historical Solds for Realtninja.CSV, and should be saved directly to your Downloads Folder, unless you specified a different folder on your computer. E-mail the .CSV file you just downloaded tosupport@realtyninja.com and we will add them to your website.

OPTIONAL: Export all Historical Solds for listings where you served as the Buyer, Co-List or Co-Seller.

If you would like to Export your Historical Solds for listings where you served as the Buyer Agent, CoBuyer, CoList Agent, ,then return to  Step 5 and do everything the exact same way all the way until Step 6. 

In Step 5, instead of entering your name into the "List Agent Full Name" field as you did before, enter your name into the "Buyer Agent Full Name" field, and then complete the remaining steps. 

Repeat this process, each time changing the field where you enter your Name in Step 5. You will download a total of 5 .CSV files which you will e-mail to us, same as mentioned in Step 7. 

Pretty simple, right ?

* *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. Unfortunately we do not have permission to login to Paragon on your behalf, but we will do our best to help you!