How do i perform feature selection for clustering?
The data described in tables above is for purchases. You, however, want to segment users. Therefore, the first thing is to derive a dataset of user data.
As a first approach, I suggest that you create a table with one row per customer ID, where you have information about how many products the customer has purchased of each of the possible hierarchy values (e.g. customer ID: 312425, tableware products purchased: 5, cookware products purchased: 10, bath scale-manual products purchased: 0), and then do clustering on that.