fx_franchise_order_product

4,737 rows · 33 columns · page 65 / 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
3201 3410 4 833 12527 41 Premium Coco Body Lotion NULL 3304300 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-01-26 12:35:50
3202 3411 5 833 12527 47 Premium Hair Care Shampoo NULL 3305109 3 0.0 699.0 0.0 0.0 559.0 532.38 26.62 2097.0 0.0 1677.0 2.5 39.93 2.5 39.93 0.0 0.0 1597.14 79.86 1677.0 INR 3 2.0 31.94 2026-01-26 12:35:50
3203 3412 6 833 12527 43 Quench Kiss Lip Balm NULL 3304300 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-01-26 12:35:50
3204 3413 7 833 12527 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-01-26 12:35:50
3205 3414 8 833 12527 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 3 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 4272.0 0.0 2250.0 2.5 53.57 2.5 53.57 0.0 0.0 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-26 12:35:50
3206 3415 9 833 12527 50 Sun Screen NULL 330499 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-01-26 12:35:50
3207 3416 1 834 12552 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 9.0 46.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-26 16:23:07
3208 3417 2 834 12552 38 Dish Wash 500ml NULL 34029099 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 311.86 56.14 368.0 INR 3 2.0 6.24 2026-01-26 16:23:07
3209 3418 3 834 12552 39 Fabric Wash 1000ml NULL 34029099 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-26 16:23:07
3210 3419 4 834 12552 33 Herbal Soap 100gm NULL 30049011 9 0.0 100.0 0.0 0.0 80.0 76.19 3.81 900.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-26 16:23:07
3211 3420 5 834 12552 34 Herbo2o Toothpaste NULL 33061090 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-26 16:23:07
3212 3421 6 834 12552 16 Liver Care Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-26 16:23:07
3213 3422 7 834 12552 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-01-26 16:23:07
3214 3423 8 834 12552 32 Neem Soap 100gm NULL 34011110 4 0.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 0.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 182.86 9.14 192.0 INR 3 2.0 3.66 2026-01-26 16:23:07
3215 3424 9 834 12552 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-01-26 16:23:07
3216 3425 10 834 12552 12 P RADIANCE FACE SERUM NULL 33049990 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-26 16:23:07
3217 3426 11 834 12552 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-26 16:23:07
3218 3427 12 834 12552 41 Premium Coco Body Lotion NULL 3304300 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-01-26 16:23:07
3219 3428 13 834 12552 47 Premium Hair Care Shampoo NULL 3305109 2 0.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 0.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-01-26 16:23:07
3220 3429 14 834 12552 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-26 16:23:07
3221 3430 15 834 12552 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-01-26 16:23:07
3222 3431 16 834 12552 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-01-26 16:23:07
3223 3432 1 835 12532 39 Fabric Wash 1000ml NULL 34029099 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-26 17:49:21
3224 3433 1 836 13536 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-26 22:14:13
3225 3434 1 837 12516 82 ALKALINE CAPSULE NULL 3402000 250 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 625000.0 0.0 500000.0 2.5 11904.76 2.5 11904.76 0.0 0.0 476190.47 23809.52 500000.0 INR 1 8.0 38095.24 2026-01-27 11:41:59
3226 3435 2 837 12516 37 Floor Cleaner 500ml NULL 3924101 400 0.0 199.0 0.0 0.0 159.0 134.75 24.25 79600.0 0.0 63600.0 9.0 4850.85 9.0 4850.85 0.0 0.0 53898.32 9701.69 63600.0 INR 1 8.0 4311.87 2026-01-27 11:41:59
3227 3436 3 837 12516 36 Toilet Cleaner 500ml NULL 3924101 800 0.0 150.0 0.0 0.0 120.0 101.69 18.31 120000.0 0.0 96000.0 9.0 7322.03 9.0 7322.03 0.0 0.0 81355.92 14644.07 96000.0 INR 1 8.0 6508.47 2026-01-27 11:41:59
3228 3437 1 838 12516 7 Morning Fresh Churan NULL 30049011 150 0.0 199.0 0.0 0.0 159.0 151.43 7.57 29850.0 0.0 23850.0 2.5 567.86 2.5 567.86 0.0 0.0 22714.29 1135.71 23850.0 INR 1 8.0 1817.14 2026-01-27 11:47:20
3229 3438 1 839 12517 82 ALKALINE CAPSULE NULL 3402000 200 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 500000.0 0.0 400000.0 0.0 0.0 0.0 0.0 5.0 19047.62 380952.38 19047.62 400000.0 INR 2 6.0 22857.14 2026-01-27 12:00:09
3230 3439 2 839 12517 37 Floor Cleaner 500ml NULL 3924101 300 0.0 199.0 0.0 0.0 159.0 134.75 24.25 59700.0 0.0 47700.0 0.0 0.0 0.0 0.0 18.0 7276.27 40423.74 7276.27 47700.0 INR 2 6.0 2425.42 2026-01-27 12:00:09
3231 3440 3 839 12517 7 Morning Fresh Churan NULL 30049011 150 0.0 199.0 0.0 0.0 159.0 151.43 7.57 29850.0 0.0 23850.0 0.0 0.0 0.0 0.0 5.0 1135.71 22714.29 1135.71 23850.0 INR 2 6.0 1362.86 2026-01-27 12:00:09
3232 3441 4 839 12517 36 Toilet Cleaner 500ml NULL 3924101 750 0.0 150.0 0.0 0.0 120.0 101.69 18.31 112500.0 0.0 90000.0 0.0 0.0 0.0 0.0 18.0 13728.81 76271.18 13728.81 90000.0 INR 2 6.0 4576.27 2026-01-27 12:00:09
3233 3442 1 840 12522 33 Herbal Soap 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 3 2.0 1.52 2026-01-27 12:55:50
3234 3443 2 840 12522 72 Pain Relief Patch NULL 30051090 1 0.0 800.0 0.0 0.0 600.0 571.43 28.57 800.0 0.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-01-27 12:55:50
3235 3444 1 841 12516 29 Shilajith NULL 30049011 43 0.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 77400.0 0.0 61920.0 2.5 1474.29 2.5 1474.29 0.0 0.0 58971.43 2948.57 61920.0 INR 1 0.0 0.0 2026-01-27 13:07:08
3236 3445 1 842 12517 29 Shilajith NULL 30049011 50 0.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 90000.0 0.0 72000.0 0.0 0.0 0.0 0.0 5.0 3428.57 68571.43 3428.57 72000.0 INR 2 0.0 6.0 2026-01-27 13:10:08
3237 3446 2 842 12517 44 Vital Glow Face Scrub NULL 3304300 43 0.0 325.0 0.0 0.0 260.0 220.34 39.66 13975.0 0.0 11180.0 0.0 0.0 0.0 0.0 18.0 1705.42 9474.58 1705.42 11180.0 INR 2 6.0 568.47 2026-01-27 13:10:08
3238 3447 1 843 12516 44 Vital Glow Face Scrub NULL 3304300 43 0.0 325.0 0.0 0.0 260.0 220.34 39.66 13975.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-01-27 13:10:27
3239 3448 1 844 12517 33 Herbal Soap 100gm NULL 30049011 2500 0.0 100.0 0.0 0.0 80.0 76.19 3.81 250000.0 0.0 200000.0 0.0 0.0 0.0 0.0 5.0 9523.81 190476.25 9523.81 200000.0 INR 2 6.0 11428.58 2026-01-27 13:20:50
3240 3449 2 844 12517 1 Stem Cell Powder NULL 2936900 200 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 499800.0 0.0 399800.0 0.0 0.0 0.0 0.0 5.0 19038.1 380761.9 19038.1 399800.0 INR 2 6.0 22845.71 2026-01-27 13:20:50
3241 3450 1 845 12516 1 Stem Cell Powder NULL 2936900 200 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 499800.0 0.0 399800.0 2.5 9519.05 2.5 9519.05 0.0 0.0 380761.9 19038.1 399800.0 INR 1 8.0 30460.95 2026-01-27 13:21:22
3242 3451 1 846 12516 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 1 8.0 20.61 2026-01-27 18:05:11
3243 3452 1 847 12555 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-27 19:35:15
3244 3453 2 847 12555 4 Diabetic 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-27 19:35:15
3245 3454 3 847 12555 2 Heart Care Capsules NULL 2936900 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-01-27 19:35:15
3246 3455 4 847 12555 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-27 19:35:15
3247 3456 1 848 12554 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 2 5.0 34.29 2026-01-27 19:43:43
3248 3457 2 848 12554 4 Diabetic 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 2 5.0 34.29 2026-01-27 19:43:43
3249 3458 3 848 12554 2 Heart Care Capsules NULL 2936900 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 2 5.0 57.14 2026-01-27 19:43:43
3250 3459 4 848 12554 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 2 5.0 95.19 2026-01-27 19:43:43