Forum management
- Threads started by me
- Threads I participate in

Developer forum

Intrgration and multiple shops - products with same IDs

René Poulsen

Posted on 03/06/2016 13:41:46

Hi,

I'm working on a solution where we've got multiple shops with one integration job setup for each shop.

Is it possible to have a product with ID "ABC" in every shop? Or does the ID of the product have to be unique accross shops?

Replies

Nicolai Høeg Pedersen

Posted on 03/06/2016 13:54:22

This post has been marked as an answer

Hi René

The combined primary key for products in the database are ID, Variant and Language. So if you have the same ID twice, DW cannot tell the difference.

Some partners do like this prodid@shopid as the product id.

BR Nicolai

Votes for this answer: 1

René Poulsen

Posted on 03/06/2016 13:57:32

Ok.

Does the integration framework send the product id or the product number when requesting (live) from the NAV?

If it uses the ID, the above would require a change in the liveintregration so it sends the product number instead of the id. (shops can have products with same product number, right?)

René Poulsen

Posted on 03/06/2016 14:57:33

Oh, i missed something in what you wrote. In this case the language would be different, so I guess I won't run into any trouble :-)

Jonas Krarup Dam

Posted on 09/06/2016 08:59:12

Hey Rene,

I don't know if it's still relevant, but to answer your question: by default it sends the productID, but it's a few very small changes to the live integration code to make it send the productNumber instead.

Regards, Jonas

You must be logged in to post in the forum