fx_order_product
| # | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11601 | 11601 | 5 | 6659 | 6712 | 46 | Root Vitality Hair Oil | 3305901 | 3 | 255.0 | 1 | 51.0 | 194.29 | 102.0 | 0.04 | 0.0 | 765.0 | 612.0 | 2.5 | 14.57 | 2.5 | 14.57 | 0.0 | 0.0 | 612.0 | 306.0 | 0.0 | 0.0 | INR | 2026-07-31 21:03:05 | 0 | NULL | NULL | NULL | NULL | |
| 11602 | 11602 | 6 | 6659 | 6712 | 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-07-31 21:03:05 | 0 | NULL | NULL | NULL | NULL | |
| 11603 | 11603 | 1 | 6660 | 15875 | 34 | HERBO 33 TOOTHPASTE | 33061090 | 14 | 199.0 | 1 | 40.0 | 134.75 | 55.0 | 0.025 | 0.0 | 2786.0 | 2226.0 | 9.0 | 169.78 | 9.0 | 169.78 | 0.0 | 0.0 | 2226.0 | 770.0 | 0.0 | 0.0 | INR | 2026-07-31 21:03:13 | 0 | NULL | NULL | NULL | NULL | |
| 11604 | 11604 | 2 | 6660 | 15875 | 32 | Neem Soap 100gm | 34011110 | 12 | 60.0 | 1 | 8.0 | 49.52 | 20.0 | 0.006 | 0.0 | 720.0 | 624.0 | 2.5 | 14.86 | 2.5 | 14.86 | 0.0 | 0.0 | 624.0 | 240.0 | 0.0 | 0.0 | INR | 2026-07-31 21:03:13 | 0 | NULL | NULL | NULL | NULL | |
| 11605 | 11605 | 1 | 6661 | 8100 | 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-07-31 21:05:06 | 0 | NULL | NULL | NULL | NULL | |
| 11606 | 11606 | 2 | 6661 | 8100 | 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-07-31 21:05:06 | 0 | NULL | NULL | NULL | NULL | |
| 11607 | 11607 | 3 | 6661 | 8100 | 7 | Morning Fresh Churan | 30049011 | 2 | 199.0 | 1 | 20.0 | 170.48 | 79.0 | 0.015 | 0.0 | 398.0 | 358.0 | 2.5 | 8.52 | 2.5 | 8.52 | 0.0 | 0.0 | 358.0 | 158.0 | 0.0 | 0.0 | INR | 2026-07-31 21:05:06 | 0 | NULL | NULL | NULL | NULL | |
| 11608 | 11608 | 1 | 6662 | 5430 | 19 | Fat loss Juice 500 ml | 30049011 | 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-07-31 21:06:58 | 0 | NULL | NULL | NULL | NULL | |
| 11609 | 11609 | 1 | 6663 | 5564 | 82 | ALKALINE CAPSULE | 3402000 | 1 | 2500.0 | 1 | 850.0 | 1571.43 | 800.0 | 0.25 | 0.0 | 2500.0 | 1650.0 | 2.5 | 39.29 | 2.5 | 39.29 | 0.0 | 0.0 | 1650.0 | 800.0 | 0.0 | 0.0 | INR | 2026-07-31 21:10:33 | 0 | NULL | NULL | NULL | NULL | |
| 11610 | 11610 | 2 | 6663 | 5564 | 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-07-31 21:10:33 | 0 | NULL | NULL | NULL | NULL | |
| 11611 | 11611 | 3 | 6663 | 5564 | 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-07-31 21:10:33 | 0 | NULL | NULL | NULL | NULL | |
| 11612 | 11612 | 4 | 6663 | 5564 | 44 | Vital Glow Face Scrub | 3304300 | 1 | 325.0 | 1 | 65.0 | 220.34 | 130.0 | 0.021 | 0.0 | 325.0 | 260.0 | 9.0 | 19.83 | 9.0 | 19.83 | 0.0 | 0.0 | 260.0 | 130.0 | 0.0 | 0.0 | INR | 2026-07-31 21:10:33 | 0 | NULL | NULL | NULL | NULL | |
| 11613 | 11613 | 1 | 6664 | 15243 | 70 | Premium Hand belt | 9404 | 1 | 2500.0 | 1 | 1060.0 | 1371.43 | 720.0 | 0.2 | 0.0 | 2500.0 | 1440.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5.0 | 68.57 | 1440.0 | 720.0 | 0.0 | 0.0 | INR | 2026-08-01 09:35:55 | 0 | NULL | NULL | NULL | NULL | |
| 11614 | 11614 | 2 | 6664 | 15243 | 38 | Dish Wash 500ml | 34029099 | 2 | 230.0 | 1 | 46.0 | 155.93 | 65.0 | 0.011 | 0.0 | 460.0 | 368.0 | 0.0 | 0.0 | 0.0 | 0.0 | 18.0 | 56.14 | 368.0 | 130.0 | 0.0 | 0.0 | INR | 2026-08-01 09:35:55 | 0 | NULL | NULL | NULL | NULL | |
| 11615 | 11615 | 3 | 6664 | 15243 | 33 | HALDI CHANDAN SOAP 100gm | 30049011 | 3 | 100.0 | 1 | 20.0 | 76.19 | 35.0 | 0.009 | 0.0 | 300.0 | 240.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5.0 | 11.43 | 240.0 | 105.0 | 0.0 | 0.0 | INR | 2026-08-01 09:35:55 | 0 | NULL | NULL | NULL | NULL | |
| 11616 | 11616 | 4 | 6664 | 15243 | 34 | HERBO 33 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-08-01 09:35:55 | 0 | NULL | NULL | NULL | NULL | |
| 11617 | 11617 | 1 | 6665 | 16292 | 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 | 55.0 | 0.0 | 0.0 | INR | 2026-08-02 20:41:48 | 0 | NULL | NULL | NULL | NULL | |
| 11618 | 11618 | 2 | 6665 | 16292 | 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-08-02 20:41:48 | 0 | NULL | NULL | NULL | NULL | |
| 11619 | 11619 | 1 | 6666 | 16296 | 32 | Neem Soap 100gm | 34011110 | 10 | 60.0 | 1 | 8.0 | 49.52 | 20.0 | 0.006 | 0.0 | 600.0 | 520.0 | 2.5 | 12.38 | 2.5 | 12.38 | 0.0 | 0.0 | 520.0 | 0.0 | 0.06 | 0.0 | INR | 2026-08-02 20:59:55 | 0 | NULL | NULL | NULL | NULL | |
| 11620 | 11620 | 1 | 6667 | 16243 | 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-08-02 21:03:09 | 0 | NULL | NULL | NULL | NULL | |
| 11621 | 11621 | 2 | 6667 | 16243 | 32 | Neem Soap 100gm | 34011110 | 2 | 60.0 | 1 | 8.0 | 49.52 | 20.0 | 0.006 | 0.0 | 120.0 | 104.0 | 2.5 | 2.48 | 2.5 | 2.48 | 0.0 | 0.0 | 104.0 | 0.0 | 0.012 | 0.0 | INR | 2026-08-02 21:03:09 | 0 | NULL | NULL | NULL | NULL | |
| 11622 | 11622 | 3 | 6667 | 16243 | 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-08-02 21:03:09 | 0 | NULL | NULL | NULL | NULL | |
| 11623 | 11623 | 1 | 6668 | 16468 | 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-08-07 19:56:07 | 0 | NULL | NULL | NULL | NULL | |
| 11624 | 11624 | 2 | 6668 | 16468 | 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-08-07 19:56:07 | 0 | NULL | NULL | NULL | NULL | |
| 11625 | 11625 | 3 | 6668 | 16468 | 17 | Memory Booster 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-08-07 19:56:07 | 0 | NULL | NULL | NULL | NULL | |
| 11626 | 11626 | 4 | 6668 | 16468 | 7 | Morning Fresh Churan | 30049011 | 5 | 199.0 | 1 | 20.0 | 170.48 | 79.0 | 0.015 | 0.0 | 995.0 | 895.0 | 2.5 | 21.31 | 2.5 | 21.31 | 0.0 | 0.0 | 895.0 | 0.0 | 0.075 | 0.0 | INR | 2026-08-07 19:56:07 | 0 | NULL | NULL | NULL | NULL | |
| 11627 | 11627 | 5 | 6668 | 16468 | 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-08-07 19:56:07 | 0 | NULL | NULL | NULL | NULL | |
| 11628 | 11628 | 1 | 6669 | 16234 | 33 | HALDI CHANDAN SOAP 100gm | 30049011 | 4 | 100.0 | 1 | 20.0 | 76.19 | 35.0 | 0.009 | 0.0 | 400.0 | 320.0 | 2.5 | 7.62 | 2.5 | 7.62 | 0.0 | 0.0 | 320.0 | 140.0 | 0.0 | 0.0 | INR | 2026-08-10 14:43:39 | 0 | NULL | NULL | NULL | NULL | |
| 11629 | 11629 | 2 | 6669 | 16234 | 25 | Manicalcium | 2009899 | 1 | 399.0 | 1 | 80.0 | 303.81 | 159.0 | 0.05 | 0.0 | 399.0 | 319.0 | 2.5 | 7.6 | 2.5 | 7.6 | 0.0 | 0.0 | 319.0 | 159.0 | 0.0 | 0.0 | INR | 2026-08-10 14:43:39 | 0 | NULL | NULL | NULL | NULL | |
| 11630 | 11630 | 3 | 6669 | 16234 | 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 | 249.0 | 0.0 | 0.0 | INR | 2026-08-10 14:43:39 | 0 | NULL | NULL | NULL | NULL | |
| 11631 | 11631 | 4 | 6669 | 16234 | 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-08-10 14:43:39 | 0 | NULL | NULL | NULL | NULL |