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 an 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