/
How to Format an Aftermarket sku
ARI Responsive Websites
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
This becomes
, multiple selections available,
Related content
Price Overrides by csv File
Price Overrides by csv File
More like this
Cost Overrides
Cost Overrides
More like this
Update Shelf Inventory by csv Import - Aftermarket
Update Shelf Inventory by csv Import - Aftermarket
More like this
How do I upload a custom price file for OEM parts?
How do I upload a custom price file for OEM parts?
More like this
Image Overrides
Image Overrides
More like this
Add Fitment by csv File Import
Add Fitment by csv File Import
More like this