fx_franchise_order_product

4,737 rows · 33 columns · page 56 / 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
2751 2960 6 715 12534 39 Fabric Wash 1000ml NULL 3924101 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-13 18:40:46
2752 2961 7 715 12534 37 Floor Cleaner 500ml NULL 3924101 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.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-01-13 18:40:46
2753 2962 8 715 12534 34 Herbo2o Toothpaste NULL 33061090 22 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4378.0 0.0 3498.0 9.0 266.8 9.0 266.8 0.0 0.0 2964.41 533.59 3498.0 INR 3 2.0 59.29 2026-01-13 18:40:46
2754 2963 9 715 12534 17 Memory Booster Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-13 18:40:46
2755 2964 10 715 12534 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 2.5 18.93 2.5 18.93 0.0 0.0 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-13 18:40:46
2756 2965 11 715 12534 32 Neem Soap 100gm NULL 34011110 55 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3300.0 0.0 2640.0 2.5 62.86 2.5 62.86 0.0 0.0 2514.29 125.71 2640.0 INR 3 2.0 50.29 2026-01-13 18:40:46
2757 2966 12 715 12534 46 Root Vitality Hair Oil NULL 3305901 4 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1020.0 0.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-01-13 18:40:46
2758 2967 13 715 12534 35 Sanitary Pad (15 pcs) NULL 9619001 6 0.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 0.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 1824.0 0.0 1824.0 INR 3 2.0 36.48 2026-01-13 18:40:46
2759 2968 14 715 12534 5 Thyro Care 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-01-13 18:40:46
2760 2969 15 715 12534 36 Toilet Cleaner 500ml NULL 3924101 17 0.0 150.0 0.0 0.0 120.0 101.69 18.31 2550.0 0.0 2040.0 9.0 155.59 9.0 155.59 0.0 0.0 1728.81 311.19 2040.0 INR 3 2.0 34.58 2026-01-13 18:40:46
2761 2970 1 716 12517 36 Toilet Cleaner 500ml NULL 3924101 20 0.0 150.0 0.0 0.0 120.0 101.69 18.31 3000.0 0.0 2400.0 0.0 0.0 0.0 0.0 18.0 366.1 2033.9 366.1 2400.0 INR 2 6.0 122.03 2026-01-13 18:51:02
2762 2971 1 717 12517 38 Dish Wash 500ml NULL 3924101 100 0.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 0.0 18400.0 0.0 0.0 0.0 0.0 18.0 2806.78 15593.22 2806.78 18400.0 INR 2 6.0 935.59 2026-01-13 19:20:01
2763 2972 2 717 12517 39 Fabric Wash 1000ml NULL 3924101 100 0.0 401.0 0.0 0.0 321.0 272.03 48.97 40100.0 0.0 32100.0 0.0 0.0 0.0 0.0 18.0 4896.61 27203.39 4896.61 32100.0 INR 2 6.0 1632.2 2026-01-13 19:20:01
2764 2973 3 717 12517 37 Floor Cleaner 500ml NULL 3924101 100 0.0 199.0 0.0 0.0 159.0 134.75 24.25 19900.0 0.0 15900.0 0.0 0.0 0.0 0.0 18.0 2425.42 13474.58 2425.42 15900.0 INR 2 6.0 808.47 2026-01-13 19:20:01
2765 2974 4 717 12517 36 Toilet Cleaner 500ml NULL 3924101 100 0.0 150.0 0.0 0.0 120.0 101.69 18.31 15000.0 0.0 12000.0 0.0 0.0 0.0 0.0 18.0 1830.51 10169.49 1830.51 12000.0 INR 2 6.0 610.17 2026-01-13 19:20:01
2766 2975 1 718 12516 38 Dish Wash 500ml NULL 3924101 100 0.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 0.0 18400.0 9.0 1403.39 9.0 1403.39 0.0 0.0 15593.22 2806.78 18400.0 INR 1 8.0 1247.46 2026-01-13 19:24:26
2767 2976 2 718 12516 37 Floor Cleaner 500ml NULL 3924101 100 0.0 199.0 0.0 0.0 159.0 134.75 24.25 19900.0 0.0 15900.0 9.0 1212.71 9.0 1212.71 0.0 0.0 13474.58 2425.42 15900.0 INR 1 8.0 1077.97 2026-01-13 19:24:26
2768 2977 3 718 12516 36 Toilet Cleaner 500ml NULL 3924101 100 0.0 150.0 0.0 0.0 120.0 101.69 18.31 15000.0 0.0 12000.0 9.0 915.25 9.0 915.25 0.0 0.0 10169.49 1830.51 12000.0 INR 1 8.0 813.56 2026-01-13 19:24:26
2769 2978 1 719 13518 52 Bhoo sanjeevni 5 kg NULL 3103100 20 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 32000.0 0.0 25000.0 2.5 595.24 2.5 595.24 0.0 0.0 23809.52 1190.48 25000.0 INR 3 2.0 476.19 2026-01-14 11:53:54
2770 2979 2 719 13518 3 BP Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.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 2.0 27.43 2026-01-14 11:53:54
2771 2980 3 719 13518 4 Diabetic Care Capsules NULL 2936900 4 0.0 999.0 0.0 0.0 720.0 685.71 34.29 3996.0 0.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-01-14 11:53:54
2772 2981 4 719 13518 38 Dish Wash 500ml NULL 3924101 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.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-01-14 11:53:54
2773 2982 5 719 13518 58 Green shield 250ml NULL 3105 30 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 75000.0 0.0 55500.0 2.5 1321.43 2.5 1321.43 0.0 0.0 52857.14 2642.86 55500.0 INR 3 2.0 1057.14 2026-01-14 11:53:54
2774 2983 6 719 13518 55 Grow master 500ml NULL 3105 5 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 10150.0 0.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 7857.14 392.86 8250.0 INR 3 0.0 0.0 2026-01-14 11:53:54
2775 2984 7 719 13518 34 Herbo2o Toothpaste NULL 33061090 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-14 11:53:54
2776 2985 8 719 13518 7 Morning Fresh Churan NULL 30049011 10 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1990.0 0.0 1590.0 2.5 37.86 2.5 37.86 0.0 0.0 1514.29 75.71 1590.0 INR 3 2.0 30.29 2026-01-14 11:53:54
2777 2986 9 719 13518 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 0.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-01-14 11:53:54
2778 2987 10 719 13518 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-01-14 11:53:54
2779 2988 11 719 13518 28 Ortho Joint Shield NULL 2009899 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.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-01-14 11:53:54
2780 2989 12 719 13518 8 Piles Care NULL 30049011 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.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 2.0 27.43 2026-01-14 11:53:54
2781 2990 13 719 13518 35 Sanitary Pad (15 pcs) NULL 9619001 5 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 0.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-01-14 11:53:54
2782 2991 14 719 13518 1 Stem Cell Powder NULL 2936900 5 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 12495.0 0.0 9995.0 2.5 237.98 2.5 237.98 0.0 0.0 9519.05 475.95 9995.0 INR 3 2.0 190.38 2026-01-14 11:53:54
2783 2992 15 719 13518 5 Thyro Care NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.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 2.0 27.43 2026-01-14 11:53:54
2784 2993 16 719 13518 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-01-14 11:53:54
2785 2994 17 719 13518 54 Wonder grow 100ml NULL 3105 25 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 35000.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 28571.43 1428.57 30000.0 INR 3 2.0 571.43 2026-01-14 11:53:54
2786 2995 1 720 12554 79 ALKALINE JUG NULL 8421 3 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 43497.0 0.0 29700.0 9.0 2265.25 9.0 2265.25 0.0 0.0 25169.49 4530.51 29700.0 INR 2 0.0 300.0 2026-01-14 11:58:39
2787 2996 2 720 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 50 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 80000.0 0.0 62500.0 2.5 1488.1 2.5 1488.1 0.0 0.0 59523.81 2976.19 62500.0 INR 2 6.0 3571.43 2026-01-14 11:58:39
2788 2997 3 720 12554 58 Green shield 250ml NULL 3105 20 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 50000.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 35238.1 1761.9 37000.0 INR 2 6.0 2114.29 2026-01-14 11:58:39
2789 2998 4 720 12554 46 Root Vitality Hair Oil NULL 3305901 30 0.0 255.0 0.0 0.0 204.0 194.29 9.71 7650.0 0.0 6120.0 2.5 145.71 2.5 145.71 0.0 0.0 5828.57 291.43 6120.0 INR 2 6.0 349.71 2026-01-14 11:58:39
2790 2999 5 720 12554 53 Terra care 2 kg NULL 3103100 20 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 30000.0 0.0 23000.0 2.5 547.62 2.5 547.62 0.0 0.0 21904.76 1095.24 23000.0 INR 2 6.0 1314.29 2026-01-14 11:58:39
2791 3000 6 720 12554 54 Wonder grow 100ml NULL 3105 30 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 42000.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 34285.71 1714.29 36000.0 INR 2 6.0 2057.14 2026-01-14 11:58:39
2792 3001 1 721 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 100 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 160000.0 0.0 125000.0 2.5 2976.19 2.5 2976.19 0.0 0.0 119047.62 5952.38 125000.0 INR 1 8.0 9523.81 2026-01-14 11:59:11
2793 3002 1 722 13518 79 ALKALINE JUG NULL 8421 1 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 14499.0 0.0 9900.0 9.0 755.08 9.0 755.08 0.0 0.0 8389.83 1510.17 9900.0 INR 3 0.0 150.0 2026-01-14 12:02:54
2794 3003 2 722 13518 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-14 12:02:54
2795 3004 3 722 13518 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.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-01-14 12:02:54
2796 3005 4 722 13518 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.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-01-14 12:02:54
2797 3006 5 722 13518 53 Terra care 2 kg NULL 3103100 6 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 9000.0 0.0 6900.0 2.5 164.29 2.5 164.29 0.0 0.0 6571.43 328.57 6900.0 INR 3 2.0 131.43 2026-01-14 12:02:54
2798 3007 1 723 13836 33 Herbal Soap 100gm NULL 30049011 4 0.0 100.0 0.0 0.0 80.0 76.19 3.81 400.0 0.0 320.0 2.5 7.62 2.5 7.62 0.0 0.0 304.76 15.24 320.0 INR 3 2.0 6.1 2026-01-14 13:08:16
2799 3008 1 724 12551 58 Green shield 250ml NULL 3105 20 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 50000.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 35238.1 1761.9 37000.0 INR 2 6.0 2114.29 2026-01-14 16:35:44
2800 3009 2 724 12551 57 Safe guard 250ml NULL 3105 20 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 50000.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 35238.1 1761.9 37000.0 INR 2 6.0 2114.29 2026-01-14 16:35:44