fx_franchise_order_product

4,737 rows · 33 columns · page 44 / 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
2151 2360 1 509 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2025-12-27 16:54:24
2152 2361 1 510 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2025-12-27 16:55:21
2153 2362 1 511 12542 62 3*6 BED WITH BRACELET NULL 94041000 2 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 25998.0 0.0 15960.0 0.0 0.0 0.0 0.0 3.0 464.85 7747.57 464.85 15960.0 INR 0 0.0 0.0 2025-12-27 16:56:02
2154 2363 1 512 12542 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 0.0 0.0 0.0 0.0 3.0 232.43 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-27 17:04:56
2155 2364 1 513 13438 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 0.0 0.0 0.0 0.0 9.0 46.16 512.84 46.16 559.0 INR 0 0.0 0.0 2025-12-27 20:00:35
2156 2365 2 513 13438 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 0.0 0.0 0.0 0.0 18.0 24.25 134.75 24.25 159.0 INR 0 0.0 0.0 2025-12-27 20:00:35
2157 2366 1 514 13438 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 0.0 0.0 0.0 0.0 3.0 232.43 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-27 20:13:25
2158 2367 1 515 12542 62 3*6 BED WITH BRACELET NULL 94041000 5 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 64995.0 0.0 39900.0 0.0 0.0 0.0 0.0 3.0 1162.14 7747.57 1162.14 39900.0 INR 0 0.0 0.0 2025-12-29 10:45:08
2159 2368 1 516 12554 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2025-12-29 10:58:37
2160 2369 1 517 12516 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-29 10:59:11
2161 2370 1 518 12516 62 3*6 BED WITH BRACELET NULL 94041000 5 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 64995.0 0.0 39900.0 1.5 581.07 1.5 581.07 0.0 0.0 7747.57 1162.14 39900.0 INR 0 0.0 0.0 2025-12-29 11:00:17
2162 2371 1 519 12555 30 Iron Capsules NULL 30049011 10 0.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 0.0 7190.0 2.5 171.19 2.5 171.19 0.0 0.0 684.76 342.38 7190.0 INR 0 0.0 0.0 2025-12-29 13:03:02
2163 2372 1 520 12554 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 30 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 42720.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 714.29 1071.43 22500.0 INR 0 0.0 0.0 2025-12-30 11:22:32
2164 2373 1 521 12516 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 40 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 56960.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 714.29 1428.57 30000.0 INR 0 0.0 0.0 2025-12-30 11:24:31
2165 2374 1 522 12555 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 30 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 42720.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 714.29 1071.43 22500.0 INR 0 0.0 0.0 2025-12-30 11:31:11
2166 2375 1 523 12555 4 Diabetic Care Capsules NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 685.71 342.86 7200.0 INR 0 0.0 0.0 2025-12-30 16:58:51
2167 2376 1 524 12555 36 Toilet Cleaner 500ml NULL 3924101 50 0.0 150.0 0.0 0.0 120.0 101.69 18.31 7500.0 0.0 6000.0 9.0 457.63 9.0 457.63 0.0 0.0 101.69 915.25 6000.0 INR 0 0.0 0.0 2025-12-30 18:37:35
2168 2377 1 525 12555 32 Neem Soap 100gm NULL 34011110 500 0.0 60.0 0.0 0.0 48.0 45.71 2.29 30000.0 0.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 45.71 1142.86 24000.0 INR 0 0.0 0.0 2025-12-30 22:52:30
2169 2378 1 526 12554 32 Neem Soap 100gm NULL 34011110 1000 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 0.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-12-30 22:53:18
2170 2379 1 527 12516 32 Neem Soap 100gm NULL 34011110 1500 0.0 60.0 0.0 0.0 48.0 45.71 2.29 90000.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 45.71 3428.57 72000.0 INR 0 0.0 0.0 2025-12-30 22:54:07
2171 2380 1 528 12542 62 3*6 BED WITH BRACELET NULL 94041000 2 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 25998.0 0.0 15960.0 0.0 0.0 0.0 0.0 3.0 464.85 7747.57 464.85 15960.0 INR 0 0.0 0.0 2025-12-31 11:26:11
2172 2381 1 529 12555 62 3*6 BED WITH BRACELET NULL 94041000 15 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 194985.0 0.0 119700.0 1.5 1743.2 1.5 1743.2 0.0 0.0 7747.57 3486.41 119700.0 INR 0 0.0 0.0 2025-12-31 12:02:14
2173 2382 1 530 12555 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-01 13:22:12
2174 2383 1 531 12555 12 P RADIANCE FACE SERUM NULL 33049990 10 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 12500.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 714.29 357.14 7500.0 INR 0 0.0 0.0 2026-01-01 13:30:52
2175 2384 1 532 12542 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 0.0 0.0 0.0 0.0 3.0 2324.27 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-01 15:28:02
2176 2385 1 533 12554 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-01 15:45:33
2177 2386 1 534 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-01 15:46:16
2178 2387 1 535 12555 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-01 16:26:55
2179 2388 2 535 12555 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2026-01-01 16:26:55
2180 2389 1 536 12554 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-01 16:27:51
2181 2390 1 537 12555 62 3*6 BED WITH BRACELET NULL 94041000 5 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 64995.0 0.0 39900.0 1.5 581.07 1.5 581.07 0.0 0.0 7747.57 1162.14 39900.0 INR 0 0.0 0.0 2026-01-01 22:47:09
2182 2391 1 538 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-01 22:48:02
2183 2392 1 539 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-01 22:48:42
2184 2393 1 540 12555 62 3*6 BED WITH BRACELET NULL 94041000 3 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 38997.0 0.0 23940.0 1.5 348.64 1.5 348.64 0.0 0.0 7747.57 697.28 23940.0 INR 0 0.0 0.0 2026-01-01 22:50:54
2185 2394 1 541 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-02 11:17:13
2186 2395 1 542 12555 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-02 11:20:49
2187 2396 1 543 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-02 16:48:57
2188 2397 1 544 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-02 16:49:26
2189 2398 1 545 12555 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-02 16:50:22
2190 2399 1 546 13438 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 0.0 0.0 0.0 0.0 5.0 29.14 194.29 29.14 612.0 INR 0 0.0 0.0 2026-01-02 17:08:48
2191 2400 1 547 12554 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 10 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 14240.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 714.29 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 17:23:29
2192 2401 1 548 13438 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 2 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 2848.0 0.0 1500.0 0.0 0.0 0.0 0.0 5.0 71.43 714.29 71.43 1500.0 INR 0 0.0 0.0 2026-01-02 17:27:48
2193 2402 1 549 12555 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-02 17:42:07
2194 2403 1 550 12554 43 Quench Kiss Lip Balm NULL 3304300 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 134.75 242.54 1590.0 INR 0 0.0 0.0 2026-01-02 17:52:14
2195 2404 1 551 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 10 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 16000.0 0.0 12500.0 2.5 297.62 2.5 297.62 0.0 0.0 1190.48 595.24 12500.0 INR 0 0.0 0.0 2026-01-02 18:01:14
2196 2405 1 552 12527 62 3*6 BED WITH BRACELET NULL 94041000 6 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 77994.0 0.0 47880.0 0.0 0.0 0.0 0.0 3.0 1394.56 7747.57 1394.56 47880.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2197 2406 2 552 12527 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 1 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 21999.0 0.0 14999.0 0.0 0.0 0.0 0.0 3.0 436.86 14562.14 436.86 14999.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2198 2407 3 552 12527 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 0.0 0.0 0.0 0.0 5.0 297.62 1190.48 297.62 6250.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2199 2408 4 552 12527 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 1142.86 114.29 2400.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2200 2409 5 552 12527 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 0.0 0.0 0.0 0.0 5.0 380.95 76.19 380.95 8000.0 INR 0 0.0 0.0 2026-01-02 18:05:33