Optional - Property Bulk Import (WP Ultimate CSV Importer)
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.
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”.