Ask HN: Tools for Optimizing Inventory Management

Hey HN - I'm a full-stack developer by trade. My friend runs a few local art stores in the state. He was asking me if there were any tools/techniques from the software world he could apply towards optimizing his inventory for each of his stores.

For instance, he would love if a tool could let him know if...

- Acrylic paint inventory should be sent from Store A to Store B where it is in more demand.

- Raising the price at Store A of paint brushes would increase profit percentage without diminishing volume sold.

- Doing a buy one get one free special for old products would be profitable in Store B.

Right now, he's only got intuition about which store should have which inventory at which price, but he'd like a tool that could help him optimize and validate these intuitions.

I guess I'm looking for a Google Analytics / Mixpanel style solution for the real world that could also assist with optimizing pricing and deals. Is there something on the market that handles this sort of problem? Or is this something that should be home-brewed?