Back to List
DesignPlug Shop Admin System
B2B admin system for a print design platform
Efficiently manages product registration, order processing, and monthly settlements between suppliers and sellers.
1 / 6
Roles
PlanningDesignFrontendBackend
Tech Stack
Next.js
TypeScript
Prisma
MySQL
Mantine UI
TanStack Query
React Hook Form
Zod
TipTap Editor
react-dnd-treeview
xlsx-js-style
NextAuth.js
Key Features
- Category Management: Drag-and-drop hierarchical category tree structure management
- Product Group Management: Category-based product group creation, image upload, and display order management
- Supplier/Seller Management: Partner information lookup and product connection management
- Settlement Management: Monthly settlement history by supplier, bulk status changes, Excel download
- Board Management: Content management for notices, FAQ, guides with TipTap-based rich text editor
Key Achievements
- Server Actions Pattern Abstraction: Implemented createServerAction utility wrapper integrating auth checks, error handling, and type safety
- Hierarchical Tree Structure Management: Drag-and-drop category ordering and parent-child relationship changes using react-dnd-treeview with transactional bulk saves
- Custom Error Class Hierarchy: AppError-based inheritance structure for HTTP status code-specific error handling (BadRequest, NotFound, Authorization) with auto-logging
- Dynamic Filtering System: Type-safe server component filtering with Zod schema-based URL searchParams parsing
- Settlement Date Range Queries: Efficient multi-year settlement data retrieval with year-month composite condition query logic
- Raw SQL Bulk Updates: Single query processing for multiple record order changes using Prisma $executeRaw with CASE WHEN statements
- Excel Download Feature: Styled settlement data Excel export using xlsx-js-style
#B2B Platform
#Admin System
#Settlement Management
#Product Management
#Next.js
#Prisma