We have a client that requires an e-commerce site with a product database linked to an external MySQL database. The client is selling a product through the site and also offers a product fitting service.
The customer needs to be able to purchase a product and also have the option to book an appointment with an available fitter at an available time. Also payment for the service when booking.
The project needs to be built on WordPress using the WooCommerce e-commerce plugin. The booking system also has to be part of WordPress in order that our client can then login and handle any fitting appointments and purchases that have been made on the websites. However, we are open to suggestions if there is a better alternative solution for this project.
1). Link 2 MySQL databases together
2). Order process: a).Cart > b).Checkout > c). Confirm Booking d).Payment > e).Confirmation Appointment By Email
3). WordPress: Integrate Woocommerce plugin with an Appointments Booking plugin for a seamless transaction.