Knowledge Base

JetBookings Import/Export in WP Ultimate CSV Importer

We have added compatibility for migrating JetBookings data using the CSV Importer. If you are looking to understand how to import and export JetBookings records,  along with their related post types, this guide will walk you through the process.

Note: The plugin currently supports migrating booking details. This means it can serialize export/import JetBookings data.

How to Import JetBookings data #

To import JetBookings data, you need an exported JetBookings CSV file that includes essential fields such as booking_id, booking_status, apartment_id, apartment_unit, check_in_date, check_out_date, user_id, guests, order_id, and orderstatus.

Field Descriptions:

  • booking_id is a unique id for each booking.
  • booking_status indicates the current status of the booking (e.g., pending, confirmed, on-hold, canceled, etc.,)
  • apartment_id is the unique identifier for the related post type, such as posts, pages, or custom posts. You can also use the title here during import.
  • apartment_unit: refers to the specific unit within the apartment or property being booked.
  • check_in_date is the date and time when the customer is scheduled to check in
  • check_out_date is the date and time when the customer is scheduled to check out from the property or booking
  • user_id is the unique identifier for the users who made the bookings.
  • The guests field includes the number of people associated with a particular booking. – Order_id is the unique identifier for the order associated with the booking. Typically an ecommerce order is generated when the customer makes the booking. – Order status indicates the current status of the order or the payment like pending, completed, failed or canceled.

Make sure to include the above fields in your CSV file and follow the steps below to import the data.

Step 1: Upload the prepared Bookings CSV file #

Tip: Before uploading, make sure your CSV file is properly verified with a tool like csv lint to avoid upload issues.

CSV Importer offers multiple upload methods like from desktop, ftp/sftp, urls, or the server. Choose any one of your preferred methods. For details on these upload methods, refer to the file upload documentation.

To upload it via desktop, click Browse, select the Bookings CSV file, and click Open. The file will begin uploading.

Once the upload reaches 100%, you will be redirected to the next screen to choose the post type and import type. The post type “JetBooking” will be selected automatically.  If not, choose it from the dropdown under ‘Import each record as’. 

select-jetbooking-post-type

Choose ‘fresh import’ for importing new data, or select ‘update content’ if you want to update existing bookings.

Step 2: Map the CSV Fields to JetBookings Fields #

The plugin will attempt to automatically map the columns in your CSV file to the corresponding JetBooking fields. This is possible if the file headers name exactly matches the JetBookings fields header name. Otherwise, use drag and drop or dropdown mapping methods and correctly match the CSV fields for the corresponding JetBooking fields.

jetbookings-import-field-mapping

Note: if you’re updating JetBookings data, the booking_id field is mandatory. When importing new bookings, the apartment_id field is mandatory.

Step 3: Configure the JetBookings Import Settings #

import-configuration-page-jetbookings-import

Scroll down, and click Import. The importer will start to run the import process. You can monitor the progress of each record without leaving the page. Once it completes, a popup will appear, offering you the option to download the import summary file. You can download the summary to verify the import, or simply visit the Bookings page directly to check your importer data.

jetbookings-log-view
bookings-list-view

How to Export JetBookings Data #

Exporting JetBookings data is easier. Just choose the JetBooking module, select the import file type, provide the name for the file, and hit export. The Bookings data will be exported and the file will be ready for download.

Step 1: Choose the JetBooking Module #

Visit the Export tab in the plugin. It will list many post types the plugin supported. Select the “Jet Booking” checkbox to export it. At the top of the export screen, you’ll see how many records are in the Bookings post type.

export-module-selection-choose-jetbooking

Step 2: Configure Export settings #

Click continue to proceed. In the next screen, fill in the export file name inside the textbox. Choose the export type under the advanced settings section.

advanced-settings-jetbookings-export

Step 3: Export and Download JetBookings Data #

Scroll down and click Export to generate the export file to download. The file will be ready to download. Click Download and save the file to your computer. Open the file and ensure that all your JetBookings data has been correctly exported.

export-completed-download-page
jetbookings-csv

Note: This exported file can now be used to import bookings data to another WordPress site.

How to Import JetBookings Fields Associated with Post Types #

You can import JetBookings fields associated post types like Posts, Pages, and Custom Posts. For instance, if you’ve associated a post type like ‘Rooms’ with Jet Bookings, you can import and export Room data along with JetBooking Fields.

Supported Fields for Migration:

  • Pricing Settings
  • Custom Schedule
  • Date Picker Config
  • Unit Title
  • Unit Number

Note: Pricing settings, custom schedule, and data picker config fields will be exported and imported in serialized formats.

For unit_title, provide the unit id values, separated by pipes(|). For unit_number, provide values separated by pipes.

Import JetBooking Fields For Custom Posts(e.g., Rooms) #

Follow these steps to import the JetBooking fields values for Custom Post type (such as “Car”) using WP Ultimate CSV Importer:

Step 1: Uploading the File with JetBooking Fields #

Go to ‘Import/Update’ and upload your CSV file.

Select ‘Fresh Content’ for new data import and choose the post type (e.g., Car).

import-post-type-selection-view

Step 2: Map the JetBooking Fields #

Click continue. In the mapping section, map the relevant fields under ‘Jet Engine Booking Fields’ (e.g., pricing settings, custom schedule, data picker config, unit titles, and unit number).

jetbooking-fields-mapping-view
jetbooking-mapping-save-template-view

Save the field mapping template.

Step 3: Import Jet Booking Fields to the Post Type #

On the next page, click Import, to add the booking fields to the post type.

import-configuration-section

Verify the import by checking the import log or visiting the post type directly.

custom-post-import-completed-view
custom-post-edit-view-pricing-settings-section-jetbookings
custom-post-edit-view-units-manager-section

How to Export JetBookings Fields Data Associated with any Post Types #

To export JetBookings Fields associated with post types such as posts, pages, or custom posts, you’ll need to navigate to the export section of WP Ultimate CSV Importer.

Step1: Choose the Post Type containing JetBookings Data #

It will list out all the supported modules. Choose the post type. For example, if you’ve associated JetBooking fields for a custom post like Car. Choose Custom posts and select the name ‘Car’ from the dropdown.

choose-custom-posts-with-jetbooking-fields-to-export

Step 2: Configure file name, file type, and advanced filters #

On the next page, provide the file name, filter type, and configure the advanced filters. You can export specific post type records based on their IDs or title.

advanced-settings-jetbookings-export
export-filters-jetbookings-export

Step 3: Export and Download File #

Click Export to extract the desired record in your preferred formats. Download the file for a backup on your computer. Learn more about export features here.

export-completed-and-download-page
custom-posts-import-csv-jetbooking-fields