fx_franchise_order_product

4,737 rows · 33 columns · page 43 / 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
2101 2310 1 475 12554 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:02:44
2102 2311 1 476 12551 62 3*3 BED WITH BRACELET NULL 94041000 3 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 38997.0 0.0 23940.0 1.5 348.64 1.5 348.64 0.0 0.0 7747.57 697.28 23940.0 INR 0 0.0 0.0 2025-12-26 17:15:52
2103 2312 1 477 12555 25 Manicalcium Tablets NULL 2009899 10 0.0 399.0 0.0 0.0 319.0 303.81 15.19 3990.0 0.0 3190.0 2.5 75.95 2.5 75.95 0.0 0.0 303.81 151.9 3190.0 INR 0 0.0 0.0 2025-12-26 18:10:18
2104 2313 1 478 13438 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 0.0 0.0 0.0 0.0 18.0 85.27 473.73 85.27 559.0 INR 0 0.0 0.0 2025-12-26 19:17:59
2105 2314 1 479 13438 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 0.0 0.0 0.0 0.0 18.0 39.66 220.34 39.66 260.0 INR 0 0.0 0.0 2025-12-26 19:18:39
2106 2315 1 480 12554 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 0 0.0 0.0 2025-12-26 19:34:29
2107 2316 1 481 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 0.0 0.0 0.0 0.0 5.0 15.14 151.43 15.14 318.0 INR 0 0.0 0.0 2025-12-26 19:41:37
2108 2317 1 482 13438 6 Asthma Care NULL 30049011 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 0.0 0.0 0.0 0.0 5.0 34.29 685.71 34.29 720.0 INR 0 0.0 0.0 2025-12-26 19:42:11
2109 2318 1 483 12554 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 2.5 113.57 2.5 113.57 0.0 0.0 151.43 227.14 4770.0 INR 0 0.0 0.0 2025-12-26 19:43:02
2110 2319 1 484 13438 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 0.0 0.0 0.0 0.0 5.0 26.57 265.71 26.57 558.0 INR 0 0.0 0.0 2025-12-26 19:48:42
2111 2320 1 485 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-26 19:51:05
2112 2321 2 485 12554 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.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-12-26 19:51:05
2113 2322 1 486 13438 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 0.0 0.0 0.0 0.0 5.0 19.43 194.29 19.43 408.0 INR 0 0.0 0.0 2025-12-26 19:56:40
2114 2323 1 487 13438 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 0.0 0.0 0.0 0.0 5.0 26.57 265.71 26.57 558.0 INR 0 0.0 0.0 2025-12-26 19:57:05
2115 2324 1 488 13438 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 0 0.0 0.0 2025-12-26 20:18:03
2116 2325 1 489 13438 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 0.0 0.0 0.0 0.0 18.0 39.66 220.34 39.66 260.0 INR 0 0.0 0.0 2025-12-26 20:21:34
2117 2326 1 490 12554 44 Vital Glow Face Scrub NULL 3304300 10 0.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 0.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-12-26 20:31:42
2118 2327 1 491 12554 48 glow face wash NULL 3304999 20 0.0 380.0 0.0 0.0 304.0 257.63 46.37 7600.0 0.0 6080.0 9.0 463.73 9.0 463.73 0.0 0.0 257.63 927.46 6080.0 INR 0 0.0 0.0 2025-12-26 20:46:03
2119 2328 2 491 12554 43 Quench Kiss Lip Balm NULL 3304300 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-26 20:46:03
2120 2329 1 492 12516 48 glow face wash NULL 3304999 50 0.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 0.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-12-26 20:46:56
2121 2330 2 492 12516 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 0 0.0 0.0 2025-12-26 20:46:56
2122 2331 1 493 12516 43 Quench Kiss Lip Balm NULL 3304300 50 0.0 199.0 0.0 0.0 159.0 134.75 24.25 9950.0 0.0 7950.0 9.0 606.36 9.0 606.36 0.0 0.0 134.75 1212.71 7950.0 INR 0 0.0 0.0 2025-12-26 20:47:16
2123 2332 1 494 12516 81 PREMIUM GLOW FACE WASH NULL 3404 100 0.0 699.0 0.0 0.0 559.0 512.84 46.16 69900.0 0.0 55900.0 4.5 2307.8 4.5 2307.8 0.0 0.0 512.84 4615.6 55900.0 INR 0 0.0 0.0 2025-12-26 20:51:57
2124 2333 1 495 12554 81 PREMIUM GLOW FACE WASH NULL 3404 50 0.0 699.0 0.0 0.0 559.0 512.84 46.16 34950.0 0.0 27950.0 4.5 1153.9 4.5 1153.9 0.0 0.0 512.84 2307.8 27950.0 INR 0 0.0 0.0 2025-12-26 20:52:46
2125 2334 1 496 12554 81 PREMIUM GLOW FACE WASH NULL 3404 10 0.0 699.0 0.0 0.0 559.0 512.84 46.16 6990.0 0.0 5590.0 4.5 230.78 4.5 230.78 0.0 0.0 512.84 461.56 5590.0 INR 0 0.0 0.0 2025-12-26 21:22:15
2126 2335 1 497 12555 57 Safe guard 250ml NULL 3105 10 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 25000.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 1761.9 880.95 18500.0 INR 0 0.0 0.0 2025-12-26 21:35:30
2127 2336 1 498 12555 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-12-26 21:38:56
2128 2337 1 499 12517 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 0.0 0.0 0.0 0.0 9.0 46.16 512.84 46.16 559.0 INR 0 0.0 0.0 2025-12-26 21:57:14
2129 2338 1 500 13438 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 0.0 0.0 0.0 0.0 5.0 380.95 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-12-26 22:14:06
2130 2339 2 500 13438 32 Neem Soap 100gm NULL 34011110 60 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3600.0 0.0 2880.0 0.0 0.0 0.0 0.0 5.0 137.14 45.71 137.14 2880.0 INR 0 0.0 0.0 2025-12-26 22:14:06
2131 2340 1 501 12555 43 Quench Kiss Lip Balm NULL 3304300 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-26 22:30:02
2132 2341 1 502 12555 37 Floor Cleaner 500ml NULL 3924101 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-26 22:41:03
2133 2342 1 503 12542 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 1142.86 114.29 2400.0 INR 0 0.0 0.0 2025-12-26 22:59:07
2134 2343 2 503 12542 41 Premium Coco Body Lotion NULL 3304300 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 0.0 0.0 0.0 0.0 18.0 170.54 473.73 170.54 1118.0 INR 0 0.0 0.0 2025-12-26 22:59:07
2135 2344 3 503 12542 1 Stem Cell Powder NULL 2936900 2 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 4998.0 0.0 3998.0 0.0 0.0 0.0 0.0 5.0 190.38 1903.81 190.38 3998.0 INR 0 0.0 0.0 2025-12-26 22:59:07
2136 2345 1 504 12555 62 3*6 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-26 23:11:55
2137 2346 1 505 12554 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-12-27 08:43:06
2138 2347 2 505 12554 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 45.71 228.57 4800.0 INR 0 0.0 0.0 2025-12-27 08:43:06
2139 2348 3 505 12554 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 50 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 62500.0 0.0 37500.0 2.5 892.86 2.5 892.86 0.0 0.0 714.29 1785.71 37500.0 INR 0 0.0 0.0 2025-12-27 08:43:06
2140 2349 1 506 12516 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 50 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 62500.0 0.0 37500.0 2.5 892.86 2.5 892.86 0.0 0.0 714.29 1785.71 37500.0 INR 0 0.0 0.0 2025-12-27 08:44:34
2141 2350 1 507 12555 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-12-27 09:15:36
2142 2351 2 507 12555 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 45.71 228.57 4800.0 INR 0 0.0 0.0 2025-12-27 09:15:36
2143 2352 3 507 12555 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 10 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 12500.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 714.29 357.14 7500.0 INR 0 0.0 0.0 2025-12-27 09:15:36
2144 2353 1 508 12542 38 Dish Wash 500ml NULL 3924101 20 0.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 0.0 3680.0 0.0 0.0 0.0 0.0 18.0 561.36 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-12-27 16:47:29
2145 2354 2 508 12542 37 Floor Cleaner 500ml NULL 3924101 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 0.0 0.0 0.0 0.0 18.0 485.08 134.75 485.08 3180.0 INR 0 0.0 0.0 2025-12-27 16:47:29
2146 2355 3 508 12542 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 0.0 0.0 0.0 0.0 5.0 380.95 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-12-27 16:47:29
2147 2356 4 508 12542 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 0.0 0.0 0.0 0.0 18.0 242.54 134.75 242.54 1590.0 INR 0 0.0 0.0 2025-12-27 16:47:29
2148 2357 5 508 12542 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 0.0 0.0 0.0 0.0 5.0 37.86 151.43 37.86 795.0 INR 0 0.0 0.0 2025-12-27 16:47:29
2149 2358 6 508 12542 32 Neem Soap 100gm NULL 34011110 200 0.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 0.0 9600.0 0.0 0.0 0.0 0.0 5.0 457.14 45.71 457.14 9600.0 INR 0 0.0 0.0 2025-12-27 16:47:29
2150 2359 7 508 12542 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 101.69 366.1 2400.0 INR 0 0.0 0.0 2025-12-27 16:47:29