💻 Smart Hardware Assistant: Component Stock, Specification Substitutes & POS Billing
Computer hardware shops manage diverse product categories such as processors, graphics cards, RAM kits, and storage drives. When a specific hardware model is out of stock, customers need compatible alternative parts with equivalent technical specifications. This complete project implements an intelligent chatbot agent featuring session lifecycle greetings, SQLite hardware inventory tracking, compatible component substitution logic, cart item summation, and a formatted point-of-sale tax receipt.
📊 End-to-End Computer Hardware Chatbot Session Lifecycle & Billing Workflow Diagram
1. Session Initialization
Bot triggers explicit Welcome Greeting & introduces hardware assistant.
2. Customer Order Inquiry
Customer requests computer parts with desired quantities.
3. SQLite Hardware Lookup
Queries database for stock status, pricing & technical category specs.
6. Session Termination
Bot outputs polite Thank You message & closes interaction.
5. Bill Generation & Summation
Calculates item totals, sums combined amount, and prints official tax invoice.
4. In-Stock / Substitute Check
Confirms available items or suggests alternate compatible parts if stock = 0.
import sqlite3
# 1. Initialize Computer Hardware SQLite Database
def setup_hardware_shop_database():
conn = sqlite3.connect("hardware_shop_billing.db")
cursor = conn.cursor()
cursor.execute("""
CREATE TABLE IF NOT EXISTS hardware_items (
id INTEGER PRIMARY KEY AUTOINCREMENT,
part_name TEXT NOT NULL,
category_spec TEXT NOT NULL,
stock_qty INTEGER NOT NULL,
price REAL NOT NULL
)
""")
# Seed computer hardware inventory items (processors, GPUs, RAM, SSDs)
sample_hardware = [
("NVIDIA RTX 4075 Super", "Graphics Card 12GB VRAM", 12, 58000.00),
("AMD RX 7800 XT", "Graphics Card 16GB VRAM", 0, 52000.00), # Out of stock alternative
("Intel Core i7-14700K", "Processor LGA1700", 25, 36500.00),
("AMD Ryzen 7 7800X3D", "Processor AM5", 18, 38000.00),
("Corsair Vengeance 32GB RAM", "DDR5 5600MHz Kit", 35, 10500.00),
("Kingston Fury 32GB RAM", "DDR5 5600MHz Kit", 0, 9800.00), # Out of stock alternative
("Samsung 990 PRO 2TB NVMe", "Gen4 M.2 SSD", 50, 16500.00),
("WD Black SN850X 2TB NVMe", "Gen4 M.2 SSD", 0, 15500.00), # Out of stock alternative
("Corsair RM850x Power Supply", "850 Watt 80+ Gold", 20, 12500.00)
]
cursor.executemany("INSERT OR IGNORE INTO hardware_items (id, part_name, category_spec, stock_qty, price) VALUES (?,?,?,?,?)",
[(i+1, d[0], d[1], d[2], d[3]) for i, d in enumerate(sample_hardware)])
conn.commit()
conn.close()
# 2. Database Hardware Lookup Tool
def check_hardware_inventory(part_name: str) -> dict:
conn = sqlite3.connect("hardware_shop_billing.db")
cursor = conn.cursor()
cursor.execute("SELECT part_name, category_spec, stock_qty, price FROM hardware_items WHERE part_name LIKE ?", (f"%{part_name}%",))
row = cursor.fetchone()
conn.close()
if not row:
return {"status": "not_found", "message": f"Sorry, '{part_name}' is not available in our hardware catalog."}
part, spec, qty, price = row
if qty > 0:
return {"status": "in_stock", "part": part, "spec": spec, "stock": qty, "price": price}
else:
return {"status": "out_of_stock", "part": part, "spec": spec}
# 3. Compatible Component Substitution Tool
def find_alternative_hardware(category_spec: str, excluded_part: str) -> list:
conn = sqlite3.connect("hardware_shop_billing.db")
cursor = conn.cursor()
cursor.execute("SELECT part_name, stock_qty, price FROM hardware_items WHERE category_spec = ? AND part_name != ? AND stock_qty > 0", (category_spec, excluded_part))
rows = cursor.fetchall()
conn.close()
return [{"part": r[0], "stock": r[1], "price": r[2]} for r in rows]
# 4. Intelligent Chatbot Session & POS Billing Receipt Controller
def run_hardware_shop_billing_chatbot(order_requests: list[dict]):
# Session Welcome Message
print("=" * 80)
print("🤖 Chatbot: Welcome to Nikita CyberTech Hardware Store! I am your tech assistant.")
print(" I can check component stock, suggest compatible substitutes, and generate your invoice.")
print("=" * 80)
cart_items = []
for req in order_requests:
part_query = req["part"]
qty_requested = req["qty"]
print(f"\n[Customer Inquiry]: Requesting {qty_requested}x '{part_query}'")
inventory_res = check_hardware_inventory(part_query)
if inventory_res["status"] == "not_found":
print(f"Chatbot: {inventory_res['message']}")
elif inventory_res["status"] == "in_stock":
part = inventory_res["part"]
price = inventory_res["price"]
available_stock = inventory_res["stock"]
if qty_requested <= available_stock:
item_total = price * qty_requested
cart_items.append({"part": part, "qty": qty_requested, "unit_price": price, "total": item_total})
print(f"Chatbot: Added {qty_requested}x {part} to your cart. (Unit Price: ₹{price:,.2f})")
else:
print(f"Chatbot: Sorry! We only have {available_stock} units of {part} in stock (requested {qty_requested}).")
elif inventory_res["status"] == "out_of_stock":
part = inventory_res["part"]
spec = inventory_res["spec"]
alternatives = find_alternative_hardware(spec, part)
print(f"Chatbot: Sorry, {part} is out of stock right now.")
if alternatives:
alt_names = [a['part'] for a in alternatives]
print(f" -> Compatible alternative parts available with matching specs ({spec}): {alt_names}")
else:
print(f" -> Sorry, no alternative compatible parts are currently available in stock.")
# Generate Official Tax Invoice if Cart has Items
if cart_items:
print("\n" + "=" * 65)
print(" NIKITA CYBERTECH HARDWARE STORE ")
print(" OFFICIAL TAX INVOICE ")
print("=" * 65)
print(f"{'Hardware Item Description':<32} | {'Qty':<3} | {'Price':<9} | {'Total'}")
print("-" * 65)
grand_total = 0.0
for item in cart_items:
print(f"{item['part']:<32} | {item['qty']:<3} | ₹{item['unit_price']:<8,.2f} | ₹{item['total']:,.2f}")
grand_total += item['total']
print("-" * 65)
print(f"{'GRAND TOTAL PAYABLE:':<40} | ₹{grand_total:,.2f}")
print("=" * 65)
else:
print("\nChatbot: No hardware items were successfully added to your cart, so no invoice was generated.")
# Session Thank You Message
print("\n" + "=" * 80)
print("🤖 Chatbot: Thank you for shopping with Nikita CyberTech Hardware Store! Build your dream PC with us again. Goodbye!")
print("=" * 80)
# Execute Complete Project Demo
setup_hardware_shop_database()
# Test Customer Session ordering available components (RTX 4075 Super & Intel i7-14700K)
# plus testing an out-of-stock item (WD Black NVMe -> suggesting alternative Samsung 990 PRO)
customer_order_session = [
{"part": "RTX 4075", "qty": 1}, # Available (In Stock)
{"part": "Intel Core i7", "qty": 1}, # Available (In Stock)
{"part": "WD Black", "qty": 1} # Out of stock (Triggers compatible substitute notice)
]
run_hardware_shop_billing_chatbot(customer_order_session)