Imports and feeds

If your listings already live somewhere else, such as another CRM, your website or a spreadsheet, you don’t have to type them in again. Imports & feeds brings them into SADE CRM from a spreadsheet, or reads your other software’s feed on a schedule and keeps your listings in step with it. It also gives you feed addresses that other portals can read your listings from.

The page is for agency admins. Open Settings at the bottom of the menu; it is under Property setup. Imported listings work like the ones you type in: they appear in Properties, get enquiries, viewings and deals, and count towards your plan’s listing limit.

The page has four cards: Import a spreadsheet, Feeds SADE reads, Import history, and Your feeds for other portals.

What happens to imported listings

• New listings of a verified agency are published straight away. They do not wait in SADE’s review queue, and they appear on the marketplace at once. SADE’s moderators look at them afterwards, and can block one.
• New listings of an agency that isn’t verified yet are Pending. They wait for SADE’s review before they are published, like listings you add by hand.
• Their availability is set to immediate, the price type to total, and the exact location is hidden: the marketplace shows a shaded area.
• They are assigned to the agent named in the row or feed, or to the default agent you choose.
• Photos are downloaded in the background and appear on the listings over the next minutes.
• Every published listing that is still in the file or feed is confirmed again, so it stays on the marketplace for another period (60 days for sale, 30 for rent). An expired one comes back.
• Where your country requires a property code and a listing has none, it gets the No property code flag. See Flags.

Each new listing counts towards your plan’s listing limit. Once the limit is reached, the remaining new rows fail with “The plan’s listing limit is reached; upgrade the plan to import more.” Updates to listings you already have still go through.

There is no notification or email after an import. You see the result on screen and in Import history.

Import a spreadsheet

The spreadsheet import takes an Excel (.xlsx) or CSV file with one listing per row. Any layout works: you tell SADE which column is which.

Upload

1. If you are starting a new file, click Excel (.xlsx) or CSV next to “Start from our template:”. The template has the column headers (in Albanian for an Albanian-language agency, otherwise in English), the required ones shaded yellow, and one example row.
2. Drop your file on the box, or click it to choose one. Files can be up to 10 MB and 5,000 rows. Old .xls files can’t be read: save them as .xlsx or .csv first.

Match columns

SADE shows the first rows of your file as it read them, and under each column which field it will fill, or “not used”.

Below, Which column is which has one drop-down per field. SADE guesses from your headers, in English, Albanian and many other words (“ref”, “asking price”, “town”, “sqm”, “beds”). If every column you used last time is in the new file, it suggests last time’s choices. Each column can be used once. Pick Not in the file for anything your file doesn’t have.

Click Check the rows. It stays greyed out until every required field has a column.

The fields

Fields marked * are required.

You can also match columns for the property code (for example 8150/7/419+1-6 in Albania), an area in square feet, and the energy class used in your country.

Check

Nothing is saved yet. SADE shows four figures: Rows, New listings, Updates and Rows with problems. Rows with problems are listed with their row number as you see it in Excel, the reference and the problem, for example City "Tirna" isn't one SADE knows in Albania. Problems are written in Albanian when your agency’s CRM language is Albanian, and in English otherwise; problems with a property code are always in English. These rows will be skipped and the rest imported.

Under the figures, SADE may add:

• “3 rows are listings deleted in the CRM; they won’t be brought back.” See Deleted listings stay deleted.
• “Your agency isn’t verified yet, so new listings wait for SADE’s review before they are published, like listings you add by hand.”

Two choices before you import:

• Rows without an agent go to: The agency’s first admin (the default), or one of your agents. A row with an agent email goes to that agent.
• Withdraw listings missing from this file: tick it when the file is your full list. Listings from earlier spreadsheets whose reference isn’t in this file are set to Withdrawn, which takes them off the marketplace. It needs a Reference column. A row that has a problem still counts as present, so a typo doesn’t take a listing down. Only listings that are Published, or Pending from an earlier import, are withdrawn; sold, rented, blocked and rejected listings stay as they are.

Click Import 12 listings (the number is new listings plus updates) and keep the page open. It takes about a second for every 300 rows.

Note: the check does not test your plan’s listing limit, or whether another agency holds a property code. Those rows can still fail at import, so the import can report more problems than the check.

Import

The result shows New, Updated, Unchanged, Withdrawn and Problems, and the problem rows. A note says that photos are fetched in the background, and whether the new listings are published or wait for SADE’s review. Click Import another file to start again.

Updating listings by uploading again

Upload the same file again later, with your changes, and SADE updates the listings it made, matched by Reference:

• Only the fields that have a value in the row change. An empty cell keeps what the listing has.
• A listing whose row is the same as before is not touched and counts as Unchanged.
• The assigned agent changes only when the row names another of your agents.
• An empty Photos cell keeps the photos. Photos your agents added by hand in the CRM stay, after the imported ones.

The uploaded file is kept for 30 minutes between steps. After that, upload it again.

Statuses on a new upload

The file’s Status column changes a listing’s status only while the listing is as the file or SADE’s approval left it: Published, or the status the last upload gave it.

• A sold word makes it Sold or Rented, and a withdrawn word makes it Withdrawn.
• An empty status or an active word keeps a Published or Pending listing as it is. A listing the file had withdrawn comes back, as a new listing would: published if your agency is verified, otherwise Pending for SADE’s review.
• A status decided in the CRM or by SADE stays, whatever the file says: a listing sold or rented through a deal, or Blocked or Rejected by SADE. Its other fields are still updated from the row.

Deleted listings stay deleted

A listing you delete in the CRM is never brought back by an import. Later uploads leave its row out, even if the file still has it, and count it under Unchanged. The import’s details name it, for example “1 listing was deleted in the CRM, so it wasn’t brought back (reference TL-007).”

To list the home again, add it by hand in Properties.

Feeds SADE reads

If your other software publishes a Kyero or OpenImmo feed, or you have access to an MLS’s RESO Web API, SADE reads it on a schedule and keeps your listings in step.

Adding a feed

1. Under Feeds SADE reads, click Add a feed.
2. Fill in the dialog:

3. Click Add feed. SADE reads it within 15 minutes, or at once if you click Read now.

Each feed’s row

The row shows the feed’s name and kind, how the last read went (Last read worked, Last read failed, Reading… or Not read yet), how often it is read, when it was last read and how many published listings it has. If the last read failed, the reason shows in red, for example “The feed answered 404 Not Found.”

• Read now reads it at once, even when it is paused. For RESO, choose What changed (listings changed since the last read) or Everything (all listings, and withdraw what the server no longer has).
• The switch pauses the feed or turns it back on.
• The pencil edits it; the bin deletes it.
• History shows that feed’s reads.

When you delete a feed, SADE stops reading it and its history is deleted. Its listings stay in the CRM as ordinary listings, unless you tick Also withdraw its listings: then those that are Published, or still Pending from the feed, become Withdrawn.

Note: nobody is notified when a scheduled read fails. Look at the feeds’ rows now and then.

What a feed does to your listings

Feeds follow the same rules as spreadsheets: new listings are published if your agency is verified and wait for SADE’s review if not, updates change only what the feed gives, statuses decided in the CRM or by SADE stay, deleted listings are not brought back, and photos are fetched in the background. A listing the feed withdrew comes back when the feed lists it again. Listings missing from the feed are withdrawn only after a full, successful read, and only when Withdraw listings the feed no longer has is on. Nothing is withdrawn when:

• the read failed;
• the read was partial: an OpenImmo feed that sends only changes, or a regular RESO read;
• the feed had no listings with an id;
• the listing’s entry had a problem.

Feeds can be up to 200 MB, and must be on the public internet.

Import history

Import history lists every import, spreadsheets and feeds, newest first. Click Refresh to update it.

Click a row to see its figures and the list of problems.

Your feeds for other portals

Many property portals can read a Kyero or OpenImmo feed. SADE can publish one for you, so a portal shows your listings and keeps them up to date.

1. Under Your feeds for other portals, click Turn on.
2. Two addresses appear: Kyero (v3) and OpenImmo (1.2.7). Click Copy next to the one the portal reads.
3. Paste it into the portal’s feed or import settings.

The feeds hold your listings that are Published and not blocked or expired, with only public information: the shaded location unless you show the exact one, and SADE’s copies of the photos with the cover first. Videos and the property code are left out. A portal sees changes within 5 minutes.

Important: the address holds a secret. Anyone who has it can read your published listings. If it gets out, click New address: the old addresses stop working at once, and you give the new ones to every portal. Turn off stops both feeds at once.

Something unclear or missing? Write to [email protected] or call +355 69 808 0118.