fx_order_product

11,631 rows · 35 columns · page 209 / 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
10401 10401 2 6186 15169 33 HALDI CHANDAN SOAP 100gm 30049011 6 100.0 1 20.0 76.19 35.0 0.009 0.0 600.0 480.0 0.0 0.0 0.0 0.0 5.0 22.86 480.0 210.0 0.0 0.0 INR 2026-05-15 13:04:55 0 NULL NULL NULL NULL
10402 10402 3 6186 15169 43 Quench Kiss Lip Balm 3304300 2 199.0 1 40.0 134.75 79.0 0.012 0.0 398.0 318.0 0.0 0.0 0.0 0.0 18.0 48.51 318.0 158.0 0.0 0.0 INR 2026-05-15 13:04:55 0 NULL NULL NULL NULL
10403 10403 1 6187 16259 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 0.0 0.15 0.0 INR 2026-05-15 15:22:28 0 NULL NULL NULL NULL
10404 10404 2 6187 16259 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-05-15 15:22:28 0 NULL NULL NULL NULL
10405 10405 3 6187 16259 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-15 15:22:28 0 NULL NULL NULL NULL
10406 10406 4 6187 16259 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 0.0 0.15 0.0 INR 2026-05-15 15:22:28 0 NULL NULL NULL NULL
10407 10407 1 6188 6712 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-15 15:33:32 0 NULL NULL NULL NULL
10408 10408 2 6188 6712 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 150.0 0.0 0.0 INR 2026-05-15 15:33:32 0 NULL NULL NULL NULL
10409 10409 1 6189 15294 38 Dish Wash 500ml 34029099 2 230.0 1 46.0 155.93 65.0 0.011 0.0 460.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 368.0 130.0 0.0 0.0 INR 2026-05-15 20:06:50 0 NULL NULL NULL NULL
10410 10410 2 6189 15294 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-05-15 20:06:50 0 NULL NULL NULL NULL
10411 10411 3 6189 15294 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-15 20:06:50 0 NULL NULL NULL NULL
10412 10412 1 6190 11866 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-15 23:35:00 0 NULL NULL NULL NULL
10413 10413 2 6190 11866 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-15 23:35:00 0 NULL NULL NULL NULL
10414 10414 3 6190 11866 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.0 0.0 INR 2026-05-15 23:35:00 0 NULL NULL NULL NULL
10415 10415 4 6190 11866 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.0 0.0 INR 2026-05-15 23:35:00 0 NULL NULL NULL NULL
10416 10416 5 6190 11866 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-15 23:35:00 0 NULL NULL NULL NULL
10417 10417 6 6190 11866 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.0 0.0 INR 2026-05-15 23:35:00 0 NULL NULL NULL NULL
10418 10418 1 6191 14535 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-15 23:44:47 0 NULL NULL NULL NULL
10419 10419 1 6192 13015 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-15 23:56:00 0 NULL NULL NULL NULL
10420 10420 2 6192 13015 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-15 23:56:00 0 NULL NULL NULL NULL
10421 10421 3 6192 13015 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.0 0.0 INR 2026-05-15 23:56:00 0 NULL NULL NULL NULL
10422 10422 4 6192 13015 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-15 23:56:00 0 NULL NULL NULL NULL
10423 10423 5 6192 13015 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 150.0 0.0 0.0 INR 2026-05-15 23:56:00 0 NULL NULL NULL NULL
10424 10424 1 6193 16264 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-05-16 12:20:05 0 NULL NULL NULL NULL
10425 10425 2 6193 16264 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-05-16 12:20:05 0 NULL NULL NULL NULL
10426 10426 1 6194 16265 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-05-16 12:21:26 0 NULL NULL NULL NULL
10427 10427 2 6194 16265 32 Neem Soap 100gm 34011110 5 60.0 1 8.0 49.52 20.0 0.006 0.0 300.0 260.0 2.5 6.19 2.5 6.19 0.0 0.0 260.0 0.0 0.03 0.0 INR 2026-05-16 12:21:26 0 NULL NULL NULL NULL
10428 10428 3 6194 16265 94 PAVANA DROPS 30041211 4 699.0 1 200.0 475.24 249.0 0.1 0.0 2796.0 1996.0 2.5 47.52 2.5 47.52 0.0 0.0 1996.0 0.0 0.4 0.0 INR 2026-05-16 12:21:26 0 NULL NULL NULL NULL
10429 10429 1 6195 16263 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-16 13:24:10 0 NULL NULL NULL NULL
10430 10430 2 6195 16263 24 Immunomax 24/7 Caps 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-05-16 13:24:10 0 NULL NULL NULL NULL
10431 10431 3 6195 16263 16 Liver 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-05-16 13:24:10 0 NULL NULL NULL NULL
10432 10432 4 6195 16263 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 0.0 0.18 0.0 INR 2026-05-16 13:24:10 0 NULL NULL NULL NULL
10433 10433 1 6196 15859 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-16 13:45:00 0 NULL NULL NULL NULL
10434 10434 1 6197 16269 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-16 16:05:18 0 NULL NULL NULL NULL
10435 10435 1 6198 16262 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-16 16:09:44 0 NULL NULL NULL NULL
10436 10436 2 6198 16262 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-16 16:09:44 0 NULL NULL NULL NULL
10437 10437 3 6198 16262 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 0.0 0.006 0.0 INR 2026-05-16 16:09:44 0 NULL NULL NULL NULL
10438 10438 4 6198 16262 94 PAVANA DROPS 30041211 1 699.0 1 200.0 475.24 249.0 0.1 0.0 699.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 499.0 0.0 0.1 0.0 INR 2026-05-16 16:09:44 0 NULL NULL NULL NULL
10439 10439 1 6199 16270 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-05-16 16:26:34 0 NULL NULL NULL NULL
10440 10440 1 6200 15868 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-05-16 17:00:47 0 NULL NULL NULL NULL
10441 10441 1 6201 16271 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 0.0 0.18 0.0 INR 2026-05-16 17:03:30 0 NULL NULL NULL NULL
10442 10442 2 6201 16271 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-16 17:03:30 0 NULL NULL NULL NULL
10443 10443 3 6201 16271 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 0.0 0.3 0.0 INR 2026-05-16 17:03:30 0 NULL NULL NULL NULL
10444 10444 1 6202 15848 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-16 17:43:12 0 NULL NULL NULL NULL
10445 10445 1 6203 15362 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-16 17:56:54 0 NULL NULL NULL NULL
10446 10446 2 6203 15362 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 0.0 0.1 0.0 INR 2026-05-16 17:56:54 0 NULL NULL NULL NULL
10447 10447 3 6203 15362 17 Memory Booster 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-05-16 17:56:54 0 NULL NULL NULL NULL
10448 10448 4 6203 15362 95 STRI 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 0.0 0.3 0.0 INR 2026-05-16 17:56:54 0 NULL NULL NULL NULL
10449 10449 5 6203 15362 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-16 17:56:54 0 NULL NULL NULL NULL
10450 10450 6 6203 15362 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 0.0 0.05 0.0 INR 2026-05-16 17:56:54 0 NULL NULL NULL NULL