Export Store Data

Export tools in ShopBuilder allow you to download your products in a CSV file. You may want to use this 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. ShopBuilder allows export of orders, products and customers.

Export CSV file specification can be found here. For examples of the export tool usage and for description of the other ShopBuilder’s Import/Export features, see Store Import and Export Basics.

Export is only available for the Professional ShopBuilder and higher.

Export Products

To export products:

  1. In the left panel, click eCommerce, and then click Manage Store.
  2. Click Catalog, and then click Products.
  3. If you need to export all your products, at the bottom of the list, click Export All. To export a part of your inventory matching some criteria, use the filters in the column headers or use the product search field, and then click Export all found.
  4. In the export settings dialog, select the delimiter and the columns you want in the file and click Download CSV file.
  5. Save the CSV file to your computer.

The Product ID is a unique global identifier of a product, internal to ShopBuilder. For example, ShopBuilder uses it in product URLs. You cannot import a product ID or change it to a value you like.

Export Orders

To export orders:

  1. In the left panel, click eCommerce, and then click Manage Store.
  2. Click My Sales, and then click Orders.
  3. At the bottom of the list, click Export All or select the orders you want to export and click Export selected.
  4. In the export settings dialog, select the delimiter and the columns you want in the file and click Download CSV file.
  5. Save the CSV file to your computer.

Export Customers

To export a list of customers:

  1. In the left panel, click eCommerce, and then click Manage Store.
  2. Click My Sales, and then click Customers.
  3. If you need to export all your customers, at the bottom of the list, click Export All. To export a part of the list matching some criteria, use the filters in the column headers and then click Export all found. Alternatively, select the customers you want to export and click Export selected.
  4. In the export settings dialog, select delimiter and the columns you want to get in a file and click Download CSV file.
  5. Save the CSV file to your computer.
Updated on 20 November 2020

Was this article helpful?

Related Articles