fx_franchise_order_product

4,737 rows · 33 columns · page 90 / 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
4451 4662 4 1182 12526 54 Wonder grow 100ml NULL 3105 1 600.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.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-12 11:11:56
4452 4663 1 1183 12526 3 BP Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-12 11:16:00
4453 4664 2 1183 12526 4 Diabetic Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-12 11:16:00
4454 4665 3 1183 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 50 35.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1750.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-05-12 11:16:00
4455 4666 4 1183 12526 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 3 2.0 28.57 2026-05-12 11:16:00
4456 4667 1 1184 12532 65 SINGLE WELLNESS NULL 94041000 1 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 12999.0 5350.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-05-12 19:28:53
4457 4668 1 1185 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-13 17:01:51
4458 4669 1 1186 12523 82 ALKALINE CAPSULE NULL 3402000 1 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 2500.0 800.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-05-13 22:20:49
4459 4670 2 1186 12523 3 BP Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-13 22:20:49
4460 4671 3 1186 12523 4 Diabetic Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-13 22:20:49
4461 4672 4 1186 12523 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-05-13 22:20:49
4462 4673 5 1186 12523 9 Omega 369 NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-13 22:20:49
4463 4674 6 1186 12523 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 750.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1271.19 228.81 1500.0 INR 3 2.0 25.42 2026-05-13 22:20:49
4464 4675 1 1187 12523 7 Morning Fresh Churan NULL 30049011 4 79.0 199.0 0.0 0.0 179.0 170.48 8.52 796.0 316.0 716.0 2.5 17.05 2.5 17.05 0.0 0.0 681.9 34.1 716.0 INR 3 2.0 13.64 2026-05-14 13:20:15
4465 4676 2 1187 12523 9 Omega 369 NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-14 13:20:15
4466 4677 1 1188 12545 70 Premium Hand belt NULL 9404 1 720.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 2500.0 720.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-05-14 15:35:50
4467 4678 2 1188 12545 3 BP Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-14 15:35:50
4468 4679 3 1188 12545 4 Diabetic Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-14 15:35:50
4469 4680 4 1188 12545 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 3 2.0 5.71 2026-05-14 15:35:50
4470 4681 5 1188 12545 28 Ortho Joint Shield 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-14 15:35:50
4471 4682 6 1188 12545 46 Root Vitality Hair Oil NULL 3305901 1 102.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 102.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-05-14 15:35:50
4472 4683 7 1188 12545 34 Toothpaste NULL 33061090 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 3 2.0 2.69 2026-05-14 15:35:50
4473 4684 1 1189 12526 94 PAVANA DROPS NULL 30041211 2 249.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 498.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-05-15 00:16:17
4474 4685 1 1190 12545 38 Dish Wash 500ml NULL 34029099 2 65.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 130.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-05-15 11:38:09
4475 4686 2 1190 12545 37 Floor Cleaner 500ml NULL 3924101 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 3 2.0 5.39 2026-05-15 11:38:09
4476 4687 3 1190 12545 41 Premium Coco Body Lotion NULL 3304300 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-05-15 11:38:09
4477 4688 4 1190 12545 46 Root Vitality Hair Oil NULL 3305901 1 102.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 102.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-05-15 11:38:09
4478 4689 5 1190 12545 36 Toilet Cleaner 500ml NULL 3924101 3 42.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 126.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-05-15 11:38:09
4479 4690 1 1191 12545 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-05-17 19:37:35
4480 4691 2 1191 12545 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-17 19:37:35
4481 4692 3 1191 12545 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-05-17 19:37:35
4482 4693 4 1191 12545 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-05-17 19:37:35
4483 4694 5 1191 12545 35 Sanitary Pad (15 pcs) NULL 9619001 1 150.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 150.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-05-17 19:37:35
4484 4695 6 1191 12545 34 Toothpaste NULL 33061090 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-17 19:37:35
4485 4696 1 1192 12545 9 Omega 369 NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-18 17:08:32
4486 4697 1 1193 12545 3 BP Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-20 10:16:46
4487 4698 2 1193 12545 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-05-20 10:16:46
4488 4699 1 1194 12545 9 Omega 369 NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-20 14:49:37
4489 4700 2 1194 12545 46 Root Vitality Hair Oil NULL 3305901 4 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1020.0 408.0 816.0 2.5 19.43 2.5 19.43 0.0 0.0 777.14 38.86 816.0 INR 3 2.0 15.54 2026-05-20 14:49:37
4490 4701 1 1195 12532 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-05-20 15:47:17
4491 4702 2 1195 12532 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-05-20 15:47:17
4492 4703 3 1195 12532 17 Memory Booster Juice NULL 2009899 3 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1047.0 450.0 900.0 2.5 21.43 2.5 21.43 0.0 0.0 857.14 42.86 900.0 INR 3 2.0 17.14 2026-05-20 15:47:17
4493 4704 4 1195 12532 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-05-20 15:47:17
4494 4705 5 1195 12532 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-05-20 15:47:17
4495 4706 6 1195 12532 94 PAVANA DROPS NULL 30041211 10 249.0 699.0 0.0 0.0 499.0 475.24 23.76 6990.0 2490.0 4990.0 2.5 118.81 2.5 118.81 0.0 0.0 4752.38 237.62 4990.0 INR 3 2.0 95.05 2026-05-20 15:47:17
4496 4707 7 1195 12532 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-05-20 15:47:17
4497 4708 1 1196 12545 9 Omega 369 NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-20 15:58:41
4498 4709 1 1197 12526 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.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-05-20 21:02:32
4499 4710 2 1197 12526 4 Diabetic Care Capsules NULL 2936900 6 360.0 999.0 0.0 0.0 720.0 685.71 34.29 5994.0 2160.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 4114.29 205.71 4320.0 INR 3 2.0 82.29 2026-05-20 21:02:32
4500 4711 3 1197 12526 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-20 21:02:32