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’.
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.
Then, select DATA from your Excel toolbar, and navigate to the TEXT TO COLUMNS icon.
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.
The next screen will ask you to set column breaks, but this is a step you can ignore. Click Next to continue.
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.
Once that is completed, your SKU should now read as its full numerical number.
If you have multiple, SKUs with the scientific notation, ensure that you have all selected before you start the Wizard.