How to Add The Listings Catalog to Your Website

Content Production
Written By unINK Creative

Benchmetrics now has a way to add a listings catalog to your real estate website! Complete with a photo gallery, address, price, property details, and much more. All you need to do is update a google sheet, and your listings will automatically generate on your website.

This article will explain how to create the Listings Catalog on your website, and will give you a bunch of tips on how to organize your listings.

Listing Options

(Items with “*” are mandatory, meaning they must be filled out for each listing)

  • *Status

  • Street Number

  • Street Name

  • Street Suffix

  • Street Dir Suffix

  • City

  • Postal Code

  • State or Province

  • Neighborhood

  • Region

  • *Longitude

  • *Latitude

  • *Date Listed

  • *Listing Key

  • Beds

  • Baths

  • Sqft

  • Living Area

  • *Price

  • Property Subtype

  • Architectural Style

  • Year Built

  • Transaction Type

  • Appliances

  • Equipment

  • Heating

  • Cooling

  • Basement

  • Construction Materials

  • Exterior Features

  • Parking Features

  • Total Parking Spaces

  • Frontage Length

  • Lot Dimensions

  • Annual Tax

  • Tax Year

  • Zoning

  • Roofing

  • *Public Remarks

  • Images

 

Important Information

Publish Time

It may take 15-30min for the changes on the Google Sheet to be seen on your website, so if you don’t see your updates right away, give it some time!

Images

We’ve created a video tutorial that walks you through how to add images to your Listings Catalog (Exclusive Listings)

Status

The “status” option should be left unfilled until everything else is finished.
Once you set the status to “Active” or “Conditionally Sold”, the program will start publishing that listing’s information to your website.

Make sure all the mandatory fields are filled out before you change the status. Otherwise, it may fail to load the page correctly or may show incorrect information.

Once the listing is sold, change the status to “Sold”. That will remove the listing from your website, but will still keep the information in the Google Sheet so you can reference it later.

Listing Key

The “Listing Key” is the most important option as this allows us to know which details to show when a user clicks on the “view more details” button on a listing. As such, the listing key must be unique.

An example of a Listing Key would be an acronym for the province, followed by 6 unique numbers.

Here are a few examples of Listing Keys:
- SK481763
- BC718221
- OT913266

There is no character limit, but it should preferably not use any special characters, such as ?!@#$%^&(). If the listing key is not unique, the app will use the first instance it finds on the sheet.

Tooltips

We’ve provided some useful information directly on the Google Sheet (called tooltips). You can view this information by clicking on a column title with a black arrow on the top-right.

Please follow the tooltips on the column title cells to input the correct information.

Public Remarks

“Public Remarks” can be as long as you want them to be, but we highly recommend not typing in all capital letters.

Dropdowns

On columns that have dropdown options, you are not explicitly limited to the prebuilt options. You can always put in more options using the dropdown option available on Google Sheets or just write in your input free-form.

We highly recommend using dropdowns to prevent typos or other small differences you may not catch when inputting multiple listings (such as “Bungalow” vs “Bungalow “)


Listing Info that Doesn’t Fit

For listings that have a unit number, apartment number, or some other extra detail for their physical address, adjust the existing columns instead of creating new columns.

For example, if the address is “203-220 20th St West, Saskatoon, Saskatchewan” then the “Street Number” would be “203-220” and the “Street Name” would be “20th” and “Street Suffix” would be “Street”.

Number Formatting

All number inputs should just be unformatted numbers and should not include any commas, dollar signs, or units of measurement (sqft).

unINK Creative

We believe in people, their potential, and growing together. 

We are a marketing & creative agency who help individuals and organizations to strategize, develop, build, execute, analyze and adjust marketing strategies for the digital world. unINK is based in Saskatchewan, Canada. 

http://www.unink.ca
Previous

How to Use The Featured Listings Widget From Benchmetrics
Next

How to Install Facebook Messenger on your Real Estate Website