Skip to main content
Database Administrators

Return to Question

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1

I need advice for best sales model for payment process. Basically my system is kind of market place. There is two kind of transaction.

  1. Customer will pay full money to administrator.

    Customer will pay full money to administrator.

  2. Administrator will take some fee and release payment to seller.

    Administrator will take some fee and release payment to seller.

    enter image description here

enter image description here

So for the single order, we need to do two transaction. But Paypal offers Delayed Chained payment option to do in single transaction as below. enter image description here

But I am not sure other major payment gateways are proving this option or not. So I want to design the database compatibly for both.

Note: I want to notify customer after paid at this time I don't know who will be seller. After certain point of time administrator will choose the seller and admin will release the pay to seller. Here I want send notification for both seller and customer.

From above, I need to use unique order_id for both transaction. So should i split the order into two and store as two records or can I manage it in single order row. Advice me reliable and better design pattern for this two kind of situation.

What I tried !

enter image description here

Help me out!

I need advice for best sales model for payment process. Basically my system is kind of market place. There is two kind of transaction.

  1. Customer will pay full money to administrator.
  2. Administrator will take some fee and release payment to seller.

enter image description here

So for the single order, we need to do two transaction. But Paypal offers Delayed Chained payment option to do in single transaction as below. enter image description here

But I am not sure other major payment gateways are proving this option or not. So I want to design the database compatibly for both.

Note: I want to notify customer after paid at this time I don't know who will be seller. After certain point of time administrator will choose the seller and admin will release the pay to seller. Here I want send notification for both seller and customer.

From above, I need to use unique order_id for both transaction. So should i split the order into two and store as two records or can I manage it in single order row. Advice me reliable and better design pattern for this two kind of situation.

What I tried !

enter image description here

Help me out!

I need advice for best sales model for payment process. Basically my system is kind of market place. There is two kind of transaction.

  1. Customer will pay full money to administrator.

  2. Administrator will take some fee and release payment to seller.

    enter image description here

So for the single order, we need to do two transaction. But Paypal offers Delayed Chained payment option to do in single transaction as below. enter image description here

But I am not sure other major payment gateways are proving this option or not. So I want to design the database compatibly for both.

Note: I want to notify customer after paid at this time I don't know who will be seller. After certain point of time administrator will choose the seller and admin will release the pay to seller. Here I want send notification for both seller and customer.

From above, I need to use unique order_id for both transaction. So should i split the order into two and store as two records or can I manage it in single order row. Advice me reliable and better design pattern for this two kind of situation.

What I tried !

enter image description here

Help me out!

Tweeted twitter.com/#!/StackDBAs/status/284283190661758976
Source Link
Gowri
Gowri
  • 209
  • 1
  • 2
  • 11

How to design sales model for escrow type payment process

I need advice for best sales model for payment process. Basically my system is kind of market place. There is two kind of transaction.

  1. Customer will pay full money to administrator.
  2. Administrator will take some fee and release payment to seller.

enter image description here

So for the single order, we need to do two transaction. But Paypal offers Delayed Chained payment option to do in single transaction as below. enter image description here

But I am not sure other major payment gateways are proving this option or not. So I want to design the database compatibly for both.

Note: I want to notify customer after paid at this time I don't know who will be seller. After certain point of time administrator will choose the seller and admin will release the pay to seller. Here I want send notification for both seller and customer.

From above, I need to use unique order_id for both transaction. So should i split the order into two and store as two records or can I manage it in single order row. Advice me reliable and better design pattern for this two kind of situation.

What I tried !

enter image description here

Help me out!