fx_order_product

11,631 rows · 35 columns · page 169 / 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
8401 8401 2 5004 9840 38 Dish Wash 500ml 34029099 6 230.0 1 46.0 155.93 0.0 0.011 0.0 1380.0 1104.0 9.0 84.2 9.0 84.2 0.0 0.0 1104.0 0.0 0.066 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8402 8402 3 5004 9840 39 Fabric Wash 1000ml 34029099 4 401.0 1 80.0 272.03 0.0 0.022 0.0 1604.0 1284.0 9.0 97.93 9.0 97.93 0.0 0.0 1284.0 0.0 0.088 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8403 8403 4 5004 9840 37 Floor Cleaner 500ml 3924101 2 199.0 1 40.0 134.75 0.0 0.011 0.0 398.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 318.0 0.0 0.022 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8404 8404 5 5004 9840 48 Glow it multi fruit face wash 3304999 5 450.0 1 130.0 271.19 0.0 0.05 0.0 2250.0 1600.0 9.0 122.03 9.0 122.03 0.0 0.0 1600.0 0.0 0.25 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8405 8405 6 5004 9840 33 HALDI CHANDAN SOAP 100gm 30049011 10 100.0 1 20.0 76.19 0.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-03-31 00:18:32 0 NULL NULL NULL NULL
8406 8406 7 5004 9840 7 Morning Fresh Churan 30049011 4 199.0 1 40.0 151.43 0.0 0.015 0.0 796.0 636.0 2.5 15.14 2.5 15.14 0.0 0.0 636.0 0.0 0.06 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8407 8407 8 5004 9840 8 Piles Care 30049011 1 999.0 1 279.0 685.71 0.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-03-31 00:18:32 0 NULL NULL NULL NULL
8408 8408 9 5004 9840 47 Premium Hair Care Shampoo 3305109 2 699.0 1 140.0 532.38 0.0 0.11 0.0 1398.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1118.0 0.0 0.22 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8409 8409 10 5004 9840 12 PREMIUM RADIANCE FACE SERUM 33049990 1 1250.0 1 500.0 714.29 0.0 0.1 0.0 1250.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 750.0 0.0 0.1 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8410 8410 11 5004 9840 43 Quench Kiss Lip Balm 3304300 6 199.0 1 40.0 134.75 0.0 0.012 0.0 1194.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 954.0 0.0 0.072 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8411 8411 12 5004 9840 10 RADIANCE GLOW DAY CREAM 33049900 2 1424.0 1 674.0 635.59 0.0 0.1 0.0 2848.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1500.0 0.0 0.2 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8412 8412 13 5004 9840 46 Root Vitality Hair Oil 3305901 1 255.0 1 51.0 194.29 0.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-03-31 00:18:32 0 NULL NULL NULL NULL
8413 8413 14 5004 9840 35 Sanitary Pad (15 pcs) 9619001 5 380.0 1 76.0 304.0 0.0 0.05 0.0 1900.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 0.25 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8414 8414 15 5004 9840 26 Spirulina Cap 2009899 1 899.0 1 180.0 684.76 0.0 0.15 0.0 899.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 719.0 0.0 0.15 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8415 8415 16 5004 9840 36 Toilet Cleaner 500ml 3924101 4 150.0 1 30.0 101.69 0.0 0.011 0.0 600.0 480.0 9.0 36.61 9.0 36.61 0.0 0.0 480.0 0.0 0.044 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8416 8416 17 5004 9840 34 Toothpaste 33061090 8 199.0 1 40.0 134.75 0.0 0.025 0.0 1592.0 1272.0 9.0 97.02 9.0 97.02 0.0 0.0 1272.0 0.0 0.2 0.0 INR 2026-03-31 00:18:32 0 NULL NULL NULL NULL
8417 8417 1 5005 5903 46 Root Vitality Hair Oil 3305901 5 255.0 1 51.0 194.29 0.0 0.04 0.0 1275.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 1020.0 0.0 0.2 0.0 INR 2026-03-31 10:42:47 0 NULL NULL NULL NULL
8418 8418 2 5005 5903 35 Sanitary Pad (15 pcs) 9619001 6 380.0 1 76.0 304.0 0.0 0.05 0.0 2280.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 1824.0 0.0 0.3 0.0 INR 2026-03-31 10:42:47 0 NULL NULL NULL NULL
8419 8419 3 5005 5903 34 Toothpaste 33061090 2 199.0 1 40.0 134.75 0.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-03-31 10:42:47 0 NULL NULL NULL NULL
8420 8420 1 5006 12194 33 HALDI CHANDAN SOAP 100gm 30049011 50 100.0 1 20.0 76.19 0.0 0.009 0.0 5000.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 4000.0 0.0 0.45 0.0 INR 2026-03-31 10:59:22 0 NULL NULL NULL NULL
8421 8421 2 5006 12194 32 Neem Soap 100gm 34011110 50 60.0 1 12.0 45.71 0.0 0.006 0.0 3000.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2400.0 0.0 0.3 0.0 INR 2026-03-31 10:59:22 0 NULL NULL NULL NULL
8422 8422 3 5006 12194 47 Premium Hair Care Shampoo 3305109 2 699.0 1 140.0 532.38 0.0 0.11 0.0 1398.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1118.0 0.0 0.22 0.0 INR 2026-03-31 10:59:22 0 NULL NULL NULL NULL
8423 8423 4 5006 12194 35 Sanitary Pad (15 pcs) 9619001 2 380.0 1 76.0 304.0 0.0 0.05 0.0 760.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 0.1 0.0 INR 2026-03-31 10:59:22 0 NULL NULL NULL NULL
8424 8424 1 5007 14265 4 Diabetic Care Capsules 2936900 2 999.0 1 279.0 685.71 0.0 0.15 0.0 1998.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1440.0 0.0 0.3 0.0 INR 2026-03-31 12:36:30 0 NULL NULL NULL NULL
8425 8425 2 5007 14265 7 Morning Fresh Churan 30049011 1 199.0 1 40.0 151.43 0.0 0.015 0.0 199.0 159.0 2.5 3.79 2.5 3.79 0.0 0.0 159.0 0.0 0.015 0.0 INR 2026-03-31 12:36:30 0 NULL NULL NULL NULL
8426 8426 3 5007 14265 9 Omega 369 2936900 1 999.0 1 279.0 685.71 0.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-03-31 12:36:30 0 NULL NULL NULL NULL
8427 8427 4 5007 14265 46 Root Vitality Hair Oil 3305901 1 255.0 1 51.0 194.29 0.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-03-31 12:36:30 0 NULL NULL NULL NULL
8428 8428 1 5008 15090 38 Dish Wash 500ml 34029099 1 230.0 1 46.0 155.93 0.0 0.011 0.0 230.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 184.0 0.0 0.011 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8429 8429 2 5008 15090 39 Fabric Wash 1000ml 34029099 4 401.0 1 80.0 272.03 0.0 0.022 0.0 1604.0 1284.0 9.0 97.93 9.0 97.93 0.0 0.0 1284.0 0.0 0.088 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8430 8430 3 5008 15090 37 Floor Cleaner 500ml 3924101 1 199.0 1 40.0 134.75 0.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-03-31 12:39:15 0 NULL NULL NULL NULL
8431 8431 4 5008 15090 33 HALDI CHANDAN SOAP 100gm 30049011 9 100.0 1 20.0 76.19 0.0 0.009 0.0 900.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 0.0 0.081 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8432 8432 5 5008 15090 32 Neem Soap 100gm 34011110 2 60.0 1 12.0 45.71 0.0 0.006 0.0 120.0 96.0 2.5 2.29 2.5 2.29 0.0 0.0 96.0 0.0 0.012 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8433 8433 6 5008 15090 10 RADIANCE GLOW DAY CREAM 33049900 2 1424.0 1 674.0 635.59 0.0 0.1 0.0 2848.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1500.0 0.0 0.2 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8434 8434 7 5008 15090 46 Root Vitality Hair Oil 3305901 2 255.0 1 51.0 194.29 0.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-03-31 12:39:15 0 NULL NULL NULL NULL
8435 8435 8 5008 15090 36 Toilet Cleaner 500ml 3924101 2 150.0 1 30.0 101.69 0.0 0.011 0.0 300.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 240.0 0.0 0.022 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8436 8436 9 5008 15090 34 Toothpaste 33061090 5 199.0 1 40.0 134.75 0.0 0.025 0.0 995.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 795.0 0.0 0.125 0.0 INR 2026-03-31 12:39:15 0 NULL NULL NULL NULL
8437 8437 1 5009 13646 33 HALDI CHANDAN SOAP 100gm 30049011 8 100.0 1 20.0 76.19 0.0 0.009 0.0 800.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 640.0 0.0 0.072 0.0 INR 2026-03-31 13:38:08 0 NULL NULL NULL NULL
8438 8438 2 5009 13646 32 Neem Soap 100gm 34011110 30 60.0 1 12.0 45.71 0.0 0.006 0.0 1800.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1440.0 0.0 0.18 0.0 INR 2026-03-31 13:38:08 0 NULL NULL NULL NULL
8439 8439 3 5009 13646 10 RADIANCE GLOW DAY CREAM 33049900 1 1424.0 1 674.0 635.59 0.0 0.1 0.0 1424.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 750.0 0.0 0.1 0.0 INR 2026-03-31 13:38:08 0 NULL NULL NULL NULL
8440 8440 4 5009 13646 35 Sanitary Pad (15 pcs) 9619001 1 380.0 1 76.0 304.0 0.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-03-31 13:38:08 0 NULL NULL NULL NULL
8441 8441 5 5009 13646 34 Toothpaste 33061090 4 199.0 1 40.0 134.75 0.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-03-31 13:38:08 0 NULL NULL NULL NULL
8442 8442 1 5010 13873 52 Bhoo sanjeevni 5 kg 3103100 1 1600.0 1 350.0 1190.48 0.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-03-31 14:00:58 0 NULL NULL NULL NULL
8443 8443 2 5010 13873 4 Diabetic Care Capsules 2936900 1 999.0 1 279.0 685.71 0.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-03-31 14:00:58 0 NULL NULL NULL NULL
8444 8444 3 5010 13873 38 Dish Wash 500ml 34029099 1 230.0 1 46.0 155.93 0.0 0.011 0.0 230.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 184.0 0.0 0.011 0.0 INR 2026-03-31 14:00:58 0 NULL NULL NULL NULL
8445 8445 4 5010 13873 37 Floor Cleaner 500ml 3924101 1 199.0 1 40.0 134.75 0.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-03-31 14:00:58 0 NULL NULL NULL NULL
8446 8446 5 5010 13873 33 HALDI CHANDAN SOAP 100gm 30049011 5 100.0 1 20.0 76.19 0.0 0.009 0.0 500.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 400.0 0.0 0.045 0.0 INR 2026-03-31 14:00:58 0 NULL NULL NULL NULL
8447 8447 6 5010 13873 2 Heart Care Capsules 2936900 1 1499.0 1 299.0 1142.86 0.0 0.2 0.0 1499.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-03-31 14:00:58 0 NULL NULL NULL NULL
8448 8448 7 5010 13873 32 Neem Soap 100gm 34011110 6 60.0 1 12.0 45.71 0.0 0.006 0.0 360.0 288.0 2.5 6.86 2.5 6.86 0.0 0.0 288.0 0.0 0.036 0.0 INR 2026-03-31 14:00:58 0 NULL NULL NULL NULL
8449 8449 8 5010 13873 53 Terra care 2 kg 3103100 1 1500.0 1 350.0 1095.24 0.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-03-31 14:00:58 0 NULL NULL NULL NULL
8450 8450 9 5010 13873 34 Toothpaste 33061090 2 199.0 1 40.0 134.75 0.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-03-31 14:00:58 0 NULL NULL NULL NULL