fx_franchise_order_product

4,737 rows · 33 columns · page 72 / 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
3551 3760 8 919 12517 34 Toothpaste NULL 33061090 73 0.0 199.0 0.0 0.0 159.0 134.75 24.25 14527.0 0.0 11607.0 0.0 0.0 0.0 0.0 18.0 1770.56 9836.44 1770.56 11607.0 INR 2 6.0 590.19 2026-02-07 16:08:59
3552 3761 1 920 12516 79 ALKALINE JAR NULL 8421 2 0.0 14499.0 0.0 0.0 9900.0 9428.57 471.43 28998.0 0.0 19800.0 2.5 471.43 2.5 471.43 0.0 0.0 18857.14 942.86 19800.0 INR 1 0.0 0.0 2026-02-07 16:10:17
3553 3762 2 920 12516 9 Omega 369 NULL 2936900 20 0.0 999.0 0.0 0.0 720.0 685.71 34.29 19980.0 0.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 13714.29 685.71 14400.0 INR 1 8.0 1097.14 2026-02-07 16:10:17
3554 3763 1 921 12517 79 ALKALINE JAR NULL 8421 1 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 14499.0 0.0 9900.0 0.0 0.0 0.0 0.0 18.0 1510.17 8389.83 1510.17 9900.0 INR 2 6.0 503.39 2026-02-07 16:12:17
3555 3764 1 922 12517 31 Vegan Plant Protein Powder NULL 21061000 1 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 2999.0 0.0 2000.0 0.0 0.0 0.0 0.0 5.0 95.24 1904.76 95.24 2000.0 INR 2 6.0 114.29 2026-02-07 16:19:38
3556 3765 2 922 12517 4 Diabetic Care Capsules NULL 2936900 6 0.0 999.0 0.0 0.0 720.0 685.71 34.29 5994.0 0.0 4320.0 0.0 0.0 0.0 0.0 5.0 205.71 4114.29 205.71 4320.0 INR 2 6.0 246.86 2026-02-07 16:19:38
3557 3766 3 922 12517 15 KIDNEY CARE JUICE NULL 2009899 9 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3141.0 0.0 2511.0 0.0 0.0 0.0 0.0 5.0 119.57 2391.43 119.57 2511.0 INR 2 6.0 143.49 2026-02-07 16:19:38
3558 3767 4 922 12517 18 Lady Care Juice 500ml NULL 2009899 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 2285.71 114.29 2400.0 INR 2 6.0 137.14 2026-02-07 16:19:38
3559 3768 5 922 12517 16 Liver Care Juice NULL 2009899 6 0.0 349.0 0.0 0.0 279.0 265.71 13.29 2094.0 0.0 1674.0 0.0 0.0 0.0 0.0 5.0 79.71 1594.29 79.71 1674.0 INR 2 6.0 95.66 2026-02-07 16:19:38
3560 3769 6 922 12517 17 Memory Booster Juice NULL 2009899 9 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3141.0 0.0 2511.0 0.0 0.0 0.0 0.0 5.0 119.57 2391.43 119.57 2511.0 INR 2 6.0 143.49 2026-02-07 16:19:38
3561 3770 7 922 12517 9 Omega 369 NULL 2936900 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 2 6.0 41.14 2026-02-07 16:19:38
3562 3771 8 922 12517 8 Piles Care NULL 30049011 4 0.0 999.0 0.0 0.0 720.0 685.71 34.29 3996.0 0.0 2880.0 0.0 0.0 0.0 0.0 5.0 137.14 2742.86 137.14 2880.0 INR 2 6.0 164.57 2026-02-07 16:19:38
3563 3772 9 922 12517 1 Stem Cell Powder NULL 2936900 140 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 349860.0 0.0 279860.0 0.0 0.0 0.0 0.0 5.0 13326.67 266533.33 13326.67 279860.0 INR 2 6.0 15992.0 2026-02-07 16:19:38
3564 3773 1 923 12517 33 HALDI CHANDAN SOAP 100gm NULL 30049011 79 0.0 100.0 0.0 0.0 80.0 76.19 3.81 7900.0 0.0 6320.0 0.0 0.0 0.0 0.0 5.0 300.95 6019.05 300.95 6320.0 INR 2 6.0 361.14 2026-02-07 16:20:22
3565 3774 2 923 12517 32 Neem Soap 100gm NULL 34011110 454 0.0 60.0 0.0 0.0 48.0 45.71 2.29 27240.0 0.0 21792.0 0.0 0.0 0.0 0.0 5.0 1037.71 20754.29 1037.71 21792.0 INR 2 6.0 1245.26 2026-02-07 16:20:22
3566 3775 1 924 12517 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 0.0 0.0 0.0 0.0 5.0 297.62 5952.38 297.62 6250.0 INR 2 5.0 297.62 2026-02-07 16:21:22
3567 3776 2 924 12517 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 5476.19 273.81 5750.0 INR 2 5.0 273.81 2026-02-07 16:21:22
3568 3777 3 924 12517 54 Wonder grow 100ml NULL 3105 48 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 67200.0 0.0 57600.0 0.0 0.0 0.0 0.0 5.0 2742.86 54857.14 2742.86 57600.0 INR 2 5.0 2742.86 2026-02-07 16:21:22
3569 3778 1 925 12516 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 9474.58 1705.42 11180.0 INR 1 8.0 757.97 2026-02-07 16:25:00
3570 3779 2 925 12516 1 Stem Cell Powder NULL 2936900 120 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 299880.0 0.0 239880.0 2.5 5711.43 2.5 5711.43 0.0 0.0 228457.14 11422.86 239880.0 INR 1 8.0 18276.57 2026-02-07 16:25:00
3571 3780 3 925 12516 54 Wonder grow 100ml NULL 3105 30 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 42000.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 34285.71 1714.29 36000.0 INR 1 8.0 2742.86 2026-02-07 16:25:00
3572 3781 1 926 12517 35 Sanitary Pad (15 pcs) NULL 9619001 28 0.0 380.0 0.0 0.0 304.0 304.0 0.0 10640.0 0.0 8512.0 0.0 0.0 0.0 0.0 0.0 0.0 8512.0 0.0 8512.0 INR 2 6.0 510.72 2026-02-07 16:54:50
3573 3782 2 926 12517 36 Toilet Cleaner 500ml NULL 3924101 9 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1350.0 0.0 1080.0 0.0 0.0 0.0 0.0 18.0 164.75 915.25 164.75 1080.0 INR 2 5.0 45.76 2026-02-07 16:54:50
3574 3783 1 927 12685 11 BRINGRAJ & SHIKAKAI NULL 33051090 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-02-09 11:31:19
3575 3784 2 927 12685 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.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-02-09 11:31:19
3576 3785 3 927 12685 31 Vegan Plant Protein Powder NULL 21061000 2 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 5998.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-02-09 11:31:19
3577 3786 4 927 12685 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-02-09 11:31:19
3578 3787 5 927 12685 79 ALKALINE JAR NULL 8421 1 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 14499.0 0.0 9900.0 9.0 755.08 9.0 755.08 0.0 0.0 8389.83 1510.17 9900.0 INR 3 2.0 167.8 2026-02-09 11:31:19
3579 3788 6 927 12685 6 Asthma Care NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-02-09 11:31:19
3580 3789 7 927 12685 38 Dish Wash 500ml NULL 34029099 15 0.0 230.0 0.0 0.0 184.0 155.93 28.07 3450.0 0.0 2760.0 9.0 210.51 9.0 210.51 0.0 0.0 2338.98 421.02 2760.0 INR 3 2.0 46.78 2026-02-09 11:31:19
3581 3790 8 927 12685 39 Fabric Wash 1000ml NULL 34029099 12 0.0 401.0 0.0 0.0 321.0 272.03 48.97 4812.0 0.0 3852.0 9.0 293.8 9.0 293.8 0.0 0.0 3264.41 587.59 3852.0 INR 3 2.0 65.29 2026-02-09 11:31:19
3582 3791 9 927 12685 37 Floor Cleaner 500ml NULL 3924101 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-02-09 11:31:19
3583 3792 10 927 12685 33 HALDI CHANDAN SOAP 100gm NULL 30049011 200 0.0 100.0 0.0 0.0 80.0 76.19 3.81 20000.0 0.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.1 761.9 16000.0 INR 3 2.0 304.76 2026-02-09 11:31:19
3584 3793 11 927 12685 30 Iron Capsules NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-02-09 11:31:19
3585 3794 12 927 12685 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-02-09 11:31:19
3586 3795 13 927 12685 16 Liver Care Juice NULL 2009899 4 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1396.0 0.0 1116.0 2.5 26.57 2.5 26.57 0.0 0.0 1062.86 53.14 1116.0 INR 3 2.0 21.26 2026-02-09 11:31:19
3587 3796 14 927 12685 25 Manicalcium Tablets NULL 2009899 2 0.0 399.0 0.0 0.0 319.0 303.81 15.19 798.0 0.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 607.62 30.38 638.0 INR 3 2.0 12.15 2026-02-09 11:31:19
3588 3797 15 927 12685 17 Memory Booster Juice NULL 2009899 4 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1396.0 0.0 1116.0 2.5 26.57 2.5 26.57 0.0 0.0 1062.86 53.14 1116.0 INR 3 2.0 21.26 2026-02-09 11:31:19
3589 3798 16 927 12685 7 Morning Fresh Churan NULL 30049011 7 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1393.0 0.0 1113.0 2.5 26.5 2.5 26.5 0.0 0.0 1060.0 53.0 1113.0 INR 3 2.0 21.2 2026-02-09 11:31:19
3590 3799 17 927 12685 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 13714.29 685.71 14400.0 INR 3 2.0 274.29 2026-02-09 11:31:19
3591 3800 18 927 12685 9 Omega 369 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-02-09 11:31:19
3592 3801 19 927 12685 8 Piles Care NULL 30049011 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.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-02-09 11:31:19
3593 3802 20 927 12685 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 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-02-09 11:31:19
3594 3803 21 927 12685 81 PREMIUM GLOW FACE WASH NULL 3404 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-02-09 11:31:19
3595 3804 22 927 12685 47 Premium Hair Care Shampoo NULL 3305109 4 0.0 699.0 0.0 0.0 559.0 532.38 26.62 2796.0 0.0 2236.0 2.5 53.24 2.5 53.24 0.0 0.0 2129.52 106.48 2236.0 INR 3 2.0 42.59 2026-02-09 11:31:19
3596 3805 23 927 12685 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-02-09 11:31:19
3597 3806 24 927 12685 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-02-09 11:31:19
3598 3807 25 927 12685 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-02-09 11:31:19
3599 3808 26 927 12685 46 Root Vitality Hair Oil NULL 3305901 12 0.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 0.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-02-09 11:31:19
3600 3809 27 927 12685 35 Sanitary Pad (15 pcs) NULL 9619001 5 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 0.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-02-09 11:31:19