What are Item variables and what can you use them for?


Supplier commission statements can contain many column headers with various information. Commission information such as: MRC, Commission, Account number, Product and Customer name. Some suppliers provide additional information that can be helpful to report on such as: Term, Billing month, Install date, address, Circuit ID etc.. The standard upload matrix contains the most common column headers found on supplier commission statements. If there is any other column you would like to bring in you can do so by adding/creating the (item) variable to the upload matrix.


What are Product variables and what can you use them for?


There are cases where the supplier provides you with a product column with generic product names (eg: MRC, LD, Usage) as well as a column with either a code or some other variable that breaks down the product. If you have a commission structure that takes these codes or other variables in consideration you can use this value by bringing it in as a product variable / by creating a product variable. RPM will now use both the product and the variable and creates a new product with the data.


Example:

Product: MRC

Variable: Internet

Variable: Internet - 100MB


After importing the data RPM will create 2 products: ‘MRC Internet’ and MRC Internet - 100MB’ Allowing you to not only audit each product accordingly if needed (if you receive a different % for them) but also pay out a different rate for the product if desired.



See also: