The shop import/export feature lets you edit your category and product details in a spreadsheet application and then import the data into the shop. You can access the import/export feature by clicking Import/export in the shop admin panel menu. You can then:
- manage images used when importing
- manage files used when importing
- import and export categories
- import and export products
- import and export stock
If you use Microsoft Excel…
CSV files are the standard format used to import and export data into and out of spreadsheet applications. Unfortunately Microsoft Excel only supports a limited set of characters within CSV files, and characters outside of this range will be lost. To prevent this happening, you need to save as Unicode text rather than CSV. To do this when saving from Excel, click on the Save as type… drop-down field and then select Unicode text (*.txt) as the file type.