fx_franchise_order_product

4,737 rows · 33 columns · page 3 / 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
101 310 18 65 12526 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-07 19:52:39
102 311 19 65 12526 43 Quench Kiss Lip Balm NULL 3304300 4 35.0 199.0 0.0 0.0 159.2 134.92 24.29 796.0 140.0 636.8 9.0 48.57 9.0 48.57 0.0 0.0 134.92 97.14 636.8 INR 0 0.0 0.0 2025-11-07 19:52:39
103 312 20 65 12526 46 Root Vitality Hair Oil NULL 3305901 1 54.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 54.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 0 0.0 0.0 2025-11-07 19:52:39
104 313 21 65 12526 35 Sanitary Pad (15 pcs) NULL 9619001 22 40.0 380.0 0.0 0.0 304.0 304.0 0.0 8360.0 880.0 6688.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 6688.0 INR 0 0.0 0.0 2025-11-07 19:52:39
105 314 22 65 12526 26 Spirulina Cap NULL 2009899 6 190.0 899.0 0.0 0.0 719.2 684.95 34.25 5394.0 1140.0 4315.2 2.5 102.75 2.5 102.75 0.0 0.0 684.95 205.49 4315.2 INR 0 0.0 0.0 2025-11-07 19:52:39
106 315 23 65 12526 50 Sun Screen NULL 330499 11 250.0 699.0 0.0 0.0 559.2 473.9 85.3 7689.0 2750.0 6151.2 9.0 469.16 9.0 469.16 0.0 0.0 473.9 938.32 6151.2 INR 0 0.0 0.0 2025-11-07 19:52:39
107 316 24 65 12526 36 Toilet Cleaner 500ml NULL 3924101 2 30.0 150.0 0.0 0.0 120.0 101.69 18.3 300.0 60.0 240.0 9.0 18.3 9.0 18.3 0.0 0.0 101.69 36.61 240.0 INR 0 0.0 0.0 2025-11-07 19:52:39
108 317 25 65 12526 44 Vital Glow Face Scrub NULL 3304300 10 71.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 710.0 2600.0 9.0 198.31 9.0 198.31 0.0 0.0 220.34 396.61 2600.0 INR 0 0.0 0.0 2025-11-07 19:52:39
109 318 26 65 12526 11 Vitamin B12 Drop NULL 2106909 4 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2996.0 760.0 2396.8 2.5 57.06 2.5 57.06 0.0 0.0 570.67 114.13 2396.8 INR 0 0.0 0.0 2025-11-07 19:52:39
110 319 27 65 12526 10 Vitamin D3 Drop NULL 2106909 4 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2996.0 760.0 2396.8 2.5 57.06 2.5 57.06 0.0 0.0 570.67 114.13 2396.8 INR 0 0.0 0.0 2025-11-07 19:52:39
111 320 1 66 12536 48 glow face wash NULL 3304999 1 250.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 250.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 0 0.0 0.0 2025-11-07 20:05:13
112 321 2 66 12536 70 Premium Hand belt NULL 9404 2 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.92 19998.0 1200.0 15998.4 2.5 380.92 2.5 380.92 0.0 0.0 7618.29 761.83 15998.4 INR 0 0.0 0.0 2025-11-07 20:05:13
113 322 3 66 12536 61 Radiation chip NULL 902221 2 325.0 999.0 0.0 0.0 799.2 677.29 121.91 1998.0 650.0 1598.4 9.0 121.91 9.0 121.91 0.0 0.0 677.29 243.82 1598.4 INR 0 0.0 0.0 2025-11-07 20:05:13
114 323 4 66 12536 40 Bamboo Brush NULL 96032100 5 25.0 110.0 0.0 0.0 88.0 74.58 13.42 550.0 125.0 440.0 9.0 33.56 9.0 33.56 0.0 0.0 74.58 67.12 440.0 INR 0 0.0 0.0 2025-11-07 20:05:13
115 324 5 66 12536 38 Dish Wash 500ml NULL 3924101 1 85.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 85.0 184.0 9.0 14.04 9.0 14.04 0.0 0.0 155.93 28.07 184.0 INR 0 0.0 0.0 2025-11-07 20:05:13
116 325 6 66 12536 39 Fabric Wash 1000ml NULL 3924101 1 150.0 401.0 0.0 0.0 320.8 271.86 48.94 401.0 150.0 320.8 9.0 24.47 9.0 24.47 0.0 0.0 271.86 48.94 320.8 INR 0 0.0 0.0 2025-11-07 20:05:13
117 326 7 66 12536 37 Floor Cleaner 500ml NULL 3924101 1 80.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 80.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-07 20:05:13
118 327 8 66 12536 60 Foot patch NULL 30051090 1 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 1999.0 500.0 1599.2 2.5 38.08 2.5 38.08 0.0 0.0 1523.05 76.15 1599.2 INR 0 0.0 0.0 2025-11-07 20:05:13
119 328 9 66 12536 33 Herbal Soap 100gm NULL 30049011 21 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2100.0 588.0 1680.0 2.5 40.0 2.5 40.0 0.0 0.0 76.19 80.0 1680.0 INR 0 0.0 0.0 2025-11-07 20:05:13
120 329 10 66 12536 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-07 20:05:13
121 330 11 66 12536 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-07 20:05:13
122 331 12 66 12536 25 Manicalcium Tablets NULL 2009899 1 95.0 399.0 0.0 0.0 319.2 304.0 15.2 399.0 95.0 319.2 2.5 7.6 2.5 7.6 0.0 0.0 304.0 15.2 319.2 INR 0 0.0 0.0 2025-11-07 20:05:13
123 332 13 66 12536 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:05:13
124 333 14 66 12536 7 Morning Fresh Churan NULL 30049011 1 40.0 199.0 0.0 0.0 159.2 151.62 7.58 199.0 40.0 159.2 2.5 3.79 2.5 3.79 0.0 0.0 151.62 7.58 159.2 INR 0 0.0 0.0 2025-11-07 20:05:13
125 334 15 66 12536 32 Neem Soap 100gm NULL 34011110 110 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6600.0 1100.0 5280.0 2.5 125.72 2.5 125.72 0.0 0.0 45.71 251.43 5280.0 INR 0 0.0 0.0 2025-11-07 20:05:13
126 335 16 66 12536 9 Omega 369 NULL 2936900 3 260.0 999.0 0.0 0.0 799.2 761.14 38.06 2997.0 780.0 2397.6 2.5 57.09 2.5 57.09 0.0 0.0 761.14 114.17 2397.6 INR 0 0.0 0.0 2025-11-07 20:05:13
127 336 17 66 12536 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-07 20:05:13
128 337 18 66 12536 8 Piles Care NULL 30049011 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-07 20:05:13
129 338 19 66 12536 47 Premium Hair Care Shampoo NULL 3305109 5 150.0 699.0 0.0 0.0 559.2 532.57 26.63 3495.0 750.0 2796.0 2.5 66.57 2.5 66.57 0.0 0.0 532.57 133.14 2796.0 INR 0 0.0 0.0 2025-11-07 20:05:13
130 339 20 66 12536 45 Premium radiance face serum NULL 3304991 1 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 1200.0 300.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 813.56 146.44 960.0 INR 0 0.0 0.0 2025-11-07 20:05:13
131 340 21 66 12536 43 Quench Kiss Lip Balm NULL 3304300 4 35.0 199.0 0.0 0.0 159.2 134.92 24.29 796.0 140.0 636.8 9.0 48.57 9.0 48.57 0.0 0.0 134.92 97.14 636.8 INR 0 0.0 0.0 2025-11-07 20:05:13
132 341 22 66 12536 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-07 20:05:13
133 342 23 66 12536 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-07 20:05:13
134 343 24 66 12536 26 Spirulina Cap NULL 2009899 4 190.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 760.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-07 20:05:13
135 344 25 66 12536 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 20:05:13
136 345 26 66 12536 36 Toilet Cleaner 500ml NULL 3924101 7 30.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 210.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 101.69 128.14 840.0 INR 0 0.0 0.0 2025-11-07 20:05:13
137 346 1 67 12528 70 Premium Hand belt NULL 9404 2 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.92 19998.0 1200.0 15998.4 2.5 380.92 2.5 380.92 0.0 0.0 7618.29 761.83 15998.4 INR 0 0.0 0.0 2025-11-07 20:12:29
138 347 2 67 12528 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-07 20:12:29
139 348 3 67 12528 49 Anti Dandruff Serum NULL 3304999 1 250.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 250.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-07 20:12:29
140 349 4 67 12528 6 Asthma Care NULL 30049011 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-07 20:12:29
141 350 5 67 12528 40 Bamboo Brush NULL 96032100 7 25.0 110.0 0.0 0.0 88.0 74.58 13.42 770.0 175.0 616.0 9.0 46.98 9.0 46.98 0.0 0.0 74.58 93.97 616.0 INR 0 0.0 0.0 2025-11-07 20:12:29
142 351 6 67 12528 3 BP Care Capsules NULL 2936900 1 160.0 599.0 0.0 0.0 479.2 456.38 22.82 599.0 160.0 479.2 2.5 11.41 2.5 11.41 0.0 0.0 456.38 22.82 479.2 INR 0 0.0 0.0 2025-11-07 20:12:29
143 352 7 67 12528 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-07 20:12:29
144 353 8 67 12528 38 Dish Wash 500ml NULL 3924101 7 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1610.0 595.0 1288.0 9.0 98.23 9.0 98.23 0.0 0.0 155.93 196.47 1288.0 INR 0 0.0 0.0 2025-11-07 20:12:29
145 354 9 67 12528 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-07 20:12:29
146 355 10 67 12528 37 Floor Cleaner 500ml NULL 3924101 12 80.0 199.0 0.0 0.0 159.2 134.92 24.29 2388.0 960.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-07 20:12:29
147 356 11 67 12528 33 Herbal Soap 100gm NULL 30049011 1 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 28.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 0 0.0 0.0 2025-11-07 20:12:29
148 357 12 67 12528 34 Herbo2o Toothpaste NULL 33061090 19 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3781.0 855.0 3024.8 9.0 230.71 9.0 230.71 0.0 0.0 134.92 461.41 3024.8 INR 0 0.0 0.0 2025-11-07 20:12:29
149 358 13 67 12528 16 Liver Care Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:12:29
150 359 14 67 12528 7 Morning Fresh Churan NULL 30049011 2 40.0 199.0 0.0 0.0 159.2 151.62 7.58 398.0 80.0 318.4 2.5 7.58 2.5 7.58 0.0 0.0 151.62 15.16 318.4 INR 0 0.0 0.0 2025-11-07 20:12:29