Refinement of the functionality for importing prices for MODX

We need a developer who will deal with the functionality for importing prices. Website on MODX mzspb.ru/

Task: update the prices on the site according to the new prices of the client. The algorithm is described in detail in the appendix.
I also attach two prices that the client sent us - for them and you need to update the prices.

The client sent 2 files with a price list of 500 lines each, for which it is necessary to update the prices on the site.
The problem is that we cannot automatically upload new prices to the site in such quantities due to the nature of the upload. Before that, they sent prices of 5-20 pieces or said which services the prices had changed, and we manually updated in our price list taking into account all the services to which the price is tied. Now they have changed ALL the prices and we cant do that.

How we work by uploading prices now:

The same prices are tied to different services (by ID), and we are forced to duplicate each price in the price list for downloading as many times as in how many services it is indicated. It looks like this: skr.sh/sFjU78ITLNn

In addition to binding prices to different services, we also have different formats of prices (which they send, and which should be for uploading to the site). The client always sends the usual unloading from 1C, where there is no service ID: skr.sh/sFjocOUyHid. And even if we did not think about binding to all services, we would still have to put the ID of the main services in their price list and remove unnecessary columns.

It is necessary to somehow optimize the unloading of prices so that it is possible to pour new prices in bulk without losing reference to all our services.

I attach the file of unloading the price from the site - the form in which the file should be uploaded to the site - called price.xls.
The other two files are price lists sent from the client.