01 Import Data Guidelines
The .csv file type can be generated and modified using Microsoft Excel, Open Office Calc, or Google Spreadsheets.

When preparing your .csv file, take note of the following:
          - BARCODE HAS NO SPACES
          - File can be opened/read by Notepad
          - Please make sure that the AMOUNT of the SELLING PRICE/ NUMBER has NO COMMA
          - Remove SINGLE and DOUBLE QUOTE. This may broke the Inventory Item Name and search display and other features

Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV?

          Option 1 You must create an Excel workbook and formatting all of the cells as TEXT, and then pasting in the data.
          Option 2 Right click, and click "Format cells..." and choose NUMBER you can stop excel from changing your data to scientific notation then set to NO DECIMALS.
          Option 3 You can copy all correctly formatted numbers into Notepad. Then just create a new column formatted as TEXT, and copy the Notepad representation into the new column.