I want to export orders which are not exported to ERP system for some reason, lets say the connection to the ERP was down. So the order is created in DW but not exported.
I have created an order export batch with order provider as a source and XML provider as destination provider. Order export for not yet Exported orders is working fine. But during that I saw really different behaviour, maybe it is a bug or maybe i need to adjust some configurations,
We have 2 shops(SHOP1 and SHOP2), in the batch on ecomorders table i have the following conditions,
- OrderShopId = SHOP1
- OrderCompleted = 1
and on Ecomorderlines i have no condition.
Now I have 2 orders which are not exported to ERP yet, one for SHOP1 and other one for SHOP2. According to my conditions, i should only get data related to SHOP1. For EcomOrders i am only getting orders related to SHOP1 which is good but for EcomOrderLines table i am also getting orderlines for order related to SHOP2 Which is wrong.
I also noticed one thing that i can not set Primery keys on both EcomOrders and EcomOrderLines table. i am not sure it its related but wanted to mention.
I am using DW 9.5.7.
All suggestions are welcome.