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

="WP"&A4

75-55065X would become WP75-55065X

Here is another example of what it looks like in excel while performing the calculation

This becomes