fx_franchise_order_product

4,737 rows · 33 columns · page 78 / 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
3851 4060 3 986 12545 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.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-03-01 08:59:54
3852 4061 1 987 12516 7 Morning Fresh Churan NULL 30049011 100 0.0 199.0 0.0 0.0 159.0 151.43 7.57 19900.0 0.0 15900.0 2.5 378.57 2.5 378.57 0.0 0.0 15142.86 757.14 15900.0 INR 1 8.0 1211.43 2026-03-01 10:31:13
3853 4062 1 988 12521 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-03-01 11:40:59
3854 4063 2 988 12521 2 Heart Care Capsules NULL 2936900 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-03-01 11:40:59
3855 4064 1 989 12521 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.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-03-01 15:08:20
3856 4065 2 989 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-01 15:08:20
3857 4066 3 989 12521 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.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-03-01 15:08:20
3858 4067 1 990 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-01 16:14:20
3859 4068 2 990 12545 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.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-03-01 16:14:20
3860 4069 1 991 12526 93 FAMILY WELLNESS PACKAGE NULL NULL 2 0.0 26000.0 0.0 0.0 18750.0 17857.14 892.86 52000.0 0.0 37500.0 2.5 892.86 2.5 892.86 0.0 0.0 35714.29 1785.71 37500.0 INR 3 2.0 714.29 2026-03-01 16:47:37
3861 4070 1 992 12526 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-03-01 16:48:52
3862 4071 1 993 12523 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.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-03-01 18:15:27
3863 4072 2 993 12523 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-03-01 18:15:27
3864 4073 3 993 12523 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-03-01 18:15:27
3865 4074 4 993 12523 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-03-01 18:15:27
3866 4075 5 993 12523 18 Lady Care Juice 500ml NULL 2009899 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-03-01 18:15:27
3867 4076 6 993 12523 7 Morning Fresh Churan NULL 30049011 15 0.0 199.0 0.0 0.0 159.0 151.43 7.57 2985.0 0.0 2385.0 2.5 56.79 2.5 56.79 0.0 0.0 2271.43 113.57 2385.0 INR 3 2.0 45.43 2026-03-01 18:15:27
3868 4077 7 993 12523 32 Neem Soap 100gm NULL 34011110 75 0.0 60.0 0.0 0.0 48.0 45.71 2.29 4500.0 0.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-03-01 18:15:27
3869 4078 8 993 12523 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 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-03-01 18:15:27
3870 4079 9 993 12523 12 PREMIUM 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-03-01 18:15:27
3871 4080 10 993 12523 43 Quench Kiss Lip Balm NULL 3304300 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-03-01 18:15:27
3872 4081 11 993 12523 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.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-03-01 18:15:27
3873 4082 12 993 12523 50 Sun Screen NULL 330499 7 0.0 699.0 0.0 0.0 559.0 473.73 85.27 4893.0 0.0 3913.0 9.0 298.45 9.0 298.45 0.0 0.0 3316.1 596.9 3913.0 INR 3 2.0 66.32 2026-03-01 18:15:27
3874 4083 13 993 12523 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-03-01 18:15:27
3875 4084 14 993 12523 34 Toothpaste NULL 33061090 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-03-01 18:15:27
3876 4085 15 993 12523 44 Vital Glow Face Scrub NULL 3304300 10 0.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 0.0 2600.0 9.0 198.31 9.0 198.31 0.0 0.0 2203.39 396.61 2600.0 INR 3 2.0 44.07 2026-03-01 18:15:27
3877 4086 1 994 12526 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 1 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 34001.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 3 2.0 352.38 2026-03-01 21:17:34
3878 4087 1 995 12526 6 Asthma Care NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-03-01 21:20:53
3879 4088 2 995 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-03-01 21:20:53
3880 4089 3 995 12526 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-03-01 21:20:53
3881 4090 1 996 12517 46 Root Vitality Hair Oil NULL 3305901 100 0.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 0.0 20400.0 0.0 0.0 0.0 0.0 5.0 971.43 19428.57 971.43 20400.0 INR 2 6.0 1165.71 2026-03-02 12:33:58
3882 4091 1 997 12516 46 Root Vitality Hair Oil NULL 3305901 100 0.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 0.0 20400.0 2.5 485.71 2.5 485.71 0.0 0.0 19428.57 971.43 20400.0 INR 1 8.0 1554.29 2026-03-02 12:34:19
3883 4092 1 998 12539 3 BP Care Capsules 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.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-02 13:41:09
3884 4093 2 998 12539 4 Diabetic Care Capsules 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.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-02 13:41:09
3885 4094 3 998 12539 38 Dish Wash 500ml NULL 34029099 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 311.86 56.14 368.0 INR 3 2.0 6.24 2026-03-02 13:41:09
3886 4095 4 998 12539 37 Floor Cleaner 500ml NULL 3924101 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-03-02 13:41:09
3887 4096 5 998 12539 33 HALDI CHANDAN SOAP 100gm NULL 30049011 11 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1100.0 0.0 880.0 2.5 20.95 2.5 20.95 0.0 0.0 838.1 41.9 880.0 INR 3 2.0 16.76 2026-03-02 13:41:09
3888 4097 6 998 12539 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.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-03-02 13:41:09
3889 4098 7 998 12539 32 Neem Soap 100gm NULL 34011110 40 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2400.0 0.0 1920.0 2.5 45.71 2.5 45.71 0.0 0.0 1828.57 91.43 1920.0 INR 3 2.0 36.57 2026-03-02 13:41:09
3890 4099 8 998 12539 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.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-02 13:41:09
3891 4100 9 998 12539 94 PAVANA DROPS NULL 30041211 1 0.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 0.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 475.24 23.76 499.0 INR 3 2.0 9.5 2026-03-02 13:41:09
3892 4101 10 998 12539 46 Root Vitality Hair Oil NULL 3305901 23 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5865.0 0.0 4692.0 2.5 111.71 2.5 111.71 0.0 0.0 4468.57 223.43 4692.0 INR 3 2.0 89.37 2026-03-02 13:41:09
3893 4102 11 998 12539 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.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-03-02 13:41:09
3894 4103 12 998 12539 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-03-02 13:41:09
3895 4104 13 998 12539 34 Toothpaste NULL 33061090 23 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4577.0 0.0 3657.0 9.0 278.92 9.0 278.92 0.0 0.0 3099.15 557.85 3657.0 INR 3 2.0 61.98 2026-03-02 13:41:09
3896 4105 1 999 14569 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-02 21:43:18
3897 4106 2 999 14569 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 0.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-03-02 21:43:18
3898 4107 3 999 14569 32 Neem Soap 100gm NULL 34011110 8 0.0 60.0 0.0 0.0 48.0 45.71 2.29 480.0 0.0 384.0 2.5 9.14 2.5 9.14 0.0 0.0 365.71 18.29 384.0 INR 3 2.0 7.31 2026-03-02 21:43:18
3899 4108 4 999 14569 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.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-03-02 21:43:18
3900 4109 1 1000 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 3 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 0.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-03-02 23:03:40