Product Pickup Reservation with Stock Quantity and Email reminder

This project received 31 bids from talented freelancers with an average bid price of $1418 CAD.

Get free quotes for a project like this
Employer working
Project Budget
Total Bids
Project Description

Product reservation system.

Product Table
SKU, Picture, Location, Quantity

Product Category
SKU, Category Name

Reservation Table
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)
reservationid, SKU

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online