Formatting CSV file

In case you are using different regional settings then expected, you may encounter issues with CSV import.

In order to properly format CSV file, especially numbers (decimal places), here is the step-by-step guide how to do it using Google Sheets.

Local settings

If you are using regional settings that uses different formatting options then expected (e.g. comma as a decimal separator), and your CSV file is created using semicolon as a column separator, you will need to convert those values to match the ones Aronium expects.

Local example

The example of a price in your local CSV file might be something like the following
...1;20;123.456,78;0;1...
where the text in red represents your price.

Format CSV file

In order to upload and convert file to Aronium expected format, do the following:

1. Go to http://sheets.google.com and create new Google sheets document
   
   
2. Before you start working, make sure your spreadsheet is in your locale, e.g. Argentina.
   Go to "File → Spreadsheet settings" and change locale to your language (selected locale formatting must match your local CSV file)
   
   
   
3. Next, click on "File → Import" and upload your local CSV file. Select "Custom" for column separator and enter your separator character (e.g semicolon or any other symbol used in your local CSV file) 
   
   
   
4. Click on "Import" button. Once import is completed, you should see the numbers formatted like the ones in the image below. This is your local format, we need to change it to match the one Aronium import expects.
   
   
   
5. Next, go back to "File → Spreadsheet settings" and change Locale back to "United States" and click "Save settings"
   
   
   
6. Once locale is changed to "United States", in case has not changed yet, select "Price" column by clicking on column header and change its format, like in the next step.
   
   
   
7. With "Price" column selected, go to "Format → Number → Automatic" (if "Automatic" is already checked, click on that option again to confirm selection and format)
   
   
   
8. After formatting is applied to a selected column, your prices should be formatted the way Aronium expects them to be, like in the image below.
   
   

   Important

   Do the same for other number columns (like Cost and Markup).
9. Click on "File → Download as → Comma-separated values (.csv, current sheet)" and save the file to your computer.
   

Once your file is downloaded and saved, follow the instructions on Import products using CSV article to complete your products import.