-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: mysql:3306 -- Generation Time: Oct 17, 2026 at 06:01 AM -- Server version: 8.0.34 -- PHP Version: 8.3.35 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `boichitromoy` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint UNSIGNED NOT NULL, `code` int NOT NULL, `type` enum('administrator','admin','seller') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'seller', `role_id` int DEFAULT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` datetime DEFAULT NULL, `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `verification_code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile_verified_at` datetime DEFAULT NULL, `password_plain` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `commission_rate` double(8,2) NOT NULL DEFAULT '0.00', `balance` double(10,2) NOT NULL DEFAULT '0.00', `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `request_status` enum('pending','approved') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `last_login_at` datetime DEFAULT NULL, `last_logout_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int DEFAULT NULL, `password_reset_code` int DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `code`, `type`, `role_id`, `name`, `email`, `email_verified_at`, `mobile`, `verification_code`, `mobile_verified_at`, `password_plain`, `password`, `commission_rate`, `balance`, `remember_token`, `image`, `status`, `request_status`, `last_login_at`, `last_logout_at`, `created_at`, `updated_at`, `created_by`, `password_reset_code`, `deleted_at`) VALUES (1, 101, 'administrator', 1, 'Mr. Admin', 'administrator@mail.com', NULL, '12345679810', '426268', '2025-04-14 05:23:00', '123456', '$2y$10$Egnk6AWhYNvuFlHPg6zM0e1Gxak7P/FImXXg9rsQkzBNkOVU3uIiG', 15.00, 18380.00, NULL, NULL, 'active', 'approved', '2026-10-16 18:59:44', NULL, '2025-02-27 10:35:48', '2026-10-16 18:59:44', 1, NULL, NULL), (2, 102, 'seller', NULL, 'Glenna Romero', 'qojuqyt@mailinator.com', NULL, '01609696858', NULL, '2025-07-05 17:49:01', '123456', '$2y$10$67o/cMH2Wz4.YzBj64s84Ohmovz4/5.EuUbHxQSmVdltWLzz/D7na', 10.00, 0.00, '2oFlMGXmmHESScoTLZh8oBntBgZYtLld6rmu1cpOF3yLYR0sXFUyUR32Ch3a', 'assets/files/images/admin/1741103423-avatar-icon-images-4.jpg', 'active', 'approved', '2025-10-10 18:58:37', NULL, '2025-03-04 09:50:23', '2025-10-10 12:58:37', 1, NULL, NULL), (3, 103, 'seller', NULL, 'Travis Newton', 'lapimimak@mailinator.com', NULL, '01598585858', NULL, NULL, '123456', '$2y$10$pJzlhg3JvJt4FN8vwjOtD.C.VLmYWi4ttwNSCDVq9NWrZkac89vhS', 5.00, 0.00, NULL, 'assets/files/images/admin/1741103500-images (3).png', 'active', 'approved', '2025-03-06 08:17:00', NULL, '2025-03-04 09:51:40', '2025-03-06 02:17:00', 1, NULL, NULL), (4, 104, 'seller', NULL, 'Piper Harper', 'hanyqesaqy@mailinator.com', NULL, '01254789652', NULL, NULL, '123456', '$2y$10$jlYd2sG1L.rxkShx2I8ODOXjnpO9aHdd5dVaY7qk/wUmWsqodfe96', 10.00, 0.00, NULL, 'assets/files/images/admin/1741103526-download.png', 'active', 'approved', NULL, NULL, '2025-03-04 09:52:06', '2025-03-04 09:53:04', 1, NULL, NULL), (5, 105, 'seller', NULL, 'Ivy Horton', 'lugoj@mailinator.com', NULL, '01693652458', NULL, NULL, '123456', '$2y$10$MvNzV1cTcXtGJLZajn2Bd.RnhRmAmKVyI1c/BzJNb4UwO7RGHIMQG', 15.00, 0.00, NULL, 'assets/files/images/admin/1741103845-images (1).png', 'active', 'approved', NULL, NULL, '2025-03-04 09:57:25', '2025-05-21 10:25:10', 1, NULL, NULL), (7, 106, 'seller', NULL, 'Rebecca Vazquez', 'hequ@mailinator.com', NULL, '01609605494', NULL, NULL, 'Pa$$w0rd!', '$2y$10$rdJtZUPRqMiirQZPN3bvKOUhZd5GX6QZIxZDKKYIAoQbBKVXwoTli', 0.00, 0.00, NULL, NULL, 'active', 'approved', '2025-07-11 09:47:05', NULL, '2025-07-11 03:32:29', '2025-07-11 03:47:05', NULL, NULL, NULL), (8, 107, 'seller', NULL, 'Ollie O\'Kon', 'your.email37089@gmail.com', NULL, '01609605495', NULL, NULL, '123456', '$2y$10$DWhtFC98XlHCrpRQzxf/DuI3llcBjSWNroHbnoKP7gR9GAt5qlqJW', 0.00, 0.00, NULL, NULL, 'active', 'approved', '2025-09-13 11:48:22', NULL, '2025-07-11 03:34:05', '2025-09-13 05:48:22', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `admin_notifications` -- CREATE TABLE `admin_notifications` ( `id` bigint UNSIGNED NOT NULL, `admin_id` bigint UNSIGNED DEFAULT NULL COMMENT 'null = all admins', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'order' COMMENT 'order, system, seller, refund', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Target URL when clicked', `is_read` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admin_notifications` -- INSERT INTO `admin_notifications` (`id`, `admin_id`, `type`, `title`, `message`, `url`, `is_read`, `created_at`, `updated_at`) VALUES (1, NULL, 'order', 'New Order Placed', 'Order #0005 placed by Stewart Sanford — ৳612.00', 'http://local-dev.test/rytoyu/order-summary/DACKVHJYHY', 1, '2026-03-31 11:40:24', '2026-04-17 22:20:03'), (2, NULL, 'order', 'New Order Placed', 'Order #0006 placed by Stewart Sanford — ৳600.00', 'http://local-dev.test/rytoyu/order-summary/BPN5ZZQORK', 1, '2026-03-31 11:40:33', '2026-04-17 22:20:03'), (3, NULL, 'order', 'New Order Placed', 'Order #0007 placed by Stewart Sanford — ৳4,860.00', 'http://local-dev.test/rytoyu/order-summary/2W9PHSXDIN', 1, '2026-03-31 11:41:37', '2026-04-17 22:20:03'), (4, NULL, 'order', 'New Order Placed', 'Order #0008 placed by Gage Delacruz — ৳10,812.00', 'http://local-dev.test/rytoyu/order-summary/ZIJBWKPXT4', 1, '2026-04-17 22:16:23', '2026-04-17 22:20:03'), (5, NULL, 'order', 'New Order Placed', 'Order #0009 placed by Gage Delacruz — ৳10,600.00', 'http://local-dev.test/rytoyu/order-summary/WTA5EKYCME', 1, '2026-04-17 22:16:30', '2026-10-08 16:43:43'), (6, NULL, 'order', 'New Order Placed', 'Order #0010 placed by Stewart Sanford — ৳776.00', 'http://local-dev.test/rytoyu/order-summary/INHDI53GWU', 1, '2026-10-04 12:21:51', '2026-10-08 16:43:43'), (7, NULL, 'order', 'New Order Placed', 'Order #0011 placed by Stewart Sanford — ৳760.00', 'http://local-dev.test/rytoyu/order-summary/NDWMLI5VR4', 1, '2026-10-04 12:22:00', '2026-10-11 07:49:52'), (8, NULL, 'order', 'New Order Placed', 'Order #0012 placed by Stewart Sanford — ৳1,694.00', 'http://127.0.0.1:8003/order-summary/BEMWOH5TJA', 1, '2026-10-05 18:13:30', '2026-10-11 07:49:52'), (9, NULL, 'order', 'New Order Placed', 'Order #0013 placed by Stewart Sanford — ৳1,694.00', 'http://127.0.0.1:8003/order-summary/AUPZHZO93J', 1, '2026-10-05 18:13:52', '2026-10-13 11:46:54'), (10, NULL, 'order', 'New Order Placed', 'Order #0014 placed by Stewart Sanford — ৳1,694.00', 'http://127.0.0.1:8003/order-summary/BY9E8OT8XD', 1, '2026-10-05 18:14:18', '2026-10-13 11:46:54'), (11, NULL, 'order', 'New Order Placed', 'Order #0015 placed by Stewart Sanford — ৳1,694.00', 'http://127.0.0.1:8003/order-summary/JRJDKR2Y8I', 1, '2026-10-05 18:14:20', '2026-10-13 11:46:54'), (12, NULL, 'order', 'New Order Placed', 'Order #0016 placed by Stewart Sanford — ৳1,660.00', 'http://127.0.0.1:8003/order-summary/KIPKOLXL62', 1, '2026-10-05 18:14:32', '2026-10-13 11:46:54'), (13, NULL, 'order', 'New Order Placed', 'Order #0017 placed by Stewart Sanford — ৳1,660.00', 'http://127.0.0.1:8003/order-summary/HRQRASD9CF', 1, '2026-10-05 18:15:49', '2026-10-13 11:46:54'), (14, NULL, 'order', 'New Order Placed', 'Order #0018 placed by Stewart Sanford — ৳1,460.00', 'http://127.0.0.1:8003/order-summary/AJPTNDLON8', 1, '2026-10-06 16:39:50', '2026-10-13 11:46:54'), (15, NULL, 'order', 'New Order Placed', 'Order #0019 placed by Stewart Sanford — ৳910.00', 'http://127.0.0.1:8003/order-summary/K68PFSRJIZ', 1, '2026-10-07 06:40:55', '2026-10-13 11:46:54'), (16, NULL, 'order', 'New Order Placed', 'Order #0020 placed by Stewart Sanford — ৳1,760.00', 'http://127.0.0.1:8003/order-summary/VW6QSYCQM1', 1, '2026-10-07 06:45:00', '2026-10-13 11:46:54'), (17, NULL, 'order', 'New Order Placed', 'Order #0021 placed by Stewart Sanford — ৳2,190.00', 'http://127.0.0.1:8003/order-summary/JOCKHJB7ZZ', 1, '2026-10-07 06:52:15', '2026-10-13 11:46:54'), (18, NULL, 'order', 'New Order Placed', 'Order #0022 placed by Stewart Sanford — ৳674.00', 'http://127.0.0.1:8003/order-summary/XZPPYNSCGG', 1, '2026-10-08 05:43:01', '2026-10-13 11:46:54'), (19, NULL, 'order', 'New Order Placed', 'Order #0023 placed by Stewart Sanford — ৳674.00', 'http://127.0.0.1:8003/order-summary/FWOT5LPRSA', 1, '2026-10-08 05:43:22', '2026-10-13 11:46:54'), (20, NULL, 'order', 'New Order Placed', 'Order #0024 placed by Stewart Sanford — ৳674.00', 'http://127.0.0.1:8003/order-summary/FEK9B3T73I', 1, '2026-10-08 05:50:20', '2026-10-13 11:46:54'), (21, NULL, 'order', 'New Order Placed', 'Order #0025 placed by Stewart Sanford — ৳0.00', 'http://127.0.0.1:8003/order-summary/RHZLQUHFVQ', 1, '2026-10-08 06:06:47', '2026-10-13 11:46:54'), (22, NULL, 'order', 'New Order Placed', 'Order #0026 placed by Stewart Sanford — ৳929.00', 'http://127.0.0.1:8003/order-summary/I28FDP93SJ', 1, '2026-10-08 06:10:30', '2026-10-13 11:46:54'), (23, NULL, 'order', 'New Order Placed', 'Order #0027 placed by Stewart Sanford — ৳3,448.00', 'http://127.0.0.1:8003/order-summary/MK8TNWGI1K', 1, '2026-10-08 06:13:35', '2026-10-13 11:46:54'), (24, NULL, 'order', 'New Order Placed', 'Order #0028 placed by Stewart Sanford — ৳560.00', 'http://127.0.0.1:8003/order-summary/USD8SA3FNI', 1, '2026-10-08 07:25:46', '2026-10-13 11:46:54'), (25, NULL, 'order', 'New Order Placed', 'Order #0029 placed by Stewart Sanford — ৳910.00', 'http://127.0.0.1:8003/order-summary/YCRUX0CPKY', 1, '2026-10-09 13:47:43', '2026-10-13 11:46:54'), (26, NULL, 'order', 'New Order Placed', 'Order #0030 placed by Mohsin Ali — ৳1,420.00', 'http://127.0.0.1:8003/order-summary/VGQR81OBAC', 1, '2026-10-10 19:33:19', '2026-10-13 11:46:54'), (27, NULL, 'order', 'New Order Placed', 'Order #0031 placed by Stewart Sanford — ৳755.00', 'http://127.0.0.1:8003/order-summary/OR0GO5GRPL', 1, '2026-10-12 16:10:56', '2026-10-13 11:46:54'), (28, NULL, 'order', 'New Order Placed', 'Order #0032 placed by Mohsin Ali — ৳2,355.00', 'http://127.0.0.1:8003/order-summary/SVQY7SXLNR', 1, '2026-10-13 11:46:05', '2026-10-13 11:46:54'), (29, NULL, 'order', 'New Order Placed', 'Order #0033 placed by Mohsin Ali — ৳2,860.00', 'http://127.0.0.1:8003/order-summary/MWNYHUFOFW', 0, '2026-10-14 06:45:15', '2026-10-14 06:45:15'), (30, NULL, 'order', 'New Order Placed', 'Order #0034 placed by Mohsin Ali — ৳1,260.00', 'http://127.0.0.1:8003/order-summary/RPVKAZPCTM', 0, '2026-10-14 08:26:00', '2026-10-14 08:26:00'), (31, NULL, 'order', 'New Order Placed', 'Order #0035 placed by Mohsin Ali — ৳3,660.00', 'http://127.0.0.1:8003/order-summary/77GNCOW0YA', 0, '2026-10-14 09:41:45', '2026-10-14 09:41:45'); -- -------------------------------------------------------- -- -- Table structure for table `announcements` -- CREATE TABLE `announcements` ( `id` bigint UNSIGNED NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `highlighted_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_by` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `announcements` -- INSERT INTO `announcements` (`id`, `title`, `highlighted_title`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Free Shipping With Orders', 'Over Tk.2000', 1, '2025-04-14 08:56:46', '2025-04-14 09:01:03', NULL), (3, 'test', 'test', 1, '2025-04-14 09:01:54', '2025-04-14 09:02:37', '2025-04-14 09:02:37'), (4, 'Sign-Up To Receive Flat', 'Tk.100 off', 1, '2025-04-14 09:02:59', '2025-04-14 09:02:59', NULL), (5, 'Free Shipping With Orders', 'Over Tk.2000', 1, '2025-04-14 09:03:15', '2025-04-14 09:03:15', NULL), (6, 'Sign-Up To Receive Flat', 'Tk.100 off', 1, '2025-04-14 09:03:30', '2025-04-14 09:03:30', NULL), (7, 'Free Shipping With Orders', 'Over Tk.2000', 1, '2025-04-14 09:03:45', '2025-04-14 09:03:45', NULL), (8, 'Sign-Up To Receive Flat', 'Tk.100 off', 1, '2025-04-14 09:04:01', '2025-04-14 09:04:01', NULL); -- -------------------------------------------------------- -- -- Table structure for table `brands` -- CREATE TABLE `brands` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `sorting_serial` int NOT NULL DEFAULT '1', `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `brands` -- INSERT INTO `brands` (`id`, `name`, `slug`, `logo`, `image`, `status`, `created_at`, `updated_at`, `created_by`, `sorting_serial`, `deleted_at`) VALUES (1, 'HIGHTECH', 'hightech', 'assets/files/images/brand/1741016722-logo2.png', 'assets/files/images/brand/1741016723-img1.png', 'active', '2025-03-03 09:45:23', '2026-03-05 10:40:48', 1, 3, NULL), (2, 'DIGITECH', 'digitech', 'assets/files/images/brand/1741016765-logo1.png', 'assets/files/images/brand/1741016765-img2.png', 'active', '2025-03-03 09:46:05', '2026-03-05 10:40:48', 1, 4, NULL), (3, 'TECHLOGO', 'techlogo', 'assets/files/images/brand/1741016812-logo3.png', 'assets/files/images/brand/1741016812-img3.png', 'active', '2025-03-03 09:46:52', '2026-03-05 10:40:48', 1, 1, NULL), (4, 'DIGITAL STORE', 'digital-store', 'assets/files/images/brand/1741016859-logo4.png', 'assets/files/images/brand/1741016859-img4.png', 'active', '2025-03-03 09:47:39', '2026-03-05 10:40:48', 1, 2, NULL), (5, 'Tamara', 'tamara', 'assets/files/images/brand/1791352616-Tamara-Logo.jpeg', 'assets/files/images/brand/1791352616-Tamara-banner.jpeg', 'active', '2026-10-07 05:56:56', '2026-10-07 05:56:56', 1, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `brand_banners` -- CREATE TABLE `brand_banners` ( `id` bigint UNSIGNED NOT NULL, `brand_id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `brand_banners` -- INSERT INTO `brand_banners` (`id`, `brand_id`, `image`, `created_at`, `updated_at`) VALUES (1, 1, 'assets/files/images/brand/1741016723-women1.png', '2025-03-03 09:45:23', '2025-03-03 09:45:23'), (2, 1, 'assets/files/images/brand/1741016723-women2.png', '2025-03-03 09:45:23', '2025-03-03 09:45:23'), (3, 1, 'assets/files/images/brand/1741016723-women3.png', '2025-03-03 09:45:23', '2025-03-03 09:45:23'), (4, 2, 'assets/files/images/brand/1741016765-men1.png', '2025-03-03 09:46:06', '2025-03-03 09:46:06'), (5, 2, 'assets/files/images/brand/1741016766-men2.png', '2025-03-03 09:46:06', '2025-03-03 09:46:06'), (6, 2, 'assets/files/images/brand/1741016766-men3.png', '2025-03-03 09:46:06', '2025-03-03 09:46:06'), (7, 3, 'assets/files/images/brand/1741016812-women_casual_1.png', '2025-03-03 09:46:52', '2025-03-03 09:46:52'), (8, 3, 'assets/files/images/brand/1741016812-women_casual_2.png', '2025-03-03 09:46:52', '2025-03-03 09:46:52'), (9, 3, 'assets/files/images/brand/1741016812-women_casual_3.png', '2025-03-03 09:46:52', '2025-03-03 09:46:52'), (10, 4, 'assets/files/images/brand/1741016859-women_winter_2.png', '2025-03-03 09:47:39', '2025-03-03 09:47:39'), (11, 4, 'assets/files/images/brand/1741016859-women_winter_3.png', '2025-03-03 09:47:39', '2025-03-03 09:47:39'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `commission_rate` double(3,2) NOT NULL DEFAULT '0.00', `is_mega_menu` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `sorting_serial` int NOT NULL DEFAULT '1', `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `slug`, `icon`, `image`, `status`, `commission_rate`, `is_mega_menu`, `created_at`, `updated_at`, `created_by`, `sorting_serial`, `deleted_at`) VALUES (1, 'MEN', 'men', 'assets/files/images/category/1740841244-man.png', 'assets/files/images/category/1740841197-man.png', 'inactive', 0.00, 'yes', '2025-03-01 08:59:57', '2026-10-15 09:15:09', 1, 1, NULL), (2, 'HOUSEHOLD', 'household', 'assets/files/images/category/1740841575-woman.png', 'assets/files/images/category/1740841575-women.png', 'active', 0.00, 'yes', '2025-03-01 09:06:15', '2026-10-16 09:26:03', 1, 2, NULL), (3, 'TRADITIONAL', 'traditional', 'assets/files/images/category/1791214659-18320188.png', 'assets/files/images/category/1791214660-images.jpeg', 'active', 0.00, 'yes', '2026-10-05 15:37:40', '2026-10-16 08:58:49', 1, 3, NULL), (4, 'APPAREL', 'apparel', NULL, 'assets/files/images/category/1792055653-1.jpg', 'active', 0.00, 'yes', '2026-10-15 09:14:13', '2026-10-16 09:25:27', 1, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `category_banners` -- CREATE TABLE `category_banners` ( `id` bigint UNSIGNED NOT NULL, `category_id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category_banners` -- INSERT INTO `category_banners` (`id`, `category_id`, `image`, `created_at`, `updated_at`) VALUES (1, 1, 'assets/files/images/category/1740841197-men1.png', '2025-03-01 08:59:57', '2025-03-01 08:59:57'), (2, 1, 'assets/files/images/category/1740841197-men2.png', '2025-03-01 08:59:58', '2025-03-01 08:59:58'), (3, 1, 'assets/files/images/category/1740841198-men3.png', '2025-03-01 08:59:58', '2025-03-01 08:59:58'), (4, 2, 'assets/files/images/category/1740841575-women1.png', '2025-03-01 09:06:15', '2025-03-01 09:06:15'), (5, 2, 'assets/files/images/category/1740841575-women2.png', '2025-03-01 09:06:15', '2025-03-01 09:06:15'), (6, 2, 'assets/files/images/category/1740841575-women3.png', '2025-03-01 09:06:15', '2025-03-01 09:06:15'); -- -------------------------------------------------------- -- -- Table structure for table `colors` -- CREATE TABLE `colors` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `color_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `colors` -- INSERT INTO `colors` (`id`, `name`, `color_code`, `slug`, `created_at`, `updated_at`, `created_by`, `deleted_at`) VALUES (1, 'GREY', '#f0f0f0', 'grey', '2025-03-03 10:01:09', '2025-03-03 10:01:16', 1, NULL), (2, 'BLACK', '#151414', 'black', '2025-03-03 10:01:53', '2025-03-03 10:01:53', 1, NULL), (3, 'RED', '#c92222', 'red', '2025-03-03 10:02:04', '2025-03-03 10:02:04', 1, NULL), (4, 'ORANGE', '#e16623', 'orange', '2025-03-03 10:02:27', '2025-03-03 10:02:27', 1, NULL), (5, 'YELOW', '#e6df19', 'yelow', '2025-03-03 10:02:40', '2025-03-03 10:02:40', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` bigint UNSIGNED NOT NULL, `valid_for` enum('all-user','new-user') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `coupon_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `discount_type` enum('flat','percentage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `discount` int NOT NULL, `used_limit` int NOT NULL DEFAULT '1', `minimum_cost` int NOT NULL DEFAULT '0', `up_to` int NOT NULL DEFAULT '0', `start_date` date NOT NULL, `end_date` date NOT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_by` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `updated_by` int DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `deleted_by` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `coupons` -- INSERT INTO `coupons` (`id`, `valid_for`, `coupon_code`, `discount_type`, `discount`, `used_limit`, `minimum_cost`, `up_to`, `start_date`, `end_date`, `status`, `created_by`, `created_at`, `updated_at`, `updated_by`, `deleted_at`, `deleted_by`) VALUES (1, 'new-user', 'DUMMY1234', 'flat', 20, 19, 25, 40, '2025-09-24', '2025-09-30', 'active', 1, '2025-09-27 10:09:31', '2025-09-27 10:28:24', 1, NULL, 1), (2, 'all-user', 'DUMMY20', 'percentage', 10, 51, 50, 34, '2025-09-26', '2025-09-30', 'active', 1, '2025-09-27 10:10:03', '2025-09-27 10:16:46', 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `delivery_charges` -- CREATE TABLE `delivery_charges` ( `id` bigint UNSIGNED NOT NULL, `district_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `delivery_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `created_by` int NOT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `delivery_charges` -- INSERT INTO `delivery_charges` (`id`, `district_name`, `slug`, `delivery_charge`, `created_by`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Dhaka', 'dhaka', 60.00, 1, 'active', '2025-05-30 22:49:07', '2025-05-30 22:59:49', NULL), (2, 'Rangpur', 'rangpur', 100.00, 1, 'active', '2025-05-30 22:56:04', '2025-05-30 22:59:33', NULL), (3, 'Rajshahi', 'rajshahi', 110.00, 1, 'active', '2025-05-30 22:59:19', '2025-06-02 10:48:26', NULL); -- -------------------------------------------------------- -- -- Table structure for table `expenses` -- CREATE TABLE `expenses` ( `id` bigint UNSIGNED NOT NULL, `admin_id` bigint UNSIGNED NOT NULL, `expense_category_id` bigint UNSIGNED DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `amount` decimal(12,2) NOT NULL, `expense_date` date NOT NULL, `attachment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `expenses` -- INSERT INTO `expenses` (`id`, `admin_id`, `expense_category_id`, `title`, `description`, `amount`, `expense_date`, `attachment`, `created_at`, `updated_at`) VALUES (1, 1, 1, 'janu bill', 'ddd', 500.00, '2026-03-05', NULL, '2026-03-05 11:15:58', '2026-03-05 11:15:58'), (2, 1, 1, 'ddd', NULL, 50.00, '2026-03-05', NULL, '2026-03-05 11:16:19', '2026-03-05 11:16:19'), (3, 1, 1, 'December 24 bill paid', NULL, 600.00, '2026-03-05', NULL, '2026-03-05 11:17:13', '2026-03-05 11:17:13'), (4, 1, 3, 'TEA COFFE BILL', NULL, 600.00, '2026-03-05', NULL, '2026-03-05 11:18:25', '2026-03-05 11:18:25'); -- -------------------------------------------------------- -- -- Table structure for table `expense_categories` -- CREATE TABLE `expense_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#6b7280', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `expense_categories` -- INSERT INTO `expense_categories` (`id`, `name`, `color`, `created_at`, `updated_at`) VALUES (1, 'Electricity', '#4361ee', '2026-03-05 11:15:40', '2026-03-05 11:15:40'), (2, 'Office Rent', '#d144ee', '2026-03-05 11:17:43', '2026-03-05 11:17:43'), (3, 'Tea and Coffe', '#b844ee', '2026-03-05 11:18:00', '2026-03-05 11:18:00'), (4, 'Product Purchase', '#4361ee', '2026-10-11 07:28:10', '2026-10-11 07:28:10'), (5, 'Courier Charge', '#3a0ca3', '2026-10-11 07:28:10', '2026-10-11 07:28:10'), (6, 'Packaging', '#7209b7', '2026-10-11 07:28:10', '2026-10-11 07:28:10'), (7, 'Marketing', '#f72585', '2026-10-11 07:28:10', '2026-10-11 07:28:10'), (8, 'Salary', '#4cc9f0', '2026-10-11 07:28:10', '2026-10-11 07:28:10'), (9, 'Other Expenses', '#6c757d', '2026-10-11 07:28:10', '2026-10-11 07:28:10'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `id` bigint UNSIGNED NOT NULL, `question` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `faqs` -- INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES (2, 'What are the delivery charges for orders from the Online Shop?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id convallis tellus. Nulla aliquam in mi et convallis. Pellentesque rutrum feugiat ante ut imperdiet. Vivamus et dolor nec nisl consectetur vulputate id non ante.', '2025-07-09 11:17:19', '2025-07-09 11:17:19'), (3, 'Which payment methods are accepted in the Online Shop?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id convallis tellus. Nulla aliquam in mi et convallis. Pellentesque rutrum feugiat ante ut imperdiet. Vivamus et dolor nec nisl consectetur vulputate id non ante.', '2025-07-09 11:17:34', '2025-07-09 11:17:34'), (4, 'How long will delivery take?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id convallis tellus. Nulla aliquam in mi et convallis. Pellentesque rutrum feugiat ante ut imperdiet. Vivamus et dolor nec nisl consectetur vulputate id non ante.', '2025-07-09 11:17:49', '2025-07-09 11:17:49'), (5, 'How secure is shopping in the Online Shop? Is my data protected?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id convallis tellus. Nulla aliquam in mi et convallis. Pellentesque rutrum feugiat ante ut imperdiet. Vivamus et dolor nec nisl consectetur vulputate id non ante.', '2025-07-09 11:18:05', '2025-07-09 11:18:05'), (6, 'What exactly happens after ordering?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id convallis tellus. Nulla aliquam in mi et convallis. Pellentesque rutrum feugiat ante ut imperdiet. Vivamus et dolor nec nisl consectetur vulputate id non ante.', '2025-07-09 11:18:20', '2025-07-09 11:18:20'), (7, 'Do I receive an invoice for my order ?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id convallis tellus. Nulla aliquam in mi et convallis. Pellentesque rutrum feugiat ante ut imperdiet. Vivamus et dolor nec nisl consectetur vulputate id non ante.', '2025-07-09 11:18:37', '2025-07-09 11:27:04'); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint UNSIGNED NOT NULL, `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint UNSIGNED NOT NULL, `reserved_at` int UNSIGNED DEFAULT NULL, `available_at` int UNSIGNED NOT NULL, `created_at` int UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `jobs` -- INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES (53, 'default', '{\"uuid\":\"0690e5ad-80d5-481b-9f97-a63211d6f92b\",\"displayName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":3,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"command\":\"O:42:\\\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\\\":1:{s:7:\\\"orderId\\\";i:32;}\"}}', 0, NULL, 1791964578, 1791964578), (54, 'default', '{\"uuid\":\"ba74c630-2f5a-4e60-9e5b-f895af4fc08d\",\"displayName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":3,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"command\":\"O:42:\\\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\\\":1:{s:7:\\\"orderId\\\";i:32;}\"}}', 0, NULL, 1791964578, 1791964578), (55, 'default', '{\"uuid\":\"54d63ba1-3165-4452-bbe0-915821b39dd0\",\"displayName\":\"App\\\\Jobs\\\\LogSellerOrderJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\LogSellerOrderJob\",\"command\":\"O:26:\\\"App\\\\Jobs\\\\LogSellerOrderJob\\\":1:{s:10:\\\"\\u0000*\\u0000orderId\\\";i:65;}\"}}', 0, NULL, 1791966360, 1791966360), (56, 'default', '{\"uuid\":\"fe43fe7d-d335-4626-b1ec-0ef6920c6d30\",\"displayName\":\"App\\\\Jobs\\\\SendOrderPlacedNotificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":3,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendOrderPlacedNotificationJob\",\"command\":\"O:39:\\\"App\\\\Jobs\\\\SendOrderPlacedNotificationJob\\\":1:{s:7:\\\"orderId\\\";i:65;}\"}}', 0, NULL, 1791966360, 1791966360), (57, 'default', '{\"uuid\":\"c7dd8a84-ede9-40dd-bedb-6a2058512529\",\"displayName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":3,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"command\":\"O:42:\\\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\\\":1:{s:7:\\\"orderId\\\";i:65;}\"}}', 0, NULL, 1791970274, 1791970274), (58, 'default', '{\"uuid\":\"be2775ae-9678-4eed-b480-dfdf09fa54eb\",\"displayName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":3,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\",\"command\":\"O:42:\\\"App\\\\Jobs\\\\SendOrderDeliveredNotificationJob\\\":1:{s:7:\\\"orderId\\\";i:65;}\"}}', 0, NULL, 1791970274, 1791970274), (59, 'default', '{\"uuid\":\"2af4c49c-2fac-425f-a51d-3ddf49bfb6ae\",\"displayName\":\"App\\\\Jobs\\\\LogSellerOrderJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\LogSellerOrderJob\",\"command\":\"O:26:\\\"App\\\\Jobs\\\\LogSellerOrderJob\\\":1:{s:10:\\\"\\u0000*\\u0000orderId\\\";i:66;}\"}}', 0, NULL, 1791970905, 1791970905), (60, 'default', '{\"uuid\":\"9e51ec60-c7c2-4688-a173-8f46e1848f16\",\"displayName\":\"App\\\\Jobs\\\\SendOrderPlacedNotificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":3,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendOrderPlacedNotificationJob\",\"command\":\"O:39:\\\"App\\\\Jobs\\\\SendOrderPlacedNotificationJob\\\":1:{s:7:\\\"orderId\\\";i:66;}\"}}', 0, NULL, 1791970905, 1791970905); -- -------------------------------------------------------- -- -- Table structure for table `join_requests` -- CREATE TABLE `join_requests` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `cv_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('pending','shortlisted','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `join_requests` -- INSERT INTO `join_requests` (`id`, `name`, `email`, `mobile`, `cv_path`, `status`, `created_at`, `updated_at`) VALUES (1, 'Ivy Berger', 'pecesewify@mailinator.com', '01609605494', '1752337575_.pdf', 'pending', '2025-07-12 10:26:15', '2025-07-12 10:26:15'), (2, 'Cassandra Terrell', 'bocyza@mailinator.com', '01609605494', '1752337836_.pdf', 'pending', '2025-07-12 10:30:36', '2025-07-12 10:30:36'); -- -------------------------------------------------------- -- -- Table structure for table `latest_offer_products` -- CREATE TABLE `latest_offer_products` ( `id` bigint UNSIGNED NOT NULL, `seller_id` int NOT NULL, `product_id` int NOT NULL, `sorting_serial` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `latest_offer_products` -- INSERT INTO `latest_offer_products` (`id`, `seller_id`, `product_id`, `sorting_serial`, `created_at`, `updated_at`) VALUES (1, 1, 1, 2, '2025-05-14 10:14:46', '2025-05-14 10:19:40'), (2, 1, 3, 3, '2025-05-14 10:14:53', '2025-05-14 10:19:40'), (3, 1, 7, 4, '2025-05-14 10:14:59', '2025-05-14 10:19:40'), (4, 1, 8, 5, '2025-05-14 10:15:03', '2025-05-14 10:15:03'), (5, 1, 9, 1, '2025-05-14 10:15:07', '2025-05-14 10:24:06'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2024_05_03_161830_create_admins_table', 1), (6, '2024_05_03_173255_create_categories_table', 1), (7, '2024_05_06_162033_create_sub_categories_table', 1), (8, '2024_05_06_174341_create_sizes_table', 1), (9, '2024_05_06_174456_create_colors_table', 1), (10, '2024_05_06_174503_create_units_table', 1), (11, '2024_05_06_175226_create_sub_subcategories_table', 1), (12, '2024_05_07_134442_create_brands_table', 1), (13, '2024_05_08_140756_create_products_table', 1), (14, '2024_05_08_144644_create_product_images_table', 1), (15, '2024_05_10_061326_create_tags_table', 1), (16, '2024_11_27_183203_create_seller_shops_table', 1), (17, '2024_11_28_150451_create_product_variants_table', 1), (18, '2025_01_25_050917_create_web_product_sections_table', 1), (19, '2025_01_25_051733_create_section_products_table', 1), (20, '2025_02_20_175403_create_category_banners_table', 1), (21, '2025_02_20_175444_create_sub_category_banners_table', 1), (22, '2025_02_20_175455_create_sub_sub_category_banners_table', 1), (23, '2025_02_20_175507_create_brand_banners_table', 1), (24, '2025_02_27_160100_create_product_types_table', 1), (25, '2025_03_03_160800_add_extra_field_on_products_table', 2), (26, '2025_03_04_162333_add_seller_id_on_products', 3), (29, '2025_04_14_053003_create_sliders_table', 4), (31, '2025_04_14_053434_create_slider_products_table', 5), (33, '2025_04_14_144024_create_announcements_table', 6), (34, '2025_04_15_152040_create_new_in_products_table', 7), (35, '2025_04_26_042340_create_carts_table', 8), (36, '2014_10_12_000000_create_users_table', 9), (37, '2025_04_29_153309_create_product_type_categories_table', 10), (38, '2025_04_29_165543_add_fulltext_index_to_products_table', 11), (47, '2025_04_30_151142_create_orders_table', 12), (48, '2025_04_30_151416_create_order_products_table', 12), (49, '2025_05_07_154740_add_google_id_column', 13), (50, '2025_05_07_162556_add_google_id_column', 14), (51, '2025_05_13_160841_add_verification_code', 15), (52, '2025_05_14_155541_create_latest_offer_products_table', 16), (55, '2025_05_17_152851_create_seller_order_logs_table', 17), (56, '2025_05_17_162333_create_jobs_table', 18), (58, '2025_05_30_184627_create_push_subscriptions_table', 19), (60, '2025_05_31_032933_create_delivery_charges_table', 20), (64, '2025_05_31_184416_create_transactions_table', 22), (67, '2025_05_31_033615_add_extr_field', 23), (68, '2025_07_09_170108_create_faqs_table', 24), (69, '2025_07_12_161500_create_join_requests_table', 25), (70, '2025_07_13_171944_create_reviews_table', 26), (71, '2025_07_23_174315_create_wishlists_table', 27), (74, '2025_08_29_054245_create_coupons_table', 28), (76, '2025_10_10_180044_add_extr_table_field', 29), (77, '2026_02_21_104505_create_vendor_payouts_table', 30), (78, '2026_02_21_104531_add_balance_to_admins_table', 30), (79, '2026_02_21_105025_create_refund_requests_table', 31), (80, '2026_02_21_110456_create_roles_table', 32), (81, '2026_02_21_131201_add_seo_columns_to_products_table', 33), (82, '2026_03_05_160000_create_notifications_todos_expenses_courier', 34), (83, '2026_10_09_160000_create_shipments_table', 35), (84, '2026_10_09_160001_create_shipment_logs_table', 35), (85, '2026_10_09_170000_add_lifecycle_columns_to_shipments_table', 36), (86, '2026_10_09_170001_create_return_requests_table', 36), (87, '2026_10_09_170002_create_return_request_items_table', 36), (88, '2026_10_09_170003_create_order_transactions_table', 36), (89, '2026_10_11_010000_add_notification_tracking_to_orders_table', 37), (90, '2026_10_11_020000_add_cost_price_and_purchases_tables', 38); -- -------------------------------------------------------- -- -- Table structure for table `new_in_products` -- CREATE TABLE `new_in_products` ( `id` bigint UNSIGNED NOT NULL, `product_id` int NOT NULL, `sorting_serial` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `new_in_products` -- INSERT INTO `new_in_products` (`id`, `product_id`, `sorting_serial`, `created_at`, `updated_at`) VALUES (16, 7, 3, '2025-05-14 09:40:52', '2025-06-02 11:09:25'), (17, 10, 4, '2025-05-14 09:40:53', '2025-06-02 11:09:04'), (18, 11, 2, '2025-05-14 09:40:57', '2025-06-02 11:09:25'), (19, 9, 1, '2025-05-14 09:41:01', '2025-06-02 11:09:25'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` bigint UNSIGNED NOT NULL, `unique_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `total_item_unit_price` double(8,2) NOT NULL DEFAULT '0.00', `total_item_discount` double(8,2) NOT NULL DEFAULT '0.00', `total_item_order_price` double(8,2) NOT NULL DEFAULT '0.00', `coupon_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `coupon_discount_amount` double(8,2) NOT NULL DEFAULT '0.00', `shipping_fee` double(8,2) NOT NULL DEFAULT '0.00', `seller_count` int NOT NULL DEFAULT '0', `service_charge` double(8,2) NOT NULL DEFAULT '0.00', `total_vat` double(8,2) NOT NULL DEFAULT '0.00', `total_discount` double(8,2) NOT NULL, `total_order_price` double(8,2) NOT NULL, `order_status` enum('pending','processing','shipped','delivered','canceled','cancelled','complete','returned') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `placed_notification_sent_at` timestamp NULL DEFAULT NULL, `delivered_notification_sent_at` timestamp NULL DEFAULT NULL, `payment_method` enum('cash-on-delivery','online-payment') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cash-on-delivery', `payment_status` enum('paid','unpaid') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid', `paid_amount` double(8,2) NOT NULL DEFAULT '0.00', `due_amount` double(8,2) NOT NULL DEFAULT '0.00', `first_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `district_id` int DEFAULT NULL, `city_town` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `post_code` int DEFAULT NULL, `additional_information` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `delete_by` int DEFAULT NULL, `courier_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courier_tracking_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courier_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `unique_id`, `order_number`, `invoice`, `user_id`, `total_item_unit_price`, `total_item_discount`, `total_item_order_price`, `coupon_code`, `coupon_discount_amount`, `shipping_fee`, `seller_count`, `service_charge`, `total_vat`, `total_discount`, `total_order_price`, `order_status`, `placed_notification_sent_at`, `delivered_notification_sent_at`, `payment_method`, `payment_status`, `paid_amount`, `due_amount`, `first_name`, `last_name`, `mobile`, `email`, `district_id`, `city_town`, `address`, `post_code`, `additional_information`, `created_at`, `updated_at`, `deleted_at`, `delete_by`, `courier_name`, `courier_tracking_id`, `courier_status`) VALUES (32, 'WZ76EYWHTG', '0001', 'RT-68288997', 6, 9512.00, 1105.00, 8407.00, '', 0.00, 120.00, 2, 0.00, 0.00, 1105.00, 8527.00, 'delivered', NULL, NULL, 'cash-on-delivery', 'paid', 8527.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2025-10-10 12:09:10', '2026-10-09 14:17:57', NULL, NULL, 'Steadfast Courier', 'SF9E60249F', 'Delivered'), (33, 'YRHSHNTGDM', '0002', 'RT-47404866', 6, 500.00, 70.00, 430.00, '', 0.00, 60.00, 1, 10.00, 0.00, 70.00, 500.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 500.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-02-21 07:53:29', '2026-02-21 07:53:29', NULL, NULL, NULL, NULL, NULL), (34, 'XRK9TNXFOH', '0003', 'RT-67011758', 6, 500.00, 70.00, 430.00, '', 0.00, 60.00, 1, 10.00, 0.00, 70.00, 500.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 500.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-02-21 07:53:35', '2026-02-21 07:53:35', NULL, NULL, NULL, NULL, NULL), (35, 'AYMBWBIU1R', '0004', 'RT-49642138', 6, 500.00, 70.00, 430.00, '', 0.00, 60.00, 1, 0.00, 0.00, 70.00, 490.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 490.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-02-21 07:53:40', '2026-03-05 23:29:06', NULL, NULL, 'Steadfast', NULL, NULL), (36, 'DACKVHJYHY', '0005', 'RT-74987935', 6, 800.00, 300.00, 500.00, '', 0.00, 100.00, 1, 12.00, 0.00, 300.00, 612.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 612.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-03-31 11:40:24', '2026-03-31 11:40:24', NULL, NULL, NULL, NULL, NULL), (37, 'BPN5ZZQORK', '0006', 'RT-92293269', 6, 800.00, 300.00, 500.00, '', 0.00, 100.00, 1, 0.00, 0.00, 300.00, 600.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 600.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-03-31 11:40:33', '2026-03-31 11:40:33', NULL, NULL, NULL, NULL, NULL), (38, '2W9PHSXDIN', '0007', 'RT-86865137', 6, 5000.00, 200.00, 4800.00, '', 0.00, 60.00, 1, 0.00, 0.00, 200.00, 4860.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 4860.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-03-31 11:41:37', '2026-03-31 11:42:22', NULL, NULL, 'Pathao', NULL, 'Pending'), (39, 'ZIJBWKPXT4', '0008', 'RT-67328351', 8, 12000.00, 1500.00, 10500.00, '', 0.00, 100.00, 1, 212.00, 0.00, 1500.00, 10812.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 10812.00, 'Gage', 'Delacruz', '01737773393', 'nahixekony@mailinator.com', 1, 'Nostrud voluptates d', 'Ut consequatur excep', 33979, NULL, '2026-04-17 22:16:23', '2026-04-17 22:16:23', NULL, NULL, NULL, NULL, NULL), (40, 'WTA5EKYCME', '0009', 'RT-72874172', 8, 12000.00, 1500.00, 10500.00, '', 0.00, 100.00, 1, 0.00, 0.00, 1500.00, 10600.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 10600.00, 'Gage', 'Delacruz', '01737773393', 'nahixekony@mailinator.com', 1, 'Nostrud voluptates d', 'Ut consequatur excep', 33979, NULL, '2026-04-17 22:16:30', '2026-04-17 22:16:30', NULL, NULL, NULL, NULL, NULL), (41, 'INHDI53GWU', '0010', 'RT-38271938', 6, 900.00, 200.00, 700.00, '', 0.00, 60.00, 1, 16.00, 0.00, 200.00, 776.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 776.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-04 12:21:51', '2026-10-04 12:21:51', NULL, NULL, NULL, NULL, NULL), (42, 'NDWMLI5VR4', '0011', 'RT-85857616', 6, 900.00, 200.00, 700.00, '', 0.00, 60.00, 1, 0.00, 0.00, 200.00, 760.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 760.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-04 12:22:00', '2026-10-04 12:22:00', NULL, NULL, NULL, NULL, NULL), (43, 'BEMWOH5TJA', '0012', 'RT-34400013', 6, 1800.00, 1200.00, 1600.00, '', 0.00, 60.00, 1, 34.00, 0.00, 1200.00, 1694.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 1694.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-05 18:13:30', '2026-10-05 18:13:30', NULL, NULL, NULL, NULL, NULL), (44, 'AUPZHZO93J', '0013', 'RT-22544085', 6, 1800.00, 1200.00, 1600.00, '', 0.00, 60.00, 1, 34.00, 0.00, 1200.00, 1694.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 1694.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-05 18:13:52', '2026-10-05 18:13:52', NULL, NULL, NULL, NULL, NULL), (45, 'BY9E8OT8XD', '0014', 'RT-94352325', 6, 1800.00, 1200.00, 1600.00, '', 0.00, 60.00, 1, 34.00, 0.00, 1200.00, 1694.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 1694.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-05 18:14:18', '2026-10-05 18:14:18', NULL, NULL, NULL, NULL, NULL), (46, 'JRJDKR2Y8I', '0015', 'RT-79256694', 6, 1800.00, 1200.00, 1600.00, '', 0.00, 60.00, 1, 34.00, 0.00, 1200.00, 1694.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 1694.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-05 18:14:20', '2026-10-05 18:14:20', NULL, NULL, NULL, NULL, NULL), (47, 'KIPKOLXL62', '0016', 'RT-35167757', 6, 1800.00, 1200.00, 1600.00, '', 0.00, 60.00, 1, 0.00, 0.00, 1200.00, 1660.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 1660.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-05 18:14:32', '2026-10-05 18:14:32', NULL, NULL, NULL, NULL, NULL), (48, 'HRQRASD9CF', '0017', 'RT-76410230', 6, 1800.00, 1200.00, 1600.00, '', 0.00, 60.00, 1, 0.00, 0.00, 1200.00, 1660.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 1660.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-05 18:15:49', '2026-10-05 18:15:49', NULL, NULL, NULL, NULL, NULL), (49, 'AJPTNDLON8', '0018', 'RT-88096539', 6, 1700.00, 300.00, 1400.00, '', 0.00, 60.00, 1, 0.00, 0.00, 300.00, 1460.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 1460.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-06 16:39:50', '2026-10-06 16:39:50', NULL, NULL, NULL, NULL, NULL), (50, 'K68PFSRJIZ', '0019', 'RT-49209621', 6, 850.00, 850.00, 850.00, '', 0.00, 60.00, 1, 0.00, 0.00, 850.00, 910.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 910.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-07 06:40:55', '2026-10-07 06:40:55', NULL, NULL, NULL, NULL, NULL), (51, 'VW6QSYCQM1', '0020', 'RT-85004669', 6, 1700.00, 1700.00, 1700.00, '', 0.00, 60.00, 1, 0.00, 0.00, 1700.00, 1760.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 1760.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-07 06:45:00', '2026-10-07 06:45:00', NULL, NULL, NULL, NULL, NULL), (52, 'JOCKHJB7ZZ', '0021', 'RT-76266182', 6, 2200.00, 1770.00, 2130.00, '', 0.00, 60.00, 1, 0.00, 0.00, 1770.00, 2190.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 2190.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-07 06:52:15', '2026-10-07 06:52:15', NULL, NULL, NULL, NULL, NULL), (53, 'XZPPYNSCGG', '0022', 'RT-89787474', 6, 800.00, 200.00, 600.00, '', 0.00, 60.00, 1, 14.00, 0.00, 200.00, 674.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 674.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 05:43:01', '2026-10-08 05:43:01', NULL, NULL, NULL, NULL, NULL), (54, 'FWOT5LPRSA', '0023', 'RT-89784480', 6, 800.00, 200.00, 600.00, '', 0.00, 60.00, 1, 14.00, 0.00, 200.00, 674.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 674.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 05:43:22', '2026-10-08 07:16:58', NULL, NULL, 'Steadfast', NULL, 'Delivered'), (55, 'FEK9B3T73I', '0024', 'RT-44954795', 6, 800.00, 200.00, 600.00, '', 0.00, 60.00, 1, 14.00, 0.00, 200.00, 674.00, 'pending', NULL, NULL, 'online-payment', 'paid', 674.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 05:50:20', '2026-10-08 07:07:03', NULL, NULL, NULL, NULL, NULL), (56, 'RHZLQUHFVQ', '0025', 'RT-77549399', 6, 0.00, 0.00, 0.00, '', 0.00, 0.00, 0, 0.00, 0.00, 0.00, 0.00, 'pending', NULL, NULL, 'online-payment', 'unpaid', 0.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 06:06:47', '2026-10-08 06:06:47', NULL, NULL, NULL, NULL, NULL), (57, 'I28FDP93SJ', '0026', 'RT-36465350', 6, 850.00, 850.00, 850.00, '', 0.00, 60.00, 1, 19.00, 0.00, 850.00, 929.00, 'pending', NULL, NULL, 'online-payment', 'paid', 929.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 06:10:30', '2026-10-08 06:11:39', NULL, NULL, NULL, NULL, NULL), (58, 'MK8TNWGI1K', '0027', 'RT-44269846', 6, 3900.00, 1430.00, 3320.00, '', 0.00, 60.00, 1, 68.00, 0.00, 1430.00, 3448.00, 'delivered', NULL, NULL, 'online-payment', 'paid', 3448.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 06:13:35', '2026-10-09 12:15:18', NULL, NULL, 'Steadfast Courier', 'SF03B0FBDB', 'In_review'), (59, 'USD8SA3FNI', '0028', 'RT-61481485', 6, 800.00, 300.00, 500.00, '', 0.00, 60.00, 1, 0.00, 0.00, 300.00, 560.00, 'delivered', NULL, NULL, 'cash-on-delivery', 'paid', 560.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-08 07:25:46', '2026-10-09 14:16:27', NULL, NULL, NULL, NULL, NULL), (60, 'YCRUX0CPKY', '0029', 'RT-54784683', 6, 850.00, 850.00, 850.00, '', 0.00, 60.00, 1, 0.00, 0.00, 850.00, 910.00, 'delivered', '2026-10-10 19:05:03', '2026-10-10 19:05:44', 'cash-on-delivery', 'paid', 910.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-09 13:47:43', '2026-10-10 19:05:44', NULL, NULL, 'Steadfast Courier', 'STDF-727842D7', 'Delivered'), (61, 'VGQR81OBAC', '0030', 'RT-53447206', 9, 1700.00, 340.00, 1360.00, '', 0.00, 60.00, 1, 0.00, 0.00, 340.00, 1420.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 1420.00, 'Mohsin', 'Ali', '01719540019', 'ami.mohsin@gmail.com', 1, 'Bashundhara', 'House-884, Floor-4th, Road-13, Block-I', 1229, NULL, '2026-10-10 19:33:19', '2026-10-10 19:33:19', NULL, NULL, NULL, NULL, NULL), (62, 'OR0GO5GRPL', '0031', 'RT-92459738', 6, 850.00, 170.00, 680.00, '', 0.00, 60.00, 1, 15.00, 0.00, 170.00, 755.00, 'delivered', NULL, NULL, 'online-payment', 'paid', 755.00, 0.00, 'Stewart', 'Sanford', '01609605491', 'mkraju.eatl@gmail.com', 1, 'Eligendi occaecat es', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 5256, NULL, '2026-10-12 16:10:56', '2026-10-12 16:19:01', NULL, NULL, 'Steadfast Courier', 'STDF-01F8A970', 'Delivered'), (63, 'SVQY7SXLNR', '0032', 'RT-48980233', 9, 2550.00, 1105.00, 2295.00, '', 0.00, 60.00, 1, 0.00, 0.00, 1105.00, 2355.00, 'pending', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 2355.00, 'Mohsin', 'Ali', '01719540019', 'ami.mohsin@gmail.com', 1, 'Bashundhara', 'House-884, Floor-4th, Road-13, Block-I', 1229, NULL, '2026-10-13 11:46:05', '2026-10-13 11:46:05', NULL, NULL, NULL, NULL, NULL), (64, 'MWNYHUFOFW', '0033', 'RT-59749838', 9, 3600.00, 800.00, 2800.00, '', 0.00, 60.00, 1, 0.00, 0.00, 800.00, 2860.00, 'shipped', '2026-10-14 06:55:01', NULL, 'cash-on-delivery', 'unpaid', 0.00, 2860.00, 'Mohsin', 'Ali', '01719540019', 'ami.mohsin@gmail.com', 1, 'Bashundhara', 'House-884, Floor-4th, Road-13, Block-I', 1229, NULL, '2026-10-14 06:45:15', '2026-10-14 08:22:00', NULL, NULL, 'Steadfast Courier', 'STDF-70A7B242', 'In_review'), (65, 'RPVKAZPCTM', '0034', 'BO-99384105', 9, 1600.00, 400.00, 1200.00, '', 0.00, 60.00, 1, 0.00, 0.00, 400.00, 1260.00, 'delivered', NULL, NULL, 'cash-on-delivery', 'paid', 1260.00, 0.00, 'Mohsin', 'Ali', '01719540019', 'ami.mohsin@gmail.com', 1, 'Bashundhara', 'House-884, Floor-4th, Road-13, Block-I', 1229, NULL, '2026-10-14 08:25:59', '2026-10-14 09:31:14', NULL, NULL, 'Carrybee', 'F1014TZK95S', 'Delivered'), (66, '77GNCOW0YA', '0035', 'BO-11221928', 9, 4000.00, 400.00, 3600.00, '', 0.00, 60.00, 1, 0.00, 0.00, 400.00, 3660.00, 'shipped', NULL, NULL, 'cash-on-delivery', 'unpaid', 0.00, 3660.00, 'Mohsin', 'Ali', '01719540019', 'ami.mohsin@gmail.com', 1, 'Bashundhara', 'House-884, Floor-4th, Road-13, Block-I', 1229, NULL, '2026-10-14 09:41:45', '2026-10-14 09:42:27', NULL, NULL, 'Carrybee', 'F10144ZF8CN', 'In_review'); -- -------------------------------------------------------- -- -- Table structure for table `order_products` -- CREATE TABLE `order_products` ( `id` bigint UNSIGNED NOT NULL, `order_id` int NOT NULL, `user_id` int NOT NULL, `seller_id` int NOT NULL, `variant_id` int NOT NULL, `product_id` int NOT NULL, `item_unit_price` double(8,2) NOT NULL DEFAULT '0.00', `item_discount_price` double(8,2) NOT NULL DEFAULT '0.00', `item_order_price` double(8,2) NOT NULL DEFAULT '0.00', `quantity` int NOT NULL DEFAULT '1', `item_total_unit_price` double(8,2) NOT NULL DEFAULT '0.00', `item_total_discount` double(8,2) NOT NULL DEFAULT '0.00', `item_total_order_price` double(8,2) NOT NULL DEFAULT '0.00', `size` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order_status` enum('pending','canceled','processing','shipped','delivered','returned') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `last_updated_by` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `order_products` -- INSERT INTO `order_products` (`id`, `order_id`, `user_id`, `seller_id`, `variant_id`, `product_id`, `item_unit_price`, `item_discount_price`, `item_order_price`, `quantity`, `item_total_unit_price`, `item_total_discount`, `item_total_order_price`, `size`, `color`, `order_status`, `last_updated_by`, `created_at`, `updated_at`) VALUES (90, 32, 6, 2, 32, 11, 5000.00, 4800.00, 4800.00, 1, 5000.00, 200.00, 4800.00, 'L', 'ORANGE', 'delivered', 1, '2025-10-10 12:09:10', '2026-10-09 14:17:57'), (91, 32, 6, 1, 19, 7, 500.00, 800.00, 400.00, 2, 1000.00, 600.00, 800.00, 'M', 'GREY', 'delivered', 1, '2025-10-10 12:09:10', '2026-10-09 14:17:57'), (92, 32, 6, 2, 38, 13, 912.00, 707.00, 707.00, 1, 912.00, 205.00, 707.00, 'N/A', 'N/A', 'delivered', 1, '2025-10-10 12:09:10', '2026-10-09 14:17:57'), (93, 32, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'delivered', 1, '2025-10-10 12:09:10', '2026-10-09 14:17:57'), (94, 32, 6, 1, 7, 3, 900.00, 700.00, 700.00, 1, 900.00, 200.00, 700.00, 'L', 'BLACK', 'delivered', 1, '2025-10-10 12:09:10', '2026-10-09 14:17:57'), (95, 32, 6, 1, 22, 8, 900.00, 800.00, 800.00, 1, 900.00, 100.00, 800.00, 'L', 'GREY', 'delivered', 1, '2025-10-10 12:09:10', '2026-10-09 14:17:57'), (96, 33, 6, 1, 19, 7, 500.00, 430.00, 430.00, 1, 500.00, 70.00, 430.00, 'M', 'GREY', 'processing', 1, '2026-02-21 07:53:29', '2026-10-08 07:24:03'), (97, 34, 6, 1, 19, 7, 500.00, 430.00, 430.00, 1, 500.00, 70.00, 430.00, 'M', 'GREY', 'pending', NULL, '2026-02-21 07:53:35', '2026-02-21 07:53:35'), (98, 35, 6, 1, 19, 7, 500.00, 430.00, 430.00, 1, 500.00, 70.00, 430.00, 'M', 'GREY', 'pending', NULL, '2026-02-21 07:53:40', '2026-02-21 07:53:40'), (99, 36, 6, 1, 28, 10, 800.00, 500.00, 500.00, 1, 800.00, 300.00, 500.00, 'L', 'GREY', 'pending', NULL, '2026-03-31 11:40:24', '2026-03-31 11:40:24'), (100, 37, 6, 1, 28, 10, 800.00, 500.00, 500.00, 1, 800.00, 300.00, 500.00, 'L', 'GREY', 'pending', NULL, '2026-03-31 11:40:33', '2026-03-31 11:40:33'), (101, 38, 6, 2, 32, 11, 5000.00, 4800.00, 4800.00, 1, 5000.00, 200.00, 4800.00, 'L', 'ORANGE', 'processing', 1, '2026-03-31 11:41:37', '2026-03-31 11:42:30'), (102, 39, 8, 1, 34, 12, 4000.00, 10500.00, 3500.00, 3, 12000.00, 8500.00, 10500.00, 'L', 'BLACK', 'pending', NULL, '2026-04-17 22:16:23', '2026-04-17 22:16:23'), (103, 40, 8, 1, 34, 12, 4000.00, 10500.00, 3500.00, 3, 12000.00, 8500.00, 10500.00, 'L', 'BLACK', 'processing', 1, '2026-04-17 22:16:30', '2026-04-17 22:18:40'), (104, 41, 6, 1, 7, 3, 900.00, 700.00, 700.00, 1, 900.00, 200.00, 700.00, 'L', 'BLACK', 'pending', NULL, '2026-10-04 12:21:51', '2026-10-04 12:21:51'), (105, 42, 6, 1, 7, 3, 900.00, 700.00, 700.00, 1, 900.00, 200.00, 700.00, 'L', 'BLACK', 'pending', NULL, '2026-10-04 12:22:00', '2026-10-04 12:22:00'), (106, 43, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-05 18:13:30', '2026-10-05 18:13:30'), (107, 43, 6, 1, 4, 2, 1000.00, 0.00, 1000.00, 1, 1000.00, 1000.00, 1000.00, 'M', 'GREY', 'pending', NULL, '2026-10-05 18:13:30', '2026-10-05 18:13:30'), (108, 44, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-05 18:13:52', '2026-10-05 18:13:52'), (109, 44, 6, 1, 4, 2, 1000.00, 0.00, 1000.00, 1, 1000.00, 1000.00, 1000.00, 'M', 'GREY', 'pending', NULL, '2026-10-05 18:13:52', '2026-10-05 18:13:52'), (110, 45, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-05 18:14:18', '2026-10-05 18:14:18'), (111, 45, 6, 1, 4, 2, 1000.00, 0.00, 1000.00, 1, 1000.00, 1000.00, 1000.00, 'M', 'GREY', 'pending', NULL, '2026-10-05 18:14:18', '2026-10-05 18:14:18'), (112, 46, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-05 18:14:20', '2026-10-05 18:14:20'), (113, 46, 6, 1, 4, 2, 1000.00, 0.00, 1000.00, 1, 1000.00, 1000.00, 1000.00, 'M', 'GREY', 'pending', NULL, '2026-10-05 18:14:20', '2026-10-05 18:14:20'), (114, 47, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-05 18:14:32', '2026-10-05 18:14:32'), (115, 47, 6, 1, 4, 2, 1000.00, 0.00, 1000.00, 1, 1000.00, 1000.00, 1000.00, 'M', 'GREY', 'pending', NULL, '2026-10-05 18:14:32', '2026-10-05 18:14:32'), (116, 48, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-05 18:15:49', '2026-10-05 18:15:49'), (117, 48, 6, 1, 4, 2, 1000.00, 0.00, 1000.00, 1, 1000.00, 1000.00, 1000.00, 'M', 'GREY', 'pending', NULL, '2026-10-05 18:15:49', '2026-10-05 18:15:49'), (118, 49, 6, 1, 7, 3, 900.00, 700.00, 700.00, 1, 900.00, 200.00, 700.00, 'L', 'BLACK', 'pending', NULL, '2026-10-06 16:39:50', '2026-10-06 16:39:50'), (119, 49, 6, 1, 8, 3, 800.00, 700.00, 700.00, 1, 800.00, 100.00, 700.00, 'XL', 'BLACK', 'pending', NULL, '2026-10-06 16:39:50', '2026-10-06 16:39:50'), (120, 50, 6, 1, 39, 18, 850.00, 0.00, 850.00, 1, 850.00, 850.00, 850.00, '9-10Y', 'BLACK', 'pending', NULL, '2026-10-07 06:40:55', '2026-10-07 06:40:55'), (121, 51, 6, 1, 39, 18, 850.00, 0.00, 850.00, 2, 1700.00, 1700.00, 1700.00, '9-10Y', 'BLACK', 'pending', NULL, '2026-10-07 06:45:00', '2026-10-07 06:45:00'), (122, 52, 6, 1, 39, 18, 850.00, 0.00, 850.00, 2, 1700.00, 1700.00, 1700.00, '9-10Y', 'BLACK', 'pending', NULL, '2026-10-07 06:52:15', '2026-10-07 06:52:15'), (123, 52, 6, 1, 19, 7, 500.00, 430.00, 430.00, 1, 500.00, 70.00, 430.00, 'M', 'GREY', 'pending', NULL, '2026-10-07 06:52:15', '2026-10-07 06:52:15'), (124, 53, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-08 05:43:01', '2026-10-08 05:43:01'), (125, 54, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'delivered', 1, '2026-10-08 05:43:22', '2026-10-08 07:18:54'), (126, 55, 6, 1, 2, 1, 800.00, 600.00, 600.00, 1, 800.00, 200.00, 600.00, 'M', 'BLACK', 'pending', NULL, '2026-10-08 05:50:20', '2026-10-08 05:50:20'), (127, 57, 6, 1, 43, 18, 850.00, 0.00, 850.00, 1, 850.00, 850.00, 850.00, '9-10Y', 'BLACK', 'pending', NULL, '2026-10-08 06:10:30', '2026-10-08 06:10:30'), (128, 58, 6, 1, 19, 7, 500.00, 430.00, 430.00, 1, 500.00, 70.00, 430.00, 'M', 'GREY', 'delivered', 1, '2026-10-08 06:13:35', '2026-10-09 12:15:18'), (129, 58, 6, 1, 40, 18, 850.00, 595.00, 595.00, 1, 850.00, 255.00, 595.00, '3-4Y', 'BLACK', 'delivered', 1, '2026-10-08 06:13:35', '2026-10-09 12:15:18'), (130, 58, 6, 1, 41, 18, 850.00, 680.00, 680.00, 1, 850.00, 170.00, 680.00, '5-6Y', 'BLACK', 'delivered', 1, '2026-10-08 06:13:35', '2026-10-09 12:15:18'), (131, 58, 6, 1, 42, 18, 850.00, 765.00, 765.00, 1, 850.00, 85.00, 765.00, '7-8Y', 'BLACK', 'delivered', 1, '2026-10-08 06:13:35', '2026-10-09 12:15:18'), (132, 58, 6, 1, 43, 18, 850.00, 0.00, 850.00, 1, 850.00, 850.00, 850.00, '9-10Y', 'BLACK', 'delivered', 1, '2026-10-08 06:13:35', '2026-10-09 12:15:18'), (133, 59, 6, 1, 28, 10, 800.00, 500.00, 500.00, 1, 800.00, 300.00, 500.00, 'L', 'GREY', 'delivered', 1, '2026-10-08 07:25:46', '2026-10-09 10:05:35'), (134, 60, 6, 1, 43, 18, 850.00, 0.00, 850.00, 1, 850.00, 850.00, 850.00, '9-10Y', 'BLACK', 'delivered', 1, '2026-10-09 13:47:43', '2026-10-10 10:20:09'), (135, 61, 9, 1, 40, 18, 850.00, 595.00, 595.00, 1, 850.00, 255.00, 595.00, '3-4Y', 'BLACK', 'pending', NULL, '2026-10-10 19:33:19', '2026-10-10 19:33:19'), (136, 61, 9, 1, 42, 18, 850.00, 765.00, 765.00, 1, 850.00, 85.00, 765.00, '7-8Y', 'BLACK', 'pending', NULL, '2026-10-10 19:33:19', '2026-10-10 19:33:19'), (137, 62, 6, 1, 41, 18, 850.00, 680.00, 680.00, 1, 850.00, 170.00, 680.00, '5-6Y', 'BLACK', 'delivered', 1, '2026-10-12 16:10:56', '2026-10-12 16:19:01'), (138, 63, 9, 1, 42, 18, 850.00, 765.00, 765.00, 1, 850.00, 85.00, 765.00, '7-8Y', 'BLACK', 'pending', NULL, '2026-10-13 11:46:05', '2026-10-13 11:46:05'), (139, 63, 9, 1, 41, 18, 850.00, 680.00, 680.00, 1, 850.00, 170.00, 680.00, '5-6Y', 'BLACK', 'pending', NULL, '2026-10-13 11:46:06', '2026-10-13 11:46:06'), (140, 63, 9, 1, 43, 18, 850.00, 0.00, 850.00, 1, 850.00, 850.00, 850.00, '9-10Y', 'BLACK', 'pending', NULL, '2026-10-13 11:46:06', '2026-10-13 11:46:06'), (141, 64, 9, 1, 7, 3, 900.00, 2800.00, 700.00, 4, 3600.00, 2900.00, 2800.00, 'L', 'BLACK', 'shipped', 1, '2026-10-14 06:45:15', '2026-10-14 08:22:00'), (142, 65, 9, 1, 2, 1, 800.00, 1200.00, 600.00, 2, 1600.00, 1000.00, 1200.00, 'M', 'BLACK', 'delivered', 1, '2026-10-14 08:26:00', '2026-10-14 09:31:14'), (143, 66, 9, 1, 6, 2, 2000.00, 3600.00, 1800.00, 2, 4000.00, 2200.00, 3600.00, 'XL', 'GREY', 'shipped', 1, '2026-10-14 09:41:45', '2026-10-14 09:42:27'); -- -------------------------------------------------------- -- -- Table structure for table `order_transactions` -- CREATE TABLE `order_transactions` ( `id` bigint UNSIGNED NOT NULL, `transaction_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `order_id` bigint UNSIGNED NOT NULL, `return_request_id` bigint UNSIGNED DEFAULT NULL, `shipment_id` bigint UNSIGNED DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'order_payment, redelivery_charge, return_charge, cod_collection, refund, adjustment', `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'credit' COMMENT 'credit (inflow), debit (outflow)', `amount` decimal(10,2) NOT NULL DEFAULT '0.00', `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cod' COMMENT 'sslcommerz, bkash, rocket, nagad, cod, wallet, cash, manual', `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'pending, completed, failed, refunded', `gateway_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `order_transactions` -- INSERT INTO `order_transactions` (`id`, `transaction_number`, `order_id`, `return_request_id`, `shipment_id`, `type`, `direction`, `amount`, `payment_method`, `payment_status`, `gateway_reference`, `note`, `created_at`, `updated_at`) VALUES (1, 'TRX-261009-SZLL7K', 32, 1, 5, 'redelivery_charge', 'credit', 120.00, 'cod_addition', 'pending', 'SF9E60249F', 'Re-delivery fee for Attempt #2 (COD: BDT 1120)', '2026-10-09 10:53:12', '2026-10-09 10:53:12'), (2, 'TRX-261009-QYBCVN', 59, NULL, NULL, 'cod_collection', 'credit', 560.00, 'cash-on-delivery', 'completed', 'RT-61481485', 'COD payment collected upon successful delivery', '2026-10-09 14:16:27', '2026-10-09 14:16:27'), (3, 'TRX-261009-IAXJH1', 32, NULL, NULL, 'cod_collection', 'credit', 8527.00, 'cash-on-delivery', 'completed', 'RT-68288997', 'COD payment collected upon successful delivery', '2026-10-09 14:17:10', '2026-10-09 14:17:10'), (4, 'TRX-261009-PNIXSQ', 60, NULL, NULL, 'cod_collection', 'credit', 910.00, 'cash-on-delivery', 'completed', 'RT-54784683', 'COD payment collected upon successful delivery', '2026-10-09 14:17:29', '2026-10-09 14:17:29'), (5, 'TRX-261014-JLVGCV', 65, NULL, 23, 'cod_collection', 'credit', 1260.00, 'cash-on-delivery', 'completed', 'F1014TZK95S', 'COD payment collected upon successful delivery (Consignment #F1014TZK95S)', '2026-10-14 09:31:14', '2026-10-14 09:31:14'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint UNSIGNED NOT NULL, `seller_id` int NOT NULL DEFAULT '1', `product_type_id` int NOT NULL, `category_id` int NOT NULL, `subcategory_id` int DEFAULT NULL, `sub_subcategory_id` int DEFAULT NULL, `brand_id` int DEFAULT NULL, `product_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `unit_price` decimal(10,2) NOT NULL DEFAULT '0.00', `cost_price` decimal(10,2) DEFAULT '0.00', `discount_price` decimal(10,2) NOT NULL DEFAULT '0.00', `product_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `product_specification` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `product_compare` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `special_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `warranty` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `video_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `view_count` int NOT NULL DEFAULT '0', `thumbnail_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product_tags` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_exchangeable` tinyint(1) NOT NULL DEFAULT '0', `is_refundable` tinyint(1) NOT NULL DEFAULT '0', `contact_person` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `listed_on` enum('featured','new-arrivals','best-selling') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'featured', `request_status` enum('pending','approved') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `meta_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `updated_by` int NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `seller_id`, `product_type_id`, `category_id`, `subcategory_id`, `sub_subcategory_id`, `brand_id`, `product_code`, `name`, `slug`, `unit_price`, `cost_price`, `discount_price`, `product_details`, `product_specification`, `product_compare`, `short_description`, `special_note`, `warranty`, `video_link`, `view_count`, `thumbnail_path`, `product_unit`, `product_tags`, `is_exchangeable`, `is_refundable`, `contact_person`, `listed_on`, `request_status`, `status`, `meta_title`, `meta_description`, `meta_image`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted_at`) VALUES (1, 1, 1, 1, 1, 2, 4, 'MSC-100', 'Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants', 'msc-100-mens-casual-romper-short-sleeve-playsuit-work-jumpsuit-fashion-cargo-long-pants', 800.00, 480.00, 600.00, '

* Item:Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants
\r\n* Condition: 100% Brand New
\r\n* Color:

\r\n\r\n

Black   Dark Blue  

\r\n\r\n


\r\n* Size:Asian Asian M   Asian L   Asian XL   Asian 2XL   Asian 3XL  
\r\n* Package:1pc Outfits (without any accessories ）

\r\n\r\n

 

\r\n\r\n

 Please note:

\r\n\r\n

1.Please allow a little error due to manual measurement.

\r\n\r\n

2.The color maybe a little difference because of the light,screen reflection etc.

\r\n\r\n

3.If you are not sure what size to choose, you can tell us your height and weight, we will recommend the right size for you.

', '

* Item:Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants
\r\n* Condition: 100% Brand New
\r\n* Color:

\r\n\r\n

Black   Dark Blue  

\r\n\r\n


\r\n* Size:Asian Asian M   Asian L   Asian XL   Asian 2XL   Asian 3XL  
\r\n* Package:1pc Outfits (without any accessories ）

\r\n\r\n

 

\r\n\r\n

 Please note:

\r\n\r\n

1.Please allow a little error due to manual measurement.

\r\n\r\n

2.The color maybe a little difference because of the light,screen reflection etc.

\r\n\r\n

3.If you are not sure what size to choose, you can tell us your height and weight, we will recommend the right size for you.

', NULL, 'Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants', 'Your Item(s) will be shipped within 5-15 business days once payment received.', NULL, NULL, 0, 'assets/files/images/products/1741020567-product_1.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-03 10:49:28', '2026-10-11 08:04:35', 1, 1, NULL), (2, 1, 1, 1, 1, 2, 2, 'MSC-101', 'Mens Knitted Sweaters Warm Long Sleeve Pullover Winter Cardigan Sweatshirt', 'msc-101-mens-knitted-sweaters-warm-long-sleeve-pullover-winter-cardigan-sweatshirt', 1000.00, 600.00, 0.00, '

Seller assumes all responsibility for this listing.

\r\n\r\n

eBay item number:125141355312

\r\n\r\n

Last updated on Feb 25, 2025 00:32:32 PSTView all revisionsView all revisions

\r\n\r\n

Item specifics

\r\n\r\n
\r\n
\r\n

Condition

\r\n
\r\n
\r\n

New with tags: This item is brand new and has never been worn. It still has the original tags and/or ... 

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Pattern

\r\n
\r\n
\r\n

Camouflage

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Knit Style

\r\n
\r\n
\r\n

Medium

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Sleeve Length

\r\n
\r\n
\r\n

Long Sleeve

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Occasion

\r\n
\r\n
\r\n

Casual

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Garment Care

\r\n
\r\n
\r\n

Machine Washable

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size

\r\n
\r\n
\r\n

M

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Material

\r\n
\r\n
\r\n

Wool blend

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fabric Type

\r\n
\r\n
\r\n

Jersey

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Brand

\r\n
\r\n
\r\n

Unbranded

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fit

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size Type

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Department

\r\n
\r\n
\r\n

Men

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Type

\r\n
\r\n
\r\n

Sweater

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Style

\r\n
\r\n
\r\n

Pullover

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Theme

\r\n
\r\n
\r\n

Sports

\r\n
\r\n
', '

Seller assumes all responsibility for this listing.

\r\n\r\n

eBay item number:125141355312

\r\n\r\n

Last updated on Feb 25, 2025 00:32:32 PSTView all revisionsView all revisions

\r\n\r\n

Item specifics

\r\n\r\n
\r\n
\r\n

Condition

\r\n
\r\n
\r\n

New with tags: This item is brand new and has never been worn. It still has the original tags and/or ... 

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Pattern

\r\n
\r\n
\r\n

Camouflage

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Knit Style

\r\n
\r\n
\r\n

Medium

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Sleeve Length

\r\n
\r\n
\r\n

Long Sleeve

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Occasion

\r\n
\r\n
\r\n

Casual

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Garment Care

\r\n
\r\n
\r\n

Machine Washable

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size

\r\n
\r\n
\r\n

M

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Material

\r\n
\r\n
\r\n

Wool blend

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fabric Type

\r\n
\r\n
\r\n

Jersey

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Brand

\r\n
\r\n
\r\n

Unbranded

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fit

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size Type

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Department

\r\n
\r\n
\r\n

Men

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Type

\r\n
\r\n
\r\n

Sweater

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Style

\r\n
\r\n
\r\n

Pullover

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Theme

\r\n
\r\n
\r\n

Sports

\r\n
\r\n
', NULL, 'Mens Cardigan Sweater Cable Knit Button Cotton Sweater Winter Warm Pockets Tops\r\nNew (Other)', 'Please make sure your checked our size instruction first!!! \r\n\r\nNormally it will be made in 3 days and arrive in 10-20 days.\r\n\r\nif there is any confuse, please feel free to contact us anytime.', NULL, NULL, 0, 'assets/files/images/products/1741021322-product_2_1.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-03 11:02:02', '2026-10-11 08:04:35', 1, 1, NULL), (3, 1, 1, 1, 1, 2, 1, 'MSC-102', 'Men Cardigan Sweater Autumn Winter Warm V-Neck Button Sweater Knitted Pullover', 'msc-102-men-cardigan-sweater-autumn-winter-warm-v-neck-button-sweater-knitted-pullover', 900.00, 540.00, 700.00, '

tem specifics

\r\n\r\n
\r\n
\r\n

Condition

\r\n
\r\n
\r\n

New with tags: This item is brand new and has never been worn. It still has the original tags and/or original packaging. See all condition definitionsopens in a new window or tab

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Accents

\r\n
\r\n
\r\n

Button

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Brand

\r\n
\r\n
\r\n

Unbranded

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Country/Region of Manufacture

\r\n
\r\n
\r\n

China

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Department

\r\n
\r\n
\r\n

Men

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Features

\r\n
\r\n
\r\n

Breathable, Lightweight

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fit

\r\n
\r\n
\r\n

Classic

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Material

\r\n
\r\n
\r\n

Acrylic, Polyester

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

MPN

\r\n
\r\n
\r\n

Does Not Apply

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Neckline

\r\n
\r\n
\r\n

V-Neck

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Pattern

\r\n
\r\n
\r\n

Solid

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Performance/Activity

\r\n
\r\n
\r\n

Walking

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size Type

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Style

\r\n
\r\n
\r\n

Cardigan

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Theme

\r\n
\r\n
\r\n

Classic

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Type

\r\n
\r\n
\r\n

Sweater

\r\n
\r\n
', '

tem specifics

\r\n\r\n
\r\n
\r\n

Condition

\r\n
\r\n
\r\n

New with tags: This item is brand new and has never been worn. It still has the original tags and/or original packaging. See all condition definitionsopens in a new window or tab

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Accents

\r\n
\r\n
\r\n

Button

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Brand

\r\n
\r\n
\r\n

Unbranded

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Country/Region of Manufacture

\r\n
\r\n
\r\n

China

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Department

\r\n
\r\n
\r\n

Men

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Features

\r\n
\r\n
\r\n

Breathable, Lightweight

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fit

\r\n
\r\n
\r\n

Classic

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Material

\r\n
\r\n
\r\n

Acrylic, Polyester

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

MPN

\r\n
\r\n
\r\n

Does Not Apply

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Neckline

\r\n
\r\n
\r\n

V-Neck

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Pattern

\r\n
\r\n
\r\n

Solid

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Performance/Activity

\r\n
\r\n
\r\n

Walking

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size Type

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Style

\r\n
\r\n
\r\n

Cardigan

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Theme

\r\n
\r\n
\r\n

Classic

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Type

\r\n
\r\n
\r\n

Sweater

\r\n
\r\n
', NULL, 'Cardigan Men Sweater Autumn Winter Warm V-Neck Button Sweater Knitted Pullover', 'Men Cardigan Sweater Autumn Winter Warm V-Neck Button Sweater Knitted Pullover', NULL, NULL, 0, 'assets/files/images/products/1741021723-product_3_3.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-03 11:08:43', '2026-10-11 08:04:35', 1, 1, NULL), (4, 1, 1, 2, 3, 5, 1, 'WJP-100', 'Colourful Oliver Bonas Pink Star Knitted Bomber Jacket/Cardigan Size 16 BNWT', 'wjp-100-colourful-oliver-bonas-pink-star-knitted-bomber-jacketcardigan-size-16-bnwt', 500.00, 0.00, 450.00, '

Oliver Bonas Pink Geometric Star Knitted Bomber Jacket Size 16 BNWT.

\r\n\r\n

Gorgeous cardigan/bomber jacket.

\r\n\r\n

Brand New with tags.

\r\n\r\n

 

\r\n\r\n

Dispatched with Royal Mail Tracked 48.

', '

Oliver Bonas Pink Geometric Star Knitted Bomber Jacket Size 16 BNWT.

\r\n\r\n

Gorgeous cardigan/bomber jacket.

\r\n\r\n

Brand New with tags.

\r\n\r\n

 

\r\n\r\n

Dispatched with Royal Mail Tracked 48.

', NULL, 'Colourful Oliver Bonas Pink Star Knitted Bomber Jacket/Cardigan Size 16 BNWT', 'Colourful Oliver Bonas Pink Star Knitted Bomber Jacket/Cardigan Size 16 BNWT', NULL, NULL, 0, 'assets/files/images/products/1741087327-w_p_1_1.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 05:22:08', '2025-07-23 10:50:05', 1, 1, NULL), (5, 1, 1, 2, 3, 5, 1, 'WJP-101', 'Mint Velvet Grey Longline Cardigan UK 10 EU 38 RRP £89 LN142 AA 01', 'wjp-101-mint-velvet-grey-longline-cardigan-uk-10-eu-38-rrp-ps89-ln142-aa-01', 800.00, 480.00, 0.00, '
Mint Velvet Grey Longline Cardigan 
\r\n\r\n
UK 10 EU 38 
\r\n\r\n
RRP £89
\r\n\r\n
 
\r\n\r\n
Spun with a touch of cashmere for softness, this grey cardigan is knitted in a relaxed silhouette with a waterfall front. Mint Velvet have added metallic stripes at the sleeves and back for a sporty look – just slip yours over jeans and joggers alike.
\r\n\r\n
 
\r\n\r\n
Hand wash only.
\r\n\r\n
 
\r\n\r\n
 
\r\n\r\n
49% Cotton, 24% Viscose, 21% Nylon, 6% Cashmere.
\r\n\r\n
 
\r\n\r\n
pit to pit 18 inch
\r\n\r\n
length 25-35 inch
', '
Mint Velvet Grey Longline Cardigan 
\r\n\r\n
UK 10 EU 38 
\r\n\r\n
RRP £89
\r\n\r\n
 
\r\n\r\n
Spun with a touch of cashmere for softness, this grey cardigan is knitted in a relaxed silhouette with a waterfall front. Mint Velvet have added metallic stripes at the sleeves and back for a sporty look – just slip yours over jeans and joggers alike.
\r\n\r\n
 
\r\n\r\n
Hand wash only.
\r\n\r\n
 
\r\n\r\n
 
\r\n\r\n
49% Cotton, 24% Viscose, 21% Nylon, 6% Cashmere.
\r\n\r\n
 
\r\n\r\n
pit to pit 18 inch
\r\n\r\n
length 25-35 inch
', NULL, 'Mint Velvet Grey Longline Cardigan UK 10 EU 38 RRP £89 LN142 AA 01', 'Mint Velvet Grey Longline Cardigan UK 10 EU 38 RRP £89 LN142 AA 01', NULL, NULL, 0, 'assets/files/images/products/1741088362-w_p_2_1.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 05:39:22', '2026-10-11 08:04:35', 1, 1, NULL), (6, 1, 2, 2, 4, 6, 1, 'WC-100', 'Ladies Linen Mix Floral Midi Knee Length Dress RRP', 'wc-100-ladies-linen-mix-floral-midi-knee-length-dress-rrp', 900.00, 0.00, 700.00, '

Item specifics

\r\n\r\n
\r\n
\r\n

Condition

\r\n
\r\n
\r\n

New without tags: This item is brand new and has never been worn, but doesn’t have tags and/or is ... 

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Pattern

\r\n
\r\n
\r\n

Floral

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Sleeve Length

\r\n
\r\n
\r\n

Short Sleeve

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Neckline

\r\n
\r\n
\r\n

V-Neck

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Closure

\r\n
\r\n
\r\n

Pullover

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Occasion

\r\n
\r\n
\r\n

Casual

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Material

\r\n
\r\n
\r\n

Linen

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fabric Type

\r\n
\r\n
\r\n

Jersey

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Colour

\r\n
\r\n
\r\n

White

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Dress Length

\r\n
\r\n
\r\n

Knee Length

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Vintage

\r\n
\r\n
\r\n

No

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Brand

\r\n
\r\n
\r\n

ex High Street

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size Type

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Department

\r\n
\r\n
\r\n

Women

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Style

\r\n
\r\n
\r\n

Knee Length Dress

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Season

\r\n
\r\n
\r\n

Summer

\r\n
\r\n
', '

Item specifics

\r\n\r\n
\r\n
\r\n

Condition

\r\n
\r\n
\r\n

New without tags: This item is brand new and has never been worn, but doesn’t have tags and/or is ... 

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Pattern

\r\n
\r\n
\r\n

Floral

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Sleeve Length

\r\n
\r\n
\r\n

Short Sleeve

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Neckline

\r\n
\r\n
\r\n

V-Neck

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Closure

\r\n
\r\n
\r\n

Pullover

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Occasion

\r\n
\r\n
\r\n

Casual

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Material

\r\n
\r\n
\r\n

Linen

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Fabric Type

\r\n
\r\n
\r\n

Jersey

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Colour

\r\n
\r\n
\r\n

White

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Dress Length

\r\n
\r\n
\r\n

Knee Length

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Vintage

\r\n
\r\n
\r\n

No

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Brand

\r\n
\r\n
\r\n

ex High Street

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Size Type

\r\n
\r\n
\r\n

Regular

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Department

\r\n
\r\n
\r\n

Women

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Style

\r\n
\r\n
\r\n

Knee Length Dress

\r\n
\r\n
\r\n\r\n
\r\n
\r\n

Season

\r\n
\r\n
\r\n

Summer

\r\n
\r\n
', NULL, 'Ladies Linen Mix Floral Midi Knee Length Dress RRP', 'Ladies Linen Mix Floral Midi Knee Length Dress RRP', NULL, NULL, 0, 'assets/files/images/products/1741089321-w_p_3_1.png', '1', 'ONE PIECE', 0, 0, NULL, 'featured', 'pending', 'active', NULL, NULL, NULL, '2025-03-04 05:55:21', '2025-07-23 11:08:23', 1, 1, NULL), (7, 1, 1, 2, 4, 6, 3, 'WJP-102', 'Womens V Neck Boho Floral Mini Dress Long Sleeve Holiday Beach Swing Sundress', 'wjp-102-womens-v-neck-boho-floral-mini-dress-long-sleeve-holiday-beach-swing-sundress', 500.00, 300.00, 430.00, '

Womens V Neck Boho Floral Mini Dress Long Sleeve Holiday Beach Swing Sundress

', '

Womens V Neck Boho Floral Mini Dress Long Sleeve Holiday Beach Swing Sundress

', NULL, 'Womens V Neck Boho Floral Mini Dress Long Sleeve Holiday Beach Swing Sundress', 'Womens V Neck Boho Floral Mini Dress Long Sleeve Holiday Beach Swing Sundress', NULL, NULL, 0, 'assets/files/images/products/1741100575-product_4_2.png', NULL, 'JUMPSUITS,ONE PIECE,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 09:02:55', '2026-10-11 08:04:35', 1, 1, NULL), (8, 1, 2, 2, 4, 6, 2, 'WJP-105', 'Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', 'wjp-105-women-floral-boho-midi-dress-ladies-summer-holiday-beach-swing-kaftan-sundress', 900.00, 540.00, 800.00, '

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

', '

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

', NULL, 'Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', 'Women Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', NULL, NULL, 0, 'assets/files/images/products/1741101389-w_p_4_1.png', '1', 'JUMPSUITS,ONE PIECE,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 09:16:29', '2026-10-11 08:04:35', 1, 1, NULL), (9, 1, 2, 2, 4, 6, 4, 'WJP-109', 'Womens Floral Boho Midi Dress Ladies Summer heroin Holiday Beach Swing Kaftan Sundress', 'wjp-109-womens-floral-boho-midi-dress-ladies-summer-holiday-beach-swing-kaftan-sundress', 900.00, 0.00, 700.00, '

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

', '

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

', NULL, 'Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', 'Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', NULL, NULL, 0, 'assets/files/images/products/1741101564-w_p_1_1.png', '1', 'JUMPSUITS,ONE PIECE,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 09:19:24', '2025-03-04 09:19:24', 1, 1, NULL), (10, 1, 2, 2, 4, 6, 4, 'WJP-110', 'Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', 'wjp-110-womens-floral-boho-midi-dress-ladies-summer-holiday-beach-swing-kaftan-sundress', 800.00, 480.00, 500.00, '

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

', '

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

\r\n\r\n

Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress

', NULL, 'Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', 'Womens Floral Boho Midi Dress Ladies Summer Holiday Beach Swing Kaftan Sundress', NULL, NULL, 0, 'assets/files/images/products/1741101853-w_p_5_1.png', NULL, 'JUMPSUITS,ONE PIECE,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 09:24:14', '2026-10-11 08:04:35', 1, 1, NULL), (11, 2, 2, 2, 4, 6, 1, 'WJP-206', 'Summer V Neck Holiday Mini Dresses UK Womens Short Sleeve Dress Ladies Plus Size', 'wjp-206-summer-v-neck-holiday-mini-dresses-uk-womens-short-sleeve-dress-ladies-plus-size', 5000.00, 3000.00, 4800.00, '

Summer V Neck Holiday Mini Dresses UK Womens Short Sleeve Dress Ladies Plus Size

', '', NULL, 'Summer V Neck Holiday Mini Dresses UK Womens Short Sleeve Dress Ladies Plus Size', 'Summer V Neck Holiday Mini Dresses UK Womens Short Sleeve Dress Ladies Plus Size', NULL, NULL, 0, 'assets/files/images/products/1741107161-w_p_6_1.png', NULL, 'JUMPSUITS,ONE PIECE,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-04 10:52:41', '2026-10-11 08:04:35', 2, 2, NULL), (12, 1, 2, 1, 2, 3, 2, 'MSC-108', 'Volodymyr Zelenskyy Army Military Coat of Arms Long Sleeve T-Shirt for Ukraine', 'msc-108-volodymyr-zelenskyy-army-military-coat-of-arms-long-sleeve-t-shirt-for-ukraine', 4000.00, 2400.00, 3500.00, '

Volodymyr Zelenskyy Army Military Coat of Arms Long Sleeve T-Shirt for Ukraine

', '

Volodymyr Zelenskyy Army Military Coat of Arms Long Sleeve T-Shirt for Ukraine

', NULL, 'Volodymyr Zelenskyy Army Military Coat of Arms Long Sleeve T-Shirt for Ukraine', 'Volodymyr Zelenskyy Army Military Coat of Arms Long Sleeve T-Shirt for Ukraine', NULL, NULL, 0, 'assets/files/images/products/1741261314-mp_1_1.png', '1', 'ONE PIECE', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-06 05:41:55', '2026-10-11 08:04:35', 1, 1, NULL), (13, 2, 3, 2, 4, 6, 4, '326857', 'Mini Dresses UK Womens Short Sleeve Dress Ladies Plus Size', '326857-ivory-barrett', 0.00, 547.20, 0.00, '

qojuqyt@mailinator.com

', '

qojuqyt@mailinator.com

', NULL, 'Non voluptatem Rati', 'Sequi eiusmod iure l', 'Debitis et non omnis', NULL, 0, 'assets/files/images/products/1753289776-1741019819-product_1.png', NULL, 'JUMPSUITS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-07-23 10:56:17', '2026-10-11 08:04:35', 2, 2, NULL), (15, 1, 1, 1, 1, 2, 4, 'MSC-109', 'Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Short Pants', 'msc-100-mens-casual-romper-short-sleeve-playsuit-work-jumpsuit-fashion-cargo-short-pants', 800.00, 0.00, 600.00, '

* Item:Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants
\r\n* Condition: 100% Brand New
\r\n* Color:

\r\n\r\n

Black   Dark Blue  

\r\n\r\n


\r\n* Size:Asian Asian M   Asian L   Asian XL   Asian 2XL   Asian 3XL  
\r\n* Package:1pc Outfits (without any accessories ）

\r\n\r\n

 

\r\n\r\n

 Please note:

\r\n\r\n

1.Please allow a little error due to manual measurement.

\r\n\r\n

2.The color maybe a little difference because of the light,screen reflection etc.

\r\n\r\n

3.If you are not sure what size to choose, you can tell us your height and weight, we will recommend the right size for you.

', '

* Item:Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants
\r\n* Condition: 100% Brand New
\r\n* Color:

\r\n\r\n

Black   Dark Blue  

\r\n\r\n


\r\n* Size:Asian Asian M   Asian L   Asian XL   Asian 2XL   Asian 3XL  
\r\n* Package:1pc Outfits (without any accessories ）

\r\n\r\n

 

\r\n\r\n

 Please note:

\r\n\r\n

1.Please allow a little error due to manual measurement.

\r\n\r\n

2.The color maybe a little difference because of the light,screen reflection etc.

\r\n\r\n

3.If you are not sure what size to choose, you can tell us your height and weight, we will recommend the right size for you.

', NULL, 'Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants', 'Your Item(s) will be shipped within 5-15 business days once payment received.', NULL, NULL, 0, 'assets/files/images/products/1741020567-product_1.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-03 10:49:28', '2025-03-03 10:57:09', 1, 1, NULL), (17, 1, 1, 1, 6, 8, 4, 'MSC-110', 'Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Shorts Pants', 'msc-100-mens-casual-romper-short-sleeve-playsuit-work-jumpsuit-fashion-cargo-shorts-pants', 800.00, 0.00, 600.00, '

* Item:Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants
\r\n* Condition: 100% Brand New
\r\n* Color:

\r\n\r\n

Black   Dark Blue  

\r\n\r\n


\r\n* Size:Asian Asian M   Asian L   Asian XL   Asian 2XL   Asian 3XL  
\r\n* Package:1pc Outfits (without any accessories ）

\r\n\r\n

 

\r\n\r\n

 Please note:

\r\n\r\n

1.Please allow a little error due to manual measurement.

\r\n\r\n

2.The color maybe a little difference because of the light,screen reflection etc.

\r\n\r\n

3.If you are not sure what size to choose, you can tell us your height and weight, we will recommend the right size for you.

', '

* Item:Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants
\r\n* Condition: 100% Brand New
\r\n* Color:

\r\n\r\n

Black   Dark Blue  

\r\n\r\n


\r\n* Size:Asian Asian M   Asian L   Asian XL   Asian 2XL   Asian 3XL  
\r\n* Package:1pc Outfits (without any accessories ）

\r\n\r\n

 

\r\n\r\n

 Please note:

\r\n\r\n

1.Please allow a little error due to manual measurement.

\r\n\r\n

2.The color maybe a little difference because of the light,screen reflection etc.

\r\n\r\n

3.If you are not sure what size to choose, you can tell us your height and weight, we will recommend the right size for you.

', NULL, 'Mens Casual Romper Short Sleeve Playsuit Work Jumpsuit Fashion Cargo Long Pants', 'Your Item(s) will be shipped within 5-15 business days once payment received.', NULL, NULL, 0, 'assets/files/images/products/1741020567-product_1.png', '1', 'JUMPSUITS,ROMPERS', 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2025-03-03 10:49:28', '2025-03-03 10:57:09', 1, 1, NULL); INSERT INTO `products` (`id`, `seller_id`, `product_type_id`, `category_id`, `subcategory_id`, `sub_subcategory_id`, `brand_id`, `product_code`, `name`, `slug`, `unit_price`, `cost_price`, `discount_price`, `product_details`, `product_specification`, `product_compare`, `short_description`, `special_note`, `warranty`, `video_link`, `view_count`, `thumbnail_path`, `product_unit`, `product_tags`, `is_exchangeable`, `is_refundable`, `contact_person`, `listed_on`, `request_status`, `status`, `meta_title`, `meta_description`, `meta_image`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted_at`) VALUES (18, 1, 8, 4, 1, 1, 5, 'KPS-001', 'Kids Premium Sweatshirt Set', 'kps-001-kids-premium-sweatshirt-set', 850.00, 510.00, 595.00, '

Product Title: Kids Premium Graphic Full-Zip Hoodie & Joggers 2-Piece Sweatshirt Set


Key Features:


Complete 2-Piece Set: Includes one hooded full-zip sweatshirt and matching jogger pants.


Athletic Joggers: Elasticized waist with tapered legs and secure ankle ribs to prevent dragging and accommodate sneakers.


All-Day Comfort: Soft, breathable cotton-rich fleece interior that keeps kids warm without overheating.


Specifications:


Fit: Regular / Relaxed athletic fit


Sleeve / Pant Length: Full length


Care Instructions: Machine wash cold, inside out with like colors; tumble dry low or hang dry to preserve print quality.


Size Chart (Inches):

', '


', NULL, 'Upgrade your child’s everyday wardrobe with this premium 2-piece fleece tracksuit. Engineered for comfort, durability, and bold streetwear flair, this matching set combines an easy-wearing full-zip hoodie with relaxed, tapered joggers built for active days.', NULL, NULL, NULL, 0, 'assets/files/images/products/1791355001-Kids-sweatshirt-0.jpeg', '1', NULL, 1, 1, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2026-10-07 06:36:41', '2026-10-15 10:16:34', 1, 1, NULL), (19, 1, 9, 4, 1, 3, 5, 'KS-1011', 'Kids Sweatshirt', 'ks-1011-kids-sweatshirt', 550.00, 250.00, 0.00, '

Product Overview

Designed for everyday ease and warmth, this casual crewneck sweatshirt features an all-over unicorn print set against a deep charcoal base. Crafted with soft inner fleece, a ribbed collar, and snug cuffs, it provides all-day comfort whether layered for cooler days or worn casually for outdoor outings.

Product Details

Size Chart (Inches)

Age Group

Chest (Pit to Pit)

Body Length

Sleeve Length

4 – 5 Years

14.5\"

18.0\"

16.0\"

6 – 7 Years

15.5\"

19.5\"

17.5\"

8 – 9 Years

16.5\"

21.0\"

19.0\"

10 – 12 Years

17.5\"

22.5\"

20.5\"


', '

Product Overview

Designed for everyday ease and warmth, this casual crewneck sweatshirt features an all-over unicorn print set against a deep charcoal base. Crafted with soft inner fleece, a ribbed collar, and snug cuffs, it provides all-day comfort whether layered for cooler days or worn casually for outdoor outings.

Product Details

Size Chart (Inches)

Age Group

Chest (Pit to Pit)

Body Length

Sleeve Length

4 – 5 Years

14.5\"

18.0\"

16.0\"

6 – 7 Years

15.5\"

19.5\"

17.5\"

8 – 9 Years

16.5\"

21.0\"

19.0\"

10 – 12 Years

17.5\"

22.5\"

20.5\"


', NULL, 'dd a touch of magic to everyday comfort! This cozy charcoal crewneck sweatshirt features an all-over whimsical unicorn print, ribbed cuffs, and an easy, relaxed fit perfect for school days, playdates, or weekend lounging.', NULL, NULL, NULL, 0, 'assets/files/images/products/1792061284-Tamara Unicorn Sweatshirt 1.png', '1', NULL, 0, 1, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2026-10-15 10:31:38', '2026-10-15 10:53:04', 1, 1, NULL), (20, 1, 1, 4, 1, 4, 5, 'GT-001', 'Girls Top', 'gt-001-girls-top', 650.00, 250.00, 0.00, '


', '


', NULL, NULL, NULL, NULL, NULL, 0, 'assets/files/images/products/1792171677-Little Styles, Big Dreams_2.png', NULL, NULL, 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2026-10-16 17:27:58', '2026-10-16 17:27:58', 1, 1, NULL), (21, 1, 1, 3, 2, NULL, NULL, 'TW-001', 'Gram Bangla Terracotta Wall Art (2x3ft approx.)', 'tw-001-gram-bangla-terracotta-wall-art-2x3ft-approx', 10000.00, 5000.00, 0.00, '

Product Name: Baul Terracotta Wall Mural

Material: Terracotta (Baked Clay)

Color: Brick Red

Utility: Heritage Wall Decor & Spiritual Art Installation

Celebrate the timeless beauty of rural Bengal with this handcrafted Gram Bangla Terracotta Wall Mural. Inspired by the peaceful charm of traditional village life, this artistic mural beautifully captures the essence of Bengal’s countryside through detailed terracotta craftsmanship.

The mural portrays a classic rural scene featuring village landscapes, a bullock cart, trees, and everyday village life elements that reflect the cultural soul of Gram Bangla. Crafted using multiple handcrafted terracotta tiles, the mural forms one large storytelling wall installation filled with warmth and heritage character.

Skilled artisans from West Bengal carefully shape and carve every tile using traditional baked clay techniques passed down through generations. The natural terracotta texture and earthy finish give the mural a timeless rustic appeal that blends beautifully with both modern and traditional interiors.

The large-format of the murals creates a striking focal point for living rooms, entrances, heritage homes, boutique hotels, resorts, cafés, galleries, and cultural spaces.

More than decorative wall art, this mural reflects the nostalgia, simplicity, and artistic richness of Bengal village life. Slight natural variations in texture and finish make every handcrafted piece unique and authentic.

Key Features:

', '

GI Tag Details (Bengal Terracotta)

SpecificationDetails
Period of OriginAncient Bengal Civilization
Country of OriginIndia
Geographical RegionBankura District, West Bengal
GI Product of India66
GI Status Awarded2018
GI Application No.66
Craft TraditionBishnupur Terracotta
Handcrafted ByTraditional Terracotta Artisans of Bankura
', NULL, 'Celebrate the timeless beauty of rural Bengal with this handcrafted Gram Bangla Terracotta Wall Mural. Inspired by the peaceful charm of traditional village life, this artistic mural beautifully captures the essence of Bengal’s countryside through detailed terracotta craftsmanship.', NULL, NULL, NULL, 0, 'assets/files/images/products/1792173476-terracota.jpeg', NULL, NULL, 0, 0, NULL, 'featured', 'approved', 'active', NULL, NULL, NULL, '2026-10-16 17:57:56', '2026-10-16 19:13:15', 1, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_images` -- CREATE TABLE `product_images` ( `id` bigint UNSIGNED NOT NULL, `product_id` int NOT NULL, `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_images` -- INSERT INTO `product_images` (`id`, `product_id`, `image_path`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'assets/files/images/products/1741020568-product_1.png', '2025-03-03 10:49:28', '2025-03-03 10:49:28', NULL), (2, 1, 'assets/files/images/products/1741020568-product_2.png', '2025-03-03 10:49:28', '2025-03-03 10:49:28', NULL), (3, 1, 'assets/files/images/products/1741020568-product_3.png', '2025-03-03 10:49:28', '2025-03-03 10:49:28', NULL), (4, 2, 'assets/files/images/products/1741021322-product_2_1.png', '2025-03-03 11:02:03', '2025-03-03 11:02:03', NULL), (5, 2, 'assets/files/images/products/1741021323-product_2_2.png', '2025-03-03 11:02:03', '2025-03-03 11:02:03', NULL), (6, 2, 'assets/files/images/products/1741021323-product_2_3.png', '2025-03-03 11:02:03', '2025-03-03 11:02:03', NULL), (7, 3, 'assets/files/images/products/1741021723-product_3_1.png', '2025-03-03 11:08:43', '2025-03-03 11:08:43', NULL), (8, 3, 'assets/files/images/products/1741021723-product_3_2.png', '2025-03-03 11:08:43', '2025-03-03 11:08:43', NULL), (9, 3, 'assets/files/images/products/1741021723-product_3_3.png', '2025-03-03 11:08:43', '2025-03-03 11:08:43', NULL), (10, 4, 'assets/files/images/products/1741087328-w_p_1_1.png', '2025-03-04 05:22:08', '2025-03-04 05:22:08', NULL), (11, 4, 'assets/files/images/products/1741087328-w_p_1_2.png', '2025-03-04 05:22:08', '2025-03-04 05:22:08', NULL), (12, 4, 'assets/files/images/products/1741087328-w_p_1_3.png', '2025-03-04 05:22:09', '2025-03-04 05:22:09', NULL), (13, 5, 'assets/files/images/products/1741088362-w_p_2_1.png', '2025-03-04 05:39:22', '2025-03-04 05:39:22', NULL), (14, 5, 'assets/files/images/products/1741088362-w_p_2_2.png', '2025-03-04 05:39:22', '2025-03-04 05:39:22', NULL), (15, 5, 'assets/files/images/products/1741088362-w_p_2_3.png', '2025-03-04 05:39:23', '2025-03-04 05:39:23', NULL), (16, 6, 'assets/files/images/products/1741089321-w_p_3_1.png', '2025-03-04 05:55:21', '2025-03-04 05:55:21', NULL), (17, 6, 'assets/files/images/products/1741089321-w_p_3_2.png', '2025-03-04 05:55:21', '2025-03-04 05:55:21', NULL), (18, 6, 'assets/files/images/products/1741089321-w_p_3_3.png', '2025-03-04 05:55:22', '2025-03-04 05:55:22', NULL), (19, 6, 'assets/files/images/products/1741089322-w_p_3_4.png', '2025-03-04 05:55:22', '2025-03-04 05:55:22', NULL), (20, 6, 'assets/files/images/products/1741089322-w_p_3_5.png', '2025-03-04 05:55:22', '2025-03-04 05:55:22', NULL), (21, 7, 'assets/files/images/products/1741100575-product_4_1.png', '2025-03-04 09:02:56', '2025-03-04 09:02:56', NULL), (22, 7, 'assets/files/images/products/1741100576-product_4_4.png', '2025-03-04 09:02:56', '2025-03-04 09:02:56', NULL), (23, 7, 'assets/files/images/products/1741100576-product_4_4.png', '2025-03-04 09:02:56', '2025-03-04 09:02:56', NULL), (24, 7, 'assets/files/images/products/1741100576-product_4_5.png', '2025-03-04 09:02:56', '2025-03-04 09:02:56', NULL), (25, 7, 'assets/files/images/products/1741100576-s-l1600 (16).png', '2025-03-04 09:02:56', '2025-03-04 09:02:56', NULL), (26, 8, 'assets/files/images/products/1741101389-w_p_4_2.png', '2025-03-04 09:16:29', '2025-03-04 09:16:29', NULL), (27, 8, 'assets/files/images/products/1741101389-w_p_4_3.png', '2025-03-04 09:16:30', '2025-03-04 09:16:30', NULL), (28, 8, 'assets/files/images/products/1741101390-w_p_4_1.png', '2025-03-04 09:16:30', '2025-03-04 09:16:30', NULL), (29, 9, 'assets/files/images/products/1741101564-w_p_1_1.png', '2025-03-04 09:19:25', '2025-03-04 09:19:25', NULL), (30, 9, 'assets/files/images/products/1741101565-w_p_1_2.png', '2025-03-04 09:19:25', '2025-03-04 09:19:25', NULL), (31, 9, 'assets/files/images/products/1741101565-w_p_1_3.png', '2025-03-04 09:19:25', '2025-03-04 09:19:25', NULL), (32, 10, 'assets/files/images/products/1741101854-w_p_5_2.png', '2025-03-04 09:24:14', '2025-03-04 09:24:14', NULL), (33, 10, 'assets/files/images/products/1741101854-w_p_5_1.png', '2025-03-04 09:24:14', '2025-03-04 09:24:14', NULL), (34, 10, 'assets/files/images/products/1741101854-w_p_5_3.png', '2025-03-04 09:24:14', '2025-03-04 09:24:14', NULL), (35, 11, 'assets/files/images/products/1741107161-w_p_6_1.png', '2025-03-04 10:52:41', '2025-03-04 10:52:41', NULL), (36, 11, 'assets/files/images/products/1741107161-w_p_6_2.png', '2025-03-04 10:52:42', '2025-03-04 10:52:42', NULL), (38, 12, 'assets/files/images/products/1741261315-mp_1_1.png', '2025-03-06 05:41:55', '2025-03-06 05:41:55', NULL), (39, 12, 'assets/files/images/products/1741261315-mp_1_2.png', '2025-03-06 05:41:55', '2025-03-06 05:41:55', NULL), (40, 13, 'assets/files/images/products/1753289777-1741021723-product_3_2.png', '2025-07-23 10:56:17', '2025-07-23 10:56:17', NULL), (41, 13, 'assets/files/images/products/1753289777-1741087328-w_p_1_1.png', '2025-07-23 10:56:17', '2025-07-23 10:56:17', NULL), (42, 13, 'assets/files/images/products/1753289777-1741021723-product_3_2.png', '2025-07-23 10:56:18', '2025-07-23 10:56:18', NULL), (43, 18, 'assets/files/images/products/1791355001-Kids-sweatshirt-1.jpeg', '2026-10-07 06:36:41', '2026-10-07 06:36:41', NULL), (44, 18, 'assets/files/images/products/1791355001-Kids-sweatshirt-2.jpeg', '2026-10-07 06:36:41', '2026-10-07 06:36:41', NULL), (45, 18, 'assets/files/images/products/1791355001-Kids-sweatshirt-3.jpeg', '2026-10-07 06:36:41', '2026-10-07 06:36:41', NULL), (46, 19, 'assets/files/images/products/1792061284-Tamara Unicorn Sweatshirt Editorial.png', '2026-10-15 10:31:38', '2026-10-15 10:48:05', NULL), (47, 19, 'assets/files/images/products/1792061285-Kids Sweatshirt.jpeg', '2026-10-15 10:48:05', '2026-10-15 10:48:05', NULL), (48, 20, 'assets/files/images/products/1792171678-Little Styles, Big Dreams.png', '2026-10-16 17:27:59', '2026-10-16 17:27:59', NULL), (49, 20, 'assets/files/images/products/1792171679-Tamara Unicorn Sweatshirt Editorial.png', '2026-10-16 17:27:59', '2026-10-16 17:27:59', NULL), (50, 21, 'assets/files/images/products/1792173476-3.jpeg', '2026-10-16 17:57:56', '2026-10-16 17:57:56', NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_types` -- CREATE TABLE `product_types` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `sorting_serial` int NOT NULL DEFAULT '1', `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_types` -- INSERT INTO `product_types` (`id`, `name`, `slug`, `icon`, `image`, `status`, `created_at`, `updated_at`, `created_by`, `sorting_serial`, `deleted_at`) VALUES (1, 'Basics', 'basics', 'assets/files/images/product_type/1740839256-basic-needs.png', 'assets/files/images/product_type/1740839659-basics.png', 'active', '2025-03-01 08:27:38', '2025-04-29 09:53:54', 1, 2, NULL), (2, 'Casual Wear', 'casual-wear', 'assets/files/images/product_type/1740839771-casual.png', 'assets/files/images/product_type/1740839771-casual-wear.png', 'active', '2025-03-01 08:36:11', '2025-04-29 09:07:23', 1, 4, NULL), (3, 'Office Wear', 'office-wear', 'assets/files/images/product_type/1740839836-office-wear.png', 'assets/files/images/product_type/1740839836-office-wear.png', 'active', '2025-03-01 08:37:16', '2025-04-29 09:07:23', 1, 7, NULL), (4, 'Traditional', 'traditional', 'assets/files/images/product_type/1740839920-clothing.png', 'assets/files/images/product_type/1740839920-traditional.png', 'active', '2025-03-01 08:38:41', '2025-04-29 09:08:31', 1, 8, NULL), (5, 'Pants', 'pants', 'assets/files/images/product_type/1740840001-trousers.png', 'assets/files/images/product_type/1740840001-pants.png', 'active', '2025-03-01 08:40:02', '2025-04-29 10:10:37', 1, 1, NULL), (6, 'Footwear', 'footwear', 'assets/files/images/product_type/1740840063-shoes.png', 'assets/files/images/product_type/1740840063-Footwear.png', 'active', '2025-03-01 08:41:03', '2025-04-29 09:07:23', 1, 5, NULL), (7, 'Jewelry', 'jewelry', 'assets/files/images/product_type/1740840132-jewelry.png', 'assets/files/images/product_type/1740840132-Jewelry.png', 'active', '2025-03-01 08:42:13', '2025-04-29 09:07:23', 1, 6, NULL), (8, 'HODDIE', 'hoddie', 'assets/files/images/product_type/1740840210-bags.png', 'assets/files/images/product_type/1740840210-Accessories.png', 'active', '2025-03-01 08:43:30', '2026-10-15 10:16:16', 1, 3, NULL), (9, 'Sweatshirt', 'sweatshirt', 'assets/files/images/product_type/1740839256-basic-needs.png', 'assets/files/images/product_type/1740839659-basics.png', 'active', '2025-03-01 08:27:38', '2025-04-29 09:53:54', 1, 2, NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_type_categories` -- CREATE TABLE `product_type_categories` ( `id` bigint UNSIGNED NOT NULL, `product_type_id` int NOT NULL, `category_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_type_categories` -- INSERT INTO `product_type_categories` (`id`, `product_type_id`, `category_id`, `created_at`, `updated_at`) VALUES (8, 2, 1, '2025-04-29 10:09:07', '2025-04-29 10:09:07'), (9, 2, 2, '2025-04-29 10:09:07', '2025-04-29 10:09:07'), (10, 1, 1, '2025-07-11 02:50:54', '2025-07-11 02:50:54'); -- -------------------------------------------------------- -- -- Table structure for table `product_variants` -- CREATE TABLE `product_variants` ( `id` bigint UNSIGNED NOT NULL, `product_id` int NOT NULL, `size_id` int DEFAULT NULL, `color_id` int DEFAULT NULL, `unit_price` decimal(10,2) NOT NULL, `cost_price` decimal(10,2) DEFAULT '0.00', `discount_price` decimal(10,2) NOT NULL DEFAULT '0.00', `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_default` tinyint(1) NOT NULL DEFAULT '0', `inventory` int NOT NULL DEFAULT '0', `alert_quantity` int NOT NULL DEFAULT '0', `weight` decimal(10,2) NOT NULL DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_variants` -- INSERT INTO `product_variants` (`id`, `product_id`, `size_id`, `color_id`, `unit_price`, `cost_price`, `discount_price`, `image`, `is_default`, `inventory`, `alert_quantity`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 3, 2, 1000.00, 600.00, 800.00, NULL, 0, 100, 0, 0.00, '2025-03-03 10:49:28', '2026-10-11 08:04:34', NULL), (2, 1, 2, 2, 800.00, 480.00, 600.00, NULL, 1, 86, 0, 0.00, '2025-03-03 10:49:28', '2026-10-14 08:26:00', NULL), (3, 1, 3, 4, 1000.00, 600.00, 700.00, NULL, 0, 100, 0, 0.00, '2025-03-03 10:49:28', '2026-10-11 08:04:34', NULL), (4, 2, 2, 1, 1000.00, 600.00, 0.00, NULL, 1, 894, 0, 0.00, '2025-03-03 11:02:02', '2026-10-11 08:04:34', NULL), (5, 2, 1, 2, 800.00, 480.00, 600.00, NULL, 0, 100, 0, 0.00, '2025-03-03 11:02:02', '2026-10-11 08:04:34', NULL), (6, 2, 4, 1, 2000.00, 1200.00, 1800.00, NULL, 0, 98, 0, 0.00, '2025-03-03 11:02:02', '2026-10-14 09:41:45', NULL), (7, 3, 3, 2, 900.00, 540.00, 700.00, NULL, 1, 87, 0, 0.00, '2025-03-03 11:08:43', '2026-10-14 06:45:15', NULL), (8, 3, 4, 2, 800.00, 480.00, 700.00, NULL, 0, 97, 0, 0.00, '2025-03-03 11:08:43', '2026-10-11 08:04:34', NULL), (9, 3, 4, 2, 900.00, 540.00, 700.00, NULL, 0, 100, 0, 0.00, '2025-03-03 11:08:43', '2026-10-11 08:04:34', NULL), (10, 4, 3, 2, 500.00, 300.00, 450.00, NULL, 1, 100, 0, 0.00, '2025-03-04 05:22:08', '2026-10-11 08:04:34', NULL), (11, 4, 1, 1, 900.00, 540.00, 800.00, NULL, 0, 100, 0, 0.00, '2025-03-04 05:22:08', '2026-10-11 08:04:34', NULL), (12, 4, 6, 3, 900.00, 540.00, 0.00, NULL, 0, 100, 0, 0.00, '2025-03-04 05:22:08', '2026-10-11 08:04:34', NULL), (13, 5, 3, 5, 800.00, 480.00, 0.00, NULL, 1, 100, 0, 0.00, '2025-03-04 05:39:22', '2026-10-11 08:04:34', NULL), (14, 5, 1, 2, 600.00, 360.00, 0.00, NULL, 0, 100, 0, 0.00, '2025-03-04 05:39:22', '2026-10-11 08:04:34', NULL), (15, 6, 3, 4, 900.00, 540.00, 700.00, NULL, 1, 100, 0, 0.00, '2025-03-04 05:55:21', '2026-10-11 08:04:34', NULL), (16, 6, 2, 1, 1000.00, 600.00, 980.00, NULL, 0, 100, 0, 0.00, '2025-03-04 05:55:21', '2026-10-11 08:04:34', NULL), (17, 6, 4, 4, 600.00, 360.00, 500.00, NULL, 0, 100, 0, 0.00, '2025-03-04 05:55:21', '2026-10-11 08:04:34', NULL), (18, 6, 1, 1, 800.00, 480.00, 600.00, NULL, 0, 100, 0, 0.00, '2025-03-04 05:55:21', '2026-10-11 08:04:34', NULL), (19, 7, 2, 1, 500.00, 300.00, 430.00, NULL, 1, 99, 0, 0.00, '2025-03-04 09:02:55', '2026-10-11 08:04:34', NULL), (20, 7, 1, 2, 900.00, 540.00, 500.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:02:55', '2026-10-11 08:04:34', NULL), (21, 7, 1, 5, 800.00, 480.00, 600.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:02:55', '2026-10-11 08:04:34', NULL), (22, 8, 3, 1, 900.00, 540.00, 800.00, NULL, 1, 96, 0, 0.00, '2025-03-04 09:16:29', '2026-10-11 08:04:34', NULL), (23, 8, 2, 4, 700.00, 420.00, 600.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:16:29', '2026-10-11 08:04:34', NULL), (24, 8, 2, 1, 900.00, 540.00, 800.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:16:29', '2026-10-11 08:04:34', NULL), (25, 9, 3, 2, 900.00, 540.00, 700.00, NULL, 1, 100, 0, 0.00, '2025-03-04 09:19:24', '2026-10-11 08:04:34', NULL), (26, 9, 2, 1, 900.00, 540.00, 800.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:19:24', '2026-10-11 08:04:34', NULL), (27, 9, 4, 4, 800.00, 480.00, 700.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:19:24', '2026-10-11 08:04:34', NULL), (28, 10, 3, 1, 800.00, 480.00, 500.00, NULL, 1, 86, 0, 0.00, '2025-03-04 09:24:14', '2026-10-11 08:04:34', NULL), (29, 10, 1, 3, 900.00, 540.00, 700.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:24:14', '2026-10-11 08:04:34', NULL), (30, 10, 4, 3, 800.00, 480.00, 700.00, NULL, 0, 100, 0, 0.00, '2025-03-04 09:24:14', '2026-10-11 08:04:34', NULL), (31, 11, 2, 1, 4500.00, 2700.00, 0.00, NULL, 0, 100, 0, 0.00, '2025-03-04 10:52:41', '2026-10-11 08:04:34', NULL), (32, 11, 3, 4, 5000.00, 3000.00, 4800.00, NULL, 1, 95, 0, 0.00, '2025-03-04 10:52:41', '2026-10-11 08:04:34', NULL), (33, 11, 4, 2, 5000.00, 3000.00, 4800.00, NULL, 0, 100, 0, 0.00, '2025-03-04 10:52:41', '2026-10-11 08:04:34', NULL), (34, 12, 3, 2, 4000.00, 2400.00, 3500.00, NULL, 1, 94, 0, 0.00, '2025-03-06 05:41:55', '2026-10-11 08:04:34', NULL), (35, 12, 2, 3, 4000.00, 2400.00, 3500.00, NULL, 0, 100, 0, 0.00, '2025-03-06 05:41:55', '2026-10-11 08:04:34', NULL), (36, 12, 4, 5, 800.00, 480.00, 0.00, NULL, 0, 100, 0, 0.00, '2025-03-06 05:41:55', '2026-10-11 08:04:34', NULL), (37, 11, NULL, NULL, 800.00, 480.00, 600.00, NULL, 0, 100, 0, 0.00, '2025-04-25 11:24:41', '2026-10-11 08:04:35', NULL), (38, 13, NULL, NULL, 912.00, 547.20, 707.00, NULL, 1, 6, 0, 0.00, '2025-07-23 10:56:17', '2026-10-11 08:04:35', NULL), (40, 18, 8, 2, 850.00, 510.00, 595.00, NULL, 1, 98, 0, 0.00, '2026-10-07 06:58:37', '2026-10-11 08:04:35', NULL), (41, 18, 9, 2, 850.00, 510.00, 680.00, NULL, 0, 97, 0, 0.00, '2026-10-07 06:58:37', '2026-10-13 11:46:06', NULL), (42, 18, 10, 2, 850.00, 510.00, 765.00, NULL, 0, 98, 0, 0.00, '2026-10-07 06:58:37', '2026-10-13 11:46:05', NULL), (43, 18, 11, 2, 850.00, 510.00, 0.00, NULL, 0, 96, 0, 0.00, '2026-10-07 06:36:41', '2026-10-13 11:46:06', NULL), (44, 18, 8, 1, 850.00, 510.00, 600.00, NULL, 0, 100, 0, 0.00, '2026-10-08 17:10:36', '2026-10-11 08:04:35', NULL), (45, 18, 9, 4, 850.00, 510.00, 650.00, NULL, 0, 160, 0, 0.00, '2026-10-08 17:10:36', '2026-10-11 12:12:39', NULL), (46, 19, 10, 2, 550.00, 250.00, 0.00, NULL, 1, 100, 0, 0.00, '2026-10-15 10:31:38', '2026-10-15 10:52:29', NULL), (47, 19, 11, 2, 600.00, 250.00, 0.00, NULL, 0, 100, 0, 0.00, '2026-10-15 10:31:38', '2026-10-15 10:53:04', NULL), (48, 20, 10, 3, 650.00, 250.00, 0.00, NULL, 1, 0, 0, 0.00, '2026-10-16 17:27:58', '2026-10-16 17:27:58', NULL), (49, 21, NULL, NULL, 10000.00, 5000.00, 0.00, NULL, 1, 0, 0, 0.00, '2026-10-16 17:57:56', '2026-10-16 17:57:56', NULL); -- -------------------------------------------------------- -- -- Table structure for table `purchases` -- CREATE TABLE `purchases` ( `id` bigint UNSIGNED NOT NULL, `purchase_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `admin_id` bigint UNSIGNED DEFAULT NULL, `supplier_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `supplier_phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `product_id` bigint UNSIGNED DEFAULT NULL, `variant_id` bigint UNSIGNED DEFAULT NULL, `quantity` int NOT NULL DEFAULT '1', `unit_cost` decimal(10,2) NOT NULL DEFAULT '0.00', `total_cost` decimal(10,2) NOT NULL DEFAULT '0.00', `payment_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'paid', `purchase_date` date NOT NULL, `note` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `purchases` -- INSERT INTO `purchases` (`id`, `purchase_number`, `admin_id`, `supplier_name`, `supplier_phone`, `product_id`, `variant_id`, `quantity`, `unit_cost`, `total_cost`, `payment_status`, `purchase_date`, `note`, `created_at`, `updated_at`) VALUES (7, 'PUR-20261011-4N8LV', 1, 'Shimanto Enterprise', '01719540019', 18, 45, 10, 510.00, 5100.00, 'paid', '2026-10-11', NULL, '2026-10-11 12:12:39', '2026-10-11 12:12:39'), (9, 'PUR-20261015-AJYU6', 1, 'Tamara', '01719540019', 19, 46, 100, 250.00, 25000.00, 'paid', '2026-10-15', NULL, '2026-10-15 10:52:29', '2026-10-15 10:52:29'), (10, 'PUR-20261015-GSG2P', 1, 'Tamara', '01719540019', 19, 47, 100, 250.00, 25000.00, 'paid', '2026-10-15', NULL, '2026-10-15 10:53:04', '2026-10-15 10:53:04'); -- -------------------------------------------------------- -- -- Table structure for table `refund_requests` -- CREATE TABLE `refund_requests` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `order_id` bigint UNSIGNED NOT NULL, `order_product_id` bigint UNSIGNED NOT NULL, `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('pending','approved','rejected','completed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `admin_id` bigint UNSIGNED DEFAULT NULL COMMENT 'ID of admin who processed', `admin_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `refund_requests` -- INSERT INTO `refund_requests` (`id`, `user_id`, `order_id`, `order_product_id`, `reason`, `status`, `admin_id`, `admin_note`, `created_at`, `updated_at`) VALUES (1, 6, 59, 133, 'you give me wrong size', 'pending', NULL, NULL, '2026-10-09 10:07:10', '2026-10-09 10:07:10'), (2, 6, 58, 128, 'wrong size and color', 'pending', NULL, NULL, '2026-10-09 10:25:51', '2026-10-09 10:25:51'), (3, 6, 58, 129, 'wrong wrong', 'pending', NULL, NULL, '2026-10-09 11:00:23', '2026-10-09 11:00:23'); -- -------------------------------------------------------- -- -- Table structure for table `return_requests` -- CREATE TABLE `return_requests` ( `id` bigint UNSIGNED NOT NULL, `return_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `order_id` bigint UNSIGNED NOT NULL, `shipment_id` bigint UNSIGNED NOT NULL COMMENT 'The exact shipment attempt that failed or was delivered', `seller_id` bigint UNSIGNED DEFAULT NULL COMMENT 'Vendor ID for multi-vendor packages', `return_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'delivery_return' COMMENT 'delivery_return, customer_return, exchange, replacement, damaged, wrong_product', `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Customer Refused, Wrong Address, Customer Unavailable, Changed Mind, Wrong Product, Damaged Product, Wrong Size Sent, Courier Failed, Other', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'requested' COMMENT 'requested, approved, picked_up, in_transit, received, inspecting, approved_for_redelivery, completed, cancelled', `return_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `redelivery_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `customer_payable` decimal(10,2) NOT NULL DEFAULT '0.00', `charge_paid_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'customer' COMMENT 'customer, merchant, split', `charge_payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cod_addition' COMMENT 'online, cod_addition, waived', `charge_payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'pending, paid, waived', `customer_note` text COLLATE utf8mb4_unicode_ci, `admin_note` text COLLATE utf8mb4_unicode_ci, `requested_at` timestamp NULL DEFAULT NULL, `received_at` timestamp NULL DEFAULT NULL, `inspected_at` timestamp NULL DEFAULT NULL, `completed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `return_requests` -- INSERT INTO `return_requests` (`id`, `return_number`, `order_id`, `shipment_id`, `seller_id`, `return_type`, `reason`, `status`, `return_charge`, `redelivery_charge`, `customer_payable`, `charge_paid_by`, `charge_payment_method`, `charge_payment_status`, `customer_note`, `admin_note`, `requested_at`, `received_at`, `inspected_at`, `completed_at`, `created_at`, `updated_at`) VALUES (1, 'RET-261009-WXOJ', 32, 3, NULL, 'delivery_return', 'Customer Refused', 'completed', 0.00, 120.00, 120.00, 'customer', 'cod_addition', 'pending', 'Customer unavailable at delivery location', NULL, '2026-10-09 10:53:12', NULL, '2026-10-09 10:53:12', '2026-10-09 10:53:12', '2026-10-09 10:53:12', '2026-10-09 10:53:12'), (2, 'RET-261009-F9PG', 58, 4, 1, 'exchange', 'Size does not fit / Too small or large', 'completed', 0.00, 60.00, 0.00, 'merchant', 'waived', 'waived', 'wrong', NULL, '2026-10-09 11:24:19', NULL, '2026-10-09 11:38:33', '2026-10-09 12:17:12', '2026-10-09 11:24:19', '2026-10-09 12:17:12'), (3, 'RET-261009-05NH', 58, 4, 1, 'exchange', 'Defective or Damaged product', 'requested', 0.00, 60.00, 0.00, 'merchant', 'waived', 'waived', 'damage', NULL, '2026-10-09 11:24:57', NULL, '2026-10-09 11:40:12', NULL, '2026-10-09 11:24:57', '2026-10-09 11:40:12'); -- -------------------------------------------------------- -- -- Table structure for table `return_request_items` -- CREATE TABLE `return_request_items` ( `id` bigint UNSIGNED NOT NULL, `return_request_id` bigint UNSIGNED NOT NULL, `order_product_id` bigint UNSIGNED NOT NULL, `product_id` bigint UNSIGNED NOT NULL, `quantity` int UNSIGNED NOT NULL DEFAULT '1', `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `unit_price` decimal(10,2) NOT NULL DEFAULT '0.00', `total_price` decimal(10,2) NOT NULL DEFAULT '0.00', `item_condition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unopened' COMMENT 'unopened, opened, used, damaged, defective', `inspection_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'pending, good, damaged, missing', `restocked_to_inventory` tinyint(1) NOT NULL DEFAULT '0', `restocked_at` timestamp NULL DEFAULT NULL, `replacement_product_id` bigint UNSIGNED DEFAULT NULL, `replacement_size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `replacement_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `replacement_price_diff` decimal(10,2) NOT NULL DEFAULT '0.00', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `return_request_items` -- INSERT INTO `return_request_items` (`id`, `return_request_id`, `order_product_id`, `product_id`, `quantity`, `size`, `color`, `unit_price`, `total_price`, `item_condition`, `inspection_status`, `restocked_to_inventory`, `restocked_at`, `replacement_product_id`, `replacement_size`, `replacement_color`, `replacement_price_diff`, `created_at`, `updated_at`) VALUES (1, 1, 91, 7, 1, 'M', 'GREY', 400.00, 400.00, 'unopened', 'good', 1, '2026-10-09 10:53:12', NULL, NULL, NULL, 0.00, '2026-10-09 10:53:12', '2026-10-09 10:53:12'), (2, 1, 93, 1, 1, 'M', 'BLACK', 600.00, 600.00, 'unopened', 'damaged', 0, NULL, NULL, NULL, NULL, 0.00, '2026-10-09 10:53:12', '2026-10-09 10:53:12'), (3, 2, 132, 18, 1, '9-10Y', 'BLACK', 850.00, 850.00, 'unopened', 'good', 1, '2026-10-09 11:38:33', NULL, '9-10Y', 'BLACK', 0.00, '2026-10-09 11:24:19', '2026-10-09 12:17:12'), (4, 3, 131, 18, 1, '7-8Y', 'BLACK', 765.00, 765.00, 'unopened', 'good', 1, '2026-10-09 11:40:12', NULL, NULL, NULL, 0.00, '2026-10-09 11:24:57', '2026-10-09 11:40:12'); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` bigint UNSIGNED NOT NULL, `user_id` int NOT NULL, `order_id` int NOT NULL, `order_product_id` int NOT NULL, `product_id` int NOT NULL, `rating` int NOT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `reviews` -- INSERT INTO `reviews` (`id`, `user_id`, `order_id`, `order_product_id`, `product_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES (4, 6, 27, 66, 9, 3, 'McLaughlin - Predovic Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '2025-07-13 11:45:10', '2025-07-13 11:46:41'), (5, 6, 27, 65, 10, 4, 'Aute ut dolor non coLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '2025-07-13 11:45:27', '2025-07-13 11:46:30'), (6, 6, 60, 134, 18, 4, 'Updated via Quick Review Modal: Very satisfied with the fabric and delivery speed!', '2026-10-09 14:48:55', '2026-10-09 14:59:53'), (7, 6, 59, 133, 10, 5, 'hust wow', '2026-10-09 15:24:51', '2026-10-09 15:24:51'), (8, 6, 62, 137, 18, 5, 'Good', '2026-10-12 16:19:35', '2026-10-12 16:19:35'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON array of permissions', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES (1, '4', '[\"manage_products\",\"manage_orders\",\"manage_webpage\",\"manage_attributes\",\"manage_sellers\",\"manage_refunds\",\"manage_coupons\",\"manage_settings\",\"manage_admins\",\"manage_reports\"]', '2026-02-21 05:27:07', '2026-02-21 05:27:07'); -- -------------------------------------------------------- -- -- Table structure for table `section_products` -- CREATE TABLE `section_products` ( `id` bigint UNSIGNED NOT NULL, `section_id` int NOT NULL, `product_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `seller_order_logs` -- CREATE TABLE `seller_order_logs` ( `id` bigint UNSIGNED NOT NULL, `seller_id` int NOT NULL, `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `total_product` int NOT NULL DEFAULT '0', `shipping_fee` double NOT NULL DEFAULT '0', `order_amount` double NOT NULL DEFAULT '0', `commission_rate` double(8,2) NOT NULL DEFAULT '0.00', `total_commission` double NOT NULL DEFAULT '0', `order_price` double NOT NULL DEFAULT '0', `seller_amount` double NOT NULL DEFAULT '0', `payment_status` enum('paid','unpaid') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `pay_to` enum('seller','merchant') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'merchant' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `seller_order_logs` -- INSERT INTO `seller_order_logs` (`id`, `seller_id`, `order_id`, `order_number`, `invoice`, `total_product`, `shipping_fee`, `order_amount`, `commission_rate`, `total_commission`, `order_price`, `seller_amount`, `payment_status`, `created_at`, `updated_at`, `pay_to`) VALUES (23, 2, '32', '0001', 'RT-68288997', 2, 60, 5507, 10.00, 550.7, 5567, 4956.3, 'paid', '2025-10-10 12:09:33', '2026-10-14 07:56:18', 'merchant'), (24, 1, '32', '0001', 'RT-68288997', 4, 60, 2900, 15.00, 435, 2960, 2465, 'paid', '2025-10-10 12:09:33', '2026-10-14 07:56:18', 'merchant'), (25, 1, '64', '0033', 'RT-59749838', 1, 60, 2800, 15.00, 420, 2860, 2380, 'unpaid', '2026-10-14 06:54:49', '2026-10-14 06:54:49', 'merchant'); -- -------------------------------------------------------- -- -- Table structure for table `seller_shops` -- CREATE TABLE `seller_shops` ( `id` bigint UNSIGNED NOT NULL, `seller_id` int NOT NULL, `shop_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start_from` date DEFAULT NULL, `licence_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `licence_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'pdf', `website_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `seller_shops` -- INSERT INTO `seller_shops` (`id`, `seller_id`, `shop_name`, `email`, `mobile`, `phone`, `address`, `start_from`, `licence_no`, `licence_file`, `website_url`, `logo`, `created_at`, `updated_at`) VALUES (1, 1, 'Ferdinand Duncan', 'dijyt@mailinator.com', '01609605494', '+1 (989) 674-1798', 'Pariatur Laborum V', '2025-02-12', 'Consequat Neque odi', NULL, 'https://www.lenonuliqiwaz.org', NULL, '2025-02-27 10:38:17', '2025-06-27 00:48:16'), (2, 2, 'Chaney Potter', 'vabugaru@mailinator.com', '01636958789', '+1 (981) 938-3582', 'Illum quisquam volu', '2025-03-20', '251259151', NULL, 'https://www.miqo.ws', NULL, '2025-03-04 10:48:27', '2025-07-23 11:27:10'), (3, 3, 'Anika Atkinson', 'bavivil@mailinator.com', '01827271455', '+1 (289) 385-9915', 'Qui atque molestias', '2025-03-20', 'Officia repudiandae', NULL, 'https://www.quhi.me', NULL, '2025-03-06 02:17:50', '2025-03-06 02:17:50'); -- -------------------------------------------------------- -- -- Table structure for table `shipments` -- CREATE TABLE `shipments` ( `id` bigint UNSIGNED NOT NULL, `order_id` bigint UNSIGNED NOT NULL, `seller_id` bigint UNSIGNED DEFAULT NULL COMMENT 'Vendor ID for multi-vendor packages, null for admin/direct', `package_number` int UNSIGNED NOT NULL DEFAULT '1' COMMENT 'e.g. Package 1 of 2', `attempt_no` int UNSIGNED NOT NULL DEFAULT '1', `shipment_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'original' COMMENT 'original, redelivery, replacement', `parent_shipment_id` bigint UNSIGNED DEFAULT NULL, `courier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'steadfast, ecourier, pathao, redx, etc.', `invoice` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Invoice / reference sent to courier', `consignment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tracking_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `courier_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Raw status string from courier', `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'Normalized status: pending, in_review, picked_up, in_transit, out_for_delivery, delivered, returned, cancelled', `delivery_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `return_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `additional_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `cod_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping_charge` decimal(10,2) NOT NULL DEFAULT '0.00', `recipient_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_address` text COLLATE utf8mb4_unicode_ci NOT NULL, `recipient_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `recipient_area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `package_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'eCourier package type code', `note` text COLLATE utf8mb4_unicode_ci, `return_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_response` longtext COLLATE utf8mb4_unicode_ci COMMENT 'Latest raw response from courier API', `shipped_at` timestamp NULL DEFAULT NULL, `delivered_at` timestamp NULL DEFAULT NULL, `returned_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `shipments` -- INSERT INTO `shipments` (`id`, `order_id`, `seller_id`, `package_number`, `attempt_no`, `shipment_type`, `parent_shipment_id`, `courier`, `invoice`, `consignment_id`, `tracking_code`, `courier_status`, `status`, `delivery_charge`, `return_charge`, `additional_charge`, `cod_amount`, `shipping_charge`, `recipient_name`, `recipient_phone`, `recipient_address`, `recipient_city`, `recipient_area`, `package_code`, `note`, `return_reason`, `api_response`, `shipped_at`, `delivered_at`, `returned_at`, `created_at`, `updated_at`) VALUES (3, 32, NULL, 1, 1, 'original', NULL, 'steadfast', 'RT-68288997', 'ST-330430', 'TEST_SF_WEBHOOK_TRK', 'delivered', 'delivered', 0.00, 0.00, 0.00, 500.00, 120.00, 'Stewart Sanford', '01609605491', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', NULL, NULL, NULL, 'Test courier dispatch', NULL, '{\"tracking_code\":\"TEST_SF_WEBHOOK_TRK\",\"status\":\"delivered\"}', '2026-10-09 10:02:18', '2026-10-09 14:17:57', NULL, '2026-10-09 10:02:18', '2026-10-09 14:17:57'), (4, 58, 1, 1, 1, 'original', NULL, 'steadfast', 'RT-44269846-P1', 'ST-295210', 'SF03B0FBDB', 'delivered', 'delivered', 0.00, 0.00, 0.00, 50.00, 60.00, 'Stewart Sanford', '01609605491', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 'Eligendi occaecat es', 'Eligendi occaecat es', '#2534', NULL, NULL, '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 10:11:35', NULL, NULL, '2026-10-09 10:11:35', '2026-10-09 10:13:09'), (5, 32, NULL, 1, 2, 'redelivery', 3, 'steadfast', 'RT-68288997-R2', 'ST-899521', 'SF9E60249F', 'in_review', 'in_review', 120.00, 0.00, 0.00, 1120.00, 0.00, 'Stewart Sanford', '01609605491', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', NULL, NULL, NULL, 'Re-delivery attempt #2 for Return #RET-261009-WXOJ', NULL, '{\"status\":200,\"message\":\"Order created successfully\",\"consignment\":{\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"status\":\"in_review\",\"invoice\":\"RT-68288997-R2\"}}', '2026-10-09 10:53:12', NULL, NULL, '2026-10-09 10:53:12', '2026-10-09 10:53:12'), (7, 58, 1, 1, 2, 'replacement', 4, 'steadfast', 'RT-44269846-P1-EX2', 'ST-349225', 'SF2712AC9A', 'in_review', 'in_review', 60.00, 0.00, 0.00, 100.00, 0.00, 'Stewart Sanford', '01609605491', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', NULL, NULL, NULL, 'Exchange replacement for Return #RET-261009-F9PG', NULL, '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 12:17:12', NULL, NULL, '2026-10-09 12:17:12', '2026-10-14 09:30:25'), (14, 60, 1, 1, 1, 'original', NULL, 'steadfast', 'RT-54784683-P1', '830778', 'STDF-727842D7', 'Delivered', 'delivered', 0.00, 0.00, 0.00, 910.00, 60.00, 'Stewart Sanford', '01609605491', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 'Eligendi occaecat es', 'Eligendi occaecat es', '#2534', NULL, NULL, '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"830778\",\"tracking_code\":\"STDF-727842D7\",\"mock\":true}', '2026-10-09 17:47:12', '2026-10-10 10:14:00', NULL, '2026-10-09 17:47:12', '2026-10-10 10:20:09'), (15, 62, 1, 1, 1, 'original', NULL, 'steadfast', 'RT-92459738-P1', '350788', 'STDF-01F8A970', 'Delivered', 'delivered', 0.00, 0.00, 0.00, 0.00, 60.00, 'Stewart Sanford', '01609605491', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', 'Eligendi occaecat es', 'Eligendi occaecat es', '#2534', NULL, NULL, '{\"status\":200,\"message\":\"Consignment created successfully (Mock)\",\"consignment\":{\"consignment_id\":350788,\"tracking_code\":\"STDF-01F8A970\",\"status\":\"in_review\",\"invoice\":\"RT-92459738-P1\",\"recipient_name\":\"Stewart Sanford\",\"recipient_phone\":\"01609605491\",\"recipient_address\":\"Shibu lichu bagan, Baruahat, Kaunia, Rangpur\",\"cod_amount\":0}}', '2026-10-12 16:14:05', '2026-10-12 16:19:01', NULL, '2026-10-12 16:14:05', '2026-10-12 16:19:01'), (22, 64, 1, 1, 1, 'original', NULL, 'steadfast', 'RT-59749838-P1', '401089', 'STDF-70A7B242', 'Cancelled', 'cancelled', 0.00, 0.00, 0.00, 2860.00, 60.00, 'Mohsin Ali', '01719540019', 'House-884, Floor-4th, Road-13, Block-I', 'Bashundhara', 'Bashundhara', '#2534', NULL, NULL, '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"401089\",\"tracking_code\":\"STDF-70A7B242\",\"mock\":true}', '2026-10-14 08:22:00', NULL, NULL, '2026-10-14 08:22:00', '2026-10-14 08:23:43'), (23, 65, 1, 1, 1, 'original', NULL, 'carrybee', 'BO-99384105-P1', 'F1014TZK95S', 'F1014TZK95S', 'order.delivered', 'delivered', 0.00, 0.00, 0.00, 1260.00, 60.00, 'Mohsin Ali', '01719540019', 'House-884, Floor-4th, Road-13, Block-I', 'Bashundhara', 'Bashundhara', '#2534', NULL, NULL, '{\"consignment_id\":\"F1014TZK95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"event\":\"order.delivered\",\"transfer_status\":\"delivered\"}', '2026-10-14 08:26:36', '2026-10-14 09:31:14', NULL, '2026-10-14 08:26:33', '2026-10-14 09:31:14'), (24, 66, 1, 1, 1, 'original', NULL, 'carrybee', 'BO-11221928-P1', 'F10144ZF8CN', 'F10144ZF8CN', 'Pickup cancelled', 'in_transit', 0.00, 0.00, 0.00, 3660.00, 60.00, 'Mohsin Ali', '01719540019', 'House-884, Floor-4th, Road-13, Block-I', 'Bashundhara', 'Bashundhara', '#2534', NULL, NULL, '{\"error\":false,\"message\":\"Order created successfully\",\"data\":{\"order\":{\"id\":9555587,\"consignment_id\":\"F10144ZF8CN\",\"business_id\":35634,\"store_id\":30120,\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_secondary_phone\":\"\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"transfer_status_id\":1,\"transfer_status_updated_at\":{\"created_at\":\"2026-10-14 09:42:27\",\"updated_at\":\"\"},\"collectable_amount\":\"3660\",\"collected_amount\":\"0\",\"delivery_fee\":\"60\",\"cod_fee\":36.6,\"discount\":\"0\",\"additional_charge\":\"0\",\"total_fee\":96.6,\"pickup_hub_id\":193,\"current_hub_id\":193,\"delivery_hub_id\":193,\"recipient_phone_last_four_digits\":\"0019\",\"consignment_last_four_digits\":\"F8CN\",\"merchant_order_id\":\"BO-11221928-P1\",\"country_id\":1,\"city_id\":14,\"zone_id\":6,\"area_id\":0,\"customer_id\":5122985,\"order_source\":6,\"attempt\":0,\"product_description\":\"\",\"special_instruction\":\"\",\"weight\":500,\"item_type\":1,\"shipment_type\":1,\"delivery_type\":1,\"created_at\":{\"created_at\":\"2026-10-14 09:42:27\",\"updated_at\":\"\"},\"updated_at\":{\"created_at\":\"2026-10-14 09:42:27\",\"updated_at\":\"\"},\"sorted_by\":0,\"tracking_link\":\"\",\"quantity\":1,\"selling_price\":0,\"old_consignment_id\":\"\",\"old_store_id\":0,\"old_business_id\":0,\"price_plan_id\":2,\"pickup_agent_id\":0,\"delivery_agent_id\":0,\"billing_status_id\":0,\"payment_invoice_id\":0,\"pickup_hub_name\":\"\",\"delivery_hub_name\":\"\",\"current_hub_name\":\"\",\"order_type\":1,\"is_closed\":false,\"weight_in_kg\":0.5,\"collectable_amount_in_paisha\":\"366000\",\"collected_amount_in_paisha\":\"0\",\"delivery_fee_in_paisha\":\"6000\",\"cod_fee_in_paisha\":\"3660\",\"discount_in_paisha\":\"0\",\"additional_charge_in_paisha\":\"0\",\"total_fee_in_paisha\":\"9660\",\"selling_price_in_paisha\":0,\"exchange_image\":\"\",\"editable_fields\":[],\"cancel_attachments\":[]}}}', '2026-10-14 09:42:27', NULL, NULL, '2026-10-14 09:42:24', '2026-10-14 09:53:33'); -- -------------------------------------------------------- -- -- Table structure for table `shipment_logs` -- CREATE TABLE `shipment_logs` ( `id` bigint UNSIGNED NOT NULL, `shipment_id` bigint UNSIGNED NOT NULL, `event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'created, synced, cancelled, webhook_received, error', `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Normalized status at time of log', `message` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci COMMENT 'JSON request/response payload', `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `shipment_logs` -- INSERT INTO `shipment_logs` (`id`, `shipment_id`, `event`, `status`, `message`, `payload`, `created_at`) VALUES (3, 3, 'created', 'in_review', 'Shipment created via Steadfast Courier. Tracking: SFCE3805C4', '{\"status\":200,\"message\":\"Order created successfully\",\"consignment\":{\"consignment_id\":\"ST-330430\",\"tracking_code\":\"SFCE3805C4\",\"status\":\"in_review\",\"invoice\":\"RT-68288997\"}}', '2026-10-09 10:02:18'), (4, 3, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_transit', '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 10:02:29'), (5, 3, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 10:04:27'), (6, 3, 'webhook_received', 'delivered', 'Steadfast Webhook: status updated to delivered (raw: delivered)', '{\"tracking_code\":\"SFCE3805C4\",\"consignment_id\":\"ST-330430\",\"status\":\"delivered\"}', '2026-10-09 10:04:43'), (7, 4, 'created', 'in_review', 'Shipment created via Steadfast Courier. Tracking: SF03B0FBDB', '{\"status\":200,\"message\":\"Order created successfully\",\"consignment\":{\"consignment_id\":\"ST-295210\",\"tracking_code\":\"SF03B0FBDB\",\"status\":\"in_review\",\"invoice\":\"RT-44269846-P1\"}}', '2026-10-09 10:11:35'), (8, 4, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_transit', '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 10:13:09'), (9, 4, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_transit', '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 10:14:21'), (10, 3, 'return_initiated', 'delivered', 'Return Request #RET-261009-WXOJ created (Reason: Customer Refused)', NULL, '2026-10-09 10:53:12'), (11, 5, 'created', 'in_review', 'Re-delivery Shipment (Attempt #2) created via Steadfast Courier. Tracking: SF9E60249F', '{\"status\":200,\"message\":\"Order created successfully\",\"consignment\":{\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"status\":\"in_review\",\"invoice\":\"RT-68288997-R2\"}}', '2026-10-09 10:53:12'), (12, 4, 'return_initiated', 'delivered', 'Return Request #RET-261009-F9PG created (Reason: Size does not fit / Too small or large)', NULL, '2026-10-09 11:24:19'), (13, 4, 'return_initiated', 'delivered', 'Return Request #RET-261009-05NH created (Reason: Defective or Damaged product)', NULL, '2026-10-09 11:24:57'), (15, 7, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_transit', '{\"status\":200,\"delivery_status\":\"in_transit\"}', '2026-10-09 13:05:38'), (20, 3, 'webhook_received', 'delivered', 'Steadfast Webhook: status updated to delivered (raw: delivered)', '{\"tracking_code\":\"TEST_SF_WEBHOOK_TRK\",\"status\":\"delivered\"}', '2026-10-09 14:17:57'), (23, 14, 'created', 'in_review', 'Shipment created via Steadfast Courier. Tracking: STDF-727842D7', '{\"status\":200,\"message\":\"Consignment created successfully (Mock)\",\"consignment\":{\"consignment_id\":830778,\"tracking_code\":\"STDF-727842D7\",\"status\":\"in_review\",\"invoice\":\"RT-54784683-P1\",\"recipient_name\":\"Stewart Sanford\",\"recipient_phone\":\"01609605491\",\"recipient_address\":\"Shibu lichu bagan, Baruahat, Kaunia, Rangpur\",\"cod_amount\":910}}', '2026-10-09 17:47:12'), (24, 14, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"830778\",\"tracking_code\":\"STDF-727842D7\",\"mock\":true}', '2026-10-10 09:58:07'), (25, 14, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"830778\",\"tracking_code\":\"STDF-727842D7\",\"mock\":true}', '2026-10-10 10:00:48'), (26, 14, 'manual_status_update', 'picked_up', 'Shipment status manually updated from In review to Picked up by Mr. Admin', '{\"old_status\":\"in_review\",\"new_status\":\"picked_up\",\"updated_by\":1,\"note\":\"\",\"order_id\":60,\"timestamp\":\"2026-10-10T10:13:40+00:00\"}', '2026-10-10 10:13:40'), (27, 14, 'manual_status_update', 'delivered', 'Shipment status manually updated from Picked up to Delivered by Mr. Admin (Note: Manual delivery confirmation test)', '{\"old_status\":\"picked_up\",\"new_status\":\"delivered\",\"updated_by\":1,\"note\":\"Manual delivery confirmation test\",\"order_id\":60,\"timestamp\":\"2026-10-10T10:14:00+00:00\"}', '2026-10-10 10:14:00'), (28, 14, 'manual_status_update', 'in_transit', 'Shipment status manually updated from Delivered to In transit by Mr. Admin (Note: Parcel in transit to customer)', '{\"old_status\":\"delivered\",\"new_status\":\"in_transit\",\"updated_by\":1,\"note\":\"Parcel in transit to customer\",\"order_id\":60,\"timestamp\":\"2026-10-10T10:14:14+00:00\"}', '2026-10-10 10:14:14'), (29, 14, 'manual_status_update', 'in_transit', 'Shipment status manually updated from In transit to In transit by Mr. Admin', '{\"old_status\":\"in_transit\",\"new_status\":\"in_transit\",\"updated_by\":1,\"note\":\"\",\"order_id\":60,\"timestamp\":\"2026-10-10T10:18:40+00:00\"}', '2026-10-10 10:18:40'), (30, 14, 'manual_status_update', 'out_for_delivery', 'Shipment status manually updated from In transit to Out for delivery by Mr. Admin', '{\"old_status\":\"in_transit\",\"new_status\":\"out_for_delivery\",\"updated_by\":1,\"note\":\"\",\"order_id\":60,\"timestamp\":\"2026-10-10T10:19:16+00:00\"}', '2026-10-10 10:19:16'), (31, 14, 'manual_status_update', 'delivered', 'Shipment status manually updated from Out for delivery to Delivered by Mr. Admin', '{\"old_status\":\"out_for_delivery\",\"new_status\":\"delivered\",\"updated_by\":1,\"note\":\"\",\"order_id\":60,\"timestamp\":\"2026-10-10T10:20:09+00:00\"}', '2026-10-10 10:20:09'), (32, 15, 'created', 'in_review', 'Shipment created via Steadfast Courier. Tracking: STDF-01F8A970', '{\"status\":200,\"message\":\"Consignment created successfully (Mock)\",\"consignment\":{\"consignment_id\":350788,\"tracking_code\":\"STDF-01F8A970\",\"status\":\"in_review\",\"invoice\":\"RT-92459738-P1\",\"recipient_name\":\"Stewart Sanford\",\"recipient_phone\":\"01609605491\",\"recipient_address\":\"Shibu lichu bagan, Baruahat, Kaunia, Rangpur\",\"cod_amount\":0}}', '2026-10-12 16:14:05'), (33, 15, 'manual_status_update', 'picked_up', 'Shipment status manually updated from In review to Picked up by Mr. Admin', '{\"old_status\":\"in_review\",\"new_status\":\"picked_up\",\"updated_by\":1,\"note\":\"\",\"order_id\":62,\"timestamp\":\"2026-10-12T16:17:37+00:00\"}', '2026-10-12 16:17:37'), (34, 15, 'manual_status_update', 'out_for_delivery', 'Shipment status manually updated from Picked up to Out for delivery by Mr. Admin', '{\"old_status\":\"picked_up\",\"new_status\":\"out_for_delivery\",\"updated_by\":1,\"note\":\"\",\"order_id\":62,\"timestamp\":\"2026-10-12T16:18:39+00:00\"}', '2026-10-12 16:18:39'), (35, 15, 'manual_status_update', 'delivered', 'Shipment status manually updated from Out for delivery to Delivered by Mr. Admin', '{\"old_status\":\"out_for_delivery\",\"new_status\":\"delivered\",\"updated_by\":1,\"note\":\"\",\"order_id\":62,\"timestamp\":\"2026-10-12T16:19:01+00:00\"}', '2026-10-12 16:19:01'), (41, 22, 'created', 'in_review', 'Shipment created via Steadfast Courier. Tracking: STDF-70A7B242', '{\"status\":200,\"message\":\"Consignment created successfully (Mock)\",\"consignment\":{\"consignment_id\":401089,\"tracking_code\":\"STDF-70A7B242\",\"status\":\"in_review\",\"invoice\":\"RT-59749838-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"01719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"cod_amount\":2860}}', '2026-10-14 08:22:00'), (42, 22, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"401089\",\"tracking_code\":\"STDF-70A7B242\",\"mock\":true}', '2026-10-14 08:22:46'), (43, 22, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"401089\",\"tracking_code\":\"STDF-70A7B242\",\"mock\":true}', '2026-10-14 08:23:20'), (44, 22, 'cancelled', 'cancelled', 'Shipment cancelled. Reason: Cancelled by admin', '[]', '2026-10-14 08:23:43'), (45, 23, 'created', 'in_review', 'Shipment created via Carrybee. Tracking: F1014TZK95S', '{\"error\":false,\"message\":\"Order created successfully\",\"data\":{\"order\":{\"id\":8757874,\"consignment_id\":\"F1014TZK95S\",\"business_id\":6537,\"store_id\":9923,\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_secondary_phone\":\"\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"transfer_status_id\":1,\"transfer_status_updated_at\":{\"created_at\":\"2026-10-14 08:26:36\",\"updated_at\":\"\"},\"collectable_amount\":\"1260\",\"collected_amount\":\"0\",\"delivery_fee\":\"60\",\"cod_fee\":12.6,\"discount\":\"0\",\"additional_charge\":\"0\",\"total_fee\":72.6,\"pickup_hub_id\":172,\"current_hub_id\":172,\"delivery_hub_id\":193,\"recipient_phone_last_four_digits\":\"0019\",\"consignment_last_four_digits\":\"K95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"country_id\":1,\"city_id\":14,\"zone_id\":6,\"area_id\":0,\"customer_id\":667893,\"order_source\":6,\"attempt\":0,\"product_description\":\"\",\"special_instruction\":\"\",\"weight\":500,\"item_type\":1,\"shipment_type\":1,\"delivery_type\":1,\"created_at\":{\"created_at\":\"2026-10-14 08:26:36\",\"updated_at\":\"\"},\"updated_at\":{\"created_at\":\"2026-10-14 08:26:36\",\"updated_at\":\"\"},\"sorted_by\":0,\"tracking_link\":\"\",\"quantity\":1,\"selling_price\":0,\"old_consignment_id\":\"\",\"old_store_id\":0,\"old_business_id\":0,\"price_plan_id\":170,\"pickup_agent_id\":0,\"delivery_agent_id\":0,\"billing_status_id\":0,\"payment_invoice_id\":0,\"pickup_hub_name\":\"\",\"delivery_hub_name\":\"\",\"current_hub_name\":\"\",\"order_type\":1,\"is_closed\":false,\"weight_in_kg\":0.5,\"collectable_amount_in_paisha\":\"126000\",\"collected_amount_in_paisha\":\"0\",\"delivery_fee_in_paisha\":\"6000\",\"cod_fee_in_paisha\":\"1260\",\"discount_in_paisha\":\"0\",\"additional_charge_in_paisha\":\"0\",\"total_fee_in_paisha\":\"7260\",\"selling_price_in_paisha\":0,\"exchange_image\":\"\",\"editable_fields\":[],\"cancel_attachments\":[],\"advance_due_collection_in_paisha\":\"0\"}}}', '2026-10-14 08:26:36'), (46, 23, 'synced', 'in_review', 'Tracking updated from in_review to in_review. Courier reports: Pickup requested', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup requested\",\"store_id\":\"9923\",\"consignment_id\":\"F1014TZK95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"1260\",\"collected_amount\":\"0\",\"cod_fee\":12.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T14:26:36+06:00\"}}', '2026-10-14 08:38:36'), (47, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 09:30:25'), (48, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 09:30:25'), (49, 23, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup requested\",\"store_id\":\"9923\",\"consignment_id\":\"F1014TZK95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"1260\",\"collected_amount\":\"0\",\"cod_fee\":12.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T14:26:36+06:00\"}}', '2026-10-14 09:30:26'), (50, 23, 'webhook_received', 'in_transit', 'Carrybee Webhook: status updated to in_transit (raw: order.in-transit)', '{\"consignment_id\":\"F1014TZK95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"event\":\"order.in-transit\",\"transfer_status\":\"in_transit\"}', '2026-10-14 09:31:05'), (51, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 09:31:09'), (52, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 09:31:09'), (53, 23, 'synced', 'in_review', 'Auto-sync updated status from in_transit to in_review', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup requested\",\"store_id\":\"9923\",\"consignment_id\":\"F1014TZK95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"1260\",\"collected_amount\":\"0\",\"cod_fee\":12.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T14:26:36+06:00\"}}', '2026-10-14 09:31:10'), (54, 23, 'webhook_received', 'delivered', 'Carrybee Webhook: status updated to delivered (raw: order.delivered)', '{\"consignment_id\":\"F1014TZK95S\",\"merchant_order_id\":\"BO-99384105-P1\",\"event\":\"order.delivered\",\"transfer_status\":\"delivered\"}', '2026-10-14 09:31:14'), (55, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 09:32:54'), (56, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 09:32:54'), (57, 24, 'created', 'in_review', 'Shipment created via Carrybee. Tracking: F10144ZF8CN', '{\"error\":false,\"message\":\"Order created successfully\",\"data\":{\"order\":{\"id\":9555587,\"consignment_id\":\"F10144ZF8CN\",\"business_id\":35634,\"store_id\":30120,\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_secondary_phone\":\"\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"transfer_status_id\":1,\"transfer_status_updated_at\":{\"created_at\":\"2026-10-14 09:42:27\",\"updated_at\":\"\"},\"collectable_amount\":\"3660\",\"collected_amount\":\"0\",\"delivery_fee\":\"60\",\"cod_fee\":36.6,\"discount\":\"0\",\"additional_charge\":\"0\",\"total_fee\":96.6,\"pickup_hub_id\":193,\"current_hub_id\":193,\"delivery_hub_id\":193,\"recipient_phone_last_four_digits\":\"0019\",\"consignment_last_four_digits\":\"F8CN\",\"merchant_order_id\":\"BO-11221928-P1\",\"country_id\":1,\"city_id\":14,\"zone_id\":6,\"area_id\":0,\"customer_id\":5122985,\"order_source\":6,\"attempt\":0,\"product_description\":\"\",\"special_instruction\":\"\",\"weight\":500,\"item_type\":1,\"shipment_type\":1,\"delivery_type\":1,\"created_at\":{\"created_at\":\"2026-10-14 09:42:27\",\"updated_at\":\"\"},\"updated_at\":{\"created_at\":\"2026-10-14 09:42:27\",\"updated_at\":\"\"},\"sorted_by\":0,\"tracking_link\":\"\",\"quantity\":1,\"selling_price\":0,\"old_consignment_id\":\"\",\"old_store_id\":0,\"old_business_id\":0,\"price_plan_id\":2,\"pickup_agent_id\":0,\"delivery_agent_id\":0,\"billing_status_id\":0,\"payment_invoice_id\":0,\"pickup_hub_name\":\"\",\"delivery_hub_name\":\"\",\"current_hub_name\":\"\",\"order_type\":1,\"is_closed\":false,\"weight_in_kg\":0.5,\"collectable_amount_in_paisha\":\"366000\",\"collected_amount_in_paisha\":\"0\",\"delivery_fee_in_paisha\":\"6000\",\"cod_fee_in_paisha\":\"3660\",\"discount_in_paisha\":\"0\",\"additional_charge_in_paisha\":\"0\",\"total_fee_in_paisha\":\"9660\",\"selling_price_in_paisha\":0,\"exchange_image\":\"\",\"editable_fields\":[],\"cancel_attachments\":[]}}}', '2026-10-14 09:42:27'), (58, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 09:53:33'), (59, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 09:53:33'), (60, 24, 'synced', 'in_transit', 'Auto-sync updated status from in_review to in_transit', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup cancelled\",\"store_id\":\"30120\",\"consignment_id\":\"F10144ZF8CN\",\"merchant_order_id\":\"BO-11221928-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"3660\",\"collected_amount\":\"0\",\"cod_fee\":36.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T15:43:41+06:00\"}}', '2026-10-14 09:53:33'), (61, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 09:53:39'), (62, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 09:53:39'), (63, 24, 'synced', 'in_transit', 'Auto-sync updated status from in_transit to in_transit', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup cancelled\",\"store_id\":\"30120\",\"consignment_id\":\"F10144ZF8CN\",\"merchant_order_id\":\"BO-11221928-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"3660\",\"collected_amount\":\"0\",\"cod_fee\":36.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T15:43:41+06:00\"}}', '2026-10-14 09:53:39'), (64, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 09:55:10'), (65, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 09:55:10'), (66, 24, 'synced', 'in_transit', 'Auto-sync updated status from in_transit to in_transit', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup cancelled\",\"store_id\":\"30120\",\"consignment_id\":\"F10144ZF8CN\",\"merchant_order_id\":\"BO-11221928-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"3660\",\"collected_amount\":\"0\",\"cod_fee\":36.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T15:43:41+06:00\"}}', '2026-10-14 09:55:10'), (67, 5, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-899521\",\"tracking_code\":\"SF9E60249F\",\"mock\":true}', '2026-10-14 10:03:04'), (68, 7, 'synced', 'in_review', 'Auto-sync updated status from in_review to in_review', '{\"status\":200,\"delivery_status\":\"in_review\",\"consignment_id\":\"ST-349225\",\"tracking_code\":\"SF2712AC9A\",\"mock\":true}', '2026-10-14 10:03:04'), (69, 24, 'synced', 'in_transit', 'Auto-sync updated status from in_transit to in_transit', '{\"error\":false,\"message\":\"Order details\",\"data\":{\"transfer_status\":\"Pickup cancelled\",\"store_id\":\"30120\",\"consignment_id\":\"F10144ZF8CN\",\"merchant_order_id\":\"BO-11221928-P1\",\"recipient_name\":\"Mohsin Ali\",\"recipient_phone\":\"8801719540019\",\"recipient_address\":\"House-884, Floor-4th, Road-13, Block-I\",\"collectable_amount\":\"3660\",\"collected_amount\":\"0\",\"cod_fee\":36.6,\"delivery_fee\":\"60\",\"attempt\":0,\"updated_at\":\"2026-10-14T15:43:41+06:00\"}}', '2026-10-14 10:03:05'); -- -------------------------------------------------------- -- -- Table structure for table `sizes` -- CREATE TABLE `sizes` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sizes` -- INSERT INTO `sizes` (`id`, `name`, `slug`, `created_at`, `updated_at`, `created_by`, `deleted_at`) VALUES (1, 'S', 's', '2025-03-03 09:58:49', '2025-03-03 09:58:49', 1, NULL), (2, 'M', 'm', '2025-03-03 09:58:55', '2025-03-03 09:58:55', 1, NULL), (3, 'L', 'l', '2025-03-03 09:59:06', '2025-03-03 09:59:06', 1, NULL), (4, 'XL', 'xl', '2025-03-03 09:59:12', '2025-03-03 09:59:12', 1, NULL), (5, 'XXL', 'xxl', '2025-03-03 09:59:45', '2025-03-03 09:59:45', 1, NULL), (6, 'XS', 'xs', '2025-03-03 09:59:58', '2025-03-03 09:59:58', 1, NULL), (8, '3-4Y', '3-4y', '2026-10-07 06:54:26', '2026-10-07 06:54:26', 1, NULL), (9, '5-6Y', '5-6y', '2026-10-07 06:54:38', '2026-10-07 06:54:38', 1, NULL), (10, '7-8Y', '7-8y', '2026-10-07 06:54:52', '2026-10-07 06:54:52', 1, NULL), (11, '9-10Y', '9-10y', '2026-10-07 05:50:43', '2026-10-07 05:50:43', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `sliders` -- CREATE TABLE `sliders` ( `id` bigint UNSIGNED NOT NULL, `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `highlighted_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `caption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `highlighted_caption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redirect_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `button_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `sorting_serial` int NOT NULL DEFAULT '0', `created_by` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sliders` -- INSERT INTO `sliders` (`id`, `title`, `highlighted_title`, `caption`, `highlighted_caption`, `slug`, `image_path`, `redirect_link`, `button_name`, `status`, `sorting_serial`, `created_by`, `created_at`, `updated_at`) VALUES (1, 'Lifestyle Collection', 'For Traveling', 'Sale up to', '30% off', '1791216400-lifestyle-collection', 'assets/files/images/slider/1791216400-Winter-banner3.jpg', NULL, 'Shop Now', 'active', 6, 1, '2025-04-14 00:06:31', '2026-10-05 16:06:40'), (2, 'Just for you', 'Make your Travel products', 'Up to', '50% off', '1791215809-just-for-you', 'assets/files/images/slider/1791215809-Winter-Banner2.jpg', NULL, 'Shop Here', 'active', 5, 1, '2025-04-14 00:13:09', '2026-10-05 15:56:49'); -- -------------------------------------------------------- -- -- Table structure for table `slider_products` -- CREATE TABLE `slider_products` ( `id` bigint UNSIGNED NOT NULL, `slider_id` int NOT NULL, `product_id` int NOT NULL, `sorting_serial` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `slider_products` -- INSERT INTO `slider_products` (`id`, `slider_id`, `product_id`, `sorting_serial`, `created_at`, `updated_at`) VALUES (10, 1, 9, 1, '2025-04-14 08:31:12', '2026-03-05 10:55:49'), (12, 1, 11, 3, '2025-04-14 08:31:19', '2026-03-05 10:55:49'), (13, 1, 8, 2, '2025-04-14 08:31:23', '2026-03-05 10:55:49'); -- -------------------------------------------------------- -- -- Table structure for table `sub_categories` -- CREATE TABLE `sub_categories` ( `id` bigint UNSIGNED NOT NULL, `category_id` int NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `is_mega_menu` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `sorting_serial` int NOT NULL DEFAULT '1', `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sub_categories` -- INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `slug`, `icon`, `image`, `status`, `is_mega_menu`, `created_at`, `updated_at`, `created_by`, `sorting_serial`, `deleted_at`) VALUES (1, 4, 'KIDS', 'apparel-kids', 'assets/files/images/sub_category/1740842272-man.png', NULL, 'active', 'yes', '2025-03-01 09:17:52', '2026-10-15 09:16:56', 1, 1, NULL), (2, 3, 'Terracotta', 'traditional-terracotta', 'assets/files/images/sub_category/1740842289-man.png', NULL, 'active', 'yes', '2025-03-01 09:18:09', '2026-10-16 17:55:31', 1, 2, NULL), (3, 4, 'MENS', 'apparel-mens', 'assets/files/images/sub_category/1740842532-woman.png', NULL, 'active', 'yes', '2025-03-01 09:22:12', '2026-10-16 09:25:01', 1, 2, NULL), (4, 2, 'CASUAL DRESS', 'casual-dress', 'assets/files/images/sub_category/1740842559-woman.png', NULL, 'inactive', 'yes', '2025-03-01 09:22:39', '2026-10-15 09:16:04', 1, 2, NULL), (5, 1, 'TOP WEAR', 'top-wear', 'assets/files/images/sub_category/1740842289-man.png', NULL, 'inactive', 'yes', '2025-03-01 09:18:09', '2026-10-15 09:16:04', 1, 2, NULL), (6, 1, 'BOTTOM WEAR', 'bottom-wear', 'assets/files/images/sub_category/1740842289-man.png', NULL, 'inactive', 'yes', '2025-03-01 09:18:09', '2026-10-15 09:16:05', 1, 2, NULL), (7, 4, 'WOMENS', 'apparel-womens', NULL, NULL, 'active', 'yes', '2026-10-07 05:52:55', '2026-10-16 09:25:01', 1, 3, NULL); -- -------------------------------------------------------- -- -- Table structure for table `sub_category_banners` -- CREATE TABLE `sub_category_banners` ( `id` bigint UNSIGNED NOT NULL, `subcategory_id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sub_category_banners` -- INSERT INTO `sub_category_banners` (`id`, `subcategory_id`, `image`, `created_at`, `updated_at`) VALUES (1, 1, 'assets/files/images/category/1740845287-men_winter_1.png', '2025-03-01 10:08:07', '2025-03-01 10:08:07'), (2, 1, 'assets/files/images/category/1740845287-men_winter_2.png', '2025-03-01 10:08:07', '2025-03-01 10:08:07'), (3, 1, 'assets/files/images/category/1740845287-men_winter_3.png', '2025-03-01 10:08:07', '2025-03-01 10:08:07'), (4, 3, 'assets/files/images/category/1740846431-women_winter_1.png', '2025-03-01 10:27:11', '2025-03-01 10:27:11'), (5, 3, 'assets/files/images/category/1740846431-women_winter_2.png', '2025-03-01 10:27:11', '2025-03-01 10:27:11'), (6, 3, 'assets/files/images/category/1740846431-women_winter_3.png', '2025-03-01 10:27:11', '2025-03-01 10:27:11'), (10, 4, 'assets/files/images/category/1740846491-men_casual_1.png', '2025-03-01 10:28:11', '2025-03-01 10:28:11'), (11, 4, 'assets/files/images/category/1740846491-men_casual_2.png', '2025-03-01 10:28:11', '2025-03-01 10:28:11'), (12, 4, 'assets/files/images/category/1740846491-men_casual_3.png', '2025-03-01 10:28:11', '2025-03-01 10:28:11'); -- -------------------------------------------------------- -- -- Table structure for table `sub_subcategories` -- CREATE TABLE `sub_subcategories` ( `id` bigint UNSIGNED NOT NULL, `category_id` int NOT NULL, `subcategory_id` int NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `is_mega_menu` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `sorting_serial` int NOT NULL DEFAULT '1', `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sub_subcategories` -- INSERT INTO `sub_subcategories` (`id`, `category_id`, `subcategory_id`, `name`, `slug`, `icon`, `image`, `status`, `is_mega_menu`, `created_at`, `updated_at`, `created_by`, `sorting_serial`, `deleted_at`) VALUES (1, 4, 1, 'HOODIE SET', 'apparel-kids-hoodie-set', 'assets/files/images/sub_category/1740843629-man.png', NULL, 'active', 'yes', '2025-03-01 09:40:30', '2026-10-16 09:25:17', 1, 2, NULL), (2, 1, 1, 'Rompers and Jumpsuits', 'men-winter-rompers-and-jumpsuits', 'assets/files/images/sub_sub_category/1741017364-clothing.png', NULL, 'inactive', 'yes', '2025-03-03 09:56:04', '2026-10-15 09:18:02', 1, 2, NULL), (3, 4, 1, 'SWEATSHIRTS', 'apparel-kids-sweatshirts', 'assets/files/images/sub_sub_category/1741017423-office-wear.png', NULL, 'active', 'yes', '2025-03-03 09:57:03', '2026-10-15 09:25:25', 1, 1, NULL), (4, 4, 1, 'Girls Top', 'apparel-kids-girls-top', 'assets/files/images/sub_sub_category/1741017484-woman.png', NULL, 'active', 'yes', '2025-03-03 09:58:04', '2026-10-16 17:25:05', 1, 1, NULL), (5, 2, 3, 'Rompers and Jumpsuits', 'women-winter-rompers-and-jumpsuits', 'assets/files/images/sub_sub_category/1741087393-woman.png', NULL, 'inactive', 'yes', '2025-03-04 05:23:13', '2026-10-15 09:18:02', 1, 2, NULL), (6, 2, 4, 'DRESSES', 'women-casual-dress-dresses', 'assets/files/images/sub_sub_category/1741088951-clothing.png', NULL, 'inactive', 'yes', '2025-03-04 05:49:11', '2026-10-15 09:18:00', 1, 1, NULL), (7, 1, 5, 'DRESSES', 'men-winter-dresses', 'assets/files/images/sub_category/1740843629-man.png', NULL, 'inactive', 'yes', '2025-03-01 09:40:30', '2026-10-15 09:18:00', 1, 1, NULL), (8, 1, 6, 'T-SHIRTS and Vests', 'men-casual-dress-t-shirts-and-vests', 'assets/files/images/sub_sub_category/1741017423-office-wear.png', NULL, 'inactive', 'yes', '2025-03-03 09:57:03', '2026-10-15 09:18:01', 1, 1, NULL), (9, 1, 2, 'Rompers and Jumpsuits', 'men-winter-rompers-and-jumpsuits', 'assets/files/images/sub_sub_category/1741017364-clothing.png', NULL, 'inactive', 'yes', '2025-03-03 09:56:04', '2026-10-15 09:18:05', 1, 2, NULL); -- -------------------------------------------------------- -- -- Table structure for table `sub_sub_category_banners` -- CREATE TABLE `sub_sub_category_banners` ( `id` bigint UNSIGNED NOT NULL, `sub_subcategory_id` int NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sub_sub_category_banners` -- INSERT INTO `sub_sub_category_banners` (`id`, `sub_subcategory_id`, `image`, `created_at`, `updated_at`) VALUES (1, 1, 'assets/files/images/sub_sub_category/1741017277-men_winter_1.png', '2025-03-03 09:53:23', '2025-03-03 09:54:37'), (2, 1, 'assets/files/images/sub_sub_category/1741017203-men_casual_2.png', '2025-03-03 09:53:23', '2025-03-03 09:53:23'), (3, 2, 'assets/files/images/sub_sub_category/1741017364-men1.png', '2025-03-03 09:56:04', '2025-03-03 09:56:04'), (4, 2, 'assets/files/images/sub_sub_category/1741017364-men3.png', '2025-03-03 09:56:04', '2025-03-03 09:56:04'), (5, 3, 'assets/files/images/sub_sub_category/1741017423-men2.png', '2025-03-03 09:57:03', '2025-03-03 09:57:03'), (6, 4, 'assets/files/images/sub_sub_category/1741017484-women_winter_1.png', '2025-03-03 09:58:05', '2025-03-03 09:58:05'), (7, 4, 'assets/files/images/sub_sub_category/1741017485-women_winter_2.png', '2025-03-03 09:58:05', '2025-03-03 09:58:05'), (8, 4, 'assets/files/images/sub_sub_category/1741017485-women_winter_3.png', '2025-03-03 09:58:05', '2025-03-03 09:58:05'), (9, 5, 'assets/files/images/sub_sub_category/1741087393-women1.png', '2025-03-04 05:23:13', '2025-03-04 05:23:13'), (10, 5, 'assets/files/images/sub_sub_category/1741087393-women2.png', '2025-03-04 05:23:13', '2025-03-04 05:23:13'), (11, 5, 'assets/files/images/sub_sub_category/1741087393-women3.png', '2025-03-04 05:23:13', '2025-03-04 05:23:13'), (12, 6, 'assets/files/images/sub_sub_category/1741088951-women1.png', '2025-03-04 05:49:11', '2025-03-04 05:49:11'), (13, 6, 'assets/files/images/sub_sub_category/1741088951-women1.png', '2025-03-04 05:49:11', '2025-03-04 05:49:11'), (14, 6, 'assets/files/images/sub_sub_category/1741088951-women3.png', '2025-03-04 05:49:11', '2025-03-04 05:49:11'); -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tags` -- INSERT INTO `tags` (`id`, `name`, `slug`, `created_at`, `updated_at`, `created_by`, `deleted_at`) VALUES (1, 'ROMPERS', 'rompers', '2025-03-03 10:15:52', '2025-03-03 10:15:52', 1, NULL), (2, 'JUMPSUITS', 'jumpsuits', '2025-03-03 10:16:00', '2025-03-03 10:16:00', 1, NULL), (3, 'ONE PIECE', 'one-piece', '2025-03-04 05:50:04', '2025-03-04 05:50:04', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `todos` -- CREATE TABLE `todos` ( `id` bigint UNSIGNED NOT NULL, `admin_id` bigint UNSIGNED NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `priority` enum('low','medium','high') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium', `status` enum('pending','in_progress','done') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `due_date` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` bigint UNSIGNED NOT NULL, `user_id` int NOT NULL, `order_id` int NOT NULL, `unique_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `gateway` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `transaction_invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `transaction_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `transaction_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `transaction_amount` double(8,2) NOT NULL, `vat` double(8,2) DEFAULT NULL, `store_amount` double(8,2) DEFAULT NULL, `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `currency_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency_rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `val_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_tran_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `transaction_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `error` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_issuer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_sub_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_issuer_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_issuer_country_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `store_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `verify_sign` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `verify_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `verify_sign_sha2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `base_fair` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `risk_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `risk_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city_town` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `post_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `user_id`, `order_id`, `unique_id`, `order_number`, `invoice`, `gateway`, `transaction_id`, `transaction_invoice`, `transaction_time`, `transaction_ip`, `transaction_amount`, `vat`, `store_amount`, `currency`, `currency_type`, `currency_amount`, `currency_rate`, `status`, `message`, `val_id`, `card_type`, `card_no`, `bank_tran_id`, `transaction_date`, `error`, `card_issuer`, `card_brand`, `card_sub_brand`, `card_issuer_country`, `card_issuer_country_code`, `store_id`, `verify_sign`, `verify_key`, `verify_sign_sha2`, `base_fair`, `risk_level`, `risk_title`, `name`, `mobile`, `city_town`, `post_code`, `address`, `created_at`, `updated_at`) VALUES (1, 6, 24, 'D2QBMKAWZD', '0024', 'RT-65618643', 'sslcommerz', '683C4C5DAAEA5', NULL, '2025-06-01 18:49:35', '127.0.0.1', 460.00, NULL, 448.50, 'BDT', 'BDT', '460.00', '1.0000', 'SUCCESS', 'Issuer Bank Declined', '250601185018IpDeCqooCZ4UHjH', 'VISA-Dutch Bangla', '418117XXXXXX7814', '25060118501819XheDz2UfxpDmL', '2025-06-01 18:49:35', NULL, 'TRUST BANK, LTD.', 'VISA', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', 'd5a9205f482d9925b7219d9536515693', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '91d2f3c8b6de38a61f89dfd3e1b0da3349134537c9bcc74d72901b0256e3c0f5', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-06-01 06:49:33', '2025-06-01 06:50:21'), (2, 6, 23, 'F62Y5JV0BP', '0023', 'RT-43209725', 'sslcommerz', '683C4C93C173E', NULL, '2025-06-01 12:50:27', '127.0.0.1', 4260.00, NULL, 4153.50, 'BDT', 'BDT', '4260.00', '1.0000', 'FAILED', '3D Security Validation Failed', '25060122541BudQPfDcJdwYsS7', 'BKASH-BKash', NULL, '250601225410mTuCYJekMB6XQu', NULL, NULL, 'BKash Mobile Banking', 'MOBILEBANKING', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', '391c700bd4e96f25b353d3c98937043e', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '5154d2f8c0bf5ceb1b6c61141d9fca55a42c77fca981dd82d45e73a2622374ef', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-06-01 06:50:27', '2025-06-01 06:51:22'), (3, 6, 22, 'ZBKFXEQKAI', '0022', 'RT-84286112', 'sslcommerz', '683C11598D7B3', NULL, '2025-06-01 08:37:45', '::1', 4260.00, NULL, 4153.50, 'BDT', 'BDT', '4260.00', '1.0000', 'FAILED', 'Do not honor', '250601225531nfRj7ng7iRhDQP', 'DBBLMOBILEB-Dbbl Mobile Banking', NULL, '2506012255318TAeHJ9kuLF3E8', NULL, NULL, 'DBBL Mobile Banking', 'MOBILEBANKING', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', '474c9ff8b132478ee81783d6d8389477', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '5db700f00d05fe8a827b2f67643bcdf083c59f4ae4b1cfba3f419b3b75b4d4c5', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-06-01 02:37:45', '2025-06-01 02:37:54'), (4, 6, 21, 'C4NEVLHXNG', '0021', 'RT-81578206', 'sslcommerz', '683B6703094FD', NULL, '2025-06-01 02:31:01', '::1', 4260.00, NULL, 4153.50, 'BDT', 'BDT', '4260.00', '1.0000', 'SUCCESS', '', '250601233110jDiUxlkbDpMeey', 'VISA-Dutch Bangla', '432149XXXXXX0667', '250601233111kWCHj7bd2JHtBg', '2025-06-01 02:31:01', NULL, 'BRAC BANK, LTD.', 'VISA', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', 'a413c72c59208c78285d0fb365bded51', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '7ade6952dbbbedf91235872b4b606a97c13278e10ff5c4a54b0807085e083b04', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-05-31 14:30:59', '2025-05-31 14:33:21'), (5, 6, 19, 'MPIWUNSCFI', '0019', 'RT-53878240', NULL, '683C0C217B8B8', NULL, '2025-06-01 08:15:29', '::1', 2400.00, NULL, NULL, 'BDT', NULL, NULL, NULL, 'PENDING', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-06-01 02:15:29', '2025-06-01 02:15:29'), (6, 6, 25, 'UXPRLA1MRO', '0025', 'RT-86409952', 'sslcommerz', '687004082923B', NULL, '2025-07-11 00:18:50', '::1', 1224.00, NULL, 1193.40, 'BDT', 'BDT', '1224.00', '1.0000', 'SUCCESS', NULL, '250711019021SmS35gUPebqFpe', 'VISA-Dutch Bangla', '421481XXXXXX4177', '25071101902DCscb4IM9U6jF3t', '2025-07-11 00:18:50', NULL, 'STANDARD CHARTERED BANK', 'VISA', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', '68c634837202e4cbd2b236be588951e4', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '9b8bc52933d57e5cdd9b2598fe70dd3ea11dd1411f97c9d908c18c809614bfbb', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-07-10 12:18:48', '2025-07-10 12:19:03'), (7, 6, 20, 'TY49VZJWVA', '0020', 'RT-24545298', 'sslcommerz', '683C713B82739', NULL, '2025-06-01 21:26:53', '127.0.0.1', 2400.00, NULL, 2340.00, 'BDT', 'BDT', '2400.00', '1.0000', 'SUCCESS', NULL, '2506012127310Bo50X03PrIq6bi', 'VISA-Dutch Bangla', '432149XXXXXX0667', '2506012127310nN8WgpeDKhlbMI', '2025-06-01 21:26:53', NULL, 'BRAC BANK, LTD.', 'VISA', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', '972ff3b5f66e340b72e8c1184bc886dd', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '44303799e743e0d40d69888d5b7dbc10b2063b9a58918ab7d58a1877087dc861', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-06-01 09:26:51', '2025-06-01 09:27:33'), (8, 6, 27, '06ZXJDCPYW', '0027', 'RT-47764322', 'sslcommerz', '683DD6C2531B7', NULL, '2025-06-02 22:52:20', '::1', 3060.00, NULL, 2983.50, 'BDT', 'BDT', '3060.00', '1.0000', 'SUCCESS', NULL, '250602225326106D5e55QlxoQTo', 'BKASH-BKash', NULL, '250602225326XNeowcAhh7ItFpM', '2025-06-02 22:52:20', NULL, 'BKash Mobile Banking', 'MOBILEBANKING', 'Classic', 'Bangladesh', 'BD', 'mobix615553a06cc1f', '4729dc27cfaff7a6dbdd3adc0c1e91a2', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '410b9f178921b93b0c0f2ddc4acc887b3d0c4834e29d294b6de2eac8d973f41b', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2025-06-02 10:52:18', '2025-06-02 10:53:28'), (9, 6, 56, 'RHZLQUHFVQ', '0025', 'RT-77549399', NULL, '6AC732F77EF6F', NULL, '2026-10-08 06:06:47', '172.21.0.1', 0.00, NULL, NULL, 'BDT', NULL, NULL, NULL, 'PENDING', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2026-10-08 06:06:47', '2026-10-08 06:06:47'), (10, 6, 57, 'I28FDP93SJ', '0026', 'RT-36465350', 'sslcommerz', '6AC733D631485', NULL, '2026-10-08 12:10:30', '172.21.0.1', 929.00, NULL, 905.78, 'BDT', 'BDT', '929.00', '1.0000', 'SUCCESS', NULL, '261008121133ggGFLfO82aEU3nN', 'BKASH-BKash', NULL, '2610081211332qkfvICdMm9cP3e', '2026-10-08 12:10:30', NULL, 'BKash Mobile Banking', 'MOBILEBANKING', 'Classic', 'Bangladesh', 'BD', 'boich6ac72bc8bab15', 'ae47e5e6d21fb3af3626e4b23f6f0b28', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '589e338007a55f6b5debe61721044a38118347a38b8e8edf3ca6dc09293a7ea0', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2026-10-08 06:10:30', '2026-10-08 06:11:39'), (11, 6, 58, 'MK8TNWGI1K', '0027', 'RT-44269846', 'sslcommerz', '6AC7348F9B1C6', NULL, '2026-10-08 12:13:36', '172.21.0.1', 3448.00, NULL, 3361.80, 'BDT', 'BDT', '3448.00', '1.0000', 'SUCCESS', NULL, '261008122122AaKBCkzGuAMpZut', 'VISA-Dutch Bangla', '421481XXXXXX4177', '2610081221226feWTR2rW7MMUvo', '2026-10-08 12:13:36', NULL, 'STANDARD CHARTERED BANK', 'VISA', 'Classic', 'Bangladesh', 'BD', 'boich6ac72bc8bab15', 'd6f505de08baa2536f8d480a94ed4221', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', 'f862f9f1f70e2bc50a32dffcdaa5c133a587bb3ce2c4be9db41041303cdaa685', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2026-10-08 06:13:35', '2026-10-08 06:21:27'), (12, 6, 55, 'FEK9B3T73I', '0024', 'RT-44954795', 'sslcommerz', '6AC7410997026', NULL, '2026-10-08 13:06:49', '172.21.0.1', 674.00, NULL, 657.15, 'BDT', 'BDT', '674.00', '1.0000', 'SUCCESS', NULL, '2610081306572daFF6e807ioq2E', 'BKASH-BKash', NULL, '261008130657oQoZ8hAa3bQMbrT', '2026-10-08 13:06:49', NULL, 'BKash Mobile Banking', 'MOBILEBANKING', 'Classic', 'Bangladesh', 'BD', 'boich6ac72bc8bab15', '652685d35272a8fafb98c2d100f34e2d', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '07cee6548a08ad66f9839473247a456dd0058240b10cd5869e4a74a3dd1bd289', '0.00', '0', 'Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2026-10-08 07:06:49', '2026-10-08 07:07:02'), (13, 6, 62, 'OR0GO5GRPL', '0031', 'RT-92459738', 'sslcommerz', '6ACD0691F3C70', NULL, '2026-10-12 22:10:58', '172.21.0.1', 755.00, NULL, 736.13, 'BDT', 'BDT', '755.00', '1.0000', 'SUCCESS', NULL, '261012221234kYMd1PleMsZscUD', 'VISA-Dutch Bangla', '450850******4050', '26101222123427m1G9zAjrOc2qD', '2026-10-12 22:10:58', NULL, 'CAJA DE AHORROS Y PENSIONES DE BARCELONA(LA CAIXA)', 'VISA', 'Classic', 'Spain', 'ES', 'boich6ac72bc8bab15', 'f87d7574661f76bae90670f76321ad19', 'amount,bank_tran_id,base_fair,card_brand,card_issuer,card_issuer_country,card_issuer_country_code,card_no,card_sub_brand,card_type,currency,currency_amount,currency_rate,currency_type,error,risk_level,risk_title,status,store_amount,store_id,tran_date,tran_id,val_id,value_a,value_b,value_c,value_d', '91a56807141f296c09ac1d8873c8106ce554be4b1bd4467cbc294611e179f191', '0.00', '1', 'Not Safe', 'Stewart Sanford', '01609605491', 'Eligendi occaecat es', '5256', 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '2026-10-12 16:10:57', '2026-10-12 16:12:41'); -- -------------------------------------------------------- -- -- Table structure for table `units` -- CREATE TABLE `units` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `units` -- INSERT INTO `units` (`id`, `name`, `slug`, `created_at`, `updated_at`, `created_by`, `deleted_at`) VALUES (1, 'PIECE', 'piece', '2025-03-03 10:02:53', '2025-03-03 10:02:53', 1, NULL), (2, 'BUNDLE', 'bundle', '2025-03-03 10:03:05', '2025-03-03 10:03:05', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `first_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mobile_verified_at` timestamp NULL DEFAULT NULL, `district_id` int DEFAULT NULL, `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `zip_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `home_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `delivery_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `google_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instagram_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `need_change_mobile` tinyint(1) NOT NULL DEFAULT '0', `need_change_password` tinyint(1) NOT NULL DEFAULT '0', `verification_code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `email_verified_at`, `mobile`, `mobile_verified_at`, `district_id`, `city`, `zip_code`, `home_address`, `delivery_address`, `password`, `remember_token`, `image`, `status`, `created_at`, `updated_at`, `deleted_at`, `google_id`, `facebook_id`, `instagram_id`, `need_change_mobile`, `need_change_password`, `verification_code`) VALUES (1, 'Yoshi', 'Tillman', 'rike@mailinator.com', NULL, '01609605494', NULL, 1, 'Eligendi occaecat es', '26367', NULL, 'Voluptas non et quis', '$2y$10$y61CaR4AuaXQk/xNE1gL/ek0Kul.9en66EC0qj7pZnuWwGJdPn61u', NULL, NULL, 'active', '2025-04-27 08:45:57', '2025-05-06 07:27:01', NULL, NULL, NULL, NULL, 0, 0, NULL), (5, 'MD', 'RAJU', 'raju.eatl.nu@gmail.com', '2025-05-08 10:24:19', 'google21830', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$iwB/rOBQcGFLCAu789V4QeQQgG.hpWJt4YAOP7XtOQeInazZxhz8m', NULL, NULL, 'active', '2025-05-07 10:28:59', '2025-05-08 10:24:19', NULL, '101401432118761020988', NULL, NULL, 1, 1, NULL), (6, 'Stewart', 'Sanford', 'mkraju.eatl@gmail.com', '2025-08-11 11:05:12', '01609605491', '2025-06-01 06:41:42', 1, 'Eligendi occaecat es', '5256', NULL, 'Shibu lichu bagan, Baruahat, Kaunia, Rangpur', '$2y$10$BDQqs8rIORIVbxtq3EtoROHifTgm2fkFhCiiEzXoZnZm7DSxFijge', 'MWTXvo4vbe4T24TIfoyGP06ywIEvtTvg7qU1qkNTNEHrig8MCkl9RXYXNMur', NULL, 'active', '2025-05-07 11:02:17', '2025-08-11 11:05:12', NULL, NULL, '122103821372861332', NULL, 0, 0, NULL), (7, 'Moktadirul', 'Raju', 'moktadirulraju@gmail.com', '2025-05-18 10:40:56', 'google14616', NULL, NULL, NULL, NULL, NULL, NULL, '$2y$10$oCQk8jUGK4P/E8S8caoAmOMxPCxNWldmFXxRqGovrkCaXAzY8yWxm', NULL, NULL, 'active', '2025-05-18 10:40:56', NULL, NULL, '111616602669580760558', NULL, NULL, 1, 1, NULL), (8, 'Gage', 'Delacruz', 'nahixekony@mailinator.com', NULL, '01737773393', NULL, 2, 'Nostrud voluptates d', '33979', NULL, 'Ut consequatur excep', '$2y$10$P7TQ5RnE136UsXoelu.rWuGYZmfkWsgZTsY6i2ChidXcCs5cM0oqS', NULL, NULL, 'active', '2025-08-29 01:35:32', '2025-08-29 01:35:32', NULL, NULL, NULL, NULL, 0, 0, NULL), (9, 'Mohsin', 'Ali', 'ami.mohsin@gmail.com', NULL, '01719540019', NULL, 1, 'Bashundhara', '1229', NULL, 'House-884, Floor-4th, Road-13, Block-I', '$2y$10$4inhOl75YB15siZmDH9qpuz02q48nJBeUsfo3xVmU5gRF/D.fmED.', 'UhzWHtcHZZDZCALGeezO9VJjniCzryS1DzSX2YVULJc5L6WgM4cn8KAfxsx5', NULL, 'active', '2026-10-10 18:53:37', '2026-10-10 18:53:37', NULL, NULL, NULL, NULL, 0, 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `vendor_payouts` -- CREATE TABLE `vendor_payouts` ( `id` bigint UNSIGNED NOT NULL, `seller_id` bigint UNSIGNED NOT NULL, `amount` double(8,2) NOT NULL, `status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `admin_id` bigint UNSIGNED DEFAULT NULL COMMENT 'ID of admin who approved/rejected', `transaction_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instructions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wishlists` -- CREATE TABLE `wishlists` ( `id` bigint UNSIGNED NOT NULL, `user_id` int NOT NULL, `product_id` int NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wishlists` -- INSERT INTO `wishlists` (`id`, `user_id`, `product_id`, `created_at`, `updated_at`) VALUES (5, 6, 10, '2025-07-23 12:27:09', '2025-07-23 12:27:09'), (8, 6, 11, '2026-10-05 18:02:07', '2026-10-05 18:02:07'), (9, 6, 18, '2026-10-09 15:27:15', '2026-10-09 15:27:15'), (10, 9, 21, '2026-10-16 18:58:22', '2026-10-16 18:58:22'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`), ADD UNIQUE KEY `admins_mobile_unique` (`mobile`); -- -- Indexes for table `admin_notifications` -- ALTER TABLE `admin_notifications` ADD PRIMARY KEY (`id`), ADD KEY `admin_notifications_admin_id_is_read_index` (`admin_id`,`is_read`), ADD KEY `admin_notifications_created_at_index` (`created_at`); -- -- Indexes for table `announcements` -- ALTER TABLE `announcements` ADD PRIMARY KEY (`id`); -- -- Indexes for table `brands` -- ALTER TABLE `brands` ADD PRIMARY KEY (`id`); -- -- Indexes for table `brand_banners` -- ALTER TABLE `brand_banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category_banners` -- ALTER TABLE `category_banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `colors` -- ALTER TABLE `colors` ADD PRIMARY KEY (`id`); -- -- Indexes for table `coupons` -- ALTER TABLE `coupons` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `coupons_coupon_code_unique` (`coupon_code`); -- -- Indexes for table `delivery_charges` -- ALTER TABLE `delivery_charges` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expenses` -- ALTER TABLE `expenses` ADD PRIMARY KEY (`id`), ADD KEY `expenses_admin_id_expense_date_index` (`admin_id`,`expense_date`); -- -- Indexes for table `expense_categories` -- ALTER TABLE `expense_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `join_requests` -- ALTER TABLE `join_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `latest_offer_products` -- ALTER TABLE `latest_offer_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `new_in_products` -- ALTER TABLE `new_in_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `orders_unique_id_unique` (`unique_id`), ADD UNIQUE KEY `orders_order_number_unique` (`order_number`), ADD UNIQUE KEY `orders_invoice_unique` (`invoice`); -- -- Indexes for table `order_products` -- ALTER TABLE `order_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_transactions` -- ALTER TABLE `order_transactions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `order_transactions_transaction_number_unique` (`transaction_number`), ADD KEY `order_transactions_order_id_type_index` (`order_id`,`type`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `products_slug_unique` (`slug`), ADD UNIQUE KEY `products_product_code_unique` (`product_code`); ALTER TABLE `products` ADD FULLTEXT KEY `products_name_fulltext` (`name`); -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_types` -- ALTER TABLE `product_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_type_categories` -- ALTER TABLE `product_type_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_variants` -- ALTER TABLE `product_variants` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchases` -- ALTER TABLE `purchases` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `purchases_purchase_number_unique` (`purchase_number`), ADD KEY `purchases_purchase_date_index` (`purchase_date`), ADD KEY `purchases_product_id_index` (`product_id`), ADD KEY `purchases_variant_id_index` (`variant_id`); -- -- Indexes for table `refund_requests` -- ALTER TABLE `refund_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `return_requests` -- ALTER TABLE `return_requests` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `return_requests_return_number_unique` (`return_number`), ADD KEY `return_requests_shipment_id_foreign` (`shipment_id`), ADD KEY `return_requests_order_id_shipment_id_index` (`order_id`,`shipment_id`), ADD KEY `return_requests_status_index` (`status`); -- -- Indexes for table `return_request_items` -- ALTER TABLE `return_request_items` ADD PRIMARY KEY (`id`), ADD KEY `return_request_items_order_product_id_foreign` (`order_product_id`), ADD KEY `return_request_items_return_request_id_inspection_status_index` (`return_request_id`,`inspection_status`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_unique` (`name`); -- -- Indexes for table `section_products` -- ALTER TABLE `section_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `seller_order_logs` -- ALTER TABLE `seller_order_logs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `seller_order_logs_seller_id_order_id_order_number_invoice_unique` (`seller_id`,`order_id`,`order_number`,`invoice`); -- -- Indexes for table `seller_shops` -- ALTER TABLE `seller_shops` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `seller_shops_email_unique` (`email`), ADD UNIQUE KEY `seller_shops_mobile_unique` (`mobile`), ADD UNIQUE KEY `seller_shops_phone_unique` (`phone`); -- -- Indexes for table `shipments` -- ALTER TABLE `shipments` ADD PRIMARY KEY (`id`), ADD KEY `shipments_order_id_seller_id_index` (`order_id`,`seller_id`), ADD KEY `shipments_consignment_id_index` (`consignment_id`), ADD KEY `shipments_tracking_code_index` (`tracking_code`), ADD KEY `shipments_status_index` (`status`); -- -- Indexes for table `shipment_logs` -- ALTER TABLE `shipment_logs` ADD PRIMARY KEY (`id`), ADD KEY `shipment_logs_shipment_id_event_index` (`shipment_id`,`event`); -- -- Indexes for table `sizes` -- ALTER TABLE `sizes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sliders` -- ALTER TABLE `sliders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `slider_products` -- ALTER TABLE `slider_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_categories` -- ALTER TABLE `sub_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_category_banners` -- ALTER TABLE `sub_category_banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_subcategories` -- ALTER TABLE `sub_subcategories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_sub_category_banners` -- ALTER TABLE `sub_sub_category_banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tags` -- ALTER TABLE `tags` ADD PRIMARY KEY (`id`); -- -- Indexes for table `todos` -- ALTER TABLE `todos` ADD PRIMARY KEY (`id`), ADD KEY `todos_admin_id_status_index` (`admin_id`,`status`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `units` -- ALTER TABLE `units` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_mobile_unique` (`mobile`); -- -- Indexes for table `vendor_payouts` -- ALTER TABLE `vendor_payouts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wishlists` -- ALTER TABLE `wishlists` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `admin_notifications` -- ALTER TABLE `admin_notifications` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- AUTO_INCREMENT for table `announcements` -- ALTER TABLE `announcements` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `brands` -- ALTER TABLE `brands` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `brand_banners` -- ALTER TABLE `brand_banners` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `category_banners` -- ALTER TABLE `category_banners` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `colors` -- ALTER TABLE `colors` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `coupons` -- ALTER TABLE `coupons` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `delivery_charges` -- ALTER TABLE `delivery_charges` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `expenses` -- ALTER TABLE `expenses` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `expense_categories` -- ALTER TABLE `expense_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61; -- -- AUTO_INCREMENT for table `join_requests` -- ALTER TABLE `join_requests` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `latest_offer_products` -- ALTER TABLE `latest_offer_products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91; -- -- AUTO_INCREMENT for table `new_in_products` -- ALTER TABLE `new_in_products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67; -- -- AUTO_INCREMENT for table `order_products` -- ALTER TABLE `order_products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144; -- -- AUTO_INCREMENT for table `order_transactions` -- ALTER TABLE `order_transactions` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51; -- -- AUTO_INCREMENT for table `product_types` -- ALTER TABLE `product_types` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `product_type_categories` -- ALTER TABLE `product_type_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `product_variants` -- ALTER TABLE `product_variants` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `purchases` -- ALTER TABLE `purchases` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `refund_requests` -- ALTER TABLE `refund_requests` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `return_requests` -- ALTER TABLE `return_requests` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `return_request_items` -- ALTER TABLE `return_request_items` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `section_products` -- ALTER TABLE `section_products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `seller_order_logs` -- ALTER TABLE `seller_order_logs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `seller_shops` -- ALTER TABLE `seller_shops` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `shipments` -- ALTER TABLE `shipments` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `shipment_logs` -- ALTER TABLE `shipment_logs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70; -- -- AUTO_INCREMENT for table `sizes` -- ALTER TABLE `sizes` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `sliders` -- ALTER TABLE `sliders` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `slider_products` -- ALTER TABLE `slider_products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `sub_categories` -- ALTER TABLE `sub_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `sub_category_banners` -- ALTER TABLE `sub_category_banners` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `sub_subcategories` -- ALTER TABLE `sub_subcategories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `sub_sub_category_banners` -- ALTER TABLE `sub_sub_category_banners` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `tags` -- ALTER TABLE `tags` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `todos` -- ALTER TABLE `todos` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `units` -- ALTER TABLE `units` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `vendor_payouts` -- ALTER TABLE `vendor_payouts` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wishlists` -- ALTER TABLE `wishlists` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- Constraints for dumped tables -- -- -- Constraints for table `order_transactions` -- ALTER TABLE `order_transactions` ADD CONSTRAINT `order_transactions_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE; -- -- Constraints for table `return_requests` -- ALTER TABLE `return_requests` ADD CONSTRAINT `return_requests_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `return_requests_shipment_id_foreign` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE CASCADE; -- -- Constraints for table `return_request_items` -- ALTER TABLE `return_request_items` ADD CONSTRAINT `return_request_items_order_product_id_foreign` FOREIGN KEY (`order_product_id`) REFERENCES `order_products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `return_request_items_return_request_id_foreign` FOREIGN KEY (`return_request_id`) REFERENCES `return_requests` (`id`) ON DELETE CASCADE; -- -- Constraints for table `shipments` -- ALTER TABLE `shipments` ADD CONSTRAINT `shipments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE; -- -- Constraints for table `shipment_logs` -- ALTER TABLE `shipment_logs` ADD CONSTRAINT `shipment_logs_shipment_id_foreign` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;