Developing a Means to Associate Vendors with Product in Measure Desktop :Vendor Identification & Freight Quoting in RFMS & Measure

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.

2. Vendor Identification Workarounds in Measure
Since vendor information is not directly imported into Measure, we are considering different solutions. Could you provide insight into the feasibility of the following?
•    Auto-Appending Vendor Names to Product Descriptions or SKUs:
o    Can RFMS be configured to automatically add vendor names to product descriptions or SKUs after each B2B download?
o    If not natively supported, could this be done via a batch script or SQL process?
•    Custom Field in Measure for Vendor Assignment:
o    Is there a way to create and populate a custom field in Measure to store vendor names?
o    Can this field be automatically updated when importing products from RFMS Core?
•    Using Product Categories to Differentiate Vendors (if feasible from Section 1 above):
o    Can RFMS Core Product Categories be structured in a way that groups products by vendor?
o    If so, can this automatically apply without manual reassignment after every B2B update?
•    Vendor-Specific Product Code Prefixes or Suffixes:
o    Could we implement a standardized naming convention for SKUs that includes a vendor identifier?
o    Would this approach interfere with B2B imports or RFMS ordering processes?
________________________________________
3. Measure’s Quoting Function & Vendor Identification
We recognize that Measure’s Quoting Function operates within Measure itself and does not require export to RFMS Core to generate quotes or print Purchase Orders. This capability presents a potential solution to our vendor identification challenge, provided that Measure can be configured to receive and display vendor data.
•    Since Measure’s Purchase Order print function could facilitate this workflow, is there a way to provide the necessary vendor data via: 
o    A batch file that populates vendor data within Measure?
o    A custom field that would store vendor details in Measure?
o    A custom import process that includes vendor assignments?
o    Any other method that would allow Measure to access vendor information automatically?
If any of these options are feasible, we would appreciate guidance on how they could be implemented.