fx_franchise_order_product

4,737 rows · 33 columns · page 42 / 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
2051 2260 3 431 12516 17 Memory Booster Juice NULL 2009899 20 0.0 349.0 0.0 0.0 279.0 265.71 13.29 6980.0 0.0 5580.0 2.5 132.86 2.5 132.86 0.0 0.0 265.71 265.72 5580.0 INR 0 0.0 0.0 2025-12-24 14:47:35
2052 2261 1 432 12554 82 ALKALINE CAPSULE NULL 3402000 50 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 125000.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 1941.75 2912.62 100000.0 INR 0 0.0 0.0 2025-12-24 14:48:30
2053 2262 2 432 12554 15 KIDNEY CARE JUICE NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2025-12-24 14:48:30
2054 2263 3 432 12554 17 Memory Booster Juice NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2025-12-24 14:48:30
2055 2264 1 433 12555 82 ALKALINE CAPSULE NULL 3402000 50 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 125000.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 1941.75 2912.62 100000.0 INR 0 0.0 0.0 2025-12-24 14:50:04
2056 2265 2 433 12555 15 KIDNEY CARE JUICE NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2025-12-24 14:50:04
2057 2266 3 433 12555 17 Memory Booster Juice NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2025-12-24 14:50:04
2058 2267 1 434 12555 20 Premium Berry Juice 1000ml NULL 2936900 10 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 34990.0 0.0 26000.0 2.5 619.05 2.5 619.05 0.0 0.0 2476.19 1238.1 26000.0 INR 0 0.0 0.0 2025-12-24 17:55:29
2059 2268 1 435 12554 20 Premium Berry Juice 1000ml NULL 2936900 10 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 34990.0 0.0 26000.0 2.5 619.05 2.5 619.05 0.0 0.0 2476.19 1238.1 26000.0 INR 0 0.0 0.0 2025-12-24 17:56:00
2060 2269 1 436 13438 38 Dish Wash 500ml NULL 3924101 4 0.0 230.0 0.0 0.0 184.0 155.93 28.07 920.0 0.0 736.0 9.0 56.13 9.0 56.13 0.0 0.0 155.93 112.27 736.0 INR 0 0.0 0.0 2025-12-24 18:38:13
2061 2270 1 437 13438 32 Neem Soap 100gm NULL 34011110 53 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3180.0 0.0 2544.0 2.5 60.57 2.5 60.57 0.0 0.0 45.71 121.14 2544.0 INR 0 0.0 0.0 2025-12-24 18:42:55
2062 2271 1 438 13438 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.91 2.5 61.91 0.0 0.0 2476.19 123.81 2600.0 INR 0 0.0 0.0 2025-12-24 18:50:57
2063 2272 2 438 13438 39 Fabric Wash 1000ml NULL 3924101 4 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1604.0 0.0 1284.0 9.0 97.93 9.0 97.93 0.0 0.0 272.03 195.86 1284.0 INR 0 0.0 0.0 2025-12-24 18:50:57
2064 2273 1 439 13438 37 Floor Cleaner 500ml NULL 3924101 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 134.75 97.02 636.0 INR 0 0.0 0.0 2025-12-24 19:01:38
2065 2274 1 440 13438 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.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-12-24 19:07:42
2066 2275 1 441 13438 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 0 0.0 0.0 2025-12-24 19:10:21
2067 2276 1 442 13438 32 Neem Soap 100gm NULL 34011110 43 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2580.0 0.0 2064.0 2.5 49.15 2.5 49.15 0.0 0.0 45.71 98.29 2064.0 INR 0 0.0 0.0 2025-12-24 19:15:44
2068 2277 1 443 13438 33 Herbal 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 76.19 38.1 800.0 INR 0 0.0 0.0 2025-12-25 12:07:07
2069 2278 1 444 13438 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.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-12-25 12:08:24
2070 2279 1 445 13438 33 Herbal 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 76.19 38.1 800.0 INR 0 0.0 0.0 2025-12-25 12:10:14
2071 2280 2 445 13438 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.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-12-25 12:10:14
2072 2281 1 446 12517 62 3*3 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 0.0 0.0 0.0 0.0 3.0 232.43 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-25 12:15:57
2073 2282 1 447 13438 62 3*3 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.22 1.5 116.22 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-25 12:17:19
2074 2283 1 448 13438 34 Herbo2o 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 134.75 727.63 4770.0 INR 0 0.0 0.0 2025-12-25 12:40:02
2075 2284 1 449 13438 38 Dish Wash 500ml NULL 3924101 10 0.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 0.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 155.93 280.68 1840.0 INR 0 0.0 0.0 2025-12-25 12:41:14
2076 2285 1 450 13438 34 Herbo2o Toothpaste NULL 33061090 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 134.75 242.54 1590.0 INR 0 0.0 0.0 2025-12-25 12:48:56
2077 2286 1 451 12555 4 Diabetic Care Capsules NULL 2936900 5 0.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 685.71 171.43 3600.0 INR 0 0.0 0.0 2025-12-25 12:57:23
2078 2287 1 452 13438 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 151.43 15.14 318.0 INR 0 0.0 0.0 2025-12-25 12:58:02
2079 2288 1 453 13438 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 151.43 37.86 795.0 INR 0 0.0 0.0 2025-12-25 13:02:13
2080 2289 1 454 12555 34 Herbo2o Toothpaste NULL 33061090 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 134.75 485.08 3180.0 INR 0 0.0 0.0 2025-12-25 13:51:34
2081 2290 1 455 12555 62 3*3 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2025-12-25 16:23:34
2082 2291 1 456 12554 79 ALKALINE JUG NULL 8421 5 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 72495.0 0.0 49500.0 9.0 3775.42 9.0 3775.42 0.0 0.0 8389.83 7550.85 49500.0 INR 0 0.0 0.0 2025-12-25 16:28:28
2083 2292 1 457 12516 79 ALKALINE JUG NULL 8421 10 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 144990.0 0.0 99000.0 9.0 7550.85 9.0 7550.85 0.0 0.0 8389.83 15101.69 99000.0 INR 0 0.0 0.0 2025-12-25 16:29:11
2084 2293 1 458 12555 79 ALKALINE JUG NULL 8421 5 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 72495.0 0.0 49500.0 9.0 3775.42 9.0 3775.42 0.0 0.0 8389.83 7550.85 49500.0 INR 0 0.0 0.0 2025-12-25 16:30:55
2085 2294 1 459 12517 62 3*3 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 0.0 0.0 0.0 0.0 3.0 232.43 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-25 17:28:03
2086 2295 1 460 12542 62 3*3 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.22 1.5 116.22 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-25 17:29:03
2087 2296 1 461 12516 62 3*3 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2025-12-26 11:03:16
2088 2297 1 462 12554 62 3*3 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2025-12-26 11:03:51
2089 2298 1 463 12555 62 3*3 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2025-12-26 11:04:14
2090 2299 1 464 12555 26 Spirulina Cap NULL 2009899 10 0.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 0.0 7190.0 2.5 171.19 2.5 171.19 0.0 0.0 684.76 342.38 7190.0 INR 0 0.0 0.0 2025-12-26 12:33:09
2091 2300 1 465 12555 34 Herbo2o Toothpaste NULL 33061090 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 134.75 2425.42 15900.0 INR 0 0.0 0.0 2025-12-26 12:42:38
2092 2301 1 466 12542 32 Neem Soap 100gm NULL 34011110 53 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3180.0 0.0 2544.0 0.0 0.0 0.0 0.0 5.0 121.14 45.71 121.14 2544.0 INR 0 0.0 0.0 2025-12-26 13:42:23
2093 2302 1 467 12555 32 Neem Soap 100gm NULL 34011110 300 0.0 60.0 0.0 0.0 48.0 45.71 2.29 18000.0 0.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 45.71 685.71 14400.0 INR 0 0.0 0.0 2025-12-26 15:16:48
2094 2303 1 468 12555 28 Ortho Joint Shield NULL 2009899 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.43 12000.0 INR 0 0.0 0.0 2025-12-26 15:40:10
2095 2304 1 469 12555 35 Sanitary Pad (15 pcs) NULL 9619001 50 0.0 380.0 0.0 0.0 304.0 304.0 0.0 19000.0 0.0 15200.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 15200.0 INR 0 0.0 0.0 2025-12-26 15:55:05
2096 2305 1 470 12554 35 Sanitary Pad (15 pcs) NULL 9619001 50 0.0 380.0 0.0 0.0 304.0 304.0 0.0 19000.0 0.0 15200.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 15200.0 INR 0 0.0 0.0 2025-12-26 15:55:39
2097 2306 1 471 12516 35 Sanitary Pad (15 pcs) NULL 9619001 50 0.0 380.0 0.0 0.0 304.0 304.0 0.0 19000.0 0.0 15200.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 15200.0 INR 0 0.0 0.0 2025-12-26 15:56:11
2098 2307 1 472 12554 47 Premium Hair Care Shampoo NULL 3305109 20 0.0 699.0 0.0 0.0 559.0 532.38 26.62 13980.0 0.0 11180.0 2.5 266.19 2.5 266.19 0.0 0.0 532.38 532.38 11180.0 INR 0 0.0 0.0 2025-12-26 15:58:24
2099 2308 1 473 12516 47 Premium Hair Care Shampoo NULL 3305109 50 0.0 699.0 0.0 0.0 559.0 532.38 26.62 34950.0 0.0 27950.0 2.5 665.48 2.5 665.48 0.0 0.0 532.38 1330.95 27950.0 INR 0 0.0 0.0 2025-12-26 16:00:38
2100 2309 1 474 12555 47 Premium Hair Care Shampoo NULL 3305109 30 0.0 699.0 0.0 0.0 559.0 532.38 26.62 20970.0 0.0 16770.0 2.5 399.29 2.5 399.29 0.0 0.0 532.38 798.57 16770.0 INR 0 0.0 0.0 2025-12-26 16:01:33