standkartcom

byAnanya Manocha

## PROMPT START Build a responsive e-commerce website for my company, **Standkart.com**, a manufacturer and supplier of household products for Government and Private sectors. ### 1. Brand Identity - **Company name:** Standkart.com - **Logo/monogram:** Use a clean "Standkart" wordmark/logo - **Tagline:** "Smart Solutions. Stronger Everyday." and "100% Genuine Products. First use our product, then believe..." - **Sub-tagline:** "Best quality product at reasonable price" - **Color palette:** Black, gold/amber gradient, white, with a deep teal accent (as used on product banners) - **Contact details** (footer + contact page): - Phone: 6263210089 - Email: mateshwarikitchenwaremkw@gmail.com - Address: DH-26 Ayodhya Extension, near Shubh Hospital, Opposite Sheetal Paradise Apartment, Bhopal 462041, MP, India - GSTIN: 23DOUPM9871J1ZZ - Include a "Scan QR to visit Standkart.com" QR code block in the footer - **Tone:** Trustworthy, practical, value-for-money household brand serving both retail customers and bulk/corporate/government buyers. ### 2. Product Catalog Structure Build a catalog with the following categories (each as its own section/page with a product grid, image, name, and price). Use the pricing tiers below — **display the "Retail Price" as the customer-facing buying price** on the storefront. (Dealer/Corporate pricing tiers should be hidden from public view and only shown after a "Dealer/Bulk Login" or a "Request Bulk Quote" form is submitted.) **Categories:** 1. **Cloth Drying Stands** (Sumo M.S., Sumo S.S., Full Band Steel — standard, double-layer, triple-layer variants; 4–8 ft sizes) 2. **Wheel Cloth Stands** (multiple SKUs, standard sizes) 3. **Wall Mounted / Ceiling Cloth Drying Stands** (Wall Hanging, Ceiling One-Rope, Ceiling Multi-Rope — 3 to 10 ft, 5–6 pipe options) 4. **Multi-Purpose Wheel Racks / Cover Racks** (3-shelf to 6-shelf variants) 5. **MS / Aluminium Step Ladders** — sub-brands: - Regular (4–8 step) - Super Plus (4–9 step) - Classy (3–7 step) - Hercules (3–6 step) 6. **Iron Tables** (Standard 18/48, Heavy 18/48) 7. **Wall Mounted Shoe Racks / Book Shelves** (20/26/30 inch, 2–5 shelf, double/triple decker, with/without drawer variants; also standalone Book Shelf units) 8. **Fridge Stands / Washing Machine Trolleys** (Small/Medium/Large fridge stands, Standard & Premium washing machine trolleys) Each product card should show: product photo, name, SKU/ID, size/description, price, and an "Add to Cart" button. Product detail pages should show all specs plus a quantity selector (note master carton packing quantities where relevant, e.g. "Sold in packs of 6"). > I will supply the full product list (name, SKU, size, price, image) as a CSV/Excel import — structure the product database/CMS so I can bulk-upload and update this data easily rather than hardcoding every item. ### 3. Core E-Commerce Features - Home page with hero banner (ladder/step-up safety messaging, "Built for Everyday Use" badge style), category tiles, and a "Why Choose Us" section (Premium Quality, Safe & Reliable Design, Space Saving, Tested Strength & Durability, Perfect for Home & Office). - Product listing pages with category/sub-category filters and search. - Product detail pages with image gallery, description, specs table, and related products. - Shopping cart and checkout flow (guest checkout allowed; no mandatory account creation). - Checkout form fields: Full Name, Phone Number, Email, Delivery Address, City, Pincode, Quantity per item, Payment Method (COD / Online Payment placeholder), Order Notes. - Order confirmation page + confirmation email/SMS trigger (placeholder integration). - A simple "Bulk / Dealer Enquiry" form separate from retail checkout, for corporate and government buyers. - Mobile-responsive design, WhatsApp "Chat with us" floating button linked to the phone number above. ### 4. Automatic Order Sync to Excel Every time a customer completes checkout, the order must be **automatically written as a new row into an Excel spreadsheet** — no manual export step. Implement this using one of the following approaches (pick the best fit for the stack you're building): - **Backend + Excel file (self-hosted):** On order submission, use a server-side library (e.g., Node.js `exceljs`, Python `openpyxl`) to append a row to a persistent `orders.xlsx` file stored on the server, with columns: Order ID, Date/Time, Customer Name, Phone, Email, Address, Product Name, SKU, Quantity, Unit Price, Total Price, Payment Method, Order Status. - **Cloud-synced (recommended for reliability):** Send order data via webhook to a Google Sheets Apps Script endpoint (or use the Google Sheets API) so each order appends a row to a live Google Sheet that I can open, share, or export as Excel anytime, from any device. - Ensure the sheet auto-generates column headers on first run and that concurrent orders don't overwrite each other (append-only, no row conflicts). - Add a simple admin view/page (password-protected) where I can see all incoming orders in a table, matching what's in the spreadsheet, as a backup way to check orders directly on the site. ### 5. Pages to Build - Home - Shop / All Products (with category filter sidebar) - Product Detail - Cart - Checkout - Order Confirmation - About Us (manufacturer/supplier story, "Manufacturer and Suppliers of household products for Gov./Pvt. Sectors") - Bulk/Dealer Enquiry - Contact Us (with map, address, phone, email, GSTIN) ### 6. Tech Preferences - Suggest the simplest reliable stack to achieve the Excel/Google Sheets auto-sync (e.g., Next.js or plain HTML/CSS/JS frontend + Node/Express backend, or a no-code option like a form connected to Google Sheets if I want zero hosting maintenance). - Keep it lightweight and easy for a non-developer to maintain/update products and prices later. ## PROMPT END