I've done some testing and found that there are no columns in the product item export for obsolete or sellable (Unleashed).
These fields would be useful as we've had a recent issue with the customer needed to update products but over 80% of them were non Active or non sellable products. Having the obsolete flag show in the product data export will allow customers to filter these items out in Excel for a shorter list of valid products that need updating.
Thanks Alex, you summarised our problem very well.
Unleashed allows product codes to be changed - we discovered that doing so will result in the old product remaining in Prospect and a new product also been generated with the new product code.
The product export data is not particularly user friendly and the 'flags' which set 'obsolete' or 'non-sellable' are not visible on the spreadsheet, meaning I can't sort the spreadsheet and filter out irrelevant products (many of the products are components which we do not sell), b) manually delete products which are still showing in Prospect if the 'change product code' feature is used in Unleashed.