route.ts

Go to the documentation of this file.

import { NextRequest, NextResponse } from 'next/server';
import { fieldpineServerApi } from '@/lib/server/fieldpineApi';
import { getRequestContext, validateApiAccess } from '@/lib/server/sessionUtils';
 
/**
 * Helper function to escape XML special characters
 */
function escapeXml(unsafe: string): string {
  if (typeof unsafe !== 'string') return String(unsafe || '');
  return unsafe
    .replace(/&/g, '&')
    .replace(/</g, '&lt;')
    .replace(/>/g, '&gt;')
    .replace(/"/g, '&quot;')
    .replace(/'/g, '&apos;');
}
 
/**
 * OpenAPI Products Endpoint
 * GET /api/v1/openapi/products/[id] - Get single product
 */
export async function GET(
  request: NextRequest,
  { params }: { params: Promise<{ id: string }> }
) {
  console.log('[Product API] ===== HANDLER STARTING v2 =====');
  try {
    // Await params in Next.js 15
    const { id } = await params;
    
    console.log('[Product API] Requested ID:', id);
    
    // 1. Get and validate session
    console.log('[Product API] Getting request context...');
    const context = await getRequestContext(request);
    console.log('[Product API] Got context, validating API access...');
    const validation = validateApiAccess(context, 'elink');
    console.log('[Product API] Validation result:', validation);
    
    // Handle both { valid: true } and true responses
    const isValid = typeof validation === 'boolean' ? validation : validation.valid;
    if (!isValid || !context) {
      console.log('[Product API] Validation failed, returning error response');
      const errorMsg = typeof validation === 'object' ? validation.error : 'Access denied';
      const errorCode = typeof validation === 'object' ? validation.errorCode : undefined;
      return NextResponse.json(
        { error: errorMsg || 'Access denied', errorCode },
        { status: 403 }
      );
    }
    console.log('[Product API] Validation passed, proceeding...');
 
    // Use GNAP/BUCK API to get full product details
    // OpenAPI doesn't return barcode and many other fields, so we use the legacy eLink API
    // Field mapping reference from Fieldpine productedit.htm:
    // 100-262: Core product fields (Pid, Description, Price, Cost, PLU, Depid, Spid, etc.)
    // 300-499: Extended product fields (pricing, warehouse, etc.)
    // 350-352, 371-374: Department hierarchy (Depid2-8)
    // 512-514, 526: Barcodes and related
    // 4000-4399: Industry-specific fields (optical/eyewear, food attributes, etc.)
    // 8390617,8390618: Web descriptions
    // 8391608-8391618: Website publishing controls
    // 8390713-8390730: Website indicators and flags
    // 8391117,8392117: SEO fields (blurb, keywords)
    // 8392608,8392609,8392708,8392772,8394608: Marketing and display controls
    // 8388814,8388817,8388818,8388908,8389009: Attributes (weight, size, color, brand)
    // 8393608,8393609,8393610: Additional product attributes
    // 8389208,8389308: Product flags and controls
    // 8408610: Shopify/ecommerce integration
    // 8480001-8480010: Website feature flags
    
    // Comprehensive field list matching Fieldpine's productedit.htm
    const fieldList = '100-262,300-499,350-352,371-374,512-514,526,4000-4399,8390617,8390618,8391608-8391618,8390713-8390730,8391117,8392117,8392608,8392609,8392708,8392772,8394608,8388814,8388817,8388818,8388908,8389009,8393608,8393609,8393610,8389208,8389308,8408610,8480001-8480010';
    
    console.log('[Product API] Fetching product via BUCK API, ID:', id);
    
    const buckParams: Record<string, string | string[]> = {
      '3': 'retailmax.elink.products',
      '100': '1', // Detail level
      '7': fieldList,
      '9': `f100,0,${id};f503,0,a6`, // Filter by Pid AND include all product statuses (a6)
      '99': Math.random().toString() // Cache buster
    };
    
    // Use store-specific URL for API calls
    const response = await fieldpineServerApi.buckApiCall(
      buckParams,
      context.session.apiKey,
      context.store.url
    );
    
    console.log('[Product API] BUCK response:', { hasResponse: !!response, responseType: typeof response });
    
    // Extract products array from BUCK API response
    let productsArray: any[] = [];
    if (response?.DATS && Array.isArray(response.DATS)) {
      productsArray = response.DATS;
    } else if (response?.data?.DATS && Array.isArray(response.data.DATS)) {
      productsArray = response.data.DATS;
    }
 
    console.log('[Product API] BUCK API returned products:', productsArray?.length || 0);
    
    // BUCK API returns a single product since we filtered by Pid
    const product = productsArray?.[0];
 
    console.log('[Product API] Found product via BUCK:', product ? `f100: ${product?.f100}, f101: ${product?.f101}` : 'Not found');
    
    if (product) {
      console.log('[Product API] Product fields from BUCK API:', Object.keys(product || {}).sort());
      console.log('[Product API] Barcode field (f513):', product?.f513);
    }
 
    console.log('[Product API] Extracted product:', product ? 'Found' : 'Not found');
 
    if (!product) {
      return NextResponse.json(
        { error: 'Product not found' },
        { status: 404 }
      );
    }
 
    // Map BUCK API field codes to standard names
    // Reference: https://www.fieldpine.com/docs/fieldpine-field-reference.html
    
    // Debug: Log department field values
    console.log('[Product API] Department fields for product:', {
      f106: product?.f106,
      f350: product?.f350,
      f351: product?.f351,
      f352: product?.f352,
      f371: product?.f371,
      f372: product?.f372,
      f373: product?.f373,
      f374: product?.f374
    });
    
    const mappedProduct = {
      Pid: product?.f100,
      Description: product?.f101 || product?.f102, // f101=Description, f102=Name
      Name: product?.f102 || product?.f101,
      Price: product?.f103,
      SellPrice: product?.f103,
      Cost: product?.f108,
      CostPrice: product?.f108,
      Plu: product?.f105,
      PLU: product?.f105,
      Depid: product?.f106,
      Department: product?.f106,
      Depid2: product?.f350,
      Depid3: product?.f351,
      Depid4: product?.f352,
      Depid5: product?.f371,
      Depid6: product?.f372,
      Depid7: product?.f373,
      Depid8: product?.f374,
      Spid: product?.f104,
      LastSupplierSpid: product?.f104,
      Barcode: product?.f513, // f513 contains barcodes (can be array or string)
      Barcodes: product?.f513,
      WebGroup: product?.f182,
      Comments: product?.f256,
      Brand: product?.f8389009,
      ShortName: product?.f102,
      WeightGm: product?.f8388814,
      Size: product?.f8388818,
      MainColour: product?.f8388908,
      Hidden: product?.f155,
      NoSell: product?.f151,
      TaxFlag: product?.f112,
      SellFlags: product?.f150,
      StockLevel: product?.f107,
      StockMin: product?.f8390726,
      StockMax: product?.f8390727,
      ReorderLevel: product?.f320,
      ReorderMax: product?.f321,
      SupplierName: product?.f1041, // May not be in response
      SupplierPartCode: product?.f1042, // May not be in response
      Measurement: product?.f111,
      DepartmentName: product?.f1061, // May not be in response
      // Pricing extras
      Freight: product?.f147,
      Packaging: product?.f149,
      DisableDiscounts: product?.f170,
      DecimalPlaces: product?.f346,
      // Warehouse
      PartCount: product?.f211,
      WarehouseLabelName: product?.f212,
      // Dates
      ReleaseDate: product?.f363,
      AvailableDate: product?.f364,
      // Shelf Labels
      ShelfLabelFormat: product?.f349,
      ShelfLabelLine1: product?.f228,
      ShelfLabelLine2: product?.f229,
      ShelfLabelLine3: product?.f230,
      // Advanced Pricing
      ConfirmPrice: product?.f323,
      FranchisePrice: product?.f325,
      PriceBand1: product?.f148,
      PriceBand2: product?.f302,
      PriceBand3: product?.f303,
      // Discount Limits
      LowestPrice: product?.f8389618,
      DiscountLimit1: product?.f8389619,
      DiscountLimit2: product?.f8389620,
      DiscountLimit3: product?.f8389621,
      DiscountLimit4: product?.f8389622,
      DiscountLimit5: product?.f8389623,
      // Stock Control
      SupplySource: product?.f196,
      IgnoreStockMovements: product?.f180,
      RecordStockMovements: product?.f258,
      Placement: product?.f238,
      // Optical/Eyewear
      AlternateFit: product?.f4002 === 'Y' || product?.f4002 === true,
      LensSize: product?.f4003 || '',
      BridgeSize: product?.f4004 || '',
      TempleLength: product?.f4005 || '',
      LensBaseCurve: product?.f4006 || '',
      LensMaterial: product?.f4007 || 0,
      FrameMaterial: product?.f4008 || 0,
      // Website/Marketing
      PublishToWebsite: product?.f198 === 'Y' || product?.f198 === true,
      WebsiteHandling: product?.f315 || 0,
      WebDescription: product?.f8390617 || '',
      WebKeywords: product?.f8392117 || '',
      WebBlurb: product?.f8391117 || '',
      SearchRank: product?.f316 || 0,
      DisplayRank: product?.f319 || 0,
      WebsiteControl: product?.f318 || '',
      OnSpecial: product?.f8390716 === 'Y' || product?.f8390716 === true,
      OutOfStock: product?.f8390717 === 'Y' || product?.f8390717 === true,
      OutOfSeason: product?.f8392609 === 'Y' || product?.f8392609 === true,
      InstoreOnly: product?.f8390718 === 'Y' || product?.f8390718 === true,
      NewProduct: product?.f8390720 === 'Y' || product?.f8390720 === true,
      FreeLocalDelivery: product?.f8390719 === 'Y' || product?.f8390719 === true,
      HighlightProduct: product?.f8390721 === 'Y' || product?.f8390721 === true,
      FeaturedProduct: product?.f8480001 === 'Y' || product?.f8480001 === true,
      PromoteProduct: product?.f8480002 === 'Y' || product?.f8480002 === true,
      MarketingColor1: product?.f234 || '',
      MarketingColor2: product?.f235 || '',
      MarketingColor3: product?.f236 || '',
      MarketingColor4: product?.f237 || '',
      InstallationUrl: product?.f240 || '',
      WarrantyUrl: product?.f241 || '',
      UpsellUrl: product?.f242 || '',
      MarketingUrl: product?.f243 || '',
      // Measurements
      MeasurementId: product?.f111 || 1,
      StockMeasurementId: product?.f114 || 1,
      DisplayMeasurementId: product?.f115 || 1,
      PackagingWeight: product?.f213 || 0,
      LengthMm: product?.f353 || 0,
      WidthMm: product?.f354 || 0,
      HeightMm: product?.f355 || 0,
      ShippingCubic: product?.f356 || 0,
      // Supply/Ordering
      ManufacturerPartCode: product?.f314 || '',
      OrderCategory: product?.f328 || 0,
      MessageWhenOrdering: product?.f221 || '',
      DisableOrdering: product?.f222 === 'Y' || product?.f222 === true,
      MinUnitsPerOrder: product?.f223 || 0,
      MaxUnitsPerOrder: product?.f224 || 0,
      PriorityColorCode: product?.f220 || 0,
      ImportanceLevel: product?.f178 || 0,
      // Debug/System (read-only)
      Physkey: product?.f210 || 0,
      GlobalKey: product?.f329 || 0,
      Rve: product?.f249 || 0,
      CreateDateTime: product?.f219 || '',
      ProcessFlags: product?.f253 || 0,
      ShopifyId: product?.f4208 || 0,
      BigcommerceId: product?.f4209 || 0,
      RmSystem: product?.f251 || 0,
      ExtractFlags: product?.f342 || 0,
      // Additional fields discovered from HAR file
      // Barcodes
      Barcode513: product?.f513 || '',
      Barcode512: product?.f512 || '',
      Barcode514: product?.f514 || '',
      // Food Attributes (8391608-8391618)
      IsGlutenFree: product?.f8391608 === 'Y' || product?.f8391608 === true || product?.f8391608 === '1',
      IsOrganic: product?.f8391609 === 'Y' || product?.f8391609 === true || product?.f8391609 === '1',
      IsDairyFree: product?.f8391610 === 'Y' || product?.f8391610 === true || product?.f8391610 === '1',
      IsLowSugar: product?.f8391611 === 'Y' || product?.f8391611 === true || product?.f8391611 === '1',
      IsVegan: product?.f8391612 === 'Y' || product?.f8391612 === true || product?.f8391612 === '1',
      IsLowSalt: product?.f8391613 === 'Y' || product?.f8391613 === true || product?.f8391613 === '1',
      IsYeastFree: product?.f8391614 === 'Y' || product?.f8391614 === true || product?.f8391614 === '1',
      IsLowFat: product?.f8391615 === 'Y' || product?.f8391615 === true || product?.f8391615 === '1',
      IsRaw: product?.f8391616 === 'Y' || product?.f8391616 === true || product?.f8391616 === '1',
      IsKosher: product?.f8391617 === 'Y' || product?.f8391617 === true || product?.f8391617 === '1',
      IsEdible: product?.f8391618 === 'Y' || product?.f8391618 === true || product?.f8391618 === '1',
      // Additional product attributes
      LensType: product?.f8393608 || '',
      MadeFrom: product?.f8389208 || '',
      DesignShape: product?.f8389308 || '',
      Polarised: product?.f232 === 'Y' || product?.f232 === true,
      Mirrored: product?.f233 === 'Y' || product?.f233 === true,
      Perishable: product?.f231 === 'Y' || product?.f231 === true,
      BlueLight: product?.f362 === 'Y' || product?.f362 === true,
      // Supply chain
      FairTrade: product?.f8392608 === 'Y' || product?.f8392608 === true,
      CountryMade: product?.f8392708 || '',
      NZMade: product?.f8392772 === 'Y' || product?.f8392772 === true,
      // eCommerce additional flags
      Gender: product?.f8408610 || '',
      ASNZSCompliance: product?.f8394608 || '',
      // Additional website flags (8480003-8480010)
      WebsiteBackgroundItem: product?.f8480003 === 'Y' || product?.f8480003 === true,
      WebsitePositionTop: product?.f8480004 === 'Y' || product?.f8480004 === true,
      WebsitePositionLeft: product?.f8480005 === 'Y' || product?.f8480005 === true,
      WebsitePositionBottom: product?.f8480006 === 'Y' || product?.f8480006 === true,
      WebsitePositionRight: product?.f8480007 === 'Y' || product?.f8480007 === true,
      WebsiteTag: product?.f8481000 || '',
      // Extended product properties
      Model: product?.f348 || '',
      ItemColor: product?.f357 || '',
      Cartridge: product?.f358 || '',
      Refillable: product?.f360 === 'Y' || product?.f360 === true,
      InternalSupportUrl: product?.f361 || '',
      RxAble: product?.f380 || 0,
      ProductCase: product?.f381 || '',
      Warranty: product?.f382 || '',
      ProductManufacturer: product?.f383 || '',
      PaperSize: product?.f394 || '',
      PrinterConnectivity: product?.f395 || '',
      PrintingTechnology: product?.f396 || '',
      PrinterAdfCapacity: product?.f397 || '',
      PrintSpeed: product?.f398 || '',
      ScanResolution: product?.f399 || '',
      PrinterPaperCapacity: product?.f400 || '',
      NonTangibleItem: product?.f8393609 === 'Y' || product?.f8393609 === true,
      OneOffItem: product?.f8393610 === 'Y' || product?.f8393610 === true,
      // Prompting fields
      PromptRegno: product?.f8394609 === 'Y' || product?.f8394609 === true,
      PromptLTNZNo: product?.f8394610 === 'Y' || product?.f8394610 === true,
      PromptDocument: product?.f8394611 === 'Y' || product?.f8394611 === true,
      PromptCustomer: product?.f8394612 === 'Y' || product?.f8394612 === true
    };
 
    return NextResponse.json({
      success: true,
      data: mappedProduct,
      source: 'buck-api'
    });
 
  } catch (error) {
    console.error('Product API error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch product' },
      { status: 500 }
    );
  }
}
 
/**
 * PUT /api/v1/openapi/products/[id] - Update product
 */
export async function PUT(
  request: NextRequest,
  { params }: { params: Promise<{ id: string }> }
) {
  console.log('[Product API PUT] ===== HANDLER STARTING =====');
  try {
    const { id } = await params;
    const body = await request.json();
    
    console.log('[Product API PUT] Updating product:', id, body);
    
    // Get and validate session
    console.log('[Product API PUT] Getting request context...');
    const context = await getRequestContext(request);
    console.log('[Product API PUT] Got context, validating API access...');
    const validation = validateApiAccess(context, 'elink');
    console.log('[Product API PUT] Validation result:', validation);
    
    // Handle both { valid: true } and true responses
    const isValid = typeof validation === 'boolean' ? validation : validation.valid;
    if (!isValid || !context) {
      console.log('[Product API PUT] Validation failed, returning error response');
      const errorMsg = typeof validation === 'object' ? validation.error : 'Access denied';
      const errorCode = typeof validation === 'object' ? validation.errorCode : undefined;
      return NextResponse.json(
        { success: false, error: errorMsg || 'Access denied', errorCode },
        { status: 403 }
      );
    }
    console.log('[Product API PUT] Validation passed, proceeding...');
 
    // Map frontend fields to Fieldpine API format
    const updateData: any = {};
    
    // Basic fields
    if (body.name !== undefined) updateData.Description = body.name;
    if (body.shortName !== undefined) updateData.ShortName = body.shortName;
    if (body.plu !== undefined) updateData.Plu = body.plu;
    if (body.barcode !== undefined) updateData.Barcode = body.barcode;
    
    // Pricing
    if (body.sellPrice !== undefined) updateData.Price = parseFloat(body.sellPrice);
    if (body.costPrice !== undefined) updateData.Cost = parseFloat(body.costPrice);
    
    // Departments (all 8 levels)
    if (body.department !== undefined) updateData.Depid = parseInt(body.department) || null;
    if (body.department2 !== undefined) updateData.Depid2 = body.department2 ? parseInt(body.department2) : null;
    if (body.department3 !== undefined) updateData.Depid3 = body.department3 ? parseInt(body.department3) : null;
    if (body.department4 !== undefined) updateData.Depid4 = body.department4 ? parseInt(body.department4) : null;
    if (body.department5 !== undefined) updateData.Depid5 = body.department5 ? parseInt(body.department5) : null;
    if (body.department6 !== undefined) updateData.Depid6 = body.department6 ? parseInt(body.department6) : null;
    if (body.department7 !== undefined) updateData.Depid7 = body.department7 ? parseInt(body.department7) : null;
    if (body.department8 !== undefined) updateData.Depid8 = body.department8 ? parseInt(body.department8) : null;
    
    // Pricing extras
    if (body.freight !== undefined) updateData.Freight = body.freight ? parseFloat(body.freight) : null;
    if (body.packaging !== undefined) updateData.Packaging = body.packaging ? parseFloat(body.packaging) : null;
    if (body.disableDiscounts !== undefined) updateData.DisableDiscounts = body.disableDiscounts ? 'Y' : 'N';
    
    // Warehouse
    if (body.partCount !== undefined) updateData.PartCount = body.partCount ? parseInt(body.partCount) : null;
    if (body.warehouseLabelName !== undefined) updateData.WarehouseLabelName = body.warehouseLabelName;
    
    // Dates
    if (body.releaseDate !== undefined) updateData.ReleaseDate = body.releaseDate;
    if (body.availableDate !== undefined) updateData.AvailableDate = body.availableDate;
    
    // Shelf Labels
    if (body.shelfLabelFormat !== undefined) updateData.ShelfLabelFormat = body.shelfLabelFormat;
    if (body.shelfLabelLine1 !== undefined) updateData.ShelfLabelLine1 = body.shelfLabelLine1;
    if (body.shelfLabelLine2 !== undefined) updateData.ShelfLabelLine2 = body.shelfLabelLine2;
    if (body.shelfLabelLine3 !== undefined) updateData.ShelfLabelLine3 = body.shelfLabelLine3;
    
    // Supplier information
    if (body.supplierId !== undefined) updateData.LastSupplierSpid = parseInt(body.supplierId) || null;
    if (body.supplierName !== undefined) updateData.SupplierName = body.supplierName;
    if (body.supplierPartCode !== undefined) updateData.SupplierPartCode = body.supplierPartCode;
    
    // Stock levels
    if (body.stockMin !== undefined) updateData.ReorderLevel = parseFloat(body.stockMin);
    if (body.stockMax !== undefined) updateData.ReorderMax = parseFloat(body.stockMax);
    
    // Flags
    if (body.taxFlag !== undefined) updateData.TaxFlag = body.taxFlag ? 1 : 0;
    if (body.noSell !== undefined) updateData.NoSell = body.noSell ? 'Y' : 'N';
    if (body.hidden !== undefined) updateData.Hidden = body.hidden ? 'Y' : 'N';
    
    // Product attributes
    if (body.brand !== undefined) updateData.Brand = body.brand;
    if (body.weightGm !== undefined) updateData.WeightGm = body.weightGm ? parseFloat(body.weightGm) : null;
    if (body.size !== undefined) updateData.Size = body.size;
    if (body.webGroup !== undefined) updateData.WebGroup = body.webGroup;
    if (body.comments !== undefined) updateData.Comments = body.comments;
    
    // Advanced Pricing
    if (body.confirmPrice !== undefined) updateData.ConfirmPrice = body.confirmPrice ? 'Y' : 'N';
    if (body.franchisePrice !== undefined) updateData.FranchisePrice = body.franchisePrice ? parseFloat(body.franchisePrice) : null;
    if (body.priceBand1 !== undefined) updateData.PriceBand1 = body.priceBand1 ? parseFloat(body.priceBand1) : null;
    if (body.priceBand2 !== undefined) updateData.PriceBand2 = body.priceBand2 ? parseFloat(body.priceBand2) : null;
    if (body.priceBand3 !== undefined) updateData.PriceBand3 = body.priceBand3 ? parseFloat(body.priceBand3) : null;
    
    // Discount Limits
    if (body.lowestPrice !== undefined) updateData.LowestPrice = body.lowestPrice ? parseFloat(body.lowestPrice) : null;
    if (body.discountLimit1 !== undefined) updateData.DiscountLimit1 = body.discountLimit1 ? parseFloat(body.discountLimit1) : null;
    if (body.discountLimit2 !== undefined) updateData.DiscountLimit2 = body.discountLimit2 ? parseFloat(body.discountLimit2) : null;
    if (body.discountLimit3 !== undefined) updateData.DiscountLimit3 = body.discountLimit3 ? parseFloat(body.discountLimit3) : null;
    if (body.discountLimit4 !== undefined) updateData.DiscountLimit4 = body.discountLimit4 ? parseFloat(body.discountLimit4) : null;
    if (body.discountLimit5 !== undefined) updateData.DiscountLimit5 = body.discountLimit5 ? parseFloat(body.discountLimit5) : null;
    
    // Stock Control
    if (body.supplySource !== undefined) updateData.SupplySource = parseInt(body.supplySource) || 0;
    if (body.ignoreStockMovements !== undefined) updateData.IgnoreStockMovements = body.ignoreStockMovements ? 'Y' : 'N';
    if (body.recordStockMovements !== undefined) updateData.RecordStockMovements = body.recordStockMovements ? 'Y' : 'N';
    if (body.placement !== undefined) updateData.Placement = parseInt(body.placement) || 0;
    
    // Optical/Eyewear fields
    if (body.alternateFit !== undefined) updateData.AlternateFit = body.alternateFit ? 'Y' : 'N';
    if (body.lensSize !== undefined) updateData.LensSize = body.lensSize;
    if (body.bridgeSize !== undefined) updateData.BridgeSize = body.bridgeSize;
    if (body.templeLength !== undefined) updateData.TempleLength = body.templeLength;
    if (body.lensBaseCurve !== undefined) updateData.LensBaseCurve = body.lensBaseCurve;
    if (body.lensMaterial !== undefined) updateData.LensMaterial = parseInt(body.lensMaterial) || 0;
    if (body.frameMaterial !== undefined) updateData.FrameMaterial = parseInt(body.frameMaterial) || 0;
    
    // Website/Marketing fields
    if (body.publishToWebsite !== undefined) updateData.PublishToWebsite = body.publishToWebsite ? 'Y' : 'N';
    if (body.websiteHandling !== undefined) updateData.WebsiteHandling = parseInt(body.websiteHandling) || 0;
    if (body.webDescription !== undefined) updateData.WebDescription = body.webDescription;
    if (body.webKeywords !== undefined) updateData.WebKeywords = body.webKeywords;
    if (body.webBlurb !== undefined) updateData.WebBlurb = body.webBlurb;
    if (body.searchRank !== undefined) updateData.SearchRank = parseInt(body.searchRank) || 0;
    if (body.displayRank !== undefined) updateData.DisplayRank = parseInt(body.displayRank) || 0;
    if (body.websiteControl !== undefined) updateData.WebsiteControl = body.websiteControl;
    if (body.onSpecial !== undefined) updateData.OnSpecial = body.onSpecial ? 'Y' : 'N';
    if (body.outOfStock !== undefined) updateData.OutOfStock = body.outOfStock ? 'Y' : 'N';
    if (body.outOfSeason !== undefined) updateData.OutOfSeason = body.outOfSeason ? 'Y' : 'N';
    if (body.instoreOnly !== undefined) updateData.InstoreOnly = body.instoreOnly ? 'Y' : 'N';
    if (body.newProduct !== undefined) updateData.NewProduct = body.newProduct ? 'Y' : 'N';
    if (body.freeLocalDelivery !== undefined) updateData.FreeLocalDelivery = body.freeLocalDelivery ? 'Y' : 'N';
    if (body.highlightProduct !== undefined) updateData.HighlightProduct = body.highlightProduct ? 'Y' : 'N';
    if (body.featuredProduct !== undefined) updateData.FeaturedProduct = body.featuredProduct ? 'Y' : 'N';
    if (body.promoteProduct !== undefined) updateData.PromoteProduct = body.promoteProduct ? 'Y' : 'N';
    if (body.marketingColor1 !== undefined) updateData.MarketingColor1 = body.marketingColor1;
    if (body.marketingColor2 !== undefined) updateData.MarketingColor2 = body.marketingColor2;
    if (body.marketingColor3 !== undefined) updateData.MarketingColor3 = body.marketingColor3;
    if (body.marketingColor4 !== undefined) updateData.MarketingColor4 = body.marketingColor4;
    if (body.installationUrl !== undefined) updateData.InstallationUrl = body.installationUrl;
    if (body.warrantyUrl !== undefined) updateData.WarrantyUrl = body.warrantyUrl;
    if (body.upsellUrl !== undefined) updateData.UpsellUrl = body.upsellUrl;
    if (body.marketingUrl !== undefined) updateData.MarketingUrl = body.marketingUrl;
    
    // Measurement fields
    if (body.measurementId !== undefined) updateData.MeasurementId = parseInt(body.measurementId) || 1;
    if (body.stockMeasurementId !== undefined) updateData.StockMeasurementId = parseInt(body.stockMeasurementId) || 1;
    if (body.displayMeasurementId !== undefined) updateData.DisplayMeasurementId = parseInt(body.displayMeasurementId) || 1;
    if (body.packagingWeight !== undefined) updateData.PackagingWeight = parseFloat(body.packagingWeight) || 0;
    if (body.lengthMm !== undefined) updateData.LengthMm = parseFloat(body.lengthMm) || 0;
    if (body.widthMm !== undefined) updateData.WidthMm = parseFloat(body.widthMm) || 0;
    if (body.heightMm !== undefined) updateData.HeightMm = parseFloat(body.heightMm) || 0;
    if (body.shippingCubic !== undefined) updateData.ShippingCubic = parseFloat(body.shippingCubic) || 0;
    
    // Supply/Ordering fields
    if (body.manufacturerPartCode !== undefined) updateData.ManufacturerPartCode = body.manufacturerPartCode;
    if (body.orderCategory !== undefined) updateData.OrderCategory = parseInt(body.orderCategory) || 0;
    if (body.messageWhenOrdering !== undefined) updateData.MessageWhenOrdering = body.messageWhenOrdering;
    if (body.disableOrdering !== undefined) updateData.DisableOrdering = body.disableOrdering ? 'Y' : 'N';
    if (body.minUnitsPerOrder !== undefined) updateData.MinUnitsPerOrder = parseInt(body.minUnitsPerOrder) || 0;
    if (body.maxUnitsPerOrder !== undefined) updateData.MaxUnitsPerOrder = parseInt(body.maxUnitsPerOrder) || 0;
    if (body.priorityColorCode !== undefined) updateData.PriorityColorCode = parseInt(body.priorityColorCode) || 0;
    if (body.importanceLevel !== undefined) updateData.ImportanceLevel = parseInt(body.importanceLevel) || 0;
 
    console.log('[Product API PUT] Mapped update data:', updateData);
 
    // Use BUCK API for updates - same method as reads but with parameter '4': '1' for update
    const buckUpdateParams: Record<string, string> = {
      '3': 'retailmax.elink.products',
      '4': '1', // Update operation
      '9': `f100,0,${id}`, // Filter by product ID
      '99': Math.random().toString() // Cache buster
    };
 
    // Add update fields using Fieldpine field codes
    if (updateData.Description !== undefined) buckUpdateParams['101'] = updateData.Description;
    if (updateData.ShortName !== undefined) buckUpdateParams['102'] = updateData.ShortName;
    if (updateData.Plu !== undefined) buckUpdateParams['105'] = updateData.Plu;
    if (updateData.Barcode !== undefined) buckUpdateParams['513'] = updateData.Barcode;
    if (updateData.Price !== undefined) buckUpdateParams['103'] = updateData.Price.toString();
    if (updateData.Cost !== undefined) buckUpdateParams['108'] = updateData.Cost.toString();
    if (updateData.Depid !== undefined) buckUpdateParams['106'] = updateData.Depid?.toString() || '';
    if (updateData.Depid2 !== undefined) buckUpdateParams['350'] = updateData.Depid2?.toString() || '';
    if (updateData.Depid3 !== undefined) buckUpdateParams['351'] = updateData.Depid3?.toString() || '';
    if (updateData.Depid4 !== undefined) buckUpdateParams['352'] = updateData.Depid4?.toString() || '';
    if (updateData.Depid5 !== undefined) buckUpdateParams['371'] = updateData.Depid5?.toString() || '';
    if (updateData.Depid6 !== undefined) buckUpdateParams['372'] = updateData.Depid6?.toString() || '';
    if (updateData.Depid7 !== undefined) buckUpdateParams['373'] = updateData.Depid7?.toString() || '';
    if (updateData.Depid8 !== undefined) buckUpdateParams['374'] = updateData.Depid8?.toString() || '';
    if (updateData.LastSupplierSpid !== undefined) buckUpdateParams['104'] = updateData.LastSupplierSpid?.toString() || '';
    if (updateData.Freight !== undefined) buckUpdateParams['147'] = updateData.Freight?.toString() || '';
    if (updateData.Packaging !== undefined) buckUpdateParams['149'] = updateData.Packaging?.toString() || '';
    if (updateData.DisableDiscounts !== undefined) buckUpdateParams['170'] = updateData.DisableDiscounts;
    if (updateData.PartCount !== undefined) buckUpdateParams['211'] = updateData.PartCount?.toString() || '';
    if (updateData.WarehouseLabelName !== undefined) buckUpdateParams['212'] = updateData.WarehouseLabelName;
    if (updateData.ShelfLabelLine1 !== undefined) buckUpdateParams['228'] = updateData.ShelfLabelLine1;
    if (updateData.ShelfLabelLine2 !== undefined) buckUpdateParams['229'] = updateData.ShelfLabelLine2;
    if (updateData.ShelfLabelLine3 !== undefined) buckUpdateParams['230'] = updateData.ShelfLabelLine3;
    if (updateData.ShelfLabelFormat !== undefined) buckUpdateParams['349'] = updateData.ShelfLabelFormat;
    if (updateData.ReleaseDate !== undefined) buckUpdateParams['363'] = updateData.ReleaseDate;
    if (updateData.AvailableDate !== undefined) buckUpdateParams['364'] = updateData.AvailableDate;
    if (updateData.ReorderLevel !== undefined) buckUpdateParams['8390726'] = updateData.ReorderLevel.toString();
    if (updateData.ReorderMax !== undefined) buckUpdateParams['8390727'] = updateData.ReorderMax.toString();
    if (updateData.TaxFlag !== undefined) buckUpdateParams['112'] = updateData.TaxFlag.toString();
    if (updateData.NoSell !== undefined) buckUpdateParams['151'] = updateData.NoSell;
    if (updateData.Hidden !== undefined) buckUpdateParams['155'] = updateData.Hidden;
    if (updateData.Brand !== undefined) buckUpdateParams['8389009'] = updateData.Brand;
    if (updateData.WeightGm !== undefined) buckUpdateParams['8388814'] = updateData.WeightGm?.toString() || '';
    if (updateData.Size !== undefined) buckUpdateParams['8388818'] = updateData.Size;
    if (updateData.WebGroup !== undefined) buckUpdateParams['182'] = updateData.WebGroup.toString();
    if (updateData.Comments !== undefined) buckUpdateParams['256'] = updateData.Comments;
    if (updateData.ConfirmPrice !== undefined) buckUpdateParams['323'] = updateData.ConfirmPrice;
    if (updateData.FranchisePrice !== undefined) buckUpdateParams['325'] = updateData.FranchisePrice?.toString() || '';
    if (updateData.PriceBand1 !== undefined) buckUpdateParams['148'] = updateData.PriceBand1?.toString() || '';
    if (updateData.PriceBand2 !== undefined) buckUpdateParams['302'] = updateData.PriceBand2?.toString() || '';
    if (updateData.PriceBand3 !== undefined) buckUpdateParams['303'] = updateData.PriceBand3?.toString() || '';
    if (updateData.LowestPrice !== undefined) buckUpdateParams['8389618'] = updateData.LowestPrice?.toString() || '';
    if (updateData.DiscountLimit1 !== undefined) buckUpdateParams['8389619'] = updateData.DiscountLimit1?.toString() || '';
    if (updateData.DiscountLimit2 !== undefined) buckUpdateParams['8389620'] = updateData.DiscountLimit2?.toString() || '';
    if (updateData.DiscountLimit3 !== undefined) buckUpdateParams['8389621'] = updateData.DiscountLimit3?.toString() || '';
    if (updateData.DiscountLimit4 !== undefined) buckUpdateParams['8389622'] = updateData.DiscountLimit4?.toString() || '';
    if (updateData.DiscountLimit5 !== undefined) buckUpdateParams['8389623'] = updateData.DiscountLimit5?.toString() || '';
    if (updateData.SupplySource !== undefined) buckUpdateParams['196'] = updateData.SupplySource.toString();
    if (updateData.IgnoreStockMovements !== undefined) buckUpdateParams['180'] = updateData.IgnoreStockMovements;
    if (updateData.RecordStockMovements !== undefined) buckUpdateParams['258'] = updateData.RecordStockMovements;
    if (updateData.Placement !== undefined) buckUpdateParams['238'] = updateData.Placement.toString();
    // Optical/Eyewear
    if (updateData.AlternateFit !== undefined) buckUpdateParams['4002'] = updateData.AlternateFit;
    if (updateData.LensSize !== undefined) buckUpdateParams['4003'] = updateData.LensSize;
    if (updateData.BridgeSize !== undefined) buckUpdateParams['4004'] = updateData.BridgeSize;
    if (updateData.TempleLength !== undefined) buckUpdateParams['4005'] = updateData.TempleLength;
    if (updateData.LensBaseCurve !== undefined) buckUpdateParams['4006'] = updateData.LensBaseCurve;
    if (updateData.LensMaterial !== undefined) buckUpdateParams['4007'] = updateData.LensMaterial.toString();
    if (updateData.FrameMaterial !== undefined) buckUpdateParams['4008'] = updateData.FrameMaterial.toString();
    // Website/Marketing
    if (updateData.PublishToWebsite !== undefined) buckUpdateParams['198'] = updateData.PublishToWebsite;
    if (updateData.WebsiteHandling !== undefined) buckUpdateParams['315'] = updateData.WebsiteHandling.toString();
    if (updateData.WebDescription !== undefined) buckUpdateParams['8390617'] = updateData.WebDescription;
    if (updateData.WebKeywords !== undefined) buckUpdateParams['8392117'] = updateData.WebKeywords;
    if (updateData.WebBlurb !== undefined) buckUpdateParams['8391117'] = updateData.WebBlurb;
    if (updateData.SearchRank !== undefined) buckUpdateParams['316'] = updateData.SearchRank.toString();
    if (updateData.DisplayRank !== undefined) buckUpdateParams['319'] = updateData.DisplayRank.toString();
    if (updateData.WebsiteControl !== undefined) buckUpdateParams['318'] = updateData.WebsiteControl;
    if (updateData.OnSpecial !== undefined) buckUpdateParams['8390716'] = updateData.OnSpecial;
    if (updateData.OutOfStock !== undefined) buckUpdateParams['8390717'] = updateData.OutOfStock;
    if (updateData.OutOfSeason !== undefined) buckUpdateParams['8392609'] = updateData.OutOfSeason;
    if (updateData.InstoreOnly !== undefined) buckUpdateParams['8390718'] = updateData.InstoreOnly;
    if (updateData.NewProduct !== undefined) buckUpdateParams['8390720'] = updateData.NewProduct;
    if (updateData.FreeLocalDelivery !== undefined) buckUpdateParams['8390719'] = updateData.FreeLocalDelivery;
    if (updateData.HighlightProduct !== undefined) buckUpdateParams['8390721'] = updateData.HighlightProduct;
    if (updateData.FeaturedProduct !== undefined) buckUpdateParams['8480001'] = updateData.FeaturedProduct;
    if (updateData.PromoteProduct !== undefined) buckUpdateParams['8480002'] = updateData.PromoteProduct;
    if (updateData.MarketingColor1 !== undefined) buckUpdateParams['234'] = updateData.MarketingColor1;
    if (updateData.MarketingColor2 !== undefined) buckUpdateParams['235'] = updateData.MarketingColor2;
    if (updateData.MarketingColor3 !== undefined) buckUpdateParams['236'] = updateData.MarketingColor3;
    if (updateData.MarketingColor4 !== undefined) buckUpdateParams['237'] = updateData.MarketingColor4;
    if (updateData.InstallationUrl !== undefined) buckUpdateParams['240'] = updateData.InstallationUrl;
    if (updateData.WarrantyUrl !== undefined) buckUpdateParams['241'] = updateData.WarrantyUrl;
    if (updateData.UpsellUrl !== undefined) buckUpdateParams['242'] = updateData.UpsellUrl;
    if (updateData.MarketingUrl !== undefined) buckUpdateParams['243'] = updateData.MarketingUrl;
    // Measurements
    if (updateData.MeasurementId !== undefined) buckUpdateParams['111'] = updateData.MeasurementId.toString();
    if (updateData.StockMeasurementId !== undefined) buckUpdateParams['114'] = updateData.StockMeasurementId.toString();
    if (updateData.DisplayMeasurementId !== undefined) buckUpdateParams['115'] = updateData.DisplayMeasurementId.toString();
    if (updateData.PackagingWeight !== undefined) buckUpdateParams['213'] = updateData.PackagingWeight.toString();
    if (updateData.LengthMm !== undefined) buckUpdateParams['353'] = updateData.LengthMm.toString();
    if (updateData.WidthMm !== undefined) buckUpdateParams['354'] = updateData.WidthMm.toString();
    if (updateData.HeightMm !== undefined) buckUpdateParams['355'] = updateData.HeightMm.toString();
    if (updateData.ShippingCubic !== undefined) buckUpdateParams['356'] = updateData.ShippingCubic.toString();
    // Supply/Ordering
    if (updateData.ManufacturerPartCode !== undefined) buckUpdateParams['314'] = updateData.ManufacturerPartCode;
    if (updateData.OrderCategory !== undefined) buckUpdateParams['328'] = updateData.OrderCategory.toString();
    if (updateData.MessageWhenOrdering !== undefined) buckUpdateParams['221'] = updateData.MessageWhenOrdering;
    if (updateData.DisableOrdering !== undefined) buckUpdateParams['222'] = updateData.DisableOrdering;
    if (updateData.MinUnitsPerOrder !== undefined) buckUpdateParams['223'] = updateData.MinUnitsPerOrder.toString();
    if (updateData.MaxUnitsPerOrder !== undefined) buckUpdateParams['224'] = updateData.MaxUnitsPerOrder.toString();
    if (updateData.PriorityColorCode !== undefined) buckUpdateParams['220'] = updateData.PriorityColorCode.toString();
    if (updateData.ImportanceLevel !== undefined) buckUpdateParams['178'] = updateData.ImportanceLevel.toString();
 
    console.log('[Product API PUT] BUCK update params:', buckUpdateParams);
 
    const result = await fieldpineServerApi.buckApiCall(
      buckUpdateParams,
      context.session.apiKey,
      context.store.url
    );
 
    console.log('[Product API PUT] Update response:', result);
 
    return NextResponse.json({
      success: true,
      data: result,
      message: 'Product updated successfully'
    });
 
  } catch (error) {
    console.error('[Product API PUT] Update error:', error);
    return NextResponse.json(
      { success: false, error: 'Failed to update product' },
      { status: 500 }
    );
  }
}