Inventory & Bulk Management
Complete product catalog CRUD operations, live SQLite storage, and two-stage bulk CSV verification.
Total Products
--
Categories
--
Brands
--
Flash Deals
--
Price Range
--
Showing 0 items
0 product(s) selected
| ID | Image | Product Details | Category & Brand | Pricing & Offer | Tags / Badges | Stock Status | Actions | |
|---|---|---|---|---|---|---|---|---|
|
Loading products from SQLite database...
|
||||||||
Step 1: Upload Products CSV
Drag and drop your prepared CSV file or click to browse. Existing IDs will update; new IDs or blank IDs will create new products.
Drop your CSV file here, or click to browse
Supports all standard fields: name, brand, category, price, original_price, offer_tag, specs, sizes, description, image.
CSV Formatting & Media Guidelines
- image (Recommended): Put the relative path (e.g.
images/products/axor-apex.jpg), a filename inside the products folder, or a full public URL (e.g.https://...). Copy image files directly intospares-n-gears-multipage/images/products/on your computer or server. Defaults to placeholder if left blank. - id (Optional): If provided and matches an existing product, it will be updated. If omitted, a new unique ID is auto-assigned.
- specs (Optional): Separate multiple bullet points with semicolons (
;) e.g.,ECE 22.06 Certified; Quick release buckle; Anti-fog visor. - sizes (Optional): Comma-separated sizes e.g.,
S, M, L, XL, XXL. - pricing:
priceis required and must be a positive number.original_pricetriggers discount badge calculations.
Step 2: Verify CSV Data Before Commit
Review validated rows below. Any errors are highlighted in red. Click "Commit Upload" to write to SQLite.
Total Rows: 0
Valid to Import: 0
Invalid / Errors: 0
New Products: 0
Updates to Existing: 0
| Row | ID | Action | Title & Brand | Category | Price & Offer | Sizes & Specs | Validation Status |
|---|
Order Dispatch Email Routing
Customer orders and checkout alerts are dispatched to this mailbox.
Brevo Email Service
smtp-relay.brevo.com:587 • Verified
1. Customer Checkout (Front-end)
When riders place orders on
checkout.html, the order is registered into the database and an instant order confirmation is returned to the user.
2. Instant Brevo Dispatch Slip
The backend instantly formats a responsive HTML invoice with full customer details, phone, shipping address, and product breakdown, dispatched via Brevo API.
3. Configurable in .env & SQLite
Credentials are securely managed in
.env (Brevo API key & relay), and the target email is updated dynamically from this dashboard.
Checkout Payment Methods
Enable or disable payment modes on checkout. Disabled methods remain visible to customers but greyed out with an "Unavailable" badge.
Total Orders Placed
0
Pending / Confirmed
0
Shipped / In Transit
0
Delivered Orders
0
Total Realized Revenue
₹0
| Order # | Date & Time | Customer & Contact | Items Ordered | Total | Payment | Order Status | Actions |
|---|---|---|---|---|---|---|---|
| Loading store orders... | |||||||
Total Leads Received
0
New / Uncontacted
0
Contacted
0
In Progress / Processing
0
Closed / Approved
0
Showing 0 leads
| ID | Date & Time | Applicant Details | Service Requested | Amount | Location | Notes / Message | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading loan & insurance inquiries... | ||||||||
Registered Riders
0
Active Profiles
0
Total Customer Orders
0
Registered Rider Community
| ID | Rider Name | Phone | Registered | Last Login | Orders | Total Spend | |
|---|---|---|---|---|---|---|---|
| Loading rider community roster... | |||||||
Rider Authentication & Activity Audit Trail
Recorded by Server
| Timestamp | Rider Email | Action | Details | IP Address |
|---|---|---|---|---|
| Loading activity logs... | ||||