Posted on 24/08/2016 14:27:32
Hi Nikolai,
Thanx for your response.
The system we are currently building will work with an ERP the other way around. The ERP will be updated with products (and its properties) form DW.
Nevertheless, I just needed confirmamtion that the fature does not exist, it is fine, customer will be assinging a shop to each product manually for now :).
Do you think it is a good idea to create a trigger on a database level and have it assign appropriate shop to each insert and update of the row in EcomProducts table?
This will be simple, as there is only one shop, but since the DW is the main point of product entries, one field down to select is performance improvement for an eCommerce operator.