fx_franchise_order_product

4,737 rows · 33 columns · page 73 / 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
3601 3810 28 927 12685 29 Shilajith NULL 30049011 1 0.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 1800.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 0.0 2.0 2026-02-09 11:31:19
3602 3811 29 927 12685 26 Spirulina Cap NULL 2009899 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-02-09 11:31:19
3603 3812 30 927 12685 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-02-09 11:31:19
3604 3813 31 927 12685 50 Sun Screen NULL 330499 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.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-02-09 11:31:19
3605 3814 32 927 12685 36 Toilet Cleaner 500ml NULL 3924101 15 0.0 150.0 0.0 0.0 120.0 101.69 18.31 2250.0 0.0 1800.0 9.0 137.29 9.0 137.29 0.0 0.0 1525.42 274.58 1800.0 INR 3 2.0 30.51 2026-02-09 11:31:19
3606 3815 33 927 12685 34 Toothpaste NULL 33061090 30 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5970.0 0.0 4770.0 9.0 363.81 9.0 363.81 0.0 0.0 4042.37 727.63 4770.0 INR 3 2.0 80.85 2026-02-09 11:31:19
3607 3816 34 927 12685 44 Vital Glow Face Scrub NULL 3304300 3 0.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 0.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 661.02 118.98 780.0 INR 3 2.0 13.22 2026-02-09 11:31:19
3608 3817 1 928 14569 38 Dish Wash 500ml NULL 34029099 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-02-09 12:23:47
3609 3818 2 928 14569 47 Premium Hair Care Shampoo NULL 3305109 2 0.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 0.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-02-09 12:23:47
3610 3819 3 928 14569 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-02-09 12:23:47
3611 3820 4 928 14569 35 Sanitary Pad (15 pcs) NULL 9619001 2 0.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 0.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-02-09 12:23:47
3612 3821 1 929 12516 94 PAVANA DROPS NULL 30041211 200 0.0 699.0 0.0 0.0 499.0 475.24 23.76 139800.0 0.0 99800.0 2.5 2376.19 2.5 2376.19 0.0 0.0 95047.62 4752.38 99800.0 INR 1 8.0 7603.81 2026-02-09 16:23:31
3613 3822 2 929 12516 95 STRI VEDA NULL 30049011 200 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 500000.0 0.0 300000.0 2.5 7142.86 2.5 7142.86 0.0 0.0 285714.28 14285.71 300000.0 INR 1 8.0 22857.14 2026-02-09 16:23:31
3614 3823 3 929 12516 96 TRIM VEDA NULL 30049011 200 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 500000.0 0.0 300000.0 2.5 7142.86 2.5 7142.86 0.0 0.0 285714.28 14285.71 300000.0 INR 1 8.0 22857.14 2026-02-09 16:23:31
3615 3824 1 930 12517 94 PAVANA DROPS NULL 30041211 100 0.0 699.0 0.0 0.0 499.0 475.24 23.76 69900.0 0.0 49900.0 0.0 0.0 0.0 0.0 5.0 2376.19 47523.81 2376.19 49900.0 INR 2 6.0 2851.43 2026-02-09 16:26:11
3616 3825 2 930 12517 95 STRI VEDA NULL 30049011 100 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 250000.0 0.0 150000.0 0.0 0.0 0.0 0.0 5.0 7142.86 142857.14 7142.86 150000.0 INR 2 5.0 7142.86 2026-02-09 16:26:11
3617 3826 3 930 12517 96 TRIM VEDA NULL 30049011 100 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 250000.0 0.0 150000.0 0.0 0.0 0.0 0.0 5.0 7142.86 142857.14 7142.86 150000.0 INR 2 6.0 8571.43 2026-02-09 16:26:11
3618 3827 1 931 13438 61 Radiation chip NULL 902221 1 0.0 999.0 0.0 0.0 500.0 423.73 76.27 999.0 0.0 500.0 9.0 38.14 9.0 38.14 0.0 0.0 423.73 76.27 500.0 INR 3 2.0 8.47 2026-02-10 11:28:57
3619 3828 1 932 13438 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-02-10 11:37:25
3620 3829 1 933 14569 4 Diabetic 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-02-10 13:07:20
3621 3830 1 934 14569 38 Dish Wash 500ml NULL 34029099 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-02-10 13:21:08
3622 3831 2 934 14569 39 Fabric Wash 1000ml NULL 34029099 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.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-02-10 13:21:08
3623 3832 3 934 14569 16 Liver Care Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-02-10 13:21:08
3624 3833 4 934 14569 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-02-10 13:21:08
3625 3834 5 934 14569 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-02-10 13:21:08
3626 3835 1 935 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-02-10 13:22:19
3627 3836 1 936 12543 2 Heart Care Capsules NULL 2936900 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.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-02-10 22:40:54
3628 3837 2 936 12543 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-02-10 22:40:54
3629 3838 3 936 12543 9 Omega 369 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-02-10 22:40:54
3630 3839 4 936 12543 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-02-10 22:40:54
3631 3840 5 936 12543 8 Piles Care NULL 30049011 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-02-10 22:40:54
3632 3841 6 936 12543 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 0.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-02-10 22:40:54
3633 3842 7 936 12543 35 Sanitary Pad (15 pcs) NULL 9619001 2 0.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 0.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-02-10 22:40:54
3634 3843 8 936 12543 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-02-10 22:40:54
3635 3844 1 937 12545 32 Neem Soap 100gm NULL 34011110 65 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3900.0 0.0 3120.0 2.5 74.29 2.5 74.29 0.0 0.0 2971.43 148.57 3120.0 INR 3 2.0 59.43 2026-02-11 11:33:57
3636 3845 1 938 12545 46 Root Vitality Hair Oil NULL 3305901 1 0.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 0.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-02-11 11:36:45
3637 3846 1 939 12544 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-02-11 11:49:49
3638 3847 2 939 12544 32 Neem Soap 100gm NULL 34011110 2 0.0 60.0 0.0 0.0 48.0 45.71 2.29 120.0 0.0 96.0 2.5 2.29 2.5 2.29 0.0 0.0 91.43 4.57 96.0 INR 3 2.0 1.83 2026-02-11 11:49:49
3639 3848 3 939 12544 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-02-11 11:49:49
3640 3849 1 940 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-02-11 12:41:18
3641 3850 2 940 14569 33 HALDI CHANDAN SOAP 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 3 2.0 1.52 2026-02-11 12:41:18
3642 3851 3 940 14569 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-02-11 12:41:18
3643 3852 4 940 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-02-11 12:41:18
3644 3853 1 941 12555 29 Shilajith NULL 30049011 3 0.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 0.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 4114.29 205.71 4320.0 INR 3 0.0 2.0 2026-02-11 13:32:24
3645 3854 1 942 12554 94 PAVANA DROPS NULL 30041211 50 0.0 699.0 0.0 0.0 499.0 475.24 23.76 34950.0 0.0 24950.0 2.5 594.05 2.5 594.05 0.0 0.0 23761.9 1188.1 24950.0 INR 2 6.0 1425.71 2026-02-11 15:53:50
3646 3855 2 942 12554 95 STRI VEDA NULL 30049011 50 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 125000.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 2 5.0 3571.43 2026-02-11 15:53:50
3647 3856 3 942 12554 96 TRIM VEDA NULL 30049011 50 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 125000.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 2 6.0 4285.71 2026-02-11 15:53:50
3648 3857 1 943 12554 94 PAVANA DROPS NULL 30041211 20 0.0 699.0 0.0 0.0 499.0 475.24 23.76 13980.0 0.0 9980.0 2.5 237.62 2.5 237.62 0.0 0.0 9504.76 475.24 9980.0 INR 2 6.0 570.29 2026-02-11 15:56:50
3649 3858 2 943 12554 95 STRI VEDA NULL 30049011 20 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 50000.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 28571.43 1428.57 30000.0 INR 2 5.0 1428.57 2026-02-11 15:56:50
3650 3859 3 943 12554 96 TRIM VEDA NULL 30049011 20 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 50000.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 28571.43 1428.57 30000.0 INR 2 6.0 1714.29 2026-02-11 15:56:50