fx_order_product

11,631 rows · 35 columns · page 229 / 233

Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_MRP prod_dis_type prod_dis prod_dis_amt product_bv product_pv product_sv total_mrp total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount final_amount total_bv total_pv total_sv _currency created_on free_prod_delevery_status delivered_on delivery_by deliver_name del_contact_no
11401 11401 1 6589 8123 39 Fabric Wash 1000ml 34029099 4 401.0 1 80.0 272.03 112.0 0.022 0.0 1604.0 1284.0 9.0 97.93 9.0 97.93 0.0 0.0 1284.0 448.0 0.0 0.0 INR 2026-06-29 22:47:45 0 NULL NULL NULL NULL
11402 11402 2 6589 8123 81 PREMIUM GLOW FACE WASH 3404 2 699.0 1 140.0 473.73 279.0 0.11 0.0 1398.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 1118.0 558.0 0.0 0.0 INR 2026-06-29 22:47:45 0 NULL NULL NULL NULL
11403 11403 1 6590 5362 10 RADIANCE GLOW DAY CREAM 33049900 1 1424.0 1 674.0 635.59 375.0 0.1 0.0 1424.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 750.0 375.0 0.0 0.0 INR 2026-06-29 22:54:38 0 NULL NULL NULL NULL
11404 11404 2 6590 5362 44 Vital Glow Face Scrub 3304300 1 325.0 1 65.0 220.34 130.0 0.021 0.0 325.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 260.0 130.0 0.0 0.0 INR 2026-06-29 22:54:38 0 NULL NULL NULL NULL
11405 11405 1 6591 15347 20 Premium Berry Juice 1000ml 2936900 1 3499.0 1 1899.0 0.95 0.0 0.0 0.0 3499.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 0.0 0.0 0.0 INR 2026-06-30 12:26:50 0 NULL NULL NULL NULL
11406 11406 2 6591 15347 20 Premium Berry Juice 1000ml 2936900 1 3499.0 1 1899.0 1523.81 800.0 0.25 0.0 3499.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1600.0 800.0 0.0 0.0 INR 2026-06-30 12:26:50 0 NULL NULL NULL NULL
11407 11407 3 6591 15347 94 PAVANA DROPS 30041211 1 699.0 1 200.0 475.24 249.0 0.1 0.0 699.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 499.0 249.0 0.0 0.0 INR 2026-06-30 12:26:50 0 NULL NULL NULL NULL
11408 11408 1 6592 15348 48 Glow it multi fruit face wash 3304999 1 450.0 1 130.0 271.19 160.0 0.05 0.0 450.0 320.0 9.0 24.41 9.0 24.41 0.0 0.0 320.0 160.0 0.0 0.0 INR 2026-06-30 12:30:13 0 NULL NULL NULL NULL
11409 11409 2 6592 15348 17 Memory Booster Juice 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 300.0 150.0 0.0 0.0 INR 2026-06-30 12:30:13 0 NULL NULL NULL NULL
11410 11410 3 6592 15348 32 Neem Soap 100gm 34011110 1 60.0 1 8.0 49.52 20.0 0.006 0.0 60.0 52.0 2.5 1.24 2.5 1.24 0.0 0.0 52.0 20.0 0.0 0.0 INR 2026-06-30 12:30:13 0 NULL NULL NULL NULL
11411 11411 4 6592 15348 10 RADIANCE GLOW DAY CREAM 33049900 2 1424.0 1 674.0 635.59 375.0 0.1 0.0 2848.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1500.0 750.0 0.0 0.0 INR 2026-06-30 12:30:13 0 NULL NULL NULL NULL
11412 11412 1 6593 15281 2 Heart Care Capsules 2936900 1 1499.0 1 299.0 0.95 0.0 0.0 0.0 1499.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 0.0 0.0 0.0 INR 2026-06-30 14:40:52 0 NULL NULL NULL NULL
11413 11413 2 6593 15281 2 Heart Care Capsules 2936900 1 1499.0 1 299.0 1142.86 600.0 0.2 0.0 1499.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1200.0 600.0 0.0 0.0 INR 2026-06-30 14:40:52 0 NULL NULL NULL NULL
11414 11414 3 6593 15281 46 Root Vitality Hair Oil 3305901 4 255.0 1 51.0 194.29 102.0 0.04 0.0 1020.0 816.0 2.5 19.43 2.5 19.43 0.0 0.0 816.0 408.0 0.0 0.0 INR 2026-06-30 14:40:52 0 NULL NULL NULL NULL
11415 11415 1 6594 15344 46 Root Vitality Hair Oil 3305901 6 255.0 1 51.0 194.29 102.0 0.04 0.0 1530.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 1224.0 612.0 0.0 0.0 INR 2026-06-30 18:14:44 0 NULL NULL NULL NULL
11416 11416 1 6595 5326 46 Root Vitality Hair Oil 3305901 5 255.0 1 51.0 194.29 102.0 0.04 0.0 1275.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 1020.0 510.0 0.0 0.0 INR 2026-06-30 18:16:17 0 NULL NULL NULL NULL
11417 11417 1 6596 15294 38 Dish Wash 500ml 34029099 1 230.0 1 46.0 155.93 65.0 0.011 0.0 230.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 184.0 65.0 0.0 0.0 INR 2026-06-30 18:43:50 0 NULL NULL NULL NULL
11418 11418 2 6596 15294 37 Floor Cleaner 500ml 3924101 1 199.0 1 40.0 134.75 55.0 0.011 0.0 199.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 159.0 55.0 0.0 0.0 INR 2026-06-30 18:43:50 0 NULL NULL NULL NULL
11419 11419 3 6596 15294 32 Neem Soap 100gm 34011110 10 60.0 1 8.0 49.52 20.0 0.006 0.0 600.0 520.0 2.5 12.38 2.5 12.38 0.0 0.0 520.0 200.0 0.0 0.0 INR 2026-06-30 18:43:50 0 NULL NULL NULL NULL
11420 11420 4 6596 15294 46 Root Vitality Hair Oil 3305901 2 255.0 1 51.0 194.29 102.0 0.04 0.0 510.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 408.0 204.0 0.0 0.0 INR 2026-06-30 18:43:50 0 NULL NULL NULL NULL
11421 11421 1 6597 15876 32 Neem Soap 100gm 34011110 25 60.0 1 8.0 49.52 20.0 0.006 0.0 1500.0 1300.0 2.5 30.95 2.5 30.95 0.0 0.0 1300.0 500.0 0.0 0.0 INR 2026-06-30 19:06:04 0 NULL NULL NULL NULL
11422 11422 1 6598 16234 33 HALDI CHANDAN SOAP 100gm 30049011 6 100.0 1 20.0 76.19 35.0 0.009 0.0 600.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 480.0 210.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11423 11423 2 6598 16234 15 KIDNEY CARE JUICE 2009899 1 349.0 1 49.0 0.95 0.0 0.0 0.0 349.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 0.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11424 11424 3 6598 16234 15 KIDNEY CARE JUICE 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 300.0 150.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11425 11425 4 6598 16234 16 Liver Care Juice 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 300.0 150.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11426 11426 5 6598 16234 7 Morning Fresh Churan 30049011 1 199.0 1 20.0 170.48 79.0 0.015 0.0 199.0 179.0 2.5 4.26 2.5 4.26 0.0 0.0 179.0 79.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11427 11427 6 6598 16234 32 Neem Soap 100gm 34011110 5 60.0 1 8.0 49.52 20.0 0.006 0.0 300.0 260.0 2.5 6.19 2.5 6.19 0.0 0.0 260.0 100.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11428 11428 7 6598 16234 47 Premium Hair Care Shampoo 3305109 1 699.0 1 140.0 532.38 279.0 0.11 0.0 699.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 559.0 279.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11429 11429 8 6598 16234 43 Quench Kiss Lip Balm 3304300 1 199.0 1 40.0 134.75 79.0 0.012 0.0 199.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 159.0 79.0 0.0 0.0 INR 2026-06-30 19:09:04 0 NULL NULL NULL NULL
11430 11430 1 6599 15152 82 ALKALINE CAPSULE 3402000 1 2500.0 1 850.0 1571.43 800.0 0.25 0.0 2500.0 1650.0 0.0 0.0 0.0 0.0 5.0 78.57 1650.0 800.0 0.0 0.0 INR 2026-06-30 19:10:00 0 NULL NULL NULL NULL
11431 11431 2 6599 15152 33 HALDI CHANDAN SOAP 100gm 30049011 2 100.0 1 20.0 76.19 35.0 0.009 0.0 200.0 160.0 0.0 0.0 0.0 0.0 5.0 7.62 160.0 70.0 0.0 0.0 INR 2026-06-30 19:10:00 0 NULL NULL NULL NULL
11432 11432 3 6599 15152 34 HERBO 33 TOOTHPASTE 33061090 1 199.0 1 40.0 134.75 55.0 0.025 0.0 199.0 159.0 0.0 0.0 0.0 0.0 18.0 24.25 159.0 55.0 0.0 0.0 INR 2026-06-30 19:10:00 0 NULL NULL NULL NULL
11433 11433 4 6599 15152 15 KIDNEY CARE JUICE 2009899 1 349.0 1 49.0 0.95 0.0 0.0 0.0 349.0 1.0 0.0 0.0 0.0 0.0 5.0 0.05 1.0 0.0 0.0 0.0 INR 2026-06-30 19:10:00 0 NULL NULL NULL NULL
11434 11434 5 6599 15152 15 KIDNEY CARE JUICE 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 0.0 0.0 0.0 0.0 5.0 14.29 300.0 150.0 0.0 0.0 INR 2026-06-30 19:10:00 0 NULL NULL NULL NULL
11435 11435 1 6600 15875 16 Liver Care Juice 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 300.0 150.0 0.0 0.0 INR 2026-06-30 19:13:53 0 NULL NULL NULL NULL
11436 11436 2 6600 15875 25 Manicalcium 2009899 1 399.0 1 80.0 0.95 0.0 0.0 0.0 399.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 0.0 0.0 0.0 INR 2026-06-30 19:13:53 0 NULL NULL NULL NULL
11437 11437 3 6600 15875 25 Manicalcium 2009899 1 399.0 1 80.0 303.81 159.0 0.05 0.0 399.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 319.0 159.0 0.0 0.0 INR 2026-06-30 19:13:53 0 NULL NULL NULL NULL
11438 11438 4 6600 15875 9 Omega 369 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-06-30 19:13:53 0 NULL NULL NULL NULL
11439 11439 5 6600 15875 94 PAVANA DROPS 30041211 1 699.0 1 200.0 475.24 249.0 0.1 0.0 699.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 499.0 249.0 0.0 0.0 INR 2026-06-30 19:13:53 0 NULL NULL NULL NULL
11440 11440 6 6600 15875 46 Root Vitality Hair Oil 3305901 1 255.0 1 51.0 194.29 102.0 0.04 0.0 255.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 204.0 102.0 0.0 0.0 INR 2026-06-30 19:13:53 0 NULL NULL NULL NULL
11441 11441 1 6601 15344 34 HERBO 33 TOOTHPASTE 33061090 3 199.0 1 40.0 134.75 55.0 0.025 0.0 597.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 477.0 165.0 0.0 0.0 INR 2026-06-30 19:24:28 0 NULL NULL NULL NULL
11442 11442 2 6601 15344 94 PAVANA DROPS 30041211 1 699.0 1 200.0 475.24 249.0 0.1 0.0 699.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 499.0 249.0 0.0 0.0 INR 2026-06-30 19:24:28 0 NULL NULL NULL NULL
11443 11443 1 6602 15370 4 Diabetic Care Capsules 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-06-30 19:34:54 0 NULL NULL NULL NULL
11444 11444 2 6602 15370 33 HALDI CHANDAN SOAP 100gm 30049011 6 100.0 1 20.0 76.19 35.0 0.009 0.0 600.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 480.0 210.0 0.0 0.0 INR 2026-06-30 19:34:54 0 NULL NULL NULL NULL
11445 11445 3 6602 15370 34 HERBO 33 TOOTHPASTE 33061090 6 199.0 1 40.0 134.75 55.0 0.025 0.0 1194.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 954.0 330.0 0.0 0.0 INR 2026-06-30 19:34:54 0 NULL NULL NULL NULL
11446 11446 4 6602 15370 32 Neem Soap 100gm 34011110 5 60.0 1 8.0 49.52 20.0 0.006 0.0 300.0 260.0 2.5 6.19 2.5 6.19 0.0 0.0 260.0 100.0 0.0 0.0 INR 2026-06-30 19:34:54 0 NULL NULL NULL NULL
11447 11447 1 6603 15721 6 ASTORELIFE GUARD 30049011 1 899.0 1 179.0 685.71 360.0 0.15 0.0 899.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-06-30 19:40:21 0 NULL NULL NULL NULL
11448 11448 2 6603 15721 48 Glow it multi fruit face wash 3304999 1 450.0 1 130.0 271.19 160.0 0.05 0.0 450.0 320.0 9.0 24.41 9.0 24.41 0.0 0.0 320.0 160.0 0.0 0.0 INR 2026-06-30 19:40:21 0 NULL NULL NULL NULL
11449 11449 3 6603 15721 33 HALDI CHANDAN SOAP 100gm 30049011 4 100.0 1 20.0 76.19 35.0 0.009 0.0 400.0 320.0 2.5 7.62 2.5 7.62 0.0 0.0 320.0 140.0 0.0 0.0 INR 2026-06-30 19:40:21 0 NULL NULL NULL NULL
11450 11450 4 6603 15721 30 Iron Capsules 30049011 1 899.0 1 180.0 684.76 359.0 0.15 0.0 899.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 719.0 359.0 0.0 0.0 INR 2026-06-30 19:40:21 0 NULL NULL NULL NULL