fx_franchise_order_product

4,737 rows · 33 columns · page 95 / 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
4701 4912 2 1268 12545 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-30 16:36:58
4702 4913 1 1269 12539 46 Root Vitality Hair Oil NULL 3305901 8 102.0 255.0 0.0 0.0 204.0 194.29 9.71 2040.0 816.0 1632.0 2.5 38.86 2.5 38.86 0.0 0.0 1554.29 77.71 1632.0 INR 3 2.0 31.09 2026-06-30 17:47:50
4703 4914 1 1270 12532 4 Diabetic Care Capsules 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-06-30 19:02:10
4704 4915 2 1270 12532 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-06-30 19:02:10
4705 4916 3 1270 12532 15 KIDNEY CARE JUICE NULL 2009899 5 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1745.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-30 19:02:10
4706 4917 4 1270 12532 16 Liver Care 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-06-30 19:02:10
4707 4918 5 1270 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-06-30 19:02:10
4708 4919 6 1270 12532 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-06-30 19:02:10
4709 4920 7 1270 12532 46 Root Vitality Hair Oil NULL 3305901 5 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 510.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-06-30 19:02:10
4710 4921 1 1271 12555 82 ALKALINE CAPSULE NULL 3402000 10 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 25000.0 8000.0 16500.0 2.5 392.86 2.5 392.86 0.0 0.0 15714.29 785.71 16500.0 INR 3 2.0 314.29 2026-06-30 19:05:03
4711 4922 1 1272 12555 47 Premium Hair Care Shampoo NULL 3305109 5 279.0 699.0 0.0 0.0 559.0 532.38 26.62 3495.0 1395.0 2795.0 2.5 66.55 2.5 66.55 0.0 0.0 2661.91 133.1 2795.0 INR 3 2.0 53.24 2026-06-30 20:05:20
4712 4923 1 1273 12526 4 Diabetic Care Capsules 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-06-30 21:15:28
4713 4924 2 1273 12526 39 Fabric Wash 1000ml NULL 34029099 3 112.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 336.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-06-30 21:15:28
4714 4925 3 1273 12526 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-06-30 21:15:28
4715 4926 4 1273 12526 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-06-30 21:15:28
4716 4927 1 1274 12527 52 Bhoo sanjeevni 5 kg NULL 3103100 4 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 6400.0 2500.0 5000.0 2.5 119.05 2.5 119.05 0.0 0.0 4761.9 238.1 5000.0 INR 3 2.0 95.24 2026-07-07 14:11:57
4717 4928 2 1274 12527 53 Terra care 2 kg NULL 3103100 4 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 6000.0 2300.0 4600.0 2.5 109.52 2.5 109.52 0.0 0.0 4380.95 219.05 4600.0 INR 3 2.0 87.62 2026-07-07 14:11:57
4718 4929 1 1275 12555 60 Foot patch NULL 30051090 3 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 5997.0 2397.0 4797.0 2.5 114.21 2.5 114.21 0.0 0.0 4568.57 228.43 4797.0 INR 3 2.0 91.37 2026-07-14 19:28:34
4719 4930 1 1276 12527 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-07-16 13:56:54
4720 4931 2 1276 12527 6 ASTORELIFE GUARD NULL 30049011 2 360.0 899.0 0.0 0.0 720.0 685.71 34.29 1798.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-07-16 13:56:54
4721 4932 3 1276 12527 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-07-16 13:56:54
4722 4933 4 1276 12527 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-07-16 13:56:54
4723 4934 5 1276 12527 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-07-16 13:56:54
4724 4935 6 1276 12527 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-07-16 13:56:54
4725 4936 7 1276 12527 46 Root Vitality Hair Oil NULL 3305901 20 102.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 2040.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 3885.71 194.29 4080.0 INR 3 2.0 77.71 2026-07-16 13:56:54
4726 4937 8 1276 12527 29 Shilajith NULL 30049011 1 400.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 1500.0 400.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 0.0 2.0 2026-07-16 13:56:54
4727 4938 1 1277 12527 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-07-30 09:46:26
4728 4939 2 1277 12527 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-07-30 09:46:26
4729 4940 3 1277 12527 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-07-30 09:46:26
4730 4941 4 1277 12527 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-07-30 09:46:26
4731 4942 5 1277 12527 35 Sanitary Pad (15 pcs) NULL 9619001 10 150.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 1500.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 3040.0 0.0 3040.0 INR 3 2.0 60.8 2026-07-30 09:46:26
4732 4943 6 1277 12527 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-07-30 09:46:26
4733 4944 1 1278 12526 39 Fabric Wash 1000ml NULL 34029099 1 112.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 112.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-07-31 13:11:15
4734 4945 2 1278 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 35.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 1050.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-07-31 13:11:15
4735 4946 3 1278 12526 7 Morning Fresh Churan NULL 30049011 1 79.0 199.0 0.0 0.0 179.0 170.48 8.52 199.0 79.0 179.0 2.5 4.26 2.5 4.26 0.0 0.0 170.48 8.52 179.0 INR 3 2.0 3.41 2026-07-31 13:11:15
4736 4947 4 1278 12526 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-07-31 13:11:15
4737 4948 5 1278 12526 46 Root Vitality Hair Oil NULL 3305901 20 102.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 2040.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 3885.71 194.29 4080.0 INR 3 2.0 77.71 2026-07-31 13:11:15