fx_franchise_order_product

4,737 rows · 33 columns · page 88 / 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
4351 4562 1 1139 12552 2 Heart Care Capsules NULL 2936900 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 3 2.0 45.71 2026-04-30 21:40:36
4352 4563 2 1139 12552 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 2 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 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 3 2.0 28.57 2026-04-30 21:40:36
4353 4564 1 1140 12545 26 Spirulina Cap NULL 2009899 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 3 2.0 13.7 2026-04-30 22:59:05
4354 4565 1 1141 12552 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 350.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-05-02 11:18:11
4355 4566 1 1142 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-05-03 14:00:00
4356 4567 1 1143 14569 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.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-05-03 23:44:54
4357 4568 2 1143 14569 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 350.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-05-03 23:44:54
4358 4569 3 1143 14569 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-05-03 23:44:54
4359 4570 1 1144 12516 98 GOLD SANITARY PAD NULL 9610091 90 0.0 250.0 0.0 0.0 0.0 0.0 0.0 22500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-05 13:14:09
4360 4571 1 1145 12554 98 GOLD SANITARY PAD NULL 9610091 90 0.0 250.0 0.0 0.0 0.0 0.0 0.0 22500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-05 13:15:16
4361 4572 1 1146 12555 98 GOLD SANITARY PAD NULL 9610091 90 0.0 250.0 0.0 0.0 0.0 0.0 0.0 22500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-05 13:20:06
4362 4573 1 1147 12516 98 GOLD SANITARY PAD NULL 9610091 50 0.0 250.0 0.0 0.0 0.0 0.0 0.0 12500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-05 18:05:24
4363 4574 1 1148 12554 98 GOLD SANITARY PAD NULL 9610091 50 0.0 250.0 0.0 0.0 0.0 0.0 0.0 12500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-05 18:06:48
4364 4575 1 1149 12554 98 GOLD SANITARY PAD NULL 9610091 50 0.0 250.0 0.0 0.0 0.0 0.0 0.0 12500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-05 18:08:59
4365 4576 1 1150 12555 98 GOLD SANITARY PAD NULL 9610091 45 0.0 250.0 0.0 0.0 0.0 0.0 0.0 11250.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-05 18:14:21
4366 4577 1 1151 12526 82 ALKALINE CAPSULE NULL 3402000 2 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 5000.0 1600.0 3300.0 2.5 78.57 2.5 78.57 0.0 0.0 3142.86 157.14 3300.0 INR 3 2.0 62.86 2026-05-06 22:19:06
4367 4578 2 1151 12526 48 Glow it multi fruit face wash NULL 3304999 7 160.0 450.0 0.0 0.0 320.0 271.19 48.81 3150.0 1120.0 2240.0 9.0 170.85 9.0 170.85 0.0 0.0 1898.3 341.69 2240.0 INR 3 2.0 37.97 2026-05-06 22:19:06
4368 4579 3 1151 12526 72 Pain Relief Patch NULL 30051090 4 200.0 800.0 0.0 0.0 400.0 380.95 19.05 3200.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-05-06 22:19:06
4369 4580 4 1151 12526 41 Premium Coco Body Lotion NULL 3304300 3 279.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 837.0 1677.0 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-05-06 22:19:06
4370 4581 5 1151 12526 46 Root Vitality Hair Oil NULL 3305901 10 102.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 1020.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-05-06 22:19:06
4371 4582 1 1152 12516 98 GOLD SANITARY PAD NULL 9610091 100 0.0 250.0 0.0 0.0 0.0 0.0 0.0 25000.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-07 12:07:24
4372 4583 1 1153 12554 98 GOLD SANITARY PAD NULL 9610091 100 0.0 250.0 0.0 0.0 0.0 0.0 0.0 25000.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-07 12:09:00
4373 4584 1 1154 12555 98 GOLD SANITARY PAD NULL 9610091 99 0.0 250.0 0.0 0.0 0.0 0.0 0.0 24750.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 12:13:34
4374 4585 1 1155 12516 98 GOLD SANITARY PAD NULL 9610091 60 0.0 250.0 0.0 0.0 0.0 0.0 0.0 15000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-07 16:49:34
4375 4586 1 1156 12554 98 GOLD SANITARY PAD NULL 9610091 60 0.0 250.0 0.0 0.0 0.0 0.0 0.0 15000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-07 16:51:35
4376 4587 1 1157 12555 98 GOLD SANITARY PAD NULL 9610091 60 0.0 250.0 0.0 0.0 0.0 0.0 0.0 15000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 16:53:27
4377 4588 1 1158 12555 70 Premium Hand belt NULL 9404 2 720.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 5000.0 1440.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 3 2.0 54.86 2026-05-07 19:40:42
4378 4589 1 1159 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 17495.0 4000.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 7619.05 380.95 8000.0 INR 3 2.0 152.38 2026-05-07 21:55:42
4379 4590 1 1160 12516 98 GOLD SANITARY PAD NULL 9610091 5 0.0 250.0 0.0 0.0 0.0 0.0 0.0 1250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-07 23:21:54
4380 4591 1 1161 12554 98 GOLD SANITARY PAD NULL 9610091 5 0.0 250.0 0.0 0.0 0.0 0.0 0.0 1250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-07 23:23:50
4381 4592 1 1162 12555 98 GOLD SANITARY PAD NULL 9610091 9 0.0 250.0 0.0 0.0 0.0 0.0 0.0 2250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 23:26:07
4382 4593 1 1163 12555 98 GOLD SANITARY PAD NULL 9610091 9 0.0 250.0 0.0 0.0 0.0 0.0 0.0 2250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 23:26:08
4383 4594 1 1164 12555 98 GOLD SANITARY PAD NULL 9610091 9 0.0 250.0 0.0 0.0 0.0 0.0 0.0 2250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 23:26:09
4384 4595 1 1165 12526 48 Glow it multi fruit face wash NULL 3304999 3 160.0 450.0 0.0 0.0 320.0 271.19 48.81 1350.0 480.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 813.56 146.44 960.0 INR 3 2.0 16.27 2026-05-08 10:18:19
4385 4596 2 1165 12526 9 Omega 369 NULL 2936900 3 360.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 1080.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-05-08 10:18:19
4386 4597 3 1165 12526 35 Sanitary Pad (15 pcs) NULL 9619001 5 150.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 750.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-05-08 10:18:19
4387 4598 4 1165 12526 34 Toothpaste NULL 33061090 6 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 330.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-05-08 10:18:19
4388 4599 1 1166 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.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-05-08 10:29:39
4389 4600 2 1166 12526 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-05-08 10:29:39
4390 4601 1 1167 12526 39 Fabric Wash 1000ml NULL 34029099 6 112.0 401.0 0.0 0.0 321.0 272.03 48.97 2406.0 672.0 1926.0 9.0 146.9 9.0 146.9 0.0 0.0 1632.2 293.8 1926.0 INR 3 2.0 32.64 2026-05-08 10:31:16
4391 4602 1 1168 12545 79 ALKALINE JAR NULL 8421 1 3300.0 14499.0 0.0 0.0 6000.0 5084.75 915.25 14499.0 3300.0 6000.0 9.0 457.63 9.0 457.63 0.0 0.0 5084.75 915.25 6000.0 INR 3 2.0 101.69 2026-05-09 13:00:52
4392 4603 2 1168 12545 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 1 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 23999.0 9250.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-05-09 13:00:52
4393 4604 1 1169 12545 37 Floor Cleaner 500ml NULL 3924101 3 55.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 165.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-05-09 13:08:28
4394 4605 1 1170 12554 28 Ortho Joint Shield NULL 2009899 27 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 40473.0 16200.0 32400.0 2.5 771.43 2.5 771.43 0.0 0.0 30857.14 1542.86 32400.0 INR 2 6.0 1851.43 2026-05-09 18:05:15
4395 4606 1 1171 12555 28 Ortho Joint Shield NULL 2009899 27 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 40473.0 16200.0 32400.0 2.5 771.43 2.5 771.43 0.0 0.0 30857.14 1542.86 32400.0 INR 3 2.0 617.14 2026-05-09 18:07:18
4396 4607 1 1172 12555 64 Bio magnetic bracelet NULL 9404 5 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 49995.0 6250.0 12500.0 1.5 182.04 1.5 182.04 0.0 0.0 12135.92 364.08 12500.0 INR 3 2.0 242.72 2026-05-09 22:53:38
4397 4608 1 1173 12555 54 Wonder grow 100ml NULL 3105 5 600.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 7000.0 3000.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 3 2.0 114.29 2026-05-10 13:31:22
4398 4609 1 1174 12555 56 Micro magic 500ml NULL 3105 9 825.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 18270.0 7425.0 14850.0 2.5 353.57 2.5 353.57 0.0 0.0 14142.86 707.14 14850.0 INR 3 2.0 282.86 2026-05-10 13:41:11
4399 4610 1 1175 14902 27 Multicharge Cap NULL 2009899 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-05-10 21:09:55
4400 4611 2 1175 14902 38 Dish Wash 500ml NULL 34029099 3 65.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 195.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 467.8 84.2 552.0 INR 3 2.0 9.36 2026-05-10 21:09:55