Developer forum

Forum » Integration » NAV integration to existing ecom

NAV integration to existing ecom

Kenneth Radoor
Reply

A customer have a running site with ecom and have created a lot of products in ecom, and enriched the products with a lot of data.

Now they want to connect there ecom to NAV, and get there product updated with core-data (price, stock, active, ect) from NAV.
And if there is new product in NAV, get them created in ecom.

In a standard setup the Dynamicweb provider is used for import, and then the productID is required. But as the products are already created, there is no link between the products in DW and NAV.

I we switch to the ecom provider then we can map the product on the productnumber and that would be fine, excisting product will be updated and new will be created.

But we cant update currencies with the ecom provider :(

Another concern is preformance, as DW states in the documentation the ecom provider uses quite a lot more memory and the import will be +5000 products in 4 languages.

So the question is what is the recommended way to go in this senario.

Go with the "standard" dynamicweb provider, where imported products will have the NAV productnumber as productID.
Then do a lot of cleaning up in the database, copying data from "old" product to the newly imported.

Or use the Ecom Proivder and then make a seperate import with DW provider to get the currencies.

NB. its a pretty simple import where we just get very basic data from NAV on the products.
Import the Units into the VariantOptions, and the Currencies, to get updated CurrencyRates.

/Kenneth 

 


Replies

 
Jonas Krarup Dam
Reply
This post has been marked as an answer

Hi Kenneth,

You should be able to use the "ProductNumber" as key when doing imports with the DynamicwebProvider. This requires setting the key explicitly on the column in the import:

If  the products in the dynamicweb database are fairly simple, without Product Category Field Values or any other related data that is connected via the productID, I would probably recommend that you set up an import using the DynamicwebProvider, and "clean" the database so that ProductIDs are 100% controlled by NAV - this could be done by doing a one-time import which matches ProductNumber, and updates the ProductIDs in Dynamicweb.

If you have lots of related data (related products, Category field values, etc), that would probably be too much work, and it might be better to stick to your suggest model with EcomProvider for products and a seperate DynamicwebProvider activity for Currencies.

Regarding performance - I don't think 20k product lines is enough to cause problems with the EcomProvider, but I would highly recommend doing a test with synthesized data that match your expected input to make sure. If you expect this number to increase 10x or more, you should probably go for the DynamicwebProvider from the start, even if it requires more work :-)

Hope this helps,

Regards, Jonas

 

Votes for this answer: 1

 

You must be logged in to post in the forum