fx_franchise_order_product

4,737 rows · 33 columns · page 85 / 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
4201 4410 5 1086 14902 37 Floor Cleaner 500ml NULL 3924101 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.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-04-17 14:32:34
4202 4411 6 1086 14902 60 Foot patch NULL 30051090 1 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 799.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-04-17 14:32:34
4203 4412 7 1086 14902 48 Glow it multi fruit face wash NULL 3304999 3 160.0 450.0 0.0 0.0 320.0 271.19 48.81 1350.0 480.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 813.56 146.44 960.0 INR 3 2.0 16.27 2026-04-17 14:32:34
4204 4413 8 1086 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 20 35.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 700.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-04-17 14:32:34
4205 4414 9 1086 14902 32 Neem Soap 100gm NULL 34011110 50 20.0 60.0 0.0 0.0 52.0 49.52 2.48 3000.0 1000.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-04-17 14:32:34
4206 4415 10 1086 14902 9 Omega 369 NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-04-17 14:32:34
4207 4416 11 1086 14902 35 Sanitary Pad (15 pcs) NULL 9619001 5 150.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 750.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-04-17 14:32:34
4208 4417 12 1086 14902 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-04-17 14:32:34
4209 4418 13 1086 14902 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 750.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-04-17 14:32:34
4210 4419 14 1086 14902 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-04-17 14:32:34
4211 4420 1 1087 12517 65 SINGLE WELLNESS NULL 94041000 10 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 129990.0 53500.0 107000.0 0.0 0.0 0.0 0.0 5.0 5095.24 101904.76 5095.24 107000.0 INR 2 6.0 6114.29 2026-04-18 15:47:56
4212 4421 1 1088 12516 64 Bio magnetic bracelet NULL 9404 50 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 499950.0 62500.0 125000.0 1.5 1820.39 1.5 1820.39 0.0 0.0 121359.23 3640.78 125000.0 INR 1 8.0 9708.74 2026-04-18 17:22:29
4213 4422 1 1089 12554 64 Bio magnetic bracelet NULL 9404 20 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 199980.0 25000.0 50000.0 1.5 728.16 1.5 728.16 0.0 0.0 48543.69 1456.31 50000.0 INR 2 6.0 2912.62 2026-04-18 17:24:01
4214 4423 1 1090 12555 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 3 2.0 485.44 2026-04-18 17:24:42
4215 4424 1 1091 12554 20 Premium Berry Juice 1000ml NULL 2936900 15 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 52485.0 12000.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 22857.14 1142.86 24000.0 INR 2 6.0 1371.43 2026-04-18 18:20:00
4216 4425 1 1092 12555 20 Premium Berry Juice 1000ml NULL 2936900 10 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 34990.0 8000.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.09 761.9 16000.0 INR 3 2.0 304.76 2026-04-18 18:21:42
4217 4426 1 1093 12555 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 5 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 1875.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-04-18 18:27:23
4218 4430 2 1095 12526 38 Dish Wash 500ml NULL 34029099 5 65.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 325.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-04-20 13:57:13
4219 4429 1 1095 12526 49 Anti Dandruff Serum NULL 3304999 2 399.0 999.0 0.0 0.0 799.0 677.12 121.88 1998.0 798.0 1598.0 9.0 121.88 9.0 121.88 0.0 0.0 1354.24 243.76 1598.0 INR 3 2.0 27.08 2026-04-20 13:57:13
4220 4431 3 1095 12526 19 Fat loss Juice 500 ml NULL 30049011 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-04-20 13:57:13
4221 4432 4 1095 12526 48 Glow it multi fruit face wash NULL 3304999 5 160.0 450.0 0.0 0.0 320.0 271.19 48.81 2250.0 800.0 1600.0 9.0 122.03 9.0 122.03 0.0 0.0 1355.93 244.07 1600.0 INR 3 2.0 27.12 2026-04-20 13:57:13
4222 4433 5 1095 12526 16 Liver Care Juice NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 3 2.0 5.71 2026-04-20 13:57:13
4223 4434 6 1095 12526 17 Memory Booster Juice NULL 2009899 5 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1745.0 750.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-04-20 13:57:13
4224 4435 7 1095 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 3 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 4272.0 1125.0 2250.0 9.0 171.61 9.0 171.61 0.0 0.0 1906.78 343.22 2250.0 INR 3 2.0 38.14 2026-04-20 13:57:13
4225 4436 8 1095 12526 34 Toothpaste NULL 33061090 24 55.0 199.0 0.0 0.0 159.0 134.75 24.25 4776.0 1320.0 3816.0 9.0 291.05 9.0 291.05 0.0 0.0 3233.9 582.1 3816.0 INR 3 2.0 64.68 2026-04-20 13:57:13
4226 4437 1 1096 12555 64 Bio magnetic bracelet NULL 9404 4 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 39996.0 5000.0 10000.0 1.5 145.63 1.5 145.63 0.0 0.0 9708.74 291.26 10000.0 INR 3 2.0 194.17 2026-04-20 19:40:03
4227 4438 1 1097 12555 64 Bio magnetic bracelet NULL 9404 4 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 39996.0 5000.0 10000.0 1.5 145.63 1.5 145.63 0.0 0.0 9708.74 291.26 10000.0 INR 3 2.0 194.17 2026-04-20 22:37:30
4228 4439 1 1098 12555 64 Bio magnetic bracelet NULL 9404 2 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 19998.0 2500.0 5000.0 1.5 72.82 1.5 72.82 0.0 0.0 4854.37 145.63 5000.0 INR 3 2.0 97.09 2026-04-20 22:55:05
4229 4440 1 1099 12516 64 Bio magnetic bracelet NULL 9404 20 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 199980.0 25000.0 50000.0 1.5 728.16 1.5 728.16 0.0 0.0 48543.69 1456.31 50000.0 INR 1 8.0 3883.5 2026-04-20 23:01:59
4230 4441 1 1100 12554 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 2 6.0 1456.31 2026-04-20 23:07:34
4231 4442 1 1101 12534 70 Premium Hand belt NULL 9404 2 720.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 5000.0 1440.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-04-22 18:46:06
4232 4443 1 1102 12526 32 Neem Soap 100gm NULL 34011110 8 20.0 60.0 0.0 0.0 52.0 49.52 2.48 480.0 160.0 416.0 2.5 9.9 2.5 9.9 0.0 0.0 396.19 19.81 416.0 INR 3 2.0 7.92 2026-04-22 19:06:56
4233 4444 1 1103 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-04-23 14:35:45
4234 4445 2 1103 12545 38 Dish Wash 500ml NULL 34029099 3 65.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 195.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 467.8 84.2 552.0 INR 3 2.0 9.36 2026-04-23 14:35:45
4235 4446 3 1103 12545 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.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-04-23 14:35:45
4236 4447 4 1103 12545 37 Floor Cleaner 500ml NULL 3924101 3 55.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 165.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-04-23 14:35:45
4237 4448 5 1103 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 15 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 525.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-04-23 14:35:45
4238 4449 6 1103 12545 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 2 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 750.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-04-23 14:35:45
4239 4450 7 1103 12545 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-04-23 14:35:45
4240 4451 8 1103 12545 36 Toilet Cleaner 500ml NULL 3924101 3 42.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 126.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-04-23 14:35:45
4241 4452 9 1103 12545 34 Toothpaste NULL 33061090 10 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 550.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-04-23 14:35:45
4242 4453 1 1104 12516 65 SINGLE WELLNESS NULL 94041000 5 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 64995.0 26750.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 1 8.0 4076.19 2026-04-24 15:23:28
4243 4454 1 1105 12554 65 SINGLE WELLNESS NULL 94041000 5 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 64995.0 26750.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 2 6.0 3057.14 2026-04-24 15:27:44
4244 4455 1 1106 12555 65 SINGLE WELLNESS NULL 94041000 3 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 38997.0 16050.0 32100.0 2.5 764.29 2.5 764.29 0.0 0.0 30571.43 1528.57 32100.0 INR 3 2.0 611.43 2026-04-24 15:30:32
4245 4456 1 1107 12554 82 ALKALINE CAPSULE NULL 3402000 5 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 12500.0 4000.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 7857.14 392.86 8250.0 INR 2 6.0 471.43 2026-04-24 15:32:24
4246 4457 1 1108 12555 82 ALKALINE CAPSULE NULL 3402000 5 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 12500.0 4000.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 7857.14 392.86 8250.0 INR 3 2.0 157.14 2026-04-24 15:34:12
4247 4458 1 1109 12516 97 Go Goa NULL NA 10 1000.0 30000.0 0.0 0.0 20000.0 18348.62 1651.38 300000.0 10000.0 200000.0 4.5 8256.88 4.5 8256.88 0.0 0.0 183486.24 16513.76 200000.0 INR 1 8.0 14678.9 2026-04-24 19:47:26
4248 4459 1 1110 12554 97 Go Goa NULL NA 10 1000.0 30000.0 0.0 0.0 20000.0 18348.62 1651.38 300000.0 10000.0 200000.0 4.5 8256.88 4.5 8256.88 0.0 0.0 183486.24 16513.76 200000.0 INR 2 6.0 11009.17 2026-04-24 19:49:37
4249 4460 1 1111 12555 97 Go Goa NULL NA 10 1000.0 30000.0 0.0 0.0 20000.0 18348.62 1651.38 300000.0 10000.0 200000.0 4.5 8256.88 4.5 8256.88 0.0 0.0 183486.24 16513.76 200000.0 INR 3 2.0 3669.72 2026-04-24 19:54:20
4250 4461 1 1112 12526 6 Asthma Care NULL 30049011 1 360.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 360.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-04-24 22:11:22