Exporting store data

You can export products, orders, customers, and gift cards from your Ecwid store. The data will be downloaded in the form of CSV files. You may want to use the export tool if you want to update existing products via import, get your store data in a table format for importing to third-party systems, for analytical purposes, etc.

Exporting products

You can export data with the details of every product in your Ecwid store. This information includes product name, SKU, description, price, quantity, and many other product attributes. The full list of attributes (columns) that are available for download appears in the dialog during export.

To export product data:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Click the Export All button at the bottom of the product list if you need to export all your products:

    Exporting_store_data__9_.png

  3. (optional) Click Filter in the left upper corner to use filters, then tick the products and click Export Selected if you want to export only a part of your inventory (e.g., based on some criteria):

    Exporting_store_data__8_.png

    You can also use the search field at the top of the product list, tick the products you want to export, and click Export All Found.
  4. In the export settings dialog, select the delimiter for your file and the columns that you want to export (by clicking them):

    Exporting_store_data__2_.png

  5. Click Download CSV file.

A CSV file with the data on your products will be downloaded to your computer. You can edit the file and import it back into your current store to update existing products, import the file into another Ecwid store (if you have more than one store) to create a catalog there, or share it with your suppliers.

Please note that if you're offering your store in multiple languages, product data is exported in your main store language.

Exporting orders

You can export data with the details of every order in your store. This data includes various information on the order itself (including its number, total, shipping and payment method chosen, payment status, tips added, and more) and on the item ordered (including item name, weight, and SKU). The full list of attributes (columns) that are available for download appears in the dialog during export.

To export data on orders:

  1. From your Ecwid admin, go to My Sales → Orders.
  2. Scroll down to the end of the order list.
  3. Click the Export All button at the bottom of the list, or tick the orders that you want to export and click Export selected:

    Exporting_store_data__1_.png

    You can also click Filter in the left upper corner to use filters and make the search faster, or use the search field at the top of the product list.
  4. In the export settings dialog, select the delimiter for your file and the columns that you want to export (by clicking them):

    Exporting_store_data__3_.png

  5. Click Download CSV file.

A CSV file with the data on your orders will be downloaded to your computer. You can filter this data by various order details to manage your sales more efficiently, use it to create various sales reports, or just keep the files for your own records.

Learn about other approaches to exporting your orders and generating store sales reports →

Exporting customers

You can export data with the details of every customer in your store. This data includes customer name and email, their registration date and time, customer group (if any), whether the customer is tax-exempt, and whether they gave consent to email marketing.

To export data on customers:

  1. From your Ecwid admin, go to My Sales → Customers.
  2. Click the Export All button at the bottom of the customer list if you need to export all your customers:

    Exporting_store_data__7_.png

  3. (optional) If you want to export only a part of the customer list (e.g., based on some criteria), you can 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.
  4. In the export settings dialog, select the delimiter for your file and the columns that you want to export (by clicking them):

    Exporting_store_data__5_.png

  5. Click Download CSV file.

A CSV file with the data on your customers will be downloaded to your computer. You can use this data for analytical purposes, create promo campaigns using the emails of customers who gave their consent for email marketing, or just keep the files for your own records.

Learn how to start email marketing →

You can also export the list of customers who gave consent to email marketing on the Marketing → Newsletters page in your Ecwid admin. Those who unticked the “Keep me up to date on news and exclusive offers” box are automatically excluded from the contacts list exported in that section. 

Exporting gift cards

You can export data with the details of every gift card sold in your store. This data includes initial and current gift card balance, expiration date, the last four symbols of the gift card code, recipient name and email, gift card order date, and other attributes.

To export data on gift cards:

  1. From your Ecwid admin, go to Catalog → Gift Cards.
  2. Click View and manage all sold gift cards:

    Exporting_store_data__4_.png

  3. At the bottom of the page, click Export Data:

    Exporting_store_data__6_.png

A CSV file with the data on all the sold gift cards in your store will be downloaded to your computer. In the file, you can filter gift cards by date, amount, and other details to see the statistics for different time periods or just to keep the files for your own records.

Learn more about gift cards →

FAQ

What are the Product ID and Product URL columns that I see when I export products?

Product ID is a unique global identifier of a product, internal to Ecwid. For example, Ecwid uses it in a Product URL (which is the address of this product in your store). You cannot import product IDs and product URLs or change them to a value you like. However, you can export product IDs to use, for example, in your third-party mods for Ecwid.

How can I automate exporting my store data in a third-party application?

You can automate exporting and importing of your store data in third-party applications by means of Ecwid API.

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
97 out of 152 found this helpful
10
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline