fx_franchise_order_product

4,737 rows · 33 columns · page 47 / 95

Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
2301 2510 4 591 12548 37 Floor Cleaner 500ml NULL 3924101 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.77 9.0 72.77 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-01-05 20:53:19
2302 2511 5 591 12548 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.53 190.48 4000.0 INR 3 2.0 76.19 2026-01-05 20:53:19
2303 2512 6 591 12548 15 KIDNEY CARE JUICE NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 2657.14 132.86 2790.0 INR 3 2.0 53.14 2026-01-05 20:53:19
2304 2513 7 591 12548 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-05 20:53:19
2305 2514 8 591 12548 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-05 20:53:19
2306 2515 9 591 12548 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-01-05 20:53:19
2307 2516 10 591 12548 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-05 20:53:19
2308 2517 1 592 12547 33 Herbal Soap 100gm NULL 30049011 15 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-05 21:07:42
2309 2518 2 592 12547 15 KIDNEY CARE JUICE NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-05 21:07:42
2310 2519 3 592 12547 32 Neem Soap 100gm NULL 34011110 103 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6180.0 0.0 4944.0 2.5 117.72 2.5 117.72 0.0 0.0 4708.57 235.43 4944.0 INR 3 2.0 94.17 2026-01-05 21:07:42
2311 2520 4 592 12547 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.59 2.5 47.59 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-05 21:07:42
2312 2521 1 593 12543 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-01-05 22:33:36
2313 2522 1 594 12549 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.91 2.5 61.91 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-06 12:03:33
2314 2523 2 594 12549 34 Herbo2o Toothpaste NULL 33061090 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-01-06 12:03:33
2315 2524 3 594 12549 7 Morning Fresh Churan NULL 30049011 3 0.0 199.0 0.0 0.0 159.0 151.43 7.57 597.0 0.0 477.0 2.5 11.36 2.5 11.36 0.0 0.0 454.29 22.71 477.0 INR 3 2.0 9.09 2026-01-06 12:03:33
2316 2525 4 594 12549 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-01-06 12:03:33
2317 2526 1 595 12552 33 Herbal Soap 100gm NULL 30049011 9 0.0 100.0 0.0 0.0 80.0 76.19 3.81 900.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-06 12:12:05
2318 2527 2 595 12552 9 Omega 369 NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-06 12:12:05
2319 2528 3 595 12552 12 P RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-06 12:12:05
2320 2529 4 595 12552 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.63 9.0 42.63 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-06 12:12:05
2321 2530 1 596 12549 19 Fat loss Juice 500 ml NULL 30049011 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-06 12:24:02
2322 2531 2 596 12549 33 Herbal Soap 100gm NULL 30049011 12 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1200.0 0.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 914.29 45.71 960.0 INR 3 2.0 18.29 2026-01-06 12:24:02
2323 2532 3 596 12549 15 KIDNEY CARE JUICE NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-06 12:24:02
2324 2533 4 596 12549 41 Premium Coco Body Lotion NULL 3304300 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-06 12:24:02
2325 2534 5 596 12549 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.63 9.0 42.63 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-06 12:24:02
2326 2535 1 597 12516 84 B AND B NULL 94041000 3 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 38997.0 0.0 31500.0 2.5 750.0 2.5 750.0 0.0 0.0 30000.0 1500.0 31500.0 INR 1 0.0 400.0 2026-01-06 15:43:54
2327 2536 1 598 12516 82 ALKALINE CAPSULE NULL 3402000 20 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 50000.0 0.0 40000.0 1.5 582.52 1.5 582.52 0.0 0.0 38834.95 1165.05 40000.0 INR 1 8.0 3106.8 2026-01-06 15:55:40
2328 2537 1 599 12517 82 ALKALINE CAPSULE NULL 3402000 10 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 25000.0 0.0 20000.0 0.0 0.0 0.0 0.0 3.0 582.52 19417.48 582.52 20000.0 INR 2 6.0 1165.05 2026-01-06 16:02:16
2329 2538 1 600 12517 84 B AND B NULL 94041000 3 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 38997.0 0.0 31500.0 0.0 0.0 0.0 0.0 5.0 1500.0 30000.0 1500.0 31500.0 INR 2 0.0 300.0 2026-01-06 18:01:56
2330 2539 1 601 13438 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 0.0 0.0 0.0 0.0 18.0 28.07 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-06 18:29:46
2331 2540 2 601 13438 39 Fabric Wash 1000ml NULL 3924101 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.0 963.0 0.0 0.0 0.0 0.0 18.0 146.9 816.1 146.9 963.0 INR 3 2.0 16.32 2026-01-06 18:29:46
2332 2541 3 601 13438 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 0.0 0.0 0.0 0.0 5.0 26.62 532.38 26.62 559.0 INR 3 2.0 10.65 2026-01-06 18:29:46
2333 2542 4 601 13438 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 0.0 0.0 0.0 0.0 5.0 95.19 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-06 18:29:46
2334 2543 1 602 12516 68 18000 bracelt NULL 94041000 10 0.0 23999.0 0.0 0.0 18000.0 17142.86 857.14 239990.0 0.0 180000.0 2.5 4285.71 2.5 4285.71 0.0 0.0 171428.57 8571.43 180000.0 INR 1 0.0 500.0 2026-01-06 19:56:40
2335 2544 2 602 12516 84 B AND B NULL 94041000 9 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 116991.0 0.0 94500.0 2.5 2250.0 2.5 2250.0 0.0 0.0 90000.0 4500.0 94500.0 INR 1 0.0 400.0 2026-01-06 19:56:40
2336 2545 1 603 12517 68 18000 bracelt NULL 94041000 5 0.0 23999.0 0.0 0.0 18000.0 17142.86 857.14 119995.0 0.0 90000.0 0.0 0.0 0.0 0.0 5.0 4285.71 85714.29 4285.71 90000.0 INR 2 0.0 400.0 2026-01-06 20:02:00
2337 2546 2 603 12517 84 B AND B NULL 94041000 7 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 90993.0 0.0 73500.0 0.0 0.0 0.0 0.0 5.0 3500.0 70000.0 3500.0 73500.0 INR 2 0.0 300.0 2026-01-06 20:02:00
2338 2547 1 604 12549 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-06 20:06:40
2339 2548 2 604 12549 32 Neem Soap 100gm NULL 34011110 3 0.0 60.0 0.0 0.0 48.0 45.71 2.29 180.0 0.0 144.0 2.5 3.43 2.5 3.43 0.0 0.0 137.14 6.86 144.0 INR 3 2.0 2.74 2026-01-06 20:06:40
2340 2549 3 604 12549 26 Spirulina Cap NULL 2009899 3 0.0 899.0 0.0 0.0 719.0 684.76 34.24 2697.0 0.0 2157.0 2.5 51.35 2.5 51.35 0.0 0.0 2054.29 102.71 2157.0 INR 3 2.0 41.09 2026-01-06 20:06:40
2341 2550 1 605 12555 37 Floor Cleaner 500ml NULL 3924101 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-06 21:06:59
2342 2551 1 606 12541 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-06 21:10:17
2343 2552 2 606 12541 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-06 21:10:17
2344 2553 3 606 12541 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-06 21:10:17
2345 2554 4 606 12541 34 Herbo2o Toothpaste NULL 33061090 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-06 21:10:17
2346 2555 5 606 12541 32 Neem Soap 100gm NULL 34011110 4 0.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 0.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 182.86 9.14 192.0 INR 3 2.0 3.66 2026-01-06 21:10:17
2347 2556 6 606 12541 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.59 2.5 47.59 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-06 21:10:17
2348 2557 1 607 12533 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 10:37:40
2349 2558 1 608 12545 68 18000 bracelt NULL 94041000 1 0.0 23999.0 0.0 0.0 18000.0 17142.86 857.14 23999.0 0.0 18000.0 2.5 428.57 2.5 428.57 0.0 0.0 17142.86 857.14 18000.0 INR 3 0.0 200.0 2026-01-07 11:12:01
2350 2559 2 608 12545 9 Omega 369 NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-07 11:12:01