Editing SKU Numbers When They Appear as Scientific Notations in Excel

Editing SKU Numbers When They Appear as Scientific Notations in Excel

A common issue that occurs when importing SKU numbers in Microsoft Excel, is that they can appear in their scientific, ‘truncated’, notation when they are either long digit numbers or with ‘0’.

1._Excel_SKU.png

Important: If this occurs on your SKU file when you go to import the file back into Hike, the system may see this as a new SKU product, and as such duplicate the item.

This is a specific problem to Microsoft Excel, so using another application that reads CSV files may be one solution.

However, you can also easily fix the problem on Excel itself.

To do this, simply select the scientific notation of the first SKU to appear as such.

Note: If you have multiple SKUs with scientific notations, then you will need to select all such SKUs before formatting. You will not be able to select and drag down.

2._SKU.png

Then, select DATA from your Excel toolbar, and navigate to the TEXT TO COLUMNS icon.

3._Text_To_Columns.png

You will then be taken to the Convert Text to Columns Wizard.

Where it asks you to Choose the field that best describes your data, click on Fixed Width. Click Next to continue.

4._Fixed_Width.png

The next screen will ask you to set column breaks, but this is a step you can ignore. Click Next to continue.

5._Break.png

Finally, you will be asked to select the Column Data Format. Here, you will need to select TEXT, and nothing else.

Once that is done, select FINISH to complete the process.

6._Finish.png

Once that is completed, your SKU should now read as its full numerical number.

7._Numerical.png

If you have multiple, SKUs with the scientific notation, ensure that you have all selected before you start the Wizard.


    • Related Articles

    • Importing Products via Excel Files

      When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. This ...
    • Importing Composite Products via Excel File

      Hike allows for creating composite products. To create them in bulk efficiently, similar to creating products, you can import the composite products. You can either use your own template or the Hike one. We would recommend the later because it will ...
    • Troubleshooting Excel Errors

      When importing an Excel file into Hike, a missing field or incorrect data will cause errors and for your products to be not being synced. Fortunately, Hike makes it easy to rectify any such errors for a quick fix. On this page we’ll go through how ...
    • Troubleshooting Excel Errors for products

      When importing an Excel file into Hike, a missing field or incorrect data will cause errors and for your products to be not being synced. Fortunately, Hike makes it easy to rectify any such errors for a quick fix. On this page we’ll go through how ...
    • Importing Suppliers via Excel Files

      When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. This ...