NAV integration and related products

René Poulsen

Posted on 09/06/2016 10:04:31

Hi,

Let's say I have Product A with related products Product B and Product C. The products comes from NAV via the integration framework. Over time the related products might change, so the related products for Product A could be Product D and Product E.

It's easy getting the new related products for Product A, but is it possible to remove the old related products (Product B and Product C) as related products to Product A during the import or do I have to change the something in the Integration Framework?

Replies

Dmitriy Benyuk

Posted on 13/06/2016 13:18:36

This post has been marked as an answer

Hi Rene,
you can set the "Remove missing rows after import" option in the DataIntegration import job -> Edit Destination Settings (if you are using Ecom or Dynamicweb providers).
When this option is checked, rows that exist in the database, but are not in the data being added to the database, are removed. This affects tables affected by the activity.
Note that this will delete all data not present in the import
Regards, Dmitrij

Votes for this answer: 1

René Poulsen

Posted on 13/06/2016 13:22:52

Hi Demitrij,

This is not an option for me. I have two import jobs - one for each shop (we have a shop for each language - right now 2). The "Remove missing..." works across shops, so when I run import job for DK shop all the products in NO shop would be removed. Later when I run the NO import job all the products in DK shop would be removed.

Dmitriy Benyuk

Posted on 13/06/2016 13:34:08

This post has been marked as an answer

Hi Rene,
The "Remove missing" is taking the "Shop" setting drop-down value into account when deleting missing data from the following tables(where the Shop id column is present):
EcomProducts, EcomGroupProductRelation, EcomGroups, EcomShopGroupRelation, EcomDetails.
So if you have two DataIntegration jobs with different Shops settings then this will delete missing records from those tables only for the specified shop.
Regards, Dmitrij

Votes for this answer: 1

René Poulsen

Posted on 13/06/2016 13:38:31

Aaaahhhhh... That was what I was missing. I only have one setup called "ErpEcomImport" under "Data Integration". I use that one for both the DK and NO import job. I guess I'll just have to create two (almost) identical setups inder "Data Integration" - the only differnece beeing the SHOP chosen in the settings for the destination.

I'll try that out and it will probably work :-) Thank you very much.

René Poulsen

Posted on 14/06/2016 08:53:51

Is there anyway to set what should be deleted and what shouldn't be deleted? I only want to do this on group, product and related products - and not languages currencies etc.

Jonas Krarup Dam

Posted on 15/06/2016 14:00:53

Hi Rene,

It's either/or - if you want to only do clean up on certain tables, you will have to split your integration up into multiple activities.

Regards, Jonas

You must be logged in to post in the forum

Developer forum

NAV integration and related products

Replies