Using Excel to edit CSV files - truncated numbers/scientific notation

If your organisation uses a SKU format which is either long digit numbers, or numbers with a leading 0, such as in the image below

Fixed.png

When you export your Vend products to a CSV, and open this directly into Microsoft Excel, it treats the SKU column as a number field and tries to remove the leading zero and 'truncate' the SKU, so that it looks like the image below.

Bad.png

If this happens, when you then save the re-import the file, Vend may treat this as a new SKU code, and add a duplicate or incorrect product.

The easiest way to work with such SKU numbers is to edit CSV files Open Office  (a free alternative to MS Office), which does not truncate number fields.

But it is possible to work with Excel, without truncating SKU codes, following the steps below.

1) Export your products to a CSV file  and save it to your computer

2) Open a new Microsoft Excel spreadsheet

3) Select Data > From Text and navigate to the saved product export CSV file

From_text.png

4) Microsoft will prompt you to select what type of data file it is. At Step 1 , select Delimited, then click Next

Delimi.png

5) At Step 2 select Comma and then click Next

Comma.png

6) At Step 3 navigate to and highlight the SKU column, change the Column data format  to Text and then click Finish (You may wish to apply this to the 'handle' column if you use the same naming convention)

SKU.png

7) Check the SKU code in Excel, it should now be in the correct format

Fixed.png

 

Did this answer your question?
Have more questions? Contact us so that we can help you out.