How to Format an Aftermarket sku

If you have a csv file from the distributors you can easily get those SKUs into the correct format for the E-Commerce Configuration with a little magic from excel. For example, we will look to format a sku from Western Powersports.

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

Open

This becomes

Open