Menu

Optimizing WooCommerce Bookings with 2 Way Google Calendar Sync and CSV Exporter

Last updated on May 8, 2019 By wpexperts

Back in 1965, SAS became the first airline to use an electronic booking system that they call SASCO (short for SAS Computer System) which was the result of close collaboration between SAS and IBM.

The first printer to fully print the boarding passes, from 1988.
The first printer to fully print the boarding passes, from 1988.

Although it was not an online system, can be considered as the first step to start optimizing the booking process which is really a time-consuming procedure. Standing in queues, waiting for your turn to fill the form and checking for available slots, it’s really exhausting.

Today we have online booking websites which seem to keep improving and making things easy for both customers and service providers. Airbnb, Booking.com, and Expedia are few examples which are pretty popular nowadays.

Starting Your Own Online Booking System

One of the easiest solutions to start implementing your own online solution for managing bookings is to use WooCommerce Bookings. This WooCommerce extension helps you to sell time or date-based bookings and is perfect for those wanting to offer appointments, services or rentals.  The author has shared detailed documentation on how to install and set up WooCommerce Bookings as per your requirement.  So we are going to move on here and let’s dig how we can make it more manageable, connecting it with Google calendars and CSV exporter.

Connecting With WOOCOMMERCE BOOKINGS TWO WAY GOOGLE CALENDAR SYNC

Although with WooCommerce Bookings everything is easily manageable But creating bookings manually from the dashboard is really time-consuming. With this Woocommerce Bookings Google Calendar 2 Way Sync you can easily create booking right from your Google Calendar. You just need to add word “booking” with your product name in your calendar’s event title and the plugin will take care of rest.

There are many possible Use cases of this plugin which we are going to discuss in short. Getting excited? Check out their documentation to have a more clear idea.

Get the list of scheduled bookings in your inbox

With WooCommerce Bookings Exporter you can easily get all scheduled bookings directly in your inbox as PDF or CSV on daily, weekly or monthly basis.  You can even download CSV of all bookings with different categories and date filters.

With WooCommerce Bookings Exporter you will get following features;

  1. Option to export bookings in CSV or PDF format.
  2. Exported CSV format can be viewed in Excel
  3. Filter options to apply before exporting bookings
  4. Set schedules for daily, weekly or monthly email reports.
  5. Select, rename and reorder Columns that you would like to export
  6. Create and save templates to make efficient workflow
  7. Use saved templates to export bookings
  8. Option to set your own separator for CSV file.

For more details, you can follow the documentation page of WooCommerce bookings CSV Exporter plugin.

Use Cases

Let’s move to use cases to have a more clear picture of how we can use these Woocommerce Plugins to get most out of WooCommerce Bookings.

1. Hotel reservations

If you are using WooCommerce bookings for your online Hotel Booking system. Then you might have faced 2 issues.

  1. You might be uncomfortable with sharing dashboard access with your staff to create bookings.
  2. There is no automated system to share bookings for the upcoming day.

With the above-discussed plugins; Woocommerce Bookings Google Calendar 2-way Sync and WooCommerce Bookings CSV Exporter, you will get the solution you were looking for.

Your staff can create bookings from shared Google Calendar using WooCommerce Bookings 2 way Google Calendar sync just by typing the name of booking room/service following the prefix “bookings –” which will book the respective time slot dynamically in WooCommerce Bookings and will make the respective time slot unavailable for future.

You can send daily, weekly or monthly email reports for scheduled hotel booking directly in the inbox of your staff using WooCommerce Bookings CSV exporter plugin.

This way neither you would require to share your WordPress dashboard with your staff, nor there will be any scheduled bookings missed on the way.

2. Hair Salon

Just like Hotel bookings, if someone is running a hair salon and have online booking system running on WooCommerce bookings, there might be times when someone walks in the shop and asks to book an appointment for hair cutting at 10 am for the next day. On the other hand, another customer comes online and books the same 10 am time. Now what we can do in such a situation?

Here is where WooCommerce Bookings two way Google Calendar Sync might come in handy. Using this plugin, Hair designer can use his/her Google Calendar to create booking on the way from his/her smartphone which will make the same slot unavailable from WooCommerce Bookings online system.

No more hassle to log in to the dashboard and create bookings manually. The good thing using this approach is you will have all your appointment visible in calendar view simplifying to plan your day ahead.

Wrapping Up

There can be many other use cases that you can think of like booking consultation services and appointments for Doctors. Although the basic WooCommerce Bookings Extension is really powerful, you can always optimize it using WooCommerce Bookings 2-way Google Calendar sync and Bookings Exporter plugin to simplify your workflow.

Excited to hear how you foresee to use these plugins to extend WooCommerce Bookings functionality. You can share your use case in comments.

 

Contact Us