For question 1, this is a great suggestion to add to the Ideas section--I find myself encountering the same issue sometimes, and it can get confusing! As a possible workaround--to have Product ID on every row, a copy of Product Name could be created (right click on it in the data box and select Duplicate), then place it to the left of Product ID on the rows/columns shelf, then right click again and un-check Show Header.
In terms of the second question, Robert Morton gives some insight at the bottom of this post:
Hope this helps!
and as a reply in the same thread, I offer a solution that uses a table calculation.
if you would like help setting this up for your situation, please provide a sample packaged workbook that represents your situation.