How to add zeros to the start of your SKUs


Latest update: - Andrew Starr

Objective

Add leading zeros to the beginning of SKUs through a CSV file. 

Setup

  • Vend for Mac or PC
  • OpenOffice 

Steps

  1. Export your product list to a CSV file
  2. Create an extra column next to the SKU column

  3. Enter the following formula: =concatenate("prefix";C2)

  4. Populate the new column with this formula

  5. Delete the original SKU column

  6. 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.

Additional Information

How to format CSV files in OpenOffice