fx_franchise_order_product

4,737 rows · 33 columns · page 19 / 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
901 1110 7 139 12685 38 Dish Wash 500ml NULL 3924101 6 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1380.0 510.0 1104.0 9.0 84.2 9.0 84.2 0.0 0.0 155.93 168.41 1104.0 INR 0 0.0 0.0 2025-11-10 18:55:28
902 1111 8 139 12685 39 Fabric Wash 1000ml NULL 3924101 12 150.0 401.0 0.0 0.0 320.8 271.86 48.94 4812.0 1800.0 3849.6 9.0 293.62 9.0 293.62 0.0 0.0 271.86 587.23 3849.6 INR 0 0.0 0.0 2025-11-10 18:55:28
903 1112 9 139 12685 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-10 18:55:28
904 1113 10 139 12685 33 Herbal Soap 100gm NULL 30049011 100 28.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 2800.0 8000.0 2.5 190.47 2.5 190.47 0.0 0.0 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-11-10 18:55:28
905 1114 11 139 12685 34 Herbo2o Toothpaste NULL 33061090 12 45.0 199.0 0.0 0.0 159.2 134.92 24.29 2388.0 540.0 1910.4 9.0 145.71 9.0 145.71 0.0 0.0 134.92 291.42 1910.4 INR 0 0.0 0.0 2025-11-10 18:55:28
906 1115 12 139 12685 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 18:55:28
907 1116 13 139 12685 28 Ortho Joint Shield NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-10 18:55:28
908 1117 14 139 12685 11 Vitamin B12 Drop NULL 2106909 6 190.0 749.0 0.0 0.0 599.2 570.67 28.53 4494.0 1140.0 3595.2 2.5 85.6 2.5 85.6 0.0 0.0 570.67 171.2 3595.2 INR 0 0.0 0.0 2025-11-10 18:55:28
909 1118 15 139 12685 10 Vitamin D3 Drop NULL 2106909 6 190.0 749.0 0.0 0.0 599.2 570.67 28.53 4494.0 1140.0 3595.2 2.5 85.6 2.5 85.6 0.0 0.0 570.67 171.2 3595.2 INR 0 0.0 0.0 2025-11-10 18:55:28
910 1119 16 139 12685 54 Wonder grow 100ml NULL 3105 3 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 4200.0 1500.0 3360.0 2.5 80.0 2.5 80.0 0.0 0.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-10 18:55:28
911 1120 1 140 12517 74 EXPLORER BOX NULL NULL 5 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 134985.0 0.0 52495.0 0.0 0.0 0.0 0.0 5.0 2499.76 9999.05 2499.76 52495.0 INR 0 0.0 0.0 2025-11-10 19:06:03
912 1121 1 141 12536 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 19:27:00
913 1122 1 142 12529 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 19:45:02
914 1123 1 143 12529 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-10 19:46:03
915 1124 1 144 12533 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 20:08:36
916 1125 1 145 12542 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 22:10:59
917 1126 1 146 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-10 22:25:50
918 1127 1 147 12544 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-11 08:05:05
919 1128 1 148 12557 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-11 11:23:26
920 1129 1 149 12523 48 glow face wash NULL 3304999 5 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 1250.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 257.63 231.86 1520.0 INR 0 0.0 0.0 2025-11-11 13:11:59
921 1130 2 149 12523 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-11 13:11:59
922 1131 3 149 12523 37 Floor Cleaner 500ml NULL 3924101 40 80.0 199.0 0.0 0.0 159.2 134.92 24.28 7960.0 3200.0 6368.0 9.0 485.69 9.0 485.69 0.0 0.0 134.92 971.39 6368.0 INR 0 0.0 0.0 2025-11-11 13:11:59
923 1132 4 149 12523 2 Heart Care Capsules NULL 2936900 1 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 425.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-11 13:11:59
924 1133 5 149 12523 34 Herbo2o Toothpaste NULL 33061090 3 45.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 135.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-11 13:11:59
925 1134 6 149 12523 30 Iron Capsules NULL 30049011 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-11 13:11:59
926 1135 7 149 12523 18 Lady Care Juice 500ml NULL 2009899 1 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 250.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-11 13:11:59
927 1136 8 149 12523 28 Ortho Joint Shield NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-11 13:11:59
928 1137 9 149 12523 42 Premium Glow Charm Fairness Cream NULL 33049990 6 80.0 399.0 0.0 0.0 319.2 270.51 48.69 2394.0 480.0 1915.2 9.0 146.07 9.0 146.07 0.0 0.0 270.51 292.15 1915.2 INR 0 0.0 0.0 2025-11-11 13:11:59
929 1138 10 149 12523 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 2.5 13.31 2.5 13.31 0.0 0.0 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-11 13:11:59
930 1139 11 149 12523 43 Quench Kiss Lip Balm NULL 3304300 2 35.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 70.0 318.4 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-11 13:11:59
931 1140 12 149 12523 46 Root Vitality Hair Oil NULL 3305901 10 54.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 540.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 194.29 97.14 2040.0 INR 0 0.0 0.0 2025-11-11 13:11:59
932 1141 13 149 12523 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-11 13:11:59
933 1142 1 150 12534 4 Diabetic Care Capsules NULL 2936900 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-11 13:16:22
934 1143 2 150 12534 37 Floor Cleaner 500ml NULL 3924101 8 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 640.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 13:16:22
935 1144 3 150 12534 34 Herbo2o Toothpaste NULL 33061090 7 45.0 199.0 0.0 0.0 159.2 134.92 24.28 1393.0 315.0 1114.4 9.0 85.0 9.0 85.0 0.0 0.0 134.92 169.99 1114.4 INR 0 0.0 0.0 2025-11-11 13:16:22
936 1145 4 150 12534 16 Liver Care Juice NULL 2009899 2 120.0 349.0 0.0 0.0 279.2 265.9 13.29 698.0 240.0 558.4 2.5 13.29 2.5 13.29 0.0 0.0 265.9 26.59 558.4 INR 0 0.0 0.0 2025-11-11 13:16:22
937 1146 5 150 12534 7 Morning Fresh Churan NULL 30049011 8 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1592.0 320.0 1273.6 2.5 30.32 2.5 30.32 0.0 0.0 151.62 60.65 1273.6 INR 0 0.0 0.0 2025-11-11 13:16:22
938 1147 6 150 12534 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-11 13:16:22
939 1148 7 150 12534 8 Piles Care NULL 30049011 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-11 13:16:22
940 1149 8 150 12534 43 Quench Kiss Lip Balm NULL 3304300 8 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 280.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 13:16:22
941 1150 9 150 12534 46 Root Vitality Hair Oil NULL 3305901 6 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 324.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 194.29 58.29 1224.0 INR 0 0.0 0.0 2025-11-11 13:16:22
942 1151 10 150 12534 36 Toilet Cleaner 500ml NULL 3924101 10 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1500.0 300.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 101.69 183.05 1200.0 INR 0 0.0 0.0 2025-11-11 13:16:22
943 1152 1 151 12518 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-11 13:21:49
944 1153 1 152 12532 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-11 13:39:46
945 1154 2 152 12532 37 Floor Cleaner 500ml NULL 3924101 5 80.0 199.0 0.0 0.0 159.2 134.92 24.28 995.0 400.0 796.0 9.0 60.71 9.0 60.71 0.0 0.0 134.92 121.42 796.0 INR 0 0.0 0.0 2025-11-11 13:39:46
946 1155 3 152 12532 60 Foot patch NULL 30051090 5 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 9995.0 2500.0 7996.0 2.5 190.38 2.5 190.38 0.0 0.0 1523.05 380.76 7996.0 INR 0 0.0 0.0 2025-11-11 13:39:46
947 1156 4 152 12532 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-11 13:39:46
948 1157 5 152 12532 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-11 13:39:46
949 1158 6 152 12532 36 Toilet Cleaner 500ml NULL 3924101 5 30.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 150.0 600.0 9.0 45.77 9.0 45.77 0.0 0.0 101.69 91.53 600.0 INR 0 0.0 0.0 2025-11-11 13:39:46
950 1159 1 153 12542 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 29997.0 1800.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-11 13:44:53