Export and cleanup

The Simple BnB Rental Pro plugin provides two useful tools to help you manage reservations over time:

CSV Export, to download reservation data filtered according to your criteria;
Cleanup, to quickly remove cancelled reservations and keep your database tidy.

1. Reservation export (CSV)

This feature lets you download a CSV file containing the list of reservations — useful for reports, backups, or analysis. You can access it by clicking Export Reservations in the plugin menu.

Available filters

Before exporting, you can apply several filters to narrow down the results:

Filter	Description
Status	Select the reservation status to export: All, Pending, Confirmed, Completed, Cancelled.
Payment status	Filter by payment state: All, Paid, Unpaid, Refunded.
Date range	Choose a date range (check-in / check-out) using flatpickr calendar fields. Only reservations within this range will be included.
Room	Select a specific room or leave All rooms to include every one.

💡 You can combine multiple filters at once — for example: “only confirmed reservations for the Double Room between August 1 and 15”.

Export process

After setting your filters:

Click “Export to CSV”.
The system will generate a CSV file and automatically start the download.

The file includes a header row with column names, followed by the filtered reservation data.

Fields included in the CSV

Each row in the file represents a single reservation, with the following data:

Field	Description
`reservation_id`	Unique reservation ID
`room_id`	ID of the booked room or unit
`room_name`	Name of the booked room or unit
`checkin_date`	Check-in date
`checkout_date`	Check-out date
`adults`	Number of adults in the reservation
`children`	Number of children in the reservation
`status`	Reservation status (pending, confirmed, completed, cancelled)
`payment_status`	Payment status (paid, unpaid, partial, etc.)
`charge_type`	Charge type (total, deposit_percent, deposit_fixed)
`total_price`	Total reservation amount
`amount_paid`	Amount actually paid by the customer
`currency_paid`	Currency used for the payment (e.g., EUR, USD)
`paid_at`	Date/time when the payment was completed
`payment_intent`	Stripe payment ID (Payment Intent)
`stripe_session_id`	Stripe Checkout session ID
`customer_name`	Guest’s full name
`customer_email`	Guest’s email address
`customer_phone`	Guest’s phone number
`token`	Confirmation token (used if online payments are disabled)
`created_at`	Date/time when the reservation was created

2. Cleanup of cancelled reservations

To keep your reservation list clean, you can use the button:

“Delete all cancelled reservations”

This command permanently removes from the database all reservations with the Cancelled status.

This operation cannot be undone. It’s recommended to perform a CSV export before cleaning, so you can keep an archive of deleted reservations.

When to use it

After a certain period, to reduce database size.
After testing or simulated reservations.
When you want to start from a clean list, keeping only active or completed bookings.

3. Practical tips

Always export a CSV backup before performing any cleanup.
If you use spreadsheet tools like Google Sheets, set the separator as “comma” (,) or “semicolon” (;) depending on your system language.