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

  1. 01
    Ingest

    Uploaded order sheet — 400 rows, 3 columns.

  2. 02
    Parse

    Split free-text order details into product, pack size and quantity.

  3. 03
    Normalise

    Map spelling variants to 19 canonical products; derive unit price.

  4. 04
    Enrich

    Attach synthetic cost, stock, spoilage and price sensitivity.

  5. 05
    Features

    Build margin, demand, sell-through, waste and volatility signals.

  6. 06
    Serve

    Feed the optimiser, the explainers and the vector knowledge base.

Daily recorded revenue

Derived from order timestamps in the sheet.

Product roll-up

ProductLinesUnitsAvg priceRevenue
(Kaju) Cashew Nuts (W-210)120153₹921₹1,30,225
Muscat green Grapes (Imported)4563₹745₹47,055
Imported Pears (Imported)6793₹330₹30,790
Imported Apples (Queen) (Imported)70102₹282₹28,650
Imported Apples (Imported)6088₹326₹28,635
Dry fruits Chocolate(Energy bar) (Salima)4287₹203₹17,710
Red & Dark Purple Plums (Kashmiri)3856₹254₹14,195
Imported Blueberries (Canadian)4060₹222₹13,300
Imported Orange (Mandarin)4465₹202₹13,070
Red king Pomegrante(Anaar) (Kashmiri)3986₹134₹11,525
Avacado (Canadian)4870₹162₹11,375
Rambutan Litchi (Muzaffarpur)2030₹329₹9,860
Peru (Guava) (Indian)4795₹96₹9,135
Kashmiri Cherry (Kashmiri dark red)1414₹492₹6,885
Dragon Fruit (Vietnam)3766₹70₹4,660
Langda Mango (Gujarati)2128₹157₹4,385
Chausa Mango (Uttar Pradesh)1218₹223₹4,000
Dussheri Mango (Malyabadi)33₹200₹600
Shahi Litchi (Muzaffarpur)22₹300₹600

Parsed lines

Search the cleaned records that came out of the parser.

OrderProductPackQtyUnit
EG-20260702-160140Dussheri Mango (Malyabadi)Kg1₹150
EG-20260702-160140Shahi Litchi (Muzaffarpur)kg1₹300
EG-20260702-160140Langda Mango (Gujarati)KG2₹120
EG-20260702-160140Avacado (Canadian)3 piece around 250 gms1₹160
EG-20260702-170513Dussheri Mango (Malyabadi)Kg1₹150
EG-20260702-170513Avacado (Canadian)3 piece around 250 gms1₹160
EG-20260702-170513Kashmiri Cherry (Kashmiri dark red)1 box around 1 kg1₹490
EG-20260702-170513Imported Blueberries (Canadian)1 pack around 150 gms1₹200
EG-20260702-170513Shahi Litchi (Muzaffarpur)kg1₹300
EG-20260705-091422Dussheri Mango (Malyabadi)Kg1₹300
EG-20260705-091422Rambutan Litchi (Muzaffarpur)500 gm1₹325
EG-20260705-091422Kashmiri Cherry (Kashmiri dark red)1 box around 1 kg1₹490
EG-20260705-091422Avacado (Canadian)3 piece around 250 gms1₹160
EG-20260705-091422Imported Blueberries (Canadian)1 pack around 150 gms1₹200
EG-20260705-091422Imported Orange (Mandarin)1 Kg around 5 pieces1₹200
EG-20260705-091422Imported Apples (Imported)1 kg1₹325
EG-20260709-112437Imported Pears (Imported)1 kg1₹330
EG-20260709-142702(Kaju) Cashew Nuts (W-210)kg1₹1,230
EG-20260709-180654Imported Pears (Imported)1 kg1₹330
EG-20260709-180654(Kaju) Cashew Nuts (W-210)kg1₹1,230
EG-20260709-233458Muscat green Grapes (Imported)1 kg1₹750
EG-20260709-233458Langda Mango (Gujarati)KG1₹125
EG-20260710-052627Red & Dark Purple Plums (Kashmiri)1 kg1₹260
EG-20260710-190436Red king Pomegrante(Anaar) (Kashmiri)500 gms1₹135
EG-20260710-190436Imported Blueberries (Canadian)1 pack around 150 gms1₹200
EG-20260710-190436(Kaju) Cashew Nuts (W-210)500 gms1₹600
EG-20260716-142738Dry fruits Chocolate(Energy bar) (Salima)200 gms1₹200
EG-20260724-033041Langda Mango (Gujarati)1 Kg1₹135
EG-20260724-033041Peru (Guava) (Indian)1 Kg1₹80
EG-20260724-033041Imported Apples (Queen) (Imported)1 Kg1₹280
EG-20260724-041920Imported Apples (Queen) (Imported)1 Kg1₹280
EG-20260724-041920Chausa Mango (Uttar Pradesh)1 Kg1₹220
EG-20260724-041920Langda Mango (Gujarati)1 Kg1₹135
EG-20260724-145056Dragon Fruit (Vietnam)1 Piece2₹70
EG-20260724-145056Imported Blueberries (Canadian)1 Pack (140 gms)1₹225
EG-20260724-145056Red & Dark Purple Plums (Kashmiri)1 Kg1₹250
EG-20260725-105844Peru (Guava) (Indian)1 Kg1₹80
EG-20260731-133920Red & Dark Purple Plums (Kashmiri)1 Kg1₹250
EG-20260806-064149Peru (Guava) (Indian)1 Kg2₹95
EG-20260806-064149Langda Mango (Gujarati)1 Kg1₹165
EG-20260806-165105Rambutan Litchi (Muzaffarpur)500 gm2₹340
EG-20260806-170123Imported Orange (Mandarin)1 Kg around 5 pieces2₹190
EG-20260807-080640Muscat green Grapes (Imported)1 kg2₹750
EG-20260807-080640Red king Pomegrante(Anaar) (Kashmiri)500 gms3₹135
EG-20260807-080640Peru (Guava) (Indian)1 Kg3₹95
EG-20260808-192326Kashmiri Cherry (Kashmiri dark red)1 box around 1 kg1₹440
EG-20260808-192326Imported Apples (Imported)1 kg1₹340
EG-20260809-020138Imported Pears (Imported)1 kg2₹330
EG-20260809-020138Langda Mango (Gujarati)1 Kg1₹165
EG-20260810-165644Dry fruits Chocolate(Energy bar) (Salima)200 gms1₹200
EG-20260810-165644Muscat green Grapes (Imported)1 kg1₹710
EG-20260810-165644Rambutan Litchi (Muzaffarpur)500 gm2₹310
EG-20260810-165644Imported Orange (Mandarin)1 Kg around 5 pieces2₹200
EG-20260811-111057Muscat green Grapes (Imported)1 kg1₹790
EG-20260813-164720Muscat green Grapes (Imported)1 kg2₹710
EG-20260813-164720Imported Apples (Queen) (Imported)1 Kg1₹250
EG-20260813-203834Dragon Fruit (Vietnam)1 Piece1₹65
EG-20260813-203834Red king Pomegrante(Anaar) (Kashmiri)500 gms2₹135
EG-20260814-054848Imported Apples (Queen) (Imported)1 Kg1₹280
EG-20260814-181143Avacado (Canadian)3 piece around 250 gms1₹150