These text files can be difficult to read as just straight text. A CSV file is nothing more than a text file with its data values separated by commas (hence the name "comma separated values" or CSV).
Instead, this is due to the way Excel and other spreadsheet programs open a CSV file and display the data therein.īasically, spreadsheet programs are designed to be used for calculation purposes, so they tend to apply mathematical formats to numbers when the CSV file is opened directly into the program. To be clear, the reason these problems occur is not due to the way Shift4Shop creates your export data. Unfortunately, saving the file in your spreadsheet program and re-uploading the CSV data to your store will then permanently change the record(s) to those displayed values. When exporting CSV data from your store, you may sometimes notice that large numbers are converted into scientific or exponential numbers in the cells of your spreadhseet program.įor example, when exporting the customer records CSV file, and a customer's phone number is listed as 8008286650 upon opening up the file in Excel, you'll have the number shown as 8.01E+09 or something similar.Ī similar issue occurs when numerical data in your store contains zeroes at the start of the number, but upon opening the file in your spreadsheet program, the leading zeroes are removed.Īn example of this can be seen if your products have part or MFGID numbers like 000986543219 but upon opening the exported file in the spreadsheet program, the numbers are shown as 986543219.
0 kommentar(er)
