Over reliance on SQL has lead to errors in results.

Currently when order updates are received the comments and tags, OrderSource, are overwritten. This means that there is a risk of comments and tags going missing if a subsequent update arrives with empty tags.



What happens if the comments and tags are legitimately removed?

If the page is refreshed the order is sent again to the remote portal

Needs some thought. What if there's an actual need to transfer it again?

For historic reasons all orders from the Amazon EDI server are treated as simply Trade. When transferring to the US Portal, if the name starts with Amazon then change this to Amazon Vendor

Have looked at this in the past and it becomes a chicken and egg situation where editing one then requires updating them all.

e.g. search for Amazon Vendor - USA with the show only Amazon box ticked yields no results

"The system is automatically failing orders that have had items refunded. We don't want it to do this unless the entire order has been refunded and cancelled.



I refunded 1 item on an order through Shopify the other week and the order failed on the UK Admin even though there were multiple other products on it meaning the rest of the order did not get shipped.



Order ref is 159987 for Tanya Schlepp"



Will need to attempt to compare the incoming order with that stored in the database.



* If any items remain in the order then do not auto fail it.



* Modify or create a message to indicate partial cancellation or refund

Currently on the main Orders admin tab the default search is to search on billing and delivery address. The default is to change to just delivery address, with the option to search the billing address as well.