Hey @burnt wolf what you want i think is custom line item prices. Where the default bheaviour is for the line item unit price to be derived from the variant price, you can create a custom api route and workflow, to add an item to a cart, overriding the default behaviour with your own logic.
Here is an official guide showcasing how to do this in the context of real time Precious metal pricing API: https://docs.medusajs.com/resources/examples/guides/custom-item-price
In your particular case, it is a matter of deciding inside your workflow, how you are going to access these json files and match them with the corresponding variant, to override the unit_price