So with the help of
@chris37 I have finally found a solution to my issue!
Turns out it was a database issue in my case and the fix was to completely re-install Wordpress and have a new database.
After re-installing and creating a new database, everything started to work again i.e. prices were showing correctly.
