fx_order_product

11,631 rows · 35 columns · page 174 / 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
8651 8651 2 5082 15131 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 399.0 0.15 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8652 8652 3 5082 15131 39 Fabric Wash 1000ml 34029099 1 401.0 1 80.0 272.03 112.0 0.022 0.0 401.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 321.0 112.0 0.022 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8653 8653 4 5082 15131 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.011 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8654 8654 5 5082 15131 33 HALDI CHANDAN SOAP 100gm 30049011 5 100.0 1 20.0 76.19 35.0 0.009 0.0 500.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 400.0 175.0 0.045 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8655 8655 6 5082 15131 72 Pain Relief Patch 30051090 1 800.0 1 400.0 380.95 200.0 0.025 0.0 800.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 400.0 200.0 0.025 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8656 8656 7 5082 15131 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.04 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8657 8657 8 5082 15131 50 Sun Screen 330499 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 279.0 0.11 0.0 INR 2026-04-18 16:33:21 0 NULL NULL NULL NULL
8658 8658 1 5083 15131 39 Fabric Wash 1000ml 34029099 1 401.0 1 80.0 272.03 112.0 0.022 0.0 401.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 321.0 112.0 0.022 0.0 INR 2026-04-18 17:06:54 0 NULL NULL NULL NULL
8659 8659 2 5083 15131 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.011 0.0 INR 2026-04-18 17:06:54 0 NULL NULL NULL NULL
8660 8660 3 5083 15131 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 35.0 0.009 0.0 INR 2026-04-18 17:06:54 0 NULL NULL NULL NULL
8661 8661 1 5084 15131 11 BHRINGRAJ & SHIKAKAI 33051090 1 1250.0 1 500.0 714.29 375.0 0.1 0.0 1250.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 750.0 375.0 0.1 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8662 8662 2 5084 15131 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 399.0 0.15 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8663 8663 3 5084 15131 39 Fabric Wash 1000ml 34029099 1 401.0 1 80.0 272.03 112.0 0.022 0.0 401.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 321.0 112.0 0.022 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8664 8664 4 5084 15131 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.011 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8665 8665 5 5084 15131 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.054 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8666 8666 6 5084 15131 72 Pain Relief Patch 30051090 1 800.0 1 400.0 380.95 200.0 0.025 0.0 800.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 400.0 200.0 0.025 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8667 8667 7 5084 15131 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.04 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8668 8668 8 5084 15131 50 Sun Screen 330499 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 279.0 0.11 0.0 INR 2026-04-18 17:08:49 0 NULL NULL NULL NULL
8669 8669 1 5085 15202 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 799.0 0.3 0.0 INR 2026-04-18 17:16:35 0 NULL NULL NULL NULL
8670 8670 2 5085 15202 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.15 0.0 INR 2026-04-18 17:16:35 0 NULL NULL NULL NULL
8671 8671 3 5085 15202 12 PREMIUM RADIANCE FACE SERUM 33049990 1 1250.0 1 500.0 714.29 375.0 0.1 0.0 1250.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 750.0 375.0 0.1 0.0 INR 2026-04-18 17:16:35 0 NULL NULL NULL NULL
8672 8672 1 5086 15169 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.05 0.0 INR 2026-04-18 17:30:17 0 NULL NULL NULL NULL
8673 8673 2 5086 15169 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.25 0.0 INR 2026-04-18 17:30:17 0 NULL NULL NULL NULL
8674 8674 3 5086 15169 26 Spirulina Cap 2009899 1 899.0 1 180.0 0.95 359.0 0.15 0.0 899.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 359.0 0.15 0.0 INR 2026-04-18 17:30:17 0 NULL NULL NULL NULL
8675 8675 4 5086 15169 26 Spirulina Cap 2009899 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.15 0.0 INR 2026-04-18 17:30:17 0 NULL NULL NULL NULL
8676 8676 5 5086 15169 34 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.05 0.0 INR 2026-04-18 17:30:17 0 NULL NULL NULL NULL
8677 8677 1 5087 15140 17 Memory Booster Juice 2009899 3 349.0 1 49.0 285.71 150.0 0.05 0.0 1047.0 900.0 0.0 0.0 0.0 0.0 5.0 42.86 900.0 450.0 0.15 0.0 INR 2026-04-18 18:11:14 0 NULL NULL NULL NULL
8678 8678 2 5087 15140 81 PREMIUM GLOW FACE WASH 3404 1 699.0 1 140.0 473.73 279.0 0.11 0.0 699.0 559.0 0.0 0.0 0.0 0.0 18.0 85.27 559.0 279.0 0.11 0.0 INR 2026-04-18 18:11:14 0 NULL NULL NULL NULL
8679 8679 3 5087 15140 12 PREMIUM RADIANCE FACE SERUM 33049990 1 1250.0 1 500.0 714.29 375.0 0.1 0.0 1250.0 750.0 0.0 0.0 0.0 0.0 5.0 35.71 750.0 375.0 0.1 0.0 INR 2026-04-18 18:11:14 0 NULL NULL NULL NULL
8680 8680 4 5087 15140 46 Root Vitality Hair Oil 3305901 1 255.0 1 51.0 194.29 102.0 0.04 0.0 255.0 204.0 0.0 0.0 0.0 0.0 5.0 9.71 204.0 102.0 0.04 0.0 INR 2026-04-18 18:11:14 0 NULL NULL NULL NULL
8681 8681 5 5087 15140 50 Sun Screen 330499 1 699.0 1 140.0 473.73 279.0 0.11 0.0 699.0 559.0 0.0 0.0 0.0 0.0 18.0 85.27 559.0 279.0 0.11 0.0 INR 2026-04-18 18:11:14 0 NULL NULL NULL NULL
8682 8682 1 5088 15169 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.05 0.0 INR 2026-04-18 18:13:21 0 NULL NULL NULL NULL
8683 8683 2 5088 15169 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.25 0.0 INR 2026-04-18 18:13:21 0 NULL NULL NULL NULL
8684 8684 3 5088 15169 26 Spirulina Cap 2009899 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.15 0.0 INR 2026-04-18 18:13:21 0 NULL NULL NULL NULL
8685 8685 4 5088 15169 34 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.05 0.0 INR 2026-04-18 18:13:21 0 NULL NULL NULL NULL
8686 8686 1 5089 15141 27 Multicharge Cap 2009899 2 1499.0 1 299.0 1142.86 600.0 0.25 0.0 2998.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2400.0 1200.0 0.5 0.0 INR 2026-04-18 18:15:10 0 NULL NULL NULL NULL
8687 8687 1 5090 15147 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.25 0.0 INR 2026-04-18 18:30:00 0 NULL NULL NULL NULL
8688 8688 2 5090 15147 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.05 0.0 INR 2026-04-18 18:30:00 0 NULL NULL NULL NULL
8689 8689 3 5090 15147 12 PREMIUM RADIANCE FACE SERUM 33049990 1 1250.0 1 500.0 714.29 375.0 0.1 0.0 1250.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 750.0 375.0 0.1 0.0 INR 2026-04-18 18:30:00 0 NULL NULL NULL NULL
8690 8690 4 5090 15147 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.1 0.0 INR 2026-04-18 18:30:00 0 NULL NULL NULL NULL
8691 8691 1 5091 15152 27 Multicharge Cap 2009899 1 1499.0 1 299.0 1142.86 600.0 0.25 0.0 1499.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1200.0 600.0 0.25 0.0 INR 2026-04-18 18:33:00 0 NULL NULL NULL NULL
8692 8692 2 5091 15152 24 Immunomax 24/7 Caps 2009899 1 1499.0 1 299.0 1142.86 600.0 0.25 0.0 1499.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1200.0 600.0 0.25 0.0 INR 2026-04-18 18:33:00 0 NULL NULL NULL NULL
8693 8693 1 5092 15165 6 Asthma Care 30049011 1 899.0 1 180.0 684.76 360.0 0.15 0.0 899.0 719.0 0.0 0.0 0.0 0.0 5.0 34.24 719.0 360.0 0.15 0.0 INR 2026-04-18 19:06:33 0 NULL NULL NULL NULL
8694 8694 2 5092 15165 33 HALDI CHANDAN SOAP 100gm 30049011 8 100.0 1 20.0 76.19 35.0 0.009 0.0 800.0 640.0 0.0 0.0 0.0 0.0 5.0 30.48 640.0 280.0 0.072 0.0 INR 2026-04-18 19:06:33 0 NULL NULL NULL NULL
8695 8695 3 5092 15165 81 PREMIUM GLOW FACE WASH 3404 1 699.0 1 140.0 473.73 279.0 0.11 0.0 699.0 559.0 0.0 0.0 0.0 0.0 18.0 85.27 559.0 279.0 0.11 0.0 INR 2026-04-18 19:06:33 0 NULL NULL NULL NULL
8696 8696 4 5092 15165 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.11 0.0 INR 2026-04-18 19:06:33 0 NULL NULL NULL NULL
8697 8697 5 5092 15165 46 Root Vitality Hair Oil 3305901 1 255.0 1 51.0 194.29 102.0 0.04 0.0 255.0 204.0 0.0 0.0 0.0 0.0 5.0 9.71 204.0 102.0 0.04 0.0 INR 2026-04-18 19:06:33 0 NULL NULL NULL NULL
8698 8698 6 5092 15165 34 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.025 0.0 INR 2026-04-18 19:06:33 0 NULL NULL NULL NULL
8699 8699 1 5093 15133 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.5 0.0 INR 2026-04-18 19:20:04 0 NULL NULL NULL NULL
8700 8700 1 5094 15205 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.5 0.0 INR 2026-04-18 19:21:33 0 NULL NULL NULL NULL