The Mill Bakery is a small sized wholesale bakery in Australia.
Currently customers phone in orders every day before 5pm for baking that night and delivery at 4am the following morning
The three types of customers Mill Bakery serves are cafes, burger restaurants and hotdog restaurants. Each category of customer does not need to see every product type.
The current process of receiving orders is time consuming and prone to error, so a flexible solution is sought to use Google Docs - in particular Google Forms.
The Mill Bakery currently does not have a website.
Willing to take suggestions of alternative ways to develop this solution
There is the possibility of further work integrating this process into a website for the successful applicant
[url removed, login to view]
The applicant needs to be skilled in developing scripts for Google Apps, in particular Forms
Here's a summary of the process required;
1. Email customers at 09.00am every day
1.1 Not every customer is open every day - only email order form on the day before it is open
1.2 Not every customer orders everything - only include products that relate to that customer type
1.3. The order form should include basic information such as the customer name, Mill Bakery’s details and the day the order is for.
2. Receive order - Create a new Daily Production List spreadsheet for each day’s order. Add customer’s order to this database
2.1. Customer can input orders for all future dates ie - from a drop down or calendar box. The default should be current day + 1
2.2 Customers can’t place orders for the current day.
3. Email back Purchase Order to customer once received
4. Email reminder to customer if no order has been received by 4pm and they are open the following day
5. Email summary of customers that have not placed orders at 5pm every day to the bakery manager
6. Email summary of production at 5pm every day to the bakery manager
11 freelancer đang chào giá trung bình $310 cho công việc này
i read your documents.. my projects. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]
Dear Sir, Greetings! We are Reform Consulting with 5 year of experience under our belt. We are really interested to work on your project. Please see PM. Thank you. Regards, RCPL.