redSHOP:Importing and Exporting CSV Files tutorial
In this tutorial we will teach you how: - Export data from redSHOP into a .csv format - Edit the unicode data file (.csv) with Excel, Open Office or Libre Office. - Send back the data to redSHOP without avoiding wrong characters issue.
Important note: If you have ever experienced problems in characters codification (è, ą, ś,ć,ż ) this is due to a wrong importing procedure. When importing .csv files the way to avoid issues is to use "UTF8 encoding" instead of open it directly the .csv file.
How to: Import a .csv file into EXCEL with with UTF8 Option (Step by step)
- Select “Data” tab
- Click “From Text” button
- Choose CSV file
- Click “Import” button
Check “Delimited” so you can choose separator you typed when file exported from redshop
Select “File origin”: Unicode (UTF-8) - encoding of the csv file
Choose the separator you typed when you exported file (it is comma in this case)
Click “OK” and we see the imported file
Finally you can edit, save and import it back to redSHOP.
How to: Import a .csv file into LIBRE OFFICE / OPEN OFFICE with with UTF8 Option (Step by step)
- Click on "File -> Open" and select the "product.csv files that you have exported from redSHOP - It will appear a new window, make sure that codification is set as "Unicode UTF8"
If you see at the bottom of the screen the preview looking wrong, that may be caused because the Separator options is not well setted.
Test the different separators until you get the right preview of data. In the next image, the right "separator" is "TAB":
Now you should be able to import all the data without issues. "Edit" it as you wish, "save" it as .csv and upload it back to redSHOP.