fx_order_product

11,631 rows · 35 columns · page 227 / 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
11301 11301 3 6549 16437 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 0.0 0.011 0.0 INR 2026-06-19 17:07:33 0 NULL NULL NULL NULL
11302 11302 4 6549 16437 33 HALDI CHANDAN SOAP 100gm 30049011 3 100.0 1 20.0 76.19 35.0 0.009 0.0 300.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 240.0 0.0 0.027 0.0 INR 2026-06-19 17:07:33 0 NULL NULL NULL NULL
11303 11303 5 6549 16437 34 HERBO 33 TOOTHPASTE 33061090 4 199.0 1 40.0 134.75 55.0 0.025 0.0 796.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 636.0 0.0 0.1 0.0 INR 2026-06-19 17:07:33 0 NULL NULL NULL NULL
11304 11304 6 6549 16437 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 0.0 0.04 0.0 INR 2026-06-19 17:07:33 0 NULL NULL NULL NULL
11305 11305 7 6549 16437 35 Sanitary Pad (15 pcs) 9619001 1 380.0 1 76.0 304.0 150.0 0.05 0.0 380.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 0.05 0.0 INR 2026-06-19 17:07:33 0 NULL NULL NULL NULL
11306 11306 8 6549 16437 36 Toilet Cleaner 500ml 3924101 1 150.0 1 30.0 101.69 42.0 0.011 0.0 150.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 120.0 0.0 0.011 0.0 INR 2026-06-19 17:07:33 0 NULL NULL NULL NULL
11307 11307 1 6550 16033 33 HALDI CHANDAN SOAP 100gm 30049011 2 100.0 1 20.0 76.19 35.0 0.009 0.0 200.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 160.0 70.0 0.0 0.0 INR 2026-06-19 19:05:25 0 NULL NULL NULL NULL
11308 11308 1 6551 16254 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 0.0 0.05 0.0 INR 2026-06-19 19:07:30 0 NULL NULL NULL NULL
11309 11309 2 6551 16254 33 HALDI CHANDAN SOAP 100gm 30049011 2 100.0 1 20.0 76.19 35.0 0.009 0.0 200.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 160.0 0.0 0.018 0.0 INR 2026-06-19 19:07:30 0 NULL NULL NULL NULL
11310 11310 1 6552 16436 60 Foot patch 30051090 1 1999.0 1 400.0 1522.86 799.0 0.3 0.0 1999.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1599.0 0.0 0.3 0.0 INR 2026-06-19 19:18:01 0 NULL NULL NULL NULL
11311 11311 2 6552 16436 81 PREMIUM GLOW FACE WASH 3404 1 699.0 1 140.0 473.73 279.0 0.11 0.0 699.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 559.0 0.0 0.11 0.0 INR 2026-06-19 19:18:01 0 NULL NULL NULL NULL
11312 11312 3 6552 16436 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 0.0 0.11 0.0 INR 2026-06-19 19:18:01 0 NULL NULL NULL NULL
11313 11313 1 6553 16436 60 Foot patch 30051090 1 1999.0 1 400.0 1522.86 799.0 0.3 0.0 1999.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1599.0 0.0 0.3 0.0 INR 2026-06-19 19:19:54 0 NULL NULL NULL NULL
11314 11314 2 6553 16436 81 PREMIUM GLOW FACE WASH 3404 1 699.0 1 140.0 473.73 279.0 0.11 0.0 699.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 559.0 0.0 0.11 0.0 INR 2026-06-19 19:19:54 0 NULL NULL NULL NULL
11315 11315 3 6553 16436 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 0.0 0.11 0.0 INR 2026-06-19 19:19:54 0 NULL NULL NULL NULL
11316 11316 1 6554 16129 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-20 15:17:10 0 NULL NULL NULL NULL
11317 11317 2 6554 16129 96 TRIM VEDA 30049011 1 2500.0 1 1000.0 1428.57 750.0 0.3 0.0 2500.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1500.0 750.0 0.0 0.0 INR 2026-06-20 15:17:10 0 NULL NULL NULL NULL
11318 11318 1 6555 15871 1 Stem Cell Powder 2936900 1 2499.0 1 1499.0 952.38 500.0 0.18 0.0 2499.0 1000.0 2.5 23.81 2.5 23.81 0.0 0.0 1000.0 500.0 0.0 0.0 INR 2026-06-20 15:17:48 0 NULL NULL NULL NULL
11319 11319 1 6556 15872 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-20 15:18:40 0 NULL NULL NULL NULL
11320 11320 2 6556 15872 34 HERBO 33 TOOTHPASTE 33061090 2 199.0 1 40.0 134.75 55.0 0.025 0.0 398.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 318.0 110.0 0.0 0.0 INR 2026-06-20 15:18:40 0 NULL NULL NULL NULL
11321 11321 3 6556 15872 41 Premium Coco Body Lotion 3304300 1 699.0 1 140.0 473.73 279.0 0.1 0.0 699.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 559.0 279.0 0.0 0.0 INR 2026-06-20 15:18:40 0 NULL NULL NULL NULL
11322 11322 1 6557 15244 39 Fabric Wash 1000ml 34029099 1 401.0 1 80.0 272.03 112.0 0.022 0.0 401.0 321.0 0.0 0.0 0.0 0.0 18.0 48.97 321.0 112.0 0.0 0.0 INR 2026-06-20 15:23:24 0 NULL NULL NULL NULL
11323 11323 2 6557 15244 33 HALDI CHANDAN SOAP 100gm 30049011 1 100.0 1 20.0 76.19 35.0 0.009 0.0 100.0 80.0 0.0 0.0 0.0 0.0 5.0 3.81 80.0 35.0 0.0 0.0 INR 2026-06-20 15:23:24 0 NULL NULL NULL NULL
11324 11324 3 6557 15244 32 Neem Soap 100gm 34011110 1 60.0 1 8.0 49.52 20.0 0.006 0.0 60.0 52.0 0.0 0.0 0.0 0.0 5.0 2.48 52.0 20.0 0.0 0.0 INR 2026-06-20 15:23:24 0 NULL NULL NULL NULL
11325 11325 4 6557 15244 47 Premium Hair Care Shampoo 3305109 1 699.0 1 140.0 532.38 279.0 0.11 0.0 699.0 559.0 0.0 0.0 0.0 0.0 5.0 26.62 559.0 279.0 0.0 0.0 INR 2026-06-20 15:23:24 0 NULL NULL NULL NULL
11326 11326 1 6558 14903 20 Premium Berry Juice 1000ml 2936900 2 3499.0 1 1899.0 1523.81 800.0 0.25 0.0 6998.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 3200.0 0.0 0.5 0.0 INR 2026-06-20 19:51:15 0 NULL NULL NULL NULL
11327 11327 1 6559 16438 60 Foot patch 30051090 2 1999.0 1 400.0 1522.86 799.0 0.3 0.0 3998.0 3198.0 2.5 76.14 2.5 76.14 0.0 0.0 3198.0 0.0 0.6 0.0 INR 2026-06-21 16:36:43 0 NULL NULL NULL NULL
11328 11328 1 6560 16441 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-23 09:50:46 0 NULL NULL NULL NULL
11329 11329 2 6560 16441 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 0.0 0.25 0.0 INR 2026-06-23 09:50:46 0 NULL NULL NULL NULL
11330 11330 1 6561 16440 65 SINGLE WELLNESS 94041000 1 12999.0 1 2299.0 10190.48 5350.0 2.0 0.0 12999.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10700.0 0.0 2.0 0.0 INR 2026-06-23 10:40:58 0 NULL NULL NULL NULL
11331 11331 1 6562 16418 8 Piles Care 30049011 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 0.0 0.15 0.0 INR 2026-06-24 12:33:42 0 NULL NULL NULL NULL
11332 11332 2 6562 16418 36 Toilet Cleaner 500ml 3924101 1 150.0 1 30.0 101.69 42.0 0.011 0.0 150.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 120.0 0.0 0.011 0.0 INR 2026-06-24 12:33:42 0 NULL NULL NULL NULL
11333 11333 1 6563 16383 64 Bio magnetic bracelet 9404 1 9999.0 1 7499.0 2427.18 1250.0 0.5 0.0 9999.0 2500.0 1.5 36.41 1.5 36.41 0.0 0.0 2500.0 1250.0 0.0 0.0 INR 2026-06-24 16:30:39 0 NULL NULL NULL NULL
11334 11334 1 6564 15872 64 Bio magnetic bracelet 9404 1 9999.0 1 7499.0 2427.18 1250.0 0.5 0.0 9999.0 2500.0 1.5 36.41 1.5 36.41 0.0 0.0 2500.0 1250.0 0.0 0.0 INR 2026-06-24 16:31:27 0 NULL NULL NULL NULL
11335 11335 1 6565 12389 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-24 16:34:47 0 NULL NULL NULL NULL
11336 11336 2 6565 12389 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 0.0 0.05 0.0 INR 2026-06-24 16:34:47 0 NULL NULL NULL NULL
11337 11337 3 6565 12389 28 Ortho Joint Shield 2009899 1 1499.0 1 299.0 1142.86 600.0 0.25 0.0 1499.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1200.0 0.0 0.25 0.0 INR 2026-06-24 16:34:47 0 NULL NULL NULL NULL
11338 11338 1 6566 16434 8 Piles Care 30049011 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 0.0 0.15 0.0 INR 2026-06-24 19:02:44 0 NULL NULL NULL NULL
11339 11339 1 6567 16439 64 Bio magnetic bracelet 9404 1 9999.0 1 7499.0 2427.18 1250.0 0.5 0.0 9999.0 2500.0 1.5 36.41 1.5 36.41 0.0 0.0 2500.0 0.0 0.5 0.0 INR 2026-06-25 18:28:47 0 NULL NULL NULL NULL
11340 11340 1 6568 16374 52 Bhoo sanjeevni 5 kg 3103100 1 1600.0 1 350.0 1190.48 625.0 0.25 0.0 1600.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1250.0 0.0 0.25 0.0 INR 2026-06-25 19:01:17 0 NULL NULL NULL NULL
11341 11341 2 6568 16374 53 Terra care 2 kg 3103100 1 1500.0 1 350.0 1095.24 575.0 0.25 0.0 1500.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1150.0 0.0 0.25 0.0 INR 2026-06-25 19:01:17 0 NULL NULL NULL NULL
11342 11342 1 6569 5430 82 ALKALINE CAPSULE 3402000 1 2500.0 1 850.0 1571.43 800.0 0.25 0.0 2500.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1650.0 800.0 0.0 0.0 INR 2026-06-27 10:10:01 0 NULL NULL NULL NULL
11343 11343 1 6570 15258 82 ALKALINE CAPSULE 3402000 1 2500.0 1 850.0 1571.43 800.0 0.25 0.0 2500.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1650.0 0.0 0.25 0.0 INR 2026-06-27 13:01:52 0 NULL NULL NULL NULL
11344 11344 2 6570 15258 49 Anti Dandruff Serum 3304999 1 999.0 1 200.0 677.12 399.0 0.15 0.0 999.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 799.0 0.0 0.15 0.0 INR 2026-06-27 13:01:52 0 NULL NULL NULL NULL
11345 11345 3 6570 15258 33 HALDI CHANDAN SOAP 100gm 30049011 10 100.0 1 20.0 76.19 35.0 0.009 0.0 1000.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 800.0 0.0 0.09 0.0 INR 2026-06-27 13:01:52 0 NULL NULL NULL NULL
11346 11346 4 6570 15258 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 0.0 0.075 0.0 INR 2026-06-27 13:01:52 0 NULL NULL NULL NULL
11347 11347 1 6571 16375 52 Bhoo sanjeevni 5 kg 3103100 1 1600.0 1 350.0 1190.48 625.0 0.25 0.0 1600.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1250.0 0.0 0.25 0.0 INR 2026-06-27 21:14:12 0 NULL NULL NULL NULL
11348 11348 2 6571 16375 53 Terra care 2 kg 3103100 1 1500.0 1 350.0 1095.24 575.0 0.25 0.0 1500.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1150.0 0.0 0.25 0.0 INR 2026-06-27 21:14:12 0 NULL NULL NULL NULL
11349 11349 1 6572 16450 27 Multicharge Cap 2009899 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-28 15:10:32 0 NULL NULL NULL NULL
11350 11350 2 6572 16450 27 Multicharge Cap 2009899 1 1499.0 1 299.0 1142.86 600.0 0.25 0.0 1499.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1200.0 0.0 0.25 0.0 INR 2026-06-28 15:10:32 0 NULL NULL NULL NULL