Shopping & Payment

We plan to use PayPal as payment solution.

PayPal RESTful API

Database

user table (new columns)
- phone
- ship_address
- ship_postcode
- ship_city_id

design_purchase table
- id
- design_id
- price
- currency
- quantity
- payment_id
- user_id
- created_at
- updated_at

payment table
- id
- total
- currency
- method (paypal/credit_card)
- paypal_payment_id
- paypal_user_id
- credit_card_number
- credit_card_type
- credit_card_expire_month
- credit_card_expire_year
- credit_card_first_name
- credit_card_last_name
- user_id
- status
- created_at
- updated_at

Implementation Difficulties

1. Shipment costs.
2. Shopping cart.
3. Return and refund.

Price

Problems:

1. How to convert currency?
2. What if currency rates or prices changed when refund?

Ship Cost Calculate

From Country:       Finland
National ship:      20 EUR
International ship: 45 EUR

Problem:

1. How to combine ship cost of items from the same designer?

Tax

Santakani won't calculate the tax of product prices. Designers should pay VAT based on local tax rates.

Service Fee

Santakani take 10% percent from sales (including product price and ship cost). PayPal will take 3.4% + 0.35 EUR from payment. So the income of Santakani is around 6.5% of each payment.