fx_franchise_order_product

4,737 rows · 33 columns · page 94 / 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
4651 4862 1 1249 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-15 16:09:37
4652 4863 1 1250 12526 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-15 22:48:22
4653 4864 2 1250 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 3 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.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-15 22:48:22
4654 4865 3 1250 12526 53 Terra care 2 kg NULL 3103100 3 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 1725.0 3450.0 2.5 82.14 2.5 82.14 0.0 0.0 3285.71 164.29 3450.0 INR 3 2.0 65.71 2026-06-15 22:48:22
4655 4866 1 1251 12526 60 Foot patch NULL 30051090 1 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 799.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-06-15 23:06:46
4656 4867 2 1251 12526 96 TRIM 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-06-15 23:06:46
4657 4868 1 1252 16410 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 4 4.0 60.95 2026-06-17 10:59:31
4658 4869 2 1252 16410 48 Glow it multi fruit face wash NULL 3304999 1 160.0 450.0 0.0 0.0 320.0 271.19 48.81 450.0 160.0 320.0 9.0 24.41 9.0 24.41 0.0 0.0 271.19 48.81 320.0 INR 4 4.0 10.85 2026-06-17 10:59:31
4659 4870 3 1252 16410 33 HALDI CHANDAN SOAP 100gm NULL 30049011 4 35.0 100.0 0.0 0.0 80.0 76.19 3.81 400.0 140.0 320.0 2.5 7.62 2.5 7.62 0.0 0.0 304.76 15.24 320.0 INR 4 4.0 12.19 2026-06-17 10:59:31
4660 4871 4 1252 16410 30 Iron Capsules NULL 30049011 2 359.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 718.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 4 4.0 54.78 2026-06-17 10:59:31
4661 4872 5 1252 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-17 10:59:31
4662 4873 6 1252 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-17 10:59:31
4663 4874 1 1253 12555 30 Iron Capsules NULL 30049011 10 359.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 3590.0 7190.0 2.5 171.19 2.5 171.19 0.0 0.0 6847.62 342.38 7190.0 INR 3 2.0 136.95 2026-06-17 11:26:59
4664 4875 1 1254 12517 46 Root Vitality Hair Oil NULL 3305901 30 102.0 255.0 0.0 0.0 204.0 194.29 9.71 7650.0 3060.0 6120.0 0.0 0.0 0.0 0.0 5.0 291.43 5828.57 291.43 6120.0 INR 2 6.0 349.71 2026-06-17 11:29:12
4665 4876 1 1255 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-22 10:10:04
4666 4877 1 1256 12685 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-22 18:33:33
4667 4878 2 1256 12685 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-06-22 18:33:33
4668 4879 3 1256 12685 46 Root Vitality Hair Oil NULL 3305901 12 102.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 1224.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-06-22 18:33:33
4669 4880 1 1257 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-23 09:48:47
4670 4881 1 1258 12526 38 Dish Wash 500ml NULL 34029099 4 65.0 230.0 0.0 0.0 184.0 155.93 28.07 920.0 260.0 736.0 9.0 56.14 9.0 56.14 0.0 0.0 623.73 112.27 736.0 INR 3 2.0 12.47 2026-06-27 10:07:22
4671 4882 1 1259 12516 20 Premium Berry Juice 1000ml NULL 2936900 10 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 34990.0 8000.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.09 761.9 16000.0 INR 1 8.0 1219.05 2026-06-28 15:55:37
4672 4883 2 1259 12516 66 Premium Blanket Single NULL 9404 10 3750.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 149990.0 37500.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 1 8.0 5714.29 2026-06-28 15:55:37
4673 4884 3 1259 12516 65 SINGLE WELLNESS NULL 94041000 10 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 129990.0 53500.0 107000.0 2.5 2547.62 2.5 2547.62 0.0 0.0 101904.76 5095.24 107000.0 INR 1 8.0 8152.38 2026-06-28 15:55:37
4674 4885 1 1260 12554 66 Premium Blanket Single NULL 9404 6 3750.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 89994.0 22500.0 45000.0 2.5 1071.43 2.5 1071.43 0.0 0.0 42857.14 2142.86 45000.0 INR 2 6.0 2571.43 2026-06-28 17:22:54
4675 4886 2 1260 12554 65 SINGLE WELLNESS NULL 94041000 5 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 64995.0 26750.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 2 6.0 3057.14 2026-06-28 17:22:54
4676 4887 1 1261 12555 66 Premium Blanket Single NULL 9404 5 3750.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 74995.0 18750.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-06-28 19:03:22
4677 4888 2 1261 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-28 19:03:22
4678 4889 1 1262 12527 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-29 10:18:38
4679 4890 1 1263 12517 11 BHRINGRAJ & SHIKAKAI NULL 33051090 4 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 5000.0 1500.0 3000.0 0.0 0.0 0.0 0.0 5.0 142.86 2857.14 142.86 3000.0 INR 2 6.0 171.43 2026-06-29 17:25:02
4680 4891 2 1263 12517 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 9 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 11250.0 3375.0 6750.0 0.0 0.0 0.0 0.0 5.0 321.43 6428.57 321.43 6750.0 INR 2 6.0 385.71 2026-06-29 17:25:02
4681 4892 3 1263 12517 10 RADIANCE GLOW DAY CREAM NULL 33049900 20 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 28480.0 7500.0 15000.0 0.0 0.0 0.0 0.0 18.0 2288.14 12711.86 2288.14 15000.0 INR 2 6.0 762.71 2026-06-29 17:25:02
4682 4893 4 1263 12517 46 Root Vitality Hair Oil NULL 3305901 60 102.0 255.0 0.0 0.0 204.0 194.29 9.71 15300.0 6120.0 12240.0 0.0 0.0 0.0 0.0 5.0 582.86 11657.14 582.86 12240.0 INR 2 6.0 699.43 2026-06-29 17:25:02
4683 4894 5 1263 12517 96 TRIM VEDA NULL 30049011 4 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 10000.0 3000.0 6000.0 0.0 0.0 0.0 0.0 5.0 285.71 5714.29 285.71 6000.0 INR 2 6.0 342.86 2026-06-29 17:25:02
4684 4895 1 1264 12517 47 Premium Hair Care Shampoo NULL 3305109 11 279.0 699.0 0.0 0.0 559.0 532.38 26.62 7689.0 3069.0 6149.0 0.0 0.0 0.0 0.0 5.0 292.81 5856.19 292.81 6149.0 INR 2 6.0 351.37 2026-06-29 18:30:31
4685 4896 2 1264 12517 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 9 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 11250.0 3375.0 6750.0 0.0 0.0 0.0 0.0 5.0 321.43 6428.57 321.43 6750.0 INR 2 6.0 385.71 2026-06-29 18:30:31
4686 4897 3 1264 12517 10 RADIANCE GLOW DAY CREAM NULL 33049900 15 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 21360.0 5625.0 11250.0 0.0 0.0 0.0 0.0 18.0 1716.1 9533.9 1716.1 11250.0 INR 2 6.0 572.03 2026-06-29 18:30:31
4687 4898 4 1264 12517 46 Root Vitality Hair Oil NULL 3305901 60 102.0 255.0 0.0 0.0 204.0 194.29 9.71 15300.0 6120.0 12240.0 0.0 0.0 0.0 0.0 5.0 582.86 11657.14 582.86 12240.0 INR 2 6.0 699.43 2026-06-29 18:30:31
4688 4899 1 1265 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-06-29 22:33:56
4689 4900 2 1265 12526 39 Fabric Wash 1000ml NULL 34029099 4 112.0 401.0 0.0 0.0 321.0 272.03 48.97 1604.0 448.0 1284.0 9.0 97.93 9.0 97.93 0.0 0.0 1088.14 195.86 1284.0 INR 3 2.0 21.76 2026-06-29 22:33:56
4690 4901 3 1265 12526 81 PREMIUM GLOW FACE WASH NULL 3404 2 279.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 558.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-06-29 22:33:56
4691 4902 4 1265 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 3 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 4272.0 1125.0 2250.0 9.0 171.61 9.0 171.61 0.0 0.0 1906.78 343.22 2250.0 INR 3 2.0 38.14 2026-06-29 22:33:56
4692 4903 1 1266 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-30 07:53:39
4693 4904 2 1266 12527 38 Dish Wash 500ml NULL 34029099 20 65.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1300.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 3118.64 561.36 3680.0 INR 3 2.0 62.37 2026-06-30 07:53:39
4694 4905 3 1266 12527 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-30 07:53:39
4695 4906 4 1266 12527 34 HERBO 33 TOOTHPASTE NULL 33061090 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-30 07:53:39
4696 4907 5 1266 12527 94 PAVANA DROPS NULL 30041211 3 249.0 699.0 0.0 0.0 499.0 475.24 23.76 2097.0 747.0 1497.0 2.5 35.64 2.5 35.64 0.0 0.0 1425.71 71.29 1497.0 INR 3 2.0 28.51 2026-06-30 07:53:39
4697 4908 6 1266 12527 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-30 07:53:39
4698 4909 1 1267 12539 2 Heart Care Capsules NULL 2936900 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-06-30 14:28:31
4699 4910 2 1267 12539 46 Root Vitality Hair Oil NULL 3305901 7 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1785.0 714.0 1428.0 2.5 34.0 2.5 34.0 0.0 0.0 1360.0 68.0 1428.0 INR 3 2.0 27.2 2026-06-30 14:28:31
4700 4911 1 1268 12545 34 HERBO 33 TOOTHPASTE NULL 33061090 14 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2786.0 770.0 2226.0 9.0 169.78 9.0 169.78 0.0 0.0 1886.44 339.56 2226.0 INR 3 2.0 37.73 2026-06-30 16:36:58