fx_order_product

11,631 rows · 35 columns · page 210 / 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
10451 10451 1 6204 5362 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-05-16 23:34:01 0 NULL NULL NULL NULL
10452 10452 2 6204 5362 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.0 0.0 INR 2026-05-16 23:34:01 0 NULL NULL NULL NULL
10453 10453 3 6204 5362 33 HALDI CHANDAN SOAP 100gm 30049011 7 100.0 1 20.0 76.19 35.0 0.009 0.0 700.0 560.0 2.5 13.33 2.5 13.33 0.0 0.0 560.0 245.0 0.0 0.0 INR 2026-05-16 23:34:01 0 NULL NULL NULL NULL
10454 10454 4 6204 5362 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-05-16 23:34:01 0 NULL NULL NULL NULL
10455 10455 1 6205 15053 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 0.0 0.015 0.0 INR 2026-05-17 12:36:42 0 NULL NULL NULL NULL
10456 10456 2 6205 15053 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 0.0 0.012 0.0 INR 2026-05-17 12:36:42 0 NULL NULL NULL NULL
10457 10457 3 6205 15053 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 0.0 0.1 0.0 INR 2026-05-17 12:36:42 0 NULL NULL NULL NULL
10458 10458 1 6206 15351 28 Ortho Joint Shield 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 0.0 0.5 0.0 INR 2026-05-17 15:25:35 0 NULL NULL NULL NULL
10459 10459 1 6207 15352 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-05-17 15:27:31 0 NULL NULL NULL NULL
10460 10460 2 6207 15352 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-05-17 15:27:31 0 NULL NULL NULL NULL
10461 10461 3 6207 15352 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-05-17 15:27:31 0 NULL NULL NULL NULL
10462 10462 4 6207 15352 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-05-17 15:27:31 0 NULL NULL NULL NULL
10463 10463 5 6207 15352 17 Memory Booster Juice 2009899 2 349.0 1 49.0 285.71 150.0 0.05 0.0 698.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 600.0 0.0 0.1 0.0 INR 2026-05-17 15:27:31 0 NULL NULL NULL NULL
10464 10464 6 6207 15352 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 0.0 0.1 0.0 INR 2026-05-17 15:27:31 0 NULL NULL NULL NULL
10465 10465 1 6208 16232 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-05-17 15:28:32 0 NULL NULL NULL NULL
10466 10466 1 6209 15263 71 Bio magnetic water pad 9404 1 4500.0 1 1500.0 2857.14 1500.0 0.5 0.0 4500.0 3000.0 0.0 0.0 0.0 0.0 5.0 142.86 3000.0 0.0 0.5 0.0 INR 2026-05-17 15:29:18 0 NULL NULL NULL NULL
10467 10467 1 6210 5762 79 ALKALINE JAR 8421 1 14499.0 1 8499.0 5084.75 3300.0 1.0 0.0 14499.0 6000.0 9.0 457.63 9.0 457.63 0.0 0.0 6000.0 3300.0 0.0 0.0 INR 2026-05-18 10:59:43 0 NULL NULL NULL NULL
10468 10468 1 6211 15243 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.0 0.0 INR 2026-05-18 15:22:11 0 NULL NULL NULL NULL
10469 10469 1 6212 15347 37 Floor Cleaner 500ml 3924101 2 199.0 1 40.0 134.75 55.0 0.011 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-05-18 21:33:20 0 NULL NULL NULL NULL
10470 10470 2 6212 15347 9 Omega 369 2936900 1 999.0 1 279.0 0.95 0.0 0.0 0.0 999.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-05-18 21:33:20 0 NULL NULL NULL NULL
10471 10471 3 6212 15347 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-05-18 21:33:20 0 NULL NULL NULL NULL
10472 10472 4 6212 15347 36 Toilet Cleaner 500ml 3924101 3 150.0 1 30.0 101.69 42.0 0.011 0.0 450.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 360.0 126.0 0.0 0.0 INR 2026-05-18 21:33:20 0 NULL NULL NULL NULL
10473 10473 1 6213 16238 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 0.0 0.1 0.0 INR 2026-05-19 21:03:04 0 NULL NULL NULL NULL
10474 10474 2 6213 16238 96 TRIM VEDA 30049011 3 2500.0 1 1000.0 1428.57 750.0 0.3 0.0 7500.0 4500.0 2.5 107.14 2.5 107.14 0.0 0.0 4500.0 0.0 0.9 0.0 INR 2026-05-19 21:03:04 0 NULL NULL NULL NULL
10475 10475 1 6214 16238 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 0.0 0.1 0.0 INR 2026-05-19 21:03:05 0 NULL NULL NULL NULL
10476 10476 2 6214 16238 96 TRIM VEDA 30049011 3 2500.0 1 1000.0 1428.57 750.0 0.3 0.0 7500.0 4500.0 2.5 107.14 2.5 107.14 0.0 0.0 4500.0 0.0 0.9 0.0 INR 2026-05-19 21:03:05 0 NULL NULL NULL NULL
10477 10477 1 6215 15868 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-05-19 21:06:57 0 NULL NULL NULL NULL
10478 10478 1 6216 16295 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 0.0 0.011 0.0 INR 2026-05-19 23:26:48 0 NULL NULL NULL NULL
10479 10479 2 6216 16295 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 0.0 0.022 0.0 INR 2026-05-19 23:26:48 0 NULL NULL NULL NULL
10480 10480 3 6216 16295 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-05-19 23:26:48 0 NULL NULL NULL NULL
10481 10481 4 6216 16295 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-05-19 23:26:48 0 NULL NULL NULL NULL
10482 10482 5 6216 16295 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-05-19 23:26:48 0 NULL NULL NULL NULL
10483 10483 6 6216 16295 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 0.0 0.1 0.0 INR 2026-05-19 23:26:48 0 NULL NULL NULL NULL
10484 10484 7 6216 16295 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-05-19 23:26:48 0 NULL NULL NULL NULL
10485 10485 8 6216 16295 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-05-19 23:26:48 0 NULL NULL NULL NULL
10486 10486 9 6216 16295 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-05-19 23:26:48 0 NULL NULL NULL NULL
10487 10487 10 6216 16295 34 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-05-19 23:26:48 0 NULL NULL NULL NULL
10488 10488 1 6217 16295 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-05-19 23:35:40 0 NULL NULL NULL NULL
10489 10489 2 6217 16295 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 0.0 0.015 0.0 INR 2026-05-19 23:35:40 0 NULL NULL NULL NULL
10490 10490 3 6217 16295 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 0.0 0.025 0.0 INR 2026-05-19 23:35:40 0 NULL NULL NULL NULL
10491 10491 4 6217 16295 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 0.0 0.1 0.0 INR 2026-05-19 23:35:40 0 NULL NULL NULL NULL
10492 10492 1 6218 13210 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.0 0.0 INR 2026-05-19 23:54:21 0 NULL NULL NULL NULL
10493 10493 2 6218 13210 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-05-19 23:54:21 0 NULL NULL NULL NULL
10494 10494 3 6218 13210 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 279.0 0.0 0.0 INR 2026-05-19 23:54:21 0 NULL NULL NULL NULL
10495 10495 4 6218 13210 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-05-19 23:54:21 0 NULL NULL NULL NULL
10496 10496 1 6219 15202 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 360.0 0.0 0.0 INR 2026-05-20 12:00:42 0 NULL NULL NULL NULL
10497 10497 2 6219 15202 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-05-20 12:00:42 0 NULL NULL NULL NULL
10498 10498 3 6219 15202 34 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 55.0 0.0 0.0 INR 2026-05-20 12:00:42 0 NULL NULL NULL NULL
10499 10499 1 6220 15203 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-05-20 12:03:05 0 NULL NULL NULL NULL
10500 10500 2 6220 15203 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-05-20 12:03:05 0 NULL NULL NULL NULL