fx_franchise_order_product

4,737 rows · 33 columns · page 64 / 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
3151 3360 6 823 12516 81 PREMIUM GLOW FACE WASH NULL 3404 200 0.0 699.0 0.0 0.0 559.0 512.84 46.16 139800.0 0.0 111800.0 4.5 4615.6 4.5 4615.6 0.0 0.0 102568.8 9231.19 111800.0 INR 1 8.0 8205.5 2026-01-25 15:00:57
3152 3361 7 823 12516 46 Root Vitality Hair Oil NULL 3305901 200 0.0 255.0 0.0 0.0 204.0 194.29 9.71 51000.0 0.0 40800.0 2.5 971.43 2.5 971.43 0.0 0.0 38857.14 1942.86 40800.0 INR 1 8.0 3108.57 2026-01-25 15:00:57
3153 3362 8 823 12516 35 Sanitary Pad (15 pcs) NULL 9619001 1000 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380000.0 0.0 304000.0 0.0 0.0 0.0 0.0 0.0 0.0 304000.0 0.0 304000.0 INR 1 8.0 24320.0 2026-01-25 15:00:57
3154 3363 1 824 12516 48 glow face wash NULL 3304999 50 0.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 0.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 12881.35 2318.64 15200.0 INR 1 8.0 1030.51 2026-01-25 15:11:07
3155 3364 2 824 12516 58 Green shield 250ml NULL 3105 40 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 100000.0 0.0 74000.0 2.5 1761.9 2.5 1761.9 0.0 0.0 70476.19 3523.81 74000.0 INR 1 8.0 5638.1 2026-01-25 15:11:07
3156 3365 3 824 12516 2 Heart Care Capsules NULL 2936900 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 114285.71 5714.29 120000.0 INR 1 8.0 9142.86 2026-01-25 15:11:07
3157 3366 4 824 12516 28 Ortho Joint Shield NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 114285.71 5714.29 120000.0 INR 1 8.0 9142.86 2026-01-25 15:11:07
3158 3367 5 824 12516 12 P RADIANCE FACE SERUM NULL 33049990 100 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 125000.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 1 8.0 5714.29 2026-01-25 15:11:07
3159 3368 6 824 12516 43 Quench Kiss Lip Balm NULL 3304300 300 0.0 199.0 0.0 0.0 159.0 134.75 24.25 59700.0 0.0 47700.0 9.0 3638.14 9.0 3638.14 0.0 0.0 40423.74 7276.27 47700.0 INR 1 8.0 3233.9 2026-01-25 15:11:07
3160 3369 7 824 12516 57 Safe guard 250ml NULL 3105 60 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 150000.0 0.0 111000.0 2.5 2642.86 2.5 2642.86 0.0 0.0 105714.29 5285.71 111000.0 INR 1 8.0 8457.14 2026-01-25 15:11:07
3161 3370 8 824 12516 11 SOUNDARYA VEDA BRINGARAJ & SHIKAKAI NULL 33051090 100 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 125000.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 1 8.0 5714.29 2026-01-25 15:11:07
3162 3371 9 824 12516 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 100 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 142400.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 1 8.0 5714.29 2026-01-25 15:11:07
3163 3372 10 824 12516 5 Thyro Care NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 68571.43 3428.57 72000.0 INR 1 8.0 5485.71 2026-01-25 15:11:07
3164 3373 11 824 12516 54 Wonder grow 100ml NULL 3105 60 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 84000.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 68571.43 3428.57 72000.0 INR 1 8.0 5485.71 2026-01-25 15:11:07
3165 3374 1 825 12516 28 Ortho Joint Shield NULL 2009899 60 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 89940.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 68571.43 3428.57 72000.0 INR 1 8.0 5485.71 2026-01-25 15:18:12
3166 3375 1 826 12516 2 Heart Care Capsules NULL 2936900 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 57142.86 2857.14 60000.0 INR 1 8.0 4571.43 2026-01-25 15:19:57
3167 3376 1 827 12516 3 BP Care Capsules NULL 2936900 70 0.0 999.0 0.0 0.0 720.0 685.71 34.29 69930.0 0.0 50400.0 2.5 1200.0 2.5 1200.0 0.0 0.0 48000.0 2400.0 50400.0 INR 1 8.0 3840.0 2026-01-25 15:27:45
3168 3377 2 827 12516 4 Diabetic Care Capsules NULL 2936900 130 0.0 999.0 0.0 0.0 720.0 685.71 34.29 129870.0 0.0 93600.0 2.5 2228.57 2.5 2228.57 0.0 0.0 89142.86 4457.14 93600.0 INR 1 8.0 7131.43 2026-01-25 15:27:45
3169 3378 3 827 12516 24 Immunomax 24/7 Caps NULL 2009899 60 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 89940.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 68571.43 3428.57 72000.0 INR 1 8.0 5485.71 2026-01-25 15:27:45
3170 3379 4 827 12516 30 Iron Capsules NULL 30049011 100 0.0 899.0 0.0 0.0 719.0 684.76 34.24 89900.0 0.0 71900.0 2.5 1711.9 2.5 1711.9 0.0 0.0 68476.19 3423.81 71900.0 INR 1 8.0 5478.1 2026-01-25 15:27:45
3171 3380 5 827 12516 18 Lady Care Juice 500ml NULL 2009899 60 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 89940.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 68571.43 3428.57 72000.0 INR 1 8.0 5485.71 2026-01-25 15:27:45
3172 3381 6 827 12516 25 Manicalcium Tablets NULL 2009899 100 0.0 399.0 0.0 0.0 319.0 303.81 15.19 39900.0 0.0 31900.0 2.5 759.52 2.5 759.52 0.0 0.0 30380.95 1519.05 31900.0 INR 1 8.0 2430.48 2026-01-25 15:27:45
3173 3382 7 827 12516 9 Omega 369 NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 68571.43 3428.57 72000.0 INR 1 8.0 5485.71 2026-01-25 15:27:45
3174 3383 8 827 12516 72 Pain Relief Patch NULL 30051090 400 0.0 800.0 0.0 0.0 600.0 571.43 28.57 320000.0 0.0 240000.0 2.5 5714.29 2.5 5714.29 0.0 0.0 228571.44 11428.57 240000.0 INR 1 8.0 18285.72 2026-01-25 15:27:45
3175 3384 9 827 12516 47 Premium Hair Care Shampoo NULL 3305109 100 0.0 699.0 0.0 0.0 559.0 532.38 26.62 69900.0 0.0 55900.0 2.5 1330.95 2.5 1330.95 0.0 0.0 53238.1 2661.9 55900.0 INR 1 8.0 4259.05 2026-01-25 15:27:45
3176 3385 10 827 12516 26 Spirulina Cap NULL 2009899 80 0.0 899.0 0.0 0.0 719.0 684.76 34.24 71920.0 0.0 57520.0 2.5 1369.52 2.5 1369.52 0.0 0.0 54780.95 2739.05 57520.0 INR 1 8.0 4382.48 2026-01-25 15:27:45
3177 3386 1 828 12516 18 Lady Care Juice 500ml NULL 2009899 20 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 29980.0 0.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 22857.14 1142.86 24000.0 INR 1 8.0 1828.57 2026-01-25 15:31:28
3178 3387 1 829 12516 25 Manicalcium Tablets NULL 2009899 100 0.0 399.0 0.0 0.0 319.0 303.81 15.19 39900.0 0.0 31900.0 2.5 759.52 2.5 759.52 0.0 0.0 30380.95 1519.05 31900.0 INR 1 8.0 2430.48 2026-01-25 15:33:41
3179 3388 1 830 12516 47 Premium Hair Care Shampoo NULL 3305109 100 0.0 699.0 0.0 0.0 559.0 532.38 26.62 69900.0 0.0 55900.0 2.5 1330.95 2.5 1330.95 0.0 0.0 53238.1 2661.9 55900.0 INR 1 8.0 4259.05 2026-01-25 15:37:41
3180 3389 1 831 12516 30 Iron Capsules NULL 30049011 20 0.0 899.0 0.0 0.0 719.0 684.76 34.24 17980.0 0.0 14380.0 2.5 342.38 2.5 342.38 0.0 0.0 13695.24 684.76 14380.0 INR 1 8.0 1095.62 2026-01-25 15:42:04
3181 3390 1 832 12516 27 Multicharge Cap NULL 2009899 120 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 179880.0 0.0 144000.0 2.5 3428.57 2.5 3428.57 0.0 0.0 137142.85 6857.14 144000.0 INR 1 8.0 10971.43 2026-01-26 10:08:34
3182 3391 2 832 12516 20 Premium Berry Juice 1000ml NULL 2936900 310 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 1084690.0 0.0 806000.0 2.5 19190.48 2.5 19190.48 0.0 0.0 767619.06 38380.95 806000.0 INR 1 8.0 61409.52 2026-01-26 10:08:34
3183 3392 3 832 12516 31 Vegan Plant Protein Powder NULL 21061000 120 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 359880.0 0.0 240000.0 2.5 5714.29 2.5 5714.29 0.0 0.0 228571.43 11428.57 240000.0 INR 1 8.0 18285.71 2026-01-26 10:08:34
3184 3393 4 832 12516 49 Anti Dandruff Serum NULL 3304999 150 0.0 999.0 0.0 0.0 799.0 677.12 121.88 149850.0 0.0 119850.0 9.0 9141.1 9.0 9141.1 0.0 0.0 101567.79 18282.2 119850.0 INR 1 8.0 8125.42 2026-01-26 10:08:34
3185 3394 5 832 12516 6 Asthma Care NULL 30049011 120 0.0 999.0 0.0 0.0 720.0 685.71 34.29 119880.0 0.0 86400.0 2.5 2057.14 2.5 2057.14 0.0 0.0 82285.72 4114.29 86400.0 INR 1 8.0 6582.86 2026-01-26 10:08:34
3186 3395 6 832 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 100 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 160000.0 0.0 125000.0 2.5 2976.19 2.5 2976.19 0.0 0.0 119047.62 5952.38 125000.0 INR 1 8.0 9523.81 2026-01-26 10:08:34
3187 3396 7 832 12516 19 Fat loss Juice 500 ml NULL 30049011 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 57142.86 2857.14 60000.0 INR 1 8.0 4571.43 2026-01-26 10:08:34
3188 3397 8 832 12516 60 Foot patch NULL 30051090 70 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 139930.0 0.0 111930.0 2.5 2665.0 2.5 2665.0 0.0 0.0 106600.0 5330.0 111930.0 INR 1 8.0 8528.0 2026-01-26 10:08:34
3189 3398 9 832 12516 55 Grow master 500ml NULL 3105 60 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 121800.0 0.0 99000.0 2.5 2357.14 2.5 2357.14 0.0 0.0 94285.72 4714.29 99000.0 INR 1 0.0 0.0 2026-01-26 10:08:34
3190 3399 10 832 12516 34 Herbo2o Toothpaste NULL 33061090 600 0.0 199.0 0.0 0.0 159.0 134.75 24.25 119400.0 0.0 95400.0 9.0 7276.27 9.0 7276.27 0.0 0.0 80847.48 14552.54 95400.0 INR 1 8.0 6467.8 2026-01-26 10:08:34
3191 3400 11 832 12516 15 KIDNEY CARE JUICE NULL 2009899 160 0.0 349.0 0.0 0.0 279.0 265.71 13.29 55840.0 0.0 44640.0 2.5 1062.86 2.5 1062.86 0.0 0.0 42514.29 2125.71 44640.0 INR 1 8.0 3401.14 2026-01-26 10:08:34
3192 3401 12 832 12516 16 Liver Care Juice NULL 2009899 210 0.0 349.0 0.0 0.0 279.0 265.71 13.29 73290.0 0.0 58590.0 2.5 1395.0 2.5 1395.0 0.0 0.0 55800.0 2790.0 58590.0 INR 1 8.0 4464.0 2026-01-26 10:08:34
3193 3402 13 832 12516 17 Memory Booster Juice NULL 2009899 210 0.0 349.0 0.0 0.0 279.0 265.71 13.29 73290.0 0.0 58590.0 2.5 1395.0 2.5 1395.0 0.0 0.0 55800.0 2790.0 58590.0 INR 1 8.0 4464.0 2026-01-26 10:08:34
3194 3403 14 832 12516 56 Micro magic 500ml NULL 3105 60 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 121800.0 0.0 99000.0 2.5 2357.14 2.5 2357.14 0.0 0.0 94285.72 4714.29 99000.0 INR 1 8.0 7542.86 2026-01-26 10:08:34
3195 3404 15 832 12516 32 Neem Soap 100gm NULL 34011110 2000 0.0 60.0 0.0 0.0 48.0 45.71 2.29 120000.0 0.0 96000.0 2.5 2285.71 2.5 2285.71 0.0 0.0 91428.6 4571.43 96000.0 INR 1 8.0 7314.29 2026-01-26 10:08:34
3196 3405 16 832 12516 50 Sun Screen NULL 330499 160 0.0 699.0 0.0 0.0 559.0 473.73 85.27 111840.0 0.0 89440.0 9.0 6821.69 9.0 6821.69 0.0 0.0 75796.61 13643.39 89440.0 INR 1 8.0 6063.73 2026-01-26 10:08:34
3197 3406 17 832 12516 53 Terra care 2 kg NULL 3103100 100 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 150000.0 0.0 115000.0 2.5 2738.1 2.5 2738.1 0.0 0.0 109523.81 5476.19 115000.0 INR 1 8.0 8761.9 2026-01-26 10:08:34
3198 3407 1 833 12527 48 glow face wash NULL 3304999 3 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 0.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 772.88 139.12 912.0 INR 3 2.0 15.46 2026-01-26 12:35:50
3199 3408 2 833 12527 4 Diabetic Care Capsules NULL 2936900 4 0.0 999.0 0.0 0.0 720.0 685.71 34.29 3996.0 0.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 3 2.0 54.86 2026-01-26 12:35:50
3200 3409 3 833 12527 17 Memory Booster Juice NULL 2009899 3 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1047.0 0.0 837.0 2.5 19.93 2.5 19.93 0.0 0.0 797.14 39.86 837.0 INR 3 2.0 15.94 2026-01-26 12:35:50