Data pipeline
Everything downstream is built from your uploaded order sheet. This page shows each processing stage and lets you inspect the parsed records.
Orders
400
rows in the source sheet
Product lines
769
after parsing
Products
19
after normalisation
Recorded revenue
₹3,86,655
sum of order totals
Processing stages
- 01Ingest
Uploaded order sheet — 400 rows, 3 columns.
- 02Parse
Split free-text order details into product, pack size and quantity.
- 03Normalise
Map spelling variants to 19 canonical products; derive unit price.
- 04Enrich
Attach synthetic cost, stock, spoilage and price sensitivity.
- 05Features
Build margin, demand, sell-through, waste and volatility signals.
- 06Serve
Feed the optimiser, the explainers and the vector knowledge base.
Daily recorded revenue
Derived from order timestamps in the sheet.
Product roll-up
| Product | Lines | Units | Avg price | Revenue |
|---|---|---|---|---|
| (Kaju) Cashew Nuts (W-210) | 120 | 153 | ₹921 | ₹1,30,225 |
| Muscat green Grapes (Imported) | 45 | 63 | ₹745 | ₹47,055 |
| Imported Pears (Imported) | 67 | 93 | ₹330 | ₹30,790 |
| Imported Apples (Queen) (Imported) | 70 | 102 | ₹282 | ₹28,650 |
| Imported Apples (Imported) | 60 | 88 | ₹326 | ₹28,635 |
| Dry fruits Chocolate(Energy bar) (Salima) | 42 | 87 | ₹203 | ₹17,710 |
| Red & Dark Purple Plums (Kashmiri) | 38 | 56 | ₹254 | ₹14,195 |
| Imported Blueberries (Canadian) | 40 | 60 | ₹222 | ₹13,300 |
| Imported Orange (Mandarin) | 44 | 65 | ₹202 | ₹13,070 |
| Red king Pomegrante(Anaar) (Kashmiri) | 39 | 86 | ₹134 | ₹11,525 |
| Avacado (Canadian) | 48 | 70 | ₹162 | ₹11,375 |
| Rambutan Litchi (Muzaffarpur) | 20 | 30 | ₹329 | ₹9,860 |
| Peru (Guava) (Indian) | 47 | 95 | ₹96 | ₹9,135 |
| Kashmiri Cherry (Kashmiri dark red) | 14 | 14 | ₹492 | ₹6,885 |
| Dragon Fruit (Vietnam) | 37 | 66 | ₹70 | ₹4,660 |
| Langda Mango (Gujarati) | 21 | 28 | ₹157 | ₹4,385 |
| Chausa Mango (Uttar Pradesh) | 12 | 18 | ₹223 | ₹4,000 |
| Dussheri Mango (Malyabadi) | 3 | 3 | ₹200 | ₹600 |
| Shahi Litchi (Muzaffarpur) | 2 | 2 | ₹300 | ₹600 |
Parsed lines
Search the cleaned records that came out of the parser.
| Order | Product | Pack | Qty | Unit |
|---|---|---|---|---|
| EG-20260702-160140 | Dussheri Mango (Malyabadi) | Kg | 1 | ₹150 |
| EG-20260702-160140 | Shahi Litchi (Muzaffarpur) | kg | 1 | ₹300 |
| EG-20260702-160140 | Langda Mango (Gujarati) | KG | 2 | ₹120 |
| EG-20260702-160140 | Avacado (Canadian) | 3 piece around 250 gms | 1 | ₹160 |
| EG-20260702-170513 | Dussheri Mango (Malyabadi) | Kg | 1 | ₹150 |
| EG-20260702-170513 | Avacado (Canadian) | 3 piece around 250 gms | 1 | ₹160 |
| EG-20260702-170513 | Kashmiri Cherry (Kashmiri dark red) | 1 box around 1 kg | 1 | ₹490 |
| EG-20260702-170513 | Imported Blueberries (Canadian) | 1 pack around 150 gms | 1 | ₹200 |
| EG-20260702-170513 | Shahi Litchi (Muzaffarpur) | kg | 1 | ₹300 |
| EG-20260705-091422 | Dussheri Mango (Malyabadi) | Kg | 1 | ₹300 |
| EG-20260705-091422 | Rambutan Litchi (Muzaffarpur) | 500 gm | 1 | ₹325 |
| EG-20260705-091422 | Kashmiri Cherry (Kashmiri dark red) | 1 box around 1 kg | 1 | ₹490 |
| EG-20260705-091422 | Avacado (Canadian) | 3 piece around 250 gms | 1 | ₹160 |
| EG-20260705-091422 | Imported Blueberries (Canadian) | 1 pack around 150 gms | 1 | ₹200 |
| EG-20260705-091422 | Imported Orange (Mandarin) | 1 Kg around 5 pieces | 1 | ₹200 |
| EG-20260705-091422 | Imported Apples (Imported) | 1 kg | 1 | ₹325 |
| EG-20260709-112437 | Imported Pears (Imported) | 1 kg | 1 | ₹330 |
| EG-20260709-142702 | (Kaju) Cashew Nuts (W-210) | kg | 1 | ₹1,230 |
| EG-20260709-180654 | Imported Pears (Imported) | 1 kg | 1 | ₹330 |
| EG-20260709-180654 | (Kaju) Cashew Nuts (W-210) | kg | 1 | ₹1,230 |
| EG-20260709-233458 | Muscat green Grapes (Imported) | 1 kg | 1 | ₹750 |
| EG-20260709-233458 | Langda Mango (Gujarati) | KG | 1 | ₹125 |
| EG-20260710-052627 | Red & Dark Purple Plums (Kashmiri) | 1 kg | 1 | ₹260 |
| EG-20260710-190436 | Red king Pomegrante(Anaar) (Kashmiri) | 500 gms | 1 | ₹135 |
| EG-20260710-190436 | Imported Blueberries (Canadian) | 1 pack around 150 gms | 1 | ₹200 |
| EG-20260710-190436 | (Kaju) Cashew Nuts (W-210) | 500 gms | 1 | ₹600 |
| EG-20260716-142738 | Dry fruits Chocolate(Energy bar) (Salima) | 200 gms | 1 | ₹200 |
| EG-20260724-033041 | Langda Mango (Gujarati) | 1 Kg | 1 | ₹135 |
| EG-20260724-033041 | Peru (Guava) (Indian) | 1 Kg | 1 | ₹80 |
| EG-20260724-033041 | Imported Apples (Queen) (Imported) | 1 Kg | 1 | ₹280 |
| EG-20260724-041920 | Imported Apples (Queen) (Imported) | 1 Kg | 1 | ₹280 |
| EG-20260724-041920 | Chausa Mango (Uttar Pradesh) | 1 Kg | 1 | ₹220 |
| EG-20260724-041920 | Langda Mango (Gujarati) | 1 Kg | 1 | ₹135 |
| EG-20260724-145056 | Dragon Fruit (Vietnam) | 1 Piece | 2 | ₹70 |
| EG-20260724-145056 | Imported Blueberries (Canadian) | 1 Pack (140 gms) | 1 | ₹225 |
| EG-20260724-145056 | Red & Dark Purple Plums (Kashmiri) | 1 Kg | 1 | ₹250 |
| EG-20260725-105844 | Peru (Guava) (Indian) | 1 Kg | 1 | ₹80 |
| EG-20260731-133920 | Red & Dark Purple Plums (Kashmiri) | 1 Kg | 1 | ₹250 |
| EG-20260806-064149 | Peru (Guava) (Indian) | 1 Kg | 2 | ₹95 |
| EG-20260806-064149 | Langda Mango (Gujarati) | 1 Kg | 1 | ₹165 |
| EG-20260806-165105 | Rambutan Litchi (Muzaffarpur) | 500 gm | 2 | ₹340 |
| EG-20260806-170123 | Imported Orange (Mandarin) | 1 Kg around 5 pieces | 2 | ₹190 |
| EG-20260807-080640 | Muscat green Grapes (Imported) | 1 kg | 2 | ₹750 |
| EG-20260807-080640 | Red king Pomegrante(Anaar) (Kashmiri) | 500 gms | 3 | ₹135 |
| EG-20260807-080640 | Peru (Guava) (Indian) | 1 Kg | 3 | ₹95 |
| EG-20260808-192326 | Kashmiri Cherry (Kashmiri dark red) | 1 box around 1 kg | 1 | ₹440 |
| EG-20260808-192326 | Imported Apples (Imported) | 1 kg | 1 | ₹340 |
| EG-20260809-020138 | Imported Pears (Imported) | 1 kg | 2 | ₹330 |
| EG-20260809-020138 | Langda Mango (Gujarati) | 1 Kg | 1 | ₹165 |
| EG-20260810-165644 | Dry fruits Chocolate(Energy bar) (Salima) | 200 gms | 1 | ₹200 |
| EG-20260810-165644 | Muscat green Grapes (Imported) | 1 kg | 1 | ₹710 |
| EG-20260810-165644 | Rambutan Litchi (Muzaffarpur) | 500 gm | 2 | ₹310 |
| EG-20260810-165644 | Imported Orange (Mandarin) | 1 Kg around 5 pieces | 2 | ₹200 |
| EG-20260811-111057 | Muscat green Grapes (Imported) | 1 kg | 1 | ₹790 |
| EG-20260813-164720 | Muscat green Grapes (Imported) | 1 kg | 2 | ₹710 |
| EG-20260813-164720 | Imported Apples (Queen) (Imported) | 1 Kg | 1 | ₹250 |
| EG-20260813-203834 | Dragon Fruit (Vietnam) | 1 Piece | 1 | ₹65 |
| EG-20260813-203834 | Red king Pomegrante(Anaar) (Kashmiri) | 500 gms | 2 | ₹135 |
| EG-20260814-054848 | Imported Apples (Queen) (Imported) | 1 Kg | 1 | ₹280 |
| EG-20260814-181143 | Avacado (Canadian) | 3 piece around 250 gms | 1 | ₹150 |