fx_franchise_order_product

4,737 rows · 33 columns · page 81 / 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
4001 4210 2 1023 14569 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 2 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 68002.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 35238.1 1761.9 37000.0 INR 3 2.0 704.76 2026-03-14 10:31:53
4002 4211 3 1023 14569 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-14 10:31:53
4003 4212 1 1024 14569 55 Grow master 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-03-14 11:30:41
4004 4213 1 1025 14569 55 Grow master 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-03-14 11:31:41
4005 4214 1 1026 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-14 11:36:44
4006 4215 2 1026 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-14 11:36:44
4007 4216 1 1027 14569 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-14 12:24:42
4008 4217 2 1027 14569 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-14 12:24:42
4009 4218 1 1028 12545 94 PAVANA DROPS NULL 30041211 5 0.0 699.0 0.0 0.0 499.0 475.24 23.76 3495.0 0.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-03-14 12:57:35
4010 4219 1 1029 12526 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 0.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-03-14 20:28:05
4011 4220 2 1029 12526 46 Root Vitality Hair Oil NULL 3305901 14 0.0 255.0 0.0 0.0 204.0 194.29 9.71 3570.0 0.0 2856.0 2.5 68.0 2.5 68.0 0.0 0.0 2720.0 136.0 2856.0 INR 3 2.0 54.4 2026-03-14 20:28:05
4012 4221 3 1029 12526 34 Toothpaste NULL 33061090 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-03-14 20:28:05
4013 4222 1 1030 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-14 20:34:24
4014 4223 2 1030 14569 41 Premium Coco Body Lotion NULL 3304300 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-14 20:34:24
4015 4224 3 1030 14569 26 Spirulina Cap NULL 2009899 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-14 20:34:24
4016 4225 4 1030 14569 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.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-03-14 20:34:24
4017 4226 5 1030 14569 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-14 20:34:24
4018 4227 6 1030 14569 5 Thyro Care 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-14 20:34:24
4019 4228 1 1031 14569 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-14 20:40:24
4020 4229 1 1032 14569 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-15 10:39:46
4021 4230 1 1033 12545 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-16 06:26:04
4022 4231 2 1033 12545 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-16 06:26:04
4023 4232 3 1033 12545 96 TRIM VEDA NULL 30049011 1 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-03-16 06:26:04
4024 4233 1 1034 12542 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-16 13:02:58
4025 4234 1 1035 12539 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-16 14:47:31
4026 4235 1 1036 12516 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 15 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 510015.0 0.0 277500.0 2.5 6607.14 2.5 6607.14 0.0 0.0 264285.71 13214.29 277500.0 INR 1 0.0 0.0 2026-03-16 14:56:35
4027 4236 1 1037 12545 32 Neem Soap 100gm NULL 34011110 13 0.0 60.0 0.0 0.0 48.0 45.71 2.29 780.0 0.0 624.0 2.5 14.86 2.5 14.86 0.0 0.0 594.29 29.71 624.0 INR 3 2.0 11.89 2026-03-16 20:49:50
4028 4237 2 1037 12545 34 Toothpaste NULL 33061090 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-03-16 20:49:50
4029 4238 1 1038 12533 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.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-03-16 20:55:37
4030 4239 1 1039 12521 93 FAMILY WELLNESS PACKAGE NULL NULL 1 0.0 26000.0 0.0 0.0 18750.0 17857.14 892.86 26000.0 0.0 18750.0 2.5 446.43 2.5 446.43 0.0 0.0 17857.14 892.86 18750.0 INR 3 2.0 357.14 2026-03-16 20:56:25
4031 4240 2 1039 12521 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.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-03-16 20:56:25
4032 4241 1 1040 14902 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-16 22:58:45
4033 4242 2 1040 14902 3 BP 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-16 22:58:45
4034 4243 3 1040 14902 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-16 22:58:45
4035 4244 4 1040 14902 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-16 22:58:45
4036 4245 5 1040 14902 7 Morning Fresh Churan NULL 30049011 2 0.0 199.0 0.0 0.0 159.0 151.43 7.57 398.0 0.0 318.0 2.5 7.57 2.5 7.57 0.0 0.0 302.86 15.14 318.0 INR 3 2.0 6.06 2026-03-16 22:58:45
4037 4246 6 1040 14902 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-03-16 22:58:45
4038 4247 7 1040 14902 28 Ortho Joint Shield NULL 2009899 4 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 5996.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-03-16 22:58:45
4039 4248 8 1040 14902 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-16 22:58:45
4040 4249 9 1040 14902 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-16 22:58:45
4041 4250 10 1040 14902 44 Vital Glow Face Scrub NULL 3304300 2 0.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 0.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 440.68 79.32 520.0 INR 3 2.0 8.81 2026-03-16 22:58:45
4042 4251 1 1041 12517 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 10 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 340010.0 0.0 185000.0 0.0 0.0 0.0 0.0 5.0 8809.52 176190.48 8809.52 185000.0 INR 2 5.0 8809.52 2026-03-17 12:24:06
4043 4252 1 1042 14079 15 KIDNEY CARE JUICE NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-03-18 22:46:17
4044 4253 2 1042 14079 5 Thyro Care 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-18 22:46:17
4045 4254 1 1043 14569 58 Green shield 250ml NULL 3105 1 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 2500.0 0.0 1850.0 2.5 44.05 2.5 44.05 0.0 0.0 1761.9 88.1 1850.0 INR 3 2.0 35.24 2026-03-19 22:17:39
4046 4255 2 1043 14569 30 Iron Capsules 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-19 22:17:39
4047 4256 3 1043 14569 56 Micro magic 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-03-19 22:17:39
4048 4257 4 1043 14569 54 Wonder grow 100ml NULL 3105 1 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.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-19 22:17:39
4049 4258 1 1044 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-20 23:25:40
4050 4259 2 1044 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-20 23:25:40