How To Bulk Upload Listings VIA CSV

Start by downloading this plugin here http://wordpress.org/plugins/really-simple-csv-importer/

Why would i need to use that plugin?

The plugin above is compatible with the Advanced Custom Fields plugin which is the plugin that displays all the fields of the theme, front-end submission form and listings custom fields. If you use a plugin to import CSV that isn’t compatible with the ACF plugin, the chances that your CSV won’t work are high, it is therefore recommended that you use a plugin compatible with the ACF plugin.

How To Import Via CSV

  1. Download the sample csv here http://cl.ly/TkG5
  2. Edit the csv file with any csv editor. Note: some editor messes up with the csv file which can cause problems when importing the csv if not correctly formatted as the plugin requires.I’ve successfully used the following CSV editor available here for free http://sourceforge.net/projects/javacsveditor/
  3. Leave the post_id column empty.
  4. The post_name column is the slug of your listing, if the listing is called “Business Listing” you can set the slug to “business-listing”
  5. Make sure the date format is the same as the one added into the sample csv
  6. DO NOT change the post_type column
  7. Set your post tile and post content columns values
  8. DO NOT add ANY value to the post_category and post_tags columns
  9. Use the tax_listings_categories column to set the slug of the listing category that you wish to use for the listing
  10. Use the tax_listings_location column to set the slug of the listing location that you wish to use for the listing
  11. Use the “field_51dd6e7c52b8a” column to set the address and coordinates of the marker that will be added on the mapThis column MUST BE FORMATTED IN THIS WAY
    108 Chambers Street New York, NY 10007, United States|40.71492749999999,-74.00818950000001

     

    The first line before the separator  ” | ” is the address of the location.
    The second line after the separator are the coordinates NEEDED to display the location on the map. If you do not set coordinates, the listing won’t be visible on the map.

  12. If you wish to fill any other field of the listings please read section “Advanced Custom Fields plugin integrate” on this page here http://wordpress.org/plugins/really-simple-csv-importer/You need to find the field key and add it to the CSV file like done into the sample csv file provided above.
  13. After your csv file is ready navigate to Tools -> Import -> Csv into your WordPress dashboard and upload the csv file.
  14. WHEN THE UPLOAD IS SUCCESSFUL you’ll see a message saying “All Done.” and at the top of it you will see the names of the successfully imported listings.IF YOU DO NOT SEE ANY NAME, your csv file is wrongly formatted. Make sure you’ve followed the instructions correctly.

How do i find the key of the custom fields?

Open file listings_post.php into the folder /framework/fields/ of the theme scroll through each field and you’ll notice a parameter called “key” take the value of that parameter and add it to your csv file like showed into the sample csv file provided above.

My listings are now imported but i don’t see them in the categories and locations pages?

Download the plugin at this url here http://cl.ly/TgAN , and install it as you would do with every other plugin.

Login into your WordPress dashboard, and add the following string to the url into your browser

 

?tdp_action=fix_csv_import

So for example if your website wp admin dashboard url is http://example.com/wp-admin/, the URL THAT YOU HAVE TO VISIT IS THIS

http://example.com/wp-admin/?tdp_action=fix_csv_import

AGAIN: ALL YOU NEED TO DO IS JUST ADD THAT STRING AT THE END OF YOUR WEBSITE URL

After visiting that page, you’ll see a message saying “The Listings Update Process Is Complete. You can now go back to your dashboard”.

All your listings are now updated and should be visible in your categories/locations pages.

Why Do I Need This Plugin ?

I’m going to explain now why this happens so you will understand why you need an external plugin to “fix” your listings.

Let’s start by specifying that this isn’t a theme bug. The listings categories and listings locations pages will display ONLY the listings that have assigned the post meta called “listing_is_featured” this post meta is created ONLY when the post is published and the Advanced Custom Fields Plugin created the entry into the database. If the entry isn’t available, the listing will be excluded from the query needed to display every listing on the categories/locations pages.

Now, how can you create the “listing_is_featured” metafield through a csv file? Regularly you would need to add the meta name into your csv field and assign a value of 0(non featured) or 1(featured) however the Advanced Custom Fields plugin isn’t being “filtered” or “hooked” by ANY CSV Import plugin this means that even if your csv file has the column “listing_is_featured” it won’t work, the database won’t be updated. This is the reason why i’ve created a new plugin that updates all the listings at once.