'use strict';
module.exports = {
  async up(queryInterface, Sequelize) {
    /* =========================
       BRANDS
    ========================== */
    await queryInterface.bulkInsert('brands', [
      // Dairy Brands
      {
        name: 'Brookside',
        description: 'Dairy products brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'KCC',
        description: 'Kenya Cooperative Creameries - Dairy products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Tuzo',
        description: 'Milk and dairy brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
     
      // Beverage Brands
      {
        name: 'Keringet',
        description: 'Bottled water brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Coca-Cola',
        description: 'Soft drinks',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Del Monte',
        description: 'Juices and beverages',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Minute Maid',
        description: 'Fruit juices',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Quencher',
        description: 'Juices brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      // Food & Cooking Brands
      {
        name: 'Bidco',
        description: 'Household & food products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Proctor & Allan',
        description: 'Flour & baking products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Pembe',
        description: 'Flour milling products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Soko',
        description: 'Maize flour brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Exe',
        description: 'Cooking fat and oil',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Kasuku',
        description: 'Rice brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Pishori',
        description: 'Premium rice brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      // Bread & Baking
      {
        name: 'Elliots',
        description: 'Bread and bakery products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Festive',
        description: 'Bread brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      // Tea & Coffee
      {
        name: 'Ketepa',
        description: 'Tea products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Brookebond',
        description: 'Tea brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Java House',
        description: 'Coffee products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      // Household & Personal Care
      {
        name: 'Omo',
        description: 'Laundry detergent',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Geisha',
        description: 'Personal care products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Colgate',
        description: 'Oral care products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Close Up',
        description: 'Oral care brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Sunlight',
        description: 'Cleaning products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      // Additional Brands for Expansion
      {
        name: 'Aquafresh',
        description: 'Oral care',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Dettol',
        description: 'Disinfectants and soaps',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Har_pic',
        description: 'Cleaning products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Mumias',
        description: 'Sugar brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Ndovu',
        description: 'Salt and spices',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Supa Loaf',
        description: 'Bread brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Dormans',
        description: 'Coffee brand',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Afia',
        description: 'Juices and drinks',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Red Bull',
        description: 'Energy drinks',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Lactel',
        description: 'Dairy products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Ujimix',
        description: 'Flour products',
        logoUrl: null,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      }
    ]);
    const brands = await queryInterface.sequelize.query(
      'SELECT id, name FROM brands',
      { type: Sequelize.QueryTypes.SELECT }
    );
    const brandMap = {};
    brands.forEach(b => brandMap[b.name] = b.id);
    /* =========================
       CATEGORIES
    ========================== */
    await queryInterface.bulkInsert('categories', [
      // Main Categories
      {
        name: 'Beverages',
        description: 'Soft drinks, water & juices',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 1,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Dairy Products',
        description: 'Milk & dairy products',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 2,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Flour & Grains',
        description: 'Maize flour, wheat flour & rice',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 3,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Cooking Essentials',
        description: 'Cooking oils & essentials',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 4,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Bakery Products',
        description: 'Bread and bakery items',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 5,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Tea & Coffee',
        description: 'Tea, coffee and related products',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 6,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Household Items',
        description: 'Cleaning and household products',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 7,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      },
      {
        name: 'Personal Care',
        description: 'Personal hygiene products',
        parentCategoryId: null,
        imageUrl: null,
        displayOrder: 8,
        isActive: true,
        createdAt: new Date(),
        updatedAt: new Date()
      }
    ]);
    const categories = await queryInterface.sequelize.query(
      'SELECT id, name FROM categories',
      { type: Sequelize.QueryTypes.SELECT }
    );
    const categoryMap = {};
    categories.forEach(c => categoryMap[c.name] = c.id);
    /* =========================
       PRODUCTS (75+ Items)
    ========================== */
    const productsData = [
      // BEVERAGES (15 items)
      {
        sku: 'BEV-COKE-500',
        name: 'Coca-Cola',
        description: 'Coca-Cola soft drink',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Coca-Cola'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'BEV001',
        stock: '200',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'BEV-SPRITE-500',
        name: 'Sprite',
        description: 'Lemon-lime soft drink',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Coca-Cola'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'BEV002',
        stock: '180',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'BEV-FANTA-500',
        name: 'Fanta Orange',
        description: 'Orange flavored soft drink',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Coca-Cola'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'BEV003',
        stock: '160',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'BEV-KERI-500',
        name: 'Keringet Water',
        description: 'Natural mineral water',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Keringet'],
        unitPrice: 50,
        costPrice: 35,
        barcode: 'BEV004',
        stock: '300',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 100,
        maxStock: 600,
        reorderLevel: 150,
        reorderQuantity: 300,
        isActive: true
      },
      {
        sku: 'BEV-DELM-1L',
        name: 'Del Monte Juice',
        description: 'Mixed fruit juice',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Del Monte'],
        unitPrice: 180,
        costPrice: 140,
        barcode: 'BEV005',
        stock: '120',
        unitOfMeasure: 'Carton',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 200,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'BEV-MINM-350',
        name: 'Minute Maid Mango',
        description: 'Mango juice drink',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Minute Maid'],
        unitPrice: 90,
        costPrice: 65,
        barcode: 'BEV006',
        stock: '150',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 300,
        reorderLevel: 60,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'BEV-QUEN-500',
        name: 'Quencher Passion',
        description: 'Passion fruit juice',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Quencher'],
        unitPrice: 80,
        costPrice: 60,
        barcode: 'BEV007',
        stock: '100',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 200,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'BEV-KERI-1.5L',
        name: 'Keringet Water 1.5L',
        description: 'Natural mineral water large bottle',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Keringet'],
        unitPrice: 80,
        costPrice: 60,
        barcode: 'BEV008',
        stock: '200',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 400,
        reorderLevel: 80,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'BEV-DELM-ORANGE',
        name: 'Del Monte Orange Juice',
        description: 'Pure orange juice',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Del Monte'],
        unitPrice: 180,
        costPrice: 140,
        barcode: 'BEV009',
        stock: '100',
        unitOfMeasure: 'Carton',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 180,
        reorderLevel: 40,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'BEV-QUEN-MANGO',
        name: 'Quencher Mango',
        description: 'Mango fruit juice',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Quencher'],
        unitPrice: 80,
        costPrice: 60,
        barcode: 'BEV010',
        stock: '90',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 200,
        reorderLevel: 45,
        reorderQuantity: 90,
        isActive: true
      },
      {
        sku: 'BEV-AFIA-1L',
        name: 'Afia Mango Juice 1L',
        description: 'Mango flavored juice',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Afia'],
        unitPrice: 150,
        costPrice: 110,
        barcode: 'BEV011',
        stock: '110',
        unitOfMeasure: 'Carton',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 250,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'BEV-REDB-250',
        name: 'Red Bull Energy Drink',
        description: 'Energy drink 250ml',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Red Bull'],
        unitPrice: 250,
        costPrice: 200,
        barcode: 'BEV012',
        stock: '80',
        unitOfMeasure: 'Can',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 200,
        reorderLevel: 40,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'BEV-COKE-1L',
        name: 'Coca-Cola 1L',
        description: 'Coca-Cola soft drink large',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Coca-Cola'],
        unitPrice: 120,
        costPrice: 90,
        barcode: 'BEV013',
        stock: '150',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 400,
        reorderLevel: 70,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'BEV-MINM-ORANGE',
        name: 'Minute Maid Orange',
        description: 'Orange juice drink',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Minute Maid'],
        unitPrice: 90,
        costPrice: 65,
        barcode: 'BEV014',
        stock: '140',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 35,
        maxStock: 300,
        reorderLevel: 60,
        reorderQuantity: 140,
        isActive: true
      },
      {
        sku: 'BEV-KERI-5L',
        name: 'Keringet Water 5L',
        description: 'Bulk mineral water',
        categoryId: categoryMap['Beverages'],
        brandId: brandMap['Keringet'],
        unitPrice: 200,
        costPrice: 150,
        barcode: 'BEV015',
        stock: '100',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 200,
        reorderLevel: 40,
        reorderQuantity: 100,
        isActive: true
      },
      // DAIRY PRODUCTS (12 items)
      {
        sku: 'DAIRY-BROOK-500',
        name: 'Brookside Milk',
        description: 'Fresh whole milk',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Brookside'],
        unitPrice: 65,
        costPrice: 45,
        barcode: 'DAIRY001',
        stock: '150',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 400,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'DAIRY-KCC-500',
        name: 'KCC Milk',
        description: 'Long life milk',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['KCC'],
        unitPrice: 60,
        costPrice: 42,
        barcode: 'DAIRY002',
        stock: '120',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 400,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'DAIRY-TUZO-500',
        name: 'Tuzo Mala',
        description: 'Fermented milk',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Tuzo'],
        unitPrice: 55,
        costPrice: 38,
        barcode: 'DAIRY003',
        stock: '80',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 300,
        reorderLevel: 40,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'DAIRY-BROOK-YOG',
        name: 'Brookside Yoghurt',
        description: 'Strawberry yoghurt',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Brookside'],
        unitPrice: 85,
        costPrice: 60,
        barcode: 'DAIRY004',
        stock: '90',
        unitOfMeasure: 'Cup',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 200,
        reorderLevel: 35,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'DAIRY-BROOK-1L',
        name: 'Brookside Milk 1L',
        description: 'Fresh whole milk 1 liter',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Brookside'],
        unitPrice: 120,
        costPrice: 85,
        barcode: 'DAIRY005',
        stock: '100',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 40,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'DAIRY-KCC-MALA',
        name: 'KCC Mala',
        description: 'Cultured milk',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['KCC'],
        unitPrice: 50,
        costPrice: 35,
        barcode: 'DAIRY006',
        stock: '70',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 35,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'DAIRY-TUZO-YOG',
        name: 'Tuzo Yoghurt',
        description: 'Vanilla yoghurt',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Tuzo'],
        unitPrice: 80,
        costPrice: 55,
        barcode: 'DAIRY007',
        stock: '60',
        unitOfMeasure: 'Cup',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 180,
        reorderLevel: 30,
        reorderQuantity: 60,
        isActive: true
      },
      {
        sku: 'DAIRY-BROOK-CHOC',
        name: 'Brookside Chocolate Milk',
        description: 'Chocolate flavored milk',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Brookside'],
        unitPrice: 75,
        costPrice: 52,
        barcode: 'DAIRY008',
        stock: '85',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 35,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'DAIRY-LACT-500',
        name: 'Lactel Milk',
        description: 'UHT milk',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Lactel'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'DAIRY009',
        stock: '110',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 45,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'DAIRY-BROOK-BUTTER',
        name: 'Brookside Butter',
        description: 'Salted butter',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Brookside'],
        unitPrice: 250,
        costPrice: 200,
        barcode: 'DAIRY010',
        stock: '70',
        unitOfMeasure: 'Pack',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'DAIRY-KCC-CHEESE',
        name: 'KCC Cheddar Cheese',
        description: 'Cheddar cheese block',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['KCC'],
        unitPrice: 450,
        costPrice: 380,
        barcode: 'DAIRY011',
        stock: '50',
        unitOfMeasure: 'Pack',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 10,
        maxStock: 150,
        reorderLevel: 20,
        reorderQuantity: 50,
        isActive: true
      },
      {
        sku: 'DAIRY-TUZO-1L',
        name: 'Tuzo Milk 1L',
        description: 'Fresh milk 1 liter',
        categoryId: categoryMap['Dairy Products'],
        brandId: brandMap['Tuzo'],
        unitPrice: 110,
        costPrice: 80,
        barcode: 'DAIRY012',
        stock: '90',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 90,
        isActive: true
      },
      // FLOUR & GRAINS (15 items)
      {
        sku: 'FLOUR-JOGO-2KG',
        name: 'Jogoo Maize Flour',
        description: 'Refined maize flour',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Proctor & Allan'],
        unitPrice: 230,
        costPrice: 200,
        barcode: 'FLOUR001',
        stock: '100',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 300,
        reorderLevel: 40,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'FLOUR-PEMBE-2KG',
        name: 'Pembe Maize Flour',
        description: 'Premium maize flour',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Pembe'],
        unitPrice: 240,
        costPrice: 210,
        barcode: 'FLOUR002',
        stock: '90',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 300,
        reorderLevel: 40,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'FLOUR-SOKO-2KG',
        name: 'Soko Maize Flour',
        description: 'Maize flour',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Soko'],
        unitPrice: 220,
        costPrice: 190,
        barcode: 'FLOUR003',
        stock: '110',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 300,
        reorderLevel: 40,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'FLOUR-EXEC-2KG',
        name: 'Exe Wheat Flour',
        description: 'Self-raising wheat flour',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Exe'],
        unitPrice: 180,
        costPrice: 155,
        barcode: 'FLOUR004',
        stock: '80',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 250,
        reorderLevel: 30,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'RICE-KASU-5KG',
        name: 'Kasuku Rice',
        description: 'Pishori rice',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Kasuku'],
        unitPrice: 650,
        costPrice: 580,
        barcode: 'RICE001',
        stock: '60',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 10,
        maxStock: 150,
        reorderLevel: 20,
        reorderQuantity: 50,
        isActive: true
      },
      {
        sku: 'RICE-PISH-5KG',
        name: 'Pishori Premium Rice',
        description: 'Premium aromatic rice',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Pishori'],
        unitPrice: 750,
        costPrice: 680,
        barcode: 'RICE002',
        stock: '50',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 10,
        maxStock: 120,
        reorderLevel: 15,
        reorderQuantity: 40,
        isActive: true
      },
      {
        sku: 'FLOUR-JOGO-5KG',
        name: 'Jogoo Maize Flour 5kg',
        description: 'Refined maize flour bulk pack',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Proctor & Allan'],
        unitPrice: 550,
        costPrice: 480,
        barcode: 'FLOUR005',
        stock: '70',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'FLOUR-PEMBE-5KG',
        name: 'Pembe Maize Flour 5kg',
        description: 'Premium maize flour bulk',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Pembe'],
        unitPrice: 570,
        costPrice: 500,
        barcode: 'FLOUR006',
        stock: '60',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'RICE-KASU-2KG',
        name: 'Kasuku Rice 2kg',
        description: 'Pishori rice small pack',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Kasuku'],
        unitPrice: 280,
        costPrice: 250,
        barcode: 'RICE003',
        stock: '80',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'FLOUR-EXEC-1KG',
        name: 'Exe Wheat Flour 1kg',
        description: 'Self-raising wheat flour',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Exe'],
        unitPrice: 95,
        costPrice: 80,
        barcode: 'FLOUR007',
        stock: '100',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 280,
        reorderLevel: 40,
        reorderQuantity: 90,
        isActive: true
      },
      {
        sku: 'FLOUR-SOKO-5KG',
        name: 'Soko Maize Flour 5kg',
        description: 'Maize flour bulk pack',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Soko'],
        unitPrice: 530,
        costPrice: 460,
        barcode: 'FLOUR008',
        stock: '75',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 220,
        reorderLevel: 30,
        reorderQuantity: 75,
        isActive: true
      },
      {
        sku: 'RICE-PISH-2KG',
        name: 'Pishori Rice 2kg',
        description: 'Premium aromatic rice small pack',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Pishori'],
        unitPrice: 380,
        costPrice: 340,
        barcode: 'RICE004',
        stock: '95',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'FLOUR-UJI-2KG',
        name: 'Ujimix Maize Flour 2kg',
        description: 'Fortified maize flour',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Ujimix'],
        unitPrice: 250,
        costPrice: 220,
        barcode: 'FLOUR009',
        stock: '85',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'RICE-KASU-10KG',
        name: 'Kasuku Rice 10kg',
        description: 'Bulk pishori rice',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Kasuku'],
        unitPrice: 1200,
        costPrice: 1100,
        barcode: 'RICE005',
        stock: '40',
        unitOfMeasure: 'Bag',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 10,
        maxStock: 100,
        reorderLevel: 15,
        reorderQuantity: 40,
        isActive: true
      },
      {
        sku: 'FLOUR-PEMBE-1KG',
        name: 'Pembe Maize Flour 1kg',
        description: 'Premium maize flour small pack',
        categoryId: categoryMap['Flour & Grains'],
        brandId: brandMap['Pembe'],
        unitPrice: 130,
        costPrice: 110,
        barcode: 'FLOUR010',
        stock: '120',
        unitOfMeasure: 'Packet',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      // COOKING ESSENTIALS (10 items)
      {
        sku: 'OIL-BIDCO-1L',
        name: 'Elianto Cooking Oil 1L',
        description: 'Pure vegetable cooking oil',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Bidco'],
        unitPrice: 320,
        costPrice: 280,
        barcode: 'OIL001',
        stock: '140',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 400,
        reorderLevel: 50,
        reorderQuantity: 120,
        isActive: true
      },
      {
        sku: 'OIL-BIDCO-3L',
        name: 'Elianto Cooking Oil 3L',
        description: 'Family pack vegetable oil',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Bidco'],
        unitPrice: 890,
        costPrice: 780,
        barcode: 'OIL002',
        stock: '80',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'FAT-EXE-2KG',
        name: 'Exe Cooking Fat 2kg',
        description: 'Premium vegetable cooking fat',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Exe'],
        unitPrice: 480,
        costPrice: 420,
        barcode: 'FAT001',
        stock: '90',
        unitOfMeasure: 'Tin',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'SUGAR-MUMI-1KG',
        name: 'Mumias Sugar 1kg',
        description: 'Granulated white sugar',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Mumias'],
        unitPrice: 180,
        costPrice: 150,
        barcode: 'SUG001',
        stock: '200',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'SALT-NDOV-500G',
        name: 'Ndovu Salt 500g',
        description: 'Iodized table salt',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Ndovu'],
        unitPrice: 50,
        costPrice: 35,
        barcode: 'SALT001',
        stock: '250',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 60,
        maxStock: 600,
        reorderLevel: 100,
        reorderQuantity: 250,
        isActive: true
      },
      {
        sku: 'OIL-BIDCO-500ML',
        name: 'Elianto Cooking Oil 500ml',
        description: 'Vegetable oil small bottle',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Bidco'],
        unitPrice: 180,
        costPrice: 150,
        barcode: 'OIL003',
        stock: '160',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 400,
        reorderLevel: 70,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'FAT-EXE-1KG',
        name: 'Exe Cooking Fat 1kg',
        description: 'Vegetable cooking fat',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Exe'],
        unitPrice: 250,
        costPrice: 220,
        barcode: 'FAT002',
        stock: '110',
        unitOfMeasure: 'Tin',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'SUGAR-MUMI-2KG',
        name: 'Mumias Sugar 2kg',
        description: 'Granulated sugar bulk',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Mumias'],
        unitPrice: 350,
        costPrice: 300,
        barcode: 'SUG002',
        stock: '150',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 400,
        reorderLevel: 70,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'SALT-NDOV-1KG',
        name: 'Ndovu Salt 1kg',
        description: 'Iodized salt bulk',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Ndovu'],
        unitPrice: 90,
        costPrice: 70,
        barcode: 'SALT002',
        stock: '180',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 45,
        maxStock: 450,
        reorderLevel: 80,
        reorderQuantity: 180,
        isActive: true
      },
      {
        sku: 'OIL-BIDCO-5L',
        name: 'Elianto Cooking Oil 5L',
        description: 'Large vegetable oil',
        categoryId: categoryMap['Cooking Essentials'],
        brandId: brandMap['Bidco'],
        unitPrice: 1400,
        costPrice: 1200,
        barcode: 'OIL004',
        stock: '60',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 150,
        reorderLevel: 25,
        reorderQuantity: 60,
        isActive: true
      },
      // BAKERY PRODUCTS (8 items)
      {
        sku: 'BREAD-ELLIOT-WHITE',
        name: 'Elliots White Bread',
        description: 'Fresh white sliced bread 400g',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Elliots'],
        unitPrice: 65,
        costPrice: 48,
        barcode: 'BRD001',
        stock: '180',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'BREAD-FESTIVE',
        name: 'Festive Bread',
        description: 'Sliced white bread',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Festive'],
        unitPrice: 60,
        costPrice: 45,
        barcode: 'BRD002',
        stock: '160',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 450,
        reorderLevel: 70,
        reorderQuantity: 180,
        isActive: true
      },
      {
        sku: 'BREAD-SUPA',
        name: 'Supa Loaf Bread',
        description: 'Wholemeal bread',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Supa Loaf'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'BRD003',
        stock: '140',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 35,
        maxStock: 400,
        reorderLevel: 60,
        reorderQuantity: 140,
        isActive: true
      },
      {
        sku: 'BREAD-ELLIOT-BROWN',
        name: 'Elliots Brown Bread',
        description: 'Brown sliced bread 400g',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Elliots'],
        unitPrice: 75,
        costPrice: 55,
        barcode: 'BRD004',
        stock: '120',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 350,
        reorderLevel: 50,
        reorderQuantity: 120,
        isActive: true
      },
      {
        sku: 'BREAD-FESTIVE-BROWN',
        name: 'Festive Brown Bread',
        description: 'Brown bread loaf',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Festive'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'BRD005',
        stock: '130',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 350,
        reorderLevel: 50,
        reorderQuantity: 130,
        isActive: true
      },
      {
        sku: 'BREAD-SUPA-800G',
        name: 'Supa Loaf 800g',
        description: 'Large wholemeal bread',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Supa Loaf'],
        unitPrice: 120,
        costPrice: 90,
        barcode: 'BRD006',
        stock: '90',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 90,
        isActive: true
      },
      {
        sku: 'BREAD-ELLIOT-800G',
        name: 'Elliots White Bread 800g',
        description: 'Large white bread',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Elliots'],
        unitPrice: 110,
        costPrice: 80,
        barcode: 'BRD007',
        stock: '100',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 45,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'BREAD-FESTIVE-800G',
        name: 'Festive Bread 800g',
        description: 'Large sliced bread',
        categoryId: categoryMap['Bakery Products'],
        brandId: brandMap['Festive'],
        unitPrice: 105,
        costPrice: 75,
        barcode: 'BRD008',
        stock: '110',
        unitOfMeasure: 'Loaf',
        taxRate: 0,
        taxType: 'ZERO',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 45,
        reorderQuantity: 110,
        isActive: true
      },
      // TEA & COFFEE (8 items)
      {
        sku: 'TEA-KETEPA-500G',
        name: 'Ketepa Premium Tea 500g',
        description: 'Kenyan black tea',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Ketepa'],
        unitPrice: 420,
        costPrice: 370,
        barcode: 'TEA001',
        stock: '110',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'TEA-BROOKE-250G',
        name: 'Brooke Bond Red Label 250g',
        description: 'Classic black tea',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Brookebond'],
        unitPrice: 220,
        costPrice: 190,
        barcode: 'TEA002',
        stock: '130',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 350,
        reorderLevel: 60,
        reorderQuantity: 120,
        isActive: true
      },
      {
        sku: 'COFF-JAVA-100G',
        name: 'Java House Coffee 100g',
        description: 'Ground coffee',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Java House'],
        unitPrice: 350,
        costPrice: 300,
        barcode: 'COFF001',
        stock: '90',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 90,
        isActive: true
      },
      {
        sku: 'TEA-KETEPA-250G',
        name: 'Ketepa Tea 250g',
        description: 'Black tea small pack',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Ketepa'],
        unitPrice: 220,
        costPrice: 190,
        barcode: 'TEA003',
        stock: '140',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 350,
        reorderLevel: 60,
        reorderQuantity: 140,
        isActive: true
      },
      {
        sku: 'COFF-DORM-200G',
        name: 'Dormans Coffee 200g',
        description: 'Premium ground coffee',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Dormans'],
        unitPrice: 500,
        costPrice: 450,
        barcode: 'COFF002',
        stock: '70',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'TEA-BROOKE-500G',
        name: 'Brooke Bond Tea 500g',
        description: 'Red label tea bulk',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Brookebond'],
        unitPrice: 400,
        costPrice: 350,
        barcode: 'TEA004',
        stock: '100',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'COFF-JAVA-250G',
        name: 'Java House Coffee 250g',
        description: 'Medium roast coffee',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Java House'],
        unitPrice: 600,
        costPrice: 550,
        barcode: 'COFF003',
        stock: '80',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 80,
        isActive: true
      },
      {
        sku: 'COFF-DORM-100G',
        name: 'Dormans Coffee 100g',
        description: 'Instant coffee',
        categoryId: categoryMap['Tea & Coffee'],
        brandId: brandMap['Dormans'],
        unitPrice: 300,
        costPrice: 250,
        barcode: 'COFF004',
        stock: '110',
        unitOfMeasure: 'Jar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 110,
        isActive: true
      },
      // HOUSEHOLD ITEMS (10 items)
      {
        sku: 'DETERG-OMO-1KG',
        name: 'Omo Auto 1kg',
        description: 'Automatic washing powder',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Omo'],
        unitPrice: 480,
        costPrice: 410,
        barcode: 'DET001',
        stock: '90',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'SOAP-SUNL-400G',
        name: 'Sunlight Bar 400g',
        description: 'Multipurpose laundry bar soap',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Sunlight'],
        unitPrice: 145,
        costPrice: 120,
        barcode: 'SOAP001',
        stock: '200',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 600,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'CLEAN-DET-500ML',
        name: 'Dettol Disinfectant 500ml',
        description: 'Antibacterial surface cleaner',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Dettol'],
        unitPrice: 350,
        costPrice: 300,
        barcode: 'CLEAN001',
        stock: '100',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 100,
        isActive: true
      },
      {
        sku: 'DETERG-OMO-2KG',
        name: 'Omo Washing Powder 2kg',
        description: 'Laundry detergent bulk',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Omo'],
        unitPrice: 900,
        costPrice: 800,
        barcode: 'DET002',
        stock: '70',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 15,
        maxStock: 200,
        reorderLevel: 30,
        reorderQuantity: 70,
        isActive: true
      },
      {
        sku: 'SOAP-SUNL-800G',
        name: 'Sunlight Bar 800g',
        description: 'Large laundry bar soap',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Sunlight'],
        unitPrice: 280,
        costPrice: 240,
        barcode: 'SOAP002',
        stock: '150',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 400,
        reorderLevel: 70,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'CLEAN-HARP-750ML',
        name: 'Har_pic Cleaner 750ml',
        description: 'Multi-surface cleaner',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Har_pic'],
        unitPrice: 200,
        costPrice: 170,
        barcode: 'CLEAN002',
        stock: '120',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 350,
        reorderLevel: 60,
        reorderQuantity: 120,
        isActive: true
      },
      {
        sku: 'DETERG-OMO-500G',
        name: 'Omo Powder 500g',
        description: 'Small pack detergent',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Omo'],
        unitPrice: 250,
        costPrice: 220,
        barcode: 'DET003',
        stock: '110',
        unitOfMeasure: 'Packet',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 25,
        maxStock: 300,
        reorderLevel: 50,
        reorderQuantity: 110,
        isActive: true
      },
      {
        sku: 'SOAP-DET-250ML',
        name: 'Dettol Liquid Soap 250ml',
        description: 'Antibacterial hand soap',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Dettol'],
        unitPrice: 180,
        costPrice: 150,
        barcode: 'SOAP003',
        stock: '140',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 35,
        maxStock: 400,
        reorderLevel: 60,
        reorderQuantity: 140,
        isActive: true
      },
      {
        sku: 'CLEAN-HARP-1L',
        name: 'Har_pic Cleaner 1L',
        description: 'Large multi-surface cleaner',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Har_pic'],
        unitPrice: 300,
        costPrice: 260,
        barcode: 'CLEAN003',
        stock: '90',
        unitOfMeasure: 'Bottle',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 20,
        maxStock: 250,
        reorderLevel: 40,
        reorderQuantity: 90,
        isActive: true
      },
      {
        sku: 'SOAP-SUNL-200G',
        name: 'Sunlight Bar 200g',
        description: 'Small laundry bar',
        categoryId: categoryMap['Household Items'],
        brandId: brandMap['Sunlight'],
        unitPrice: 80,
        costPrice: 60,
        barcode: 'SOAP004',
        stock: '220',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      // PERSONAL CARE (10 items)
      {
        sku: 'TOOTH-COLG-150G',
        name: 'Colgate Max Fresh 150g',
        description: 'Toothpaste with cooling crystals',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Colgate'],
        unitPrice: 185,
        costPrice: 150,
        barcode: 'PCARE001',
        stock: '140',
        unitOfMeasure: 'Tube',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 400,
        reorderLevel: 60,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'SOAP-GEIS-125G',
        name: 'Geisha Beauty Soap 125g',
        description: 'Moisturizing beauty soap',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Geisha'],
        unitPrice: 85,
        costPrice: 65,
        barcode: 'SOAP002',
        stock: '220',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'TOOTH-CLOSE-100G',
        name: 'Close Up Toothpaste 100g',
        description: 'Fresh breath toothpaste',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Close Up'],
        unitPrice: 150,
        costPrice: 120,
        barcode: 'PCARE002',
        stock: '160',
        unitOfMeasure: 'Tube',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 40,
        maxStock: 450,
        reorderLevel: 70,
        reorderQuantity: 160,
        isActive: true
      },
      {
        sku: 'SOAP-GEIS-250G',
        name: 'Geisha Soap 250g',
        description: 'Large beauty soap',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Geisha'],
        unitPrice: 150,
        costPrice: 120,
        barcode: 'SOAP005',
        stock: '180',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 45,
        maxStock: 450,
        reorderLevel: 80,
        reorderQuantity: 180,
        isActive: true
      },
      {
        sku: 'TOOTH-AQUA-125G',
        name: 'Aquafresh Toothpaste 125g',
        description: 'Triple protection toothpaste',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Aquafresh'],
        unitPrice: 200,
        costPrice: 170,
        barcode: 'PCARE003',
        stock: '120',
        unitOfMeasure: 'Tube',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 30,
        maxStock: 350,
        reorderLevel: 60,
        reorderQuantity: 120,
        isActive: true
      },
      {
        sku: 'SOAP-DET-125G',
        name: 'Dettol Soap 125g',
        description: 'Antibacterial bar soap',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Dettol'],
        unitPrice: 100,
        costPrice: 80,
        barcode: 'SOAP006',
        stock: '200',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      },
      {
        sku: 'TOOTH-COLG-75G',
        name: 'Colgate Herbal 75g',
        description: 'Herbal toothpaste',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Colgate'],
        unitPrice: 120,
        costPrice: 90,
        barcode: 'PCARE004',
        stock: '150',
        unitOfMeasure: 'Tube',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 35,
        maxStock: 400,
        reorderLevel: 70,
        reorderQuantity: 150,
        isActive: true
      },
      {
        sku: 'SOAP-GEIS-75G',
        name: 'Geisha Soap 75g',
        description: 'Small moisturizing soap',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Geisha'],
        unitPrice: 60,
        costPrice: 45,
        barcode: 'SOAP007',
        stock: '250',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 60,
        maxStock: 600,
        reorderLevel: 100,
        reorderQuantity: 250,
        isActive: true
      },
      {
        sku: 'TOOTH-CLOSE-50G',
        name: 'Close Up 50g',
        description: 'Travel size toothpaste',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Close Up'],
        unitPrice: 80,
        costPrice: 60,
        barcode: 'PCARE005',
        stock: '180',
        unitOfMeasure: 'Tube',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 45,
        maxStock: 450,
        reorderLevel: 80,
        reorderQuantity: 180,
        isActive: true
      },
      {
        sku: 'SOAP-DET-75G',
        name: 'Dettol Soap 75g',
        description: 'Small antibacterial soap',
        categoryId: categoryMap['Personal Care'],
        brandId: brandMap['Dettol'],
        unitPrice: 70,
        costPrice: 50,
        barcode: 'SOAP008',
        stock: '220',
        unitOfMeasure: 'Bar',
        taxRate: 16,
        taxType: 'VAT',
        isTrackInventory: true,
        minStock: 50,
        maxStock: 500,
        reorderLevel: 80,
        reorderQuantity: 200,
        isActive: true
      }
    ];
    await queryInterface.bulkInsert('products', productsData.map(p => ({
      ...p,
      createdAt: new Date(),
      updatedAt: new Date()
    })));
  },

  async down(queryInterface, Sequelize) {
    await queryInterface.bulkDelete('products', null, {});
    await queryInterface.bulkDelete('categories', null, {});
    await queryInterface.bulkDelete('brands', null, {});
  }
};