fx_franchise_order_product

4,737 rows · 33 columns · page 45 / 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
2201 2410 6 552 12527 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 0.0 0.0 0.0 0.0 5.0 685.71 45.71 685.71 14400.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2202 2411 7 552 12527 41 Premium Coco Body Lotion NULL 3304300 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 0.0 0.0 0.0 0.0 18.0 426.36 473.73 426.36 2795.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2203 2412 8 552 12527 43 Quench Kiss Lip Balm NULL 3304300 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 2026-01-02 18:05:33
2204 2413 9 552 12527 46 Root Vitality Hair Oil NULL 3305901 20 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 0.0 4080.0 0.0 0.0 0.0 0.0 5.0 194.29 194.29 194.29 4080.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2205 2414 10 552 12527 50 Sun Screen NULL 330499 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 0.0 0.0 0.0 0.0 18.0 426.36 473.73 426.36 2795.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2206 2415 1 553 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 2026-01-02 18:07:44
2207 2416 2 553 12554 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 2026-01-02 18:07:44
2208 2417 3 553 12554 53 Terra care 2 kg NULL 3103100 10 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 15000.0 0.0 11500.0 2.5 273.81 2.5 273.81 0.0 0.0 1095.24 547.62 11500.0 INR 0 0.0 0.0 2026-01-02 18:07:44
2209 2418 1 554 12527 15 KIDNEY CARE JUICE NULL 2009899 3 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1047.0 0.0 837.0 0.0 0.0 0.0 0.0 5.0 39.86 265.71 39.86 837.0 INR 0 0.0 0.0 2026-01-02 18:11:12
2210 2419 2 554 12527 25 Manicalcium Tablets NULL 2009899 5 0.0 399.0 0.0 0.0 319.0 303.81 15.19 1995.0 0.0 1595.0 0.0 0.0 0.0 0.0 5.0 75.95 303.81 75.95 1595.0 INR 0 0.0 0.0 2026-01-02 18:11:12
2211 2420 3 554 12527 53 Terra care 2 kg NULL 3103100 5 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 0.0 5750.0 0.0 0.0 0.0 0.0 5.0 273.81 1095.24 273.81 5750.0 INR 0 0.0 0.0 2026-01-02 18:11:12
2212 2421 1 555 12554 33 Herbal Soap 100gm NULL 30049011 500 0.0 100.0 0.0 0.0 80.0 76.19 3.81 50000.0 0.0 40000.0 2.5 952.38 2.5 952.38 0.0 0.0 76.19 1904.76 40000.0 INR 0 0.0 0.0 2026-01-02 18:21:33
2213 2422 2 555 12554 32 Neem Soap 100gm NULL 34011110 500 0.0 60.0 0.0 0.0 48.0 45.71 2.29 30000.0 0.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 45.71 1142.86 24000.0 INR 0 0.0 0.0 2026-01-02 18:21:33
2214 2423 1 556 12554 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 2026-01-02 18:24:32
2215 2424 2 556 12554 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2216 2425 3 556 12554 19 Fat loss Juice 500 ml NULL 30049011 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 2026-01-02 18:24:32
2217 2426 4 556 12554 41 Premium Coco Body Lotion NULL 3304300 20 0.0 699.0 0.0 0.0 559.0 473.73 85.27 13980.0 0.0 11180.0 9.0 852.71 9.0 852.71 0.0 0.0 473.73 1705.42 11180.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2218 2427 5 556 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 2026-01-02 18:24:32
2219 2428 6 556 12554 46 Root Vitality Hair Oil NULL 3305901 20 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 0.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 2026-01-02 18:24:32
2220 2429 7 556 12554 50 Sun Screen NULL 330499 20 0.0 699.0 0.0 0.0 559.0 473.73 85.27 13980.0 0.0 11180.0 9.0 852.71 9.0 852.71 0.0 0.0 473.73 1705.42 11180.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2221 2430 1 557 12516 62 3*6 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 2026-01-02 18:25:20
2222 2431 1 558 12516 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 5 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 109995.0 0.0 74995.0 1.5 1092.16 1.5 1092.16 0.0 0.0 14562.14 2184.32 74995.0 INR 0 0.0 0.0 2026-01-02 18:33:21
2223 2432 1 559 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 2026-01-02 18:51:12
2224 2433 1 560 13438 62 3*6 BED WITH BRACELET NULL 94041000 4 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 51996.0 0.0 31920.0 0.0 0.0 0.0 0.0 3.0 929.71 7747.57 929.71 31920.0 INR 0 0.0 0.0 2026-01-02 19:04:52
2225 2434 2 560 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 2026-01-02 19:04:52
2226 2435 1 561 12545 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 2026-01-02 20:50:12
2227 2436 1 562 12542 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 0.0 0.0 0.0 0.0 5.0 2.29 45.71 2.29 48.0 INR 0 0.0 0.0 2026-01-02 20:58:55
2228 2437 1 563 12516 65 1 Bracelet NULL 9404 1 0.0 12999.0 0.0 0.0 10500.0 10194.17 305.83 12999.0 0.0 10500.0 1.5 152.91 1.5 152.91 0.0 0.0 10194.17 305.83 10500.0 INR 0 0.0 0.0 2026-01-02 21:12:29
2229 2438 1 564 12516 68 18000 bracelt NULL 9404 25 0.0 23999.0 0.0 0.0 18000.0 17475.73 524.27 599975.0 0.0 450000.0 1.5 6553.4 1.5 6553.4 0.0 0.0 17475.73 13106.8 450000.0 INR 0 0.0 0.0 2026-01-02 21:14:01
2230 2439 2 564 12516 65 1 Bracelet NULL 9404 25 0.0 12999.0 0.0 0.0 10500.0 10194.17 305.83 324975.0 0.0 262500.0 1.5 3822.82 1.5 3822.82 0.0 0.0 10194.17 7645.63 262500.0 INR 0 0.0 0.0 2026-01-02 21:14:01
2231 2440 1 565 12516 68 18000 bracelt NULL 9404 25 0.0 23999.0 0.0 0.0 18000.0 17475.73 524.27 599975.0 0.0 450000.0 1.5 6553.4 1.5 6553.4 0.0 0.0 17475.73 13106.8 450000.0 INR 0 0.0 0.0 2026-01-02 21:15:04
2232 2441 2 565 12516 65 1 Bracelet NULL 9404 25 0.0 12999.0 0.0 0.0 10500.0 10194.17 305.83 324975.0 0.0 262500.0 1.5 3822.82 1.5 3822.82 0.0 0.0 10194.17 7645.63 262500.0 INR 0 0.0 0.0 2026-01-02 21:15:04
2233 2442 1 566 12542 62 3*6 BED WITH BRACELET NULL 94041000 2 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 25998.0 0.0 15960.0 0.0 0.0 0.0 0.0 3.0 464.85 7747.57 464.85 15960.0 INR 0 0.0 0.0 2026-01-02 21:41:09
2234 2443 2 566 12542 12 P RADIANCE FACE SERUM NULL 33049990 10 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 12500.0 0.0 7500.0 0.0 0.0 0.0 0.0 5.0 357.14 714.29 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 21:41:09
2235 2444 1 567 12516 62 3*6 BED WITH BRACELET NULL 94041000 50 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 649950.0 0.0 399000.0 1.5 5810.68 1.5 5810.68 0.0 0.0 7747.57 11621.36 399000.0 INR 0 0.0 0.0 2026-01-02 22:21:33
2236 2445 1 568 12554 62 3*6 BED WITH BRACELET NULL 94041000 50 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 649950.0 0.0 399000.0 1.5 5810.68 1.5 5810.68 0.0 0.0 7747.57 11621.36 399000.0 INR 0 0.0 0.0 2026-01-02 22:23:16
2237 2446 1 569 12555 62 3*6 BED WITH BRACELET NULL 94041000 44 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 571956.0 0.0 351120.0 1.5 5113.4 1.5 5113.4 0.0 0.0 7747.57 10226.8 351120.0 INR 0 0.0 0.0 2026-01-02 22:27:06
2238 2447 1 570 12516 66 Premium Blanket Single NULL 9404 1 0.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 14999.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 23:26:11
2239 2448 1 571 12554 66 Premium Blanket Single NULL 9404 1 0.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 14999.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 23:27:23
2240 2449 1 572 12555 66 Premium Blanket Single NULL 9404 1 0.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 14999.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 23:29:35
2241 2450 1 573 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 1190.48 297.62 6250.0 INR 0 0.0 0.0 2026-01-02 23:39:12
2242 2451 1 574 12555 62 3*6 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.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2026-01-02 23:59:43
2243 2452 1 575 12555 61 Radiation chip NULL 902221 3 0.0 999.0 0.0 0.0 500.0 423.73 76.27 2997.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 423.73 228.81 1500.0 INR 0 0.0 0.0 2026-01-03 14:45:08
2244 2453 1 576 12554 61 Radiation chip NULL 902221 5 0.0 999.0 0.0 0.0 500.0 423.73 76.27 4995.0 0.0 2500.0 9.0 190.68 9.0 190.68 0.0 0.0 423.73 381.36 2500.0 INR 0 0.0 0.0 2026-01-03 16:17:04
2245 2454 1 577 12555 61 Radiation chip NULL 902221 3 0.0 999.0 0.0 0.0 500.0 423.73 76.27 2997.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 423.73 228.81 1500.0 INR 0 0.0 0.0 2026-01-03 16:17:37
2246 2455 1 578 12555 62 3*6 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.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2026-01-03 16:37:10
2247 2456 1 579 12554 55 Grow master 500ml NULL 3105 5 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 10150.0 0.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 1571.43 392.86 8250.0 INR 0 0.0 0.0 2026-01-03 16:46:21
2248 2457 1 580 12555 55 Grow master 500ml NULL 3105 10 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 20300.0 0.0 16500.0 2.5 392.86 2.5 392.86 0.0 0.0 1571.43 785.71 16500.0 INR 0 0.0 0.0 2026-01-03 16:47:15
2249 2458 1 581 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 2026-01-03 18:04:20
2250 2459 1 582 12555 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-03 22:01:43