What software can restore the rules of product sales analytics?

Question

Database

Let's imagine that you have a history of drug sales for a week in 7 pharmacies.
There is also software that, based on your sales, generates recommendations for prices for the next day, while all prices are the same in the entire pharmacy network. But the pharmacies themselves can be located in different cities, and for analytics, you can only operate on sales history.
As a result, you have 2 files: in the first one, the sales history (list of goods + price + number of sales + balance at the end of the day), in the second - recommended prices (list of goods + new prices).
The question is, how is it possible to do reverse modeling, or what software is there that can model the rules for analytics based on these 2 files?