Updated by Kyle Tymoszewicz
Both files require a seller to list their Product SKUs. However, some spreadsheet editors such as Microsoft Excel can convert a seller's SKUs to scientific notation.
Normal SKU: 4172043946189
Scientific Notation: 4.17+E12
The below steps show how to resolve this issue.
Managing Column Width
The first step is to ensure that your column for SKU is wide enough to display the full width of values. You can drag the column width to fix this.
Changing the Data
Once the column width is fixed you can change the data type:
- Select the column for SKU
- Click the dropdown for the data type
- Change the data type to Text
To confirm success, you can open your CSV in a text editor like Notepad and search for "e+" and "E+".
If no values are returned then your SKUs have not been saved in scientific notation.
If issues persist, please contact support.