fx_franchise_order_product

4,737 rows · 33 columns · page 10 / 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
451 660 15 82 12516 38 Dish Wash 500ml NULL 3924101 197 85.0 230.0 0.0 0.0 184.0 155.93 28.07 45310.0 16745.0 36248.0 9.0 2764.68 9.0 2764.68 0.0 0.0 155.93 5529.36 36248.0 INR 0 0.0 0.0 2025-11-07 22:56:50
452 661 16 82 12516 39 Fabric Wash 1000ml NULL 3924101 166 150.0 401.0 0.0 0.0 320.8 271.86 48.94 66566.0 24900.0 53252.8 9.0 4061.66 9.0 4061.66 0.0 0.0 271.86 8123.31 53252.8 INR 0 0.0 0.0 2025-11-07 22:56:50
453 662 17 82 12516 19 Fat loss Juice 500 ml NULL 30049011 7 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 10493.0 1750.0 10353.0 2.5 246.5 2.5 246.5 0.0 0.0 1408.57 493.0 10353.0 INR 0 0.0 0.0 2025-11-07 22:56:50
454 663 18 82 12516 22 Fit Fuel Juice NULL 2009899 4 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 7996.0 800.0 7916.0 2.5 188.47 2.5 188.47 0.0 0.0 1884.76 376.95 7916.0 INR 0 0.0 0.0 2025-11-07 22:56:50
455 664 19 82 12516 37 Floor Cleaner 500ml NULL 3924101 125 80.0 199.0 0.0 0.0 159.2 134.92 24.28 24875.0 10000.0 19900.0 9.0 1517.8 9.0 1517.8 0.0 0.0 134.92 3035.59 19900.0 INR 0 0.0 0.0 2025-11-07 22:56:50
456 665 20 82 12516 60 Foot patch NULL 30051090 52 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 103948.0 26000.0 83158.4 2.5 1979.96 2.5 1979.96 0.0 0.0 1523.05 3959.92 83158.4 INR 0 0.0 0.0 2025-11-07 22:56:50
457 666 21 82 12516 58 Green shield 250ml NULL 3105 14 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 35000.0 11200.0 28000.0 2.5 666.66 2.5 666.66 0.0 0.0 1904.76 1333.33 28000.0 INR 0 0.0 0.0 2025-11-07 22:56:50
458 667 22 82 12516 55 Grow master 500ml NULL 3105 33 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 66990.0 28050.0 53592.0 2.5 1276.0 2.5 1276.0 0.0 0.0 1546.67 2552.0 53592.0 INR 0 0.0 0.0 2025-11-07 22:56:50
459 668 23 82 12516 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 2.5 285.52 2.5 285.52 0.0 0.0 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-07 22:56:50
460 669 24 82 12516 33 Herbal Soap 100gm NULL 30049011 1593 28.0 100.0 0.0 0.0 80.0 76.19 3.81 159300.0 44604.0 127440.0 2.5 3034.28 2.5 3034.28 0.0 0.0 76.19 6068.57 127440.0 INR 0 0.0 0.0 2025-11-07 22:56:50
461 670 25 82 12516 34 Herbo2o Toothpaste NULL 33061090 597 45.0 199.0 0.0 0.0 159.2 134.92 24.28 118803.0 26865.0 95042.4 9.0 7248.99 9.0 7248.99 0.0 0.0 134.92 14497.99 95042.4 INR 0 0.0 0.0 2025-11-07 22:56:50
462 671 26 82 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:56:50
463 672 27 82 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:56:50
464 673 28 82 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:56:50
465 674 29 82 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:56:50
466 675 30 82 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:56:50
467 676 31 82 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:56:50
468 677 32 82 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:56:50
469 678 33 82 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:56:50
470 679 34 82 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:56:50
471 680 35 82 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:56:50
472 681 36 82 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:56:50
473 682 37 82 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:56:50
474 683 38 82 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:56:50
475 684 39 82 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:56:50
476 685 40 82 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:56:50
477 686 41 82 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:56:50
478 687 42 82 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:56:50
479 688 43 82 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:56:50
480 689 44 82 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:56:50
481 690 45 82 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:56:50
482 691 46 82 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:56:50
483 692 47 82 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:56:50
484 693 48 82 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:56:50
485 694 49 82 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:56:50
486 695 50 82 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:56:50
487 696 51 82 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:56:50
488 697 52 82 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:56:50
489 698 53 82 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:56:50
490 699 54 82 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:56:50
491 700 55 82 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:56:50
492 701 56 82 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:56:50
493 702 57 82 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:56:50
494 703 58 82 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:56:50
495 704 59 82 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:56:50
496 705 60 82 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:56:50
497 706 61 82 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:56:50
498 707 1 83 12526 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-07 23:02:42
499 708 1 84 12517 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 0.0 0.0 0.0 0.0 18.0 2365.02 257.63 2365.02 15504.0 INR 0 0.0 0.0 2025-11-07 23:11:39
500 709 2 84 12517 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 0.0 0.0 0.0 0.0 5.0 399.73 1142.1 399.73 8394.4 INR 0 0.0 0.0 2025-11-07 23:11:39