Order pipeline
Where every order currently sits
New
0Confirmed
0Shipped
0Delivered
0Cancelled
0Leads
Customers who filled the checkout form but didn't complete the order · admin-only
| When | Name / Phone | Address | Product | Cart | Actions |
|---|---|---|---|---|---|
Loading… | |||||
Orders
Click a row to view details or change status
| Order | Customer | Item | Total | Pay | Status |
|---|---|---|---|---|---|
Products
Every SKU on the storefront · admin-editable · Supabase
Bulk import from folder
Pick a folder that contains one subfolder per SKU. Each subfolder's images become that product's photos. Duplicates (existing slugs) get photos attached; metadata is left alone.
• New slug → creates a Draft product (unpublished, no price yet)
• Existing slug → attaches photos to that product without touching its price, description, or publish state
• Every upload records your admin email + timestamp against
uploaded_by for the audit trail
| Folder | Slug (edit) | Display name (edit) | Photos | Status |
|---|
Coupons
Flat ₹ discount codes for the checkout · admin-only · validated by apply_coupon() RPC
+ Create New Coupon
Next step
Highest-impact action right now, computed from open Action centre items
Data sources
What is live, seeded, or missing
Keyword intelligence
Master keyword database backed by seo_keywords + seo_keyword_rankings
Import from GSC once verified, or add manually. Fields: keyword, cluster, intent, volume range, difficulty, target URL, priority score, status, owner.
Page inventory
Every indexable URL + editable meta, backed by seo_pages + seo_page_metrics
The nightly crawler will populate this once
/api/seo/crawl ships.Content planner
Editorial pipeline backed by seo_content_tasks
Statuses: Idea → Researching → Brief ready → Writing → Expert review → Compliance review → Editing → Scheduled → Published → Refresh required.
Technical SEO health
Open issues from crawler + GSC Enhancements, backed by seo_issues
Categories tracked: indexation, broken links, redirect chains, canonicals, duplicate titles/descriptions, missing H1, orphans, schema, sitemap, robots, slow pages, CWV, images, crawl depth, OOS pages.
Structured-data manager
Validation results per schema × template, backed by seo_schema_results
Ship
/api/seo/schema-validate to start rolling validation of Product, FAQPage, Article, Breadcrumb, Organization, Person, VideoObject.Internal-link manager
Suggested + implemented internal links, backed by seo_internal_links
GEO / AEO visibility
Manual AI-citation monitoring across ChatGPT, Perplexity, Google AI Overviews, Gemini, Bing Copilot, Claude — backed by geo_queries + geo_observations
Add canonical prompts under
geo_queries, then log an observation per platform (cited? which URL? competitors? accuracy 1–5? sentiment 1–5?). Scraping AI outputs is not compliant — this is manual only.AI-visibility score formula (editable in seo_settings.geo_score_formula): cited_pct × 60 + accuracy × 25 + sentiment × 15. Not an official metric from any search engine.
Competitor tracking
Backed by competitors + competitor_metrics
Track: camstarsports.com, preciholesports.com, gunsandshooting.in, marketplaces, forums, YouTube channels.
Backlink + mention monitoring
Backed by backlinks + brand_mentions
Sources: Bing WMT backlinks (free), Semrush / Ahrefs when subscribed, manual brand alerts.
Action centre
Prioritised queue backed by seo_action_items
Reporting
Exportable weekly/monthly SEO + GEO reports
/api/reports/weekly.pdf./api/reports/monthly.pdf.