HivePress – Export and Import Listings in CSV Format

In a previous tutorial, we showed you how to bulk edit HivePress listings using an intuitive spreadsheet. In this tutorial, we want to show another way to bulk manage your HivePress listings data. You’ll learn how to export HivePress listings to a CSV file and how to import HivePress listings from a CSV file into WordPress, using WP Sheet Editor – Post Types.

Related tutorials:

• How to bulk edit HivePress listings using a spreadsheet
• How to duplicate HivePress listings
• How to bulk delete duplicate HivePress listings

Some benefits of exporting and importing HivePress listings using a CSV

Using CSV files to export and import HivePress listings can be a real game-changer, especially if you’re running a business directory or marketplace. Let’s break down some of the benefits:

• Exporting and importing listings makes bulk editing easier. Imagine having to edit hundreds of listings one by one. It would take forever! But with CSV files, you can export your HivePress listings, make changes to things like prices or descriptions all at once, and then import your HivePress listings back into WordPress. It’s like having a shortcut for making bulk updates to your listings.
• CSV export and import allows you to save tons of time. Instead of adding or editing each listing manually, you can use CSV files to import many listings at a time. This is especially helpful if you have a lot of listings to manage. Once you have a CSV file set up, you can keep reusing it as a template whenever you need to add more listings.
• You can edit CSV files anywhere. CSV files are super flexible. You can open and edit them in different programs like Excel or Google Sheets. Besides, if you ever want to switch platforms or need to move your listings to another website, you can easily take your CSV file with you.
• Managing HivePress listings in CSV format allows you to manage big data. As your HivePress directory grows, managing hundreds or even thousands of listings can become time-consuming. But with CSV import, you can handle large amounts of data easily. It scales with your business, so you won’t be stuck trying to manage everything by hand.
• WP Sheet Editor makes exporting and importing listings flexible. You don’t have to import or export all your data at once. You can choose exactly what information you want to work with, whether it’s just the listing titles, descriptions, or categories. You can also map your CSV columns to match the fields in HivePress, and even select which rows you want to import, starting from any specific number of rows.

Install WP Sheet Editor – Post Types

You need to install and activate the WP Sheet Editor – Post Types plugin, which allows you to view and manage HivePress listings, as well as posts, pages and other custom post types, using spreadsheets on WordPress.

After completing the payment process, you need to install and activate the WP Sheet Editor – Post Types plugin on your website. Just follow these steps:

1. Go to Plugins > Add New Plugin.
2. Click on Upload plugin.
3. Click on Choose file.
4. Locate the file on your computer.
5. Click on Install now.
6. Click on Activate plugin.
7. Enter your license and click on Activate License.

Install the “WP Sheet Editor – HivePress” extension

We have created a free extension that will add full compatibility between WP Sheet Editor and HivePress.

You need to download and install the extension on your WordPress website:

1. Go to Plugins > Add New Plugin.
2. Click on Upload plugin.
3. Click on Choose file.
4. Locate the file on your computer.
5. Click on Install now.
6. Click on Activate plugin.

Set up the HivePress Listings spreadsheet

After installing and activating the plugin on your WordPress site, you need to generate the spreadsheet you are going to use.

In this case, we are going to use the HivePress Listings spreadsheet, so we need to generate it:

1. Go to WP Sheet Editor > Setup spreadsheet.
2. Tick the Listings post type.
3. Click on Save.

Now you will see the available columns, and you have to decide which columns you want to see/use in the spreadsheet and which columns you want to disable/hide.

You just need to drag the columns to the left or right side to enable/disable them.

Once you’re done, click on Save.

You will see all your listings displayed in the spreadsheet. Each row is a listing and each column is a field.

Export HivePress listings to a CSV file

After installing and activating both the plugin and the extension, you can export your HivePress listings to a CSV file.

To do this, you need to open the Export tool.

Now you need to select the following values in the Export tool:

• What columns do you want to export: Here you need to select the columns/fields you want to include in the CSV file you’re exporting.
• Which rows do you want to export: WP Sheet Editor allows you to export listings that you have manually selected in the spreadsheet, listings you’ve filtered using the advanced search tool, or all your listings. In this case, we will export all listings, so we will select the All the rows from my current search option, which includes all rows in case you haven’t applied any search filter.
• What app will you use to edit this file: In this example, we will use Microsoft Excel (Office 365)
• Name of this export: You can add a name here and reuse these export options in the future.
• Click on Start new export.

Edit HivePress listings in a CSV file

After exporting your HivePress listings to a CSV file, you can open the downloaded file with Excel, Google Sheets or any other CSV editor.

You can edit the data of your existing listings, create new listings, etc. This is a great way to bulk edit your HivePress listings in CSV format.

Import HivePress listings from a CSV file

After you have edited or added new data to the CSV file, you can import your HivePress listings from the CSV file into WordPress.

To do this, you need to open the Import tool.

Now you need to select the following values in the Import tool:

• Source: CSV file from my computer.
• Click on Choose File and locate the CSV on your computer.
• Click on Next.

You can Import all the columns or Select individual columns to import.

Select if you want to update or create listings.

In this example, we will Create new contacts and update existing listings, so we will match the existing listings by ID.

Once you select the values, click on Next.

Finally, you’ll see a preview. If everything is OK in the preview, you need to click on The preview is fine, start import.

This is how you can export HivePress listings to a CSV file, edit the listings in a CSV file, and import listings from a CSV file into WordPress.

WP Sheet Editor – Post Types boosts your productivity by allowing you to bulk edit HivePress listings on WordPress, as well as export/import listings.

Related tutorials:

• How to bulk edit HivePress listings using a spreadsheet
• How to duplicate HivePress listings
• How to bulk delete duplicate HivePress listings