Skip to Content
0
Former Member
Feb 11, 2015 at 07:26 PM

Sync issues on Price Rows: error copying 8807118046239 due to missing unit for price row

400 Views

When attempting to sync certain products we get this error:

 ERROR [SyncWorker<000053QW 1 of 5>] [10.17.1.3] (000053QW) [AbstractItemCopyContext] error copying 8807117521951 due to missing unit for price row 
 ERROR [SyncWorker<000053QW 1 of 5>] [10.17.1.3] (000053QW) [AbstractItemCopyContext] (Failed) CopyReport src:8807117521951, target:n/a
     mode:create
     time: total:0ms, read:0ms, copyAttr:0ms, create:0ms, refs:0ms 
     wrote initial attributes 
         owner[c] value:<NULL> unchanged 
         pg[c] value:<NULL> unchanged 
         product[c] value:Product 'AECHABK15-2RA' (8805268652033) changed into Product 'AECHABK15-2RA' (8805336023041)
         currency[?] value:8796125855777->USD unchanged 
         dateRange[A] value:<NULL> unchanged 
         endTime[A] value:<NULL> unchanged 
         giveAwayPrice[A?] value:false unchanged 
         matchValue[A] value:5 unchanged 
         minqtd[A] value:1 unchanged 
         net[A] value:false unchanged 
         price[A?] value:45.0 unchanged 
         priceType[?] value:PriceType.WHOLESALEPRICE(WHOLESALEPRICE(8796115239003)) unchanged 
         productMatchQualifier[A] value:8805268652033 unchanged 
         sequenceId[A] value:<NULL> unchanged 
         startTime[A] value:<NULL> unchanged 
         unitFactor[A] value:1 unchanged 
         userMatchQualifier[A] value:0 unchanged 
     blacklist: {modifiedtime=true}
     whitelist: {pg=true, product=true, user=true, productmatchqualifier=true, alldocuments=true, owner=true, unit=true, currency=true, matchvalue=true, starttime=true, minqtd=true, catalogversion=true, endtime=true, unitfactor=true, daterange=true, net=true, usermatchqualifier=true, pricetype=true, price=true, sequenceid=true, giveawayprice=true, ug=true}
         excluded attributes 
         comments[] due to whitelist
         assignedCockpitItemTemplates[] due to whitelist
         creationtime[Ac] due to whitelist

not all products throw this error, but the products that do still do even after deleting and reimporting via ImpEx:

 $productCatalog=smithopticsProductCatalog
 $catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default=$productCatalog:Staged]
 $baseProduct=baseProduct(code, catalogVersion(catalog(id[default='$productCatalog']),version[default='Staged']))
 $approved=approvalstatus(code)[default='approved']
 $lang=en
 
 INSERT_UPDATE SOSunglass;code[unique=true];variantType(code)[default=SOSunglassVariant];name[lang=$lang];eliteName[lang=$lang];metaDescription[lang=$lang];description[lang=$lang];family(code[unique=true])[mode=replace];fit(code[unique=true]);shape(code[unique=true]);popularitySort;nosePadMaterial;templePadMaterial;templeTipDistance;templeLength;lensWidth;lensHeight;noseBridge;metaTitle;metaKeywords;$catalogVersion;$approved
 ;AEGIS_ECHO_II_7_2071000415;;Aegis Echo II;Aegis Echo II;;;;;;1138;;;;;;;;;;;
 
 INSERT_UPDATE SOSunglassVariant;code[unique=true];$baseProduct;name[lang=$lang];color[lang=$lang];lensColor[lang=$lang];precedence;colorFamily;lensVLT;lensCategory;lensScale[lang=$lang];lensMaterial[lang=$lang];lensDescription[lang=$lang];supercategories(code, $catalogVersion)[mode=replace];canadianFlag;inline;upc;planCode; division;businessUnit;line; productClass;b2bOnly;$catalogVersion;$approved
 ;AECHABK15-2RA;AEGIS_ECHO_II_7_2071000415;Aegis Echo II Asian Fit ;Black;Clear, Gray;;;;;;;;1140,2140;;;;20710004;7;710;2710;;;;
 
 
 INSERT_UPDATE PriceRow;product(code,$catalogVersion)[unique=true];price;currency(isocode)[unique=true];priceType(code)[unique=true];unit(code[default=pieces]);unitFactor[default=1];$catalogVersion
 ;AECHABK15-2RA;45;USD;WHOLESALEPRICE;;;
 ;AECHABK15-2RA;90;USD;MSRP;;;