Developer forum

Hi Andrejs,
I can not get it reproduced. Is everything imported and displayed correctly in the UI? Have you imported the data in the default language and tried to save it in the default language? Does it happen with any selected stock unit or only with the imported? What is your BC request xml and what providers do you use?
BR, Dmitrij

Hi Dmitriy

Is everything imported and displayed correctly in the UI?

Yes 

Have you imported the data in the default language and tried to save it in the default language?

Yes

Does it happen with any selected stock unit or only with the imported?

Only with imported stock units, if you create new stock unit, I can't reproduce this issue.

I tested OdataProvider and XML as source to DW provider

 You can try import this xml file with 2 stockunits

first need to create 2 products with id 1000 and 1001 and setup product unit STK

After import I can see all in UI

Push save and close => open again

after this actions, product stock unit not exist in DB

Did you create the unit called "stk" - does that exist in the units in settings->ecommerce

Hi Nicolai

Yes of course 

Hi Dmitriy

Yep I can confirm, that without importing product numbers no issue with stock units

Thx 

Also I'm catching issue, when save imported stock units, they are duplicated in both UI and Database

If description or product number are NULL, then create duplicate in both UI and Database

if description and product number are empty, then duplicate only in UI

Clear cache doesn't help

Hi Andrejs,
yes, this should also be fixed. You can try to check if it works with this version (try to put it to 9.15 bin folder). 
BR, Dmitrij

Hi Dmitriy

my DW version 9.15.3

Duplications still persist with this Ecommerce version

Sorry, can not reproduce it again. Are you sure you have updated the Dynamicweb.Ecommerce.dll from the link above so it has 1.15.13 version?
If yes then what are your steps?

Yep

Have simillar issue, which I described before, but now

If description or product number are NULL, then create duplicate in UI only

if description and product number are empty, then duplicate only in UI

And that is strange, that I can catch this issue only on 1 local solution, on another I can't, both use same Application 9.15.3

Can you manually upload the Ecommerce dll from the link above to your second solution and check with it? This bug is in QA state so it wasn't yet released anywhere, so it is not availble in 9.15.3

My both local solutions run same Application(9.15.3) with diferent DB,

I update Ecommerce.dll from your link and strange thing is, that 1 local solution have issue with duplication and another doesn't have

Cache cleared and solution recycled several times, so cache probably not an issue

It is probably connected with the "PK" columns, can you try to select those in your Data integration job settings?

Then once you will have the previous rows in the db with the same "PK" columns combination it will only update existing and will not insert a new duplicate rows

Issue occur only in solution where OData integation and other integrations

I configured like you sugested, but that doesn't help

Maybe issue can be, that I'm using custom VariantOptionGroup?

in clean solution when I try to import with XML provider as source and destination DW provider no any issues

You are using different table, so yours is a mapping where the DynamicwebProvider is a source, while I showed the mapping where DW provider is destination.
So not sure this is connected to this issue....

On my previos post source Endpoint Provider and destination OData provider

With source XML and destination DW provider looks the same for now

With your sugestions still looks the same duplicate only in UI

But maybe that is my local solution 1 some issue, because I have here many integrations
With new ecommerce.dll version on clean solution 2 that work fine

But again very strange, that both solutions use same Application(9.15.3)

And on production 9.15.2 with StockUnitDescription and StockUnitProductNumber empty fields and default ecommerce.dll stock units work fine