Home / Sales & Distribution / Stockist Intake
Stockist File Intake
Secondary sales & returns fed from stockist files
⤴
Drag & drop stockist sales file
.xlsx, .csv · chemist · SKU · batch no. · qty · value · date — or browse
⤵
Files this month
38
across 4 stockists
▤
Rows ingested
24,120
secondary lines
⚠
Validation errors
312
need fixing
✓
Auto-mapped chemists
91%
to master
By default stockists send sales files to HQ for feeding here. The optional stockist portal lets a stockist upload directly — both run the same validation, dedupe and chemist-mapping checks.
| File | Stockist | Rows | Status | Uploaded by | When |
|---|---|---|---|---|---|
| sai_jun_secondary.xlsx | Sai Distributors | 4,210 | Processed | Tapas A. | 18 Jun, 09:14 |
| krishna_w24.csv | Krishna Agencies | 3,860 | Processed | Tapas A. | 17 Jun, 18:42 |
| metro_secondary_jun.xlsx | Metro Pharma Dist | 5,104 | Validating | R. Nair | 17 Jun, 12:08 |
| sharma_returns_jun.csv | Sharma Medical | 980 | Errors | Portal · Sharma | 16 Jun, 20:31 |
| sai_jun_w23.xlsx | Sai Distributors | 4,002 | Processed | Tapas A. | 15 Jun, 10:22 |
| metro_w23.csv | Metro Pharma Dist | 3,744 | Processed | R. Nair | 14 Jun, 16:50 |
| krishna_returns.xlsx | Krishna Agencies | 620 | Errors | Portal · Krishna | 13 Jun, 09:05 |
Rows for chemists not in the master are held here — map the chemist or they fall to natural sales.
| Row | Issue | Detail | Action |
|---|---|---|---|
| #1042 | Unknown chemist | "APOLLO PHCY SOUTH EXT" not in master · Azithro 500 · qty 60 | |
| #1088 | Duplicate line | Same batch B-2291 · Pantop-D · already in sai_jun_w23.xlsx | |
| #1130 | Bad date | Date "31/06/2026" invalid — June has 30 days | |
| #1175 | Negative qty | Montek-LC · qty -12 · no matching return ref | |
| #1203 | Unknown chemist | "WELNES FOREVR HSR" fuzzy match below threshold | |
| #1247 | Bad date | Empty invoice date · Azithro 500 · qty 24 |
| Raw name | Suggested master chemist | Confidence | Action |
|---|---|---|---|
| APOLLO PHCY SOUTH EXT | Apollo Pharmacy | ||
| MEDPLUS - INDRPRSTHA | MedPlus | ||
| WELNES FOREVR HSR | Wellness Forever | ||
| LIFE CARE CHEM. | LifeCare Chemist | ||
| APOLO PHARMACY NR2 | Apollo Pharmacy | ||
| MED PLUS CTY CTR | MedPlus |