-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1:3308
-- Tiempo de generación: 06-06-2026 a las 01:10:27
-- Versión del servidor: 10.4.32-MariaDB
-- Versión de PHP: 8.2.12

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 */;

--
-- Base de datos: `perfumes`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `categorias`
--

CREATE TABLE `categorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `descripcion` text DEFAULT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `categorias`
--

INSERT INTO `categorias` (`id`, `nombre`, `descripcion`, `estado`, `created_at`, `updated_at`) VALUES
(1, 'FEMENINAS ARABE', NULL, 1, '2026-04-04 02:53:34', '2026-06-03 23:14:48'),
(2, 'FEMENINAS TRADICIONALES', NULL, 1, '2026-04-04 02:51:24', '2026-06-04 01:50:05'),
(3, 'MASCULINAS ARABE', NULL, 1, '2026-06-04 02:00:34', '2026-06-04 02:00:34'),
(4, 'MASCULINAS TRADICIONALES', NULL, 1, '2026-06-04 02:23:31', '2026-06-04 02:23:31'),
(6, 'AMBIENTADORES E HIDROSOLUBLES', NULL, 1, '2026-06-04 02:36:43', '2026-06-04 02:36:43');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `clientes`
--

CREATE TABLE `clientes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `apellido` varchar(255) NOT NULL,
  `documento` varchar(255) NOT NULL,
  `telefono` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `direccion` text DEFAULT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `clientes`
--

INSERT INTO `clientes` (`id`, `nombre`, `apellido`, `documento`, `telefono`, `email`, `direccion`, `estado`, `created_at`, `updated_at`) VALUES
(1, 'Sebastian', 'gonzalez', '43434', '3215379193', 'master34cool@gmail.com', 'Calle 62b #1a 980', 1, '2026-04-04 05:13:00', '2026-04-04 05:13:00'),
(2, 'juliana', 'vela', '11152565', '3028533966', 'sebasgonzalezmartinez@hotmail.com', 'kjkjkjkk', 1, '2026-04-04 05:15:21', '2026-04-04 05:15:21');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `compras`
--

CREATE TABLE `compras` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `numero_compra` varchar(255) NOT NULL,
  `proveedor_id` bigint(20) UNSIGNED NOT NULL,
  `fecha_compra` date NOT NULL,
  `total` decimal(12,2) NOT NULL,
  `estado` enum('pendiente','completada','cancelada') NOT NULL DEFAULT 'completada',
  `observaciones` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `compras`
--

INSERT INTO `compras` (`id`, `numero_compra`, `proveedor_id`, `fecha_compra`, `total`, `estado`, `observaciones`, `created_at`, `updated_at`) VALUES
(1, 'COMP-000001', 1, '2026-04-04', 80000.00, 'completada', NULL, '2026-04-04 08:43:41', '2026-04-04 08:43:41'),
(2, 'COMP-000002', 1, '2026-04-04', 1500000.00, 'completada', NULL, '2026-04-04 08:49:38', '2026-04-04 08:49:38'),
(3, 'COMP-000003', 1, '2026-04-04', 5700000.00, 'completada', NULL, '2026-04-04 23:49:16', '2026-04-04 23:49:16');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `compra_costos`
--

CREATE TABLE `compra_costos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `compra_id` bigint(20) UNSIGNED NOT NULL,
  `concepto` varchar(200) NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `compra_detalles`
--

CREATE TABLE `compra_detalles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `compra_id` bigint(20) UNSIGNED NOT NULL,
  `producto_id` bigint(20) UNSIGNED NOT NULL,
  `cantidad` int(11) NOT NULL,
  `precio_unitario` decimal(12,2) NOT NULL,
  `subtotal` decimal(12,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2026_04_03_214019_create_categorias_table', 1),
(6, '2026_04_03_214340_create_productos_table', 1),
(7, '2026_04_04_000712_create_clientes_table', 2),
(8, '2026_04_04_001624_create_proveedors_table', 3),
(9, '2026_04_04_002615_create_compras_table', 4),
(10, '2026_04_04_002621_create_compra_detalles_table', 4),
(11, '2026_04_04_041950_create_ventas_table', 5),
(12, '2026_04_04_041952_create_venta_detalles_table', 5),
(13, '2026_04_07_185147_create_compra_costos_table', 6),
(14, '2026_04_07_185618_create_producto_costos_table', 7),
(15, '2026_06_03_174832_remove_old_fields_from_productos_table', 8),
(16, '2026_06_03_174841_add_excel_fields_to_productos_table', 8),
(17, '2026_06_05_195439_create_productos_terminados_tables', 9);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `productos`
--

CREATE TABLE `productos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `codigo` varchar(50) DEFAULT NULL,
  `nombre` varchar(200) NOT NULL,
  `fragancia` varchar(200) NOT NULL,
  `presentacion` varchar(100) DEFAULT NULL,
  `categoria_id` bigint(20) UNSIGNED NOT NULL,
  `costo_1k` decimal(12,2) NOT NULL DEFAULT 0.00,
  `iva_19` decimal(12,2) NOT NULL DEFAULT 0.00,
  `costo_1k_con_iva` decimal(12,2) NOT NULL DEFAULT 0.00,
  `costo_gr` decimal(12,2) NOT NULL DEFAULT 0.00,
  `costo_frag_cf_cv` decimal(12,2) NOT NULL DEFAULT 0.00,
  `precio_30` decimal(12,2) NOT NULL DEFAULT 0.00,
  `precio_50` decimal(12,2) NOT NULL DEFAULT 0.00,
  `precio_75` decimal(12,2) NOT NULL DEFAULT 0.00,
  `precio_100` decimal(12,2) NOT NULL DEFAULT 0.00,
  `stock_actual` int(11) NOT NULL DEFAULT 0,
  `stock_minimo` int(11) NOT NULL DEFAULT 0,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `productos`
--

INSERT INTO `productos` (`id`, `codigo`, `nombre`, `fragancia`, `presentacion`, `categoria_id`, `costo_1k`, `iva_19`, `costo_1k_con_iva`, `costo_gr`, `costo_frag_cf_cv`, `precio_30`, `precio_50`, `precio_75`, `precio_100`, `stock_actual`, `stock_minimo`, `estado`, `created_at`, `updated_at`) VALUES
(1, 'PROD-0001', 'FEMME NIGHT', '9 PM', NULL, 1, 162401.00, 30856.19, 193257.19, 193.26, 271.00, 352.30, 406.50, 474.25, 542.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(2, 'PROD-0002', 'TIMAFEEF', 'AFEET LATTAFA', NULL, 1, 150725.00, 28637.75, 179362.75, 179.36, 251.00, 326.30, 376.50, 439.25, 502.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(3, 'PROD-0003', 'INDULGENT ELIXIR', 'AJWARD PINK TO PIN WOMAN', NULL, 1, 162403.00, 30856.57, 193259.57, 193.26, 271.00, 352.30, 406.50, 474.25, 542.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(4, 'PROD-0004', 'LISARI', 'ARI ARIANA GRANDE', NULL, 1, 128042.00, 24327.98, 152369.98, 152.37, 213.00, 276.90, 319.50, 372.75, 426.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(5, 'PROD-0005', 'KARYI', 'BLEECKER STREET', NULL, 1, 180556.00, 34305.64, 214861.64, 214.86, 301.00, 391.30, 451.50, 526.75, 602.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(6, 'PROD-0006', 'LONDON ELIXIR (INFUSION)', 'BURBERRY HER ELIXIR', NULL, 1, 129170.00, 24542.30, 153712.30, 153.71, 215.00, 279.50, 322.50, 376.25, 430.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(7, 'PROD-0007', 'BLUSH PETAL', 'BHARARA VELVET ROSE', NULL, 1, 147932.00, 28107.08, 176039.08, 176.04, 246.00, 319.80, 369.00, 430.50, 492.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(8, 'PROD-0008', 'SWEET CUDDLE', 'BIANCO LATTE', NULL, 1, 135665.00, 25776.35, 161441.35, 161.44, 226.00, 293.80, 339.00, 395.50, 452.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(9, 'PROD-0009', 'DREAM PARADISE', 'CLOUD PINK', NULL, 1, 157101.00, 29849.19, 186950.19, 186.95, 262.00, 340.60, 393.00, 458.50, 524.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(10, 'PROD-0010', 'UPLIFTING DREAM', 'CLOUD', NULL, 1, 144651.00, 27483.69, 172134.69, 172.13, 241.00, 313.30, 361.50, 421.75, 482.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(11, 'PROD-0011', 'INSTANT SOUL', 'CREED CARMINA', NULL, 1, 177091.00, 33647.29, 210738.29, 210.74, 295.00, 383.50, 442.50, 516.25, 590.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(12, 'PROD-0012', 'STELLAR LIGHT', 'CASSIOPEA', NULL, 1, 150673.00, 28627.87, 179300.87, 179.30, 251.00, 326.30, 376.50, 439.25, 502.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(13, 'PROD-0013', 'COZY SWEETNESS', 'COOKIE CRAVE', NULL, 1, 122315.00, 23239.85, 145554.85, 145.55, 204.00, 265.20, 306.00, 357.00, 408.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(14, 'PROD-0014', 'ADELINE', 'DELINA LA ROSEE', NULL, 1, 157419.00, 29909.61, 187328.61, 187.33, 262.00, 340.60, 393.00, 458.50, 524.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(15, 'PROD-0015', 'IRRESISTIBLE DESSERT', 'ECLAIRE LATTAFA', NULL, 1, 179765.00, 34155.35, 213920.35, 213.92, 299.00, 388.70, 448.50, 523.25, 598.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(16, 'PROD-0016', 'INHERETN MAJESTY', 'GAULTIER DIVINE', NULL, 1, 166263.00, 31589.97, 197852.97, 197.85, 277.00, 360.10, 415.50, 484.75, 554.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(17, 'PROD-0017', 'NEW ERA', 'FAME', NULL, 1, 156918.00, 29814.42, 186732.42, 186.73, 261.00, 339.30, 391.50, 456.75, 522.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(18, 'PROD-0018', 'PINK OPULENCE', 'HAYA LATTAFA', NULL, 1, 170339.00, 32364.41, 202703.41, 202.70, 284.00, 369.20, 426.00, 497.00, 568.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(19, 'PROD-0019', 'INTOXICANTING REVERIE', 'IL FEMME', NULL, 1, 188700.00, 35853.00, 224553.00, 224.55, 314.00, 408.20, 471.00, 549.50, 628.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(20, 'PROD-0020', 'ADELINE', 'ILMIN IL ROSO', NULL, 1, 232376.00, 44151.44, 276527.44, 276.53, 387.00, 503.10, 580.50, 677.25, 774.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(21, 'PROD-0021', 'TROPICAL GETAWAY', 'ISLAND BLISS ARMAE', NULL, 1, 135709.00, 25784.71, 161493.71, 161.49, 226.00, 293.80, 339.00, 395.50, 452.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(22, 'PROD-0022', 'METAMORPHOSIS', 'LA BOMBA CAROLINA HERRERA', NULL, 1, 154261.00, 29309.59, 183570.59, 183.57, 257.00, 334.10, 385.50, 449.75, 514.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(23, 'PROD-0023', 'YOUTH DESIRE', 'MISS DIOR PARFUM ', NULL, 1, 159182.00, 30244.58, 189426.58, 189.43, 265.00, 344.50, 397.50, 463.75, 530.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(24, 'PROD-0024', 'CHERIE', 'MISS DIOR CHERIE', NULL, 1, 142622.00, 27098.18, 169720.18, 169.72, 238.00, 309.40, 357.00, 416.50, 476.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(25, 'PROD-0025', 'EXOTIC WARMTH', 'MAYAR LATTAFA', NULL, 1, 155496.00, 29544.24, 185040.24, 185.04, 259.00, 336.70, 388.50, 453.25, 518.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(26, 'PROD-0026', 'DREAMY FANTASY', 'NOBEL BLUSH', NULL, 1, 162652.00, 30903.88, 193555.88, 193.56, 271.00, 352.30, 406.50, 474.25, 542.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(27, 'PROD-0027', 'HOT SPOT', 'NOLITA', NULL, 1, 142210.00, 27019.90, 169229.90, 169.23, 237.00, 308.10, 355.50, 414.75, 474.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(28, 'PROD-0028', 'NOWOM', 'NOW WOMEN RAVE LATTAFA', NULL, 1, 153530.00, 29170.70, 182700.70, 182.70, 256.00, 332.80, 384.00, 448.00, 512.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(29, 'PROD-0029', 'CHARMED ELEMENTS', 'ORIENTICA VELVET GOLD', NULL, 1, 166146.00, 31567.74, 197713.74, 197.71, 277.00, 360.10, 415.50, 484.75, 554.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(30, 'PROD-0030', 'SWEET TEMPTATION', 'ORZA TIZINIA TERENZI', NULL, 1, 135270.00, 25701.30, 160971.30, 160.97, 225.00, 292.50, 337.50, 393.75, 450.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(31, 'PROD-0031', 'CANDYLAND', 'ODYSSEY CANDEE', NULL, 1, 148335.00, 28183.65, 176518.65, 176.52, 247.00, 321.10, 370.50, 432.25, 494.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(32, 'PROD-0032', 'UNIQUE CHARM', 'ODYSSEY FEMME WHITE', NULL, 1, 149334.00, 28373.46, 177707.46, 177.71, 249.00, 323.70, 373.50, 435.75, 498.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(33, 'PROD-0033', 'OBSESSIVE ROMANCE', 'PSYCODELIC LOVE INITIO', NULL, 1, 178550.00, 33924.50, 212474.50, 212.47, 297.00, 386.10, 445.50, 519.75, 594.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(34, 'PROD-0034', 'EXTASY', 'PINK EXTASY (NOBLE BLUSH)', NULL, 1, 172178.00, 32713.82, 204891.82, 204.89, 287.00, 373.10, 430.50, 502.25, 574.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(35, 'PROD-0035', 'ROSE TONIGHT', 'ROSE NIGHT', NULL, 1, 273902.00, 52041.38, 325943.38, 325.94, 456.00, 592.80, 684.00, 798.00, 912.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(36, 'PROD-0036', 'ROSE MUSK', 'ROSE MUSK', NULL, 1, 252980.00, 48066.20, 301046.20, 301.05, 421.00, 547.30, 631.50, 736.75, 842.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(37, 'PROD-0037', 'ULTIMATE SWEETNESS', 'SHOW ME LOVE ', NULL, 1, 163110.00, 30990.90, 194100.90, 194.10, 272.00, 353.60, 408.00, 476.00, 544.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(38, 'PROD-0038', 'HOLIDAY AFFAIR', 'SORBETTO ROSSO', NULL, 1, 136314.00, 25899.66, 162213.66, 162.21, 227.00, 295.10, 340.50, 397.25, 454.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(39, 'PROD-0039', 'SUMMER HIT', 'THANK U NEXT', NULL, 1, 140758.00, 26744.02, 167502.02, 167.50, 235.00, 305.50, 352.50, 411.25, 470.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(40, 'PROD-0040', 'PINKARA', 'YARA LATTAFA', NULL, 1, 140680.00, 26729.20, 167409.20, 167.41, 234.00, 304.20, 351.00, 409.50, 468.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(41, 'PROD-0041', 'SWEET FANTASY', 'YARA CANDY', NULL, 1, 134977.00, 25645.63, 160622.63, 160.62, 225.00, 292.50, 337.50, 393.75, 450.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(42, 'PROD-0042', 'ENCHANTING BLEND', 'YARA TOUS', NULL, 1, 162342.00, 30844.98, 193186.98, 193.19, 270.00, 351.00, 405.00, 472.50, 540.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(43, 'PROD-0043', 'CAPTIVATING SILLAGE', 'YARA MOI', NULL, 1, 180556.00, 34305.64, 214861.64, 214.86, 301.00, 391.30, 451.50, 526.75, 602.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(44, 'PROD-0044', 'PLAYFUL BLEND', 'YARA ELIXIR', NULL, 1, 122892.00, 23349.48, 146241.48, 146.24, 205.00, 266.50, 307.50, 358.75, 410.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(45, 'PROD-0045', 'A MILKSHAKE PLEASE', 'YUM YUM', NULL, 1, 150502.00, 28595.38, 179097.38, 179.10, 251.00, 326.30, 376.50, 439.25, 502.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(46, 'PROD-0046', 'POWERFUL VALERIA', 'VALENTINO DONNA BORN IN ROMAINTENSE', NULL, 1, 171177.00, 32523.63, 203700.63, 203.70, 285.00, 370.50, 427.50, 498.75, 570.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(47, 'PROD-0047', 'GOLDEN VALERIA', 'VALENTINO YELLOW DREAM', NULL, 1, 135778.00, 25797.82, 161575.82, 161.58, 226.00, 293.80, 339.00, 395.50, 452.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(48, 'PROD-0048', 'MERINGUE BRULEE', 'VICTORIA LATTAFA', NULL, 1, 127997.00, 24319.43, 152316.43, 152.32, 213.00, 276.90, 319.50, 372.75, 426.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(49, 'PROD-0049', 'CREAM ADDICTION', 'WHIPPED PLEASURE', NULL, 1, 122552.00, 23284.88, 145836.88, 145.84, 204.00, 265.20, 306.00, 357.00, 408.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(50, 'PROD-0050', 'DELICIOUS EMBRACE', 'CHOCO OVERDOSE', NULL, 1, 140311.00, 26659.09, 166970.09, 166.97, 234.00, 304.20, 351.00, 409.50, 468.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(51, 'PROD-0051', 'BANANADDICTION', 'ECLAIRE BANOFFI', NULL, 1, 127377.00, 24201.63, 151578.63, 151.58, 212.00, 275.60, 318.00, 371.00, 424.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(52, 'PROD-0052', 'SUGAR REVIERE', 'MALLOW MADNESS', NULL, 1, 126464.00, 24028.16, 150492.16, 150.49, 211.00, 274.30, 316.50, 369.25, 422.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(53, 'PROD-0053', 'CANDY ILLUSION', 'BERRY ON TOP', NULL, 1, 124313.00, 23619.47, 147932.47, 147.93, 207.00, 269.10, 310.50, 362.25, 414.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(54, 'PROD-0054', 'CUPCAKE INDULGENCE', 'VAINILLA FREAK', NULL, 1, 124313.00, 23619.47, 147932.47, 147.93, 207.00, 269.10, 310.50, 362.25, 414.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(55, 'PROD-0055', 'IRRESISTIBLE PISTACHIO', 'ECLAIRE PISTACHO', NULL, 1, 130694.00, 24831.86, 155525.86, 155.53, 218.00, 283.40, 327.00, 381.50, 436.00, 0, 0, 1, '2026-06-04 01:33:46', '2026-06-04 01:33:46'),
(56, 'PROD-0056', 'ADRIANA', '212', NULL, 2, 137856.00, 26192.64, 164048.64, 164.05, 230.00, 299.00, 345.00, 402.50, 460.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(57, 'PROD-0057', 'SEX SYMBOL', '212 SEXY', NULL, 2, 124354.00, 23627.26, 147981.26, 147.98, 207.00, 269.10, 310.50, 362.25, 414.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(58, 'PROD-0058', 'CAROLA ROSE', '212 VIP ROSE', NULL, 2, 161787.00, 30739.53, 192526.53, 192.53, 270.00, 351.00, 405.00, 472.50, 540.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(59, 'PROD-0059', 'WILDA', '212 WILD PARTY', NULL, 2, 158233.00, 30064.27, 188297.27, 188.30, 264.00, 343.20, 396.00, 462.00, 528.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(60, 'PROD-0060', 'DOSIETRES', '273', NULL, 2, 135639.00, 25771.41, 161410.41, 161.41, 226.00, 293.80, 339.00, 395.50, 452.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(61, 'PROD-0061', 'ANGLE', '360', NULL, 2, 128557.00, 24425.83, 152982.83, 152.98, 214.00, 278.20, 321.00, 374.50, 428.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(62, 'PROD-0062', 'CUPIDO', 'AMOR AMOR', NULL, 2, 168110.00, 31940.90, 200050.90, 200.05, 280.00, 364.00, 420.00, 490.00, 560.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(63, 'PROD-0063', 'DILEMA', 'ANGE OU DEMON', NULL, 2, 137073.00, 26043.87, 163116.87, 163.12, 228.00, 296.40, 342.00, 399.00, 456.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(64, 'PROD-0064', 'DALILA', 'ANIMALE', NULL, 2, 86668.00, 16466.92, 103134.92, 103.13, 144.00, 187.20, 216.00, 252.00, 288.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(65, 'PROD-0065', 'ARUS', 'ARRURU', NULL, 2, 122675.00, 23308.25, 145983.25, 145.98, 204.00, 265.20, 306.00, 357.00, 408.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(66, 'PROD-0066', 'BLAXIS', 'BLACK XS', NULL, 2, 235448.00, 44735.12, 280183.12, 280.18, 392.00, 509.60, 588.00, 686.00, 784.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(67, 'PROD-0067', 'BOHEMIA INTENSE', 'BRIGHT CRYSTAL', NULL, 2, 143864.00, 27334.16, 171198.16, 171.20, 240.00, 312.00, 360.00, 420.00, 480.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(68, 'PROD-0068', 'BURBEKE', 'BURBERRY', NULL, 2, 161787.00, 30739.53, 192526.53, 192.53, 270.00, 351.00, 405.00, 472.50, 540.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(69, 'PROD-0069', 'PONY PINK', 'BIG PONY 2', NULL, 2, 162750.00, 30922.50, 193672.50, 193.67, 271.00, 352.30, 406.50, 474.25, 542.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(70, 'PROD-0070', 'EXPLOSIVA', 'BOMBSHELL', NULL, 2, 94424.00, 17940.56, 112364.56, 112.36, 157.00, 204.10, 235.50, 274.75, 314.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(71, 'PROD-0071', 'BEAUTY KIM', 'BFF KIM KARDASHIAN', NULL, 2, 118698.00, 22552.62, 141250.62, 141.25, 198.00, 257.40, 297.00, 346.50, 396.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(72, 'PROD-0072', 'COCO PASION', 'COCONUT PASSION', NULL, 2, 115456.00, 21936.64, 137392.64, 137.39, 192.00, 249.60, 288.00, 336.00, 384.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(73, 'PROD-0073', 'CAROL', 'CAROLINA HERRERA', NULL, 2, 166275.00, 31592.25, 197867.25, 197.87, 277.00, 360.10, 415.50, 484.75, 554.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(74, 'PROD-0074', 'CAROLINA', 'CH', NULL, 2, 141981.00, 26976.39, 168957.39, 168.96, 237.00, 308.10, 355.50, 414.75, 474.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(75, 'PROD-0075', 'CORALINE', 'CH SUBLIME', NULL, 2, 192060.00, 36491.40, 228551.40, 228.55, 320.00, 416.00, 480.00, 560.00, 640.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(76, 'PROD-0076', 'MUSIC HALL', 'CAN CAN', NULL, 2, 135390.00, 25724.10, 161114.10, 161.11, 226.00, 293.80, 339.00, 395.50, 452.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(77, 'PROD-0077', 'BURLESQUE', 'CAN CAN BURLESQUE', NULL, 2, 300998.00, 57189.62, 358187.62, 358.19, 501.00, 651.30, 751.50, 876.75, 1002.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(78, 'PROD-0078', 'YOUNG Y CHICK', 'COCO MADEMOISELLE', NULL, 2, 157100.00, 29849.00, 186949.00, 186.95, 262.00, 340.60, 393.00, 458.50, 524.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(79, 'PROD-0079', 'FORTUNA', 'CHANCE CHANEL', NULL, 2, 195050.00, 37059.50, 232109.50, 232.11, 325.00, 422.50, 487.50, 568.75, 650.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(80, 'PROD-0080', 'CHARMIA', 'CHANEL NO 5', NULL, 2, 152980.00, 29066.20, 182046.20, 182.05, 255.00, 331.50, 382.50, 446.25, 510.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(81, 'PROD-0081', 'DALE', 'DAZZEL', NULL, 2, 156674.00, 29768.06, 186442.06, 186.44, 261.00, 339.30, 391.50, 456.75, 522.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(82, 'PROD-0082', 'DIAMANTE', 'DIAMANTES BLANCOS', NULL, 2, 107192.00, 20366.48, 127558.48, 127.56, 179.00, 232.70, 268.50, 313.25, 358.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(83, 'PROD-0083', 'STELLA E.576', 'ETERNITY', NULL, 2, 148789.00, 28269.91, 177058.91, 177.06, 248.00, 322.40, 372.00, 434.00, 496.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(84, 'PROD-0084', 'SENSUELLE', 'EAU DE LACOSTE SENSUELLE', NULL, 2, 242289.00, 46034.91, 288323.91, 288.32, 404.00, 525.20, 606.00, 707.00, 808.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(85, 'PROD-0085', 'ELIXIA', 'ELIXIR BY SHAKIRA', NULL, 2, 288783.00, 54868.77, 343651.77, 343.65, 481.00, 625.30, 721.50, 841.75, 962.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(86, 'PROD-0086', 'EROICA', 'EROS', NULL, 2, 143196.00, 27207.24, 170403.24, 170.40, 239.00, 310.70, 358.50, 418.25, 478.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(87, 'PROD-0087', 'FANTAZIA', 'FANTASY', NULL, 2, 147851.00, 28091.69, 175942.69, 175.94, 246.00, 319.80, 369.00, 430.50, 492.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(88, 'PROD-0088', 'FANATSY MIDNIGHT', 'MIDNIGHT FANTASY', NULL, 2, 155269.00, 29501.11, 184770.11, 184.77, 259.00, 336.70, 388.50, 453.25, 518.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(89, 'PROD-0089', 'GODINA', 'GOOD GIRL', NULL, 2, 173142.00, 32896.98, 206038.98, 206.04, 288.00, 374.40, 432.00, 504.00, 576.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(90, 'PROD-0090', 'GLITTERING GODINA', 'GOOD GIRL VERY GLAM', NULL, 2, 258937.00, 49198.03, 308135.03, 308.14, 431.00, 560.30, 646.50, 754.25, 862.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(91, 'PROD-0091', 'HEREDERA', 'HEIRESS', NULL, 2, 149414.00, 28388.66, 177802.66, 177.80, 249.00, 323.70, 373.50, 435.75, 498.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(92, 'PROD-0092', 'PAOLA', 'HUGO BOSS', NULL, 2, 152395.00, 28955.05, 181350.05, 181.35, 254.00, 330.20, 381.00, 444.50, 508.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(93, 'PROD-0093', 'YOKO', 'ISSEY MIYAKE', NULL, 2, 154411.00, 29338.09, 183749.09, 183.75, 257.00, 334.10, 385.50, 449.75, 514.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(94, 'PROD-0094', 'DIORE', 'J´ADORE', NULL, 2, 139112.00, 26431.28, 165543.28, 165.54, 232.00, 301.60, 348.00, 406.00, 464.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(95, 'PROD-0095', 'BELLE EPOQUE', 'LA VIE EST BELLE', NULL, 2, 170208.00, 32339.52, 202547.52, 202.55, 284.00, 369.20, 426.00, 497.00, 568.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(96, 'PROD-0096', 'GOLD WOMAN', 'LADY MILLION', NULL, 2, 173100.00, 32889.00, 205989.00, 205.99, 288.00, 374.40, 432.00, 504.00, 576.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(97, 'PROD-0097', 'LOLITA', 'LOLITA LEMPICKA', NULL, 2, 138313.00, 26279.47, 164592.47, 164.59, 230.00, 299.00, 345.00, 402.50, 460.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(98, 'PROD-0098', 'TURQUESA', 'LIGHT BLUE', NULL, 2, 135232.00, 25694.08, 160926.08, 160.93, 225.00, 292.50, 337.50, 393.75, 450.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(99, 'PROD-0099', 'MARJIE', 'LOVE SV', NULL, 2, 151951.00, 28870.69, 180821.69, 180.82, 253.00, 328.90, 379.50, 442.75, 506.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(100, 'PROD-0100', 'MAUDIE', 'LOCO POR TI', NULL, 2, 182024.00, 34584.56, 216608.56, 216.61, 303.00, 393.90, 454.50, 530.25, 606.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(101, 'PROD-0101', 'CHOUPETTE', 'MEOWL KP', NULL, 2, 177351.00, 33696.69, 211047.69, 211.05, 295.00, 383.50, 442.50, 516.25, 590.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(102, 'PROD-0102', 'CENTELLA', 'MOON SPARKLE', NULL, 2, 152053.00, 28890.07, 180943.07, 180.94, 253.00, 328.90, 379.50, 442.75, 506.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(103, 'PROD-0103', 'OLIMPIANA', 'OLYMPEA', NULL, 2, 157313.00, 29889.47, 187202.47, 187.20, 262.00, 340.60, 393.00, 458.50, 524.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(104, 'PROD-0104', 'AMATISTA', 'OMNIA AMETHYSTE', NULL, 2, 258937.00, 49198.03, 308135.03, 308.14, 431.00, 560.30, 646.50, 754.25, 862.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(105, 'PROD-0105', 'MURANO', 'OMNIA CRYSTALLINE', NULL, 2, 185769.00, 35296.11, 221065.11, 221.07, 309.00, 401.70, 463.50, 540.75, 618.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(106, 'PROD-0106', 'CORALINE', 'OMNIA CORAL', NULL, 2, 161787.00, 30739.53, 192526.53, 192.53, 270.00, 351.00, 405.00, 472.50, 540.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(107, 'PROD-0107', 'CRUCERO', 'OCEAN LOUNGE', NULL, 2, 264098.00, 50178.62, 314276.62, 314.28, 440.00, 572.00, 660.00, 770.00, 880.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(108, 'PROD-0108', 'WILD MAGNET', 'PURE XS', NULL, 2, 273770.00, 52016.30, 325786.30, 325.79, 456.00, 592.80, 684.00, 798.00, 912.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(109, 'PROD-0109', 'NICKY', 'PARIS HILTON', NULL, 2, 133111.00, 25291.09, 158402.09, 158.40, 222.00, 288.60, 333.00, 388.50, 444.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(110, 'PROD-0110', 'PASSPORT', 'PASSPORT PARIS', NULL, 2, 182873.00, 34745.87, 217618.87, 217.62, 305.00, 396.50, 457.50, 533.75, 610.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(111, 'PROD-0111', 'FLORENTINE', 'YELLOW DIAMOND', NULL, 2, 144058.00, 27371.02, 171429.02, 171.43, 240.00, 312.00, 360.00, 420.00, 480.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(112, 'PROD-0112', 'MUSIC REBEL', 'ROCK BY SHAKIRA', NULL, 2, 258937.00, 49198.03, 308135.03, 308.14, 431.00, 560.30, 646.50, 754.25, 862.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(113, 'PROD-0113', 'SAKINA', 'S BY SHAKIRA', NULL, 2, 258760.00, 49164.40, 307924.40, 307.92, 431.00, 560.30, 646.50, 754.25, 862.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(114, 'PROD-0114', 'DELPHY', 'RALPH', NULL, 2, 173586.00, 32981.34, 206567.34, 206.57, 289.00, 375.70, 433.50, 505.75, 578.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(115, 'PROD-0115', 'SOFIE', 'SOFIA VERGARA', NULL, 2, 159950.00, 30390.50, 190340.50, 190.34, 266.00, 345.80, 399.00, 465.50, 532.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(116, 'PROD-0116', 'FUN MINISTRY', 'SCANDAL', NULL, 2, 174901.00, 33231.19, 208132.19, 208.13, 291.00, 378.30, 436.50, 509.25, 582.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(117, 'PROD-0117', 'TAJAMAR', 'TAJ SUNSET', NULL, 2, 187743.00, 35671.17, 223414.17, 223.41, 313.00, 406.90, 469.50, 547.75, 626.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(118, 'PROD-0118', 'TOMY', 'TOMMY', NULL, 2, 170086.00, 32316.34, 202402.34, 202.40, 283.00, 367.90, 424.50, 495.25, 566.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(119, 'PROD-0119', 'GISELE', 'THE ONE', NULL, 2, 233810.00, 44423.90, 278233.90, 278.23, 390.00, 507.00, 585.00, 682.50, 780.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(120, 'PROD-0120', 'VIVALASUC', 'VIVA LA JUICY', NULL, 2, 223002.00, 42370.38, 265372.38, 265.37, 372.00, 483.60, 558.00, 651.00, 744.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(121, 'PROD-0121', 'ICONIC YOGUI', 'MOSCHINO TOY 2', NULL, 2, 175136.00, 33275.84, 208411.84, 208.41, 292.00, 379.60, 438.00, 511.00, 584.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(122, 'PROD-0122', 'PINK YOGUI', 'TOY 2 BUBBLE GUM', NULL, 2, 144504.00, 27455.76, 171959.76, 171.96, 241.00, 313.30, 361.50, 421.75, 482.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(123, 'PROD-0123', 'IRIDESCENT YOGUI', 'TOY 2 PEARL', NULL, 2, 191107.00, 36310.33, 227417.33, 227.42, 318.00, 413.40, 477.00, 556.50, 636.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(124, 'PROD-0124', 'FANY', 'MOSCHINO FUNNY', NULL, 2, 167776.00, 31877.44, 199653.44, 199.65, 280.00, 364.00, 420.00, 490.00, 560.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(125, 'PROD-0125', 'CHELSEA LOVE', 'I LOVE LOVE MOSCHINO', NULL, 2, 121380.00, 23062.20, 144442.20, 144.44, 202.00, 262.60, 303.00, 353.50, 404.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(126, 'PROD-0126', 'CATHERINE', 'CLASSIQUE JEAN PAUL G', NULL, 2, 166973.00, 31724.87, 198697.87, 198.70, 278.00, 361.40, 417.00, 486.50, 556.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(127, 'PROD-0127', 'KISS', 'AQUA KISS RAIN-KISSED', NULL, 2, 58626.00, 11138.94, 69764.94, 69.76, 98.00, 127.40, 147.00, 171.50, 196.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(128, 'PROD-0128', 'SEDUCCION', 'PURE SEDUCTION', NULL, 2, 60392.00, 11474.48, 71866.48, 71.87, 101.00, 131.30, 151.50, 176.75, 202.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(129, 'PROD-0129', 'LAZO', 'GARDEN VAINILLA LACE', NULL, 2, 40196.00, 7637.24, 47833.24, 47.83, 67.00, 87.10, 100.50, 117.25, 134.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(130, 'PROD-0130', 'WILDLY ENCHANTING', 'VELVET PETALS', NULL, 2, 86196.00, 16377.24, 102573.24, 102.57, 144.00, 187.20, 216.00, 252.00, 288.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(131, 'PROD-0131', 'SPELOVE', 'GARDEN LOVE SPELL', NULL, 2, 73028.00, 13875.32, 86903.32, 86.90, 122.00, 158.60, 183.00, 213.50, 244.00, 0, 0, 1, '2026-06-04 01:50:48', '2026-06-04 01:50:48'),
(290, 'PROD-0132', 'BLUE DAYLIGHT', '9 AM DIVE UNISEX', NULL, 3, 132309.00, 25138.71, 157447.71, 157.45, 220.00, 286.00, 330.00, 385.00, 440.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(291, 'PROD-0133', 'AT NIGHTFALL', '9 PM', NULL, 3, 150133.00, 28525.27, 178658.27, 178.66, 250.00, 325.00, 375.00, 437.50, 500.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(292, 'PROD-0134', 'EXQUISITE EVENING', '9 PM ELIXIR', NULL, 3, 143773.00, 27316.87, 171089.87, 171.09, 240.00, 312.00, 360.00, 420.00, 480.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(293, 'PROD-0135', 'VIBRANT EVENING', '9 PM REBEL UNISEX', NULL, 3, 130938.00, 24878.22, 155816.22, 155.82, 218.00, 283.40, 327.00, 381.50, 436.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(294, 'PROD-0136', 'INDULGENT ELIXIR', 'AJWAD LATTAFA', NULL, 3, 160864.00, 30564.16, 191428.16, 191.43, 268.00, 348.40, 402.00, 469.00, 536.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(295, 'PROD-0137', 'ARABIAN SEA', 'AMBER OUD AGUA DUBAI', NULL, 3, 176347.00, 33505.93, 209852.93, 209.85, 294.00, 382.20, 441.00, 514.50, 588.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(296, 'PROD-0138', 'GOLDEN CITY NIGHTFALL', 'AMBER OUD DUBAI NIGHT', NULL, 3, 153849.00, 29231.31, 183080.31, 183.08, 256.00, 332.80, 384.00, 448.00, 512.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(297, 'PROD-0139', 'REFINED ELIXIR', 'AMBER OUD GOLD EDITION ROYAL AMBER', NULL, 3, 158846.00, 30180.74, 189026.74, 189.03, 265.00, 344.50, 397.50, 463.75, 530.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(298, 'PROD-0140', 'N/A', 'AL HARAMAIN AMBER OUD CARBON EDITION', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(299, 'PROD-0141', 'VEGAS', 'AHLI VEGA', NULL, 3, 200500.00, 38095.00, 238595.00, 238.60, 334.00, 434.20, 501.00, 584.50, 668.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(300, 'PROD-0142', 'KARALHY II', 'AHLI KARPOS', NULL, 3, 240214.00, 45640.66, 285854.66, 285.85, 400.00, 520.00, 600.00, 700.00, 800.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(301, 'PROD-0143', 'N/A', 'ARABIANS', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(302, 'PROD-0144', 'AUDACIOUS TEMPERAMENT', 'ARABIANS TONKA', NULL, 3, 155264.00, 29500.16, 184764.16, 184.76, 259.00, 336.70, 388.50, 453.25, 518.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(303, 'PROD-0145', 'MAPS', 'ATLAS LATTAFA', NULL, 3, 171581.00, 32600.39, 204181.39, 204.18, 286.00, 371.80, 429.00, 500.50, 572.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(304, 'PROD-0146', 'WARM SPICE', 'ASAD LATTAFA', NULL, 3, 203519.00, 38668.61, 242187.61, 242.19, 339.00, 440.70, 508.50, 593.25, 678.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(305, 'PROD-0147', 'ALLURNING SPICE', 'ASAD BOURBON', NULL, 3, 146692.00, 27871.48, 174563.48, 174.56, 244.00, 317.20, 366.00, 427.00, 488.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(306, 'PROD-0148', 'ROYAL SPICE', 'ASAD ELIXIR', NULL, 3, 122892.00, 23349.48, 146241.48, 146.24, 205.00, 266.50, 307.50, 358.75, 410.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(307, 'PROD-0149', 'SUMMER SPICE', 'ASAD ZANZIBAR', NULL, 3, 162220.00, 30821.80, 193041.80, 193.04, 270.00, 351.00, 405.00, 472.50, 540.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(308, 'PROD-0150', 'BOLD MAJESTY', 'OUD FOR GLORY', NULL, 3, 241149.00, 45818.31, 286967.31, 286.97, 402.00, 522.60, 603.00, 703.50, 804.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(309, 'PROD-0151', 'CAPTIVATING BLEND', 'LATTAFA BADEE AL OUD SUBLIME', NULL, 3, 156268.00, 29690.92, 185958.92, 185.96, 260.00, 338.00, 390.00, 455.00, 520.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(310, 'PROD-0152', 'QUARTZ VIOLET O SUMPTOUS QUARZ', 'BADEE AL OUD AMETHYST', NULL, 3, 156599.00, 29753.81, 186352.81, 186.35, 261.00, 339.30, 391.50, 456.75, 522.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(311, 'PROD-0153', 'HONOURED BLEND', 'BADE´E AL OUD HONOR Y GLORY', NULL, 3, 154724.00, 29397.56, 184121.56, 184.12, 258.00, 335.40, 387.00, 451.50, 516.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(312, 'PROD-0154', 'BLUE CONQUEST', 'ART OF UNIVERSE LATTAFA', NULL, 3, 139687.00, 26540.53, 166227.53, 166.23, 233.00, 302.90, 349.50, 407.75, 466.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(313, 'PROD-0155', 'MENES', 'FARAON RAMSSES BHARARA', NULL, 3, 150438.00, 28583.22, 179021.22, 179.02, 251.00, 326.30, 376.50, 439.25, 502.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(314, 'PROD-0156', 'ROYAL BOLDNESS', 'BHARARA KING ORIGINAL', NULL, 3, 154094.00, 29277.86, 183371.86, 183.37, 257.00, 334.10, 385.50, 449.75, 514.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(315, 'PROD-0157', 'ENLIVENING MAGNESTISM', 'BHARARA NICHE', NULL, 3, 289043.00, 54918.17, 343961.17, 343.96, 482.00, 626.60, 723.00, 843.50, 964.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(316, 'PROD-0158', 'BHARARA ONIX', 'BHARARA ONYX', NULL, 3, 122928.00, 23356.32, 146284.32, 146.28, 205.00, 266.50, 307.50, 358.75, 410.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(317, 'PROD-0159', 'KURAT', 'BACCARAT ROUGE', NULL, 3, 146345.00, 27805.55, 174150.55, 174.15, 244.00, 317.20, 366.00, 427.00, 488.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(318, 'PROD-0160', 'BONSAI', 'BOND NO 9', NULL, 3, 170686.00, 32430.34, 203116.34, 203.12, 284.00, 369.20, 426.00, 497.00, 568.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(319, 'PROD-0161', 'EXQUISITE VICE', 'CHOCOLATE GREEDY', NULL, 3, 160516.00, 30498.04, 191014.04, 191.01, 267.00, 347.10, 400.50, 467.25, 534.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(320, 'PROD-0162', 'BLACK ADVENTURE', 'CLUB NUIT INTENSE', NULL, 3, 148978.00, 28305.82, 177283.82, 177.28, 248.00, 322.40, 372.00, 434.00, 496.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(321, 'PROD-0163', 'ENDELESS DAYLIGHT', 'DAY DREAMS', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(322, 'PROD-0164', 'ORIENT TREAUSER', 'DUBAI JADE', NULL, 3, 212338.00, 40344.22, 252682.22, 252.68, 354.00, 460.20, 531.00, 619.50, 708.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(323, 'PROD-0165', 'GOLDEN SERENITY', 'EMEER', NULL, 3, 178568.00, 33927.92, 212495.92, 212.50, 297.00, 386.10, 445.50, 519.75, 594.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(324, 'PROD-0166', 'REFINED ELIXIR', 'ERBA PURA ', NULL, 3, 158846.00, 30180.74, 189026.74, 189.03, 265.00, 344.50, 397.50, 463.75, 530.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(325, 'PROD-0167', 'PICAS BLUE', 'GAME OF SPADES MOON  MILANO MOON PARIS', NULL, 3, 184620.00, 35077.80, 219697.80, 219.70, 308.00, 400.40, 462.00, 539.00, 616.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(326, 'PROD-0168', 'MILERIAL', 'FAKHAR BLACK LATTAFA', NULL, 3, 158035.00, 30026.65, 188061.65, 188.06, 263.00, 341.90, 394.50, 460.25, 526.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(327, 'PROD-0169', 'HERODES', 'HEROD', NULL, 3, 166767.00, 31685.73, 198452.73, 198.45, 278.00, 361.40, 417.00, 486.50, 556.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(328, 'PROD-0170', 'BOOSTED CONFIDENCE', 'HAWAS FIRE RASASI FOR MEN', NULL, 3, 163727.00, 31108.13, 194835.13, 194.84, 273.00, 354.90, 409.50, 477.75, 546.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(329, 'PROD-0171', 'GOLDEN CHARM', 'HAWAS ELIXIR RASAS UNISEX', NULL, 3, 143302.00, 27227.38, 170529.38, 170.53, 239.00, 310.70, 358.50, 418.25, 478.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(330, 'PROD-0172', 'NEW EXTRAVAGANCE', 'IL KAKUNO', NULL, 3, 189734.00, 36049.46, 225783.46, 225.78, 316.00, 410.80, 474.00, 553.00, 632.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(331, 'PROD-0173', 'EXQUISITE BLEND', 'ILMIA IL VITA', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(332, 'PROD-0174', 'SENSORIAL EMOTION', 'IL ORGASME', NULL, 3, 168747.00, 32061.93, 200808.93, 200.81, 281.00, 365.30, 421.50, 491.75, 562.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(333, 'PROD-0175', 'COSY EXPRESSO', 'INTENSE CAFÉ', NULL, 3, 187782.00, 35678.58, 223460.58, 223.46, 313.00, 406.90, 469.50, 547.75, 626.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(334, 'PROD-0176', 'TEMPTING DAPPER', 'LE BEAU LE PARFUM JEAN PAUL GAULTIER', NULL, 3, 168663.00, 32045.97, 200708.97, 200.71, 281.00, 365.30, 421.50, 491.75, 562.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(335, 'PROD-0177', 'ULTRAMAN', 'JEAN PAUL GAULTIER ULTRA MALE', NULL, 3, 171757.00, 32633.83, 204390.83, 204.39, 286.00, 371.80, 429.00, 500.50, 572.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(336, 'PROD-0178', 'STYLISH TRAIL', 'LE MALE LE PERFUM JEAN PAUL GAULTIER', NULL, 3, 152283.00, 28933.77, 181216.77, 181.22, 254.00, 330.20, 381.00, 444.50, 508.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(337, 'PROD-0179', 'TROPICAL DAPPER', 'LE BEAU PARADISE GARDEN JEAN PAUL GAULTIER MAS', NULL, 3, 192251.00, 36527.69, 228778.69, 228.78, 320.00, 416.00, 480.00, 560.00, 640.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(338, 'PROD-0180', 'SUPREME BELMONDO', 'JEAN PAUL GAULTIER LE MALE ELIXIR', NULL, 3, 167083.00, 31745.77, 198828.77, 198.83, 278.00, 361.40, 417.00, 486.50, 556.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(339, 'PROD-0181', 'MAJESTIC GARDEN', 'KALAN MARLY', NULL, 3, 179927.00, 34186.13, 214113.13, 214.11, 300.00, 390.00, 450.00, 525.00, 600.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(340, 'PROD-0182', 'FIERY AURA', 'KHAMRAH DUKHAN', NULL, 3, 174726.00, 33197.94, 207923.94, 207.92, 291.00, 378.30, 436.50, 509.25, 582.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(341, 'PROD-0183', 'SUMPTUOUS WARMTH', 'KHAMRAH LATTAFE', NULL, 3, 163969.00, 31154.11, 195123.11, 195.12, 273.00, 354.90, 409.50, 477.75, 546.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(342, 'PROD-0184', 'EVENING CAFÉ', 'KHAMRAH QAHWA', NULL, 3, 161250.00, 30637.50, 191887.50, 191.89, 269.00, 349.70, 403.50, 470.75, 538.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(343, 'PROD-0185', 'BLACK ADVENTURE', 'L´AVENTURE AL HARAMAIN', NULL, 3, 159435.00, 30292.65, 189727.65, 189.73, 266.00, 345.80, 399.00, 465.50, 532.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(344, 'PROD-0186', 'HIGH VOLTAGE', 'NO LIMIT$', NULL, 3, 162591.00, 30892.29, 193483.29, 193.48, 271.00, 352.30, 406.50, 474.25, 542.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(345, 'PROD-0187', 'GOLDEN PATH', 'NASHEET LATTAFA', NULL, 3, 189127.00, 35934.13, 225061.13, 225.06, 315.00, 409.50, 472.50, 551.25, 630.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(346, 'PROD-0188', 'BOLD FLAME', 'NITRO RED', NULL, 3, 152060.00, 28891.40, 180951.40, 180.95, 253.00, 328.90, 379.50, 442.75, 506.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(347, 'PROD-0189', 'RICH WARMTH', 'ORIENTICA AMBER ROUGE', NULL, 3, 202760.00, 38524.40, 241284.40, 241.28, 338.00, 439.40, 507.00, 591.50, 676.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(348, 'PROD-0190', 'BEAUTIFUL VERSATIL', 'ORIENTICA OUD SAFFRON', NULL, 3, 184874.00, 35126.06, 220000.06, 220.00, 308.00, 400.40, 462.00, 539.00, 616.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(349, 'PROD-0191', 'TURQUOISE DREAM', 'ORIENTICA EXCLUSIVE AZUL AZURE FANTASY', NULL, 3, 160323.00, 30461.37, 190784.37, 190.78, 267.00, 347.10, 400.50, 467.25, 534.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(350, 'PROD-0192', 'MESMERIZING VELVET', 'OUD SATIN MOOD', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(351, 'PROD-0193', 'EXOTIC CONTRAST', 'OUD MARACUJA MAISON UNISEX', NULL, 3, 174445.00, 33144.55, 207589.55, 207.59, 291.00, 378.30, 436.50, 509.25, 582.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(352, 'PROD-0194', 'INDELIBLE TRACE', 'OMBRE NOMADE', NULL, 3, 281106.00, 53410.14, 334516.14, 334.52, 468.00, 608.40, 702.00, 819.00, 936.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(353, 'PROD-0195', 'POSH DESSERT', 'ODYSSEY DUBAI CHOCOLATE', NULL, 3, 140196.00, 26637.24, 166833.24, 166.83, 234.00, 304.20, 351.00, 409.50, 468.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(354, 'PROD-0196', 'INFINITE HORIZON', 'ODYSSEY MANDARINA SKY ELIXIR', NULL, 3, 134616.00, 25577.04, 160193.04, 160.19, 224.00, 291.20, 336.00, 392.00, 448.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(355, 'PROD-0197', 'SKY ORANGE', 'ODYSSEY MANDARINA SKY', NULL, 3, 146501.00, 27835.19, 174336.19, 174.34, 244.00, 317.20, 366.00, 427.00, 488.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(356, 'PROD-0198', 'LEMON BURST', 'ODYSSEY LIMON FREST', NULL, 3, 154229.00, 29303.51, 183532.51, 183.53, 257.00, 334.10, 385.50, 449.75, 514.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(357, 'PROD-0199', 'LUMINOUS AURA', 'ODYSSEY HOME WHITE', NULL, 3, 154840.00, 29419.60, 184259.60, 184.26, 258.00, 335.40, 387.00, 451.50, 516.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(358, 'PROD-0200', 'TITAN FORCE', 'ODYSSEY MEGA AMARILLA', NULL, 3, 135705.00, 25783.95, 161488.95, 161.49, 226.00, 293.80, 339.00, 395.50, 452.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(359, 'PROD-0201', 'PEGASO', 'PEGASUS', NULL, 3, 201937.00, 38368.03, 240305.03, 240.31, 336.00, 436.80, 504.00, 588.00, 672.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(360, 'PROD-0202', 'DISCONCERTING TOUC', 'PRADA LUNA CARBON', NULL, 3, 168110.00, 31940.90, 200050.90, 200.05, 280.00, 364.00, 420.00, 490.00, 560.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(361, 'PROD-0203', 'SUMMER MALET', 'SUMMER HAMMER', NULL, 3, 102941.00, 19558.79, 122499.79, 122.50, 171.00, 222.30, 256.50, 299.25, 342.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(362, 'PROD-0204', 'SOARING', 'SHAHEEN GOLD', NULL, 3, 155549.00, 29554.31, 185103.31, 185.10, 259.00, 336.70, 388.50, 453.25, 518.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(363, 'PROD-0205', 'ALLURING DUET', 'STRONGER WITH YOU', NULL, 3, 188273.00, 35771.87, 224044.87, 224.04, 314.00, 408.20, 471.00, 549.50, 628.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(364, 'PROD-0206', 'WARM SILLAGE', 'STARRY NIGHTS ', NULL, 3, 167970.00, 31914.30, 199884.30, 199.88, 280.00, 364.00, 420.00, 490.00, 560.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(365, 'PROD-0207', 'URBAN RANGER', 'SANTAL 33', NULL, 3, 155401.00, 29526.19, 184927.19, 184.93, 259.00, 336.70, 388.50, 453.25, 518.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(366, 'PROD-0208', 'MILERIAL', 'YVES SAINT LAURENT', NULL, 3, 187608.00, 35645.52, 223253.52, 223.25, 313.00, 406.90, 469.50, 547.75, 626.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(367, 'PROD-0209', 'IRONIC GAME', 'TOY BOY MOSCHINO TOY BOY', NULL, 3, 167235.00, 31774.65, 199009.65, 199.01, 279.00, 362.70, 418.50, 488.25, 558.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(368, 'PROD-0210', 'TONISSIMO', 'TOM FORD', NULL, 3, 187005.00, 35530.95, 222535.95, 222.54, 312.00, 405.60, 468.00, 546.00, 624.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(369, 'PROD-0211', 'PURE ANTIDOTE', 'TERIAQ INTENSE LATTAFA MASCULINA', NULL, 3, 145677.00, 27678.63, 173355.63, 173.36, 243.00, 315.90, 364.50, 425.25, 486.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(370, 'PROD-0212', 'NORTH LEGACY', 'VIKING KAHSMIR BHARARA', NULL, 3, 170569.00, 32408.11, 202977.11, 202.98, 284.00, 369.20, 426.00, 497.00, 568.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(371, 'PROD-0213', 'DESSERT DUNE', 'VIKING KAIRO BHARARA', NULL, 3, 180264.00, 34250.16, 214514.16, 214.51, 300.00, 390.00, 450.00, 525.00, 600.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(372, 'PROD-0214', 'N/A', 'VALENTINO BORN IN ROMA', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(373, 'PROD-0215', 'ROME LEGEND', 'VALENTINO BORN IN ROMA INTENSE VALENTINO MEN', NULL, 3, 180307.00, 34258.33, 214565.33, 214.57, 300.00, 390.00, 450.00, 525.00, 600.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(374, 'PROD-0216', 'MAGNETIC TRADITION', 'BORN IN ROMA EXTRADOSE UOMO VALENTINO', NULL, 3, 183117.00, 34792.23, 217909.23, 217.91, 305.00, 396.50, 457.50, 533.75, 610.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(375, 'PROD-0217', 'ETERNAL TARDTION', 'VALENTINO UOMO BORN IN ROMA INTENSE', NULL, 3, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:17:30', '2026-06-04 02:17:30'),
(376, 'PROD-0218', 'MILXMIL', '1 MILLION', NULL, 4, 126698.00, 24072.62, 150770.62, 150.77, 211.00, 274.30, 316.50, 369.25, 422.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(377, 'PROD-0219', 'ADDICTIVE VIBE', '1 MILLION LUCKY', NULL, 4, 144339.00, 27424.41, 171763.41, 171.76, 240.00, 312.00, 360.00, 420.00, 480.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(378, 'PROD-0220', 'PRILLION', '1 MILLION PRIVE', NULL, 4, 165065.00, 31362.35, 196427.35, 196.43, 275.00, 357.50, 412.50, 481.25, 550.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(379, 'PROD-0221', 'SUPREME MILXMIL', '1 MILLION ELIXIR', NULL, 4, 140283.00, 26653.77, 166936.77, 166.94, 234.00, 304.20, 351.00, 409.50, 468.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(380, 'PROD-0222', 'GLORIOUS MILXMIL', '1 MILLION GOLD', NULL, 4, 136927.00, 26016.13, 162943.13, 162.94, 228.00, 296.40, 342.00, 399.00, 456.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(381, 'PROD-0223', 'ADRIAN', '212 MEN', NULL, 4, 138325.00, 26281.75, 164606.75, 164.61, 230.00, 299.00, 345.00, 402.50, 460.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(382, 'PROD-0224', 'VICARO', '212 VIP', NULL, 4, 157241.00, 29875.79, 187116.79, 187.12, 262.00, 340.60, 393.00, 458.50, 524.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(383, 'PROD-0225', 'PURE FREEDOM', '212 HERORES', NULL, 4, 146538.00, 27842.22, 174380.22, 174.38, 244.00, 317.20, 366.00, 427.00, 488.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(384, 'PROD-0226', 'KING OF PARTIES', '212 VIP BLACK', NULL, 4, 151520.00, 28788.80, 180308.80, 180.31, 252.00, 327.60, 378.00, 441.00, 504.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(385, 'PROD-0227', 'WILDO', '212 VIP WILD PARTY', NULL, 4, 165760.00, 31494.40, 197254.40, 197.25, 276.00, 358.80, 414.00, 483.00, 552.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(386, 'PROD-0228', 'ADREA', 'ADRENALINE', NULL, 4, 180288.00, 34254.72, 214542.72, 214.54, 300.00, 390.00, 450.00, 525.00, 600.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(387, 'PROD-0229', 'TERRY', '360', NULL, 4, 198284.00, 37673.96, 235957.96, 235.96, 330.00, 429.00, 495.00, 577.50, 660.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(388, 'PROD-0230', 'SANSON', 'ANIMALE', NULL, 4, 78452.00, 14905.88, 93357.88, 93.36, 131.00, 170.30, 196.50, 229.25, 262.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(389, 'PROD-0231', 'CONSTELACION', 'ANGEL', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(390, 'PROD-0232', 'AQVARIUM', 'AQVA BVLGARI', NULL, 4, 168101.00, 31939.19, 200040.19, 200.04, 280.00, 364.00, 420.00, 490.00, 560.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(391, 'PROD-0233', 'BLUE GRENADE', 'ARSNEAL', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(392, 'PROD-0234', 'ACQUA FRESCA', 'ACQUA DI GIO', NULL, 4, 156987.00, 29827.53, 186814.53, 186.81, 262.00, 340.60, 393.00, 458.50, 524.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(393, 'PROD-0235', 'VITALIZING GIOVANNI', 'ACQUA DI GIO PROFONDO', NULL, 4, 142024.00, 26984.56, 169008.56, 169.01, 237.00, 308.10, 355.50, 414.75, 474.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(394, 'PROD-0236', 'ALONSO', 'ALLURE SPORT', NULL, 4, 231827.00, 44047.13, 275874.13, 275.87, 386.00, 501.80, 579.00, 675.50, 772.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(395, 'PROD-0237', 'BLACKMAN', 'BVLGARI MAN IN BLACK', NULL, 4, 160694.00, 30531.86, 191225.86, 191.23, 268.00, 348.40, 402.00, 469.00, 536.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(396, 'PROD-0238', 'ALL BLACK', 'BLACK XS', NULL, 4, 152395.00, 28955.05, 181350.05, 181.35, 254.00, 330.20, 381.00, 444.50, 508.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(397, 'PROD-0239', 'TRUE REBELION', 'BLACK XS BE A LEGEND ', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(398, 'PROD-0240', 'BLAXMEN', 'BLAC XS L´EXCES', NULL, 4, 134220.00, 25501.80, 159721.80, 159.72, 224.00, 291.20, 336.00, 392.00, 448.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(399, 'PROD-0241', 'AFRODISIO', 'BLACK XS L´APHRODISIAQUE', NULL, 4, 173142.00, 32896.98, 206038.98, 206.04, 288.00, 374.40, 432.00, 504.00, 576.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(400, 'PROD-0242', 'SENDOA', 'BLUE SEDUCTION ANTONIO BANDERAS', NULL, 4, 197469.00, 37519.11, 234988.11, 234.99, 329.00, 427.70, 493.50, 575.75, 658.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(401, 'PROD-0243', 'BOSE', 'BOSS', NULL, 4, 140749.00, 26742.31, 167491.31, 167.49, 234.00, 304.20, 351.00, 409.50, 468.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(402, 'PROD-0244', 'SMELL', 'BOSS THE SCENT', NULL, 4, 181070.00, 34403.30, 215473.30, 215.47, 302.00, 392.60, 453.00, 528.50, 604.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(403, 'PROD-0245', 'BORAMA', 'BOSS ORANGE', NULL, 4, 211380.00, 40162.20, 251542.20, 251.54, 352.00, 457.60, 528.00, 616.00, 704.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(404, 'PROD-0246', 'BOSIS', 'BOSS IN MOTION', NULL, 4, 151873.00, 28855.87, 180728.87, 180.73, 253.00, 328.90, 379.50, 442.75, 506.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(405, 'PROD-0247', 'BOSE WHITE', 'BOSS BOTTLED UNLIMITED', NULL, 4, 186909.00, 35512.71, 222421.71, 222.42, 311.00, 404.30, 466.50, 544.25, 622.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(406, 'PROD-0248', 'BAD MAN', 'BAD DIESEL', NULL, 4, 162184.00, 30814.96, 192998.96, 193.00, 270.00, 351.00, 405.00, 472.50, 540.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(407, 'PROD-0249', 'BLUNEL', 'BLUE CHANEL', NULL, 4, 175358.00, 33318.02, 208676.02, 208.68, 292.00, 379.60, 438.00, 511.00, 584.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(408, 'PROD-0250', 'BOLD FLASH', 'BAD BOY CH', NULL, 4, 161327.00, 30652.13, 191979.13, 191.98, 269.00, 349.70, 403.50, 470.75, 538.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(409, 'PROD-0251', 'LIDER', 'CK ONE', NULL, 4, 178973.00, 34004.87, 212977.87, 212.98, 298.00, 387.40, 447.00, 521.50, 596.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(410, 'PROD-0252', 'CARLOMAN', 'CH', NULL, 4, 163439.00, 31053.41, 194492.41, 194.49, 272.00, 353.60, 408.00, 476.00, 544.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(411, 'PROD-0253', 'PRIMEN', 'CH PRIVE', NULL, 4, 176077.00, 33454.63, 209531.63, 209.53, 293.00, 380.90, 439.50, 512.75, 586.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(412, 'PROD-0254', 'AFRIKANO', 'CH AFRICA EDITION LIMITED', NULL, 4, 150353.00, 28567.07, 178920.07, 178.92, 250.00, 325.00, 375.00, 437.50, 500.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(413, 'PROD-0255', 'MAN PARK', 'CH CENTRAL PARK', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(414, 'PROD-0256', 'FELICE', 'CLINIQUE HAPPY', NULL, 4, 138313.00, 26279.47, 164592.47, 164.59, 230.00, 299.00, 345.00, 402.50, 460.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32');
INSERT INTO `productos` (`id`, `codigo`, `nombre`, `fragancia`, `presentacion`, `categoria_id`, `costo_1k`, `iva_19`, `costo_1k_con_iva`, `costo_gr`, `costo_frag_cf_cv`, `precio_30`, `precio_50`, `precio_75`, `precio_100`, `stock_actual`, `stock_minimo`, `estado`, `created_at`, `updated_at`) VALUES
(415, 'PROD-0257', 'SNOB', 'CHIC FOR MEN', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(416, 'PROD-0258', 'SILVER', 'CREED', NULL, 4, 153362.00, 29138.78, 182500.78, 182.50, 256.00, 332.80, 384.00, 448.00, 512.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(417, 'PROD-0259', 'EVENTO', 'CREED AVENTUS', NULL, 4, 126536.00, 24041.84, 150577.84, 150.58, 211.00, 274.30, 316.50, 369.25, 422.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(418, 'PROD-0260', 'UN¡ILERIAL', 'CREED MILLESIME IMPERIAL', NULL, 4, 171516.00, 32588.04, 204104.04, 204.10, 286.00, 371.80, 429.00, 500.50, 572.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(419, 'PROD-0261', 'CREDENCE', 'CREED GREEN IRISH TWEED (AL HARAMAIN CARBON EDICTION)', NULL, 4, 148713.00, 28255.47, 176968.47, 176.97, 248.00, 322.40, 372.00, 434.00, 496.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(420, 'PROD-0262', 'CARTER', 'DECLARATION', NULL, 4, 177947.00, 33809.93, 211756.93, 211.76, 296.00, 384.80, 444.00, 518.00, 592.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(421, 'PROD-0263', 'PLUS MEN', 'DIESEL PLUS PLUS', NULL, 4, 198500.00, 37715.00, 236215.00, 236.22, 331.00, 430.30, 496.50, 579.25, 662.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(422, 'PROD-0264', 'MUSEUM', 'D´ORSAY', NULL, 4, 174570.00, 33168.30, 207738.30, 207.74, 291.00, 378.30, 436.50, 509.25, 582.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(423, 'PROD-0265', 'BLACK TATTO', 'ONLY THE BRAVE TATTOO', NULL, 4, 161632.00, 30710.08, 192342.08, 192.34, 269.00, 349.70, 403.50, 470.75, 538.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(424, 'PROD-0266', 'FOREVER', 'ETERNITY', NULL, 4, 179764.00, 34155.16, 213919.16, 213.92, 299.00, 388.70, 448.50, 523.25, 598.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(425, 'PROD-0267', 'BREATHTAKING VEROS', 'EROS ENERGY', NULL, 4, 154924.00, 29435.56, 184359.56, 184.36, 258.00, 335.40, 387.00, 451.50, 516.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(426, 'PROD-0268', 'VEROS', 'EROS ', NULL, 4, 163439.00, 31053.41, 194492.41, 194.49, 272.00, 353.60, 408.00, 476.00, 544.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(427, 'PROD-0269', 'PASSIONATE VEROS', 'EROS FLAME', NULL, 4, 158160.00, 30050.40, 188210.40, 188.21, 263.00, 341.90, 394.50, 460.25, 526.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(428, 'PROD-0270', 'EMBLE', 'EMBLEM MB', NULL, 4, 163192.00, 31006.48, 194198.48, 194.20, 272.00, 353.60, 408.00, 476.00, 544.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(429, 'PROD-0271', 'IRRESISTIBLE CALL', 'EXPLORER', NULL, 4, 155621.00, 29567.99, 185188.99, 185.19, 259.00, 336.70, 388.50, 453.25, 518.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(430, 'PROD-0272', 'VERMAN', 'EAU FRAICHE', NULL, 4, 156037.00, 29647.03, 185684.03, 185.68, 260.00, 338.00, 390.00, 455.00, 520.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(431, 'PROD-0273', 'EAU EPICE ART', 'EAU DE CARTIER', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(432, 'PROD-0274', 'KELVIN', 'FAHRENHEIT', NULL, 4, 137705.00, 26163.95, 163868.95, 163.87, 229.00, 297.70, 343.50, 400.75, 458.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(433, 'PROD-0275', 'FACONABLE', 'FACONNABLE', NULL, 4, 176849.00, 33601.31, 210450.31, 210.45, 295.00, 383.50, 442.50, 516.25, 590.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(434, 'PROD-0276', 'BLUEBEL', 'GIVENCHY BLUE', NULL, 4, 153316.00, 29130.04, 182446.04, 182.45, 255.00, 331.50, 382.50, 446.25, 510.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(435, 'PROD-0277', 'ENERGICO', 'HUGO ENERGISE', NULL, 4, 150914.00, 28673.66, 179587.66, 179.59, 251.00, 326.30, 376.50, 439.25, 502.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(436, 'PROD-0278', 'BOSMAN', 'HUGO BOSS', NULL, 4, 135015.00, 25652.85, 160667.85, 160.67, 225.00, 292.50, 337.50, 393.75, 450.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(437, 'PROD-0279', 'BOSMAN RED', 'HUGO RED', NULL, 4, 168943.00, 32099.17, 201042.17, 201.04, 281.00, 365.30, 421.50, 491.75, 562.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(438, 'PROD-0280', 'INVICTO', 'INVICTUS', NULL, 4, 134024.00, 25464.56, 159488.56, 159.49, 223.00, 289.90, 334.50, 390.25, 446.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(439, 'PROD-0281', 'INVICTO TRIUMPH', 'INVICTUS VICTORY', NULL, 4, 145226.00, 27592.94, 172818.94, 172.82, 242.00, 314.60, 363.00, 423.50, 484.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(440, 'PROD-0282', 'INVICTO GEMSTONE', 'INVICTUS ONIX', NULL, 4, 142303.00, 27037.57, 169340.57, 169.34, 237.00, 308.10, 355.50, 414.75, 474.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(441, 'PROD-0283', 'SAPPORO', 'ISSEY MIYAKE', NULL, 4, 177873.00, 33795.87, 211668.87, 211.67, 296.00, 384.80, 444.00, 518.00, 592.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(442, 'PROD-0284', 'HELENO', 'JEAN PAUL GAULTIER', NULL, 4, 212415.00, 40358.85, 252773.85, 252.77, 354.00, 460.20, 531.00, 619.50, 708.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(443, 'PROD-0285', 'COSTELO', 'LACOSTE RED', NULL, 4, 146345.00, 27805.55, 174150.55, 174.15, 244.00, 317.20, 366.00, 427.00, 488.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(444, 'PROD-0286', 'LEBLANC', 'LA 12 12 BLANC', NULL, 4, 242454.00, 46066.26, 288520.26, 288.52, 404.00, 525.20, 606.00, 707.00, 808.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(445, 'PROD-0287', 'LENOIR', 'L 12 12 NOIR', NULL, 4, 162365.00, 30849.35, 193214.35, 193.21, 271.00, 352.30, 406.50, 474.25, 542.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(446, 'PROD-0288', 'COLATE', 'LACOSTE ESSENTIAL', NULL, 4, 156059.00, 29651.21, 185710.21, 185.71, 260.00, 338.00, 390.00, 455.00, 520.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(447, 'PROD-0289', 'DESAFIO', 'LACOSTE CHALLENGE', NULL, 4, 145472.00, 27639.68, 173111.68, 173.11, 242.00, 314.60, 363.00, 423.50, 484.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(448, 'PROD-0290', 'LEGOMAN', 'LEGACY CR', NULL, 4, 175838.00, 33409.22, 209247.22, 209.25, 293.00, 380.90, 439.50, 512.75, 586.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(449, 'PROD-0291', 'SEVEN BLACK', 'LOEWE 7', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(450, 'PROD-0292', 'TEDY', 'LAPIDUS', NULL, 4, 172826.00, 32836.94, 205662.94, 205.66, 288.00, 374.40, 432.00, 504.00, 576.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(451, 'PROD-0293', 'LEGADO', 'LEGEND', NULL, 4, 63973.00, 12154.87, 76127.87, 76.13, 107.00, 139.10, 160.50, 187.25, 214.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(452, 'PROD-0294', 'SEVEN', 'M7 YVES SAINT LAURENT', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(453, 'PROD-0295', 'NAUTILLIUS', 'NAUTICA VOYAGE', NULL, 4, 167235.00, 31774.65, 199009.65, 199.01, 279.00, 362.70, 418.50, 488.25, 558.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(454, 'PROD-0296', 'ADVENTUROUS SKIPPER', 'BLUE SAIL NAUTICA', NULL, 4, 128200.00, 24358.00, 152558.00, 152.56, 214.00, 278.20, 321.00, 374.50, 428.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(455, 'PROD-0297', 'TRUE ESSENCE', 'OHM', NULL, 4, 143216.00, 27211.04, 170427.04, 170.43, 239.00, 310.70, 358.50, 418.25, 478.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(456, 'PROD-0298', 'EPSILON', 'PI GIVENCHY', NULL, 4, 137392.00, 26104.48, 163496.48, 163.50, 229.00, 297.70, 343.50, 400.75, 458.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(457, 'PROD-0299', 'FUTURISTIC', 'PHANTOM', NULL, 4, 152340.00, 28944.60, 181284.60, 181.28, 254.00, 330.20, 381.00, 444.50, 508.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(458, 'PROD-0300', 'DESIREMAGNET', 'PURE XS', NULL, 4, 146443.00, 27824.17, 174267.17, 174.27, 244.00, 317.20, 366.00, 427.00, 488.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(459, 'PROD-0301', 'NICKO', 'PARIS HILTON', NULL, 4, 224062.00, 42571.78, 266633.78, 266.63, 373.00, 484.90, 559.50, 652.75, 746.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(460, 'PROD-0302', 'MOONLIGHT DESIRE', 'PURE XS NIGHT', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(461, 'PROD-0303', 'POLARE', 'POLO RED', NULL, 4, 179768.00, 34155.92, 213923.92, 213.92, 299.00, 388.70, 448.50, 523.25, 598.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(462, 'PROD-0304', 'POLO SUR', 'POLO BLUE', NULL, 4, 235040.00, 44657.60, 279697.60, 279.70, 392.00, 509.60, 588.00, 686.00, 784.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(463, 'PROD-0305', 'WILD DEEP', 'SAUVAGE DIOR', NULL, 4, 196106.00, 37260.14, 233366.14, 233.37, 327.00, 425.10, 490.50, 572.25, 654.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(464, 'PROD-0306', 'WILD INFUSION', 'SAUVAGE ELIXIR', NULL, 4, 182230.00, 34623.70, 216853.70, 216.85, 304.00, 395.20, 456.00, 532.00, 608.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(465, 'PROD-0307', 'BOMBERO', 'SPICEBOMB VR', NULL, 4, 151278.00, 28742.82, 180020.82, 180.02, 252.00, 327.60, 378.00, 441.00, 504.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(466, 'PROD-0308', 'SKYWALKER', 'STARWALKER', NULL, 4, 185429.00, 35231.51, 220660.51, 220.66, 309.00, 401.70, 463.50, 540.75, 618.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(467, 'PROD-0309', 'ARMY', 'SWISS ARMY', NULL, 4, 161443.00, 30674.17, 192117.17, 192.12, 269.00, 349.70, 403.50, 470.75, 538.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(468, 'PROD-0310', 'TOM', 'TOMMY', NULL, 4, 206975.00, 39325.25, 246300.25, 246.30, 345.00, 448.50, 517.50, 603.75, 690.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(469, 'PROD-0311', 'TOMBOLD', 'TH BOLD TOMMY HILFIGER', NULL, 4, 172402.00, 32756.38, 205158.38, 205.16, 287.00, 373.10, 430.50, 502.25, 574.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(470, 'PROD-0312', 'SOUL CONTRAST', 'THE ONE LUMINOS NIGHT', NULL, 4, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(471, 'PROD-0313', 'EBRAHIM', 'ZLATAN IBRAHIMOVIC', NULL, 4, 158313.00, 30079.47, 188392.47, 188.39, 264.00, 343.20, 396.00, 462.00, 528.00, 0, 0, 1, '2026-06-04 02:25:32', '2026-06-04 02:25:32'),
(472, 'PROD-0472', 'N/A', 'PINO', NULL, 6, 38000.00, 7220.00, 45220.00, 45.22, 63.00, 81.90, 94.50, 110.25, 126.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(473, 'PROD-0473', 'N/A', 'ALCOHOL', NULL, 6, 815126.00, 154873.94, 969999.94, 970.00, 1358.00, 1765.40, 2037.00, 2376.50, 2716.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(474, 'PROD-0474', 'N/A', 'PINO EUCALIPTO', NULL, 6, 46628.00, 8859.32, 55487.32, 55.49, 78.00, 101.40, 117.00, 136.50, 156.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(475, 'PROD-0475', 'N/A', 'PIÑA', NULL, 6, 51843.00, 9850.17, 61693.17, 61.69, 86.00, 111.80, 129.00, 150.50, 172.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(476, 'PROD-0476', 'N/A', 'ROMERO', NULL, 6, 54902.00, 10431.38, 65333.38, 65.33, 91.00, 118.30, 136.50, 159.25, 182.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(477, 'PROD-0477', 'N/A', 'SANDALO', NULL, 6, 81391.00, 15464.29, 96855.29, 96.86, 136.00, 176.80, 204.00, 238.00, 272.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(478, 'PROD-0478', 'N/A', 'SANDIA', NULL, 6, 47457.00, 9016.83, 56473.83, 56.47, 79.00, 102.70, 118.50, 138.25, 158.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(479, 'PROD-0479', 'N/A', 'FRUTOS ROJOS', NULL, 6, 39383.00, 7482.77, 46865.77, 46.87, 66.00, 85.80, 99.00, 115.50, 132.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(480, 'PROD-0480', 'N/A', 'CANELA', NULL, 6, 32622.00, 6198.18, 38820.18, 38.82, 54.00, 70.20, 81.00, 94.50, 108.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(481, 'PROD-0481', 'N/A', 'VAINILLA', NULL, 6, 38721.00, 7356.99, 46077.99, 46.08, 65.00, 84.50, 97.50, 113.75, 130.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(482, 'PROD-0482', 'N/A', 'MEDITERRANEO', NULL, 6, 46838.00, 8899.22, 55737.22, 55.74, 78.00, 101.40, 117.00, 136.50, 156.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(483, 'PROD-0483', 'N/A', 'LAVANDA', NULL, 6, 43766.00, 8315.54, 52081.54, 52.08, 73.00, 94.90, 109.50, 127.75, 146.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(484, 'PROD-0484', 'N/A', 'TALCO', NULL, 6, 60870.00, 11565.30, 72435.30, 72.44, 101.00, 131.30, 151.50, 176.75, 202.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(485, 'PROD-0485', 'N/A', 'CHICLE', NULL, 6, 43716.00, 8306.04, 52022.04, 52.02, 73.00, 94.90, 109.50, 127.75, 146.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(486, 'PROD-0486', 'N/A', 'CARRO NUEVO', NULL, 6, 43630.00, 8289.70, 51919.70, 51.92, 73.00, 94.90, 109.50, 127.75, 146.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(487, 'PROD-0487', 'N/A', 'BRISA MARINA', NULL, 6, 40880.00, 7767.20, 48647.20, 48.65, 68.00, 88.40, 102.00, 119.00, 136.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(488, 'PROD-0488', 'N/A', 'KIWI', NULL, 6, 47892.00, 9099.48, 56991.48, 56.99, 80.00, 104.00, 120.00, 140.00, 160.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(489, 'PROD-0489', 'N/A', 'BABY', NULL, 6, 45452.00, 8635.88, 54087.88, 54.09, 76.00, 98.80, 114.00, 133.00, 152.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(490, 'PROD-0490', 'N/A', 'CHICA FRESITA', NULL, 6, 51717.00, 9826.23, 61543.23, 61.54, 86.00, 111.80, 129.00, 150.50, 172.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(491, 'PROD-0491', 'N/A', 'FRESA', NULL, 6, 34426.00, 6540.94, 40966.94, 40.97, 57.00, 74.10, 85.50, 99.75, 114.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(492, 'PROD-0492', 'N/A', 'JAZMIN ', NULL, 6, 37197.00, 7067.43, 44264.43, 44.26, 62.00, 80.60, 93.00, 108.50, 124.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(493, 'PROD-0493', 'N/A', 'MARACUYA', NULL, 6, 45859.00, 8713.21, 54572.21, 54.57, 76.00, 98.80, 114.00, 133.00, 152.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(494, 'PROD-0494', 'N/A', 'MANGO HIBISCO', NULL, 6, 52654.00, 10004.26, 62658.26, 62.66, 88.00, 114.40, 132.00, 154.00, 176.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(495, 'PROD-0495', 'N/A', 'MELÓN', NULL, 6, 39110.00, 7430.90, 46540.90, 46.54, 65.00, 84.50, 97.50, 113.75, 130.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(496, 'PROD-0496', 'N/A', 'MENTA', NULL, 6, 45277.00, 8602.63, 53879.63, 53.88, 75.00, 97.50, 112.50, 131.25, 150.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(497, 'PROD-0497', 'N/A', 'MELON', NULL, 6, 36522.00, 6939.18, 43461.18, 43.46, 61.00, 79.30, 91.50, 106.75, 122.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(498, 'PROD-0498', 'N/A', 'CEREZA', NULL, 6, 32435.00, 6162.65, 38597.65, 38.60, 54.00, 70.20, 81.00, 94.50, 108.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(499, 'PROD-0499', 'N/A', 'MANDARINA', NULL, 6, 75414.00, 14328.66, 89742.66, 89.74, 126.00, 163.80, 189.00, 220.50, 252.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(500, 'PROD-0500', 'N/A', 'CHERRIE', NULL, 6, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(501, 'PROD-0501', 'N/A', 'MUSK', NULL, 6, 47775.00, 9077.25, 56852.25, 56.85, 80.00, 104.00, 120.00, 140.00, 160.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(502, 'PROD-0502', 'N/A', 'EUCALIPTO ', NULL, 6, 86065.00, 16352.35, 102417.35, 102.42, 143.00, 185.90, 214.50, 250.25, 286.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(503, 'PROD-0503', 'N/A', 'FRESA Y FRAMBUESA - 2017438', NULL, 6, 60499.00, 11494.81, 71993.81, 71.99, 101.00, 131.30, 151.50, 176.75, 202.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(504, 'PROD-0504', 'N/A', 'ROSA HD', NULL, 6, 50118.00, 9522.42, 59640.42, 59.64, 83.00, 107.90, 124.50, 145.25, 166.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(505, 'PROD-0505', 'N/A', 'MANDARINA HD', NULL, 6, 47697.00, 9062.43, 56759.43, 56.76, 79.00, 102.70, 118.50, 138.25, 158.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(506, 'PROD-0506', 'N/A', 'CEREZA HD', NULL, 6, 41764.00, 7935.16, 49699.16, 49.70, 70.00, 91.00, 105.00, 122.50, 140.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(507, 'PROD-0507', 'N/A', 'MIDDLE LAY HD', NULL, 6, 68501.00, 13015.19, 81516.19, 81.52, 114.00, 148.20, 171.00, 199.50, 228.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(508, 'PROD-0508', 'N/A', 'MORA AZUL REED', NULL, 6, 42857.00, 8142.83, 50999.83, 51.00, 71.00, 92.30, 106.50, 124.25, 142.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(509, 'PROD-0509', 'N/A', 'AMBARADO REED', NULL, 6, 73575.00, 13979.25, 87554.25, 87.55, 123.00, 159.90, 184.50, 215.25, 246.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(510, 'PROD-0510', 'N/A', 'PIÑA REED', NULL, 6, 39216.00, 7451.04, 46667.04, 46.67, 65.00, 84.50, 97.50, 113.75, 130.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(511, 'PROD-0511', 'N/A', 'SANDIA REED', NULL, 6, 42157.00, 8009.83, 50166.83, 50.17, 70.00, 91.00, 105.00, 122.50, 140.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(512, 'PROD-0512', 'N/A', 'VANILLA & TONKA REED', NULL, 6, 37647.00, 7152.93, 44799.93, 44.80, 63.00, 81.90, 94.50, 110.25, 126.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(513, 'PROD-0513', 'N/A', 'FRESAS Y FRAMBUESAS REED - 2017135', NULL, 6, 52654.00, 10004.26, 62658.26, 62.66, 88.00, 114.40, 132.00, 154.00, 176.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(514, 'PROD-0514', 'N/A', 'CANELA MANZANA REED', NULL, 6, 53005.00, 10070.95, 63075.95, 63.08, 88.00, 114.40, 132.00, 154.00, 176.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(515, 'PROD-0515', 'N/A', 'PAPAYA REED', NULL, 6, 46643.00, 8862.17, 55505.17, 55.51, 78.00, 101.40, 117.00, 136.50, 156.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(516, 'PROD-0516', 'N/A', 'UVA REED', NULL, 6, 41140.00, 7816.60, 48956.60, 48.96, 69.00, 89.70, 103.50, 120.75, 138.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06'),
(517, 'PROD-0517', 'N/A', 'MILK PLATANO REED', NULL, 6, 55698.00, 10582.62, 66280.62, 66.28, 93.00, 120.90, 139.50, 162.75, 186.00, 0, 0, 1, '2026-06-06 00:08:06', '2026-06-06 00:08:06');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `productos_terminados`
--

CREATE TABLE `productos_terminados` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `codigo` varchar(50) NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `presentacion` varchar(50) NOT NULL DEFAULT '100ml',
  `costo_total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `precio_venta` decimal(12,2) DEFAULT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `producto_costos`
--

CREATE TABLE `producto_costos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `producto_id` bigint(20) UNSIGNED NOT NULL,
  `concepto` varchar(200) NOT NULL,
  `valor` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `producto_terminado_composicion`
--

CREATE TABLE `producto_terminado_composicion` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `producto_terminado_id` bigint(20) UNSIGNED NOT NULL,
  `producto_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `proveedores`
--

CREATE TABLE `proveedores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `documento` varchar(255) NOT NULL,
  `telefono` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `direccion` text DEFAULT NULL,
  `contacto` varchar(255) DEFAULT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `proveedores`
--

INSERT INTO `proveedores` (`id`, `nombre`, `documento`, `telefono`, `email`, `direccion`, `contacto`, `estado`, `created_at`, `updated_at`) VALUES
(1, 'pepito perez', '34343434', '3215379193', 'master34cool@gmail.com', NULL, 'sdsdsd', 1, '2026-04-04 05:21:15', '2026-04-04 05:21:15');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ventas`
--

CREATE TABLE `ventas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `numero_venta` varchar(50) NOT NULL,
  `cliente_id` bigint(20) UNSIGNED NOT NULL,
  `fecha_venta` date NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `estado` enum('completada','pendiente','cancelada') NOT NULL DEFAULT 'completada',
  `tipo_pago` enum('efectivo','tarjeta','transferencia') NOT NULL DEFAULT 'efectivo',
  `observaciones` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `ventas`
--

INSERT INTO `ventas` (`id`, `numero_venta`, `cliente_id`, `fecha_venta`, `total`, `estado`, `tipo_pago`, `observaciones`, `created_at`, `updated_at`) VALUES
(1, 'VENT-000001', 1, '2026-04-04', 3040000.00, 'completada', 'efectivo', NULL, '2026-04-04 09:31:00', '2026-04-04 09:31:00'),
(2, 'VENT-000002', 1, '2026-04-04', 11520000.00, 'completada', 'efectivo', NULL, '2026-04-04 23:41:59', '2026-04-04 23:41:59'),
(3, 'VENT-000003', 1, '2026-04-04', 7800000.00, 'completada', 'efectivo', NULL, '2026-04-04 23:48:22', '2026-04-04 23:48:22'),
(4, 'VENT-000004', 2, '2026-04-07', 500000.00, 'completada', 'efectivo', NULL, '2026-04-08 00:52:56', '2026-04-08 00:52:56');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `venta_detalles`
--

CREATE TABLE `venta_detalles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `venta_id` bigint(20) UNSIGNED NOT NULL,
  `producto_id` bigint(20) UNSIGNED NOT NULL,
  `cantidad` int(11) NOT NULL,
  `precio_unitario` decimal(10,2) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `categorias`
--
ALTER TABLE `categorias`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `clientes`
--
ALTER TABLE `clientes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `clientes_documento_unique` (`documento`);

--
-- Indices de la tabla `compras`
--
ALTER TABLE `compras`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `compras_numero_compra_unique` (`numero_compra`),
  ADD KEY `compras_proveedor_id_foreign` (`proveedor_id`);

--
-- Indices de la tabla `compra_costos`
--
ALTER TABLE `compra_costos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `compra_costos_compra_id_foreign` (`compra_id`);

--
-- Indices de la tabla `compra_detalles`
--
ALTER TABLE `compra_detalles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `compra_detalles_compra_id_foreign` (`compra_id`),
  ADD KEY `compra_detalles_producto_id_foreign` (`producto_id`);

--
-- Indices de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indices de la tabla `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indices de la tabla `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`);

--
-- Indices de la tabla `productos`
--
ALTER TABLE `productos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `productos_codigo_unique` (`codigo`),
  ADD KEY `productos_categoria_id_foreign` (`categoria_id`);

--
-- Indices de la tabla `productos_terminados`
--
ALTER TABLE `productos_terminados`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `productos_terminados_codigo_unique` (`codigo`);

--
-- Indices de la tabla `producto_costos`
--
ALTER TABLE `producto_costos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `producto_costos_producto_id_foreign` (`producto_id`);

--
-- Indices de la tabla `producto_terminado_composicion`
--
ALTER TABLE `producto_terminado_composicion`
  ADD PRIMARY KEY (`id`),
  ADD KEY `producto_terminado_composicion_producto_terminado_id_foreign` (`producto_terminado_id`),
  ADD KEY `producto_terminado_composicion_producto_id_foreign` (`producto_id`);

--
-- Indices de la tabla `proveedores`
--
ALTER TABLE `proveedores`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `proveedores_documento_unique` (`documento`);

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indices de la tabla `ventas`
--
ALTER TABLE `ventas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ventas_numero_venta_unique` (`numero_venta`),
  ADD KEY `ventas_cliente_id_foreign` (`cliente_id`);

--
-- Indices de la tabla `venta_detalles`
--
ALTER TABLE `venta_detalles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `venta_detalles_venta_id_foreign` (`venta_id`),
  ADD KEY `venta_detalles_producto_id_foreign` (`producto_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `categorias`
--
ALTER TABLE `categorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `clientes`
--
ALTER TABLE `clientes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `compras`
--
ALTER TABLE `compras`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `compra_costos`
--
ALTER TABLE `compra_costos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `compra_detalles`
--
ALTER TABLE `compra_detalles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT de la tabla `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `productos`
--
ALTER TABLE `productos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=518;

--
-- AUTO_INCREMENT de la tabla `productos_terminados`
--
ALTER TABLE `productos_terminados`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `producto_costos`
--
ALTER TABLE `producto_costos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de la tabla `producto_terminado_composicion`
--
ALTER TABLE `producto_terminado_composicion`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `proveedores`
--
ALTER TABLE `proveedores`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `ventas`
--
ALTER TABLE `ventas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `venta_detalles`
--
ALTER TABLE `venta_detalles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `compras`
--
ALTER TABLE `compras`
  ADD CONSTRAINT `compras_proveedor_id_foreign` FOREIGN KEY (`proveedor_id`) REFERENCES `proveedores` (`id`);

--
-- Filtros para la tabla `compra_costos`
--
ALTER TABLE `compra_costos`
  ADD CONSTRAINT `compra_costos_compra_id_foreign` FOREIGN KEY (`compra_id`) REFERENCES `compras` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `compra_detalles`
--
ALTER TABLE `compra_detalles`
  ADD CONSTRAINT `compra_detalles_compra_id_foreign` FOREIGN KEY (`compra_id`) REFERENCES `compras` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `compra_detalles_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`);

--
-- Filtros para la tabla `productos`
--
ALTER TABLE `productos`
  ADD CONSTRAINT `productos_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`);

--
-- Filtros para la tabla `producto_costos`
--
ALTER TABLE `producto_costos`
  ADD CONSTRAINT `producto_costos_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `producto_terminado_composicion`
--
ALTER TABLE `producto_terminado_composicion`
  ADD CONSTRAINT `producto_terminado_composicion_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `producto_terminado_composicion_producto_terminado_id_foreign` FOREIGN KEY (`producto_terminado_id`) REFERENCES `productos_terminados` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `ventas`
--
ALTER TABLE `ventas`
  ADD CONSTRAINT `ventas_cliente_id_foreign` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `venta_detalles`
--
ALTER TABLE `venta_detalles`
  ADD CONSTRAINT `venta_detalles_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `venta_detalles_venta_id_foreign` FOREIGN KEY (`venta_id`) REFERENCES `ventas` (`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 */;
