Marketing

1
E-Commerce Phases
Marketing
Customer/ Visitor
Ship Order
Website Visit
Fulfill Order
ProductBrowsing
Process Order
Shopping Basket
Send Receipt
Checkout
Payment
Taxes and Shipping
2
Site Architecture
Home Page
Department
Search
Product Listing
Product Page
Basket Page
Shipping Page
Payment Page
Confirmation
Order History
3
Department and Product Tables

• Department(DepartmentID, DepartmentName,
  DepartmentDescription, DepartmentImage)
• DepartmentProduct(DepartmentID, ProductID)
• Product(ProductID, ProductName,
  ProductDescription, ProductImage,
  ProductPrice, )
• ProductAttribute(ProductID, AttributeID)
• Attribute(AttributeID, AttributeName,
  AttributeCategoryID)
• AttributeCategory(AttributeCategoryID,
  AttributeCategoryName)

4
Designing Shopping Cart

• Add Item to Basket
• Display Basket
• Update Quantity of Basket
• Remove Item
• Empty Basket

5
Basket Tables

• Basket(BasketID, ShopperID, BasketQuantity,
  BasketDateCreated, BasketOrderPlaced,
  BasketSubtotal, BasketTotal, BasketShipping,
  BasketTax)
• BasketItem(BasketItemID, BasketID, ProductID,
  BasketItemPrice, BasketItemProductName,
  BasketItemQuantity, BasketItemSize,
  BasketItemColor)

6
The Stored Procedures

• procCreateBasket
• procInsertBasketItem
• procRetrieveBasket
• procUpdateQuantity
• procRemoveBasketItem
• procClearBasketItem

7
Calculating SubTotal for the Basket

• CREATE PROCEDURE ProcBasketSubTotal
• _at_basketID int
• AS
• declare _at_subtotal money
• select _at_subTotalsum(BasketItemQuantity
  BasketItemPrice)
• from basketItem
• where basketID_at_basketID
• if _at_subTotal is null
• select 0
• else
• select _at_subTotal
• RETURN

8
Display SubTotal

• Drag the stored procedure to the basket.aspx
• Drag a label box to the basket.aspx
• Add commands in Display Basket section as
• cmdBasketTotal.Parameters(_at_BasketID).valuesessi
  on(idBasket)
• cnn.open
• Label1.TextCurrent Total is
  format(cmdBasketTotal.ExecuteScalar, Currency)

9
Lab 9 10