1. Home
  2. Booking & Appointment Plugin for WooCommerce
  3. Manage Availability in Bulk

Manage Availability in Bulk

In v4.16.0 of Booking & Appointment Plugin for WooCommerce, we have released ‘Manage Availability for Products‘ feature which allows the store owner to Add, Delete and Update the availability related information of the bookable products in bulk.

E.g You have multiple bookable products that are set up with the Fixed Time Booking Type and you want to add/delete new timeslot or update the max booking and the pricing for multiple products together from one place then it can be achieved by using this functionality. The same way it will also work for different booking types available in the Booking plugin.

We have added a ‘Bulk Booking Settings‘ tab on Booking -> Settings page, where the options are available under the ‘Manage Availability for Products‘ section.

Manage availability of products
Manage availability of products

 

Bookable products: All the bookable products will be listed here. One can select as many products or all products to execute the added actions.

Understanding the available columns in the table:

Day/Date: You can select Day or Date for which you want to manage the availability.
Which Days/Dates: For which days or dates you want to manage the availability.
Action: Select the action among Add, Update and Delete options for the selected days/dates.
From & To time: This option is applicable only for Fixed Time booking type. Input from time and to time values in the fields of this column in 24 hours format(HH:MM).
Max Booking: This is the maximum booking field to be used when adding/updating the availability of the products.
Price: This is the special price field to be used when adding/updating the availability of the products.
Note: This field is for adding/updating note information for the chosen day/date and time information. This option is applicable only for Fixed Time booking type.

One can add as many actions as they want in the Manage Availability table. Added action will be executed for the selected product in the ‘Bookable products’ fields. We highly recommend selecting the same booking type products for the smooth execution of the action and less number of actions to avoid performance-related issues.

Let’s understand ‘Manage Availability for Products‘ functionality in depth according to the different booking types available in our Booking plugin.

Single Day

Action: Add

Using Single Day booking type one can create a bookable product that takes the booking for the whole day. This booking type can be used in Tour Business, Events, Amusement Park, etc. Let’s assume you are running one of these businesses and you have created multiple products(could be 100+) with the following availability.

City Tour Availability - Manage Availability
City Tour Availability

 

As you can in the above screenshot, all the weekdays are enabled except Monday & Tuesday. If you want to enable both these weekdays along with their Max booking and pricing in all/multiple products then it can be done by adding the following action in the manage availability table.

Bookable products: All the products where we want to add availability.

Day/Date: Day
Which Days/Dates: Monday, Tuesday
Action: Add
From & To time: Blank
Max Booking: 100
Price: Blank
Note: Blank

As you can see in the above screenshot, we have selected all the bookable products for which we want to manage the availability. In the table, we have used add action to enable the Monday & Tuesday along with its Max booking as 100. Clicking on the ‘Execute Added Action‘ button will gather the selected data and execute it on the selected products. In this case, Monday & Tuesday will get enabled in the selected product along with the Max Booking to 100.

In the same way, it is possible to add new dates to the products as shown in the below screenshot.

Bookable products: All the products where we want to add availability.

Day/Date: Date
Which Days/Dates: 9-10-2019,10-10-2019,11-10-2019
Action: Add
From & To time: Blank
Max Booking: 100
Price: Blank
Note: Blank

Adding dates to products : Manage availability of products
Adding dates to products

 

After executing this action, 9th, 10th and 12th Oct 2019 will be added to the selected products with 100 as its maximum booking.

Note: If day/date is already enabled then nothing will happen for that day/date. Also, it doesn’t matter if any values are set or not in ‘From & To time’ and ‘Note’ column if the booking type is Single Day.

Action: Delete

It is possible to delete/disable available days/dates from the bookable product using ‘Manage availability of products‘ functionality. Let’s say all the weekdays are enabled in the products and you want to disable Saturday & Sunday. You can add the following action in the Manage availability table.

Bookable products: All the products in which we want to delete the availability.

Day/Date: Day
Which Days/Dates: Saturday and Sunday
Action: Delete
From & To time: Blank
Max Booking: Blank
Price: Blank
Note: Blank

Disable weekdays - Manage Availability
Disable weekdays

After executing this action, Saturday & Sunday will be disabled in the selected products. The same way it possible to delete the dates from the product.

Action: Update

There will be times where you will need to update the Maximum booking for the days/date in multiple products. Visiting each product and update the required thing will require a huge amount of effort. This action can be simplified using ‘Manage Availability of products‘ functionality.

E.g The max booking and price need to be updated for all weekdays in multiple products or all products. You can add the following action in the Manage availability table.

Bookable products: All the products in which we want to delete the availability.

Day/Date: Day
Which Days/Dates: All
Action: Update
From & To time: Blank
Max Booking: 150
Price: 250
Note: Blank

Day/Date: Date
Which Days/Dates: 16-10-2019,17-10-2019
Action: Update
From & To time: Blank
Max Booking: 150
Price: 250
Note: Blank

Update Max Booking and Special Price for all weekdays and specific dates
Update Max Booking and Special Price for all weekdays and specific dates

 

Executing the above-added action will update the max booking to 150 and pricing to 250 for all weekday and 16th, 17th Oct 2019 in the selected products. If the selected day is disabled then it will not update the details. It should first be enabled by using add action which we have discussed earlier.er.

Fixed Time

Using the Fixed Time booking type one can create a bookable product that allows booking the product on date and time slot. This booking type can be used in businesses like hair spa to an appointment with a doctor. Let’s assume you are running one of these businesses and you have created multiple products(could be 100+) with the following availability.

Availability of day & time - Manage availability
Availability of day & time

 

As you can see in the above screenshot that the product is available for booking for all weekdays on 10:00 – 11:00, 11:00 – 12:00, 12:00 – 13:00 and 13:00 – 14:00 time slots.

Action: Add

If you want to add more time slots for particular or all weekdays then it can be done by adding the following action in the manage availability table. Let’s add 14:00 – 15:00 time slot for Sunday in multiple products.

Bookable products: All the products where we want to add availability.

Day/Date: Day
Which Days/Dates: Sunday
Action: Add
From & To time: 14:00 & 15:00
Max Booking: 1
Price: 200 (Keep if blank if you do not want to set price)
Note: Blank

Adding time slots to multiple products - Manage Availability
Adding timeslots to multiple products

 

As you can see in the above screenshot, we have selected all the bookable products for which we want to manage the availability. In the table, we have used add action to add 14:00 – 15:00 timeslot for Sunday along with its Max booking as 1 and time slot price as 200 along with the note.

Clicking on the ‘Execute Added Action‘ button will gather the selected data and execute it on the selected products. In this case, timeslot 14:00 – 15:00 will get added for Sunday in the selected product along with the max booking, price, and note.

If the weekday or date is not available in the product then weekday will get enabled and date will get added to the product. If you want to add or update only day/date then you can do the same by without adding value in from time and to time field.

In the same way, it is possible to add new time slots for dates to the products as shown in the below screenshot.

After executing this action, 18:00 – 20:00 timeslot will get added for 15th, 22th and 29th Oct 2019 dates to the selected products with 1 as its maximum booking and price as 200. Also, this action will add 15th, 22th and 29th Oct 2019 date in the specific dates if products doesn’t have these dates.

Action: Delete

It is possible to delete time slots from the bookable products using ‘Manage availability of products‘ functionality. Let’s say timeslots for all the weekdays are present in the products and you want to delete a particular time slot 13:00 – 14:00 for all weekdays. You can add the following action in the Manage availability table.

Bookable products: All the products in which we want to delete the availability.

Day/Date: Day
Which Days/Dates: All
Action: Delete
From & To time: 13:00 and 14:00
Max Booking: Blank
Price: Blank
Note: Blank

Deleting time slot from products - Manage Availability
Deleting time slot from products

 

After adding this action, click on the ‘Execute Added Action‘ button. This will delete 13:00 – 14:00 timeslot from all weekdays. When delete action will be added without time slot information then the weekdays will get disabled in the products. The same way this will work for the dates.

Action: Update

It is possible to update the max booking, pricing and note information for the time slots for multiple products using ‘Manage Availability of products‘ functionality. E.g The max booking and price need to be updated for some of the time slots for all weekdays in multiple products or all products. You can add the following actions in the Manage availability table.

Bookable products: All the products in which we want to delete the availability.

Day/Date: Day
Which Days/Dates: All
Action: Update
From & To time: 10:00 and 11:00
Max Booking: 10
Price: 100
Note: Blank

Day/Date: Day
Which Days/Dates: All
Action: Update
From & To time: 11:00 and 12:00
Max Booking: 10
Price: 100
Note: Blank

Day/Date: Day
Which Days/Dates: All
Action: Update
From & To time: 12:00 and 13:00
Max Booking: 10
Price: 100
Note: Blank

Updating Max booking and price of time slots - Manage Availability
Updating Max booking and price of time slots

 

Click on the ‘Execute Added Action‘ button after adding the above actions and it will update the Max Booking and Price of the time slots in the selected products. If from time and to time information is not added then Max Booking and Price will be updated to the selected day/date.

Duration Based Time & Multiple Nights

Action: Add, Delete, Update

These actions for the products which are set up with Duration Based Time or Multiple Nights will work the same as explained in the Single Day booking type section. The only difference is, the Max Booking field will not be considered for the days/dates. Also, when adding dates for the products then it will only be considered for the pricing of the dates.

That’s it. This was all about ‘Manage Availability for products‘ functionality we provide in Booking & Appointment Plugin for WooCommerce. Free free to contact us if you have any questions and also we welcome suggestions and feedback to improve this functionality.

Was this article helpful to you? Yes No

How can we help?