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
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