This is what is going to stop truncations and loss of leading zeros. Next, right click on the SKU column and set to Text. This is because that is what a CSV file is, a spreadsheet displayed as comma separated values.ģ. Under Separator Options, it is really important that the file is set to Separated by and Comma and " under the Text delimiter section. Set the Character Set section to Unicode (UTF-8).Ģ.
#Openoffice base print to dymo how to
However, if you are using Excel, check out this article.īefore you can edit your CSV file in OpenOffice, you will get a pop-up window showing you options on how to format your CSV file.īelow is an outline of how to correctly format your CSV file.ġ.
We recommend that you use OpenOffice instead of Excel or another spreadsheet application when working with CSV files (especially with products or customers) because the formatting works better with Retail POS. This ensures your SKU numbers don’t become truncated and that your SKUs don’t lose any leading zeros they may contain. OpenOffice gives you the option to format CSV files before you open them allowing you to set the correct formatting before you even start working on your CSV file. OpenOffice is a spreadsheet application that can be downloaded for free. If you want to work with CSV, you can edit your CSV files using OpenOffice. See our article on exporting your product list to learn more. You can avoid SKU truncating by exporting products as an XLSX file. If this happens, you would have to start from scratch with a new CSV file.
Once your SKU numbers become truncated, there is no way to undo it. If your organization uses a SKU format which is either long digit numbers, or numbers with a leading 0, your SKUs could be truncated when you export your Retail POS products to a CSV.
0 kommentar(er)
