Hi your profile came up in odesk recommendation.
I'm looking to create:
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.
Please send me a quote if you are interested in this job.