Optional - Property Bulk Import (WP Ultimate CSV Importer)

Easily import all your existing properties in bulk using Realty and the WP Ultimate CSV Importer plugin:

Step 1 of 2: Add All Your Properties To The Property CSV File

First of all you have to add your property’s data to the example CSV file.

You can download the Property CSV Importer example CSV file here:  realty-csv-import-format.csv

What follows is an overview plus explanation of the CSV data:

post_title Property title (Will be used for the permalink, if post_slug is empty)
post_content Property description. The content you would normally add via the text editor.
post_date Property publishing date. Format: MM/DD/YYYY HH:MM:SS (e.g. 08/31/2014 09:00:00)
post_slug Optional. Property link name.
post_author Author of the property.
featured_image URL to the featured image.
Optional. Set the property post status. When using the same status, such as “published”, leave this empty for now, and set it later straight from the CSV Importer plugin.
property-location Property location. Valid are property location slug or name.
property-status Property status. Valid are property status slug or name.
Property type. Valid are property type slug or name.
Property features. Separate features with “|”. For example: air-conditioning | balcony | built-in-kitchen | dryer
raw_property_address Property address. For example: 1 Main Street, New York, NY, United States
raw_property_latitude Latitude. For example: " 40.762381". See "How to convert addresses to latitude/longitude in batch" section below
raw_property_longitude Latitude. For example: " -73.949443". See "How to convert addresses to latitude/longitude in batch" section below
estate_property_custom_agent Optional. Assign agent (ID) to property.
estate_property_available_from Format: Integer. Date from which the property will be available from. Format: YYYYMMDD (e.g. 20140831 for 31st of August 2014)
estate_property_bathrooms Format: Integer. Number of bathrooms.
estate_property_bedrooms Format: Integer. Number of bedrooms.
estate_property_featured Format: Boolean. Set property to “Featured” by entering “TRUE” or “1”.
estate_property_garages Format: Integer. Number of garages.
estate_property_id Optional. Property ID.
Single property layout. If empty theme option settings will be used. Override on a property basis by setting it to either “full_width” or “boxed”.
estate_property_price Format: Integer. Property price.
Price suffix, such as “/week”.
estate_property_rooms Format: Integer. Total number of rooms.
estate_property_size Format: Integer. Property size.
Property size unit. Example: “sq ft” or “sq m”
estate_property_status_update Property status update. Example: “Rented Out” or “Sold”.
estate_page_hide_sidebar Format: Boolean. Enter “TRUE” or “1” to hide the sidebar for this property.
raw_property_attachments Format: ‘|’ separated URLs for example: http://yourcompany.com/wp-content/uploads/attachment1.pdf|http://yourcompany.com/wp-content/uploads/attachment2.pdf
raw_property_gallery Format: ‘|’ separated URLs for example: http://yourcompany.com/wp-content/uploads/image1.jpgf|http://yourcompany.com/wp-content/uploads/image2.jpg

How To Convert Addresses To Latitude/Longitude Coordinates In Batch

Go to  http://www.findlatitudeandlongitude.com/batch-geocode/ and insert all your properties addresses into the “Input” textfield. Important: One address per line! Your settings should match the screenshot below:

Step 2 of 2: Import Your Properties Using Your Property CSV File

After successful preparation of our property CSV file we can now download the plugin  WP Ultimate CSV Importer plugin from the repository or you go to Plugins > Add New, search for “WP Ultimate CSV Importer” by smackcoders.com, and click “Install”. Once installed, activate the plugin.

You’ll find a new menu item called WP Ultimate CSV Importer. Click on it, and go to Imports > Custom Post.

Now we have to select our property CSV file by clicking on the green “Browse button”. Once selected click “Next”.

On the next page under “Select post Type” choose “property”, and map our CSV header with the appropriate WP fields, as show in the screenshot below. Field names are identical to the CSV header, so simply select the WP fields that match the CSV header. Once you have assigned all WP fields, click “Next”.

IMPORTANT: There will be five fields which you will find in CSV headers but you will not find in dropdown list to map with.

  1. raw_property_address
  2. raw_property_latitude
  3. raw_property_longitude
  4. raw_property_attachments
  5. raw_property_gallery

For these fields in drop down list the last option will be “Add Custom Field”. Click that option and you will see a new field appear next to it with same name header. Please do it for all these five fields.

Final step: Under “No. of posts/rows per server request” enter “1” and click the blue “Import Now” button.

If you are going to import a lot of properties be patient, the import will take a while. Once done, go to “Property” to see the result.

NOTE: As the property gallery is using WordPress image ID’s we can’t simply import property gallery images from an external URL, as we did for our featured image. We have to upload them via WordPress first. You have to upload them separately for each property, when editing the property, underneath the text editor under “Property Images”.