Have you ever wanted to change multiple items at once but the administration took too much work? Or did you need data for use in another application? By exporting data in CSV format, you have the option to arrange this. We are probably all very accustomed to using spreadsheets and editing them, so we will present a way in which you can export items from your store and easily edit them in a spreadsheet. Of course, once you have arranged everything, you can save the organized spreadsheet with data in a CSV file and import it back into the store. The exported file can be used for editing items, data analysis, importing data into accounting software, etc.
Exporting items to CSV from the Magento online store
The online store on the Magento platform allows you to export your data from the administration into a CSV file. The term CSV is usually used for text files in which data is entered so that individual fields are separated by a comma, semicolon, quotation mark, or similar symbol. A CSV file is created when exporting from a program that processes data with the purpose of transferring data elsewhere. To edit the file, you can use programs such as Microsoft Excel, OpenOffice Calc, etc.
Procedure for exporting products from Magento
To export items from the online store, follow the procedure below:
- In the online store administration, go to System > Export / Import > Export.
- From the first selection field "Entity Type", select the first option "Products". The system will create and display a list of all attributes associated with your items.
- By default, all attributes of your items will be exported in the CSV file. In the selection list, you have the option to select attributes that you want to exclude from the export to the CSV file.
- By default, all items and item options will be exported in CSV. Use the filtering option to limit the export.
- Click Continue and the export of your selected items to the CSV file will begin.
- You can now open your exported file in your favorite data/table processing program. You can then edit the data in the program as needed. When saving the file, you just need to make sure that you save the data in the correct format. Encoding or symbol selection must be UTF-8 and field delimitation should be the same as in the open file.
The export/import system allows you to prepare or edit the sales assortment of items in an Excel file on your computer and update the status in the online store when uploading this file via import.
