Skip to Content
0
Former Member
Sep 14, 2017 at 02:34 PM

Impex import, some values are nulls

448 Views

Hi Guys, I'm exporting PriceRows for Order, and I want to import them back by impex. Got something like that:

 # ---- Extension: europe1 ---- Type: PriceRow ----
 "#% impex.setTargetFile( ""PriceRow.csv"" );"
 insert_update PriceRow;&pk[unique=true];basePrice;bundleTemplateIds;catalogVersion(catalog(id),version);channel(code,itemtype(code));creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss.SSS, unique=true];currency(isocode)[allownull=true];endTime[dateformat=dd.MM.yyyy hh:mm:ss];giveAwayPrice[allownull=true];matchValue;minqtd[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss.SSS];netPrice;netPriceBeforePromotion;net[allownull=true];oldPrice;priceBeforePromotion;priceListId;price[allownull=true];product(catalogVersion(catalog(id),version),code)[unique=true];productMatchQualifier;sequenceId;startTime[dateformat=dd.MM.yyyy hh:mm:ss.SSS];unit(code)[allownull=true];unitFactor[allownull=true];user(uid);userMatchQualifier
 "#% impex.exportItemsFlexibleSearch( ""$select {pk} $fromPriceRow"");"

So in the result, I have some PriceRows with all fields filled (in the CSV file), but for some reason, I 'm getting null values on some PriceRows when I'm importing them into my system, and the using them:

             Optional<PriceRowModel> priceRow = ((ColorVariantProductModel) orderEntry.getProduct())
                     .getBaseProduct()
                     .getEurope1Prices()
                     .stream()
                     .filter(price -> price.getPriceListId() != null)
                     .filter(price -> itemProductVO.getPriceListId().equals(Long.valueOf(price.getPriceListId())))
                     .findFirst();

price.getPriceListID() is null for some PriceRows, and I don't know why. Maybe you have this kind of problem?

Best regards