Add leading zeros to the beginning of SKUs through a CSV file.
- Retail POS for Mac or PC
- Export your product list to a CSV file
Create an extra column next to the SKU column
Enter the following formula: ="prefix"&C2
Populate the new column with this formula
Delete the original SKU column
- Change the heading of the newly created column to sku
The "prefix" is any text you would like to add in front of the cell contents. C2 is the original cell.