fx_franchise_order_product

4,737 rows · 33 columns · page 2 / 95

Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
51 260 9 60 12516 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-07 18:50:33
52 261 10 60 12516 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 18:50:33
53 262 11 60 12516 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 18:50:33
54 263 1 61 12546 20 Premium Berry Juice 1000ml NULL 2936900 1 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 3499.0 750.0 3479.0 2.5 82.83 2.5 82.83 0.0 0.0 3313.33 165.67 3479.0 INR 0 0.0 0.0 2025-11-07 18:56:18
55 264 2 61 12546 70 Premium Hand belt NULL 9404 1 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 9999.0 600.0 7999.2 2.5 190.46 2.5 190.46 0.0 0.0 7618.29 380.91 7999.2 INR 0 0.0 0.0 2025-11-07 18:56:18
56 265 3 61 12546 40 Bamboo Brush NULL 96032100 10 25.0 110.0 0.0 0.0 88.0 74.58 13.42 1100.0 250.0 880.0 9.0 67.12 9.0 67.12 0.0 0.0 74.58 134.24 880.0 INR 0 0.0 0.0 2025-11-07 18:56:18
57 266 4 61 12546 3 BP Care Capsules NULL 2936900 7 160.0 599.0 0.0 0.0 479.2 456.38 22.82 4193.0 1120.0 3354.4 2.5 79.86 2.5 79.86 0.0 0.0 456.38 159.73 3354.4 INR 0 0.0 0.0 2025-11-07 18:56:18
58 267 5 61 12546 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 18:56:18
59 268 6 61 12546 38 Dish Wash 500ml NULL 3924101 12 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2760.0 1020.0 2208.0 9.0 168.41 9.0 168.41 0.0 0.0 155.93 336.81 2208.0 INR 0 0.0 0.0 2025-11-07 18:56:18
60 269 7 61 12546 39 Fabric Wash 1000ml NULL 3924101 2 150.0 401.0 0.0 0.0 320.8 271.86 48.94 802.0 300.0 641.6 9.0 48.94 9.0 48.94 0.0 0.0 271.86 97.87 641.6 INR 0 0.0 0.0 2025-11-07 18:56:18
61 270 8 61 12546 19 Fat loss Juice 500 ml NULL 30049011 1 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 1499.0 250.0 1479.0 2.5 35.22 2.5 35.22 0.0 0.0 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-07 18:56:18
62 271 9 61 12546 37 Floor Cleaner 500ml NULL 3924101 18 80.0 199.0 0.0 0.0 159.2 134.92 24.29 3582.0 1440.0 2865.6 9.0 218.56 9.0 218.56 0.0 0.0 134.92 437.13 2865.6 INR 0 0.0 0.0 2025-11-07 18:56:18
63 272 10 61 12546 60 Foot patch NULL 30051090 3 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 5997.0 1500.0 4797.6 2.5 114.23 2.5 114.23 0.0 0.0 1523.05 228.46 4797.6 INR 0 0.0 0.0 2025-11-07 18:56:18
64 273 11 61 12546 33 Herbal Soap 100gm NULL 30049011 54 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5400.0 1512.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 76.19 205.71 4320.0 INR 0 0.0 0.0 2025-11-07 18:56:18
65 274 12 61 12546 34 Herbo2o Toothpaste NULL 33061090 93 45.0 199.0 0.0 0.0 159.2 134.92 24.28 18507.0 4185.0 14805.6 9.0 1129.24 9.0 1129.24 0.0 0.0 134.92 2258.48 14805.6 INR 0 0.0 0.0 2025-11-07 18:56:18
66 275 13 61 12546 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 18:56:18
67 276 14 61 12546 32 Neem Soap 100gm NULL 34011110 422 10.0 60.0 0.0 0.0 48.0 45.71 2.29 25320.0 4220.0 20256.0 2.5 482.29 2.5 482.29 0.0 0.0 45.71 964.57 20256.0 INR 0 0.0 0.0 2025-11-07 18:56:18
68 277 15 61 12546 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-07 18:56:18
69 278 16 61 12546 72 Pain Relief Patch NULL 30051090 2 200.0 800.0 0.0 0.0 640.0 609.52 30.48 1600.0 400.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 609.52 60.95 1280.0 INR 0 0.0 0.0 2025-11-07 18:56:18
70 279 17 61 12546 14 Premium Aloe Vera VEG caps NULL 2936900 2 100.0 359.0 0.0 0.0 287.2 273.52 13.68 718.0 200.0 574.4 2.5 13.68 2.5 13.68 0.0 0.0 273.52 27.35 574.4 INR 0 0.0 0.0 2025-11-07 18:56:18
71 280 18 61 12546 43 Quench Kiss Lip Balm NULL 3304300 3 35.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 105.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-07 18:56:18
72 281 19 61 12546 35 Sanitary Pad (15 pcs) NULL 9619001 46 40.0 380.0 0.0 0.0 304.0 304.0 0.0 17480.0 1840.0 13984.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 13984.0 INR 0 0.0 0.0 2025-11-07 18:56:18
73 282 20 61 12546 26 Spirulina Cap NULL 2009899 1 190.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 190.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 18:56:18
74 283 21 61 12546 5 Thyro Care NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-07 18:56:18
75 284 22 61 12546 36 Toilet Cleaner 500ml NULL 3924101 20 30.0 150.0 0.0 0.0 120.0 101.69 18.3 3000.0 600.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 101.69 366.1 2400.0 INR 0 0.0 0.0 2025-11-07 18:56:18
76 285 1 62 12537 52 Bhoo sanjeevni 5 kg NULL 3103100 10 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 16000.0 4500.0 12800.0 2.5 304.76 2.5 304.76 0.0 0.0 1219.05 609.52 12800.0 INR 0 0.0 0.0 2025-11-07 19:35:22
77 286 2 62 12537 33 Herbal Soap 100gm NULL 30049011 75 28.0 100.0 0.0 0.0 80.0 76.19 3.81 7500.0 2100.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 76.19 285.71 6000.0 INR 0 0.0 0.0 2025-11-07 19:35:22
78 287 3 62 12537 34 Herbo2o Toothpaste NULL 33061090 2 45.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 90.0 318.4 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 19:35:22
79 288 4 62 12537 32 Neem Soap 100gm NULL 34011110 75 10.0 60.0 0.0 0.0 48.0 45.71 2.29 4500.0 750.0 3600.0 2.5 85.72 2.5 85.72 0.0 0.0 45.71 171.43 3600.0 INR 0 0.0 0.0 2025-11-07 19:35:22
80 289 5 62 12537 35 Sanitary Pad (15 pcs) NULL 9619001 15 40.0 380.0 0.0 0.0 304.0 304.0 0.0 5700.0 600.0 4560.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 4560.0 INR 0 0.0 0.0 2025-11-07 19:35:22
81 290 6 62 12537 53 Terra care 2 kg NULL 3103100 10 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 15000.0 4500.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.43 12000.0 INR 0 0.0 0.0 2025-11-07 19:35:22
82 291 1 63 12529 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-07 19:49:03
83 292 1 64 12529 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-07 19:50:02
84 293 1 65 12526 48 glow face wash NULL 3304999 30 250.0 380.0 0.0 0.0 304.0 257.63 46.37 11400.0 7500.0 9120.0 9.0 695.6 9.0 695.6 0.0 0.0 257.63 1391.19 9120.0 INR 0 0.0 0.0 2025-11-07 19:52:39
85 294 2 65 12526 20 Premium Berry Juice 1000ml NULL 2936900 4 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 13996.0 3000.0 13916.0 2.5 331.33 2.5 331.33 0.0 0.0 3313.33 662.67 13916.0 INR 0 0.0 0.0 2025-11-07 19:52:39
86 295 3 65 12526 40 Bamboo Brush NULL 96032100 4 25.0 110.0 0.0 0.0 88.0 74.58 13.42 440.0 100.0 352.0 9.0 26.84 9.0 26.84 0.0 0.0 74.58 53.69 352.0 INR 0 0.0 0.0 2025-11-07 19:52:39
87 296 4 65 12526 4 Diabetic Care Capsules NULL 2936900 4 250.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 1000.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-07 19:52:39
88 297 5 65 12526 39 Fabric Wash 1000ml NULL 3924101 7 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2807.0 1050.0 2245.6 9.0 171.28 9.0 171.28 0.0 0.0 271.86 342.55 2245.6 INR 0 0.0 0.0 2025-11-07 19:52:39
89 298 6 65 12526 37 Floor Cleaner 500ml NULL 3924101 1 80.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 80.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-07 19:52:39
90 299 7 65 12526 33 Herbal Soap 100gm NULL 30049011 180 28.0 100.0 0.0 0.0 80.0 76.19 3.81 18000.0 5040.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 76.19 685.71 14400.0 INR 0 0.0 0.0 2025-11-07 19:52:39
91 300 8 65 12526 34 Herbo2o Toothpaste NULL 33061090 28 45.0 199.0 0.0 0.0 159.2 134.92 24.28 5572.0 1260.0 4457.6 9.0 339.99 9.0 339.99 0.0 0.0 134.92 679.97 4457.6 INR 0 0.0 0.0 2025-11-07 19:52:39
92 301 9 65 12526 16 Liver Care Juice NULL 2009899 4 120.0 349.0 0.0 0.0 279.2 265.9 13.29 1396.0 480.0 1116.8 2.5 26.59 2.5 26.59 0.0 0.0 265.9 53.18 1116.8 INR 0 0.0 0.0 2025-11-07 19:52:39
93 302 10 65 12526 12 Melatonin Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 19:52:39
94 303 11 65 12526 17 Memory Booster Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-07 19:52:39
95 304 12 65 12526 7 Morning Fresh Churan NULL 30049011 1 40.0 199.0 0.0 0.0 159.2 151.62 7.58 199.0 40.0 159.2 2.5 3.79 2.5 3.79 0.0 0.0 151.62 7.58 159.2 INR 0 0.0 0.0 2025-11-07 19:52:39
96 305 13 65 12526 32 Neem Soap 100gm NULL 34011110 160 10.0 60.0 0.0 0.0 48.0 45.71 2.29 9600.0 1600.0 7680.0 2.5 182.85 2.5 182.85 0.0 0.0 45.71 365.71 7680.0 INR 0 0.0 0.0 2025-11-07 19:52:39
97 306 14 65 12526 9 Omega 369 NULL 2936900 7 260.0 999.0 0.0 0.0 799.2 761.14 38.06 6993.0 1820.0 5594.4 2.5 133.2 2.5 133.2 0.0 0.0 761.14 266.4 5594.4 INR 0 0.0 0.0 2025-11-07 19:52:39
98 307 15 65 12526 72 Pain Relief Patch NULL 30051090 3 200.0 800.0 0.0 0.0 640.0 609.52 30.48 2400.0 600.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 609.52 91.43 1920.0 INR 0 0.0 0.0 2025-11-07 19:52:39
99 308 16 65 12526 8 Piles Care NULL 30049011 7 250.0 899.0 0.0 0.0 719.2 684.95 34.25 6293.0 1750.0 5034.4 2.5 119.86 2.5 119.86 0.0 0.0 684.95 239.73 5034.4 INR 0 0.0 0.0 2025-11-07 19:52:39
100 309 17 65 12526 41 Premium Coco Body Lotion NULL 3304300 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 19:52:39