Freight Adders and Developing a Means to Associate Vendors with Product in Measure Desktop (Various Scenarios: Product Category Limits)

My Company is evaluating solutions to ensure that estimators using RFMS Measure can easily determine which vendor is supplying each product so they can apply the correct freight adder accordingly. Currently, vendor information is not included in the data downloaded into Measure, making freight estimation more complex. We are exploring several potential workarounds and would greatly appreciate your guidance on feasibility, best practices, and any built-in RFMS features that might assist in achieving this goal.
________________________________________
1. Product Categories in RFMS & Measure
To explore vendor identification using Product Categories, we need to understand:
•    What is the maximum number of Product Categories that RFMS Core and Measure can support?
•    Are there any limitations regarding active vs. inactive Product Categories?
•    Can Product Categories be tiered or structured to organize materials by vendor without disrupting existing category assignments?
•    Can Product Categories in RFMS automatically update based on vendor assignment after a B2B import?
•    Can Measure display Product Categories in a way that allows estimators to easily filter materials by vendor?