Store Setup Guide
◆
The store needs a MySQL database. Follow these steps once, then everything (products, orders, admin panel) works.
1. Configure MySQL credentials
Edit .env.local and point DB_HOST, DB_USER, DB_PASSWORD, DB_NAME at your MySQL server (local or hosting cPanel).
2. Create the database and app user
Run once. Creates the `tayyab_shawls` database, applies the schema, and creates the `tayyab_user` app account.
npm run setup-db -- --user root --password YOUR_MYSQL_ROOT_PASSWORD
3. Seed products, categories and demo data
Imports all 131 products from the CSV, assigns local images, creates the full category hierarchy, banners, coupons, admin and demo orders.
npm run seed
4. Start the store
Then open http://localhost:3000
npm run dev