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.
userid (integer, autoincrement)
...various other fields such as contact info etc
transactionid (integer, autoincrement)
sellerid (Foreign Key to user table)
buyerid (Foreign Key to user table)
status (FK to transaction_status table)
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.
14 freelance font une offre moyenne de $329 pour ce travail
Hello, We provide web and e-comemrce development services, and have successfully delivered numerous web solutions to our clients. We are confident we can do this project for you. Front End: HTML, CSS, Angular JS, Plus
Hello Sir, I am the same freelancer for which you are looking and i am feeling happy to say that i am having 5+ exp in website design/development so pls have a look of my past work done and ping me for further proces Plus
Hello Sir , I have gone through your requirements and in the bid amount i can provide you the website development + with some time technical support free as well.i will be available 24/7 for chat and any call .so pl Plus
Hello, Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some backgrou Plus
Dear hiring manager, Greetings! We, an expert team of .Net, PHP developers, have gone through your project requirements. We have a rich experience in the similar project. NOTE:- Online Escrow Service System (back-e Plus
Hello. Your project is very interesting for me. It includes a lot of work. This is why my bid is so big.
Greeting of the day. We have gone through your requirement. It's sound good. We are Professional IT company and still growing, we have very professional 10+ yrs experienced web designer , HTML5 , CSS3 , PHP, JS, Plus
Hello, I have read your project carefully and understood well that you required an back end system. I am honest and dedicated developer. I read your post and i am interested working on your project and i believe tha Plus
Hi, we will summarize all the lectures and will provide you with quality notes. VVV Group is among world’s top entrepreneur business serving millions of customers across Software Designing and Development Like (WEB Plus
Hello Dear Client, I am new on Freelancer but possess 10+ years of experience while working for several companies as a coder at various positions. Now I am full time Freelancer trying to help small businesses and c Plus
Hi, I am an experienced programmer and I'm sure I can complete your project asap. Please contact me and tell about your project details. I promise a high quality and punctual work. Thanks.
Hi, Hire me and my 4+ years of software development including a large bunch of technologies such as Magento2, Wordpress, Laravel, CodeIgniter, ReactJS, KnockoutJS, AngularJS, MySQL, PHP, Centos7, Nginx, Apache. P Plus