fx_franchise_order_product

4,737 rows · 33 columns · page 69 / 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
3401 3610 16 868 12552 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-30 21:11:22
3402 3611 1 869 12525 33 Herbal Soap 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 3 2.0 1.52 2026-01-30 22:12:30
3403 3612 1 870 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-01-31 00:12:12
3404 3613 2 870 12526 3 BP Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 00:12:12
3405 3614 3 870 12526 39 Fabric Wash 1000ml NULL 34029099 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-31 00:12:12
3406 3615 4 870 12526 34 Herbo2o Toothpaste NULL 33061090 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-01-31 00:12:12
3407 3616 5 870 12526 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 3 2.0 5.31 2026-01-31 00:12:12
3408 3617 6 870 12526 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 302.86 15.14 318.0 INR 3 2.0 6.06 2026-01-31 00:12:12
3409 3618 7 870 12526 32 Neem Soap 100gm NULL 34011110 15 0.0 60.0 0.0 0.0 48.0 45.71 2.29 900.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 00:12:12
3410 3619 8 870 12526 28 Ortho Joint Shield NULL 2009899 3 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-01-31 00:12:12
3411 3620 9 870 12526 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-01-31 00:12:12
3412 3621 10 870 12526 35 Sanitary Pad (15 pcs) NULL 9619001 3 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 0.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 912.0 0.0 912.0 INR 3 2.0 18.24 2026-01-31 00:12:12
3413 3622 1 871 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 1 0.0 0.0 2026-01-31 13:25:20
3414 3623 1 872 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 2 0.0 0.0 2026-01-31 13:25:59
3415 3624 1 873 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 0.0 0.0 2026-01-31 13:26:38
3416 3625 1 874 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 4 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 74800.0 0.0 42800.0 2.5 1019.05 2.5 1019.05 0.0 0.0 40761.9 2038.1 42800.0 INR 1 0.0 0.0 2026-01-31 13:33:35
3417 3626 1 875 12517 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 0.0 0.0 0.0 0.0 5.0 509.52 10190.48 509.52 10700.0 INR 2 0.0 0.0 2026-01-31 13:39:06
3418 3627 1 876 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 2 0.0 0.0 2026-01-31 13:55:44
3419 3628 1 877 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 0.0 0.0 2026-01-31 13:56:23
3420 3629 1 878 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 17495.0 0.0 13000.0 2.5 309.52 2.5 309.52 0.0 0.0 12380.95 619.05 13000.0 INR 3 2.0 247.62 2026-01-31 14:00:54
3421 3630 1 879 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 2 0.0 0.0 2026-01-31 14:10:48
3422 3631 1 880 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 0.0 0.0 2026-01-31 14:12:23
3423 3632 1 881 12548 38 Dish Wash 500ml NULL 34029099 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-31 15:32:23
3424 3633 2 881 12548 39 Fabric Wash 1000ml NULL 34029099 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-31 15:32:23
3425 3634 3 881 12548 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-31 15:32:23
3426 3635 4 881 12548 33 Herbal Soap 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-31 15:32:23
3427 3636 5 881 12548 34 Herbo2o Toothpaste NULL 33061090 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-31 15:32:23
3428 3637 1 882 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 5 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 93500.0 0.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 1 0.0 0.0 2026-01-31 17:11:37
3429 3638 1 883 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 5 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 93500.0 0.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 2 0.0 0.0 2026-01-31 17:12:05
3430 3639 1 884 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 3 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 56100.0 0.0 32100.0 2.5 764.29 2.5 764.29 0.0 0.0 30571.43 1528.57 32100.0 INR 3 0.0 0.0 2026-01-31 17:12:56
3431 3640 1 885 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 0.0 0.0 2026-01-31 17:16:09
3432 3641 1 886 12534 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-31 17:29:07
3433 3642 1 887 12516 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 20 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 680020.0 0.0 370000.0 2.5 8809.52 2.5 8809.52 0.0 0.0 352380.95 17619.05 370000.0 INR 1 0.0 0.0 2026-01-31 17:30:46
3434 3643 2 887 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 150 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 2805000.0 0.0 1605000.0 2.5 38214.29 2.5 38214.29 0.0 0.0 1528571.43 76428.57 1605000.0 INR 1 0.0 0.0 2026-01-31 17:30:46
3435 3644 1 888 12517 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 100 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 1870000.0 0.0 1070000.0 0.0 0.0 0.0 0.0 5.0 50952.38 1019047.62 50952.38 1070000.0 INR 2 0.0 300.0 2026-01-31 18:55:11
3436 3645 1 889 14490 48 glow face wash NULL 3304999 5 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 0.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-01-31 19:04:03
3437 3646 2 889 14490 61 Radiation chip NULL 902221 2 0.0 999.0 0.0 0.0 500.0 423.73 76.27 1998.0 0.0 1000.0 9.0 76.27 9.0 76.27 0.0 0.0 847.46 152.54 1000.0 INR 3 2.0 16.95 2026-01-31 19:04:03
3438 3647 3 889 14490 32 Neem Soap 100gm NULL 34011110 30 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1800.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-31 19:04:03
3439 3648 1 890 12526 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.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-31 20:09:21
3440 3649 1 891 12526 48 glow face wash NULL 3304999 9 0.0 380.0 0.0 0.0 304.0 257.63 46.37 3420.0 0.0 2736.0 9.0 208.68 9.0 208.68 0.0 0.0 2318.64 417.36 2736.0 INR 3 2.0 46.37 2026-01-31 21:01:36
3441 3650 2 891 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-01-31 21:01:36
3442 3651 3 891 12526 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 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36
3443 3652 4 891 12526 3 BP Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36
3444 3653 5 891 12526 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36
3445 3654 6 891 12526 38 Dish Wash 500ml NULL 34029099 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-31 21:01:36
3446 3655 7 891 12526 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-31 21:01:36
3447 3656 8 891 12526 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-01-31 21:01:36
3448 3657 9 891 12526 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.53 190.48 4000.0 INR 3 2.0 76.19 2026-01-31 21:01:36
3449 3658 10 891 12526 18 Lady Care Juice 500ml NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-31 21:01:36
3450 3659 11 891 12526 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 3 2.0 5.31 2026-01-31 21:01:36