This includes;

• List Seller Name
• Delete Seller Button
• View Seller Information (Products Details)

I recommend header should be separated to the whole website to prevent copy pasting of codes

• Header for Buyers must include

• Shop Name

• Shop Brand

• About Page

• Drop Down List
  1. Order History of the Buyer
  2. Carts (Including number of Carts they add)
  3. Settings Button for Buyers
  4. Logout Button

• Headers for Sellers must include

• Brand and Name of the Shop

• User Settings

• Logout Button

• Header for Admin

• Brand and Name of the Shop

• User Settings

• Logout Button

NOTE: This can be done in separated files(buyerHeader.php, sellerHeader.php, adminHeader.php)

• Showing the list of Items
  - Name
  - Picture of the Product
  - Price
  - View Button
  - Add to cart button

In homepage seller will show a product of the seller

• Seller can remove the product
• Seller can edit the specific product

• Connection to the Database

When a buyer click "Add to Cart"

• It automatically added in a buyer acount

• It can be saved in database (Cart)

• Add Cart (if already in cart table add amount + 1)

• Remove Cart (In checkout system)

By Clicking "VIEW" in Homepage UI you will be directed to the following

• Product Image (Specific)
• Product Name (Specific)
• Category
• Details
• Add to Cart Button

NOTE: This should be automated as the buyer will automatically add a product for less work force in making the website one by one according to the number of products

There are separate transactions (3)

• For the Sellers

  • Pull all the transactions in with a name of the seller.
  • Pull all the product amount and price of the transactions
  • Add an option when the seller packed the item.
  • Status will be inserted to the database

• For the Buyers

  • The buyers will only view the transaction history
  • Can cancel the product when the seller hasn't packed the product

• For the Admin

  • Admin can view all the transactions but it can't be deleted
  • If the status is packed, the admin can change the status to shipped to logistics
  • If the status is shipped the admin can also change status to delivered

List of Status

• Pending Order
• Packed
• Shipped
• Delivered

Information to be added not enough details and knowledge

1. User choose an amount
2. Calculates all the amount in the cart for checkout
3. Selects the Option in Delivery
   • Cash on delivery
   • Cash Card
4. Display Status
   • Packed
   • Shipped
   • Received
5. Transactions are recorded
6. Buyer have a received button
7. Seller have a packed button
8. Admin have a shipped button

• PHP <?php echo("Hello World!");?>
• Javascript console.log("Hello World");
• Bootstrap for designing

This is to arrange the files according to the functions needed for more code readability and reduce redundancy

• Main Functions
• Seller Functions
• Buyer Functions
• Transaction Functions

This includes:

• Product Name (Text Box)
• Product Details (Text Box)
• Category (Text Box)
• Price (Text Box)
• Change Image (Text Box)

Previous information must be in the text box to have less work

• Login

• PHP Check login userdata

• Redirected to login and signup when accessing the homepage

• Login for Admin (No register, username and password only)

• Register

• All of the text box are required <input type="text" required>

• Password must be hashed when going to the database $_password = md5($_POST['password']);

• Password confirmation

• Does not register if it has duplicate email

• Register for Seller

• Same as the register for buyer

• Login for Seller

• Same as the login for buyer

• Buyer

  • Has Picture
  • Has Details
  • Has Add to Cart Button

• Seller

  • Has Picture
  • Has Delete Product Button when clicking it will ask the password to confirm
  • Has Edit Button Will preview all the previous information to the inputs

• Admin

  • Can only View the product by the seller Don't Delete
  • Has Picture
  • Has Details
  • Has Seller Name

Scripts that view all the products in database to the store

• View Button for Product Description
• Add to Cart Button

Includes

• Cart Button

• Cart Button will add a number of carts
  

• Log out Button

• Buyer

  • Can change the information
  • Can change the password ENTER PASSWORD CURRENT AND NEW

• Seller

  • Can change the information
  • Can change the password ENTER PASSWORD CURRENT AND NEW

• Admin

  • Can change the password ENTER PASSWORD CURRENT AND NEW

• In home page of both buyer and seller there will be settings tab where you can change password

• Inputs

1. Existing Password
2. New Password
3. Confirm Password

• Alert Password changed
• Redirects to the Login page to login again

Script that redirects to login page
Removes saved information (auto redirect)

• Script for login buyer
• Script for login seller
• Script for login admin

This database rows are the following:

For Buyers

• Increment ID
• User_ID (Automated)
• Email
• Contact Number
• Name (First Name, MI and Surname Combined)
• Password
• Cart Systems
• Registered Date

For Sellers

• Increment ID
• buyer_id (Automated)
• Name (First Name, MI and Surname Combined)
• Email
• Contact Number
• Password
• Registered Date

Product

• Increment ID
• Product ID (Automated)
• Product Name
• Product Detail
• Seller Name
• Price
• Amount
• Image

Admin

• Username
• Password

Transactions Database

• Incremented ID
• Transaction ID
• Product
• Quantity
• Price
• Payment Method
• Timestamp
• Buyers ID or Name
• Seller ID or Name

EDIT: Added transactions database

This include

• Product Name
• Product Details
• Price
• Amount
• Image

• In product page it has a UI that click edit
• Will show a pop-up for edit section
• Seller remove the information that is already in textbox (previous information to edit)
• Click EDIT will confirm and send a query to the database otherwise click X

• When the admin click view
• Has a delete button
• Shows the following
  • Seller ID
  • Seller Name
  • Contact Number
  • Registered Date
    Password is not displayed

• Login
  • Email
  • Password
• Register
  • Email
  • Contact Number
  • Name (First Name, MI and Surname Combined)
  • Password
  • Confirm Password
• Register Buyer
  • Name (First Name, MI and Surname Combined)
  • Email
  • Contact Number
  • Password
• Admin Login Access (No register)
  • Admin Username
  • Admin Password

• GET All transactions
• GET SpecificTransactions (Buyer, $id)
• GET SpecificTransactions (Seller, $seller)
• UPDATE Status to Packed (Seller)
• UPDATE Status to Shipped (Admin)
• UPDATE Status to Delivered (Admin)
• DELETE Transactions from the Database (Admin)

This Includes:

• Seller List of Products
• Quantity
• Delete Button
• Seller Delete Button

Note: When Deleting make sure it ask confirmation before proceeding as it doesn't have a way to regain it's details once it is deleted

Make a script that automatically redirects the login into the home page if the user has already logged in

if(userHasAlreadyLoggedIn){ redirect to store get all the data from database(name, email, password etc) }

User redirected to the View Page Product
Shows the following

• Title (product_name)
• Description (Product_detail)
• Seller name
• Price
• Amount
• Product Image

Has

• Add to Cart Button
• Continue Shopping Button

• Show list of Sellers
• Has a Delete Seller Button
• View button to show details

• LOGIN Buyer
• LOGIN Seller
• LOGIN Admin
  =========================
• REGISTER Buyer
• REGISTER Seller
  =========================
• HOMEPAGE Buyer
• HOMEPAGE Seller
• HOMEPAGE Admin
  =========================
• TRANSACTIONS Buyer
• TRANSACTIONS Seller
• TRANSACTIONS Admin
  =========================
• EDIT DETAILS Buyer
• EDIT DETAILS Seller
  =========================
• CHANGE PASSWORD Buyer
• CHANGE PASSWORD Seller
• CHANGE PASSWORD Admin
  =========================
• VIEW PRODUCT Buyer
• VIEW PRODUCT Seller
• VIEW PRODUCT Admin Removed
  =========================
• VIEW BUYER Admin
• VIEW SELLER Admin
  =========================
• ABOUT Buyer
• ABOUT Seller
• ABOUT Admin
  =========================
• ADD-TO-CART Buyer
• CHECKOUT Buyer
  =========================
• DELETE PRODUCT Seller
• EDIT PRODUCT Seller
  =========================
• DELETE BUYER Admin
• DELETE SELLER Admin
  =========================
• PAGINATION Buyer Homepage

• Admin click delete button
• It should ask for the password to confirm delete

Seller Section

• Add delete UI in seller store
• Clicking view will show a pop-up of the product
• When the seller confirms they remove, they will type a their password for confirmation, otherwise click "X"

Automatically added a listed item when a buyer register a product

• Buyer

  • Tables that show the transactions
  • Show Status
  • Actions: If the STATUS is ORDER PENDING then action can click CANCEL ORDER

• Seller

  • Tables show the transactions of buyer in their product
  • Actions: If the STATUS is ORDER PENDING you can click PACKED

• Admin

  • Table that shows all the transactions
  • Actions: If the STATUS is PACKED you can click SHIP NOW
  • Actions: If the STATUS is SHIPPED you can click RECEIVED

Includes:

• Headers for Sellers

• Buyers Products

  1. Delete Button
  2. Edit Button
  3. List Product Button
  4. Quantity