fx_franchise_order_product

4,737 rows · 33 columns · page 9 / 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
401 610 26 81 12516 24 Immunomax 24/7 Caps NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 22:39:17
402 611 27 81 12516 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-07 22:39:17
403 612 28 81 12516 15 Kidney Stone Juice NULL 2009899 11 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3839.0 1320.0 3071.2 2.5 73.12 2.5 73.12 0.0 0.0 265.9 146.25 3071.2 INR 0 0.0 0.0 2025-11-07 22:39:17
404 613 29 81 12516 18 Lady Care Juice 500ml NULL 2009899 16 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 23984.0 4000.0 19187.2 2.5 456.84 2.5 456.84 0.0 0.0 1142.1 913.68 19187.2 INR 0 0.0 0.0 2025-11-07 22:39:17
405 614 30 81 12516 16 Liver Care Juice NULL 2009899 46 120.0 349.0 0.0 0.0 279.2 265.9 13.3 16054.0 5520.0 12843.2 2.5 305.79 2.5 305.79 0.0 0.0 265.9 611.58 12843.2 INR 0 0.0 0.0 2025-11-07 22:39:17
406 615 31 81 12516 25 Manicalcium Tablets NULL 2009899 23 95.0 399.0 0.0 0.0 319.2 304.0 15.2 9177.0 2185.0 7341.6 2.5 174.8 2.5 174.8 0.0 0.0 304.0 349.6 7341.6 INR 0 0.0 0.0 2025-11-07 22:39:17
407 616 32 81 12516 12 Melatonin Drop NULL 2106909 38 190.0 749.0 0.0 0.0 599.2 570.67 28.53 28462.0 7220.0 22769.6 2.5 542.13 2.5 542.13 0.0 0.0 570.67 1084.27 22769.6 INR 0 0.0 0.0 2025-11-07 22:39:17
408 617 33 81 12516 17 Memory Booster Juice NULL 2009899 52 120.0 349.0 0.0 0.0 279.2 265.9 13.3 18148.0 6240.0 14518.4 2.5 345.68 2.5 345.68 0.0 0.0 265.9 691.35 14518.4 INR 0 0.0 0.0 2025-11-07 22:39:17
409 618 34 81 12516 56 Micro magic 500ml NULL 3105 24 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 48720.0 20400.0 38976.0 9.0 2972.74 9.0 2972.74 0.0 0.0 1376.27 5945.49 38976.0 INR 0 0.0 0.0 2025-11-07 22:39:17
410 619 35 81 12516 7 Morning Fresh Churan NULL 30049011 157 40.0 199.0 0.0 0.0 159.2 151.62 7.58 31243.0 6280.0 24994.4 2.5 595.11 2.5 595.11 0.0 0.0 151.62 1190.21 24994.4 INR 0 0.0 0.0 2025-11-07 22:39:17
411 620 36 81 12516 32 Neem Soap 100gm NULL 34011110 3122 10.0 60.0 0.0 0.0 48.0 45.71 2.29 187320.0 31220.0 149856.0 2.5 3568.0 2.5 3568.0 0.0 0.0 45.71 7136.0 149856.0 INR 0 0.0 0.0 2025-11-07 22:39:17
412 621 37 81 12516 9 Omega 369 NULL 2936900 57 260.0 999.0 0.0 0.0 799.2 761.14 38.06 56943.0 14820.0 45554.4 2.5 1084.63 2.5 1084.63 0.0 0.0 761.14 2169.26 45554.4 INR 0 0.0 0.0 2025-11-07 22:39:17
413 622 38 81 12516 28 Ortho Joint Shield NULL 2009899 14 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 6300.0 16788.8 2.5 399.74 2.5 399.74 0.0 0.0 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-07 22:39:17
414 623 39 81 12516 72 Pain Relief Patch NULL 30051090 52 200.0 800.0 0.0 0.0 640.0 609.52 30.48 41600.0 10400.0 33280.0 2.5 792.38 2.5 792.38 0.0 0.0 609.52 1584.76 33280.0 INR 0 0.0 0.0 2025-11-07 22:39:17
415 624 40 81 12516 8 Piles Care NULL 30049011 49 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44051.0 12250.0 35240.8 2.5 839.07 2.5 839.07 0.0 0.0 684.95 1678.13 35240.8 INR 0 0.0 0.0 2025-11-07 22:39:17
416 625 41 81 12516 41 Premium Coco Body Lotion NULL 3304300 25 250.0 699.0 0.0 0.0 559.2 473.9 85.3 17475.0 6250.0 13980.0 9.0 1066.27 9.0 1066.27 0.0 0.0 473.9 2132.54 13980.0 INR 0 0.0 0.0 2025-11-07 22:39:17
417 626 42 81 12516 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-07 22:39:17
418 627 43 81 12516 47 Premium Hair Care Shampoo NULL 3305109 78 150.0 699.0 0.0 0.0 559.2 532.57 26.63 54522.0 11700.0 43617.6 2.5 1038.52 2.5 1038.52 0.0 0.0 532.57 2077.03 43617.6 INR 0 0.0 0.0 2025-11-07 22:39:17
419 628 44 81 12516 13 Premium NONI VEG caps NULL 2936900 27 150.0 501.0 0.0 0.0 400.8 381.71 19.09 13527.0 4050.0 10821.6 2.5 257.65 2.5 257.65 0.0 0.0 381.71 515.31 10821.6 INR 0 0.0 0.0 2025-11-07 22:39:17
420 629 45 81 12516 45 Premium radiance face serum NULL 3304991 16 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 19200.0 4800.0 15360.0 9.0 1171.53 9.0 1171.53 0.0 0.0 813.56 2343.05 15360.0 INR 0 0.0 0.0 2025-11-07 22:39:17
421 630 46 81 12516 43 Quench Kiss Lip Balm NULL 3304300 15 35.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 525.0 2388.0 9.0 182.13 9.0 182.13 0.0 0.0 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-07 22:39:17
422 631 47 81 12516 46 Root Vitality Hair Oil NULL 3305901 59 54.0 255.0 0.0 0.0 204.0 194.29 9.71 15045.0 3186.0 12036.0 2.5 286.57 2.5 286.57 0.0 0.0 194.29 573.14 12036.0 INR 0 0.0 0.0 2025-11-07 22:39:17
423 632 48 81 12516 57 Safe guard 250ml NULL 3105 24 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 60000.0 19200.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 1904.76 2285.71 48000.0 INR 0 0.0 0.0 2025-11-07 22:39:17
424 633 49 81 12516 35 Sanitary Pad (15 pcs) NULL 9619001 370 40.0 380.0 0.0 0.0 304.0 304.0 0.0 140600.0 14800.0 112480.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 112480.0 INR 0 0.0 0.0 2025-11-07 22:39:17
425 634 50 81 12516 29 Shilajith NULL 30049011 21 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 37800.0 5250.0 30240.0 2.5 720.0 2.5 720.0 0.0 0.0 1371.43 1440.0 30240.0 INR 0 0.0 0.0 2025-11-07 22:39:17
426 635 51 81 12516 26 Spirulina Cap NULL 2009899 30 190.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 5700.0 21576.0 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-07 22:39:17
427 636 52 81 12516 1 Stem Cell Powder NULL 2936900 55 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 137445.0 41195.0 109956.0 2.5 2618.0 2.5 2618.0 0.0 0.0 1904.0 5236.0 109956.0 INR 0 0.0 0.0 2025-11-07 22:39:17
428 637 53 81 12516 50 Sun Screen NULL 330499 44 250.0 699.0 0.0 0.0 559.2 473.9 85.3 30756.0 11000.0 24604.8 9.0 1876.63 9.0 1876.63 0.0 0.0 473.9 3753.27 24604.8 INR 0 0.0 0.0 2025-11-07 22:39:17
429 638 54 81 12516 59 T Shirt NULL 61099010 1 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 0.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 22:39:17
430 639 55 81 12516 53 Terra care 2 kg NULL 3103100 71 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 106500.0 31950.0 85200.0 2.5 2028.57 2.5 2028.57 0.0 0.0 1142.86 4057.14 85200.0 INR 0 0.0 0.0 2025-11-07 22:39:17
431 640 56 81 12516 5 Thyro Care NULL 2936900 21 250.0 899.0 0.0 0.0 719.2 684.95 34.25 18879.0 5250.0 15103.2 2.5 359.6 2.5 359.6 0.0 0.0 684.95 719.2 15103.2 INR 0 0.0 0.0 2025-11-07 22:39:17
432 641 57 81 12516 36 Toilet Cleaner 500ml NULL 3924101 180 30.0 150.0 0.0 0.0 120.0 101.69 18.31 27000.0 5400.0 21600.0 9.0 1647.46 9.0 1647.46 0.0 0.0 101.69 3294.92 21600.0 INR 0 0.0 0.0 2025-11-07 22:39:17
433 642 58 81 12516 11 Vitamin B12 Drop NULL 2106909 126 190.0 749.0 0.0 0.0 599.2 570.67 28.53 94374.0 23940.0 75499.2 2.5 1797.6 2.5 1797.6 0.0 0.0 570.67 3595.2 75499.2 INR 0 0.0 0.0 2025-11-07 22:39:17
434 643 59 81 12516 10 Vitamin D3 Drop NULL 2106909 131 190.0 749.0 0.0 0.0 599.2 570.67 28.53 98119.0 24890.0 78495.2 2.5 1868.93 2.5 1868.93 0.0 0.0 570.67 3737.87 78495.2 INR 0 0.0 0.0 2025-11-07 22:39:17
435 644 60 81 12516 23 Women Fuel Juice NULL 2202999 6 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 11994.0 1200.0 9595.2 2.5 228.46 2.5 228.46 0.0 0.0 1523.05 456.91 9595.2 INR 0 0.0 0.0 2025-11-07 22:39:17
436 645 61 81 12516 54 Wonder grow 100ml NULL 3105 55 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 77000.0 27500.0 61600.0 2.5 1466.66 2.5 1466.66 0.0 0.0 1066.67 2933.33 61600.0 INR 0 0.0 0.0 2025-11-07 22:39:17
437 646 1 82 12516 48 glow face wash NULL 3304999 51 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19380.0 12750.0 15504.0 9.0 1182.51 9.0 1182.51 0.0 0.0 257.63 2365.02 15504.0 INR 0 0.0 0.0 2025-11-07 22:56:50
438 647 2 82 12516 27 Multicharge Cap NULL 2009899 7 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 10493.0 3150.0 8394.4 2.5 199.87 2.5 199.87 0.0 0.0 1142.1 399.73 8394.4 INR 0 0.0 0.0 2025-11-07 22:56:50
439 648 3 82 12516 20 Premium Berry Juice 1000ml NULL 2936900 10 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 34990.0 7500.0 34790.0 2.5 828.34 2.5 828.34 0.0 0.0 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-07 22:56:50
440 649 4 82 12516 70 Premium Hand belt NULL 9404 18 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 179982.0 10800.0 143985.6 2.5 3428.23 2.5 3428.23 0.0 0.0 7618.29 6856.46 143985.6 INR 0 0.0 0.0 2025-11-07 22:56:50
441 650 5 82 12516 61 Radiation chip NULL 902221 10 325.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 3250.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-07 22:56:50
442 651 6 82 12516 31 Vegan Plant Protein Powder NULL 21061000 2 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 5998.0 2000.0 4798.4 2.5 114.25 2.5 114.25 0.0 0.0 2284.95 228.5 4798.4 INR 0 0.0 0.0 2025-11-07 22:56:50
443 652 7 82 12516 79 ALKALINE JUG NULL 8421 5 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 74995.0 17500.0 59996.0 9.0 4575.97 9.0 4575.97 0.0 0.0 10168.81 9151.93 59996.0 INR 0 0.0 0.0 2025-11-07 22:56:50
444 653 8 82 12516 21 All Fuel Juice NULL 22029990 5 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 12495.0 1750.0 12395.0 2.5 295.12 2.5 295.12 0.0 0.0 2360.95 590.24 12395.0 INR 0 0.0 0.0 2025-11-07 22:56:50
445 654 9 82 12516 6 Asthma Care NULL 30049011 24 250.0 899.0 0.0 0.0 719.2 684.95 34.25 21576.0 6000.0 17260.8 2.5 410.97 2.5 410.97 0.0 0.0 684.95 821.94 17260.8 INR 0 0.0 0.0 2025-11-07 22:56:50
446 655 10 82 12516 40 Bamboo Brush NULL 96032100 85 25.0 110.0 0.0 0.0 88.0 74.58 13.42 9350.0 2125.0 7480.0 9.0 570.51 9.0 570.51 0.0 0.0 74.58 1141.02 7480.0 INR 0 0.0 0.0 2025-11-07 22:56:50
447 656 11 82 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 68 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 108800.0 30600.0 87040.0 2.5 2072.38 2.5 2072.38 0.0 0.0 1219.05 4144.76 87040.0 INR 0 0.0 0.0 2025-11-07 22:56:50
448 657 12 82 12516 71 Bio magnetic water pad NULL 9404 6 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 27000.0 6000.0 21600.0 2.5 514.28 2.5 514.28 0.0 0.0 3428.57 1028.57 21600.0 INR 0 0.0 0.0 2025-11-07 22:56:50
449 658 13 82 12516 3 BP Care Capsules NULL 2936900 74 160.0 599.0 0.0 0.0 479.2 456.38 22.82 44326.0 11840.0 35460.8 2.5 844.3 2.5 844.3 0.0 0.0 456.38 1688.61 35460.8 INR 0 0.0 0.0 2025-11-07 22:56:50
450 659 14 82 12516 4 Diabetic Care Capsules NULL 2936900 45 250.0 899.0 0.0 0.0 719.2 684.95 34.25 40455.0 11250.0 32364.0 2.5 770.57 2.5 770.57 0.0 0.0 684.95 1541.14 32364.0 INR 0 0.0 0.0 2025-11-07 22:56:50