How to Format the Distributor SKU on a .csv File
If you have a CSV file from the distributors you can easily get those SKUs into the PSS format with a little magic from excel. For example, we will look to format a SKU from Western.
Insert an empty column next to the SKU column provided by Western.
In the new column enter the formula ="WP"&Cell
75-55065X would become WP75-55065X
Here is another example of what it looks like in excel while performing the calculation