| Username | Role | Status | Created | Action |
|---|
Manage shop URLs. Upload via Excel/CSV or Load Sheets. URLs are automatically categorized by product type and grouped by company.
Upload Excel or CSV with column: 'Company Online Shop URLs' (or 'url', 'website_url'). URLs are automatically categorized as Coffee, Tea, or Instant Coffee based on URL content.
| Company Name | Coffee URLs | Tea URLs | Instant Coffee URLs | Last Scraped | Action |
|---|
| Notifications | Reports | Action |
|---|
Add brand names to flag products as branded. Updates apply across products, reports, and price tracking.
| Brand | Created | Action |
|---|
Manage sector cost multipliers and assign seller types for cost price calculation.
| Sector | B2B/B2C | Margin % | Cost Multiplier | Action |
|---|
| Seller | Type | Sector | Multiplier | Action |
|---|
Manage multiple API keys for SerpAPI and OpenAI. Keys are encrypted in the database. Only one key can be active per service.
| Name | Key (Masked) | Status | Usage Count | Last Validated | Actions |
|---|
| Name | Key (Masked) | Status | Usage Count | Last Validated | Actions |
|---|
Upload Excel or CSV with columns: url, product_name, source_platform, category (optional), notes (optional), enabled (optional)
Valid sources: Amazon, GoogleShopping, Direct
| URL | Product | Source | Status | Last Price (€) | Action |
|---|
Status
Running
Last Run
Never
Next Run
Not scheduled
Jobs Active
0
Scheduler State
Loading...
Run Day
1st
Run Time
02:00
Cost Estimate
£--.--
Monthly: ~€2-5/run | Weekly: ~€14-35/month | Daily: ~€60-150/month
2:00 AM UTC = 10 PM EST, 3 AM GMT, 9 AM IST
New Only = 20-30% API cost reduction
Monthly reports are automatically generated on the 2nd of each month. Download previous reports here.
Prices automatically recorded on each discovery run (1st of month). Google Sheets tab: "Price History" shows monthly trends.
| Month | Products Tracked | Avg Price Change | Highest Change |
|---|---|---|---|
| Loading... | -- | -- | -- |
| Date | Type | Status | Products Found | API Cost |
|---|---|---|---|---|
| Loading... | -- | -- | -- | -- |