on 02-11-2015 7:26 PM
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;;;
Hi Ryan, Could you please specify the priceType ? It is a custom type ? Regards, Sergio.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.