I currently sell raw milk to people who order and deliver to my designated drop-off places; the number of drop-off places can increase. I deliver three times a week - Monday, wednesday and Friday but only go to each drop-off point once a week ( 16 places on Fridays, including some deliveries to non designated points e.g. home because I was going past), 16 on Wednesdays, 10 on Monday. I would have about 500 customers but that is steadily increasing. I sell in 1 litre bottles, 2 litre bottles and returnable 10 litre and 20 litre pails but a person may request - say 15 litres in a 20 litre pail. Some people get a standard order each week, some each fortnight, some only get when ordered, some try once and then nothing more is ever heard from them, some people are regular for sevral weeks then just disappear.
I currently have an explanatory website - as a subsection of another website - with a contact address - people then contact me with their requirements, I incorporate it manually into an excel spreadsheet with totals at each drop-off point, those totals add up to total number of bottles to be delivered on the day and - hopefully - it all works out ( 1 + 1 = 2) but it's a lot of manual work on my part AND I MAKE MISTAKES. What i need is a totally seamless (on my part) ordering system which prints the drop-off sheets; I leave drop-off sheets with the milk at each depot so people can read what's on the list, just take and go - some people collect for them selves and others too so a drop-off sheet is critical. THe total number of litres delivered have to be added up at the end of each month. It would be nice to have a check that everybody had actually paid for the milk ordered but I'm not making that an essential criteria as most of my people are honest and if the ordering can be sorted out it will all 'fall into place.' (There are some places I go to and find uncollected milk from the week before and I assume something went wrong somewhere.) My current thoughts are to have a standalone website and the odering / delivery criteria a section people get directed to. I fail to see why the cutoff point for orders on the day can't be 0300 hrs on the day of delivery. I need to be able to see what I have to bottle when I arise at 0400 hrs.
Is this enough detail for starters?