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 being 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 SKU’s 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 data, like products, customers & suppliers. It may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. Also, manually ...
    • 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 latter because it will ...
    • Importing Customers via Excel File

      Importing your Customers via Excel file 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 ...
    • 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 ...
    • Importing Unit of Measure via Excel Files

      Hike supports the feature, unit of measure, to enable selling and purchasing products in bulk. For the details of the feature, please refer to Unit of Measure: Sell or Purchase Products in Bulk. Apart from creating them manually one by one, you can ...