Jewelry Sales System At The Store

Software Requirement Specification

1.Team Member:

• Nguyễn Ngọc Quy SE171134

• Hoàng Việt Đức SE170590

• Huỳnh Thái Tài SE171320

• Phan Tuấn Đạt SE182381

2.Requirement:

2.1 Name of The System:

Jewelry Sales System At The Store

(Phần mềm bán hàng trang sức tại cửa hàng)

2.2 Purpose of The System:

This project's goal is to make a system that can help shops whose main category is jewelry or accessories to be able to sell products, and manage staff.

2.3 Actor

No.	Actor	Description
0.	Guest	Guest is a person who hasn't logged in the system. Guest's main job is access to the system to get a role.
1	Registered User	Registered User is a person who has logged into the system. A Registered User is a person who can log out the system.
2	Admin	Admin is a person who logged in the “Jewelry Sale System At The Store” System as “admin” role. Admin is the person who manages all managers activities and monitors the dashboard.
3	Manager	Manager is a person who logged in the “Jewelry Sale System At The Store” System as “manager” role. Manager is the person who manages all staff, product, and promotion.
4	Staff	User who manages customer’s cart and supports customers during the purchasing process.

2.4 List of Feature:

Registered User

No.	Use case	Description
1.	Login	Log in into the system as a specific role by email, password
2.	Logout	Log out the system

Admin

No.	Use case	Description
1.	Add Manager	Create a new account for manager role
2.	Update Manager Info	Edit manager information
3.	Change Manager Status	enable/disable manager account status
4.	View Dashboard	View dashboard statistics in an interval of time
5.	View Manager List	View list of managers.
6.	View Manager Info	View manager detailed info.
7.	Search Manager	Search manager by name, status, counter ID, phone number

Manager

No.	Use case	Description
1	Add Staff	Create a new account for staff role
2	View Staff List	View list of staff
3	View Staff Info	View staff detail info
4	Search Staff	Search staff info by phone number, name, status, counter ID
5	Update Staff Info	Edit staff information, enable/disable staff account
6	Change Staff Status	Change staff status (enable/disable) in staff account
7	Add Product	Create a new product
8	View Product List	View list of product (name, price, stock) available in store
9	View Product Info	View product’s specified info such as name, price, stock, weight,...
10	Search Product	Search product by product ID, name,...
11	Update Product	Edit product info in product list
12	Change Product Status	Change product status (enable/disable) in product list
13	View Counter Info	View the revenue and staff info of the counter under the management of the manager
14	Create Counter	Create a new counter
15	Delete Counter	Remove a counter, including its info
16	View List of Counter	View a list of counters
17	Add Promotion	Add promotion code + price for deduction + started date + ended date
18	View Promotion List	View list of valid/invalid promotion code
19	Update Promotion	Change promotion info
20	Change Promotion Status	enable/disable promotion status
21	Search Promotion	Search promotion by name, status

Staff

No.	Use case	Description
1.	Add Item	Add a new item in the cart by scanning barcode or by inputting product code directly
2.	Delete Item	Remove item from the cart
3.	Update Cart	Update item’s quantity in the cart
4.	View Cart	View the product in the cart and total price. - Price of product = historical cost * gold price ratio. - Historical cost = (Gold price at current time * product weight) + manufacture price + stone price.
5.	Print Receipt	Print receipt for customer after payment
6.	Print Warranty	Print warranty for each accessory that customers has purchased
7.	Check out	Confirm the payment and change the stock
8.	Refund	Reclaim the product that customer had bought from the store before.
9.	View Product Info	View product information such as name, price, stock, weight,...
10.	View Order List	View list of order
11.	View Order Info	View order’s properties
12.	Search Order	Search order based on customer’s phone number and order ID.
13.	Update Order	Edit order info (status, delivery date).
14.	View Customer Info	View customer info + their point
15.	Search Customer	Search customer info base on phone number
16.	View Customer List	View List of Customer
17.	View Product List	View list of Product.
18.	Change Counter Status	Announce to customers that this counter is unoccupied/occupied.
19.	Search Product	Search product by product ID, name,...

2.5 Statistics

• Dashboard Statistics

• Total Revenue.

• Amount of Order.

• Product Statistic

  • Product ID

  • Product Name.

  • Price.
  • Refund Price.
  • Stock.
  • Description.(Weight, Main Stone, Sub Stone, Number of Main Stone, Number of Sub Stone, Brand, Cut)
  • Labor Cost.
  • Stone Cost.
  • Promotion ID.
  • Gender.
  • Category.
  • Status.

• Staff/Manager/Customer Info

  • User ID.
  • Full Name.
  • Address.(Staff/Manager only)
  • Role.
  • Phone Number.
  • Email.
  • Gender.
  • Point. (Customer only)

• Order/Refund Info:

  • Order ID.
  • Customer ID.
  • Customer Name.
  • Phone Number.
  • Gender.
  • Order Date Time.
  • List of purchased products:

• Name.
• Quantity.
• Price. (Individual Price * Quantity)

• Sale Promotion. (optional)
• Total Cost. (Sum of Product’s Price)

• Promotion Info:

  • Promotion ID.
  • Description.
  • Discount Rate.
  • Status.

• Cart Info:

  • ProductID.
  • Product Name.
  • Amount.
  • Price.
  • Total Price. (Sum of each product’s price)

2.6 Order Management

• Order Process:

• Create order at store:

  • Step 1: Input Customer Information.
  • Name.(Required)
  • Phone Number.(Required)
  • Gender.
• Step 2: Check out

• Choose payment method: cash, momo.
• Issue company invoice.(optional)
• Perform payment.

2.7. Staff Management

• 1 manager manages 3 counters.
• Manager can check the revenue of each counter and each staff member.

3.Policy:

3.1 Points Policy

• The payment will be turned into points, with every 10 million vnd = 1 point.
• Points can be used in various activities such as discounts.
• The point will be printed within the receipt in a form of code. (User will input the code into their account gift code feature or in web gift code page)

3.2 Discount Policy

• Discount Money = Discount during sale promotion (optional) + Discount for customer(optional) + Discount money per point (optional)

• 2 types of discount:

• Discount during sale promotion.
• Discount for customers.

• 1 point = 100.000 vnd discount.

3.2 Purchasing Policy

• For women’s accessory + normal stone, Shop will only buy the real gold part.
• Reclaim the jewels which customers had bought with a percentage of sold price.
• The gold price will be based on a real-time price chart.

3.3 Warranty Policy

• Every accessory can be returned to the shop within 7 days under these condition:

• The accessory must remain intact and not have any sign of being used.

• Return procedure:

• Step 1: Contact the staff to request returning product. (To facilitate the process, customer should provide warranty of the returning product)
• Step 2: We will check the product’s warranty and product’s integrity then respond to the customer.
• Step 3: We will perform a refund/replace procedure. (100% sold price)