You have chosen to sponsor your bid up to a maximum amount of .
Product reservation system.
SKU, Picture, Location, Quantity
SKU, Category Name
ID, first, last, phone, date reserve, pick up date deadline (always 5 days after reserve)
Reservation2product (each entry means 1 quantity off from the product table)
Display products, by categories with being able to see quantity of product in each pickup store
Register a reservation
add products to reservation2product table
deduct quantity appropriately from choosen store
email user reservationid and what they have reserve
run a cron script everyday to remind people that has only 1 day left to pick up their order.
everyday purge all order that didn't get picked up by their deadline date. and replenish stock accordingly.