fx_franchise_order_product

4,737 rows · 33 columns · page 18 / 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
851 1060 3 121 12524 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-09 16:36:10
852 1061 4 121 12524 39 Fabric Wash 1000ml NULL 3924101 25 150.0 401.0 0.0 0.0 320.8 271.86 48.94 10025.0 3750.0 8020.0 9.0 611.7 9.0 611.7 0.0 0.0 271.86 1223.39 8020.0 INR 0 0.0 0.0 2025-11-09 16:36:10
853 1062 5 121 12524 37 Floor Cleaner 500ml NULL 3924101 20 80.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 1600.0 3184.0 9.0 242.84 9.0 242.84 0.0 0.0 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-09 16:36:10
854 1063 6 121 12524 34 Herbo2o Toothpaste NULL 33061090 50 45.0 199.0 0.0 0.0 159.2 134.92 24.28 9950.0 2250.0 7960.0 9.0 607.12 9.0 607.12 0.0 0.0 134.92 1214.24 7960.0 INR 0 0.0 0.0 2025-11-09 16:36:10
855 1064 7 121 12524 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-09 16:36:10
856 1065 8 121 12524 46 Root Vitality Hair Oil NULL 3305901 20 54.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 1080.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 194.29 194.29 4080.0 INR 0 0.0 0.0 2025-11-09 16:36:10
857 1066 9 121 12524 36 Toilet Cleaner 500ml NULL 3924101 20 30.0 150.0 0.0 0.0 120.0 101.69 18.3 3000.0 600.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 101.69 366.1 2400.0 INR 0 0.0 0.0 2025-11-09 16:36:10
858 1067 1 122 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 17:07:48
859 1068 1 123 12540 4 Diabetic Care Capsules NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-09 19:11:39
860 1069 2 123 12540 33 Herbal Soap 100gm NULL 30049011 30 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 840.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 76.19 114.29 2400.0 INR 0 0.0 0.0 2025-11-09 19:11:39
861 1070 3 123 12540 32 Neem Soap 100gm NULL 34011110 50 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 500.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 45.71 114.29 2400.0 INR 0 0.0 0.0 2025-11-09 19:11:39
862 1071 4 123 12540 42 Premium Glow Charm Fairness Cream NULL 33049990 2 80.0 399.0 0.0 0.0 319.2 270.51 48.69 798.0 160.0 638.4 9.0 48.69 9.0 48.69 0.0 0.0 270.51 97.38 638.4 INR 0 0.0 0.0 2025-11-09 19:11:39
863 1072 5 123 12540 46 Root Vitality Hair Oil NULL 3305901 5 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 270.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 194.29 48.57 1020.0 INR 0 0.0 0.0 2025-11-09 19:11:39
864 1073 6 123 12540 35 Sanitary Pad (15 pcs) NULL 9619001 5 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 200.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1520.0 INR 0 0.0 0.0 2025-11-09 19:11:39
865 1074 7 123 12540 44 Vital Glow Face Scrub NULL 3304300 2 71.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 142.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 220.34 79.32 520.0 INR 0 0.0 0.0 2025-11-09 19:11:39
866 1075 1 124 12517 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 0.0 0.0 0.0 0.0 5.0 499.95 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-09 19:37:47
867 1076 1 125 12525 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 21:31:07
868 1077 1 126 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 21:36:02
869 1078 1 127 12525 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 21:59:41
870 1079 1 128 12546 7 Morning Fresh Churan NULL 30049011 15 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2985.0 600.0 2388.0 2.5 56.85 2.5 56.85 0.0 0.0 151.62 113.71 2388.0 INR 0 0.0 0.0 2025-11-10 06:50:30
871 1080 2 128 12546 46 Root Vitality Hair Oil NULL 3305901 16 54.0 255.0 0.0 0.0 204.0 194.29 9.71 4080.0 864.0 3264.0 2.5 77.72 2.5 77.72 0.0 0.0 194.29 155.43 3264.0 INR 0 0.0 0.0 2025-11-10 06:50:30
872 1081 1 129 12544 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-10 10:10:06
873 1082 1 130 12525 40 Bamboo Brush NULL 96032100 2 25.0 110.0 0.0 0.0 88.0 74.58 13.43 220.0 50.0 176.0 9.0 13.43 9.0 13.43 0.0 0.0 74.58 26.85 176.0 INR 0 0.0 0.0 2025-11-10 14:50:14
874 1083 2 130 12525 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-10 14:50:14
875 1084 3 130 12525 38 Dish Wash 500ml NULL 3924101 5 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 425.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 155.93 140.34 920.0 INR 0 0.0 0.0 2025-11-10 14:50:14
876 1085 4 130 12525 39 Fabric Wash 1000ml NULL 3924101 2 150.0 401.0 0.0 0.0 320.8 271.86 48.94 802.0 300.0 641.6 9.0 48.94 9.0 48.94 0.0 0.0 271.86 97.87 641.6 INR 0 0.0 0.0 2025-11-10 14:50:14
877 1086 5 130 12525 19 Fat loss Juice 500 ml NULL 30049011 1 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 1499.0 250.0 1479.0 2.5 35.22 2.5 35.22 0.0 0.0 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-10 14:50:14
878 1087 6 130 12525 33 Herbal Soap 100gm NULL 30049011 50 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1400.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 76.19 190.48 4000.0 INR 0 0.0 0.0 2025-11-10 14:50:14
879 1088 7 130 12525 34 Herbo2o Toothpaste NULL 33061090 15 45.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 675.0 2388.0 9.0 182.13 9.0 182.13 0.0 0.0 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-10 14:50:14
880 1089 8 130 12525 15 Kidney Stone Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-10 14:50:14
881 1090 9 130 12525 16 Liver Care Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-10 14:50:14
882 1091 10 130 12525 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-10 14:50:14
883 1092 11 130 12525 32 Neem Soap 100gm NULL 34011110 60 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3600.0 600.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 45.71 137.14 2880.0 INR 0 0.0 0.0 2025-11-10 14:50:14
884 1093 12 130 12525 41 Premium Coco Body Lotion NULL 3304300 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-10 14:50:14
885 1094 13 130 12525 46 Root Vitality Hair Oil NULL 3305901 15 54.0 255.0 0.0 0.0 204.0 194.29 9.71 3825.0 810.0 3060.0 2.5 72.86 2.5 72.86 0.0 0.0 194.29 145.71 3060.0 INR 0 0.0 0.0 2025-11-10 14:50:14
886 1095 1 131 12543 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-10 15:17:53
887 1096 1 132 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-10 15:38:31
888 1097 1 133 12552 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 9.0 1044.84 9.0 1044.84 0.0 0.0 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-10 16:31:44
889 1098 2 133 12552 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-10 16:31:44
890 1099 1 134 12517 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 0.0 0.0 0.0 0.0 18.0 2089.68 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-10 16:32:36
891 1100 1 135 12517 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 0.0 0.0 0.0 0.0 5.0 190.4 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-10 16:33:45
892 1101 1 136 12532 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-10 18:07:31
893 1102 1 137 12517 74 EXPLORER BOX NULL NULL 4 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 107988.0 0.0 41996.0 0.0 0.0 0.0 0.0 5.0 1999.81 9999.05 1999.81 41996.0 INR 0 0.0 0.0 2025-11-10 18:20:37
894 1103 1 138 12526 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-10 18:33:12
895 1104 1 139 12685 48 glow face wash NULL 3304999 6 250.0 380.0 0.0 0.0 304.0 257.63 46.37 2280.0 1500.0 1824.0 9.0 139.12 9.0 139.12 0.0 0.0 257.63 278.24 1824.0 INR 0 0.0 0.0 2025-11-10 18:55:28
896 1105 2 139 12685 27 Multicharge Cap NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-10 18:55:28
897 1106 3 139 12685 20 Premium Berry Juice 1000ml NULL 2936900 3 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 10497.0 2250.0 10437.0 2.5 248.5 2.5 248.5 0.0 0.0 3313.33 497.0 10437.0 INR 0 0.0 0.0 2025-11-10 18:55:28
898 1107 4 139 12685 61 Radiation chip NULL 902221 1 325.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 325.0 799.2 9.0 60.95 9.0 60.95 0.0 0.0 677.29 121.91 799.2 INR 0 0.0 0.0 2025-11-10 18:55:28
899 1108 5 139 12685 79 ALKALINE JUG NULL 8421 1 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 14999.0 3500.0 11999.2 9.0 915.2 9.0 915.2 0.0 0.0 10168.81 1830.39 11999.2 INR 0 0.0 0.0 2025-11-10 18:55:28
900 1109 6 139 12685 49 Anti Dandruff Serum NULL 3304999 3 250.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 750.0 2397.6 9.0 182.87 9.0 182.87 0.0 0.0 677.29 365.74 2397.6 INR 0 0.0 0.0 2025-11-10 18:55:28