Online Escrow Service
$30-250 USD
Plačilo ob prevzemu
would like to write a script for establishing an escrow system but I have no idea for how should be structure of database table. In this system, users can send money to "escrow system" through a kind of payment gateways (a payment gateway API is already available). There are 3 parties in transactions, a buyer, a seller and an escrow account. And system should work as folowings:
- Buyer send payment to escrow account. And when payment confirmed by escrow mods/admins emails should be sent to buyer and seller
- Seller send the item to buyer. When he/she sends the item, emails should be sent to buyer and escrow account.
- If buyer gives confirmation when he/she receives the item without any problem, money from the escrow account should be transferred to seller. If buyer does not give a confirmation in a certain period or gives negative comments system should work to backwards ..Confirmation info should be email to seller and escrow account.
USERS
userid (integer, autoincrement)
username (text)
password (text)
allowed_to_purchase (Y/N)
allowed_to_sell (Y/N)
allowed_to_adimn (Y/N)
...various other fields such as contact info etc
TRANSACTIONS
transactionid (integer, autoincrement)
sellerid (Foreign Key to user table)
buyerid (Foreign Key to user table)
description (text)
value (real)
status (FK to transaction_status table)
TRANSACTION_STATUS
statusid (int)
meaning (enum "Awaiting Payment", "Payment Received by Escrow", "Order despatched", "Order received", "Seller Paid")
This is a very basic data set but sould get your prototype up and running.
Form 1 could allow people to register.
Form 2 could allow an admin to assign buy/sell/admin rights to users
Form 3 could allow a buyer to create an escrow payment
Form 4 could allow an admin to acknowledge receipt of payment
Form 5 could allow a seller to signal dispatch of goods
Form 6 could allow a buyr to acknowledge receipt
Form 7 could allow an admin to release payment for the goods
How's that?
ID projekta: #17781660
Več o projektu
Dodeljeno:
9 freelancerjev ponuja v povprečju za $259 na tem delu
We can help you in developing your complete escrow management system. We have checked the fields and the forms that you want. Please send us the complete flow of application so that we can provide you the exact timelin Več
Hello friend, I am so interested in the development of Online Escrow Service , I am an expert web developer, having years of experience. I can give this work with 100% satisfaction ,I have great hands-on HTML, CSS, J Več
Hello there, As we went through your job description and understand your requirements, We can build a script including all your requirements as per your job description. We have 7 year experience in HTML, MySQL, Več
Hello my friend, I just take an overview of your project. I want to impress you with my development skill and services :) , You can visit my profile, I have done 140 + projects here:).I can do this task with 100% satis Več
