Developer forum

Forum » Integration » Imported NAV Item Attributes not updated

Imported NAV Item Attributes not updated

E-mail notifications
Cristina Santos
Reply
Posted on 29/03/2022 07:49:25

Hi everybody,

We have a website integrated with BC on premise.

Through a task we update the products. The problem is that the Product Categories Fields were created the first time grouped by "Imported NAV Item Attributes", but then they are not updated, only the product fields (name, description,...) are updated.

The Request XMK in Schedule Task for importing is: 

<GetEcomData><tables><Products type="all" setLanguage="LANG1" languages="LANG1" importProductProperties="true"/></tables></GetEcomData>

 

Details of the Import Product Data_

 

 

What i forgot o missconfiguring? What could be the reason for not beeing updated only the Imported NAV Item attributes?

Thank you very much!


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 29/03/2022 09:21:12
Reply

Hi Cristina,
it is not clear what is your problem. Is sound like you have a problems with category field values.
Could you check if the data is imported to the EcomProductCategoryFieldValue database table?
Maybe it is a caching problem so the data is present in the database but is not shown on the UI?
BR, Dmitrij

 
Cristina Santos
Posted on 29/03/2022 09:36:11
Reply

Thank you Dimitri!

The data is imported to the EcomProductCategoryFieldValue database table.

I can see the data in the backend and in the frontend.

The problem is that if one of those values ​​is changed in BC, they are not updated in DW. The update task runs every half hour with no errors, but only updates fields like product name. But it doesn't update the EcomProductCategoryFieldValuefields.

For example, in a product if one of those fields changes (see image) in a product, in DynamicWeb it is not updated and I still see the same value...

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 29/03/2022 09:51:04
Reply

Can you try with "Remove missing rows after import" OFF?
Also try with "Remove missing rows after import in the Destination tables only" ON?

 
Cristina Santos
Posted on 29/03/2022 11:53:15
Reply
This post has been marked as an answer

Mystery solved!
In the Import Prduct Data job, in the last tables, the mapping had disappeared...

I don't know why the configuration we had in DATA COLUMN MAPPING has been deleted.

It did not work because the Source column and the Destination Column had "None" selected

Marking the mapping in each field again, it has worked again.

How is it possible that it has been deleted? Any possible reason?

Thanks for the help!

Votes for this answer: 1

 

You must be logged in to post in the forum