Case Study

Customized Vendor Management System Improves Eat Cake Today’s Operations

Industry

E-commerce

Core Technologies

AJAXJavaScriptMySQLPHP

Challenges

Eat Cake Today faced several challenges as its processes were still manual, and nothing was automated. They could not coordinate with vendors and manage order processing and delivery times accordingly.

Their main issues were:

  • Some vendors had the high baking capacity and shorter cooking periods, so managing dates for cakes from such vendors was challenging for them. 
  • Eat Cake Today had to manually write baking time in each product description. 
  • They had to manually mark each product if it became unavailable on a holiday. 
  • They had to manually add shipment dates for shipping companies. 
  • Lacking a centralized vendor management system was consuming a lot of unwanted time, energy, and mishaps.

The client’s main requirement was to create a centralized vendor management system. 

  • They can add vendors and delivery companies by themselves.
  • The cake vendor can manage the baking capacity, time, and cake availability on holidays.
  • The store front will display cakes according to availability.

Solutions

We developed a customized Vendor Management System (VMS) to automate vendor coordination, improve scheduling, and enhance operational efficiency.

Centralized Vendor Database: A dedicated database was implemented to store vendor details, product availability, and delivery schedules in one place.

Automated Time Tracking: The system allowed vendors to manage their own baking schedules, delivery times, and availability on holidays, reducing the need for manual intervention.

Dynamic Storefront Display: Cakes were displayed on the website based on real-time availability, ensuring customers only saw products that were ready for order.

Automated Holiday & Stock Notifications: Vendors could pre-schedule product availability and mark items unavailable during holidays, preventing last-minute order issues.

Efficient Delivery Coordination: A shipment scheduling system was integrated to allow vendors to manage delivery timelines with logistics providers, improving order fulfillment accuracy.

Technologies and Tools

Backend Development

PHP

Frontend Development

JavaScript, AJAX, HTML5, CSS3

Database Management

MySQL

Web Server

Apache/NGINX

Vendor & Order Tracking

Automated scheduling and status tracking

Results

arrow-icon

40% Reduction in Manual Effort: Automating vendor and product management significantly reduced time spent on administrative tasks.

arrow-icon

Improved Order Accuracy: The real-time availability feature eliminated order cancellations due to unavailable products.

arrow-icon

Better Vendor Coordination: Vendors could now self-manage schedules and deliveries, improving efficiency and reducing miscommunication.

arrow-icon

Enhanced Customer Experience: Customers could view accurate product availability, resulting in a 20% increase in completed orders.

arrow-icon

Streamlined Logistics: Integration with delivery services improved on-time deliveries by 35%, reducing delays and order tracking issues.

Words of Appreciation

"Working with Lucent Innovation made a huge difference for Eat Cake Today. Their vendor management system helped us organize our vendor and delivery information, saving time and reducing mistakes. The automated features have made everything run much smoother. We’re incredibly grateful for their expertise and support, and we’re really happy with the results!"

Kevin Tan

Senior Operations Coordinator

One-stop solution for next-gen tech.