Prestashop Web Api Connector - C#

i am having a retail system based on ms sql, which is the primary database and keeping all articles. additionally there is now a webshop, based on prestashop 1.7.2.2 (latest available version) which is having just a part of the articles available (compared to the retail system). articles are having a reference number for the article itself, which is having then combinations for sizes, like 40, 41, 42, ... The idea is now, to have an update service on my windows server (which is also the host of the retail system and the ms sql server) * which is checking ALL products in the webshop to have a corresponding article in the local retail system - which is a requirement (as they are created manually, there is always the possibility for mistakes - and there should be no article in the webshop without having a corresponing referencenumber in the retail system) * then, the price should be updated (if necessary) * then, the product combinations should be created or updated (first time they have to be created, later on just updated * if there are then no more available combinations (stock of all is 0), there has to be the possibility to disable the product (has to be an option) * one thing, which is important, is to respect the "reserved" items: if someone is placing an item in the cart or did buy already an item (and the payment will be by bank transfer, which means it took take a few days to get the money), the available stock in the webshop will be reduced maybe to 0 and the retail system is having still 1 - if then an update is happening, the webshop would show up again 1 item, but, this item is already reserved for a customer. there should be also a few checks and information topics: * if there is a product sold out, without any more stock, there should be an information * if there is a product "reserved", there should be an information (as the product has to be reserved at least also in the retail shop) * plausibility checks are also needed to avoid having problems in the productive system, like * if the stock in the webshop has to be updated for more than 1 combination per product (should normally not happen, just when the product is new), then there may be a mistake somewhere, or * if the price is different, there is also a mistake (this should not happen normally, just if the product is new, what means, if the price is 0 before updating it is ok, but, if the price would be for example 100 euros and the update would be 120 euros, this should be blocked and there should be an information for me * if there is a product in the webshop which is having a reference number which does not correspondent to any reference number in the retail system, there has to be an information. the information should be available in the gui and also by email and should not be deleted when the next update is happening. Requirements are also, that c# is being used, a gui (wpf) and a windows service shoud be made, the connection with prestashop could be done by the api restful xml service (or direct connection to the (remote) database). The retail connection will be done seperately, as this connection could be simulated for this project by a simple list (as example)