updating csv file
running into an error when uploading csv product list after downloading and editing.
aronium is showing numerous barcosed as a scientific formula (1.86E+11) instead of 185782000000
This is fine as excel knows that actual number in the cell
unfortunately on product import ARONIUM is reading 185782000000 as 1.86E+11 which not only means the barcode is miss saved and will no longer scan but that it reads multiple different barcodes as the same number.. for example 185782000001 and 185782000000 both are now saved as 1.86E+11 or is skipped/merged as a double on import.
Both causes a massive database conflict and incorrect products/prices
-
Hi Robert,
Unfortunately, it is most likely not Aronium's fault, but the way how CSV is formatted during the export. You can double check this by simply opening your CSV in the notepad, you will see "1.86E+11" there, too. Aronium is reading whatever it is in the CSV file without applying any formatting.
If this is the case, you need to "tell" Excel to treat the columns as text, not as numbers, so the Excel doesn't convert them to these "scientific" numbers (e.g. 1.86E+11) during the export. If you have any trouble specifying columns' format in Excel, we suggest using Google Sheets, as it will not try to convert numbers to "scientific" format.
Hope this helps. If you still have trouble exporting CSV after reading this, please let us know.
Thanks, Aronium team.
Please sign in to leave a comment.
Comments
1 comment