An average of 672 shoplifting offences a day went unsolved in the year to March 2024, according to analysis from the House of Commons Library.