Admin Notes
管理员笔记
Site Statistics 站点统计
| Category 类别 | Count 数量 |
|---|---|
| Countries 国家 | 13 |
| Region Detail Pages 产区详情页 | 28 |
| Wine Detail Pages 酒款详情页 | 21 |
| Producer Pages 酒庄页面 | 21 |
| Grape Varieties 葡萄品种 | 15 |
| Wine Styles 葡萄酒风格 | 10 |
| Total Navigable Pages 总可导航页面 | 112 |
CSV Import Template 批量导入模板
For future bulk import of wines, use the following CSV column structure:
未来批量导入葡萄酒时，请使用以下CSV列结构：
Wine CSV Columns 酒款CSV列
slug, name, nameCn, producer, producerCn, producerSlug, country, countryCn, countrySlug, region, regionCn, regionSlug, grapes (pipe-separated), grapesCn (pipe-separated), style, styleCn, vintage, abv, tastingNotes, tastingNotesCn, serving, servingCn, pairing (pipe-separated), pairingCn (pipe-separated), priceRange, priceRangeCn, summary, summaryCn
Producer CSV Columns 酒庄CSV列
slug, name, nameCn, country, countryCn, countrySlug, region, regionCn, regionSlug, founded, signatureWines (pipe-separated), signatureWinesCn (pipe-separated), style, styleCn, summary, summaryCn
Region CSV Columns 产区CSV列
slug, name, nameCn, country, countryCn, countrySlug, climate, climateCn, mainGrapes (pipe-separated), mainGrapesCn (pipe-separated), subregions (pipe-separated), subregionsCn (pipe-separated), styles (pipe-separated), stylesCn (pipe-separated), intro, introCn, producers (pipe-separated)
Post-ProWein Upgrade Plan 展后升级计划
- Backend + Database: Migrate from static data to PostgreSQL with full CRUD API. 从静态数据迁移到PostgreSQL，配备完整CRUD API。
- Bulk Import Tool: CSV/Excel upload for wines, producers, and regions. CSV/Excel批量上传酒款、酒庄和产区。
- User Authentication: Admin panel for content management. 管理员面板用于内容管理。
- Advanced Search: Faceted search with filters (price, region, grape, style). 多维搜索，支持价格、产区、品种、风格筛选。
- Wine Ratings: User ratings and reviews system. 用户评分和评论系统。
- E-commerce Integration: Direct pre-order checkout with payment processing. 直接预定结账和支付处理。
- Multi-language: Add French, German, Italian, Spanish, Japanese, Korean. 添加法语、德语、意大利语、西班牙语、日语、韩语。
- Analytics Dashboard: Track page views, search queries, and pre-order conversions. 跟踪页面浏览、搜索查询和预定转化。
- API Access: Public API for partners and third-party integrations. 面向合作伙伴和第三方集成的公开API。
Technical Notes 技术说明
- Stack: React 19 + Vite + TailwindCSS 4 + Wouter (routing)
- All data is static (client-side) — no backend required for demo
- Bilingual content on every page (EN + 中文)
- SEO: Unique title/description per page, sitemap.xml, robots.txt
- FAQ Schema on /preorder, /sell-to-china, /pricing
- Wikipedia-style infoboxes on detail pages
- Wine comparison feature at /compare
- Mobile-responsive design with sticky header