fx_franchise_order_product

4,737 rows · 33 columns · page 53 / 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
2601 2810 3 681 12517 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 5.0 227.14 4542.86 227.14 4770.0 INR 2 6.0 272.57 2026-01-10 16:18:01
2602 2811 1 682 12516 7 Morning Fresh Churan NULL 30049011 50 0.0 199.0 0.0 0.0 159.0 151.43 7.57 9950.0 0.0 7950.0 2.5 189.29 2.5 189.29 0.0 0.0 7571.43 378.57 7950.0 INR 1 8.0 605.71 2026-01-10 16:18:28
2603 2812 1 683 12517 36 Toilet Cleaner 500ml NULL 3924101 50 0.0 150.0 0.0 0.0 120.0 101.69 18.31 7500.0 0.0 6000.0 0.0 0.0 0.0 0.0 18.0 915.25 5084.74 915.25 6000.0 INR 2 6.0 305.08 2026-01-10 16:19:35
2604 2813 1 684 12517 12 P RADIANCE FACE SERUM NULL 33049990 30 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 37500.0 0.0 22500.0 0.0 0.0 0.0 0.0 5.0 1071.43 21428.57 1071.43 22500.0 INR 2 6.0 1285.71 2026-01-10 16:21:05
2605 2814 1 685 14323 38 Dish Wash 500ml NULL 3924101 9 0.0 230.0 0.0 0.0 184.0 155.93 28.07 2070.0 0.0 1656.0 9.0 126.31 9.0 126.31 0.0 0.0 1403.39 252.61 1656.0 INR 3 2.0 28.07 2026-01-10 16:26:54
2606 2815 2 685 14323 37 Floor Cleaner 500ml NULL 3924101 17 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3383.0 0.0 2703.0 9.0 206.16 9.0 206.16 0.0 0.0 2290.68 412.32 2703.0 INR 3 2.0 45.81 2026-01-10 16:26:54
2607 2816 3 685 14323 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-10 16:26:54
2608 2817 4 685 14323 36 Toilet Cleaner 500ml NULL 3924101 19 0.0 150.0 0.0 0.0 120.0 101.69 18.31 2850.0 0.0 2280.0 9.0 173.9 9.0 173.9 0.0 0.0 1932.2 347.8 2280.0 INR 3 2.0 38.64 2026-01-10 16:26:54
2609 2818 1 686 14323 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-10 16:46:16
2610 2819 2 686 14323 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-10 16:46:16
2611 2820 3 686 14323 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-10 16:46:16
2612 2821 4 686 14323 4 Diabetic Care Capsules NULL 2936900 3 0.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 0.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-01-10 16:46:16
2613 2822 5 686 14323 39 Fabric Wash 1000ml NULL 3924101 20 0.0 401.0 0.0 0.0 321.0 272.03 48.97 8020.0 0.0 6420.0 9.0 489.66 9.0 489.66 0.0 0.0 5440.68 979.32 6420.0 INR 3 2.0 108.81 2026-01-10 16:46:16
2614 2823 6 686 14323 12 P RADIANCE FACE SERUM NULL 33049990 5 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 0.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-01-10 16:46:16
2615 2824 7 686 14323 81 PREMIUM GLOW FACE WASH NULL 3404 5 0.0 699.0 0.0 0.0 559.0 512.84 46.16 3495.0 0.0 2795.0 4.5 115.39 4.5 115.39 0.0 0.0 2564.22 230.78 2795.0 INR 3 2.0 51.28 2026-01-10 16:46:16
2616 2825 8 686 14323 43 Quench Kiss Lip Balm NULL 3304300 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-10 16:46:16
2617 2826 1 687 12517 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 0.0 0.0 0.0 0.0 5.0 500.0 10000.0 500.0 10500.0 INR 2 0.0 300.0 2026-01-10 16:48:31
2618 2827 1 688 12517 39 Fabric Wash 1000ml NULL 3924101 8 0.0 401.0 0.0 0.0 321.0 272.03 48.97 3208.0 0.0 2568.0 0.0 0.0 0.0 0.0 18.0 391.73 2176.27 391.73 2568.0 INR 2 6.0 130.58 2026-01-10 16:55:50
2619 2828 1 689 12516 39 Fabric Wash 1000ml NULL 3924101 100 0.0 401.0 0.0 0.0 321.0 272.03 48.97 40100.0 0.0 32100.0 9.0 2448.31 9.0 2448.31 0.0 0.0 27203.39 4896.61 32100.0 INR 1 8.0 2176.27 2026-01-10 16:59:03
2620 2829 1 690 12517 39 Fabric Wash 1000ml NULL 3924101 50 0.0 401.0 0.0 0.0 321.0 272.03 48.97 20050.0 0.0 16050.0 0.0 0.0 0.0 0.0 18.0 2448.31 13601.69 2448.31 16050.0 INR 2 6.0 816.1 2026-01-10 16:59:53
2621 2830 1 691 13536 39 Fabric Wash 1000ml NULL 3924101 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-01-10 17:10:28
2622 2831 2 691 13536 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-10 17:10:28
2623 2832 3 691 13536 43 Quench Kiss Lip Balm NULL 3304300 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-10 17:10:28
2624 2833 4 691 13536 44 Vital Glow Face Scrub NULL 3304300 3 0.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 0.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 661.02 118.98 780.0 INR 3 2.0 13.22 2026-01-10 17:10:28
2625 2834 1 692 12527 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 0.0 0.0 0.0 0.0 18.0 92.75 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-10 17:25:56
2626 2835 2 692 12527 39 Fabric Wash 1000ml NULL 3924101 20 0.0 401.0 0.0 0.0 321.0 272.03 48.97 8020.0 0.0 6420.0 0.0 0.0 0.0 0.0 18.0 979.32 5440.68 979.32 6420.0 INR 3 2.0 108.81 2026-01-10 17:25:56
2627 2836 3 692 12527 37 Floor Cleaner 500ml NULL 3924101 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 0.0 0.0 0.0 0.0 18.0 485.08 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-01-10 17:25:56
2628 2837 4 692 12527 34 Herbo2o Toothpaste NULL 33061090 30 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 18.0 727.63 4042.37 727.63 4770.0 INR 3 2.0 80.85 2026-01-10 17:25:56
2629 2838 5 692 12527 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 0.0 0.0 0.0 0.0 5.0 48.57 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-01-10 17:25:56
2630 2839 6 692 12527 35 Sanitary Pad (15 pcs) NULL 9619001 20 0.0 380.0 0.0 0.0 304.0 304.0 0.0 7600.0 0.0 6080.0 0.0 0.0 0.0 0.0 0.0 0.0 6080.0 0.0 6080.0 INR 3 2.0 121.6 2026-01-10 17:25:56
2631 2840 7 692 12527 36 Toilet Cleaner 500ml NULL 3924101 30 0.0 150.0 0.0 0.0 120.0 101.69 18.31 4500.0 0.0 3600.0 0.0 0.0 0.0 0.0 18.0 549.15 3050.85 549.15 3600.0 INR 3 2.0 61.02 2026-01-10 17:25:56
2632 2841 8 692 12527 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 0.0 0.0 0.0 0.0 18.0 39.66 220.34 39.66 260.0 INR 3 2.0 4.41 2026-01-10 17:25:56
2633 2842 1 693 12517 68 18000 bracelt NULL 94041000 3 0.0 23999.0 0.0 0.0 18000.0 17142.86 857.14 71997.0 0.0 54000.0 0.0 0.0 0.0 0.0 5.0 2571.43 51428.57 2571.43 54000.0 INR 2 0.0 400.0 2026-01-12 12:42:24
2634 2843 1 694 12517 58 Green shield 250ml NULL 3105 5 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 12500.0 0.0 9250.0 0.0 0.0 0.0 0.0 5.0 440.48 8809.52 440.48 9250.0 INR 2 6.0 528.57 2026-01-12 12:52:57
2635 2844 2 694 12517 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 0.0 0.0 0.0 0.0 5.0 392.86 7857.14 392.86 8250.0 INR 2 0.0 0.0 2026-01-12 12:52:57
2636 2845 3 694 12517 56 Micro magic 500ml NULL 3105 5 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 10150.0 0.0 8250.0 0.0 0.0 0.0 0.0 5.0 392.86 7857.14 392.86 8250.0 INR 2 6.0 471.43 2026-01-12 12:52:57
2637 2846 4 694 12517 57 Safe guard 250ml NULL 3105 5 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 12500.0 0.0 9250.0 0.0 0.0 0.0 0.0 5.0 440.48 8809.52 440.48 9250.0 INR 2 6.0 528.57 2026-01-12 12:52:57
2638 2847 1 695 13438 8 Piles Care NULL 30049011 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 3 2.0 13.71 2026-01-12 13:25:49
2639 2848 2 695 13438 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 0.0 0.0 0.0 0.0 18.0 48.51 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-12 13:25:49
2640 2849 1 696 13438 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 0.0 0.0 0.0 0.0 18.0 54.92 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-12 13:30:25
2641 2850 1 697 13438 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 0.0 0.0 0.0 0.0 18.0 54.92 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-12 13:31:59
2642 2851 1 698 13438 8 Piles 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-12 13:49:36
2643 2852 2 698 13438 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-01-12 13:49:36
2644 2853 3 698 13438 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-01-12 13:49:36
2645 2854 1 699 13438 32 Neem Soap 100gm NULL 34011110 14 0.0 60.0 0.0 0.0 48.0 45.71 2.29 840.0 0.0 672.0 2.5 16.0 2.5 16.0 0.0 0.0 640.0 32.0 672.0 INR 3 2.0 12.8 2026-01-12 13:55:39
2646 2855 1 700 13836 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-12 15:43:39
2647 2856 2 700 13836 39 Fabric Wash 1000ml NULL 3924101 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-01-12 15:43:39
2648 2857 3 700 13836 33 Herbal Soap 100gm NULL 30049011 2 0.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 0.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 3 2.0 3.05 2026-01-12 15:43:39
2649 2858 4 700 13836 34 Herbo2o Toothpaste NULL 33061090 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-01-12 15:43:39
2650 2859 5 700 13836 32 Neem Soap 100gm NULL 34011110 18 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1080.0 0.0 864.0 2.5 20.57 2.5 20.57 0.0 0.0 822.86 41.14 864.0 INR 3 2.0 16.46 2026-01-12 15:43:39