Posted on 01/10/2021 00:52:12
Hi Nicolai,
That log entry looks good. What about in EcomOrderDebuggingInfo? Would it make sense to have it in EcomOrderDebuggingInfo too? The problem I ran into is that an order was deleted and it was logged in EcomOrderDebuggingInfo but I didn't have a way to figure out which AutoId or OrderId was used for that deleted order. If there was a link from the UserId (or SecondaryUserId), then I could find all carts from a particular user on that day. It's ok if it's in the body of the message. It could have a single entry added to EcomOrderDebuggingInfo when the order is created. (or maybe you meant EcomOrderDebuggingInfo and I misunderstood)
The general log would be helpful also, I believe.
Regarding deleting orders, that sounds like a great idea to just soft delete them. It would protect us from situations like this, to be able to dig up those orders again. I can't envision that it would clutter up the EcomOrders table since the percentage of deleted orders is a fraction of the regular orders. It would happen with problem situations like this, or if someone creates a cart and empties the lines, causing the header to be deleted. I'm sure there are a few other situations. In all cases, having access to the original order sounds great.
Thanks!
Scott