Closed

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
N/A
Total Bids
31
Project Description

Product reservation system.
PHP/MYSQL

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