Google Sheets stock update between Baselinker using ZAPIER

Good afternoon,

I would like to commission the integration of a warehouse located in Google Sheets with a platform (Baselinker) via the Zapier platform on which the Baselinker integration is located.

Operating principle:

Modification of a single cell in the Google Sheets spreadsheet (e.g. Field A2 right next to product X in Google Sheets based on an add new order event (1) or a make changes event in Baselinker (2).

(1) - Event when you add an order and add a product in the order

(2) - Event when someone enters an order to modify it, e.g. increase the number of products from 1 item to 2 items.

(3) - other required to maintain the logic of the operation

The goal is to have more control over the warehouse to take into account orders 'in progress'.

In the appendices, there is a preview of a modifiable cell called 'In progress (pcs)' in which we see the sum of the pieces of products in progress.