fx_franchise_order_product

4,737 rows · 33 columns · page 93 / 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
4601 4812 5 1235 14902 37 Floor Cleaner 500ml NULL 3924101 10 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 550.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-06-07 09:38:45
4602 4813 6 1235 14902 48 Glow it multi fruit face wash NULL 3304999 2 160.0 450.0 0.0 0.0 320.0 271.19 48.81 900.0 320.0 640.0 9.0 48.81 9.0 48.81 0.0 0.0 542.37 97.63 640.0 INR 3 2.0 10.85 2026-06-07 09:38:45
4603 4814 7 1235 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 35.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 1050.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-06-07 09:38:45
4604 4815 8 1235 14902 17 Memory Booster Juice NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-06-07 09:38:45
4605 4816 9 1235 14902 7 Morning Fresh Churan NULL 30049011 10 79.0 199.0 0.0 0.0 179.0 170.48 8.52 1990.0 790.0 1790.0 2.5 42.62 2.5 42.62 0.0 0.0 1704.76 85.24 1790.0 INR 3 2.0 34.1 2026-06-07 09:38:45
4606 4817 10 1235 14902 81 PREMIUM GLOW FACE WASH NULL 3404 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-06-07 09:38:45
4607 4818 11 1235 14902 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-06-07 09:38:45
4608 4819 12 1235 14902 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-06-07 09:38:45
4609 4820 13 1235 14902 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-06-07 09:38:45
4610 4821 14 1235 14902 36 Toilet Cleaner 500ml NULL 3924101 10 42.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 420.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-06-07 09:38:45
4611 4822 15 1235 14902 44 Vital Glow Face Scrub NULL 3304300 1 130.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 130.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 3 2.0 4.41 2026-06-07 09:38:45
4612 4823 1 1236 14902 1 Stem Cell Powder NULL 2936900 1 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 2499.0 500.0 1000.0 2.5 23.81 2.5 23.81 0.0 0.0 952.38 47.62 1000.0 INR 3 2.0 19.05 2026-06-07 12:34:40
4613 4824 1 1237 12555 11 BHRINGRAJ & SHIKAKAI NULL 33051090 5 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-06-07 17:17:05
4614 4825 2 1237 12555 49 Anti Dandruff Serum NULL 3304999 5 399.0 999.0 0.0 0.0 799.0 677.12 121.88 4995.0 1995.0 3995.0 9.0 304.7 9.0 304.7 0.0 0.0 3385.59 609.41 3995.0 INR 3 2.0 67.71 2026-06-07 17:17:05
4615 4826 3 1237 12555 60 Foot patch NULL 30051090 5 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 9995.0 3995.0 7995.0 2.5 190.36 2.5 190.36 0.0 0.0 7614.29 380.71 7995.0 INR 3 2.0 152.29 2026-06-07 17:17:05
4616 4827 4 1237 12555 9 Omega 369 NULL 2936900 5 360.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 1800.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-06-07 17:17:05
4617 4828 5 1237 12555 94 PAVANA DROPS NULL 30041211 5 249.0 699.0 0.0 0.0 499.0 475.24 23.76 3495.0 1245.0 2495.0 2.5 59.4 2.5 59.4 0.0 0.0 2376.19 118.81 2495.0 INR 3 2.0 47.52 2026-06-07 17:17:05
4618 4829 6 1237 12555 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 5 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-06-07 17:17:05
4619 4830 7 1237 12555 65 SINGLE WELLNESS NULL 94041000 2 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 25998.0 10700.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 2.0 407.62 2026-06-07 17:17:05
4620 4831 8 1237 12555 95 STRI VEDA NULL 30049011 5 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 12500.0 3750.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 3 2.0 142.86 2026-06-07 17:17:05
4621 4832 9 1237 12555 50 Sun Screen NULL 330499 5 279.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 1395.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-06-07 17:17:05
4622 4833 10 1237 12555 96 TRIM VEDA NULL 30049011 6 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 15000.0 4500.0 9000.0 2.5 214.29 2.5 214.29 0.0 0.0 8571.43 428.57 9000.0 INR 3 2.0 171.43 2026-06-07 17:17:05
4623 4834 1 1238 12554 20 Premium Berry Juice 1000ml NULL 2936900 20 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 69980.0 16000.0 32000.0 2.5 761.9 2.5 761.9 0.0 0.0 30476.19 1523.81 32000.0 INR 2 6.0 1828.57 2026-06-07 17:21:33
4624 4835 2 1238 12554 31 Vegan Plant Protein Powder NULL 21061000 9 700.0 2999.0 0.0 0.0 1400.0 1333.33 66.67 26991.0 6300.0 12600.0 2.5 300.0 2.5 300.0 0.0 0.0 12000.0 600.0 12600.0 INR 2 6.0 720.0 2026-06-07 17:21:33
4625 4836 3 1238 12554 82 ALKALINE CAPSULE NULL 3402000 10 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 25000.0 8000.0 16500.0 2.5 392.86 2.5 392.86 0.0 0.0 15714.29 785.71 16500.0 INR 2 6.0 942.86 2026-06-07 17:21:33
4626 4837 1 1239 12527 31 Vegan Plant Protein Powder NULL 21061000 1 700.0 2999.0 0.0 0.0 1400.0 1333.33 66.67 2999.0 700.0 1400.0 2.5 33.33 2.5 33.33 0.0 0.0 1333.33 66.67 1400.0 INR 3 2.0 26.67 2026-06-08 15:26:48
4627 4838 2 1239 12527 52 Bhoo sanjeevni 5 kg NULL 3103100 5 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 3125.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-06-08 15:26:48
4628 4839 3 1239 12527 37 Floor Cleaner 500ml NULL 3924101 20 55.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 1100.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-06-08 15:26:48
4629 4840 4 1239 12527 53 Terra care 2 kg NULL 3103100 5 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 2875.0 5750.0 2.5 136.9 2.5 136.9 0.0 0.0 5476.19 273.81 5750.0 INR 3 2.0 109.52 2026-06-08 15:26:48
4630 4841 5 1239 12527 36 Toilet Cleaner 500ml NULL 3924101 20 42.0 150.0 0.0 0.0 120.0 101.69 18.31 3000.0 840.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 2033.9 366.1 2400.0 INR 3 2.0 40.68 2026-06-08 15:26:48
4631 4842 1 1240 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-10 08:11:53
4632 4843 2 1240 12527 25 Manicalcium Tablets NULL 2009899 1 159.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 159.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-06-10 08:11:53
4633 4844 1 1241 14079 15 KIDNEY CARE JUICE NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-06-11 18:54:37
4634 4845 1 1242 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-12 12:47:27
4635 4846 1 1243 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-12 19:24:02
4636 4847 1 1244 16410 38 Dish Wash 500ml NULL 34029099 1 65.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 65.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 4 4.0 6.24 2026-06-13 13:04:53
4637 4848 2 1244 16410 33 HALDI CHANDAN SOAP 100gm NULL 30049011 3 35.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 105.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 228.57 11.43 240.0 INR 4 4.0 9.14 2026-06-13 13:04:53
4638 4849 3 1244 16410 16 Liver Care Juice NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 4 4.0 11.43 2026-06-13 13:04:53
4639 4850 4 1244 16410 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 4 4.0 15.24 2026-06-13 13:04:53
4640 4851 5 1244 16410 47 Premium Hair Care Shampoo NULL 3305109 1 279.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 279.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 4 4.0 21.3 2026-06-13 13:04:53
4641 4852 6 1244 16410 46 Root Vitality Hair Oil NULL 3305901 2 102.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 204.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 4 4.0 15.54 2026-06-13 13:04:53
4642 4853 1 1245 16410 37 Floor Cleaner 500ml NULL 3924101 1 55.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 55.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 4 4.0 5.39 2026-06-13 13:15:23
4643 4854 2 1245 16410 30 Iron Capsules NULL 30049011 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 4 4.0 27.39 2026-06-13 13:15:23
4644 4855 3 1245 16410 28 Ortho Joint Shield NULL 2009899 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 4 2.0 45.71 2026-06-13 13:15:23
4645 4856 1 1246 12555 20 Premium Berry Juice 1000ml NULL 2936900 20 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 69980.0 16000.0 32000.0 2.5 761.9 2.5 761.9 0.0 0.0 30476.19 1523.81 32000.0 INR 3 2.0 609.52 2026-06-13 13:20:29
4646 4857 1 1247 16410 33 HALDI CHANDAN SOAP 100gm NULL 30049011 2 35.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 70.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 4 4.0 6.1 2026-06-13 13:28:28
4647 4858 2 1247 16410 34 HERBO 33 TOOTHPASTE NULL 33061090 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 4 4.0 10.78 2026-06-13 13:28:28
4648 4859 3 1247 16410 30 Iron Capsules NULL 30049011 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 4 4.0 27.39 2026-06-13 13:28:28
4649 4860 4 1247 16410 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 750.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 4 4.0 57.14 2026-06-13 13:28:28
4650 4861 1 1248 12527 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-06-15 14:53:17