Export tools allow downloading your products in the form of CSV file
You may want to use this if you need to get your store data in a table format for importing to 3rd party systems or for editing your store products in mass in a spreadsheet editor etc. Currently, it allows export of orders, products, and customers.
Export CSV file specification can be found here. For examples of the export tool usage and for the description of the other Import/Export features, please refer to this article: Import-Export.
How to export products
- Open the products listing page in your control panel: Catalog → Products
- If you need to export all your products, click the 'Export All' button at the bottom of the list. It is also possible to export just a part of your inventory matching some criteria - use the filters in the column headers or use the product search field on the top right and then click "Export all found".
- In the export settings dialog, select delimiter and the columns you want to get in a file and press 'Download CSV file'
- Save the CSV file on our computer
How to export orders
- Open the sales section in your control panel: Sales → Orders
- Click the 'Export All' button at the bottom of the list or tick the orders you want to export and click 'Export selected'
- In the export settings dialog, select delimiter and the columns you want to get in a file and press 'Download CSV file'
- Save the CSV file on our computer
How to export customers
- Open the 'Customers' section in your control panel
- If you need to export all your customers, click the 'Export All' button at the bottom of the list. If you want to export just a part of the list matching some criteria - use the filters in the column headers and then click "Export all found". It is also possible to tick the customers you want to export and click 'Export selected'.
- In the export settings dialog, select delimiter and the columns you want to get in a file and press 'Download CSV file'
- Save the CSV file on our computer
FAQ
When I export products I see the Product ID column. What is this?
Product ID is a unique global identifier of a product, internal to Online store. For example, Online store uses it in product URLs. You cannot import a product ID or change it to a value you like. However, you can export it to use, for example, in your 3rd party mods.