Skip to main content

Featured

Constraints

NOT NULL CONSTRAINT -    Ensures that a column cannot have a null value. DEFAULT CONSTRAINT -    Provides a default value for a column when none is specified  UNIQUE CONSTRAINT -   Ensures that all values in columns are different  CHECK CONSTRAINT -   Makes sure that all values in a column satisfy certain criteria  PRIMARY KEY CONSTRAINT -   Used to uniquely identify a row in the table  FOREIGN KEY CONSTRAINT -   Used to ensure referential integrity of the data  Primary Key - is used uniquely to identify each row in a table . It can consist of one or more columns on a table . When Multiple columns are used on a table it is called composite key.  Foreign Key - Foreign key is a column or columns that references a column most often primary key of another table . The purpose of foreign key is to maintain referential integrity of the data. Pg admin  Data base - training - right click on training - query click  Always add semi colen to run the query  Int - integer  varchar - variable charact
Post a Comment
Read more

Payments and Shipping

 A retailer , manufacturer anybody can start there E - Commerce website .

When to start e - commerce website ?

When you have identified a unique concept and have proof of concept . Don't start until you have not sold a single piece .

Sell some product before starting . 


How to start ?

Reach web developer , but if you can hustle a little more , if you can create something then suggestion is do yourself , learn yourself , implement it .

A couple of platform is Shopify , WOO Commerce. They help you create your own e commerce website without technical knowledge (Usually SaaS solution).

Both these platform have the features . They have large market share. 


How to collect Payments Online ?

Payment gateway companies help you get payment Online. 

Top is Razor pay, Pay U, Simpl - INR In india 

USD or EURO etc - Stripe , Pay pal (very expensive)

They will charge on Each transaction .23.8 rs on every 1000 rs by Razor pay .

You should trust them , they have strong digital protocols . 

In India you have to get approval from RBI if you want to become a company like Razor Pay , You have to have 2 million dollars every time as deposit !

You can trust them left right centre. 

CC avenue charges 2% 

Stripe charges you 3%

Pay pal online transaction charges 4% and Simpl charges 5% for any transaction . 

Simpl is an Indian company while pay pal is American .


Example -

Transaction Value 1000

Transaction Charges 10

GST On transaction charges @18% rs 1.8

Amount you receive after deduction rs 988.2 

Settlement date is transaction day + 2 days.

Strip has t +8 days , the first time you make transaction in pay pal can happen in 30 days .

Pay pal is one of the longer settlement periods . 


Who should you go for ?

CC avenue is oldest in India 

Razor pay is fastest and largest

They both charges 2% + extra charges. 

If I am basing my decision  on interface .


Strip is better than Pay pal , it makes you more convenient rather than arranging a pay pal account .




Comments

Post a Comment

Popular Posts