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