Exporting your products from Online Store

Export tools in Online Store allow downloading your store data in the form of CSV files. You may want to use this data if you need to get your store data in a table format for importing to third-party systems or for editing your store products in mass in a spreadsheet editor etc. Currently, the Online Store allows the export of orders, products, and customers. You can find the CSV table format details here.

How to export products

Here's how you can export your products into a CSV table:

1. Open the products listing page in your control panel: Catalog > Products.

2. If you need to export all your products, click the Export All button at the bottom of the product list. 

Screenshot_2019-07-03_at_13.06.47.png

3. You can 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 8 selected.

Screenshot_2019-07-03_at_13.09.06.png4. In the export settings dialog, select delimiter and the columns you want to get in a file and press Download CSV file.

Screenshot_2019-07-03_at_13.12.01.png5. Save the CSV file on your computer.

What is a delimiter?

Delimiters indicate where one product attribute ends and another one begins. Online Store supports three delimiters in CSV files: commas, semicolons, and tabulation. Choose one type of delimiter to use across all your store imports and exports.

How to export orders

Here's how you can export your customer order data to a CSV file:

1. Open My sales > Orders.

2. Click the Export All button in the bottom of the list or tick the orders you want to export and click Export X Selected.

3. In the export settings dialog, select delimiter and the columns you want to get in a file and press Download CSV file.

4. Save the CSV file on your computer.

How to export customers

Here's how you can export customers and their data as a CSV file.

1. Open My sales > Customers section in your control panel.

2. 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 X Selected.  

3. In the export settings dialog, select delimiter and the columns you want to get in a file and press Download CSV file.

4. Save the CSV file on your computer.

This feature is available on all Online Store plans.

Was this article helpful?
0 out of 0 found this helpful