fx_order_product

11,631 rows · 35 columns · page 230 / 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
11451 11451 1 6604 15169 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-30 20:07:16 0 NULL NULL NULL NULL
11452 11452 2 6604 15169 95 STRI VEDA 30049011 1 2500.0 1 1000.0 1428.57 750.0 0.3 0.0 2500.0 1500.0 0.0 0.0 0.0 0.0 5.0 71.43 1500.0 750.0 0.0 0.0 INR 2026-06-30 20:07:16 0 NULL NULL NULL NULL
11453 11453 1 6605 16286 46 Root Vitality Hair Oil 3305901 10 255.0 1 51.0 194.29 102.0 0.04 0.0 2550.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 2040.0 0.0 0.4 0.0 INR 2026-06-30 20:36:46 0 NULL NULL NULL NULL
11454 11454 1 6606 5289 37 Floor Cleaner 500ml 3924101 3 199.0 1 40.0 134.75 55.0 0.011 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 20:55:13 0 NULL NULL NULL NULL
11455 11455 2 6606 5289 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 20:55:13 0 NULL NULL NULL NULL
11456 11456 3 6606 5289 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 20:55:13 0 NULL NULL NULL NULL
11457 11457 1 6607 15207 34 HERBO 33 TOOTHPASTE 33061090 11 199.0 1 40.0 134.75 55.0 0.025 0.0 2189.0 1749.0 9.0 133.4 9.0 133.4 0.0 0.0 1749.0 605.0 0.0 0.0 INR 2026-06-30 21:03:53 0 NULL NULL NULL NULL
11458 11458 1 6608 15207 33 HALDI CHANDAN SOAP 100gm 30049011 12 100.0 1 20.0 76.19 35.0 0.009 0.0 1200.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 960.0 420.0 0.0 0.0 INR 2026-06-30 21:20:07 0 NULL NULL NULL NULL
11459 11459 1 6609 5574 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 625.0 0.0 0.0 INR 2026-06-30 21:36:19 0 NULL NULL NULL NULL
11460 11460 1 6610 5783 31 Vegan Plant Protein Powder 21061000 1 2999.0 1 1599.0 1333.33 700.0 0.2 0.0 2999.0 1400.0 2.5 33.33 2.5 33.33 0.0 0.0 1400.0 700.0 0.0 0.0 INR 2026-06-30 21:38:55 0 NULL NULL NULL NULL
11461 11461 2 6610 5783 48 Glow it multi fruit face wash 3304999 2 450.0 1 130.0 271.19 160.0 0.05 0.0 900.0 640.0 9.0 48.81 9.0 48.81 0.0 0.0 640.0 320.0 0.0 0.0 INR 2026-06-30 21:38:55 0 NULL NULL NULL NULL
11462 11462 1 6611 7075 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 600.0 0.0 0.0 INR 2026-06-30 22:38:06 0 NULL NULL NULL NULL
11463 11463 2 6611 7075 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-30 22:38:06 0 NULL NULL NULL NULL
11464 11464 3 6611 7075 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 42.0 0.0 0.0 INR 2026-06-30 22:38:06 0 NULL NULL NULL NULL
11465 11465 1 6612 10031 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 22:39:24 0 NULL NULL NULL NULL
11466 11466 2 6612 10031 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 22:39:24 0 NULL NULL NULL NULL
11467 11467 3 6612 10031 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 600.0 0.0 0.0 INR 2026-06-30 22:39:24 0 NULL NULL NULL NULL
11468 11468 1 6613 14970 4 Diabetic Care Capsules 2936900 2 999.0 1 279.0 685.71 360.0 0.15 0.0 1998.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1440.0 720.0 0.0 0.0 INR 2026-06-30 22:40:53 0 NULL NULL NULL NULL
11469 11469 2 6613 14970 39 Fabric Wash 1000ml 34029099 2 401.0 1 80.0 272.03 112.0 0.022 0.0 802.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 642.0 224.0 0.0 0.0 INR 2026-06-30 22:40:53 0 NULL NULL NULL NULL
11470 11470 3 6613 14970 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 22:40:53 0 NULL NULL NULL NULL
11471 11471 1 6614 5564 31 Vegan Plant Protein Powder 21061000 1 2999.0 1 1599.0 1333.33 700.0 0.2 0.0 2999.0 1400.0 2.5 33.33 2.5 33.33 0.0 0.0 1400.0 700.0 0.0 0.0 INR 2026-06-30 23:56:18 0 NULL NULL NULL NULL
11472 11472 2 6614 5564 48 Glow it multi fruit face wash 3304999 2 450.0 1 130.0 271.19 160.0 0.05 0.0 900.0 640.0 9.0 48.81 9.0 48.81 0.0 0.0 640.0 320.0 0.0 0.0 INR 2026-06-30 23:56:18 0 NULL NULL NULL NULL
11473 11473 1 6615 16434 36 Toilet Cleaner 500ml 3924101 5 150.0 1 30.0 101.69 42.0 0.011 0.0 750.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 600.0 0.0 0.055 0.0 INR 2026-07-01 12:17:24 0 NULL NULL NULL NULL
11474 11474 1 6616 15243 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-07-06 13:53:33 0 NULL NULL NULL NULL
11475 11475 2 6616 15243 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-07-06 13:53:33 0 NULL NULL NULL NULL
11476 11476 3 6616 15243 10 RADIANCE GLOW DAY CREAM 33049900 1 1424.0 1 674.0 635.59 375.0 0.1 0.0 1424.0 750.0 0.0 0.0 0.0 0.0 18.0 114.41 750.0 375.0 0.0 0.0 INR 2026-07-06 13:53:33 0 NULL NULL NULL NULL
11477 11477 1 6617 16392 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-07-06 19:48:33 0 NULL NULL NULL NULL
11478 11478 2 6617 16392 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-07-06 19:48:33 0 NULL NULL NULL NULL
11479 11479 1 6618 16393 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-07-06 20:00:34 0 NULL NULL NULL NULL
11480 11480 2 6618 16393 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-07-06 20:00:34 0 NULL NULL NULL NULL
11481 11481 1 6619 16458 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 0.0 0.15 0.0 INR 2026-07-06 20:11:17 0 NULL NULL NULL NULL
11482 11482 2 6619 16458 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-07-06 20:11:17 0 NULL NULL NULL NULL
11483 11483 3 6619 16458 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-07-06 20:11:17 0 NULL NULL NULL NULL
11484 11484 4 6619 16458 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 0.0 0.05 0.0 INR 2026-07-06 20:11:17 0 NULL NULL NULL NULL
11485 11485 5 6619 16458 32 Neem Soap 100gm 34011110 3 60.0 1 8.0 49.52 20.0 0.006 0.0 180.0 156.0 2.5 3.71 2.5 3.71 0.0 0.0 156.0 0.0 0.018 0.0 INR 2026-07-06 20:11:17 0 NULL NULL NULL NULL
11486 11486 6 6619 16458 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-07-06 20:11:17 0 NULL NULL NULL NULL
11487 11487 1 6620 16046 52 Bhoo sanjeevni 5 kg 3103100 4 1600.0 1 350.0 1190.48 625.0 0.25 0.0 6400.0 5000.0 2.5 119.05 2.5 119.05 0.0 0.0 5000.0 0.0 1.0 0.0 INR 2026-07-07 18:36:56 0 NULL NULL NULL NULL
11488 11488 2 6620 16046 53 Terra care 2 kg 3103100 4 1500.0 1 350.0 1095.24 575.0 0.25 0.0 6000.0 4600.0 2.5 109.52 2.5 109.52 0.0 0.0 4600.0 0.0 1.0 0.0 INR 2026-07-07 18:36:56 0 NULL NULL NULL NULL
11489 11489 1 6621 16462 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 0.0 0.05 0.0 INR 2026-07-13 13:48:33 0 NULL NULL NULL NULL
11490 11490 2 6621 16462 16 Liver Care Juice 2009899 4 349.0 1 49.0 285.71 150.0 0.05 0.0 1396.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1200.0 0.0 0.2 0.0 INR 2026-07-13 13:48:33 0 NULL NULL NULL NULL
11491 11491 3 6621 16462 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-07-13 13:48:33 0 NULL NULL NULL NULL
11492 11492 1 6622 16459 33 HALDI CHANDAN SOAP 100gm 30049011 28 100.0 1 20.0 76.19 35.0 0.009 0.0 2800.0 2240.0 2.5 53.33 2.5 53.33 0.0 0.0 2240.0 0.0 0.252 0.0 INR 2026-07-13 13:54:10 0 NULL NULL NULL NULL
11493 11493 2 6622 16459 34 HERBO 33 TOOTHPASTE 33061090 10 199.0 1 40.0 134.75 55.0 0.025 0.0 1990.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1590.0 0.0 0.25 0.0 INR 2026-07-13 13:54:10 0 NULL NULL NULL NULL
11494 11494 1 6623 16103 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-07-13 19:31:38 0 NULL NULL NULL NULL
11495 11495 2 6623 16103 33 HALDI CHANDAN SOAP 100gm 30049011 1 100.0 1 20.0 76.19 35.0 0.009 0.0 100.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 80.0 0.0 0.009 0.0 INR 2026-07-13 19:31:38 0 NULL NULL NULL NULL
11496 11496 3 6623 16103 34 HERBO 33 TOOTHPASTE 33061090 1 199.0 1 40.0 134.75 55.0 0.025 0.0 199.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 159.0 0.0 0.025 0.0 INR 2026-07-13 19:31:38 0 NULL NULL NULL NULL
11497 11497 4 6623 16103 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 0.0 0.08 0.0 INR 2026-07-13 19:31:38 0 NULL NULL NULL NULL
11498 11498 1 6624 16460 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-07-14 08:20:48 0 NULL NULL NULL NULL
11499 11499 2 6624 16460 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-07-14 08:20:48 0 NULL NULL NULL NULL
11500 11500 1 6625 16461 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-07-14 08:22:45 0 NULL NULL NULL NULL