Clicking on any Account No on the List of Members page leads to this Account Details page for that Account. Click on the Member Details link to view or edit the membership fields associated with the account. Click on the Purchase History to view a list of shopping orders made by the member. Follow the Order ID(s) to view the details of that order.

Developers: New fields can be added to the database as necessary. You create a form element on the detail.asp page, then add a field with the same name to the "Accounts" table in the membership database to accept the information. Knowledge of HTML and Database is required.

The following sections will explain each part on this page.

It is highly unusual to change the account number or account type of an existing account. An account number consists of three parts (separated by hyphen "-"): Account Prefix (as defined in Membership Admin Settings), Account Type ID, and a sequence number (across all types). To do so:

1. Enter the New Account number (please follow the convention) ;
2. And/or select  another Account Type from the Drop-down list;
3. Press the Change! button to proceed the changes.

CyberClub will attempt to update the information across all the tables affected, including the that in shopping cart database. However, this might not exhaust all the places, especially if you have you own customizations on the program in place.

You may modify one or more of the following fields then Click the Update Info button.

Cancel Status:  Setting this to any nonzero integer would suspend the account. Exactly which integer is up to your interpretation. Presumably you use different integers to identify different reasons of suspension.

Account Balance:  Set the balance of the account. If Cancel Status was nonzero and Expiry Date was set, attempting by the member to login to the application will display a membership joining/renewal information. It links to CyberShop to process the payment.

Recurrent Bill: The number of entries can be expanded by adding new fields to the Accounts table (e.g. ExpiryDate2, Period2, Balance2, BillDesc2).

This block lets you specify the attributes of a recurrent bill. Their meanings are quite self-explanatory. At run time, either the Batch Renewal / Recurrent Billing (one of the Batch Operations on the List of Members) or a proper member login will handle the billing automatically. Namely, either of the actions will add the recurrent bill to the total balance when it maturates.

Credit Limit:  If set to nonzero (positive), it allows the member to purchase goods from the underlying Web site using any of the payment method(s) specified in Membership Admin Settings. The available credit is (Credit Limit) - (Account Balance) - (New Order on Hold).

Billing Date:  The date that the account balance was updated. This information will be displayed to the member when he/she checks his account balance on the Web site. This field is filled when an account is created. Afterwards you should manually update it (if you are to bill the members).

New Order on Hold:  Amount of Shopping Orders that has been made since the last balance field was updated. This works in conjunction with the Credit Limit field. It needs to be cleared periodically and manually.

Points Redeemed:  The buyer's point that were redeemed on the last (most recent) purchase. Buyer's points are accumulated by default as one-dollar-per-point. You can find the setting on the finalize.asp page of the shopping cart folder:

Session(DSN+"DollarToPoint") = 1

Setting this to -1 to stop the accumulation of points.

You also need to specify on the shopping page a hidden field "Point" to tell CyberShop how much is required to redeem a specific product (cf. the Main Help Page for more explanation).

You may increase points to the account by subtrating the amount from this field (it may end up with a negative number, which is acceptable).

Membership Expiry Date:  This field will be automatically updated if the appropriate information is set in the Configure Account Types, along with Cancel Status and Account Balance.

Administrative Remark:  Anything special about a particular account.

Vendor's Shopping Cart Database: This field assumes that the owner of the account is a merchant, who is allowed to upload products to the CyberOffice Warehouse Builder (CyberBuild) database. Cf. Catalog Admin Settings and Merchant Upload Interface for more information on the working with CyberBuild. Typically, it is used in a CyberOffice Franchise & Shopping Mall (CyberMall) application.

This field specifies a valid connection string pointing to the shopping cart database operated by the account owner. At run time, CyberMall will dispatch any order placed on the master shopping cart to this shopping cart and notify the merchant about the order (if the order contains this merchant's products). Presumably, the central admin will give the merchant a Shop Manager interface to manage their own orders.

Note that the field is optional, not every merchant is required to have their own shopping cart. 

Forwarding Email for new Orders: Similar to the above field. This specifies the email to receive the order notification.

Purchasing History section displays the shopping orders that the member has made in reverse chronological order. If the order information exists in the associated CyberShop, the amount will be displayed. Click on the Order ID to display the Shopping Order Details.

This page lets you remove any cancelled orders by selecting the orders and clicking on the Remove Order button. This will effectively stop redeeming the buyer's points that are originated from the cancelled orders.

Note that the action deletes only the information on the CyberClub membership database. The order information still remains in the shopping cart database.