A modern e-commerce web application for selling printers, ink, toner, and accessories. Built with Next.js 16, React 19, TypeScript, and Tailwind CSS.

• Product catalog with search and filters
• Shopping cart with persistent storage
• Product detail pages with image gallery
• Checkout flow
• Responsive design
• SEO optimized

• Next.js 16 (App Router)
• React 19 & TypeScript
• Tailwind CSS
• SQLite (via better-sqlite3)
• Zustand (State management)

• Node.js 18+

npm install

Create .env.local:

NEXT_PUBLIC_STORE_NAME=PrinterHub
ADMIN_SETUP_KEY=your_setup_key

npm run db:seed

npm run dev

Visit http://localhost:3000

npm run dev          # Start dev server
npm run build        # Build for production
npm start            # Start production server
npm run db:seed      # Seed database
npm run db:reset     # Reset and reseed database
npm run lint         # Run ESLint

Uses SQLite (via better-sqlite3) stored at data/printers.db with tables: categories, products, orders, order_items, users, sessions.

Use npm run db:seed only for first-time setup or to reset sample data. After that, manage products and categories from the Admin dashboard.

See USER_MANUAL.md for setup, storefront usage, auth flows, cart behavior, and admin access.

• First-time setup: http://localhost:3000/admin/setup (requires ADMIN_SETUP_KEY)
• Admin login: http://localhost:3000/admin/login
• Admin dashboard: http://localhost:3000/admin

• Go to /admin → Products → Bulk Import (CSV)
• Required columns: SKU, Name, Price, Category
• Optional columns: Stock, Brand, Description, MainImage, Slug, SalePrice, InStock, Featured, OnSale, IsActive, LongDescription, Images, CategoryDescription, CategoryImage
• Header parsing: Column names are case- and punctuation-insensitive — SKU, sku, S K U all match. Product_ID is accepted as a column and ignored.
• Category: Provide a display name (e.g. Sticky Notes) or a slug. We slugify it automatically. If the slug doesn't exist yet, the category is auto-created on confirm using the display name.
• Image auto-search: MainImage is optional. If omitted, an image is auto-picked from a DuckDuckGo search using the row's Description if present, otherwise the Name (truncated to ~120 characters). You can swap any image in the review step before confirming.
• Description fallback: If Description is empty, the product's stored description defaults to the Name.
• Two-phase flow: Upload CSV → review every staged row (edit fields, swap image, deselect) → click Confirm import to write to the DB. Nothing is created until you confirm.
• For Images, use pipe-separated URLs (url1|url2) or a JSON array string.
• Limit: 100 rows per upload.

• Open USER_MANUAL.md in your editor and export/print to PDF, or
• Convert via your preferred Markdown-to-PDF tool.

Store name: Edit NEXT_PUBLIC_STORE_NAME in .env.local

Colors: Edit tailwind.config.ts

Products: Use the Admin dashboard (or edit scripts/seed-database.ts then run npm run db:seed for sample data resets).

1. Push to GitHub
2. Deploy to an EC2 instance
3. Configure your domain (e.g. via GoDaddy)
4. Set up nginx with SSL
5. Add environment variables and start the app

Database issues:

• Ensure data/ directory exists and is writable
• Run npm run db:seed to create and populate the database
• Delete data/printers.db and reseed if the schema is corrupted

MIT License

Built with Next.js, TypeScript, and Tailwind CSS