Database
When an Email is received from a payment gateway the transaction
details are extracted and put into the database. You can then use
the information to:
- Track the filling of orders.
- Display histograms e.g. number of sales of products
- Display reports e.g. income
- Send mail to selected customers
The information stored (and the processing) is slightly different
depending on whether the transaction is a sale, purchase or a
donation.
Some of the data stored in the database are:
Transactions
- Transaction time
- Amount
- Tax
- Gateway commission
- Type
- Status (new, completed etc)
Items (that make up the transaction)
- Product
- Quantity
- Cost
- Tax
- Status
Customer (for sales)
- Name
- Email address
- Postal address
- Time of last transaction
Merchant (for purchases)
- Name
- Email address
- Postal address
- Time of last transaction
Product
- Name
- Product code
- Cost
- Tax
- Stock level
- Stock low limit
Other information is also stored such as log messages and Emails to
be sent.
sellEbit uses a version of the Derby relational database that is
supplied by Sun Microsystems. If you are really keen you can use the
database GUI to do anything you like with the database.
Home